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-220672026-05-16T09:10:47ZHeather—Vazquez1979-12-04—UNKNOWNUNKNOWN—5238 Harbor Boulevard Apt 2ChandlerAZ85258null—
PRVPRV-267602026-09-26T08:32:13ZPeter—Johnson1978-09-24null—233.582.4895—1545 Spring St·San DiegoCA—nullSELECT-EPO
PRVPRV-233762026-03-30T02:07:35ZYUKI—PETERSMay 8, 1998N/A•••-••-0281(827) 261-5075yuki.peters51@gmail.com890 OAK STAUSTINTX78744··null—
PRVPRV-207192026-07-14T07:30:58Zalexis—nguyen··1960-09-04null•••-••-6830(424) 761-5077alexis.nguyen90@yahoo.com9279 FOREST AVENUE #208HoustonTX77040UNKNOWN-
PRVPRV-272592026-02-22T15:00:29Zdanielle—grahaam10/18/85·UHC-01900-59····(377) 501-1977NULL··null—UNKNOWNUNKNOWN——
PRVPRV-294632026-03-15T21:04:46ZNICOLE—ORTEGA2003-03-20UHC-23371-21UNKNOWN830-503-7171NICOLE.ORTEGA@AOL.COM2244 Maple Ave #939·FRESNOCAUNKNOWNnullUNKNOWN
PRVPRV-236702026-07-27T03:20:43ZAbigail—Alexander19400304NULLNULL(582) 291-4748-6190 INDIAN SCHOOL RDAtlantaGA30392NULL-
PRVPRV-291892026-08-05T07:35:23ZFrancesR.··Bowman1966-06-16NULL—(405) 460-0635—6951 Union StreetGILBERTAZ85266null··—
PRVPRV-273652026-04-13T00:04:35ZDebra·NSchmidt19410821UHC-39182-52·null5129037debra.schmidt25@gmail.com1984 Jefferson Avenue·TempeAZ85232—NULL
PRVPRV-203882026-09-30T09:47:04ZJULIE—ROMERODec 17, 1940UHC-28284-55-··nullUNKNOWN5302 Apache Boulevard··DenverCO80229—N/A··
PRVPRV-206782026-03-19T02:12:50ZBETTY—LUCAAS1984-12-10UHC-91442-85··—631-659-9428-··8176 Mesa Drive··NashvilleTennessee37212····—
PRVPRV-243812026-05-30T21:00:10ZDouglas··Carpenter1945-07-21—NULL4924136877DOUGLAS.CARPENTER76@OUTLOOK.COM3423 Jefferson AvenueTampa·Florida33648NULLN/A
PRVPRV-220582026-02-24T17:41:15ZJUAN—BURTON1964-08-28UHC-41210-57—··—7543 RIDGE RDLos AngelesCA90005UNKNOWN—
PRVPRV-264962026-03-26T16:19:07Z·JudyAEdwards1992-08-01UNKNOWNN/A277.451.1115—501 Palm DrGilbertAZ85223UNKNOWN-
PRVPRV-274722026-01-22T03:07:08ZDaniel····Hudson1996-07-23UHC-33246-35N/A435.891.4542DANIEL.HUDSON3@HOTMAIL.COM8069 LINCOLN WAYJACKSONVILLEFL32245NULLNULL
PRVPRV-210112026-08-17T11:53:28ZBRADLEY—GILBERT03/24/05NULL•••-••-8205—bradley.gilbert@outlook.com600 MAPLE AVENUE··Las VegasNV89123NULLnull
PRVPRV-211312026-05-25T00:55:47ZSHARON—VASQUEZ14-08-1943UHC-15996-02—(842) 988-2868N/A2682 BroadwayPhoenix···AZ85078UNKNOWN-
PRVPRV-217992026-01-06T05:45:54ZStephenDSimpson1999-12-10UHC2857029—18766063654stephen.simpson@hotmail.com4833 WILLOW COURT Apt 40SacramentoCA95891NULL-
PRVPRV-257052026-09-14T03:28:29ZGERALD—BANKS1998-10-17—null16513665118NULL1424 Desert Sky BoulevardMesaAZ85258——
PRVPRV-253832026-09-27T07:49:29Zchristopher—cunningham02-03-1990UHC0911169··-··8775872086—9136 Apache BoulevardSeattleWA98120-OPTIONS-PPO··
PRVPRV-294762026-03-02T20:45:40ZCatherine—Harris1994-08-16UHC-89494-51UNKNOWN351-470-8871catherine.harris@proton.me2084 Lincoln WayChandlerAZ85269N/ANULL
PRVPRV-255882026-09-02T06:57:52ZBRIAN—WARREN04/15/1987—•••-••-9029+1 675 786 5821—3951 Central Ave··CHANDLERAZ85206nullNAVIGATE-HMO
PRVPRV-259322026-04-26T00:05:11ZBrittany—AdamsJun 11, 2005UHC-46200-50··—15989978463—UNKNOWN—NULLNULLUNKNOWNUNKNOWN
PRVPRV-266472026-02-24T10:10:54ZNicoleQ·Thomas1999-04-10UNKNOWN—(930) 918-4924··—5300 Maple AvenueMesaAZ85212-5447·null—
PRVPRV-203892026-07-25T10:37:42ZSTEVEN—LEWIS11/08/1941UHC-52617-07····N/AN/A5512 Ridge RdGLENDALEAZUNKNOWNUNKNOWNCORE-HMO··
PRVPRV-238442026-09-17T16:36:11Z FrankQBailey··6/25/1949UHC-20314-33•••-••-4506nullfrank.bailey19@icloud.com7687 Indian School Road Apt 20Las VegasNV89150—N/A
PRVPRV-203062026-09-23T16:19:29Zgilbert—josseph1946-07-21··——joseph.gilbert@gmail.com2818 BAYSHORE DRIVE··TucsonAZ85738—··
PRVPRV-203562026-08-20T18:05:02ZNatalieHWilliams1960-03-13—N/A467-844-9886nullnull--null—-
PRVPRV-260502026-08-04T07:16:37ZCarol—Ortega1996-01-15UHC-51717-73NULL(596) 780-3069UNKNOWN5241 Central AvenueTAMPAFlorida··——OPTIONS-PPO
PRVPRV-232172026-08-13T14:19:29ZCatherine—Cunningham1972-06-16NULL•••-••-58518886127NULL615 River RoadSacramentoCA95837-7749NULLN/A
PRVPRV-228222026-03-27T02:33:20Z alan—ramos9/24/1971UNKNOWN——ALAN.RAMOS88@HOTMAIL.COM34 WASHINGTON STSEATTLEWA98132-NULL
PRVPRV-211512026-08-12T03:42:08Zkenneth····payne10/27/73UHC-66838-75•••-••-1693N/Akenneth.payne@yahoo.com4077 Grand AveChandler··Arizona85223—null
PRVPRV-267382026-10-07T21:35:09ZChris—Contreras08/03/08UHC-67401-81•••-••-5916445.339.2976NULL5571 Meadow Ln Apt 40OrlandoFL32849nullN/A
PRVPRV-208822026-10-15T19:31:32ZRALPH—SHAW1955-09-18··UHC-87502-98-813-500-7335RALPH.SHAW53@AOL.COM6408 Central AveSan AntonioTX78238NULL—
PRVPRV-239192026-04-23T23:37:01ZRICHARD—GREENE1997-02-19—·N/AUNKNOWNUNKNOWN1273 Spring StMiamiFL33191N/AMEDICARE-ADV-B
PRVPRV-258222026-01-07T04:09:00ZArthur··Sanders01/06/1946·N/Anull708.288.5927arthur.sanders@gmail.com8522 MAIN STREET #670OrlandoFL32809—MEDICARE-ADV-B
PRVPRV-285182026-02-28T17:27:02ZKAYLA—MITCHELL01/11/1985—•••-••-250819583016221kayla.mitchell80@icloud.com·5324 Desert Sky BoulevardMiami··FL33121·-—
PRVPRV-219362026-06-13T13:59:13ZDouglas—Garza·15-09-1946UHC-82645-48·-12734276134—1168 Cedar LnPhoenixAZ85069null—
PRVPRV-271462026-08-31T08:22:18ZJamesWFowler··1961-09-11·UHC-97018-67—623-325-7956—2069 Palm DrDENVERCO80294nullNAVIGATE-HMO
PRVPRV-288732026-03-26T18:01:32ZRobinson, Patrick—··1971-12-01NULL—596-335-5452—1715 Ridge RoadDenverCO80231··null-
PRVPRV-292562026-01-02T16:45:28ZMARIAHCRUZ1976-05-06UHC5366081—+1 960 555 3923N/A629 Market StreetSAN DIEGOCalifornia92110—OPTIONS-PPO
PRVPRV-252712026-08-19T19:55:14ZJustin—Johnson19920302—UNKNOWN654-795-9197justin.johnson@gmail.com3789 VALLEY VIEW DRIVE··Eden PrairieMN55304-2566NULLNULL
PRVPRV-266352026-06-12T12:12:10Zsean—gardner1964-07-20UNKNOWN—7313075480—9447 Lake View RoadSeattleWANULLUNKNOWN-
PRVPRV-237402026-08-09T18:36:20ZNICHOLAS—PRICE19420903UHC-89676-44N/A+1 826 686 8530nicholas.price44@icloud.com5158 Baseline RoadFresnoCA93794N/A-
PRVPRV-261852026-04-19T14:21:59ZRUSSELL··G.BELL2006-04-02nullnull298.796.8758—2688 Jefferson AvenueAtlantaGA30380nullN/A
PRVPRV-254552026-02-18T18:20:07ZANN—SIMPSON2006-01-05—•••-••-586818725507612··2030 Central AvenueGilbertArizona85268——
PRVPRV-226902026-04-15T17:21:02Z·JOSAPH—LEWIS01/13/46···UHC-59337-92•••-••-57134262786896··joseph.lewis1@yahoo.com6639 Mountain View DrGilbertAZ·85244NULL-
PRVPRV-20368 2026-02-01T07:31:54ZFordEJudy1982-07-24UHC-04242-46—9522956028null—UNKNOWN-N/A——
PRVPRV-268592026-07-13T08:37:29ZWillam—Knight··1940-02-10uhc-41179-03······(353) 587-9695—267 Grand AveLos AngelesCA90070—-··
PRVPRV-29148 2026-03-30T17:31:31ZBruceT.Rodriguez10/12/1960UHC-81012-41—2356127113UNKNOWN8269 Market StreetMesaAZUNKNOWN—CORE-HMO
9,596 rows, page 45 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:40.340Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty