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-276642026-03-07T12:18:26ZSara—Gordon1942-10-07nullN/A+1 357 316 9412sara.gordon70@hotmail.com7925 Highland Ave··TampaFlorida33697UNKNOWNCHOICE-PLUS-PPO
PRVPRV-270832026-10-11T04:15:12ZTIMOTHYO.GRIFFIN11/03/77UHC-74484-31—(644) 301-6484timothy.griffin@yahoo.com3387 Hillcrest RdAustinTX78761UNKNOWNnull
PRVPRV-242212026-02-28T19:48:41ZJOAN—HUNTER1950-10-22··-·null(488) 681-8551—7944 WASHINGTON ST··Seattle··WA·98159—OPTIONS-PPO
PRVPRV-253112026-02-17T15:43:29ZJonathan—Wang1997-08-12—null658-989-0069NULL5706 Indian School RdJacksonville·FL·32238——
PRVPRV-210472026-10-16T07:17:54ZMatthew—Snyer2004-11-13UHC-33098-14—6039445723···matthew.snyder50@aol.com7898 Sage CourtMiamiFL33143-6522—-
PRVPRV-268102026-08-02T01:59:56ZTeresa—Chavez1980-12-08····NULLN/Ateresa.chavez24@proton.me2318 HARBOR BOULEVARDMESAAZ85214—null
PRVPRV-264102026-05-05T12:12:33ZRandyILynch··09/27/96UHC-19138-60—18787679973UNKNOWN269 Canyon RdEden PrairieMN55336UNKNOWNoptions-ppo··
PRVPRV-248752026-09-01T00:58:54ZPriya··—Brown10/04/1939—N/A9616654710NULL9357 Canyon RoadLos AngelesCA90062NULLMEDICARE-ADV-A
PRVPRV-247492026-03-10T21:02:49ZJohnston, Alexaner——2006-02-24N/AUNKNOWN··—N/A3793 Lake View RdGilbertAZ85247NULLMEDICARE-ADV-B
PRVPRV-227002026-04-05T07:47:29ZJANICE·····MENDOZA10/04/98N/A-+1 470 914 1900-8684 MAIN STREET Apt 23ScottsdaleArizona85226UNKNOWN-
PRVPRV-252942026-07-03T21:48:51ZHiroshi··Wheeler1997-03-16UHC-60484-53UNKNOWN(337) 586-9545NULL··7748 PALM DRChandlerAZ85214N/Anull
PRVPRV-227032026-08-08T15:02:42ZarjunRelliott1997-06-07UHC-67426-37•••-••-5003(579) 759-3513null6148 Grand AvenueTampa··FL··33654UNKNOWNNULL
PRVPRV-290772026-05-14T00:40:00ZMark—Gardner1966-02-12--(314) 576-0286MARK.GARDNER8@OUTLOOK.COM607 Harbor BoulevardCHARLOTTENC28207N/Anull
PRVPRV-240332026-04-18T04:50:13ZHarold—Ramos1978-08-26NULLnull208-790-5762harold.ramos@gmail.com3785 Church StreetSan DiegoCA92144-4431N/ACORE-HMO
PRVPRV-265782026-08-07T07:25:33ZHENRY—BURTON19708711UNKNOWN—6458435996HENRY.BURTON84@ICLOUD.COMN/A—NULL—null—
PRVPRV-264362026-04-11T11:09:38ZHernandez, Aisha——2005-10-20—•••-••-8718—aisha.hernandez@outlook.com4692 JEFFERSON AVESan DiegoCA92139—····
PRVPRV-240242026-09-08T21:47:49ZChristian—Owens1962-06-09null·UNKNOWNnull··1675 Sage CourtDenverCO80281····null
PRVPRV-232532026-01-03T11:32:58ZSamuel—Reyes1940-00-25—•••-••-2245825.693.9401—445 Mesa DriveCharlottenc28256N/A-
PRV PRV-271972026-01-02T03:24:53ZAngelaFWells1985-07-25null—+1 306 795 6585angela.wells49@outlook.com2563 Pine Drive·FresnoCA93715NULLNULL
PRVPRV-278262026-05-11T02:59:25ZCox, Joe——06/17/54UHC-98294-10N/A3414021-839 Grand AvenueATLANTAGA··30394null—
PRVPRV-237282026-06-11T20:40:12ZLOGAN—CARPENTER·19771008·UHC-28655-27•••-••-470714666079054-4033 Mountain View DrPhoenixAZ85052—NULL
PRVPRV-214702026-10-07T02:47:59Z·lawrenceHwardJan 7, 1983UHC-20136-99-9838497743UNKNOWN··664 ELM STREET··TempeAZ85233UNKNOWN··NAVIGATE-HMO
PRVPRV-245542026-08-24T04:31:05ZDaniel··Myers1991-01-22—N/A3248792863—2242 Camelback RdGilbertAZ85258-CHOICE-PLUS-PPO
PRV PRV-286492026-09-23T16:06:01ZGloria—Lopez1942-12-10UHC-27080-04UNKNOWN663-411-3864gloria.lopez31@icloud.com1893 CENTRAL AVENUE··TempeAZ85223·N/ANULL
PRVPRV-269652026-07-31T14:57:14ZGabriel—Nunez07/16/1974UHC-00967-47•••-••-1256491-864-2578GABRIEL.NUNEZ11@OUTLOOK.COM1549 Lake View RdMiamiFL33159··N/AMEDICARE-ADV-B
PRVPRV-224912026-06-21T07:52:06Zdavis—jason2008-11-02UHC-10468-58•••-••-8437(888) 625-8419··jason.davis@hotmail.com8435 Pine DriveGilbertAZ—·nullOPTIONS-PPO
PRVPRV-295072026-03-05T08:45:10ZROB··—RAMOS11/20/46-·nullUNKNOWNN/A5876 Indian School RoadSan AntonioTX78239nullOPTIONS-PPO
PRVPRV-242362026-09-26T04:24:41ZemilyDwells28-03-1971—UNKNOWN879.824.0310emily.wells@outlook.com2695 Mountain View DrSAN DIEGOCA···92155-····
PRV PRV-228962026-08-13T03:14:22ZGeorge—Murray14-10-1964·-NULL5265528474—2753 Central AveColumbusOhio43225N/A—
PRVPRV-279222026-08-17T16:18:07ZJohn—Henry2007-09-06··-2535758250-5444 Union StMesaAZ85214—UNKNOWN
PRVPRV-268712026-01-10T01:23:39ZSTEVE—LEWIS1945-04-19UHC-79108-37UNKNOWN708-351-1873stephen.lewis@outlook.com6070 SAGE CTScottsdale·AZ·85260—N/A
PRVPRV-216922026-05-03T09:19:47ZAhmed—·Turner1971-09-27UHC-43070-49N/A686-824-2048—7916 Bayshore Dr··Mesaaz85211nullNULL
PRVPRV-267242026-08-03T20:14:56Znoah—brown02/09/03UHC-23265-67—6379460N/A8408 BAYSHORE DRSEATTLEWA98129··null
PRVPRV-243452026-05-22T19:02:46ZJensen, Cynthia——05/28/59UHC-82520-15—NULL—454 APACHE BOULEVARD Apt 36ColumbusOH43277—NULL
PRVPRV-274752026-06-28T00:32:40Z Arthur—Washington2000-07-27——+1 725 680 2731UNKNOWN7566 Willow CourtGilbertAZ85294··-
PRVPRV-285282026-09-04T23:12:41ZFrances—Wood1962-08-02NULL•••-••-97894173919073NULL——NULLN/ANULLN/A
PRVPRV-276002026-08-04T23:20:03ZALICE—HUNTER21-08-2006UHC-81231-21—600-569-1813—2357 INDIAN SCHOOL ROAD·PlanoTX75062UNKNOWNNULL
PRVPRV-24649 2026-03-31T21:34:11ZAhmed—Meyer1981-10-19·UHC-94500-92—2555211062-5017 Canyon RdMiamiFL33130UNKNOWN-
PRVPRV-283672026-09-10T09:09:43Z Harold—Li1984-09-24UHC-16200-68UNKNOWN983.503.8749—NULLNULL——null-
PRVPRV-262172026-01-18T19:45:34ZButler, DavidG—0204-12-28UHC-58798-14•••-••-7360857-614-7972··-—-N/A-——
PRVPRV-248202026-06-27T01:39:09ZHenry—Olson19990516null•••-••-1432398-308-8282—3416 PINE DRIVEMiamiFL33112—CORE-HMO
PRVPRV-202502026-09-13T05:02:26ZCamila—Tran02-11-1973NULL-18637311081-5949 PARK PLACEMesaAZ85228····-
PRVPRV-273852026-03-22T04:22:19ZJordan, Carlos——2006-09-02UHC-81783-75N/A276-349-9443carlos.jordan7@proton.me86 Oak StreetSacramentoCA95886NULLnull
PRVPRV-214112026-03-16T00:00:46ZRYANTROSE1940-10-15UHC-20347-39-15939827627—3781 Lake View RoadNashvilleTN37221—MEDICARE-ADV-A
PRVPRV-208282026-08-18T09:41:16ZDennis—Gutierrez08-04-1984UHC4152439N/A9526327283UNKNOWN9635 Mountain View DrSeattleWashington98132·UNKNOWNNULL
PRVPRV-207582026-06-03T03:20:07ZRuth—Vargas·2001-04-09—null8469270847N/A7794 Union StGlendale···Arizonanull—SELECT-EPO
PRVPRV-242292026-08-08T08:25:52ZMary····Weever1944-05-01UNKNOWNNULL288.422.0512N/A··2173 Main StGilbertAZ85268UNKNOWNCHOICE-PLUS-PPO
PRVPRV-207972026-05-06T12:50:29ZLuis—Wallace··1939-02-04UHC-03439-03UNKNOWN+1 445 593 1112NULL···6713 Main St·ColumbusOH43232NULLNULL
PRVPRV-242352026-06-13T22:05:12ZSTEPHEN—ROMERO1987-01-15UHC-58897-97null·764-491-2566—7926 Camelback RoadEden PrairieMN55316····—
PRVPRV-287392026-06-15T21:26:58Z·DonaldWAlvarez1944-10-03UHC-12281-73•••-••-8095·3435573286-2697 Central AvenueGilbertAZ85244—NULL
9,596 rows, page 135 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.748Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty