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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1331142026-08-10T19:33:54ZCarl—Hunter1998-06-16UHC8871227•••-••-2000813-751-1527CARL.HUNTER51@GMAIL.COM734 Maple AveColumbusOH—GRP-2643SELECT-EPO
ENRENR-1070032026-08-19T23:27:06ZStevens, Bryen——25-08-1967UHC-54937-27•••-••-3854(642) 492-4703NULL7061 CHURCH STGilbertAZ85210GRP-9560MEDICARE-ADV-A
PRVPRV-216222026-04-27T14:44:22ZWelker, Alice———UHC-55066-76—+1 308 417 5809null3598 Willow CourtMinneapolisMN55437N/A—
ENRENR-1161642026-03-29T22:41:15Zaustin—nelson1976-04-26UHC-17625-45•••-••-32202050949austin.nelson@proton.me2549 Cedar LaneColumbusOH··43243GRP-5145CHOICE-PLUS-PPO
ENRENR-1143832026-06-04T02:11:38ZRICHARDK.FERGUSON·12/18/1949UHC-78818-78•••-••-7447568-867-9799N/A·4772 CENTRAL AVE·Tucson·AZ—GRP-7468SELECT-EPO
ENRENR-1270502026-08-13T09:21:30ZNatalieF.Moore5/27/1956UHC-21260-01—-natalie.moore@aol.com1111 Baseline RdColumbusOH43248GRP-1752MEDICARE-ADV-B
CLMCLM-4287092026-01-28T02:08:04ZHiroshi—Herrera1979-01-23—•••-••-52094822735360—4577 Union StreetPlanotx·75018——
CLMCLM-412817 2026-06-25T04:11:08ZRalph—Campbell1989-10-10UHC-69425-15-5816600304N/A4022 Main StAtlantaGA30392GRP-1319NULL
CLMCLM-4186152026-09-21T22:12:24Zrachel—arnold11/3/2006UHC-88152-78N/AUNKNOWNUNKNOWN5388 Highland AveAustin·TX78705GRP-2858·N/A
TPATPA-568422026-02-24T13:45:50ZBEVERLY—HUNTER1996-11-15—nullN/A—UNKNOWN——N/A-—
ENRENR-1176372026-09-19T05:44:55ZHelen··K.Jenkins·Aug 25, 1977·uhc-05577-58•••-••-9942607.612.2856UNKNOWN8398 Lincoln WaySan AntonioTX78249GRP-0813CORE-HMO
TPATPA-556492026-05-16T21:23:53ZRyan—Grant1989-09-27UHC-15044-36NULL740-436-3040—6174 Valley View DriveTucsonAZ85708-5407GRP-4283-
ENRENR-1000102026-02-06T12:52:11ZCAROLYNOBURNSnullUHC6438722•••-••-4084(864) 714-3924·carolyn.burns@yahoo.com7945 Forest AveJacksonvilleFL32288·GRP-3627CHOICE-PLUS-PPO
ENRENR-1120942026-02-05T02:38:37ZNICOLEQCARTER1978-02-06UHC-16666-12··N/Anull-5698 Grand AveHoustonTexas··77048GRP-2105MEDICARE-ADV-A
TPATPA-599942026-04-05T04:17:07ZElizabeth—·Estrada1985-01-04——null··—4614 Church StSan AntonioTX·78249····null··
ENRENR-1074942026-06-05T10:00:40ZFrank—Alvarado··1968-11-17··UHC-72561-53-4707390frank.alvarado60@outlook.com9413 CENTRAL AVEGlendale·Arizona85378GRP-8667MEDICARE-ADV-A
ENRENR-124626 2026-08-06T01:09:33ZDylan—Graham4/20/1991UHC-38198-66··•••-••-8619+1 633 211 6626dylan.graham13@yahoo.com5316 Harbor Boulevard··Chandler·AZ85237GRP-9807MEDICARE-ADV-A
TPATPA-630762026-03-08T07:47:32ZDOROTHY—GRAY09/19/01—•••-••-4721—·N/A1611 Market Street #488DenverCOnullUNKNOWNnull
CLMCLM-4182032026-06-19T00:46:08ZTHOMAS—BARNES1958-12-14·UHC-50248-95··null—4530 Ridge RdPLANOTX75041GRP-9899SELECT-EPO
CLMCLM-4283052026-07-12T20:38:59ZJerry··IPerkins·1988-01-07null•••-••-2043809-755-5262jerry.perkins@aol.com9878 Desert Sky BoulevardAtlantaGA30380-3034—CORE-HMO
CLMCLM-4211302026-10-17T10:41:10ZDoris, Bell——1957-03-09UHC-49343-44•••-••-52956277660285N/AN/A-·nullNULLGRP-4730—
PRVPRV-239722026-02-15T13:51:18Zfrank—baker1990-09-08--774-260-1092·UNKNOWN2429 Sage CtGlendaleAZ85307-3547—-
CLMCLM-413055 2026-09-05T00:12:55ZVIRGINIA··FDOMINGUEZ1997-03-24UHC-47834-81··NULLN/AN/A9376 Elm St Apt 25OrlandoFL32846—OPTIONS-PPO
ENRENR-1117512026-02-28T22:39:27ZSOFIAUVAZQUEZ5/3/1971UHC9524652•••-••-0464457-540-5160—6152 Apache BoulevardSeattleWashington98197GRP-4293OPTIONS-PPO
ENRENR-1424122026-08-13T17:25:03ZLaura··Dunn12/16/1946UHC-26938-12•••-••-9013(649) 987-1583—·8726 Apache Blvd Apt 20PlanoTX75092GRP-1591MEDICARE-ADV-B
ENRENR-119879 2026-10-01T04:44:37ZTERESAV.HARRISON2007-01-27UHC-56572-05—(975) 304-9752teresa.harrison@proton.me1781 HARBOR BOULEVARDSan AntonioTX78294·GRP-6674NAVIGATE-HMO
ENRENR-1170382026-01-14T22:59:43ZAmy—Robinson1967-09-23UHC-32707-46•••-••-93108938407867-3052 UNION STHoustonTexas77003··GRP-9787CORE-HMO
ENRENR-1166592026-10-13T15:12:01ZKahyJMorales1949-06-28UHC-69962-70•••-••-9633(709) 921-5098katherine.morales@outlook.com9500 Sunset BoulevardLos AngelesCA90008GRP-7350MEDICARE-ADV-A
CLMCLM-4253952026-04-22T08:59:44Zwayne—bennett1948-01-25—N/A—UNKNOWN4348 Maple Ave Apt 32TampaFL33602GRP-7843N/A
CLMCLM-4055912026-03-26T04:54:42ZLawrence, Jose——1967-12-22··UHC-16741-15··•••-••-3883(233) 889-9604-·4669 Lincoln WayPlanoTX75040-4130NULLOPTIONS-PPO
ENRENR-1071812026-04-27T17:31:49ZTERRYQ.··WONG··1942-08-17UHC-43194-92··•••-••-67538886964622—4830 Hillcrest RdFRESNOCA93700GRP-2446··SELECT-EPO
ENRENR-1004202026-06-30T10:27:41ZHarris, RobertB—10/27/83UHC-42531-34····8783630618ROBERT.HARRIS@PROTON.ME7190 MAIN STCharlotteNC28290GRP-3849MEDICARE-ADV-B
ENRENR-1086082026-03-16T06:50:10Z AnthonyURos·1984-09-02UHC-38512-88•••-••-7746+1 430 907 3514anthony.rios5@gmail.com5354 CAMELBACK ROADGilbertAZ85246GRP-2495MEDICARE-ADV-B
PRVPRV-287642026-03-08T16:12:00ZDanielle, Weaver——06/27/71UHC-98676-06—N/Adanielle.weaver90@yahoo.com724 Palm Dr·AtlantaGA30341-0857NULL-
TPATPA-610732026-07-20T11:41:24ZJacob—Green1976-06-19—•••-••-7300—··1279 Sunset BlvdLos AngelesCA90003-8224·GRP-3888UNKNOWN
ENRENR-1228062026-01-17T11:37:45ZCharlesTWilliamson07/12/75UHC-92484-92—421-880-2017null2922 River RoadFresnoCA93765GRP-2558MEDICARE-ADV-B
ENRENR-1126332026-08-19T11:35:49ZOlivia—Thomas1966-01-14UHC-31622-35•••-••-3562+1 349 297 0755olivia.thomas@aol.com9328 Sage CourtPlanoTX75006GRP-1775OPTIONS-PPO
ENRENR-1227392026-09-10T21:41:23ZNOAHU.PRYCE1969-11-08UHC-27165-52•••-••-27275552532220noah.price@icloud.com4559 MARKET STREETPLANOtx75026GRP-2833CHOICE-PLUS-PPO
PRVPRV-221772026-04-19T23:41:34ZGarrett, MadisonO—04/18/42UHC-53981-25··NULL3276414185UNKNOWN—————NULL
ENRENR-1316552026-07-28T17:27:13ZRALPH····GUZMAN1988-08-10UHC-55739-78•••-••-89097912715247—7461 Lincoln WayCharlotteNC28237GRP-2886CORE-HMO
ENRENR-1096392026-03-05T05:57:03ZVazquez, BrianG.—·07/16/70uhc-12630-18•••-••-4884(364) 661-5998N/A4314 WASHINGTON STREET·SacramentoCA95831··GRP-8130··CORE-HMO
ENRENR-1235912026-06-27T23:59:28ZChristopher—Marshall··08/27/1959UHC-31218-31•••-••-2839(240) 355-5494christopher.marshall62@outlook.com6291 HARBOR BOULEVARDTampaFL··33667-0229GRP-3781CORE-HMO
CLMCLM-4113622026-09-23T20:06:36ZMarcusCWong10/05/2006UHC-03574-75—501-257-4386—8541 DESERT SKY BLVDMESAAZ85278GRP-9982—
ENRENR-1151032026-07-18T12:06:50ZMaggie—Cruz01/09/01UHC-61807-71•••-••-2616nullMARGARET.CRUZ@GMAIL.COM9104 JEFFERSON AVEGlendaleAZ85353GRP-7146SELECT-EPO
TPATPA-606722026-07-07T09:00:41ZStephanie—Porter1974-01-20N/A··null-N/A·3850 Jefferson AveLos AngelesCalifornia90086—MEDICARE-ADV-B
ENRENR-1121112026-03-18T09:46:11ZLOGAN··—COX·1967-07-18UHC-60227-35•••-••-4768296-776-7447logan.cox13@hotmail.com5449 BAYSHORE DRHoustonTXUNKNOWNGRP-9754OPTIONS-PPO
ENRENR-1274152026-02-01T22:14:40ZMariaRNichols·1954-07-02UHC-45780-65··•••-••-7414+1 660 751 4682maria.nichols81@aol.com·9570 HARBOR BLVD·AtlantaGA30356GRP-3227··SELECT-EPO
TPATPA-531032026-01-06T21:59:49ZRalph····Daniels7/7/2001—N/AUNKNOWNnull3822 SAGE CT·Phoenixaz85082GRP-9160CORE-HMO
ENR ENR-1177982026-08-19T01:24:16Z Ramirez, Heather——1985-09-07UHC-96401-94•••-••-4282+1 675 669 5687heather.ramirez@yahoo.com3843 MAIN STREETPLANOTX75050GRP-7768MEDICARE-ADV-A
TPATPA-52649 2026-09-10T07:55:51ZPATRICK—WEST··1961-09-23UHC-73334-92•••-••-8470(320) 454-5775null5599 Maple AvenueTampaFL33640-CORE-HMO
100,000 rows, page 3 of 2,000PreviousNext

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-19T19:54:25.413Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty