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-1263302026-08-20T14:02:58ZNICHOLAS—·SANCHEZ04/16/1985UHC-24197-12•••-••-7072(205) 496-0238—3184 Canyon RdSan AntonioTX78264GRP-9470CHOICE-PLUS-PPO··
ENRENR-1364382026-02-01T18:50:30ZChristinaX.Estrada1969-02-07UHC-05394-63•••-••-0290(257) 574-3192CHRISTINA.ESTRADA@HOTMAIL.COM5680 Canyon RdNashvilleTN37201·GRP-9863CORE-HMO
ENRENR-1204602026-09-07T10:53:45ZParker, Olivia——1982-07-27UHC-73080-77•••-••-00896079777656OLIVIA.PARKER98@ICLOUD.COM4826 Cedar LnGlendale·AZ85360-6376GRP-4741NAVIGATE-HMO
ENRENR-117021 2026-09-04T13:06:10ZELIJAH—MEYER1957-01-17UHC-22809-59•••-••-57654544298303elijah.meyer88@yahoo.com1014 Mountain View DrAtlantaGeorgia30316GRP-1994CHOICE-PLUS-PPO··
ENRENR-1401862026-01-26T23:39:48ZMaldonado, JohnV—1943-04-02UHC-04570-68•••-••-7804(501) 269-9231JOHN.MALDONADO@GMAIL.COM1029 Sage CtMesaArizona85211GRP-2167SELECT-EPO
ENRENR-1127372026-05-18T12:29:09ZGray, Kayla··W.—1963-10-09UHC-69276-35•••-••-2762697-749-6815—9706 Lake View RdSCOTTSDALEArizona85214GRP-7909MEDICARE-ADV-A
ENRENR-1235652026-08-25T11:53:09ZAlanP.Hanson1999-01-27UHC-37725-42•••-••-7322438-996-7162alan.hanson@yahoo.com3378 Ridge RdLos AngelesCA90009GRP-2146MEDICARE-ADV-B
ENRENR-1041502026-09-01T23:45:42ZMariana—Collins1966-09-24UHC-57189-74•••-••-466817359498191null9011 Pine DriveJacksonvilleFL32277GRP-4009SELECT-EPO
ENRENR-1165162026-02-12T22:04:50ZTHOMAS—WEBB1966-07-03UHC-04914-27•••-••-0748248-319-6321··5126 Cedar LaneScottsdaleAZ85220GRP-4238·MEDICARE-ADV-A
ENRENR-1217442026-02-02T11:05:45ZvincentWsantosSep 20, 1956UHC-03098-68•••-••-2312692-880-3919vincent.santos72@gmail.com8963 BROADWAYAustinTX78759-8522GRP-1470OPTIONS-PPO
ENRENR-1173062026-09-18T09:52:04ZROYPSMITH1945-01-07UHC-64287-90•••-••-6799NULL—·5453 MARKET STREETScottsdaleArizona85283GRP-7075CHOICE-PLUS-PPO
ENRENR-1168712026-02-17T18:54:59ZLi, Mei··N—1953-11-28··UHC-98792-36•••-••-2459—mei.li54@yahoo.com9840 Palm DriveJacksonvillefl32255GRP-8290OPTIONS-PPO
ENRENR-1267002026-07-01T12:23:33ZGERALDYGARDNERJun 1, 1952UHC-17504-13•••-••-27073414882720gerald.gardner@proton.me2245 Meadow LaneCharlotteNC28269GRP-2965CORE-HMO
ENRENR-1271522026-06-05T20:58:31ZDanielGCarroll1970-06-20UHC-02920-79··933-810-3677DANIEL.CARROLL79@OUTLOOK.COM6778 ELM STCharlotteNorth Carolina28218-8657GRP-7196CHOICE-PLUS-PPO
ENRENR-1330642026-01-24T03:28:14ZMargaret·IPhillips9/19/2005UHC-64204-80•••-••-3317+1 611 432 8254margaret.phillips@yahoo.com7376 Sage CourtNASHVILLETennessee37207GRP-4659CORE-HMO
ENRENR-1153362026-06-29T11:19:29ZAdam·PAlvarado02/23/41UHC-25176-33-593-899-6010-··-nullUNKNOWN-·GRP-4484·SELECT-EPO
ENRENR-1060392026-04-18T19:41:13ZBradleyZThhomas1941-07-28UHC-73766-30•••-••-27013945141766bradley.thomas21@aol.com6512 Ridge RdGlendaleAZ85322GRP-4080CORE-HMO
ENRENR-1403962026-02-10T14:14:24ZBrittany—·Mendez1964-08-09UHC-52889-10•••-••-90683704665917brittany.mendez80@icloud.com6649 PALM DRIVESan DiegoCA92150GRP-5976NAVIGATE-HMO
ENRENR-1017962026-03-22T18:08:32ZEmilyXPeterson11/16/1969UHC-84259-62-900.540.0983emily.peterson30@gmail.com5650 Mesa DriveDenverCO-GRP-9233··MEDICARE-ADV-A
ENRENR-1374552026-09-02T00:23:54Zmegan—morgan1997-09-07UHC-81877-49—3702014986··megan.morgan39@gmail.com5484 Ridge RoadAtlantaGA30374GRP-1135CORE-HMO
ENRENR-1006342026-09-01T17:09:44ZMeganQPorter1973-10-21UHC6693790NULL(262) 770-2901megan.porter15@proton.me··8071 MAPLE AVENUETucsonAZ85797GRP-8739MEDICARE-ADV-A
ENRENR-1046942026-05-30T02:47:51ZBellUBenjamin··May 19, 1987UHC-88671-74•••-••-0410(487) 943-7971benjamin.bell94@outlook.com8479 CAMELBACK ROADMinneapolismn55428··GRP-5593NAVIGATE-HMO
ENRENR-1410362026-08-10T01:42:11ZBenjamin—Banks19750109UHC-28318-64•••-••-6848-benjamin.banks91@aol.com5463 BroadwayPhoenixAZ85080GRP-3970CORE-HMO
ENRENR-1296392026-05-02T05:50:23ZSTEPHANIEFDAY05/02/1968UHC-13402-27•••-••-8668576.483.8525STEPHANIE.DAY@OUTLOOK.COM··5173 Highland AveAtlantaGA30361-2007GRP-5563MEDICARE-ADV-B
ENRENR-1386972026-05-31T04:09:50ZMaldonado, Cheryl·S—1999-06-11UHC-13415-08•••-••-7463317.427.8811—6974 Hillcrest RdPhoenix·Arizona85037··GRP-8384SELECT-EPO
ENRENR-1132002026-01-29T21:58:57Zteresa··—santos22-12-1959UHC-28319-23•••-••-9469957-635-9236TERESA.SANTOS25@HOTMAIL.COM194 Oak StreetDallasTX75256-3144GRP-2012NAVIGATE-HMO
ENRENR-1411782026-04-07T11:57:40ZDylanP··Morrison··26-06-1948UHC-76007-54··6839591610dylan.morrison65@gmail.com368 Apache BlvdColumbusOhio··43231GRP-7721·SELECT-EPO
ENRENR-1388162026-05-01T01:50:57ZRAYMONDJCOX1947-12-23··—•••-••-47488168144119RAYMOND.COX15@OUTLOOK.COM6788 Park PlTEMPEAZ85214GRP-3980OPTIONS-PPO
ENRENR-1088422026-01-05T06:01:46ZDONALDR.SILVA1991-12-02UHC-01229-52•••-••-4801(536) 792-3622—366 Forest AveScottsdaleAZ··85253GRP-2980CORE-HMO
ENRENR-1369082026-03-07T18:24:34ZMeiLClark1987-03-09UHC-15546-20•••-••-3799765-896-2929mei.clark51@hotmail.com4102 SUNSET BLVDGlendaleArizonanull··GRP-9992OPTIONS-PPO
ENRENR-1214652026-07-22T20:36:56ZALEXANDER—STTONE1954-02-21UHC-79178-97•••-••-1790N/AALEXANDER.STONE3@YAHOO.COM5648 HARBOR BLVDAtlantaGeorgia30352··GRP-9143OPTIONS-PPO
ENRENR-111241 2026-01-10T11:55:56ZMATEOP.HILL07/15/70UHC-13418-23•••-••-16618406903357mateo.hill77@outlook.com2581 Elm StEden Prairie··MN55315GRP-6607CHOICE-PLUS-PPO
ENRENR-1113172026-01-26T18:54:34ZWILLIE—JENKINS2004-05-26uhc-51635-89•••-••-84059473390461··willie.jenkins99@icloud.com·5072 Pine DrSCOTTSDALEAZ85251GRP-7150OPTIONS-PPO
ENRENR-1275822026-01-03T13:37:21ZDoris—Gilbert1945-07-11UHC-96647-42•••-••-6801(297) 985-4632-··8676 Canyon RdLas VegasNV89190-4045GRP-2508CORE-HMO
ENRENR-1132792026-09-26T20:14:54ZHenryR.Harper1952-10-15··—nullhenry.harper@yahoo.com3110 DESERT SKY BLVDCharlotteNC28206GRP-3711OPTIONS-PPO
ENR ENR-1138422026-07-31T05:17:15ZYuki—Powell1970-05-24··UHC-46195-87•••-••-4585-—402 Lincoln WayGlendaleAZ85390GRP-1049CORE-HMO
ENR ENR-1111142026-08-29T18:53:18ZCAMILA—KELLEY1967-12-06UHC1638974··•••-••-3552—null4455 INDIAN SCHOOL ROADChandlerAZ85283GRP-9355CHOICE-PLUS-PPO
ENRENR-1269352026-09-18T07:38:35ZSHIRLEYBWASHINGTON2008-04-16··UHC0530116•••-••-25796145073··SHIRLEY.WASHINGTON@YAHOO.COM5417 VALLEY VIEW DRIVESan DiegoCA92163GRP-8249SELECT-EPO
ENRENR-1137212026-06-26T18:16:23ZsofiaMporter1971-07-26UHC-75152-84•••-••-94265948765195sofia.porter@proton.me2993 Union StATLANTAGA30339GRP-8668·SELECT-EPO
ENRENR-102522 2026-02-19T07:32:23Zdouglas—·scott19550619UHC-94895-23N/A(854) 645-5189douglas.scott@gmail.com9220 Indian School RoadMesaAZ85228GRP-9172NAVIGATE-HMO··
ENR ENR-1157722026-09-28T21:53:31ZGABRIEL··REYNOLDS1939-04-23UNKNOWN•••-••-17498529219991gabriel.reynolds26@hotmail.com3079 VALLEY VIEW DRIVE··Las VegasNV89138-9917GRP-5716CORE-HMO
ENRENR-1386712026-03-01T19:27:40ZMartha—West19510813UHC-32314-83•••-••-6274683-471-3620martha.west20@proton.me3664 Pine DriveTempeAZ85218GRP-7543CHOICE-PLUS-PPO
ENRENR-1162652026-04-14T06:22:59ZPierce, Amy——1698-04-10··UHC-70925-48•••-••-7090·544-643-6868—3002 Main Street·DenverCO80207GRP-4906SELECT-EPO
ENRENR-1327462026-03-24T16:56:55ZTim—Roberts1985-02-27UHC4008036•••-••-6161(372) 327-4370timothy.roberts@gmail.com3405 Cedar LaneChandlerAZ85292GRP-9240CORE-HMO
ENRENR-1010272026-03-31T06:00:44ZSam—·Munoz1952-07-03UHC-42507-18··•••-••-4724+1 632 301 7599samuel.munoz@aol.com·6521 Mesa DriveSan AntonioTX78233GRP-1137CHOICE-PLUS-PPO
ENRENR-1420072026-01-30T20:19:28ZDianeACar2005-08-14UHC-71365-75•••-••-3860632-476-7089diane.carr@yahoo.com··2848 LAKE VIEW ROADSEATTLEwa98102GRP-1950MEDICARE-ADV-B
ENRENR-1117822026-10-11T14:30:18ZJenniferKOliver1972-09-17UHC-58266-53•••-••-6693(712) 209-1092jennifer.oliver@hotmail.com8588 Union StreetOrlandofl32874GRP-1207CHOICE-PLUS-PPO
ENRENR-1372012026-06-17T00:43:24ZEugeneVWatkins1965-11-24UHC-59440-01•••-••-6422656-261-8581—5076 ELM STREET #250Denver··Colorado··80295GRP-9547CORE-HMO
ENRENR-1163622026-10-13T11:04:45Zcarl—elliott·1956-07-18UHC8685688•••-••-07776795155685·carl.elliott31@yahoo.com7197 Market Street···JacksonvilleFL··32296GRP-9607SELECT-EPO
ENRENR-1182182026-05-08T00:01:42ZNATHANYRYAN17-09-1996UHC-40820-53•••-••-7275(607) 844-7520NATHAN.RYAN@GMAIL.COM8757 DESERT SKY BOULEVARD·DenverColorado80273GRP-8563OPTIONS-PPO
43,101 rows, page 64 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:36.697Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty