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-230982026-03-07T02:04:52ZKeith—Olson2006-03-05-N/A(949) 404-8924NULL500 Highland AvenueSacramentoca·95828null—
PRVPRV-272102026-09-25T15:31:52ZWeiHSanders··05/27/1961·UHC-34725-21•••-••-58788345113721N/A1824 BroadwayJACKSONVILLEFL——select-epo
PRVPRV-240372026-03-18T22:17:04ZMASON—RIOS14-09-1950··UHC-34110-11—220-822-0528·MASON.RIOS18@AOL.COM8770 Washington Street Apt 16GlendaleAZ85340N/AMEDICARE-ADV-A
PRVPRV-250552026-09-19T02:34:04Zyuki—rios11/21/79··-(542) 579-7223—2827 Central AveORLANDOFL32883nullN/A
PRVPRV-216642026-02-19T20:19:35Z·maggie—obrien5/3/1985UHC-19518-51•••-••-00632982673659margaret.obrien86@gmail.com··1406 Elm StreetNashvilleTN37286—UNKNOWN
PRVPRV-240542026-08-09T11:38:49ZKIMZJONES1968-08-16—•••-••-0388nullkimberly.jones@hotmail.com6153 Central AveColumbusOH43271·null—
PRVPRV-249552026-05-20T15:41:17ZAhmed, Lewis——11/18/1986NULL•••-••-1152(791) 477-9822ahmed.lewis@outlook.com1864 Baseline RoadMiamiFL33155null—
PRVPRV-233502026-03-10T20:06:15Z·Deborah—Howard08/08/1958UHC-46791-90null··4137536810—6384 Maple Avenue·Eden PrairieMNNULLN/ANULL
PRVPRV-264532026-10-09T07:41:47ZJoshua··Phillips1955-12-12UHC-93601-34null(940) 502-7434JOSHUA.PHILLIPS@ICLOUD.COM7125 Church StTEMPEAZ85288··nullN/A
PRVPRV-244282026-06-05T21:44:15ZMarianaM.Robertson··2004-08-20UHC5975005•••-••-0050·7085404—5340 DESERT SKY BOULEVARDDenverCO80211UNKNOWNNULL
PRVPRV-259062026-08-13T01:11:44ZLuca··—Thompson1985-12-14N/A—12434166660lucia.thompson@aol.com19 Pine DriveSan AntonioTX78223—UNKNOWN
PRVPRV-280762026-02-04T08:23:23ZANTHONY—OLIVER24-09-1962UHC-51791-98··•••-••-0626(587) 757-2903—697 Meadow LanePhoenixArizona—NULL—
PRVPRV-248632026-03-19T01:35:57ZTHERESA—GUTIERREZ1996-02-01——898.444.1622theresa.gutierrez@aol.com2091 HARBOR BLVDMinneapolisMN55445——
PRVPRV-233222026-10-01T07:40:31ZAaron—Webb1964-02-02UHC-01857-64NULL(324) 284-7345··null8555 Apache BlvdSan AntonioTX78290NULLUNKNOWN
PRVPRV-290212026-06-02T13:55:02ZAnaEKing1983-04-14·UHC-25436-16N/A3803949632-··5915 PARK PLORLANDOFL32850——
PRVPRV-278362026-02-20T05:53:16ZLopez, Isabella——·1942-02-10UHC-11066-76NULL··-2688 Maple AveNashvilleTN37280NULL··null
PRVPRV-240382026-06-18T19:34:44ZLawrence··—Wright1981-12-16—-6045844216·lawrence.wright@hotmail.com2780 Harbor BoulevardScottsdaleAZ85242——
PRVPRV-277342026-02-20T13:45:05Z Nicholas····Arnold05/18/82UHC-60710-65•••-••-4873——6306 Indian School Rd··GilbertAZ85226-N/A
PRVPRV-250282026-04-15T04:42:56Z·Woods, Ana——1999-12-10····—3853935205—9524 Broadway··Las VegasNV89124N/ACHOICE-PLUS-PPO
PRVPRV-267292026-05-13T23:58:57Z ANDREA··GOMEEZ10/27/1987UHC-49598-70UNKNOWN(734) 586-9631ANDREA.GOMEZ72@AOL.COM9419 Sunset BoulevardTUCSONAZ85762——
PRVPRV-207002026-06-20T21:25:21Zhelen··—harvey·1942-02-24UNKNOWN—(336) 451-2165HELEN.HARVEY59@OUTLOOK.COM9675 BROADWAYNashvilleTN37203·-null
PRVPRV-244122026-06-19T22:21:10ZCarlos—·Estrada1968-05-07—null(902) 324-2819NULL2063 Hillcrest Rd·San DiegoCA92165—UNKNOWN
PRVPRV-223732026-04-03T23:02:59ZSTEVEN—MILLER3/21/1943UHC-50421-83NULL+1 205 783 4352null6461 GRAND AVETampaFL33623—UNKNOWN
PRVPRV-225252026-01-16T06:20:58ZDean, JoseP—5/2/1950UHC-46188-06—UNKNOWN·jose.dean17@proton.meNULL-NULL-—N/A
PRVPRV-239012026-07-22T20:08:19ZBOBBY—MILLER1995-01-10UNKNOWN—nullUNKNOWN—--UNKNOWN—-
PRVPRV-275752026-08-31T22:35:30ZBrenda—Wells1961-07-12UHC-70706-56•••-••-7837650.734.5717-5623 Maple AveMESA··AZ85251-2936UNKNOWN—
PRVPRV-261242026-07-09T02:56:21Z·Fatima—Kelly19730610UHC7617665—18454184269fatima.kelly9@icloud.com··4014 Jefferson AvenueMesaAZ85237—N/A
PRVPRV-281362026-07-21T20:12:02ZWILLIE—BAILEY1973-10-24UHC4537087null(673) 286-4536NULLnull—NULL-—null
PRVPRV-253542026-09-27T17:00:01ZKaren—Hawkins1994-05-18UHC-25363-23——·N/A2740 Meadow Ln·PlanoTX75044nullN/A
PRVPRV-265682026-04-26T07:24:37ZJaniceRWong1966-03-21—null——3914 Sunset BlvdFRESNOCA93741-N/A··
PRVPRV-259922026-02-09T20:59:28ZFrances—Valedz19570424—-——9052 PARK PLACEGlendale··Arizona85345NULL··
PRVPRV-222182026-02-05T05:42:39ZLawrence—Maldonado9194-07-20UHC-97544-20null—NULL7498 Main StreetGlendaleAZ85367-9089··——
PRVPRV-285562026-09-12T06:36:40ZWebb, CarlosA.—12/20/1949UHC-82977-74NULL(878) 304-0123—N/A——-NULLSELECT-EPO
PRVPRV-242072026-01-29T00:32:12ZAnna D.—Park1983-12-27uhc-82241-54····290.626.7195UNKNOWN68 BroadwaySan DiegoCAUNKNOWNNULLNAVIGATE-HMO
PRVPRV-290622026-09-02T18:55:45ZSaraQGuzman06/15/1964—·nullNULL-1638 Washington StreetSacramentoCA95816—CORE-HMO
PRVPRV-261722026-09-25T22:38:07ZBrenda··Jenkins06/28/98·NULL—445-234-7436brenda.jenkins@proton.me8124 RIDGE ROADLas VegasNV89173—OPTIONS-PPO
PRVPRV-292772026-06-29T23:52:30Zhenry—rojas1974-05-02—•••-••-1350(347) 293-7102N/A7604 Hillcrest RdTEMPE·AZ85216N/ACHOICE-PLUS-PPO
PRVPRV-277652026-05-19T05:26:59ZWhite, Joshua——19410409UHC-26246-17N/A12104142977···-7062 Elm StMiamiFL33175nullNULL
PRVPRV-283882026-09-07T22:42:46ZRobert—Gilbert10-01-1967NULLnull963.202.3528—8431 Oak St·DenverCO80231····—
PRVPRV-206602026-03-09T03:05:55ZLINDA—BOWMAN1978-04-25UHC-84271-43-3676944980UNKNOWN1878 INDIAN SCHOOL ROAD #201Chandler··AZ85263UNKNOWNNULL
PRVPRV-273962026-08-30T11:56:13ZTim—Clark1948-06-25-•••-••-2985704.897.5860UNKNOWN1128 BroadwayPHOENIXAZ85074-8244N/A—
PRV PRV-269252026-07-18T02:09:38ZVICKY—CLARKNULL·UHC-04405-72—7023078648victoria.clark72@icloud.com7958 INDIAN SCHOOL RDScottsdaleAZ85247—-
PRVPRV-267082026-02-17T20:11:13ZArthurWRios1972-11-23UNKNOWN—4303402335arthur.rios60@aol.com8018 ELM STGlendale··AZ85335--
PRVPRV-248982026-05-28T14:20:46ZMARTHA—FLORES10/16/1956UHC-46994-53UNKNOWN7377016721—NULL··——-NAVIGATE-HMO
PRVPRV-237382026-10-04T03:22:09ZBryan··Murray1995-11-15UHC-67709-72N/A4107677508NULL6402 Mesa Dr #507Chandler·AZ85239UNKNOWNOPTIONS-PPO
PRVPRV-274362026-01-17T15:22:08ZDianeS··Moore1940-11-02UHC-33475-05•••-••-9520490.647.0638NULL3407 Desert Sky BoulevardChandlerAZ·85296——
PRVPRV-263482026-07-15T22:20:12Z·Ruiz, FrancesL—16-03-1994--3817942729—9212 MAIN STREETAtlantaGA30353N/A··null
PRVPRV-28778 2026-04-05T19:26:39ZJACK—PIERCE—UHC-70363-83null——8375 SPRING STEden Prairie··MN55337····null··
PRVPRV-273462026-01-04T10:19:28ZJason—·Willis1938-04-20UHC-58129-66——jason.willis91@hotmail.comnull—UNKNOWNUNKNOWN—CHOICE-PLUS-PPO
PRV PRV-248942026-03-13T04:56:29ZEthan··—Ramos1942-05-17UHC-43094-43•••-••-9667524.672.4027UNKNOWNUNKNOWN—NULL····UNKNOWN-
9,596 rows, page 122 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:53.133Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty