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
TPATPA-613192026-09-25T18:01:48ZMadison—Rse·16-11-1966·nullnull3446203431NULL3811 Bayshore DrScottsdale·AZ85291GRP-2831MEDICARE-ADV-A
CLMCLM-4009802026-07-17T17:43:26ZStewart, Bradley··—Feb 12, 1968UHC-82552-49•••-••-4326—-1693 Indian School RoadMinneapolisMN55479··—OPTIONS-PPO
CLMCLM-401286 2026-03-03T20:51:38ZEMMA—VALDEZ1940-64-19UHC-16477-14———5102 Cedar LaneSeattleWA98192nullCHOICE-PLUS-PPO
ENRENR-1411782026-04-07T11:57:40ZDylanP··Morrison··26-06-1948UHC-76007-54··6839591610dylan.morrison65@gmail.com368 Apache BlvdColumbusOhio··43231GRP-7721·SELECT-EPO
CLMCLM-4192522026-03-11T15:31:03ZKing, AndreaF—19600113UHC-14938-22··NULL3287266945——null—NULLN/AUNKNOWN
ENRENR-1388162026-05-01T01:50:57ZRAYMONDJCOX1947-12-23··—•••-••-47488168144119RAYMOND.COX15@OUTLOOK.COM6788 Park PlTEMPEAZ85214GRP-3980OPTIONS-PPO
CLMCLM-4061432026-04-04T04:38:16ZArthur—Thompson1945-05-20UHC-52821-02•••-••-07656882082359-2767 Forest AvenueChandlerAZ85233·GRP-2684CORE-HMO
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
TPATPA-561182026-09-09T07:14:22ZCAROL—BURTON02/02/84UNKNOWN··——N/A5385 BROADWAYOrlando·FL32807NULLCHOICE-PLUS-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
CLMCLM-4274992026-01-17T22:20:44ZYUKI··—BURTON2001-06-17UHC-06392-96•••-••-2105—-1866 WILLOW CTTempeAZ85244—OPTIONS-PPO
CLMCLM-4083402026-05-31T19:22:19ZGloria—Le1940-08-28UHC-26291-93null—N/A1542 HIGHLAND AVESCOTTSDALEAZ85295—-
CLM CLM-4215552026-02-24T09:08:12ZSchmidt, Virginia———UHC-83823-87UNKNOWN18933198397-··9250 FOREST AVESEATTLEWA··98146GRP-8795null
CLMCLM-4108252026-07-01T12:41:08ZChristian—Rojas19580515·UHC-96374-15null5299698703UNKNOWN—NULLN/A-GRP-7122UNKNOWN
PRVPRV-218172026-08-25T13:32:14ZHENRY—SNYDER1946-09-18UNKNOWNN/A3918930872henry.snyder@gmail.com4659 Church StreetHoustonTX77029UNKNOWNMEDICARE-ADV-A
ENRENR-1275822026-01-03T13:37:21ZDoris—Gilbert1945-07-11UHC-96647-42•••-••-6801(297) 985-4632-··8676 Canyon RdLas VegasNV89190-4045GRP-2508CORE-HMO
CLMCLM-4266822026-03-04T04:41:39Zjudth—larson1952-10-27NULL—(683) 649-8806—6318 SUNSET BLVDCOLUMBUSOH43237N/AMEDICARE-ADV-A
CLMCLM-4291152026-10-08T21:56:32ZMark—Hoffman09/10/1942·UHC-11330-50•••-••-8913··mark.hoffman@gmail.comnullnullnullNULLNULL—
TPATPA-570992026-06-06T03:48:43ZYang, Gerald—··07/07/63UNKNOWN··—(245) 927-6170—533 Baseline RoadColumbusOH43261——
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
PRVPRV-221832026-09-21T16:03:52ZBOBBY····LEE1939-06-16—-890-229-7657BOBBY.LEE@AOL.COM7975 LINCOLN WAYScottsdaleAZ85201N/ANAVIGATE-HMO
ENR ENR-1111142026-08-29T18:53:18ZCAMILA—KELLEY1967-12-06UHC1638974··•••-••-3552—null4455 INDIAN SCHOOL ROADChandlerAZ85283GRP-9355CHOICE-PLUS-PPO
CLMCLM-4320822026-09-23T04:45:37Zkeith—cruz1946-01-14··——nullNULL7173 Apache BlvdSan Antonio··TX78295GRP-8444CORE-HMO
PRVPRV-233352026-05-14T09:00:54ZSHIRLEY—JENSEN1957-03-15—null·(448) 926-8805—3189 Pine DrGlendaleAZ85375——
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
CLMCLM-4174452026-02-01T10:44:08ZCarolyn—Guzman1967-06-08UHC-42076-73-461-310-7599UNKNOWN963 Bayshore Dr·TucsonAZ85739—NAVIGATE-HMO
CLMCLM-4153212026-02-02T09:24:45Z·WAYNE—JACKSON1952-12-22NULLUNKNOWN··-null4411 Willow CtDallasTX·75290GRP-8649-
PRVPRV-240452026-05-20T17:22:05Z·KELLY—DUNCAN1978-09-20··-686-476-4460kelly.duncan@hotmail.com9867 Oak StTampaFL33688—UNKNOWN
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
TPATPA-545152026-05-20T09:41:04ZDebra—Green2007-10-20·NULL•••-••-5139UNKNOWNNULL4502 Spring StMiamiFL33199GRP-8166··NULL
ENRENR-1386712026-03-01T19:27:40ZMartha—West19510813UHC-32314-83•••-••-6274683-471-3620martha.west20@proton.me3664 Pine DriveTempeAZ85218GRP-7543CHOICE-PLUS-PPO
PRVPRV-245082026-05-05T21:50:15ZJulie—·Allen18-07-2006—NULL+1 958 617 9676—455 INDIAN SCHOOL ROADDallasTX75215—N/A
TPATPA-548782026-07-16T14:45:01ZDavid—HarveyDec 3, 1944NULL——null9718 Harbor Boulevard #891DENVERCO80218—-
ENRENR-1162652026-04-14T06:22:59ZPierce, Amy——1698-04-10··UHC-70925-48•••-••-7090·544-643-6868—3002 Main Street·DenverCO80207GRP-4906SELECT-EPO
TPATPA-511922026-02-28T06:35:47ZWei—Ferguson1953-09-09—····+1 769 422 6581WEI.FERGUSON@HOTMAIL.COM1093 VALLEY VIEW DRIVESacramentoCAnull—-
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
CLMCLM-4102992026-02-03T16:05:30ZBruce—Morris01/18/86··•••-••-09927646439587-6865 Mesa DrGilbertAZ85258·GRP-4006MEDICARE-ADV-A
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
PRVPRV-235272026-01-18T05:24:38ZSean—Fuller24-08-1986UHC-36745-76—9424263366—8628 SPRING STCharlotteNorth Carolina28200—··
TPATPA-573322026-10-02T00:45:04ZNoahW.Hall05/18/46UHC-25198-97•••-••-1258—noah.hall@outlook.com7972 Forest AvenueSeattleWashington98119GRP-8248options-ppo
100,000 rows, page 146 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-22T12:42:36.697Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty