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-256862026-01-27T04:37:07ZJudy—Hoffmaan1949-11-07—•••-••-1852(823) 977-0775JUDY.HOFFMAN83@PROTON.ME9408 VALLEY VIEW DRIVEPhoenixAZ85016—null
PRVPRV-226182026-09-24T17:21:34Zbeverly····wilson05-07-1942-UNKNOWN+1 613 542 9013beverly.wilson99@yahoo.com6056 FOREST AVENUEJacksonvilleFL32289NULLN/A
PRVPRV-222972026-03-15T12:06:19ZCHARLOTTE—REYES··1942-10-20UHC-26687-68······(624) 293-6807UNKNOWN2567 CANYON ROADCharlotteNC28296··—SELECT-EPO
PRV PRV-242942026-05-16T05:28:41ZRebecca—BennettApr 27, 1948UHC-21274-89-(829) 741-8145····5990 CAMELBACK RDGILBERTAZ85268null—
PRVPRV-282632026-02-01T23:17:19ZSAM—WARREN2003-06-02UNKNOWNnullnullUNKNOWN4561 Pine Drive··MesaAZ85246—-
PRVPRV-24219 2026-01-18T07:26:50ZChristiian—OrtegaOct 28, 1989UHC-60388-18•••-••-7825(368) 361-9780null4157 Desert Sky BlvdTempeAZ85254nullOPTIONS-PPO
PRVPRV-218112026-09-17T21:06:27ZKathryn—Ramirez1944-05-02UHC-00624-02null18616212548—9294 Park Pl Apt 1GilbertAZ85281N/A—
PRVPRV-22445 2026-03-13T14:03:52ZRUSSELL—MEYER2/15/1974—N/A9374545520NULL9097 ELM STREETAustinTX78738—N/A··
PRVPRV-215862026-10-14T03:04:31ZMARILYN····FISHER1985-04-16UHC-53466-53—6327881364MARILYN.FISHER93@ICLOUD.COM4815 Sage CourtSan Antonio··TX78201··null··
PRVPRV-233572026-09-28T19:51:30ZADAMPALVARADO1941-02-23UHC2517633•••-••-55188996010adam.alvarado@hotmail.com··1044 MAIN STLos AngelesCalifornia·nullNULL—
PRVPRV-271572026-01-29T02:02:42Zmartha—·patterson1991-05-22——NULLmartha.patterson16@gmail.com7089 RIVER ROADTempeAZ85239--
PRVPRV-24281 2026-10-03T20:26:38ZMari—Wheeler1978-02-11null-12863458013maria.wheeler@aol.com6718 BroadwayAUSTINTX78778-N/A
PRVPRV-233802026-06-24T04:36:30Z Laura—Jensen2003-06-19—•••-••-05897623889708null-··N/A···N/A-N/ANULL
PRVPRV-277792026-01-12T11:51:12ZJessica—Sims2004-08-08UHC-47302-21—896-377-3056jessica.sims@outlook.comNULL·-—UNKNOWN—CHOICE-PLUS-PPO
PRVPRV-275862026-06-03T14:45:37ZAnthony—Hernandez1986-02-11UHC-00616-73—15736512891—9401 Central AveOrlandoFlorida32845NULL·MEDICARE-ADV-A
PRVPRV-252122026-06-14T07:31:00ZDavid—·Andrews1950-09-02··UHC-01919-18N/A695-400-9348—3567 Sunset BoulevardJacksonvilleFL32215NULLUNKNOWN
PRVPRV-203322026-02-28T20:25:14Z GloriaQ.Stone03/28/1954UHC-49958-85-—UNKNOWN7547 BROADWAYSeattleWA—UNKNOWN—
PRVPRV-224162026-01-21T10:10:26ZAnthony··Torres14-10-1940——845-316-7535-··6430 Palm Drive Apt 8SACRAMENTOCA95812—UNKNOWN
PRVPRV-230342026-06-21T16:26:22ZJaniceEDixon10/08/90UHC-72655-75•••-••-0350-—7673 Indian School Road··TucsonAZ85703—N/A
PRVPRV-266182026-10-10T21:07:26ZLORI··BRADLEY19600722UHC-54008-33UNKNOWN(903) 851-5267NULL75 MARKET STREETLas VegasNV·89112UNKNOWNNULL
PRVPRV-231452026-02-27T06:34:50ZBrendaD··Rojas1985-06-14—-555-659-2334—1484 GRAND AVENUE·ChandlerAZ85228——
PRVPRV-245362026-05-21T18:58:46ZDANIEL—WARREN06-05-2007UHC-75069-05—(928) 795-9436daniel.warren@outlook.com————-N/A
PRVPRV-250922026-10-04T08:08:02ZHayes, Austin··——Apr 20, 1955UHC-88677-05······727-245-5654—8554 OAK STREETJacksonvilleFL32285null-
PRVPRV-274682026-01-31T09:21:50ZPattersonN·Dorothy1963-07-14-•••-••-9861939.940.6003—3384 Cedar LnNashvilleTN37266—UNKNOWN
PRVPRV-253782026-05-08T15:21:32ZALEXIS—ORTEGA25-10-1967NULLN/A15729478817NULL8143 Palm DriveSan DiegoCA··92152--
PRVPRV-284992026-06-26T14:45:49ZAndrea—Griffin1985-06-07UHC-70467-12NULL982-656-2855—5822 Bayshore DrCharlotteNC28203NULL-
PRVPRV-262062026-02-01T18:51:10ZSara—PowellFeb 3, 2005nullN/A459-572-9223-4148 Ocean AveHoustonTexas··77044—CORE-HMO
PRVPRV-240922026-09-27T10:13:29ZKayla·P.Patel·Sep 8, 1964UHC-00656-58•••-••-9405418-901-1716KAYLA.PATEL@PROTON.ME4595 BAYSHORE DRIVETampaFL-··UNKNOWNUNKNOWN
PRVPRV-261442026-01-25T11:30:51ZYUKI··SIMPSON08/19/1971UHC9470377-235-899-2090—5732 Maple AvenueAustin··TX78756-·NULL
PRVPRV-228922026-05-15T10:01:08ZSam—·Patterson2002-06-04nullUNKNOWN(964) 389-2607SAMUEL.PATTERSON@GMAIL.COM4811 HILLCREST RDCOLUMBUSOH43253N/AN/A
PRVPRV-204302026-09-10T13:58:39ZAnnaXAnderson1992-10-03UHC-58405-22null16048405401null7973 Ocean AvePhoenixAZ85094—··
PRVPRV-274212026-10-15T20:16:01ZCatherineVDay04-07-1943UHC-08875-72NULLnull—5538 Grand AvenuePlanoTX75047—N/A
PRVPRV-277882026-08-23T12:30:26ZBRYAN—GIBSON1951-10-22··N/A—18646557342·null7359 SAGE CTOrlandoFL-—MEDICARE-ADV-B
PRVPRV-209502026-06-19T09:23:19ZChristina—Jones1975-05-11UHC-72951-01N/A+1 517 647 2759-2696 Mesa Dr··ATLANTAGA30395—-
PRVPRV-201542026-10-02T20:33:25ZJOSEPH—JORDAN10/27/1959NULLN/A·(241) 824-6598UNKNOWN6397 Highland AveSCOTTSDALEAZ85227·-MEDICARE-ADV-A
PRVPRV-211072026-01-09T07:56:08ZCrawford, Mark——1942-07-15UHC8051814—(336) 394-4959N/A9452 MESA DRIVEEden PrairieMinnesota55398—CORE-HMO
PRVPRV-265602026-05-03T04:23:32Zjacob—wallaceMay 4, 1969UHC-66285-29NULL8632623231null9419 SAGE COURTMINNEAPOLISMN55451NULL—
PRVPRV-294952026-04-16T12:21:47ZChen, Judy——06/18/80··NULL—(735) 238-0371NULL7401 Desert Sky BoulevardFresnoCA93790—····
PRVPRV-282532026-02-12T02:04:40ZSara—Moreno09/22/1942··UHC-58120-86•••-••-9377382-682-2296NULLUNKNOWN—--··-
PRVPRV-262482026-08-23T18:19:01Zsharon——1980-02-01null—+1 514 805 5266··653 Ocean AveSan DiegoCA92167UNKNOWNN/A
PRVPRV-254532026-04-26T22:14:20ZPHILIPPJOHNSON1941-09-19UHC-00083-62UNKNOWN655-454-4924philip.johnson47@aol.com2403 Oak StreetSacramentoCA95828-8833··N/A
PRVPRV-206622026-01-03T09:03:59ZHIROSHIDBAKER1/19/1984UHC-28647-99UNKNOWN14398996615··6310 Indian School RoadGlendaleAZ··85357UNKNOWNnull
PRVPRV-209022026-07-09T16:49:40ZDOUGLAS—TRAN1989-11-23UHC-80256-41—3402778579—3176 Jefferson AveSan Diego··CA·92141—UNKNOWN
PRVPRV-214352026-03-07T03:46:49ZCrawford, Robert——02/15/2006UHC-52692-57null(598) 932-4285UNKNOWN4891 Meadow Lane··SacramentoCA95837—NULL
PRVPRV-274232026-02-04T21:52:12ZARTHUR—GREENE1942-11-16-—4914654923ARTHUR.GREENE@ICLOUD.COM4951 Canyon Road·Los AngelesCA90085-0257NULLCHOICE-PLUS-PPO
PRVPRV-287742026-09-20T14:49:42ZOliver, Lucia—····1978-03-13—•••-••-3073(786) 994-0438lucia.oliver37@aol.com1236 CEDAR LN·MESAAZ85219null—
PRV PRV-278762026-04-15T19:16:53ZPamela—ShawDec 17, 1999UHC-66394-29N/A(249) 514-6270UNKNOWN6583 INDIAN SCHOOL ROADTampa··FL33690null—
PRVPRV-274112026-05-05T01:09:50Z Jose····Matthews1956-05-12UNKNOWNNULLN/ANULL2912 Hillcrest RdNashville··TN37210—NULL
PRVPRV-201772026-01-09T05:23:40ZHaroldXWest2003-10-12nullnull310-995-6201UNKNOWN9739 PINE DRMESAAZ·85270UNKNOWNCORE-HMO
PRVPRV-234922026-01-30T02:56:37ZJOSHUA—ROSS1989-12-07——+1 295 533 4474-3415 PINE DRMIAMIFL33128-4355NULL-
9,596 rows, page 166 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:43:00.503Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty