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
PRV PRV-252722026-05-13T04:16:16ZJUSTIN—JOHNSON1991-03-02UHC-90635-30—(654) 795-9197JUSTIN.JOHNSON@GMAIL.COM3789 Valley View DrEden PrairieMN55304N/ANULL
PRVPRV-230582026-03-19T10:29:39ZChristina—Hart1954-04-21—NULL8399833023CHRISTINA.HART88@OUTLOOK.COM6532 Bayshore DriveLas VegasNV89144-4043UNKNOWNCORE-HMO
PRV PRV-205802026-02-20T21:23:21Zeevlyn··—lee2007-02-22·UHC-62339-83-+1 701 338 4967-7247 River RoadNashvilleTN37293null—
PRVPRV-223642026-03-29T16:42:38ZCHRISTINE—CHEN1/2/1943-··—·(901) 293-7786christine.chen@aol.com7525 APACHE BOULEVARDAtlantaGA30397—UNKNOWN
PRVPRV-261812026-02-20T20:14:58ZJANICE—SANDOVAL2003-12-23UHC-66768-58-367-284-8392janice.sandoval68@gmail.com8538 Highland AveORLANDOFL32852—CORE-HMO
PRVPRV-265832026-04-16T09:04:11ZPEER—PAYNE1994-06-07—•••-••-4281(238) 512-8845PETER.PAYNE33@YAHOO.COM4592 MAPLE AVEAtlantaGA30378-7090··-
PRVPRV-201132026-06-25T22:15:56ZAARONUHARPER11/02/2008UHC-06862-81—2896341496UNKNOWN—————-
PRVPRV-207442026-07-28T21:26:21ZJoshua—Lane08/05/08—•••-••-08417074910819JOSHUA.LANE@ICLOUD.COM3732 Maple Avenue··SacramentoCA95899—NULL
PRVPRV-212722026-06-21T13:06:57ZGregory—Ward·19810122UHC-42600-61···null(422) 714-3570—886 Bayshore DriveMiamiFL33159N/A·CHOICE-PLUS-PPO
PRVPRV-252782026-01-15T01:49:55Z ROGERHNELSON1989-06-14·N/ANULL19684758967roger.nelson28@aol.com1103 DESERT SKY BLVDTucsonAZ85733N/A-
PRVPRV-271532026-08-08T12:24:10ZDEBORAH—VARGAS·19440626··—409-643-3678deborah.vargas@gmail.com4953 APACHE BOULEVARDMinneapolisMN55473·nullN/A
PRVPRV-231492026-03-28T16:07:21ZChreyl—Kennedy1982-09-19UHC-14493-37•••-••-8363316-279-2853null2547 WASHINGTON STREETPlano·TX75005null·null
PRVPRV-236592026-03-21T21:31:55ZBRENDA—HENRY05-01-2004N/A—·699-812-6106brenda.henry45@gmail.com2034 CEDAR LANE Apt 18CHANDLERAZNULL-null
PRVPRV-219922026-06-09T03:26:50ZZachary—PalmerFeb 28, 1947··UHC-29115-60—NULL-5230 Apache BlvdDallasTX75225N/A—
PRVPRV-210332026-08-27T06:08:38ZSarahM.Alvarado··4/16/1963NULLnull209-558-1648-6407 GRAND AVENUEOrlandoFL32893—·UNKNOWN
PRVPRV-240312026-07-27T21:29:30ZRamos, GraceI—1991-08-09UHC-74116-69null(793) 324-5860N/A683 HILLCREST RDCharlotteNC28231·UNKNOWN—
PRVPRV-256562026-05-13T17:38:56ZRussell—Parker1970-08-10UHC-91285-73NULL(602) 727-6902····3317 Oak Street··LAS VEGAS··NV89180-NULL
PRVPRV-281072026-07-23T07:32:10Z·Alexis—Bennett06/04/68UHC-65598-14•••-••-6548967-433-3853N/A8577 BroadwaySacramentoCA95882—OPTIONS-PPO
PRVPRV-277722026-07-26T12:16:42ZRaymondD··West1959-12-27——null-451 Union StColumbusOH43207N/A—
PRVPRV-237632026-10-02T23:09:55ZHolmes, Sean··—08/13/03uhc-34874-09NULL307-384-5941-7645 Apache BoulevardDALLASTX75210null··
PRVPRV-262272026-05-12T11:50:20ZDick—Lawrence1950-10-16null•••-••-0235627-211-8276RICHARD.LAWRENCE@ICLOUD.COM6026 CHURCH STREETGilbert·AZ85225—NULL
PRVPRV-278312026-02-04T23:01:55ZRuth—Spencer2002-07-12UHC-50944-63nullN/Anull1966 Main StreetTempeAZ85241--
PRVPRV-223202026-09-03T10:30:16Z·Ahmed—Vega1991-05-16-UNKNOWN391-433-2193—1975 Jefferson AvenueSan Diego·CA92114-—
PRVPRV-274472026-04-23T06:09:55ZRICHARD—·CRUZ2008-02-16UHC-30512-30-+1 663 939 9759-9194 Mesa DrHoustonTX77008—-··
PRVPRV-272812026-03-20T13:20:52ZSAMANTHAS.ADAMS1997-01-12UHC-60115-83NULL——6922 SAGE CT #957FresnoCA93727N/ASELECT-EPO
PRVPRV-248782026-03-13T23:19:22ZBRANDON··—STEVENS11/18/1976—UNKNOWN6343461500brandon.stevens@hotmail.comUNKNOWN-UNKNOWNUNKNOWN——
PRVPRV-291282026-07-24T12:44:51ZSEANZFLORES4/12/1975-——UNKNOWN8026 Camelback RdMiamiFL33122UNKNOWN-
PRVPRV-291122026-01-14T20:37:38ZBrian—Montgomery1997-04-14UHC-99370-99N/A12522811562—1387 Hillcrest RdMIAMIFL33116-3888—NULL
PRVPRV-275082026-01-05T23:31:16ZEmily—Schultz1998-07-07··-19193993464··—2386 Apache BlvdSacramentoCA95829—NAVIGATE-HMO
PRVPRV-216112026-03-12T21:10:53ZNguyen, Maria——2003-04-02N/A—18202037758—4081 Willow CourtPhoenixAZ85030NULLOPTIONS-PPO
PRVPRV-238022026-05-14T09:05:13ZSEAN—HUNTER7/21/1963UHC-31403-34··N/A921.687.4431sean.hunter@hotmail.com4045 Market StSacramentoCA95809—UNKNOWN
PRVPRV-277772026-05-16T07:30:49ZJudy—Delgado2005-03-05·UHC-10925-71-UNKNOWN—9895 Jefferson AveLos AngelesCA90053N/ANULL
PRVPRV-244972026-05-15T17:54:48ZJudy··—Ortega·19971123—UNKNOWN234-228-3457—2089 CAMELBACK RD #529San Diego·CA92136null—
PRVPRV-294332026-07-15T01:25:52Z Jesse··—HillOct 7, 1960UHC-84855-30—942-606-4653UNKNOWN9848 Indian School RoadJacksonville··FL··32219UNKNOWN-
PRVPRV-286602026-07-09T07:34:41ZSTEVENS—ZACHARY1983-11-03··——249-730-5113null6105 Park PlaceChandlerAZ85270··CORE-HMO
PRVPRV-223452026-07-21T08:01:46ZJEREMY—REYES1793-02-03UHC8737254null(930) 513-1662jeremy.reyes55@yahoo.com—-——N/A—
PRVPRV-263262026-03-16T04:53:56ZCAROL···MASON1947-06-16uhc-05630-68•••-••-3752+1 415 860 4155NULL1548 Grand Avenue Apt 38Los AngelesCANULLnull—
PRVPRV-266032026-07-04T15:43:17Z·Matthew—Hoffman1995-04-23UHC-49069-01—290-373-3827··matthew.hoffman59@outlook.com3568 Church StGILBERTArizona85231N/AUNKNOWN
PRVPRV-227182026-03-17T07:25:00ZJuan—Hoffman2000-10-05UHC-66382-01•••-••-1699304-304-3551juan.hoffman31@aol.com2964 Desert Sky BoulevardDENVERCO80240NULLN/A
PRVPRV-293492026-08-18T17:02:38ZStephanie—Elliott1957-09-15NULL•••-••-84623688106511STEPHANIE.ELLIOTT@HOTMAIL.COM2713 BAYSHORE DRIVEGilbertAZ·85252-NULL
PRVPRV-293702026-05-31T16:57:47ZETHAN··—LOPEZ1972-07-10UHC-92695-79•••-••-613416246151566UNKNOWN··992 SAGE COURTSan DiegoCA92148——
PRVPRV-217682026-07-26T17:41:10ZJoan—Silva01/08/1980—•••-••-2875-N/A9459 Canyon RdFresnoCA93709UNKNOWNN/A
PRVPRV-262812026-03-31T15:37:49ZJudy—Hansen1968-08-13UHC-56044-45··•••-••-9927(478) 404-2141-·7537 Union StGILBERTAZ85296UNKNOWNnull
PRVPRV-200052026-08-26T18:45:53ZSophia—Ramirez—NULL—7196681436SOPHIA.RAMIREZ57@ICLOUD.COM—·-N/AnullUNKNOWNNULL
PRVPRV-269792026-07-23T04:01:26ZJanice—Banks22-06-1964UHC-81252-69null(721) 618-3607—·6376 CHURCH STREETScottsdaleAZ85275N/A—
PRVPRV-26329 2026-09-30T21:37:26ZBARBARA—JOHNSTON1974-09-16·UHC-72209-44N/A(580) 422-3914NULL5293 Washington StDallasTX75254-3563UNKNOWNMEDICARE-ADV-B
PRVPRV-285402026-04-19T23:22:51ZJESSE—BELL01/06/83null•••-••-1018328-207-5003-6700 SPRING STREETOrlandoFL32859-5741UNKNOWNMEDICARE-ADV-B
PRVPRV-268162026-10-06T07:49:38ZDennis—Phillips1996-12-07-—17066237718··—·725 Grand Ave·OrlandoFL32822UNKNOWN—
PRVPRV-264902026-04-30T13:12:02ZNOAH—WRIGHTJun 4, 1960UNKNOWNNULL7834840937—7972 HILLCREST RDScottsdaleAZ85253N/Anull
PRVPRV-250432026-09-09T21:21:26ZJoyceG.Price01/27/64-nullnull··null3725 JEFFERSON AVENUEColumbusOhio—-—
9,596 rows, page 13 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.689Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty