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
ENR ENR-1240912026-05-01T08:48:03ZLawrenceIDiaz1998-01-18UHC-88531-91•••-••-3357545-708-1027LAWRENCE.DIAZ35@HOTMAIL.COM6361 LINCOLN WAYAustinTexas78751·GRP-6371select-epo··
ENRENR-1429682026-02-18T16:27:09Z·Linda—BishopMay 16, 1943UHC-76949-11•••-••-9066454-700-7895NULL1478 Maple AvenueJacksonvilleFL32238GRP-2063MEDICARE-ADV-A
ENRENR-1414022026-10-12T04:17:20ZJordanA.OBrien10/6/1979UHC-17132-71··—+1 265 580 8459··jordan.obrien46@aol.com7469 Ridge RdGlendaleAZ85311GRP-2024MEDICARE-ADV-B
ENRENR-1338372026-08-17T10:39:38ZGabrielGMartin1945-10-18UHC-52944-33•••-••-816314327823778gabriel.martin@aol.com3286 Central Avenue··PhoenixAZ85073GRP-0875MEDICARE-ADV-B
ENRENR-1324012026-04-18T11:13:02ZNancy··Martin01/10/1964UHC-33658-68•••-••-193512269268027nancy.martin@proton.me3600 Washington StreetSan AntonioTX78250GRP-4304CHOICE-PLUS-PPO
ENRENR-1297212026-02-09T19:09:14ZArthurVLawson19800104UHC-45410-99•••-••-47052375944552arthur.lawson91@icloud.com6245 UNION STTampaFL33637GRP-3970CHOICE-PLUS-PPO
ENRENR-1051302026-02-25T00:42:06ZJENNIFER·AJONEES1940-12-22UHC-53450-73•••-••-1818—null3202 HIGHLAND AVEJacksonvillefl32271GRP-2838OPTIONS-PPO
ENRENR-1151492026-06-08T11:51:30ZFRANKG.WELCHAug 8, 2002UHC-83329-67—9483800374·FRANK.WELCH@ICLOUD.COM3183 Indian School RdDallasTX75200GRP-7235CHOICE-PLUS-PPO
ENRENR-1359162026-10-05T02:47:32ZGloriaWWardSep 2, 1968UHC-82962-29•••-••-33464968924413gloria.ward92@yahoo.com2598 HILLCREST ROADMiamiFlorida·33166GRP-3434CORE-HMO
ENRENR-1113062026-03-07T06:14:27ZTIMOTHY—OBRIENMay 22, 1994UHC-68603-34•••-••-55799698669011NULL··631 Sunset BoulevardMesaAZ··85232GRP-6695MEDICARE-ADV-A··
ENRENR-1347592026-06-14T17:43:31Z JESSEIDELGADO1956-12-12UHC-02668-55··•••-••-8034(617) 542-2848N/A662 Harbor BlvdAtlantaGA30376GRP-9480MEDICARE-ADV-A
ENRENR-1172562026-01-05T00:05:36ZEspinoza, SaraS—01/27/97UHC-90159-04•••-••-48197938200340SARA.ESPINOZA97@AOL.COM5773 Central AveLos AngelesCA90072GRP-5707OPTIONS-PPO
ENRENR-1201492026-06-24T06:18:48ZwillieZ.garza04-10-1962UHC-11602-33•••-••-2572+1 565 611 5464-9375 Jefferson AveSan AntonioTX78259GRP-8818SELECT-EPO
ENRENR-136884 2026-06-13T11:55:40ZJack—Bishop04/02/43·UHC-95340-02•••-••-6158(448) 928-3197···-411 Washington St·SAN ANTONIOTexas78280-3789GRP-6859MEDICARE-ADV-A
ENRENR-1284542026-09-12T15:48:19Zsusan—mason19540627··UHC-43398-29•••-••-3600NULLsusan.mason55@yahoo.com··685 Cedar LnMiamiFlorida33124GRP-6124MEDICARE-ADV-A
ENRENR-1295152026-07-06T21:23:00Zmark—perez5/13/1962UHC-51631-22•••-••-4996(611) 940-6836··MARK.PEREZ61@OUTLOOK.COM8922 CANYON ROADLos AngelesCA90089GRP-6803CORE-HMO
ENR ENR-1154872026-06-03T22:48:22ZFlores, Jcaqueline——2001-09-24··UHC-36088-62•••-••-8886579-875-6006····1019 GRAND AVEPlanoTexas75005-1213GRP-9539NAVIGATE-HMO··
ENRENR-1233202026-05-12T22:28:03ZETHAN—JOHNSTON08-08-1996UHC-99682-03null(976) 573-3846N/A2096 Canyon RdPhoenixAZ85042GRP-2033MEDICARE-ADV-A
ENRENR-1149602026-03-05T10:22:54ZSalazar—Greg19550317UHC-54013-72•••-••-1961393-806-7388—5228 HARBOR BLVDLOS ANGELESCAnull·GRP-1780OPTIONS-PPO
ENRENR-1406172026-03-19T02:58:25ZBetty—Perez1997-03-07UHC-12785-63•••-••-9272N/ABETTY.PEREZ14@OUTLOOK.COM136 Mesa DrMinneapolisMN55470GRP-6166NAVIGATE-HMO
ENRENR-1208352026-09-30T09:46:19ZGabriel····Hawkins··12/22/49UHC-32513-52•••-••-8199864-341-9326gabriel.hawkins@hotmail.com3579 Desert Sky BoulevardSan AntonioTX78217GRP-8901MEDICARE-ADV-B
ENRENR-1080152026-06-13T18:00:30ZSantiagoJ.Crawford22-05-2005—•••-••-4823769-529-4454santiago.crawford3@hotmail.com3072 Main StColumbusOH·43203GRP-2075NAVIGATE-HMO
ENRENR-1082462026-08-23T01:46:34ZLisaN.ColeApr 7, 1977UHC-60321-83•••-••-61995183206334·lisa.cole@yahoo.com349 Cedar Ln··ColumbusOH43283GRP-0819CORE-HMO
ENRENR-1196752026-01-08T12:45:07ZDelgado, JonathanB.····1972-05-23UHC-28899-94•••-••-56304855058023jonathan.delgado@gmail.com5209 PARK PLACEMinneapolisMN55407GRP-8607CHOICE-PLUS-PPO
ENRENR-1114092026-10-17T01:42:14ZPriyaWWilliamsonMay 23, 1981UHC-37053-26•••-••-0475(535) 229-0728·PRIYA.WILLIAMSON29@AOL.COM1331 OCEAN AVENUESeattleWA98159GRP-8847CORE-HMO
ENRENR-1097722026-09-18T16:44:54ZJose—Reyes1982-09-22UHC-82007-66•••-••-2631275.560.5024··jose.reyes94@proton.me·3037 Willow CtPhoenixAZ85074GRP-0106SELECT-EPO
ENRENR-1396472026-03-02T22:35:17ZVirginia—Hansen19440706UHC-14278-08•••-••-8344838.671.8672virginia.hansen@outlook.com3692 SUNSET BOULEVARDJACKSONVILLEFL32220GRP-7263NAVIGATE-HMO
ENRENR-1350712026-10-05T01:55:10ZGibson, CamilaU—1968-03-15·UHC-37139-56N/A··9162589539-·999 Bayshore DriveJacksonvilleFL32272GRP-2024MEDICARE-ADV-A
ENRENR-1056552026-09-02T20:24:36ZDennis—Cunningham·1943-04-25UHC-38067-76•••-••-3022nullnull5227 Lincoln WayAtlantaGA30370GRP-4687MEDICARE-ADV-A
ENRENR-1186402026-08-05T12:13:51ZChristopherU.Morrison19-11-1993UHC-26057-22—494-847-2455christopher.morrison@outlook.com4755 BroadwayMiamiFL33136GRP-9645CHOICE-PLUS-PPO
ENRENR-1277042026-09-04T09:18:38ZDennisJ.Holmes1981-01-15UHC-23663-34•••-••-2749-UNKNOWN8792 ELM STMiamiFL33153GRP-1143MEDICARE-ADV-A
ENRENR-1370082026-04-18T04:45:06ZCARLGMURRAYJan 19, 1998UHC-43401-37•••-••-4971(885) 787-4803··carl.murray@icloud.com1170 Elm StreetPhoenixAZ85048GRP-7951·SELECT-EPO
ENRENR-1159262026-02-23T21:09:03Zrachel—rios09/09/2003UHC-86721-94•••-••-5528(769) 534-0062·rachel.rios99@hotmail.com8449 Park Pl Apt 6AustinTX78799···GRP-9772CHOICE-PLUS-PPO
ENRENR-1277512026-08-23T20:58:50ZJose—Brooks19851120UHC-69339-04··•••-••-38885608342817UNKNOWN9210 Main StNASHVILLETN·37244GRP-7363MEDICARE-ADV-B
ENRENR-1188872026-01-07T19:58:39ZJENNIFER··CSINGH19401109UHC-92478-93•••-••-5416883-903-8774—5404 Canyon RoadColumbus··OH43240GRP-3038MEDICARE-ADV-A
ENRENR-1134902026-01-18T07:16:00ZDYLAN—WHEELERJan 26, 2000··UHC-34756-24•••-••-63027058103344dylan.wheeler16@outlook.com··5635 Palm DrEden PrairieMN55303GRP-8217CHOICE-PLUS-PPO
ENRENR-1159202026-08-11T23:45:51ZJessKStephens06/15/1948UHC-76732-26•••-••-63022476418-9811 CANYON ROADEden PrairieMN55340-9542GRP-9999CORE-HMO
ENRENR-1094442026-03-12T05:23:45ZVincent—Lee1979-01-01UHC4050425•••-••-679816897745966VINCENT.LEE@PROTON.ME4326 Sunset BlvdHoustonTX··77068GRP-1425CORE-HMO
ENRENR-1249522026-08-15T08:09:22ZnicholasW.fuller1987-03-27UHC-68170-18•••-••-3759623-787-4093nicholas.fuller@hotmail.com6747 Maple AveSAN DIEGOCA92160GRP-4240··OPTIONS-PPO
ENRENR-1004392026-05-11T21:38:43ZChristineVSalazar1973-11-05UHC-75118-47•••-••-48119447804785christine.salazar91@outlook.com7127 Sunset BoulevardPlano··TX75020-4383GRP-9361SELECT-EPO
ENRENR-1020272026-03-30T10:20:02ZPHILIP—HENRY09/01/1968UHC-20135-23··•••-••-380712884697135UNKNOWN2376 Bayshore DriveJACKSONVILLEFL32230GRP-1600CHOICE-PLUS-PPO
ENRENR-1084522026-04-26T10:34:10ZangelaF.·kingJul 19, 1998UHC-52357-03•••-••-2347+1 809 297 0983—5763 RIVER RDEden PrairieMN55354-9347GRP-6076MEDICARE-ADV-A
ENR ENR-1105992026-09-08T16:46:41ZBobby·JJohnson2006-06-03UHC-59091-27•••-••-5833(396) 791-9207bobby.johnson@yahoo.com3248 MESA DRIVEAtlantaGA30345GRP-9845SELECT-EPO··
ENRENR-1087582026-03-06T11:41:28ZLindaKRichardson1948-09-07UHC-26607-58•••-••-5091(617) 567-1627LINDA.RICHARDSON@OUTLOOK.COM8758 Pine DriveOrlandoFL32883-4703GRP-1742OPTIONS-PPO
ENRENR-1000902026-07-11T19:16:35ZANTHONY—JAMES1980-03-10UHC-31774-96•••-••-4089691.551.8747null7496 ELM STREETSan DiegoCA92192··GRP-0655CORE-HMO
ENRENR-1032872026-01-30T15:30:00ZMargaretEYoung06/14/69UHC-35522-23•••-••-6833-margaret.young43@hotmail.com7545 Meadow LaneTampaFL33664-6907GRP-5287SELECT-EPO
ENRENR-132872 2026-01-18T17:05:53ZSofiaAOrtiz04-11-1995UHC-16134-88•••-••-6959(439) 981-6570sofia.ortiz37@aol.com3988 LINCOLN WAYJacksonville··FL32242··GRP-9038CORE-HMO
ENRENR-1235432026-04-20T21:45:01ZREBECCAZPARK—UHC-38162-90•••-••-89944881394rebecca.park@outlook.com3900 VALLEY VIEW DRIVESan DiegoCalifornia92109·GRP-8139CHOICE-PLUS-PPO
ENRENR-125405 2026-07-26T01:55:03ZKimberly··—Henderson1979-01-28UHC-38908-47null(401) 200-7130kimberly.henderson5@gmail.com2478 Forest AveSacramentoCA95810GRP-4102NAVIGATE-HMO
ENRENR-1380672026-03-16T00:26:50Zann—henry11/28/1950UHC-47061-95•••-••-3683+1 349 319 9676ANN.HENRY@HOTMAIL.COM4023 MAIN STSacramentoca95877··GRP-9371CHOICE-PLUS-PPO
43,101 rows, page 199 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:40.337Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty