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-593792026-03-14T03:44:05ZLINDA—ELLIS1941-02-05null—-———UNKNOWNnullNULLNAVIGATE-HMO
ENRENR-1409072026-02-23T00:07:25ZYuki—Peters1993-07-02UHC-97799-88•••-••-0220(443) 379-1540yuki.peters@icloud.com7982 River RdAtlantaGA30354GRP-8661··NAVIGATE-HMO
ENRENR-1048262026-03-02T21:29:38Zjustin—·mcdonald1955-07-27UHC-37344-03•••-••-61596542666743justin.mcdonald@yahoo.com1863 Hillcrest RdMinneapolisMN55466GRP-9658CORE-HMO
CLMCLM-4008012026-10-06T18:01:01ZRandy—Sanchez1962-01-09·N/A•••-••-5949(647) 882-9925UNKNOWN3993 Elm StreetChandlerAZ85218GRP-0913OPTIONS-PPO
TPATPA-557792026-10-11T23:54:35ZMarilyn··G.Nguyen·1988-11-23NULLUNKNOWN—UNKNOWN7033 Palm DrDallasTX·75277·GRP-3634null
ENRENR-1134682026-03-14T23:25:09ZKnight, Mary——1949-03-23UHC-69884-47•••-••-7177-MARY.KNIGHT74@AOL.COM3855 CAMELBACK RDOrlandoFlorida32893GRP-8788OPTIONS-PPO
ENR ENR-1289492026-09-26T02:02:19ZKellyA.Isabella2/25/1959UHC-28896-64•••-••-7625(450) 593-3422UNKNOWN·2733 SUNSET BLVDDallasTX75215GRP-9531CORE-HMO
TPATPA-519502026-07-20T11:06:03ZWILLIE—·BOYD10/16/04UNKNOWNN/A(762) 624-8254—9492 APACHE BLVDFresnoCalifornia93787··-—
CLMCLM-4282552026-06-10T11:18:04ZMariana—Bennett1966-04-04UHC-64835-32—-—5181 Market StreetSan AntonioTX78274GRP-9717—
TPATPA-623962026-09-10T14:45:43Z CHRISTIAN—KING1952-07-18····null(308) 767-3267—5526 Sunset BlvdTempeAZ85215NULLMEDICARE-ADV-B
CLMCLM-4132832026-04-01T02:44:35ZRivera, SamuelA—1988-07-26-•••-••-245713786441173samuel.rivera@icloud.com4182 VALLEY VIEW DRIVEJacksonvilleFL32271··GRP-2938MEDICARE-ADV-B
ENRENR-1244172026-03-03T17:09:06ZKaylaW.Cunningham19640107UHC-42672-48•••-••-0274(755) 528-0586kayla.cunningham51@yahoo.com8778 Cedar LaneAtlantaGA30356GRP-2006CORE-HMO
CLMCLM-4265512026-03-09T17:52:18ZMason··Palmer20050119·UHC-10433-05—UNKNOWNnull334 LINCOLN WAY··AtlantaGA30351GRP-6564null
PRVPRV-206122026-03-17T12:56:55ZTHOMAS—JOHNSTONJan 26, 1982·UNKNOWN—19517046677thomas.johnston24@icloud.com2797 Market Street·ScottsdaleAZ85273UNKNOWNNULL
CLMCLM-4028562026-02-21T15:46:08ZRobert—Contreras2000-04-08UHC8986973—NULLROBERT.CONTRERAS15@GMAIL.COM4976 HARBOR BOULEVARDLas VegasNV—GRP-4461null
CLMCLM-4113182026-02-09T14:07:59ZROJAS—BTTY1976-12-27nullUNKNOWN(253) 377-4468—3322 Hillcrest RdSacramentoCA95831nullCORE-HMO
CLMCLM-4122782026-07-15T19:06:37Z Terry—Elliott1980-05-20N/AN/A(387) 492-1011UNKNOWN6936 Willow CtTempeaz85260NULLN/A
ENRENR-1117052026-05-10T19:10:45ZLogan·PSantos1945-08-20UHC-63237-32•••-••-0371399-572-2344—431 Palm DriveORLANDO··FL32845··GRP-4522options-ppo
ENRENR-1256962026-07-07T04:19:51ZNicole P—Luna2006-03-22··UHC-74735-63•••-••-8491(430) 369-1195··N/A9760 Washington StreetTempe··AZ85256GRP-6740SELECT-EPO
ENRENR-1191982026-01-04T08:58:08ZDouglasZDuncan1972-11-26UHC-48753-15•••-••-86715616492070null4993 Jefferson AvenueGilbertAZ85205GRP-8362NAVIGATE-HMO
PRVPRV-268032026-10-13T15:59:48ZDominguez, Keith——02/08/1941UHC-93982-60—345.797.0629—null-UNKNOWN—N/ANULL
ENRENR-1142122026-07-16T11:49:08ZSTEVEN—GRRAY09/17/1940—•••-••-5485607-753-6750steven.gray19@icloud.com6033 Camelback RoadNashvilleTN37217·GRP-8832MEDICARE-ADV-B··
ENRENR-1074242026-06-30T20:57:42ZJohn—·Torres1995-01-21UHC-31945-76··•••-••-3650(615) 456-2158NULL6220 OCEAN AVENUEMINNEAPOLISMN55446GRP-2613OPTIONS-PPO
CLMCLM-4207072026-06-19T15:37:31ZPeter—Jenkins1948-05-09N/A•••-••-7129·-UNKNOWN—-null—GRP-3309—
ENRENR-1176662026-06-29T10:05:00ZCamilaZMarshall1940-01-08··UHC-46797-62•••-••-7809337-217-4060camila.marshall51@yahoo.com3494 Ridge Rd Apt 28MiamiFL33128GRP-9581OPTIONS-PPO
ENRENR-1347232026-07-03T03:49:07ZMASONSWEAVER2008-02-06UHC-52861-29•••-••-9172+1 393 809 9648mason.weaver@aol.com5809 HARBOR BLVDMesaAZ85238·GRP-4962CHOICE-PLUS-PPO
ENRENR-1083742026-05-12T08:04:29ZDavid·AMason1950-05-02··UHC-68814-53•••-••-3137237.307.2608DAVID.MASON84@GMAIL.COM9414 Elm StNASHVILLETN37234GRP-0699MEDICARE-ADV-A
ENRENR-136875 2026-05-21T00:50:36ZISABELLA—BELL1965-01-17uhc-68295-82•••-••-4043627-990-1707—8002 Cedar LnEden PrairieMN55383GRP-6030OPTIONS-PPO
ENRENR-1236382026-06-07T17:48:09ZAna—Phillips1959-04-19UHC-41264-27•••-••-0062-··ana.phillips3@icloud.com6304 Meadow LaneTampaFL33640GRP-0564NAVIGATE-HMO
TPATPA-606472026-03-27T10:01:49ZTucker, EdwardH—1966-10-13—•••-••-7347NULL-5509 Lake View Rd··FresnoCA93708GRP-0101····
TPATPA-522382026-02-15T05:29:36ZKAREN—SALAZAR11/7/1977UHC-08069-23UNKNOWN(439) 931-9682karen.salazar@gmail.com5885 Jefferson AveColumbusOH43217GRP-8976NULL
ENR ENR-1400082026-08-16T20:20:27ZVINCENTFDELGADO12-02-1960UHC-58815-25•••-••-6416(740) 212-6774vincent.delgado39@aol.com5442 Sunset BoulevardMiamiFL33162GRP-4598SELECT-EPO
CLMCLM-4278672026-07-22T17:20:51ZHenry—Nguyen03/18/02UHC-95115-21•••-••-4783UNKNOWNhenry.nguyen@hotmail.com5080 Canyon Road··ColumbusOH43273—·CORE-HMO
ENRENR-1145752026-08-16T04:24:32Z Gary—Ford·nullUHC-22231-75•••-••-9093NULL—6247 GRAND AVEMIAMIFL33122GRP-3197SELECT-EPO
ENRENR-1180142026-10-01T05:57:37ZJACQUELINEF.··WILLIS1954-02-17UHC-66165-73··•••-••-9320(506) 602-5599jacqueline.willis29@yahoo.com6072 UNION STREET Apt 37PlanoTX75085GRP-1446SELECT-EPO
CLMCLM-4324472026-01-25T09:21:17ZCHRISTINA—COPER1958-05-08——-NULL6821 Sage CtMiamiFL33179GRP-0479·MEDICARE-ADV-A
CLMCLM-4227792026-01-21T03:56:07Z·DYLAN—LUNA1956-01-18UHC-88278-15··null(530) 554-0651··9845 Camelback Road Apt 21PlanoTexas75073GRP-7444NULL
TPATPA-554262026-09-04T12:22:08ZGABRIEL—ROMEROJun 22, 1952—•••-••-5437—-·NULL—---····
TPATPA-607102026-01-09T14:17:54ZMichelle—Butler2006-04-03——914-917-0067MICHELLE.BUTLER47@HOTMAIL.COM6798 Union St···DallasTexas75261-9195—N/A
CLMCLM-4073062026-06-30T12:37:08ZJudith—Mills1952-01-10···UHC-91879-89··3823471971NULL6622 Oak StreetJACKSONVILLEFL32249UNKNOWN····
ENRENR-1233682026-03-18T11:50:01ZGeraldTSandoval·0128-91-94UHC-41043-56•••-••-79784605688417gerald.sandoval@proton.me1877 Mesa DrMesaAZ85212GRP-2002·medicare-adv-a
PRVPRV-278872026-03-23T00:25:26ZWatson, Keith······08-02-1991UHC-99757-95•••-••-7116+1 710 468 8661null·907 Central AvenueSAN ANTONIOTX78265—UNKNOWN
CLMCLM-4292872026-04-26T16:14:18ZBOBBY—WILSON1994-01-12—null·2094822436—-—null··—GRP-7897NULL
ENRENR-1321662026-05-23T04:26:49ZSofia—·MillerJul 25, 2008UHC-07868-78•••-••-9819234-823-4100null3441 Forest AveHoustonTX77090GRP-5620MEDICARE-ADV-A
PRVPRV-265562026-05-15T01:15:27ZAARON—COLEMAN02-11-1950UNKNOWN•••-••-1501(468) 471-6438NULL5871 Forest AvenueLas VegasNV89192N/A—
TPATPA-609122026-09-24T20:51:13Zjoseph—·olson01/23/51UHC-17116-81null455.446.2453UNKNOWN8346 Desert Sky BoulevardSan DiegoCA·92115—SELECT-EPO
CLMCLM-4257372026-06-30T10:27:27ZARJUNFMARSHALL3/22/1974NULL•••-••-6728·····-4070 Willow CtTampaFL33617GRP-8147-
PRVPRV-220802026-03-12T22:24:24ZDonna—Garza1997-09-22··NULL··—337-566-3352donna.garza@outlook.com8852 Maple AveColumbusOH43299-8470—-
ENRENR-1228172026-01-05T19:54:26ZJUDITHRCASTRO1946-06-18UHC-84515-73•••-••-7866—judith.castro35@icloud.com9281 Baseline RdSAN DIEGOCA92180GRP-5649MEDICARE-ADV-A
ENRENR-1054082026-10-10T07:18:34ZMARIA—DUNN08/17/64UHC-04782-32•••-••-0577—null3948 Hillcrest RoadFRESNOCA·93772GRP-1502CHOICE-PLUS-PPO
100,000 rows, page 71 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:34.791Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty