Raw sources

Raw sources (bronze)

Rows from every feed, stored exactly as received. Normalisation happens in the silver layer, where each change is flagged.

ENREnrollment
43,101
raw rows
Usable
42,871
Flagged
84%
No member ID
2%
Linked
29,405
First seen
2026-01-01
Last seen
2026-10-18
CLMClaims
32,829
raw rows
Usable
32,674
Flagged
74%
No member ID
35%
Linked
30,209
First seen
2026-01-01
Last seen
2026-10-18
TPAThird-party administrator
14,474
raw rows
Usable
14,404
Flagged
77%
No member ID
85%
Linked
11,671
First seen
2026-01-01
Last seen
2026-10-18
PRVProvider network
9,596
raw rows
Usable
9,546
Flagged
80%
No member ID
50%
Linked
8,676
First seen
2026-01-01
Last seen
2026-10-18

Raw events

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1406992026-08-21T16:08:30ZNATALIE—MEDINA1963-09-06UHC-05268-08•••-••-3886+1 489 329 4533natalie.medina@proton.me6281 CAMELBACK RDHoustonTX77024GRP-3583OPTIONS-PPO
ENRENR-1159292026-09-25T06:10:16ZDANIEL—HANSEN12/22/42UHC-80355-44•••-••-1717(286) 811-8561·DANIEL.HANSEN@ICLOUD.COM5594 Willow CtTampaFL33655GRP-3600OPTIONS-PPO
ENRENR-1093512026-07-21T21:49:16ZBenjamin—Walsh1972-04-04N/A•••-••-78822207615819null9852 Ridge RdPhoenixAZ85033GRP-5461CHOICE-PLUS-PPO
ENRENR-1138232026-04-17T19:46:03ZJoshuaGPowell2004-11-10UHC4486916•••-••-6597·18142274678JOSHUA.POWELL@YAHOO.COM5876 Mountain View DrTampaFL33699GRP-3791MEDICARE-ADV-B
ENRENR-1334772026-05-29T02:04:52ZSHIRLEY··PRICE1995-09-17UHC-74361-22•••-••-2586511-585-3654shirley.price@outlook.com1106 Park PlGilbertAZ85257GRP-0572MEDICARE-ADV-B
ENRENR-1000752026-08-06T03:46:37ZCarlosLVazquez··Jun 14, 2002UHC3336789•••-••-8050(447) 795-0657carlos.vazquez81@aol.com5250 Central Ave·GlendaleAZ85368GRP-4583··CHOICE-PLUS-PPO
ENRENR-130182 2026-02-05T17:27:22ZTeresa—Chavez1980-12-08UHC9147266•••-••-50213717833852TERESA.CHAVEZ24@PROTON.ME2318 Harbor BlvdMesaAZ85214GRP-8053CORE-HMO
ENRENR-1015772026-08-01T16:29:35Z anaC·hughes24-10-1953UHC-80738-36•••-••-4314(803) 568-4704··ana.hughes@icloud.com····NULL—UNKNOWN·GRP-3186CORE-HMO
ENR ENR-1180102026-07-24T09:46:27ZBailey, StephenA—·2/22/1994UHC-72645-22•••-••-51209798374715stephen.bailey60@icloud.com5482 INDIAN SCHOOL ROAD··ScottsdaleAZ85256GRP-1938CHOICE-PLUS-PPO
ENRENR-1039892026-09-29T19:22:11ZValentinaS··Banks1954-05-17UHC9505493•••-••-653114526099548valentina.banks27@hotmail.com7203 Palm Dr··AtlantaGA30397GRP-3711··OPTIONS-PPO··
ENRENR-1346762026-06-04T05:38:41ZDORIS—RIVERA21-02-1969UHC-42495-13N/A(263) 524-6876DORIS.RIVERA@OUTLOOK.COM5068 Mesa DrSAN DIEGOCA92185GRP-2668MEDICARE-ADV-A
ENRENR-1016442026-06-07T18:46:11ZJudithGWang2007-11-09UHC-93998-66—4153175333judith.wang@gmail.com1337 Maple AveAtlantaGA30392GRP-3892OPTIONS-PPO
ENRENR-1036912026-03-27T06:40:29ZPena, KimberlyO—28-05-1982UHC-27784-32•••-••-57239612391659kimberly.pena@proton.me2968 Sage Ct··Las VegasNV89108GRP-4526MEDICARE-ADV-A
ENRENR-1017562026-04-21T19:38:12Zarjun—gardnerAug 28, 1987UHC-24635-15··•••-••-8494487-830-3467arjun.gardner@proton.me7270 BAYSHORE DRDENVERColoradoN/AGRP-0348SELECT-EPO
ENRENR-1079262026-09-23T09:01:55ZPriya—Harvey1989-08-15UHC4105047•••-••-0865598-261-1718PRIYA.HARVEY@YAHOO.COM3080 Apache Boulevard Apt 31DallasTXnullGRP-3151OPTIONS-PPO··
ENRENR-1037352026-06-10T02:20:30ZHANNAHLYOUNG1963-06-13UHC-10405-78-4882650160HANNAH.YOUNG2@ICLOUD.COM1395 PARK PLACEDenverCO80298GRP-4360SELECT-EPO
ENRENR-1341662026-01-29T19:55:43ZMorgan, AnthonyY—09/05/2001UHC-23469-62•••-••-9761266-270-0298anthony.morgan@outlook.com5791 Indian School RdSCOTTSDALEAZ85231GRP-1140MEDICARE-ADV-A
ENRENR-1251172026-04-18T08:45:02Znancy··O.·vargas5/21/1947UHC-55764-99•••-••-3288(943) 820-6881nancy.vargas15@proton.me2475 Church StCHANDLERAZ85251GRP-5460OPTIONS-PPO
ENRENR-1055532026-08-21T03:16:59ZDonnaB.Williams06/25/1984UHC-10270-99•••-••-5858425.231.4592DONNA.WILLIAMS39@AOL.COM5938 Ridge RoadGlendaleAZ85390GRP-2723MEDICARE-ADV-B
ENRENR-1000352026-02-05T09:18:42ZJeremy··I.Carlson··19390319UHC-49717-27•••-••-02067576890394jeremy.carlson36@icloud.com255 BROADWAYSCOTTSDALEAZ85248GRP-7006NAVIGATE-HMO
ENRENR-1059792026-04-20T10:57:49ZRickXLittle1942-10-15UHC-26075-48•••-••-5412746-343-3858NULL·2180 Baseline RdSAN ANTONIOTX78230GRP-6525CHOICE-PLUS-PPO
ENRENR-124267 2026-09-03T13:40:54ZPerezZRalph1971-05-24UHC-58602-73N/A··927-974-8279RALPH.PEREZ37@YAHOO.COM7671 APACHE BOULEVARDJacksonvilleFL32257GRP-9921MEDICARE-ADV-A
ENRENR-1084052026-03-10T03:40:30ZFrank Y—Simpson11-09-1946··UHC-30318-98·null437-901-1316frank.simpson67@aol.com1478 Grand AveHouston·TX77069·GRP-2153SELECT-EPO
ENRENR-1224072026-07-05T12:58:47ZJonathanJMcCoy02/18/2004UHC4482780-nulljonathan.mccoy@outlook.com4382 CHURCH STREETOrlando·FL32852GRP-0193MEDICARE-ADV-A
ENRENR-1232982026-03-26T04:24:31Z·Eugene—Graham2004-10-26UHC-44398-20•••-••-1531274.253.0457eugene.graham@icloud.com1088 MAPLE AVENUE Apt 7··FresnoCA93725GRP-9689MEDICARE-ADV-A
ENRENR-1387322026-10-09T14:20:41ZPalmer, Zachay··—1953-11-15UHC-76597-84··•••-••-5369+1 279 968 0762ZACHARY.PALMER1@OUTLOOK.COM8301 Apache BlvdLas VegasNV—GRP-1412CHOICE-PLUS-PPO
ENRENR-1188632026-08-23T11:40:54ZEvans, BobbyQ—1976-07-03UHC-75183-23•••-••-91823658364507bobby.evans@yahoo.com6622 Maple AvenueSacramentoCA95876GRP-2204CORE-HMO
ENRENR-1119232026-01-17T16:29:11ZCARLO.BARNES07-09-1949UHC-50191-73•••-••-4739(657) 295-7273carol.barnes@aol.com8051 HILLCREST ROADMiamiFL33177GRP-2138NAVIGATE-HMO
ENRENR-1221272026-06-05T16:40:01ZEric—Hernandez07-01-1959NULL•••-••-2214·(247) 498-7159N/A9634 Mountain View DrSan DiegoCA92171GRP-5887CORE-HMO··
ENRENR-1091812026-06-27T12:39:08ZJacqueline—Graham1945-12-23UHC-66972-89•••-••-6070+1 739 928 4388jacqueline.graham@outlook.com·4419 Cedar LnAtlanta··GA30363GRP-0664MEDICARE-ADV-A
ENRENR-1157162026-04-17T17:11:16ZKEITH····RMIREZJun 19, 1954UHC-39559-25•••-••-90044842642072keith.ramirez60@hotmail.com339 BroadwayTucsonAZ85705GRP-3066MEDICARE-ADV-B
ENRENR-1027482026-09-19T18:21:54ZJack—Arnold1950-10-23UHC-31146-13•••-••-47012934952283null6818 Spring StreetColumbusOH43276GRP-4148core-hmo
ENRENR-1058982026-08-30T16:45:03ZterryHdiaz1939-05-15UHC-77144-47•••-••-248612984482979terry.diaz34@proton.me4080 Palm DrivePlano·TX75019GRP-4461MEDICARE-ADV-B
ENRENR-1351042026-06-21T17:53:55ZRayBVargas·Mar 2, 1949UHC-85125-76•••-••-885716504315259null9088 RIVER ROADHoustonTX77017GRP-9609MEDICARE-ADV-B
ENRENR-1270152026-09-25T05:28:02ZSEAN—HOWELL03/16/1982UHC-57319-58•••-••-3701+1 216 355 1879····9674 Park PlTempeAZ85261GRP-9194··medicare-adv-b
ENRENR-1393222026-06-18T02:06:22ZbrandonV.·smith9/13/1954·uhc-16733-19•••-••-5039611-876-2320BRANDON.SMITH@OUTLOOK.COM8647 Park Pl··Glendaleaz85350-8181GRP-2118SELECT-EPO
ENRENR-1085412026-06-25T10:42:38ZJORDANLCOLE·19791101UHC-83214-78•••-••-6969+1 579 439 4335null4226 Spring StreetMinneapolisMN55459-1317GRP-6517OPTIONS-PPO
ENRENR-1109832026-08-17T19:25:05ZlarryRjones·6/4/1950UHC-94064-39•••-••-4245(231) 259-2006null··6613 Jefferson AvePlano·TX75089GRP-9933MEDICARE-ADV-B
ENRENR-1217872026-05-26T00:07:52ZGREGM·HAYES07/20/1975UHC-04760-22—5710718GREGORY.HAYES21@ICLOUD.COM1498 FOREST AVENUEMinneapolis··MN55452GRP-5983MEDICARE-ADV-B
ENRENR-1220492026-06-03T19:44:18ZKIETH—BURKE1951-08-19UHC-26388-23•••-••-2422725-580-6428·KEITH.BURKE65@ICLOUD.COM9829 DESERT SKY BOULEVARD·MiamiFL33192··GRP-7324NAVIGATE-HMO
ENR ENR-1213422026-04-26T13:48:58ZVictoria··EDixon1943-04-03UHC-43667-50—2493842228victoria.dixon29@hotmail.com1154 MAPLE AVENUE #117LOS ANGELESCA90028GRP-3090CORE-HMO
ENRENR-1038582026-07-24T14:31:26ZHannah—YoungFeb 22, 2001UHC-12727-47··•••-••-57933338285049UNKNOWN··3496 CEDAR LNMINNEAPOLISmn55481GRP-4426··CORE-HMO
ENRENR-1320132026-08-02T17:02:49ZABIGAIL—LUNA1940-11-08·UHC-74464-69•••-••-9590—abigail.luna@outlook.com4651 Hillcrest RoadJACKSONVILLEFL32238GRP-5936OPTIONS-PPO
ENRENR-1224772026-04-23T11:58:19ZFord, Jordan·A—1978-07-12UHC-27315-41•••-••-2960(978) 299-2078—1158 Oak StreetMINNEAPOLISMN55427GRP-2039MEDICARE-ADV-A
ENRENR-1329552026-05-24T20:48:21ZTeresa—King1990-05-17UHC-80583-96•••-••-4107··teresa.king@proton.me6395 Ocean AvenueEden PrairieMN55348GRP-5512NAVIGATE-HMO
ENRENR-1130532026-07-06T15:12:30ZAlan H—Nunez·2003-08-05UHC-53813-83•••-••-4498+1 943 330 5822ALAN.NUNEZ@GMAIL.COM6551 Maple AveTampaFL33644GRP-8882CHOICE-PLUS-PPO
ENRENR-1415902026-07-02T02:17:41ZJasonSBailey02/16/1938·UHC-32640-85•••-••-6898·19479647321jason.bailey98@gmail.com4995 Harbor BlvdMinneapolis·MN·55463GRP-3135CORE-HMO
ENRENR-1228192026-04-20T14:34:54ZDennisU.Carroll1943-02-20UHC-89739-33•••-••-5171(284) 717-7644DENNIS.CARROLL@PROTON.ME7211 BroadwayGLENDALEAZ85375GRP-6697··MEDICARE-ADV-B
ENRENR-1187962026-06-25T06:44:44ZmarcusJlewis1945-02-07uhc-54523-19•••-••-5010(754) 918-5266marcus.lewis27@aol.com4802 JEFFERSON AVETampaFL33648GRP-8436CORE-HMO
ENRENR-1129642026-07-14T13:31:53ZLucia—Foster1944-01-24UHC-36501-21··•••-••-5197nulllucia.foster@aol.com9070 Maple AvenueAtlantaGA30364GRP-9046OPTIONS-PPO
43,101 rows, page 43 of 863PreviousNext

Bronze layer rules

What is guaranteed for downstream layers

  • As received
    Values are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
  • No transformation
    Bronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
  • Line number preserved
    The line number records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    The load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:42:34.804Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty