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-140329 2026-09-21T18:00:42Znatalie—mendez2004-09-09UHC-08282-03NULL(734) 263-5192natalie.mendez54@outlook.com2534 Mesa DriveEden Prairie··MN55326-1674GRP-9331SELECT-EPO
PRVPRV-21912 2026-04-02T17:54:28Zjoan—estradaSep 22, 1989NULL··NULL726-445-1391-5173 Highland AvenueNashvilleTennessee37298—-
CLMCLM-4265872026-10-12T08:14:30ZJacob—Jimenez11/07/1983—•••-••-5669·710-301-7058NULL·1086 OCEAN AVEHouston··tx77041GRP-9790CHOICE-PLUS-PPO
ENRENR-1244452026-08-11T00:58:59ZDaniellePDay2005-07-09UHC-21529-84•••-••-2840·5927859778danielle.day@outlook.com6548 Washington StreetHoustonTX77088GRP-2893CORE-HMO
ENRENR-1175142026-07-04T12:18:03ZJOSHUAYHAWKINS1942-02-02UHC-04131-49•••-••-6358349.566.2578joshua.hawkins@gmail.com··4435 Union StreetSAN ANTONIO·Texas78204GRP-9866CORE-HMO
ENRENR-1177312026-06-12T04:23:31ZAUSTINK.HARTJan 22, 1999UHC-70253-84•••-••-284213044549959—NULLN/AN/AUNKNOWNGRP-7865options-ppo
CLMCLM-4320482026-04-09T05:20:26ZNATHAN—HERNANDEZ1998-90-28UHC-51466-53•••-••-388016626810799—7291 Union StFresnoCA93756GRP-1010CORE-HMO
ENRENR-1389532026-05-03T23:45:31ZSEANJVEGA1996-02-13UHC-58043-65•••-••-2469(527) 384-0197sean.vega@outlook.comNULL—N/A—GRP-5340OPTIONS-PPO
PRV PRV-217732026-06-12T10:46:41Zlaura—perkins1956-09-28—-820.677.8065laura.perkins@icloud.com·5448 Baseline RoadMinneapolisMN··55493-—
CLMCLM-4114122026-04-28T04:04:36ZSCOTT—ELLIOTT1983-11-11UHC-82085-28•••-••-075515012428848-5169 BroadwayAUSTINTX78704—MEDICARE-ADV-B
CLMCLM-4178312026-07-21T08:22:41ZJESSICA—MARTINEZ1992-08-15UHC-78420-75•••-••-2932+1 287 250 4621—4361 Forest AveSacramentoCAN/AGRP-9770—
ENRENR-1115892026-07-24T04:42:36ZEMMAZ.DAVIS20060314UHC-54291-61•••-••-0085·NULLemma.davis68@icloud.com2197 Grand AvenueTUCSONAZ85739GRP-7810·CORE-HMO
PRVPRV-252292026-06-24T21:49:31ZMatthewPRiec1999-03-22N/A··•••-••-32198689471631-··6058 Apache BoulevardHoustonTX77066-3977····—
PRVPRV-266742026-03-02T04:11:21ZBeverly—Nunez2004-02-22UHC-70757-60—8342549266BEVERLY.NUNEZ@ICLOUD.COM9033 Washington StMinneapolisMN55439—MEDICARE-ADV-A
ENRENR-1043352026-03-31T22:55:47ZLawrenceMBure1951-03-07UHC5870565•••-••-3890488-783-5554lawrence.burke40@yahoo.com1137 Palm DriveGILBERTAZ85259GRP-5520MEDICARE-ADV-A
TPATPA-607112026-01-08T19:34:27ZALEXIS—CASTRO01/10/91··--—4926 UNION STREETGlendaleAZ85328-NULL
ENRENR-1097352026-01-19T20:36:27ZKyle—Garcia1950-11-15UHC-39892-95•••-••-2355(839) 254-8873kyle.garcia@proton.me9830 Church StreetSan DiegoCA92173-3570GRP-7525MEDICARE-ADV-A
ENRENR-1207492026-02-02T14:13:45ZahmedGlee2000-04-26··UHC-13172-99—7472577129ahmed.lee@aol.com1909 OCEAN AVEHoustonTX77082GRP-3560CHOICE-PLUS-PPO
CLMCLM-4174742026-03-08T03:32:27ZWilliam—Patterson02/18/74UHC7067352-UNKNOWN-9035 Sunset BoulevardMIAMIFL33172-medicare-adv-b
TPATPA-556502026-02-07T15:09:35ZRYAN—GRANT27-09-1989···NULL•••-••-4542—NULL6174 Valley View DriveTucsonArizonanullGRP-4283CHOICE-PLUS-PPO
CLMCLM-4111792026-01-24T08:56:36ZJean—Morrison01/18/1942null•••-••-3090(892) 970-7534-1239 Spring StTampaFlorida33615GRP-6122—
ENRENR-1163412026-01-24T18:17:35ZBruce··—Yang02/10/1955UHC-72059-81•••-••-8748NULLBRUCE.YANG72@ICLOUD.COM578 WILLOW COURT Apt 1MIAMIFL33193GRP-3169SELECT-EPO
ENRENR-1114192026-02-07T16:33:30ZAMANDAXCONTRERAS1967-03-10UHC-79344-55•••-••-8659890-248-3447—6242 Elm Street··ScottsdaleAZ85269GRP-2448SELECT-EPO
ENRENR-1304792026-01-15T21:58:50ZDanielleMGilbert08-01-1950UHC-98391-19•••-••-604913847173751danielle.gilbert@gmail.com5661 Highland AvenueTucsonAZ85747GRP-1247NAVIGATE-HMO
ENRENR-1200222026-07-09T21:30:45ZWilliie—Graham1956-12-06UHC-51883-84··•••-••-86736809425274-··4737 Washington StPhoenixAZ85049GRP-2679MEDICARE-ADV-A
PRVPRV-245152026-08-31T13:12:03ZBrandonGRivera1991-04-07UNKNOWNUNKNOWN+1 773 552 1965null··5041 Jefferson AveGlendale··AZ··85328N/A··
CLMCLM-4162002026-07-20T10:34:58ZJeremyZWilliamson09-05-2001UHC-36275-30N/AN/A··9294 MAPLE AVESan Antonio··TX78298GRP-6662NAVIGATE-HMO
ENRENR-1115652026-03-26T07:50:25ZLindaB.Wang1951-03-02UHC-62194-36•••-••-93085513530861LINDA.WANG@GMAIL.COM4440 BROADWAYAUSTINTXUNKNOWNGRP-1498NAVIGATE-HMO
ENR ENR-1056002026-06-07T01:09:09ZGABRIEL—RUSSELL-UHC-05189-61•••-••-3013(617) 588-4034gabriel.russell84@yahoo.com4477 WASHINGTON STColumbusOH43258GRP-5373·CORE-HMO
CLMCLM-4309932026-03-02T11:13:13ZSofia—Webb1960-12-02UHC-18146-96•••-••-0631·(729) 820-0070—265 Ridge Rd··TampaFL33645GRP-6026null··
CLMCLM-4098172026-09-02T13:23:22ZHiroshiFRce1947-09-04N/A•••-••-8954UNKNOWNUNKNOWN5783 Oak StreetJacksonvilleFL·32271GRP-8213—
TPATPA-518262026-10-10T23:41:28ZMATTHEW—DAY1949-03-08N/A—3868458370—4162 CEDAR LNTempeaz··85261-6869GRP-9752—
ENRENR-1268302026-01-16T01:01:29ZLaurenLMartin1969-10-25UHC-08305-01N/A5286187478—7667 Willow CtSacramentoCA95898GRP-8053MEDICARE-ADV-B
ENR ENR-1423582026-10-04T13:28:42ZSARAO.··WARREN1960-10-23NULL•••-••-95207376697523SARA.WARREN92@GMAIL.COM1795 Desert Sky BlvdDallasTX—GRP-0220CORE-HMO
CLMCLM-4312482026-07-24T12:43:50Zkatherine—jenkins12/03/1941—-null—6551 DESERT SKY BOULEVARDScottsdaleAZ85284—N/A
ENRENR-1231442026-04-04T19:27:25ZDenise—PetersonOct 12, 2006UHC-84776-24•••-••-6359(399) 872-2277denise.peterson7@aol.com3782 Main StreetSACRAMENTOCA95896GRP-6038CORE-HMO
CLMCLM-4039202026-02-03T06:38:06ZzacharyG.carlson10/23/03NULL•••-••-2089·UNKNOWN·NULL6475 Jefferson AvenueDenverco80273··GRP-4758CHOICE-PLUS-PPO
ENRENR-1138692026-06-08T16:10:37Zmargaret—spencer1955-02-23UHC-91658-38•••-••-55742502905224N/A4242 Baseline RoadPlanoTX75047GRP-1001MEDICARE-ADV-B
ENRENR-1371252026-09-17T00:47:11ZJONATHANZKENNEDY1961-12-02UHC9629149•••-••-8335262-488-3407JONATHAN.KENNEDY2@GMAIL.COM2767 Grand AvenueTampaFL33605GRP-8224NAVIGATE-HMO
ENRENR-1259962026-07-20T16:02:54ZjudyR·cox1986-12-06UHC-67971-10•••-••-9678—-6375 Baseline RdSan Diego·CANULLGRP-5030MEDICARE-ADV-A
CLMCLM-4175812026-01-11T00:11:40ZHenry—Graham·Apr 4, 1969UHC-16030-05·-815-263-3479-46 Grand Ave Apt 17PlanoTX75023UNKNOWNMEDICARE-ADV-A··
ENRENR-1106972026-10-05T22:24:20ZSHIRLEYH·WELCH19441110UHC-57883-65•••-••-328815096102614SHIRLEY.WELCH41@OUTLOOK.COM5380 Washington StMiamiFlorida33147··GRP-9930·NAVIGATE-HMO
ENRENR-1116142026-08-29T04:06:21ZBETTY·HMARQEZ9/1/1981UHC-53331-51•••-••-96596003625515betty.marquez63@outlook.com4089 Sage CourtTampaFL·33688GRP-0860SELECT-EPO
CLMCLM-4126982026-01-18T03:51:06ZNathan—Franklin08/05/1942UHC-12055-16•••-••-0784883.240.3615N/A3003 Sage CtChandlerArizona85202-5852-UNKNOWN
PRVPRV-229672026-05-06T07:51:14ZPaul—Bryant1941-11-16UHC-60881-82-290-375-2486—2302 Sage CourtLos AngelesCA90001-null
ENRENR-1330682026-08-03T08:02:32ZNoahA··Olson2001-05-14UHC-28379-03•••-••-6653+1 279 581 7329noah.olson8@yahoo.com7807 Palm DrScottsdaleAZ85228··GRP-7845NAVIGATE-HMO
ENRENR-1190142026-01-20T16:53:32ZAshley—Mejia02/15/1941UHC-36724-72•••-••-4002598-430-4073NULL··1713 UNION ST···Austin·TX78733GRP-1140MEDICARE-ADV-B
ENRENR-1206552026-04-27T13:44:07ZJACQUELINEJBERRY1961-10-07UHC-46209-94•••-••-7036(518) 594-2960null351 Forest AveLAS VEGASNVnullGRP-1836NAVIGATE-HMO
CLMCLM-4247192026-09-30T21:56:59ZPaul M—Gordon1954-05-19—UNKNOWN6838472125—9470 CAMELBACK RDMiamiFL33165GRP-0510OPTIONS-PPO
TPATPA-604192026-06-17T16:51:20ZCarlos—Ortega1985-05-15UNKNOWNUNKNOWN7852825408null—N/A——GRP-7313MEDICARE-ADV-A
100,000 rows, page 118 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.684Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty