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-1330572026-06-06T16:04:43ZPtaterson, NicholasE.—·09-10-1966UHC9291336•••-••-66944209904362·nicholas.patterson62@icloud.com8555 Valley View DrNashvilleTN37296GRP-3071OPTIONS-PPO
ENRENR-1241122026-02-26T20:26:20ZKELLYKGARDNER1969-11-19N/A•••-••-22163255514310KELLY.GARDNER31@AOL.COM6746 CENTRAL AVEMESAAZ85232GRP-2864CHOICE-PLUS-PPO··
CLMCLM-4243542026-07-22T19:34:01ZHenry—RuizFeb 13, 1992UNKNOWN•••-••-91629188487342UNKNOWNnullnullnull····NULL—
CLMCLM-415340 2026-01-10T00:32:57ZMARGARET—FOSTER1970-07-13UHC-64307-23•••-••-5068973.249.4998UNKNOWN3524 BROADWAYDallasTX75276GRP-4417—
CLM CLM-4215382026-07-10T10:35:30ZCharles—PayneOct 6, 1954UHC4457547•••-••-6906·(264) 687-3784—4594 Ocean Avenue Apt 3AtlantaGA30368GRP-9616—
ENRENR-1076892026-09-05T04:18:44ZSofiaO.Duncan06/28/38-•••-••-335617576423281—2365 River RdDenverCO80217-6885GRP-6321MEDICARE-ADV-B
ENRENR-1056992026-07-01T19:03:25ZKyleBGuzman1/15/1954·UHC-10602-08•••-••-08894266404283NULL··4117 Central AveSAN ANTONIOTX78258GRP-7866CHOICE-PLUS-PPO
ENRENR-135005 2026-01-16T15:25:44ZAbigail G—Young19920227UHC-96753-20•••-••-0881588.731.5256abigail.young20@aol.com9294 Indian School Road Apt 16Los AngelesCAnullGRP-4738MEDICARE-ADV-A
CLMCLM-4062852026-08-30T05:08:42ZDouglas—Hill··1959-03-08UHC7502583nullNULLdouglas.hill13@icloud.com2821 Jefferson AveColumbusOH43254GRP-5502CORE-HMO
ENRENR-1302842026-05-24T04:39:24ZSanda—Allen·09/15/1953uhc-81023-98•••-••-0465——7497 CANYON ROADTempeAZ85235GRP-6656·CHOICE-PLUS-PPO
ENRENR-1235332026-05-28T09:19:50ZStevenBButler1948-12-19UHC-75930-09··•••-••-1604(831) 606-0927null3328 Lake View RdAustinTX78765GRP-2020MEDICARE-ADV-B
CLMCLM-4154672026-04-14T14:26:24ZZachary—Munoz6/21/1971N/A—NULL—6721 BROADWAYLos AngelesCalifornia90014GRP-4716null
ENR ENR-1406302026-08-01T23:05:35ZKimberlyYWright9187-09-02UHC-39402-30•••-••-0441+1 929 624 1168kimberly.wright22@proton.me4002 Market StNashvilleTennessee37271GRP-2277OPTIONS-PPO··
PRVPRV-24407 2026-02-07T20:52:31ZAaron—Stone1966-01-28UHC-20090-06•••-••-2015(780) 224-3948NULL·14 Park PlGilbertAZ85205N/A·SELECT-EPO
PRVPRV-287232026-07-09T03:44:38ZGuerrero, Kayla——·Apr 5, 1974··•••-••-0061303-463-4451kayla.guerrero@hotmail.com9734 Desert Sky BoulevardNashvilleTennessee37237-3432··N/A—
CLMCLM-4152722026-09-21T15:06:09ZKimberly—MarquezMay 15, 1942UHC-94929-40•••-••-03882302544KIMBERLY.MARQUEZ@AOL.COM1432 VALLEY VIEW DRIVELas VegasNV89170GRP-3132—
CLMCLM-4020752026-07-11T02:08:35ZBuyd, MichaelZ—1992-07-23UHC-19257-78N/A(397) 543-1757-5328 Ridge RdSAN ANTONIO·TX78231GRP-7333·MEDICARE-ADV-A
ENRENR-1344192026-05-30T04:15:50ZbryanY.bradley—UHC5603471•••-••-33862126093209·bryan.bradley23@icloud.com5040 Oak StMiamiFL··33161GRP-0275NAVIGATE-HMO
CLMCLM-4129632026-02-19T10:49:12ZAmanda—Montgomery1969-03-19null•••-••-8990--6520 Harbor Boulevard·PlanoTX-·GRP-9857—
ENRENR-1109402026-07-19T07:13:34ZVICKYYJAMES1946-03-05UHC-93973-31•••-••-427013277420415VICTORIA.JAMES@AOL.COM4992 Hillcrest RdDenverCO80219GRP-4207OPTIONS-PPO
ENRENR-1386052026-06-08T17:21:15ZOMARXFORD01-08-2003UHC-27228-51•••-••-5713967-523-2713·omar.ford@aol.com2289 Ridge Rd···SAN ANTONIOTexas78299··GRP-9221NAVIGATE-HMO
ENRENR-1088612026-01-13T17:37:08Zeddward—delgado1/16/1986UHC-98565-10··•••-••-2381+1 445 317 6477edward.delgado@hotmail.com8051 Market StreetAtlantaGA··30380-1971GRP-4393CORE-HMO
CLMCLM-4280242026-06-14T21:09:12Z BRUCE—PARKER2008-03-02UNKNOWN•••-••-3100545-568-5259NULLN/A—UNKNOWN··GRP-0707—
TPATPA-543092026-10-09T02:33:55ZANA—CUNNINGHAM19720303UHC-35095-35-(454) 799-9463N/A1845 DESERT SKY BOULEVARDScottsdaleAZ85299UNKNOWN—
ENRENR-1250452026-02-10T22:43:34Z WalterM.Gilbbert5/27/1963UHC-67455-85•••-••-51814285885393—2595 Maple Avenue·ChandlerAZ85266··GRP-6605MEDICARE-ADV-A
TPATPA-611002026-07-16T17:22:55ZRachel—Nunez··Jun 25, 1959—····N/Arachel.nunez3@gmail.com3897 MARKET STREETTampaFL33692·GRP-4845—
ENRENR-1163612026-07-08T03:05:41ZNICOLE—ELLIS1956-04-26UHC4622728•••-••-2394·9567801821nicole.ellis@yahoo.com8243 Central AvenuePhoenixAZ85044GRP-7682CORE-HMO
PRVPRV-278342026-03-10T06:30:25ZJanetAJimenez03/12/62-•••-••-56603008720717janet.jimenez16@gmail.com4320 Ocean AvenueLas VegasNV89175——
ENRENR-1267392026-02-16T01:32:58ZJoshua—Bell1982-01-09UHC-11814-06•••-••-6150+1 814 983 1571JOSHUA.BELL@HOTMAIL.COM2664 Lincoln WayMiamiFL33196GRP-8468MEDICARE-ADV-A
ENRENR-1246622026-01-31T06:17:23ZDYLAN—·PERRY12-11-1991UHC0469913•••-••-5532940-243-8613dylan.perry@aol.com1794 Cedar LnDENVERCO80244GRP-7637OPTIONS-PPO
ENRENR-1059262026-10-01T20:16:33ZHenryY.Little·0306-19-97UHC-90229-54•••-••-24064777783428—6925 Hillcrest RoadPlanoTX··75017GRP-0962SELECT-EPO
TPATPA-608542026-05-19T20:19:04ZJanice—Jordan··1966-03-24····N/A··——774 Washington Street··NashvilleTN37275——
ENRENR-1339872026-02-06T11:40:14ZAshleyPBryatn2001-60-04UHC-46537-83•••-••-8345553.610.7150ashley.bryant@outlook.com7372 Pine DriveMiamiFL··33162GRP-9311··NAVIGATE-HMO
PRVPRV-283862026-09-22T13:05:16ZKeithOTran1998-05-08--+1 812 276 3352·UNKNOWN8577 Highland AvenueFresnoCA93722——
ENRENR-1214232026-09-12T06:01:37ZLinda—Berry··1952-07-22UHC-94854-16•••-••-2091908-565-1714N/A5051 SUNSET BOULEVARDMinneapolismn55413-8824GRP-2493OPTIONS-PPO
CLMCLM-4280292026-01-26T05:00:22Z·Kaern····Clark01/28/1956UHC-04799-83··•••-••-9192null—·7273 Mesa Drive·OrlandoFL32814-CHOICE-PLUS-PPO
TPATPA-580852026-05-30T10:41:12ZDoris—Peterson1989-06-09UNKNOWNnullnullnull5401 DESERT SKY BOULEVARDFRESNOCA·93753—NULL
ENRENR-1041832026-06-03T10:48:59ZYUKI—RICHARDSON19820208UHC-64259-10•••-••-2936+1 614 433 0688yuki.richardson@outlook.com2434 Forest AvenueEden Prairie·MN55340GRP-0444NAVIGATE-HMO
CLMCLM-430365 2026-07-07T18:32:46ZAndrea—Ortiz1980-09-18N/ANULLN/A—662 Union StTUCSONAZ85792··GRP-9784-
CLMCLM-4035292026-09-19T14:08:16ZMARIA—CHAVEZ·05/25/1966UHC-22088-39•••-••-9169nullN/A9462 Mountain View Drive #944AtlantaGA30318GRP-1083MEDICARE-ADV-B
PRVPRV-226582026-01-09T09:19:01ZBradley—Belll··10/15/89-•••-••-417916273622857—8241 Meadow LnJacksonvilleFL32268——
ENRENR-1006602026-09-03T03:08:39ZOlson, SophiaY—·1971-08-04UHC-24314-77•••-••-0471nullUNKNOWN4458 Mesa DrLas VegasNV89169-9801GRP-3910CHOICE-PLUS-PPO
CLMCLM-4117022026-09-28T15:43:56ZRobinson, Wei——1985-07-06—•••-••-1739—WEI.ROBINSON@YAHOO.COM-—null—-MEDICARE-ADV-B
ENRENR-1301262026-08-21T15:49:47ZAshley··Hudson·1972-10-24UHC-94895-79NULL371-225-0580ashley.hudson46@aol.com56 Central AvenueDallasTX75223GRP-5537OPTIONS-PPO
CLMCLM-4197702026-01-09T08:53:37ZHANNAH—SCHULTZ1980-07-03-N/ANULL·UNKNOWNnull—nullUNKNOWN··GRP-2256null
CLMCLM-4238762026-02-12T03:47:30ZJoshuaOBurke17-02-2005UHC-01003-36—442.879.1389······-N/AN/A—GRP-5195UNKNOWN
CLMCLM-409869 2026-05-29T18:01:45ZPaulONelson1938-02-01UHC-97618-19•••-••-3032NULLUNKNOWN—null——NULL—
ENRENR-1122432026-09-10T10:37:17ZLaura·DWallace12/10/47UHC-16225-98•••-••-3105(642) 614-9549LAURA.WALLACE@YAHOO.COM9541 Indian School RdAustinTX·78733GRP-9181core-hmo
ENRENR-1122372026-06-18T20:06:58ZRaymondI.Campbell2002-11-15UHC8838596··•••-••-57765217027raymond.campbell75@yahoo.com5500 Ocean AveGlendaleAZ85328GRP-7707··CHOICE-PLUS-PPO
ENRENR-1011762026-08-29T17:51:22ZAshley··—Thomas1983-03-07UHC-49242-29—404-225-6977-7181 Ocean AvenueTampaFL33642··GRP-3924CHOICE-PLUS-PPO
100,000 rows, page 103 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.678Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty