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-220912026-10-12T11:11:37ZRONALD—PIERCE·04/14/1989N/A—3038921432—6679 Union StTempeAZ85249—UNKNOWN
PRVPRV-253912026-09-07T01:34:59ZBrandonXReid··07-11-1968UNKNOWN-553.593.9403·NULL4052 Indian School RdGlendaleAZ85388UNKNOWNNULL
PRVPRV-293822026-08-19T01:19:23Z·Keith—CruzJan 14, 1946UHC7138039•••-••-2461811-762-9109KEITH.CRUZ@AOL.COM5885 Sunset Blvd #810PlanoTX75054··N/A
PRVPRV-277622026-10-06T06:14:05ZMARIA—HAWKINSMay 24, 1984UHC-51163-84•••-••-2328466-659-4416—4711 DESERT SKY BOULEVARDAUSTINTX78783UNKNOWNnull
PRVPRV-234882026-02-20T15:05:06ZHannah—Sims1985-11-24NULLNULL··408-302-0675N/A9768 Sunset BoulevardDALLASTX75256nullSELECT-EPO
PRVPRV-219862026-06-11T01:10:58ZjaniceKalexander2008-05-23UHC-43589-03NULL·(887) 452-3752NULL8708 CENTRAL AVENUESacramentoCalifornia95832—CORE-HMO
PRVPRV-240172026-06-14T09:22:29ZJun—·Welch1959-01-05—•••-••-04923478201851—4917 Park PlaceSan AntonioTX78227—NAVIGATE-HMO
PRV PRV-214422026-03-31T05:52:22ZSantago—Ross···1972-09-08N/A-··2448777865·UNKNOWN3583 HILLCREST ROADPhoenixAZ85004—UNKNOWN
PRVPRV-214202026-08-15T02:43:53ZAMBER—ROBINSON8/7/2006UHC-29861-86··—643-254-5330··3458 HIGHLAND AVENUEMesaAZ85293-6965—NULL
PRVPRV-261352026-03-25T03:56:34ZDONNA—SULLIVAN1998-01-01UHC-84309-27·UNKNOWN(578) 688-8092N/A7269 BROADWAYAtlantaGA30393-0904—N/A
PRVPRV-27173 2026-08-11T17:32:38ZHelen—HudsonDec 26, 1992N/ANULL4452204883—3802 Elm StreetJacksonvilleFL32233nullCHOICE-PLUS-PPO
PRV PRV-208712026-07-20T15:00:32ZRandy—·Ward25-01-1980UHC-24436-39··•••-••-91627975544450N/A··1813 UNION STREETPlanoTX75009UNKNOWN·null
PRVPRV-20395 2026-03-12T18:24:36ZLINDAVRILEYJul 15, 1982UHC-36896-26•••-••-69657425941177-1557 Central AvenueSeattleWAN/A-NAVIGATE-HMO
PRVPRV-257542026-04-29T15:01:02ZOlivia—Franklin2003-08-18——2308304907—2718 PALM DRIVESeattleWA98101——
PRVPRV-207232026-09-30T02:59:20ZBrittany—Wright1946-05-25UHC-09549-37··——BRITTANY.WRIGHT@HOTMAIL.COM9086 HILLCREST RDMIAMIFL33101UNKNOWNNULL
PRVPRV-248582026-03-23T05:03:26ZSamantha—Murphy2001-03-03null-307-566-9853-455 Ocean AveHOUSTON·TX77035——
PRVPRV-258492026-04-11T17:09:00Z·bradley—hayes1967-08-21null—979.974.9640null7711 Mountain View DrOrlandoFL32845UNKNOWNMEDICARE-ADV-B
PRVPRV-250852026-06-17T12:46:12ZMatt—Williamson·1955-12-05····NULLN/A—N/AUNKNOWN—NULLnull—
PRVPRV-274302026-05-17T13:14:52ZMadisonV··Russell2/24/1985UHC-55697-51•••-••-15812472185779MADISON.RUSSELL@PROTON.ME7334 Mountain View DrTucsonAZ85706—null
PRVPRV-273692026-07-24T08:53:21ZJoan—Fowler14-10-1983UHC-85183-78—17126109526joan.fowler@aol.com7025 Sage CourtFresnoCA93722nullN/A
PRVPRV-25521 2026-08-31T14:41:00ZAlexander—Ray1986-05-02UHC-84597-48N/A(599) 417-7794alexander.ray@yahoo.com8891 Lincoln WayDenverCO80277--
PRVPRV-234522026-10-06T19:20:25ZMEGNASHERRERA1991-02-23—null-··4453 Indian School RoadDenverCO80228nullN/A
PRVPRV-285172026-08-30T18:43:55Z·FRANK·····SCOTT1988-11-22UHC-44570-96N/A9323558609frank.scott52@yahoo.com2437 Highland Avenue Apt 36DallasTX75249NULL—
PRVPRV-210052026-08-04T00:41:15Z·Priya—Larson··12/13/75UHC-56071-01NULLNULLN/A9198 Pine DrNashvilleTN·37232-4774-N/A
PRVPRV-228092026-06-21T03:27:00ZJOOYCE—GRAHAM11/7/1998——18924901767UNKNOWN8055 Ocean AveGlendaleAZ85370·NULLOPTIONS-PPO
PRVPRV-261532026-07-19T05:20:04ZNATHAN—SALAZAR1956-08-11··UHC-50188-33-904-207-2255null506 Mountain View DrAtlantaGA30351—NULL··
PRVPRV-207072026-05-07T21:19:08ZAnnR.Harris1/28/1985——5869920894-2557 Willow CourtDALLASTexas75206--
PRVPRV-293592026-05-11T16:45:45ZBishop, KyleJ—1940-01-05UHC-06507-66•••-••-9151823.770.4050··UNKNOWN1367 Grand AvenueChandler·AZ85280··UNKNOWN—
PRVPRV-261542026-03-14T09:42:17ZHansen, Denny··M—1940-05-06nullN/A658-449-6728UNKNOWN4410 RIVER RDTampaFL33667··UNKNOWN—
PRVPRV-277832026-08-05T12:58:08ZannaFmurray·1999-08-04—•••-••-2701571-906-0986anna.murray@aol.com7304 HIGHLAND AVEAtlantaGA30376-9132—null
PRVPRV-270912026-02-28T04:09:42ZMarcus—Thomas1959-04-28UHC-45703-19null7384551260·null3707 Ocean AvenueHOUSTONTX77043····null
PRVPRV-238772026-10-18T19:36:41ZFrances··BCarpenterJul 13, 1989——(278) 937-0578null—UNKNOWN—N/AUNKNOWNUNKNOWN
PRVPRV-262582026-03-01T23:20:32ZMari—Luna1998-08-15—NULL4407334607maria.luna3@icloud.com801 INDIAN SCHOOL ROADGlendaleAZ85332NULLNULL
PRVPRV-291762026-07-02T00:35:23ZCAROLYN—PANE06/09/78—N/A··7666339374-5657 Bayshore DrOrlandoFL32824——
PRVPRV-202122026-05-08T09:39:39ZCharlotte····Bryannt··9/22/1993·UHC-51096-97•••-••-5259(858) 820-0512null4266 Union StreetDenver··Colorado80230—N/A
PRVPRV-273302026-10-06T03:08:06ZDenise F—Anderson05/16/87··UNKNOWNN/A2936129893denise.anderson30@proton.me3970 Market StreetLAS VEGASNevada89189-7022UNKNOWNMEDICARE-ADV-A
PRVPRV-207922026-01-07T06:11:14ZGEORGE··KNIGHT1998-04-09NULLNULL(686) 439-0158george.knight@outlook.com7834 Canyon RoadLos AngelesCA90070—null
PRVPRV-291652026-02-11T09:43:36ZCARL—SIMS1964-06-26UHC-22625-51—8967386776N/A3056 Indian School RoadTUCSON·AZ85781—-
PRVPRV-255692026-03-31T15:38:44ZDYLAN—PERRY1991-11-12UHC-04699-13--—·1794 Cedar LnDenverCO80244—OPTIONS-PPO
PRVPRV-260182026-02-21T05:33:58ZDanielQSoo1985-08-17UHC-72153-33N/A5748152457daniel.soto2@icloud.com1606 BROADWAY·SeattleWA98175-—
PRVPRV-206292026-08-31T17:18:19ZCHARLES—·CHAVEZ1988-04-02N/A—18097346366UNKNOWN3476 Lake View RoadFresnoCalifornia93753NULL—
PRVPRV-274122026-02-16T04:19:43ZBENJAMIN—MARTIN1967-09-19—•••-••-4271-N/A6483 Union StTempeAZ85253NULL-
PRVPRV-212842026-05-21T09:58:23ZCynthia—Rojas·1979-06-02NULLnull9749992783-5677 Mesa DriveCharlotte·nc28264-··null
PRVPRV-284702026-09-11T21:13:35Z·Jonathan—Ramirez1962-03-14UHC-25636-58—-—995 Spring Street··COLUMBUSOH43276-7319null·N/A
PRVPRV-273372026-05-29T01:40:45ZLcuia—Daniels·11/22/82UHC-83430-16····+1 222 845 6416—·6113 MARKET STREETLas VegasNV——-
PRVPRV-282422026-05-22T08:26:43ZPriya—Lopez1947-04-09——-priya.lopez@aol.com6000 Harbor BoulevardCHANDLERAZ85296—null
PRVPRV-211632026-08-19T09:51:34ZAARON—LARSON1996-05-07—null16839919805—3534 UNION STNashvilleTNUNKNOWNnullOPTIONS-PPO
PRV PRV-233892026-09-19T03:53:40ZALICE—ORTEGA1948-01-20UHC-20128-12-17567665648alice.ortega@icloud.com4708 Camelback RdMiamiFL33194-7279null—
PRVPRV-24983 2026-05-16T00:04:25ZDIEGO—BRADLEY1938-08-04——(848) 321-8084UNKNOWN7044 MEADOW LANEHoustonTX77074NULLUNKNOWN
PRVPRV-294992026-02-23T09:39:30ZJoe—Martin2009-02-18UHC-97135-53—+1 953 744 8775··UNKNOWN9024 Bayshore DriveMinneapolisMN55483UNKNOWN—
9,596 rows, page 93 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:46.447Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty