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
PRV PRV-264872026-09-09T02:23:43ZGaryVHill15950323UHC-08265-40-489-671-3363—1930 APACHE BLVD··SeattleWA98148N/AMEDICARE-ADV-A
PRVPRV-205412026-10-11T17:14:56ZPerez, Judy——1996-05-07—-2814323145—·9661 MESA DRIVEMinneapolisMN55456-1519-null
ENRENR-1249272026-02-03T17:10:54ZCAROLBGIBSON01/10/1941UHC-92939-34•••-••-566813465222203CAROL.GIBSON35@OUTLOOK.COM6007 OAK STREETTempeAZ85235GRP-7004CORE-HMO
CLMCLM-4209732026-10-06T09:42:34ZBrittany··Hudson1966-07-21UHC-45710-24—nullnull1462 Canyon RdMinneapolisMN55447—NULL
ENRENR-1197842026-08-15T19:58:19ZPamela—Austin1943-06-16UHC-05115-47•••-••-28206653008pamela.austin24@icloud.com4921 Grand AvenueScottsdale··AZ85250-4542GRP-7599SELECT-EPO
TPATPA-573602026-02-24T08:55:03ZGrace—Hernandez··1950-12-14—•••-••-1760(207) 528-9147—·1280 SUNSET BLVD Apt 5ChandlerAZ85229nullN/A··
CLMCLM-4208412026-04-12T01:46:55ZHeather—Peterson1980-07-21··UHC-87939-62•••-••-5641223-924-9434null7025 Bayshore DriveCharlotteNCNULLGRP-1081MEDICARE-ADV-A
ENRENR-1225782026-07-15T13:34:24ZRACHELQ.··BURTON1959-08-26UHC-31823-84•••-••-6536(634) 203-5015rachel.burton@proton.me7580 Maple AveEDEN PRAIRIEMN·55354GRP-2806medicare-adv-b
ENRENR-1124032026-07-18T10:02:03ZROBERT—EDWARDS2004-07-11UHC-38119-75•••-••-6337+1 286 616 3981····3734 Desert Sky BoulevardAustinTX78732GRP-1359NAVIGATE-HMO
PRVPRV-215272026-04-09T04:28:28Z·AnnaT.Jordan··2002-11-01NULL•••-••-6699(531) 498-6591UNKNOWN9449 Maple AveAtlantaGA30345null—
ENRENR-1426952026-05-15T22:03:41ZPAUL··AMORRIS8/17/1987UHC-21357-84•••-••-8682(397) 445-6187paul.morris35@yahoo.com·9224 Sunset BlvdLas Vegas···NV·89157-8289GRP-8839··MEDICARE-ADV-A
PRVPRV-242052026-09-08T03:15:31ZWei—Castillo·NULL—N/A(906) 243-9468—2397 WILLOW CTEden PrairieMN55392NULLCORE-HMO
CLMCLM-4029932026-06-14T12:40:31ZGregory—Lee1971-11-13UHC-72345-25•••-••-0012·7274827948····3487 Ocean AveATLANTAGA30326GRP-8238NULL
CLMCLM-4265732026-03-30T20:57:31ZterryAbutlr2008-10-10UHC-98914-41··(258) 664-1575—5887 JEFFERSON AVE Apt 16PlanoTX75041··MEDICARE-ADV-A
ENRENR-1205822026-10-02T10:20:04ZLindaEGreen08/10/70UHC-04889-62•••-••-9904+1 607 782 6178—8032 Valley View DriveLos AngelesCalifornia90038-8247GRP-7112··MEDICARE-ADV-A
PRVPRV-234682026-01-18T04:13:33ZSofiaR.Montgomery20070217UHC-68722-65•••-••-79634656011090··sofia.montgomery78@yahoo.com··9524 APACHE BOULEVARDTampaFlorida33696—UNKNOWN
ENRENR-1095782026-09-15T08:41:28ZPowell··F.·Lisa10/19/1963UHC0570734•••-••-54116445209309lisa.powell@yahoo.com4384 Meadow LnSeattleWA98122GRP-2858CHOICE-PLUS-PPO
PRVPRV-239482026-05-25T08:04:30ZCarlosPLe1944-10-15UHC-07359-80-564-470-7042—null—null—····OPTIONS-PPO
CLMCLM-4056302026-03-16T11:16:20Z·JUDITH—MEYER2002-04-23UHC-98459-56—7408426301judith.meyer92@proton.me6103 RIDGE ROAD·OrlandoFL·32872—NULL
TPATPA-626942026-04-18T23:00:11ZHiroshi—Herrera1979-01-23N/A•••-••-5209-UNKNOWN··4577 Union StreetPlanoTX75018UNKNOWN-
CLMCLM-4037862026-05-11T22:21:19ZWALTER—LUNA04-12-1983N/Anull5946404747—97 Highland AveMinneapolisMN55496GRP-9423MEDICARE-ADV-A
CLM CLM-4298372026-07-05T14:53:11Zteresa—james1987-06-15UHC3622789•••-••-7987620-845-8818—5550 JEFFERSON AVENUEPLANOTX·75084GRP-5099—
PRVPRV-257812026-04-01T01:54:09ZJacobKArnold1945-11-04UHC-45585-13—·429-917-8212·null4195 Jefferson AvenueMinneapolisMN55427——
CLMCLM-4040302026-01-09T19:10:10ZMartha—Bell1965-09-21··UHC-05322-98•••-••-69565259835256—1624 Palm DriveMesaAZ85222—select-epo
ENRENR-1352532026-01-14T05:13:03ZWeiO·Garza05/16/1973UHC-65237-74•••-••-3453831-611-2926··wei.garza@gmail.com4564 Ocean AvenueAtlantaGA30306GRP-9260NAVIGATE-HMO
CLMCLM-4135252026-05-07T11:46:23ZBenjamin··—Peters2006-10-23UHC-96567-22—5195001-8029 Mesa DriveHoustonTexas77014··GRP-4263null
CLMCLM-4106502026-05-14T05:45:02ZHiroshi·····Lynch1025-91-65UHC-75411-44•••-••-1402—hiroshi.lynch@aol.com581 CEDAR LNTampaFL33626UNKNOWN·NULL
ENR ENR-1150012026-02-26T12:40:07ZWatson, KathleenB—2/22/1959UHC-97472-60•••-••-5727·13643213792null2651 Pine DrHoustonTexas77032·GRP-0901·CHOICE-PLUS-PPO
CLMCLM-4029582026-01-26T12:23:42Zkayla—romero6/11/1997UHC-53695-41•••-••-5126557.617.7259NULL18 Central AveGlendaleAZ85309—OPTIONS-PPO
ENRENR-1371632026-02-02T02:04:31ZWard, Meria—····1993-12-23UHC-62524-86NULL362-698-1115N/A7942 Lincoln Way #765PlanoTX·75034GRP-8212MEDICARE-ADV-B
CLMCLM-4067372026-01-21T13:46:07Z Barb—Warren1979-06-15UHC-54834-89····—·UNKNOWN9804 Ocean AveAustin·TX78763-0734GRP-4001—
TPATPA-523912026-10-13T19:08:49ZJOHN—SNYDER04/10/49UHC-19895-89•••-••-4448(921) 492-8644····1460 Church StSan DiegoCA92181····MEDICARE-ADV-A
ENRENR-132694 2026-03-13T10:46:03ZALAN—MENDEZ1999-04-23··UHC-09937-27•••-••-08142705100280null9237 LINCOLN WAYLas VegasNevada89135GRP-6633CHOICE-PLUS-PPO
TPATPA-558552026-05-04T16:47:05ZAmbber—Brown··04-01-1948N/A—7732869431—5547 Hillcrest RdTUCSONAZ··85743-5958null··CHOICE-PLUS-PPO
TPATPA-537892026-06-10T01:44:58ZKathryn—Black1999-08-22—•••-••-7403UNKNOWN—NULLNULL-NULL--
ENRENR-1174822026-05-13T17:34:51ZKathleen—Oliver91490302UHC0605818•••-••-9372(845) 642-0416-3595 Spring StTampaFL33603GRP-3860CORE-HMO
TPATPA-619392026-09-28T06:13:50ZKyle··Cook20-06-1963—null19472163495UNKNOWN8422 Hillcrest RoadTAMPAFL33671--
CLMCLM-4166222026-07-08T08:13:18ZWAYNE—BAILEY7/10/2007UNKNOWN—707-729-0054—8816 FOREST AVENUE Apt 19PHOENIXAZN/A—····
ENR ENR-1253862026-07-12T19:08:43ZStephenHAlexanderFeb 1, 2006UHC-25900-07•••-••-7718267-215-3210stephen.alexander68@yahoo.com4982 MAIN STEden PrairieMN····GRP-2042NAVIGATE-HMO
CLMCLM-4284692026-04-03T17:02:37ZJoan—Allen19671222UHC-42345-40——-7075 Harbor BlvdOrlandoFlorida32822GRP-3215MEDICARE-ADV-B
ENRENR-126381 2026-09-22T01:25:06ZJUUANE.PADILLA2004-10-21UHC-00148-63—7244135479JUAN.PADILLA49@ICLOUD.COM2287 CEDAR LNSan AntonioTX78260GRP-3055MEDICARE-ADV-B
ENRENR-1306292026-10-10T08:31:12Z ELIJAH—SHAW1988-05-16UHC-98614-28•••-••-7579(752) 578-3872—1204 Cedar LnMinneapolisMN55466GRP-7323NAVIGATE-HMO
ENR ENR-1010462026-08-27T11:04:09ZDeborah—Butler2/19/1994UHC-90382-97•••-••-7538nullN/A6452 Church StreetSAN ANTONIOTexas··78232GRP-1777OPTIONS-PPO
PRVPRV-288332026-06-16T04:44:47ZJesseD.Wang05/04/1951UHC-64399-80-562-790-3791-4970 Grand AveChandlerAZ85245—UNKNOWN
ENRENR-1124212026-01-03T01:34:19ZEMILY—STEWART11/5/2005UHC0933670•••-••-0137727-601-0399emily.stewart18@icloud.com4286 Forest Avenue #201AtlantaGA30366GRP-4810OPTIONS-PPO
PRV PRV-286472026-03-04T16:12:24ZRebecca E—Cox1997-02-09UHC-65252-88N/A3582509037—8322 SAGE CTOrlandoFL32858NULLnull
ENRENR-1239942026-07-06T10:04:46ZYuki—Barnes··19570403··UHC-87254-53•••-••-1104(779) 535-7853·null63 WILLOW CT Apt 27TucsonAZ85750-6856··GRP-5805MEDICARE-ADV-B
ENRENR-1274542026-04-24T05:55:37ZChristine··Simmons1969-07-11UHC-21756-63•••-••-68998657541704-5236 Cedar LnMesaAZ85281·GRP-0790MEDICARE-ADV-B
TPATPA-573132026-07-12T22:48:32ZBUTLER····DYLAN1971-06-18null-12456384148—5807 Church StreetHoustonTexas·77095NULLnavigate-hmo
ENR ENR-1244322026-08-22T02:48:51ZGraham, Lauren——1979-06-03UHC-12369-48•••-••-565914347087361··LAUREN.GRAHAM@HOTMAIL.COM7492 Jefferson AvenueScottsdaleAZ·85207GRP-2897CHOICE-PLUS-PPO
100,000 rows, page 13 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-19T19:54:25.416Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty