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-211772026-01-04T22:06:16ZAllen, Maria——12/8/1963UHC-56210-79•••-••-8923801-201-5427N/A4502 Hillcrest RoadPhoenixAZ85052NULL····
PRVPRV-207472026-04-16T14:32:17Z·CarlSWatson1942-06-01UHC-93057-38UNKNOWN(874) 346-2772-2747 Mountain View DriveJacksonvilleFL32262NULL-
PRVPRV-264642026-09-26T23:35:44ZSaraBTrranSep 20, 2003···UHC-06860-38•••-••-319916645858422NULL6688 Lincoln WayMesaAZ85294··NULL—
PRVPRV-256302026-02-12T02:19:54ZPRIYA—MORENOAug 6, 1991UHC-96157-92•••-••-20955498854889priya.moreno@gmail.com8560 Palm Drive #490··CharlotteNorth Carolina·28296——
PRVPRV-277262026-02-17T02:51:34ZWEI—JAMES05/16/87UHC-53568-22•••-••-898918928080751wei.james@proton.me7550 Sage CtORLANDOFL32822null·-
PRVPRV-265242026-10-03T01:42:11ZIsabella—Kelly02/25/59··UNKNOWNnull4505933422—2733 SUNSET BLVDDallasTX75215UNKNOWNnull
PRVPRV-205992026-01-29T22:45:46ZARTHUR—GARRETTNov 27, 1965UHC-35004-63NULL4847752631UNKNOWN5313 Sunset BlvdCharlotteNC28207nullNAVIGATE-HMO
PRVPRV-277862026-08-01T05:15:15ZAlan—Ryan06/15/40—null722-348-4375alan.ryan35@hotmail.com5901 Grand Ave···San DiegoCA92174N/ASELECT-EPO
PRVPRV-289422026-04-10T01:38:14ZEric—Owens8/24/1963UHC-64461-99N/A227.776.0343UNKNOWN1197 WILLOW CTOrlandoFL32872-8341nullMEDICARE-ADV-A
PRVPRV-274572026-01-04T14:26:58ZJULIA··—RYAN1988-04-08-•••-••-566517123874597N/A2161 HILLCREST ROADSacramentoCA95881-6026—SELECT-EPO
PRVPRV-259572026-04-07T03:38:05ZPAUL—MEDINASep 11, 1979—UNKNOWN499-697-3167paul.medina18@icloud.com6454 FOREST AVENUE··OrlandoFL32810··nullUNKNOWN
PRVPRV-206492026-05-19T07:27:55ZGLORIA—HAMILTON2008-01-22UHC1929824·N/A(911) 704-7508··GLORIA.HAMILTON23@ICLOUD.COMNULLN/ANULLUNKNOWN——
PRVPRV-273362026-10-05T12:53:12ZVICTORIA··N.GRAHAM1950-09-24UHC-99148-14UNKNOWN16796257726null———UNKNOWN—-
PRVPRV-218612026-06-12T14:25:29ZWILLIAMF.MORENO1953-05-16··UHC-32552-30—712-266-4779UNKNOWN7067 FOREST AVENUEAUSTINTX78729··NULL
PRVPRV-256842026-07-27T16:10:37Zscott—tran1976-08-06UHC4774573UNKNOWN869.699.5329null1201 Palm DrHoustonTX77031UNKNOWNnull
PRVPRV-250412026-03-30T06:12:58ZPorter, Charles·O.—04/09/04UHC-37973-20—(617) 635-5619N/A··9313 Forest AvenueSacramentoCA95829-OPTIONS-PPO
PRVPRV-244062026-09-29T09:14:01ZJudith—Owens9/17/1969-null210-590-6088null8433 Lincoln WayMiamiFL33151-··OPTIONS-PPO
PRVPRV-242472026-10-12T15:50:17ZDonna—Welch1976-06-06UHC-78754-72N/Anull—NULLnull—UNKNOWNN/AUNKNOWN
PRVPRV-236182026-09-09T03:04:49ZADAM—GIBSON08-01-1991—NULL(911) 545-6638—7686 Sunset BlvdSacramentoCA95867-3240-MEDICARE-ADV-A
PRVPRV-29408 2026-07-27T05:48:56Z·Angela—Riley1991-01-03··UHC-71344-92N/A·528.703.6211N/A1064 Main StreetHoustonTX77099-3571··null-
PRVPRV-289102026-08-03T11:22:54Zaisha—gomez1982-11-15-UNKNOWN9752021738AISHA.GOMEZ25@HOTMAIL.COM4319 Ocean AveTucsonAZ85798null-
PRVPRV-290632026-02-05T14:27:47ZSandra—Cunningham1962-04-13UNKNOWN-—··2627 Jefferson AveLos AngelesCAN/Anull-
PRVPRV-205222026-05-02T11:38:59ZJEREMY··T.HARPERJan 17, 1981null—18214744500JEREMY.HARPER@YAHOO.COM5522 Baseline RoadLos AngelesCA90093null—
PRVPRV-223282026-07-18T13:21:37ZBrittanyQGraham1987-01-04UHC-81173-09—5376023613UNKNOWN3057 Sunset Boulevard·TampaFL——SELECT-EPO
PRVPRV-235582026-01-10T09:38:21ZSOPHIA—MURPHY··1975-06-15——4433302133····7694 Pine DriveGlendaleaz85314—UNKNOWN
PRVPRV-222142026-01-16T01:51:27ZLEE—JULIE6/28/1985UHC-59108-59·N/A—JULIE.LEE54@YAHOO.COM7238 Main StreetTucsonAZ85743null-
PRVPRV-224302026-02-02T15:20:48ZJack—Martinez2006-09-24UHC-79485-18—15069828781—5313 Forest Ave·MinneapolisMN55403——
PRVPRV-202612026-02-07T14:18:29ZMORRISON—DONALD11/26/1970UHC-52599-41-8265790735—6285 Park PlDenverCOUNKNOWN····UNKNOWN
PRVPRV-276232026-10-02T09:51:50ZEthan—Chavez09/10/89UHC-17655-21•••-••-6293(719) 930-2937—7974 Lincoln WayDenverCO80250—UNKNOWN
PRVPRV-29552 2026-10-06T04:30:38ZWei—Mason1982-09-01UNKNOWN-550.437.3701null9839 Palm Dr #990SeattleWashington98103——
PRVPRV-263432026-07-30T08:43:27ZJOEGSTEWARTFeb 11, 1953UHC-21317-80-+1 526 234 6068null··286 Sage CtLos AngelesCA90063-3171—NULL
PRVPRV-229482026-01-15T21:42:22ZCarool····Kim2007-10-18··UHC-04642-40•••-••-1904——565 Meadow LnTucsonAZ——NULL
PRVPRV-262432026-07-08T00:25:46ZJeremy—Sullivan10/18/81UHC-15896-37-523-917-6767jeremy.sullivan@icloud.com5808 Camelback RdColumbusOH43237-null
PRVPRV-252302026-09-16T23:57:46ZBRITTANYX.ROOMERO1966-01-05UNKNOWN—528.938.6055—1928 Maple AveAustinTXUNKNOWN——
PRVPRV-204892026-05-13T20:10:58ZLucia—Perkins1968-10-09UHC6444021NULL6769825008lucia.perkins@gmail.com9799 WASHINGTON STREETDenverCONULL—NULL
PRVPRV-280572026-09-12T03:15:26Z·LisaFEvans5/23/1994—•••-••-0224—null3982 Willow Ct··Los Angelesca·90056N/AN/A
PRVPRV-25825 2026-05-25T17:07:35ZDanielleXCox19430412UNKNOWNN/A(713) 400-7297DANIELLE.COX@OUTLOOK.COM5635 Spring StSACRAMENTOCalifornia·95887—N/A
PRV PRV-232102026-08-21T22:21:21ZFATIMA—COLLNIS1999-12-24UHC-63611-25•••-••-4377(634) 305-3581null9073 Lincoln WayDenverCO80205—····
PRVPRV-216982026-07-18T01:14:13ZOMAR—·WOOD1986-11-02UHC-49107-09null678.769.1835null5185 Pine DriveLas Vegas··NV·89146UNKNOWNN/A
PRVPRV-252992026-10-02T15:18:14ZGregory—Taylor1975-03-06·UNKNOWN—878-953-4201N/A3415 Washington Street··GilbertAZ85212—UNKNOWN
PRVPRV-245742026-09-10T07:11:32ZHart, Rebecca—··1962-03-15··UNKNOWN4442893304null2012 Jefferson Ave·DallasTX75284-1939-—
PRVPRV-293042026-09-05T02:50:42Z Russell—Rjas·1966-11-19-—·nullrussell.rojas11@outlook.com1584 Broadway Apt 17HoustonTX77069—null
PRVPRV-224082026-08-20T00:33:01ZANA··RICHARDS2001-02-07UHC5314166—3759208N/A841 Sage Court·GlendaleazUNKNOWNUNKNOWN··UNKNOWN
PRVPRV-243472026-07-03T21:00:19Zchristine··garcia1960-03-06UNKNOWNNULL+1 393 442 4041CHRISTINE.GARCIA77@PROTON.ME2995 BROADWAYMINNEAPOLISMN55477·-—
PRV PRV-222862026-03-11T23:41:47ZAMYOELLIOTT1950-07-18UHC-43246-58·N/A-null7041 Elm StreetPhoenixAZ85070NULL—
PRVPRV-254602026-01-28T23:26:54ZSanders, CamilaB—·07/23/03UHC-24398-42null·(307) 799-0541CAMILA.SANDERS@YAHOO.COM7123 CEDAR LNTampaFL··33648N/A—
PRVPRV-277672026-05-04T07:05:43ZKYLE—FULLER1961-09-12UHC-61514-91UNKNOWN297.411.3366kyle.fuller45@icloud.com5677 HIGHLAND AVENUESacramentoCA95844-8565UNKNOWNCHOICE-PLUS-PPO
PRVPRV-251832026-03-14T22:47:30Z ·Daniel—Mendeznull—N/A19787564344daniel.mendez@aol.comnullN/AUNKNOWNN/ANULLUNKNOWN
PRVPRV-24924 2026-03-02T03:08:36ZCAROL··—RODRIGUEZ19970602UHC-46306-66··(865) 447-8254CAROL.RODRIGUEZ@HOTMAIL.COM5317 Forest AvenueNashvilleTN37227NULLUNKNOWN
PRVPRV-213642026-09-21T16:03:47Z CAROL—HENDERSON10/16/1948—-289-688-0385N/A5023 Central AveMinneapolisMN55455—NULL
9,596 rows, page 20 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:36.722Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty