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-240562026-03-19T06:49:54ZOliviaJHunt12/18/2002UHC-49329-86-2317836571··—1027 Oak StMesaAZ85241—null
PRVPRV-238232026-07-01T00:51:13ZSARA—STEWART2/20/1945NULL—766-711-4993··sara.stewart@yahoo.com—UNKNOWN—UNKNOWNnull—
PRVPRV-223492026-08-16T04:17:42ZAdams, Valentina——·1955-01-24UHC-04850-47-535-616-5261-3261 MESA DRIVESeattleWA98130—SELECT-EPO
PRVPRV-237562026-03-24T02:35:06ZJanice—HuntDec 24, 1956UHC-20449-42•••-••-8328+1 856 900 3404UNKNOWN5192 Lincoln WayCharlotteNC28268NULLnull
PRVPRV-275102026-04-02T14:32:07ZVirginia··—Graham1965-09-01UHC-41763-34—(276) 457-3892—4219 Mesa DriveAUSTIN··Texas78789-NULL
PRVPRV-232842026-04-15T18:37:21Z·PAMELA—ROJAS·04/09/1976UHC-38278-60··—PAMELA.ROJAS24@GMAIL.COM2815 Elm StreetPlanoTX75010-1560··UNKNOWN
PRVPRV-251982026-06-11T09:14:24Zbilly—weaver1975-06-25NULL··NULL(751) 794-6640—2855 BAYSHORE DRIVEScottsdaleAZ85267N/AUNKNOWN
PRVPRV-285842026-03-18T15:39:51ZDennis—Meyer9/15/1988—··+1 287 404 5819dennis.meyer37@gmail.com9097 SPRING STSeattleWA98166··—N/A
PRVPRV-213412026-06-27T01:11:32ZJesseFFowler1998-12-11UHC-13704-87NULL5134605829jesse.fowler8@outlook.com·4715 SAGE COURT #627MiamiFLnullUNKNOWNcore-hmo
PRVPRV-252932026-06-08T06:01:02ZBEVERLY—ROMERO02/22/63N/A•••-••-1558+1 678 413 2451—·7088 OCEAN AVEMiamiFL·N/Anull—
PRVPRV-286172026-01-28T19:46:57ZBurton, Jonathan——2006-09-23UHC-87120-20NULL971-667-0384UNKNOWN4473 Mesa DrDallas·TX75238NULL—
PRVPRV-243892026-09-07T13:46:28Znatalie—medina1945-12-24UHC-96777-36•••-••-7407948-402-3277——UNKNOWNN/AUNKNOWNNULL—
PRVPRV-201752026-06-28T10:36:12ZDANIELYBURTON——•••-••-1417+1 754 432 2656N/A8924 Canyon RdPhoenixaz··85021·NULLMEDICARE-ADV-B
PRVPRV-269782026-06-25T21:44:08ZNunez, Andrew··——1995-08-24··UHC-64434-62•••-••-9878(216) 740-8191NULL6814 Canyon RoadHouston··Texas77059N/ANAVIGATE-HMO··
PRVPRV-293162026-06-29T04:20:40ZDonna····Mason2002-04-14—UNKNOWN·(967) 826-1186N/A1781 Forest Ave·San AntonioTX78245—NAVIGATE-HMO
PRVPRV-267682026-06-25T04:09:18ZIsabella—Munoz1982-05-16UNKNOWN··•••-••-6107(932) 635-7406—4246 Main St #707Nashville·TN37274——
PRVPRV-219552026-07-13T12:58:21ZPATRICIA····NICHOLS·1945-03-18N/A····(311) 619-6673null9725 DESERT SKY BOULEVARDEDEN PRAIRIEMN55397——
PRVPRV-203362026-08-22T12:33:03ZsamuelC··mejia06/12/60——8023123063—3111 Mesa DriveSEATTLE··WA98180-NAVIGATE-HMO
PRVPRV-248062026-04-16T14:38:58ZGLORIA—MILLER1988-09-11——+1 315 367 5577-7263 Cedar LaneColumbusOH43288··UNKNOWNN/A··
PRVPRV-242092026-01-27T06:04:03ZRAYMOND··—PADILLA1959-11-23NULL··N/A849-292-7414·null6845 Maple AvenueMinneapolisMN·55439UNKNOWNUNKNOWN
PRVPRV-289272026-01-31T21:05:31ZAmy—Griffin1967-12-12UHC-47681-13UNKNOWN849-586-1893—7186 Central AveLos AngelesCA90017NULL—
PRVPRV-212652026-08-23T23:01:43ZALAN··—TORRES1966-05-03—N/A(794) 516-4440···2033 Maple AveNashvilleTennessee37205N/A-··
PRVPRV-207082026-02-02T07:15:28ZElizabeth—Hudson2001-12-09UHC0454213null5768633560N/A4988 Highland AvenueAustinTX78703nullN/A
PRVPRV-253082026-01-14T09:43:55ZValentinaM.Hayes1952-04-28UHC-86120-56UNKNOWN+1 241 740 7827valentina.hayes@proton.me6380 Washington Street·ScottsdaleArizona85229UNKNOWN—
PRVPRV-220682026-01-15T20:54:20ZBRYAN—BAIILEY1972-07-16UHC-99666-81—625-927-9433—6961 WASHINGTON STScottsdaleAZ85277——
PRVPRV-261572026-06-11T18:48:28ZStephenM.Harrison1955-03-22—-··3752847338-9547 Indian School RoadSan AntonioTX78226-0046-MEDICARE-ADV-A
PRVPRV-223832026-07-21T19:41:38ZRyan—RobinnsonAug 4, 1946—NULL544-833-8811ryan.robinson@yahoo.comNULLN/A——null··
PRVPRV-220242026-01-07T23:37:21ZSTEVE—·MEYER1999-09-17—•••-••-5954718-939-3961UNKNOWN226 Indian School RdTucson·AZ85773——
PRVPRV-201222026-06-25T15:14:48ZGomez, ValentinaS—1980-09-13·UHC-76561-42N/A323-246-5980valentina.gomez20@hotmail.com5672 Church StMESAAZ85253··-N/A
PRVPRV-290672026-05-12T06:15:12ZDiegoJBerryApr 6, 1949N/A•••-••-5229466.253.3984N/AUNKNOWN-NULL—UNKNOWN··NULL··
PRV PRV-253002026-01-15T21:25:29ZSara—Jones11/04/1965UNKNOWN•••-••-900918552580299UNKNOWNnull—·-··—null
PRVPRV-20342 2026-03-05T16:47:08ZELIZEBETHG·WEST7/1/1964UHC-23324-07N/A366.509.1188null9763 Apache BlvdSan AntonioTX78294——
PRVPRV-218572026-09-04T15:49:32ZOMAR—COLLINS2001-09-13UHC1762038····229-222-7324··—9690 Hillcrest RdAtlantaGA30341··-OPTIONS-PPO
PRVPRV-25594 2026-02-27T02:14:33ZMei—McDonald01/28/39UHC-20880-78UNKNOWN14816081080N/A7772 Lincoln WayHOUSTON··TX77077nullCORE-HMO
PRVPRV-278402026-01-16T06:18:00Z Joe—·Payne1996-08-03UNKNOWN—UNKNOWNJOE.PAYNE66@ICLOUD.COM6313 Central AveScottsdaleArizona85221-1064NULLnull
PRVPRV-25361 2026-09-03T19:59:52Z·Douglas—Colins1941-10-14N/AN/A(261) 301-3363douglas.collins17@gmail.comN/A—N/A—N/AUNKNOWN
PRVPRV-23346 2026-04-05T06:33:32ZAmanda····AllenOct 20, 1954-•••-••-416714779035426—UNKNOWN—NULL··——NULL
PRVPRV-279672026-01-13T10:18:42ZSullivn, Marilyn—··May 20, 1952—NULL··2748519508N/A5246 Desert Sky BlvdMiamiFL····NULLnull
PRVPRV-285302026-01-31T21:38:34ZMichael—Mills1996-08-15UHC-19184-04—3276269302michael.mills98@gmail.com··1624 Mountain View DrNashvilleTN37273N/AUNKNOWN
PRVPRV-293892026-03-13T04:02:52ZHENRYKELLIS01/01/1950--+1 411 601 6082N/A1632 Central Avenue··San AntonioTX··78250nullN/A··
PRVPRV-248822026-02-22T02:07:15ZLisa··Lewis·03/27/1951UHC-05664-71null346-368-1261lisa.lewis72@icloud.com2672 Park PlaceJacksonvilleFL··32202—null··
PRVPRV-272872026-01-22T07:47:25ZMARTTHA—HART1992-08-09null··16112168218—UNKNOWN—NULL··—UNKNOWN
PRVPRV-269302026-07-31T23:41:06ZEvelynZHillAug 3, 1943UHC-49905-98N/A(539) 987-9574UNKNOWN3867 DESERT SKY BLVDSan AntonioTX78265—UNKNOWN
PRVPRV-282552026-02-10T14:50:55ZLOGAN—LARSON04/19/1945——N/AN/A··——N/Anullnull—
PRV PRV-219442026-07-19T22:10:09ZAmy—Daniels·08-04-2007-NULL(756) 802-2992··amy.daniels@hotmail.com1993 MAIN STSAN ANTONIOTexas—-UNKNOWN
PRVPRV-26008 2026-02-24T23:24:31Zbilly—valdez19681202UHC-52318-42null··—billy.valdez83@outlook.com1459 HILLCREST RD Apt 13GlendaleAZ85310null—
PRVPRV-237122026-07-01T02:06:50ZHAROLD—FERNANDEZ1981-07-02UHC-45011-98•••-••-77888222250190NULL6390 Lake View Road Apt 24SACRAMENTOCalifornia95808UNKNOWN—
PRVPRV-249582026-01-22T00:37:38ZKelly V··—Espinoza27-11-1999——UNKNOWN—2936 Canyon RoadSacramentoCA95858-NULL
PRVPRV-227852026-08-10T19:56:02ZANGELA—WANG1967-03-01UHC-43079-70-667.988.9966·NULL8641 Valley View DriveOrlandoFlorida32887NULL—
PRVPRV-200002026-10-02T23:46:05ZLaura—Alvarado03/06/39——·2082046344NULL4347 CHURCH STPlano·TX·75086——
9,596 rows, page 73 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:43.618Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty