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

Provider network only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
PRVPRV-272042026-08-23T23:51:09Z Gerald—Olson2002-01-08N/A-310-464-4629null5297 PINE DRJacksonvilleFL32246····CORE-HMO
PRVPRV-201232026-06-13T12:13:52ZChen, Jacqueline——1997-08-07N/A-2478775jacqueline.chen31@aol.com5143 GRAND AVE··LOS ANGELESCA90011UNKNOWN—
PRVPRV-225852026-10-02T01:41:04ZSusan—·Chavez1982-09-21NULL····(323) 361-0184·-·6323 Camelback RoadCHARLOTTE·NC28229NULLnull
PRVPRV-277162026-01-16T15:11:46ZKEVINLTUCKER1951-06-09·UHC0135875—323-521-3877UNKNOWN1128 HARBOR BLVDColumbusOH43242—N/A
PRVPRV-203442026-03-02T23:24:20ZThomasVWest1961-12-16UHC-63916-28-5476178107·THOMAS.WEST@PROTON.ME5325 Hillcrest Rd Apt 15DALLASTX75211UNKNOWNUNKNOWN
PRVPRV-216182026-02-22T00:21:00ZSofia—Sims·1954-06-06UHC-52577-70null552-220-3187—7390 Washington StFresnoca93796UNKNOWN—
PRVPRV-229292026-09-22T05:10:46ZBOBBY—WALSH05/01/2002—·UNKNOWN588.401.9411bobby.walsh@outlook.com5749 Mountain View DrHoustonTX77041NULLN/A
PRVPRV-283202026-05-04T10:31:59ZPhilipX.Gray1982-01-06UNKNOWNNULL··(412) 926-5674··—6954 SAGE COURTDallas·Texas75214-—
PRVPRV-255642026-01-17T21:14:55ZKathynXMillsFeb 24, 2008null•••-••-6933933-994-9389-2641 Ocean AvenueMiami·FL33111——
PRVPRV-288912026-05-29T21:07:45ZSantiago—Palmer2008-12-05UNKNOWNNULL··UNKNOWN··9709 Ridge RdNashvilleTN37258NULLUNKNOWN
PRVPRV-200652026-03-27T22:05:26ZDEBORAHT.MURRAY4/24/2003UHC-81038-07UNKNOWN—NULL3737 Baseline RdScottsdaleArizona85253-9027—NULL
PRVPRV-280152026-04-07T03:10:19ZbrendaE·stewartMar 28, 1958UHC-39537-90NULL(339) 479-1544N/A·2741 Hillcrest RdMiamiFL33143N/ANULL
PRV PRV-256152026-05-19T23:04:28Z JOSEPH—CARPENTER1942-01-28UHC-79380-69-219.736.1619joseph.carpenter16@icloud.com874 Main StTucsonArizona85713N/ANULL
PRVPRV-223842026-03-18T17:59:44ZJoan—Morris2007-12-21UHC-13242-98—646.270.4805—7097 PINE DRSan DiegoCA92140nullMEDICARE-ADV-A
PRVPRV-212912026-02-04T18:51:39ZDanQAllen11/27/1944—N/A(233) 223-8726NULL9804 CAMELBACK RDHouston··Texas———
PRVPRV-285822026-09-08T12:02:33ZNancy—Fields···1983-01-08··—6887513580N/A900 Palm Drive Apt 38ScottsdaleAZ85282UNKNOWNNAVIGATE-HMO
PRVPRV-254752026-01-15T01:54:26ZJordanY.Hill24-05-1979—•••-••-83512466149749UNKNOWN9487 CHURCH STTampaFL33695-NULL
PRVPRV-230962026-05-05T06:39:50ZBRIAN—GARCIA1948-10-17null—790-630-5029null678 Church StreetTampaFL33625--
PRVPRV-232052026-06-02T21:06:41ZWeiHGardner12-07-1966NULL•••-••-5877·(582) 567-9306wei.gardner54@proton.me7036 Central AveSAN DIEGOCA··92132·N/AMEDICARE-ADV-A
PRVPRV-283302026-10-04T17:04:22ZJeremy—Mason1962-12-28——8153981570NULL4853 Apache BoulevardJacksonvilleFL32253-—
PRVPRV-265862026-01-06T10:41:25ZSHIRLEY—·POWEL1968-11-08—•••-••-79946714997328N/A7652 Ocean AvenueSeattleWA98160NULL··
PRVPRV-288522026-04-21T00:49:44Zaustin··—miller2000-11-16UHC-05857-13·NULL17426838444··1627 Church Street··MINNEAPOLISMN55476N/AUNKNOWN
PRVPRV-263882026-03-21T02:00:02ZSantiago——1972-01-21NULLnull(241) 730-0455—172 Jefferson AveGlendaleArizona85363null—
PRVPRV-232402026-02-24T20:12:18Zmason R—wagner04/13/1966——(229) 768-1839—6319 JEFFERSON AVENUEMiamiFL··33175N/AUNKNOWN
PRVPRV-25409 2026-09-06T17:11:29ZMARIANAVFOWLER1986-11-05··uhc-92162-53—(323) 821-1928—6958 Mountain View DrSCOTTSDALEAZ—UNKNOWNNULL
PRVPRV-249722026-04-07T12:55:21ZAdam—Li01/18/45UHC-03793-43•••-••-8984—-51 Oak StreetHoustonTX·77050N/A-
PRV PRV-20600 2026-07-09T13:57:42ZROGER—BRYANT1995-03-09——UNKNOWN—1117 Forest AvenueGilbertAZ85212—·NULL
PRVPRV-242582026-09-16T00:40:05ZnancyR.cole··04/25/2002UHC-89188-42——nancy.cole27@proton.me8672 Bayshore DriveAtlantaGA30324N/AN/A··
PRVPRV-210102026-02-22T15:50:38ZsandraNharper19460910UHC-48277-68NULL—sandra.harper@icloud.com7685 Jefferson AvenueDenverCO80212UNKNOWNN/A
PRVPRV-265812026-03-23T17:45:03ZJacob····Anderson7/6/1939——502-554-7768-2590 Maple AveSeattleWA98194nullnull
PRVPRV-27378 2026-06-29T02:49:36Z·Simpson, Mary——1957-08-17—•••-••-9908·N/Amary.simpson@icloud.com9133 River RoadJacksonvilleFL··32221-8053nullN/A
PRVPRV-267352026-04-20T05:01:41ZVincent—RussllJul 1, 1998··N/A·-728-381-0394—1656 Maple AvenueEden PrairieMinnesota55319null—
PRVPRV-226862026-01-26T16:29:11Z·CHERYL—STEPHENS··6/25/2008—NULL942-365-8387——UNKNOWN-N/A-MEDICARE-ADV-A
PRVPRV-228012026-10-07T19:23:31ZAISHA—STEPHENS04/17/1996—UNKNOWN(706) 504-4094AISHA.STEPHENS@GMAIL.COM2778 Valley View DrMinneapolisMinnesota——NULL
PRVPRV-241022026-05-10T20:45:51ZMary—Owens01/19/43N/A-UNKNOWNUNKNOWN726 SUNSET BOULEVARDAtlantaGA30394null—
PRVPRV-244112026-09-08T21:00:48ZGacria, Ben——1939-10-07UHC-62566-50NULL(716) 668-0938····5928 MARKET STREET #415JACKSONVILLEFL32254——
PRVPRV-294122026-07-26T20:39:56ZDIANE—CHAVEZ1971-09-18null—(306) 976-9457diane.chavez@outlook.com··7566 MOUNTAIN VIEW DRJacksonvilleFL32255NULLN/A
PRVPRV-255852026-05-09T14:20:50ZBryan—Morris1944-12-09·UHC-75126-91null3758720481bryan.morris82@yahoo.com————nullnull
PRVPRV-264662026-02-20T08:38:05Z Flores, Rachel——04/19/01UHC-51774-44UNKNOWN+1 476 851 5262—4893 CENTRAL AVENUEHoustonTX··77060—NULL
PRVPRV-200402026-04-11T17:44:15Z·Hannah—Campbbell04/15/2007—UNKNOWN(325) 517-8293hannah.campbell@gmail.com9710 CANYON ROADPhoenixAZ85099-UNKNOWN
PRV PRV-250562026-02-05T07:16:18ZPamelaBBrown4/7/1967UNKNOWN—15345773386pamela.brown@aol.com2433 Park PlSacramento··CA95874NULLNAVIGATE-HMO
PRVPRV-242642026-02-19T08:40:14ZJUDITH—HOWELL·1993-05-02UHC2098503NULL(554) 478-3967··—5164 PARK PLHouston··TX77081··——
PRVPRV-222392026-06-06T03:15:04Z ISABELLA—MITCHELL··1982-12-01·UHC-75813-49NULL8337065null1147 CANYON ROADChandlerArizona85200UNKNOWN—
PRVPRV-263682026-09-08T12:40:20ZWashington, Santiago——1994-08-02—•••-••-57263645520274null6554 Ocean AvenueCharlotteNC28228—-
PRVPRV-204602026-06-23T08:11:27ZGerald—Sullivan1938-07-08UHC3200978—4887059377gerald.sullivan35@gmail.com5553 GRAND AVEDALLASTX75264N/AUNKNOWN
PRVPRV-246752026-02-07T01:34:48Zroger—moreno1987-02-24—NULL(808) 769-2396··roger.moreno26@aol.com8883 Meadow LnSacramentoCA··95863UNKNOWNNULL
PRVPRV-292062026-09-15T23:48:43ZLERRY—HUNT·2006-04-09N/AN/A5292811209larry.hunt@aol.com7696 Desert Sky Boulevard·San AntonioTX78273NULLMEDICARE-ADV-A
PRVPRV-242232026-03-02T22:47:24ZJanice—Richrds1938-06-13··UHC-36443-23UNKNOWN+1 604 331 7216UNKNOWN2622 JEFFERSON AVENUECharlotteNC28254UNKNOWNNULL
PRVPRV-235912026-03-04T02:32:55ZBeverly—Padilla1988-12-19—N/A6967591907BEVERLY.PADILLA@GMAIL.COM404 Park PlaceDenverCO80256—CHOICE-PLUS-PPO
PRVPRV-235692026-10-05T12:31:07ZAnn—Morales1982-03-06UHC-02904-05null··N/A3142 Park Pl·AustinTX78773UNKNOWNMEDICARE-ADV-B··
9,596 rows, page 125 of 192PreviousNext

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:53.147Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty