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-225752026-05-06T21:46:26ZPaulEHollmesnullUHC-05951-73—(446) 541-2660paul.holmes@gmail.com5401 Forest AveScottsdaleAZ85254——
PRVPRV-271692026-09-30T13:38:00Zsofia—patel03/25/2000N/AN/A+1 261 915 6113··—5736 OCEAN AVENUE #100ChandlerAZ85298—CORE-HMO
PRVPRV-271672026-02-15T13:47:27ZSophiaF.Scott·19490316UHC-50442-67NULL·13436297675-3828 PALM DRIVECharlotte·NC28283—NULL
PRVPRV-256912026-01-28T09:49:05ZAngelaEMurray11/25/2004UNKNOWN•••-••-8806942-247-2957NULL53 Elm StreetNASHVILLETN37215N/AUNKNOWN
PRVPRV-265112026-09-11T07:03:24ZMADISONH.RAMOS1994-04-06-•••-••-1489+1 293 978 8894UNKNOWN2845 Market StColumbusOhioUNKNOWN—MEDICARE-ADV-A
PRVPRV-231122026-06-02T11:21:08ZsharonOgibson08/13/1980——5545494790NULL2123 Jefferson AvenueJacksonvilleFL32237—····
PRVPRV-238652026-04-03T21:47:23ZWalterEMitchell··7/2/1938UHC4767092null399-990-9734N/A7108 Washington StSan Diego··CA92160UNKNOWN-
PRVPRV-288542026-07-22T09:55:39ZVIRGINIA····HANSEN1944-07-06N/ANULL6718672virginia.hansen@outlook.com3692 SUNSET BLVD Apt 30JacksonvilleFL32220UNKNOWNNAVIGATE-HMO
PRVPRV-212972026-10-02T10:28:46Z ·HEATHEROGRIFFIN1987-08-11··NULL—·UNKNOWNheather.griffin@yahoo.com8521 PALM DRJACKSONVILLEFlorida32278——
PRVPRV-267902026-05-23T07:16:37ZJORDAN—OLIVER11/21/1981—N/A13197505190—4263 Spring Street Apt 35LAS VEGASNV89178—UNKNOWN
PRVPRV-229732026-09-20T13:18:19ZDYLANF.··WHEELER··01/26/2000UHC-34756-24—705-810-3344UNKNOWN5635 PALM DRIVEEden PrairieMinnesota55303NULLCHOICE-PLUS-PPO
PRVPRV-284752026-02-16T06:01:20ZAshleyOWalsh19611013UHC-77677-08··UNKNOWN··-7897 PALM DRIVENashvilleTN37276—-
PRVPRV-231292026-08-10T22:47:14ZEdward—Daniels10/27/85UHC-52432-11NULL··(334) 317-2163EDWARD.DANIELS97@YAHOO.COM8035 Central AveTampaFlorida33615nullnull
PRVPRV-208602026-09-16T05:27:50ZNOAHM.MORALES04/26/58UHC-68816-49NULL(337) 458-2516—8322 Maple AveSan AntonioTX·78212··—
PRVPRV-216302026-07-27T22:09:46ZDIEGOQRILEY1994-07-22UHC-05758-75•••-••-526612096792870UNKNOWN··1017 Harbor Boulevard··MiamiFlorida—N/A—
PRVPRV-261082026-06-22T14:44:12ZCarl J.—Ross1984-10-05-NULL12547942074carl.ross94@proton.me9633 Pine DriveLos AngelesCaliforniaNULLNULL-
PRVPRV-262452026-10-11T02:41:08ZAmy—Bennett1970-10-21··UNKNOWN-N/A8477 Pine DriveSAN ANTONIOTX78201null—
PRVPRV-222622026-06-20T14:42:01ZSOFIA—CASTROFeb 28, 1999null—870.466.8083NULL3667 Cedar LnCHARLOTTENorth Carolina28253-N/A
PRVPRV-204122026-07-07T06:27:07ZEspinoza, ChrisP.—18-09-1994UHC-74983-53•••-••-0053820.883.1326—5093 Lake View RoadEden Prairie··mn·55378NULLN/A
PRV PRV-233192026-01-04T02:25:33ZHarrison, Rachel——9/25/1956·N/A—(651) 517-5655UNKNOWN5938 Cedar LnEden PrairieMinnesota55366NULL··NAVIGATE-HMO
PRVPRV-275812026-03-07T18:47:56Z anthonyPfoster1987-01-06—•••-••-32068388749143null7589 Pine DriveNashvilleTennessee·37254null—
PRVPRV-228072026-06-23T07:08:00Zsophia····taylor·1986-01-78UHC-53505-21—(215) 651-9022sophia.taylor75@yahoo.com9815 WASHINGTON STOrlando··FL··32842N/AN/A
PRVPRV-239092026-09-19T01:50:28Z·Samuel—Harris·19821116UHC3279929•••-••-5265400-611-9644·NULLnullN/A—UNKNOWN—CORE-HMO
PRVPRV-202892026-09-27T09:47:39ZANDREW—MORGAN1987-12-08UHC-78457-24·null840.393.1682N/A·NULL———NULL—
PRVPRV-234142026-02-28T16:47:12ZWeiFChapman20050320null··null3045402131null5147 Pine DriveTempeAZ85216—UNKNOWN
PRVPRV-217822026-03-17T05:35:10ZAlan—Tran1970-06-06UHC-55420-11•••-••-08644134792832—7475 Valley View DrNashvilleTennessee37292——
PRVPRV-251892026-01-12T08:19:08Z Jeremy—Young6/24/1981N/ANULL19063797467N/A··4942 Main StreetLas VegasNevada··89132UNKNOWNUNKNOWN
PRVPRV-285082026-07-05T17:18:02Zdorothy—hicks1946-08-25NULL—+1 415 576 0904—7841 River RoadTucsonAZ85755N/A··UNKNOWN
PRVPRV-260752026-10-03T12:59:55ZSAMANTHAI.TORRES1954-08-20UHC-71644-84N/A—samantha.torres@proton.me5874 SUNSET BOULEVARDAustinTX78717—CORE-HMO
PRVPRV-233782026-09-22T11:14:42ZEmily—Hanson1987-06-12N/AN/A856.631.1779-··3323 Hillcrest RoadLAS VEGASNV89132—NULL
PRVPRV-281192026-03-28T19:54:20Z·Wayne—Fernandez03-12-1941·UHC-71673-52NULL+1 498 951 4706NULL6873 CANYON RDJacksonvilleFL32269—OPTIONS-PPO
PRVPRV-254102026-07-20T08:08:13ZBRUCE··—OLSONJun 21, 1938-NULL4864539108N/A2751 RIDGE ROADSeattleWA·98165nullN/A··
PRVPRV-291252026-06-19T13:34:27ZARJUNXCRAWFORD1971-06-32UHC-35273-61NULL··(413) 376-1866ARJUN.CRAWFORD@AOL.COM8223 HIGHLAND AVEEden Prairie·Minnesota55372UNKNOWN··UNKNOWN
PRVPRV-243002026-10-14T03:25:50ZSue—Carr2005-06-19UHC-11023-15-+1 439 207 5440··-5207 PINE DRIVELAS VEGASNV89177NULLNULL
PRVPRV-233942026-03-31T14:41:15ZWatson, Carl——1947-06-09UHC-46114-22•••-••-98986356141072—4297 Palm DrMiamiFL33100UNKNOWNMEDICARE-ADV-B
PRVPRV-217802026-04-14T22:09:01ZMarcA·Roberts2005-04-16UHC-52099-28-+1 400 915 6736—1639 River RoadMiamiFL33122UNKNOWN—
PRVPRV-202002026-10-01T03:47:30ZWoods, ShirleyA—1959-10-18UHC-25499-05N/A··6592621873—9434 Washington StEden Prairie·MN55379NULL··UNKNOWN··
PRVPRV-216242026-02-14T02:09:42ZTerryDGuzman12/08/1950null—475-871-2939··3966 BAYSHORE DRNashvilleTN37247-4965nullnull
PRVPRV-274912026-09-23T17:31:51ZROGRE—STEVENS··1978-03-01———·N/A3348 LINCOLN WAYChandlerAZ85217—null
PRVPRV-279162026-01-08T07:01:09ZCatherineSJohnson··05/23/47UHC-09489-58null16359917157N/A9299 PALM DRIVESeattleWA98170--
PRVPRV-265362026-04-30T03:28:37ZPamelaILucas1970-12-01—•••-••-11212927828982pamela.lucas34@outlook.com1073 Church StreetLas VegasNevada89186-—
PRVPRV-249332026-06-21T21:23:59ZEmilyI··Diaz1962-04-24nullNULL7184874460·-9476 Forest AveTucsonAZ85779N/A—
PRV PRV-281012026-06-27T07:02:19ZEryc—Wheeler10-06-1997··-—2015855404—2403 Canyon RoadOrlandoFL··NULL-N/A
PRVPRV-289852026-01-06T20:01:26ZKETHERINE·G·BLACK1997-07-25UHC-68969-40—(232) 267-7319katherine.black39@gmail.com45 Palm DriveTucsonAZ85765-9206UNKNOWN-
PRVPRV-284672026-01-12T02:38:39ZChristopher—Moreno1982-03-18UHC-90490-58•••-••-9250(813) 992-0653christopher.moreno50@aol.com7662 CEDAR LANE··SeattleWA98104NULLnull
PRVPRV-20767 2026-09-16T11:03:54ZRoy—Payne01/20/1987UHC-52043-76—261.778.0795—5791 Baseline RoadColumbusOH43228—N/A
PRVPRV-247062026-05-03T14:24:14Zbetty—hart1993-04-17N/ANULL·8180225BETTY.HART@HOTMAIL.COMN/AnullUNKNOWN—UNKNOWNnull
PRVPRV-261962026-09-05T23:15:37ZNicole—Snyder19880706NULLN/A13302417673UNKNOWN6336 Spring StreetSan AntonioTXN/A—N/A
PRVPRV-266702026-02-27T14:31:17Zpatrick—castro·2008-08-26—NULL6542298143·UNKNOWN1268 Washington StFresnoCA93735UNKNOWN-
PRVPRV-290702026-04-24T05:37:56ZDANIEL—MEJIA1965-07-17UNKNOWNNULL·8766420344NULL7763 Ocean AveCOLUMBUSOH43222N/A··MEDICARE-ADV-B
9,596 rows, page 106 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:49.139Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty