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-289282026-05-24T23:21:46ZGarrett, Janet——1995-11-27—-4366904995—6771 BroadwayMiami·FL33154--
PRVPRV-261212026-01-26T16:49:55ZDavis··Deborah1953-07-11UHC-21383-58•••-••-5053·(596) 386-2981—9882 VALLEY VIEW DR··AUSTINTexas78745—-
PRVPRV-286542026-06-20T04:59:05ZDickOHarrisonSep 9, 1953-—(778) 279-7982-··9432 Grand AveFresnoCA93778··CHOICE-PLUS-PPO
PRVPRV-216622026-05-04T09:36:35ZChristineDElliott3/8/1956·UHC-65978-88•••-••-39542184941420-2209 Hillcrest RoadCharlotteNC28215NULLnull
PRVPRV-264442026-04-05T02:11:40ZJoan, Larson——9/16/1949NULL•••-••-5168——2943 Pine DrTempeArizona—UNKNOWNUNKNOWN
PRVPRV-284532026-10-16T02:53:19ZJOANTCOLEMAN2002-05-25null·N/A551-424-6119joan.coleman@outlook.com6592 Willow Ct Apt 32··TampaFL33636-—
PRVPRV-231622026-04-29T22:15:59ZELIZABETH··ESPINOZA1945-07-01UHC-70832-05—UNKNOWNELIZABETH.ESPINOZA52@GMAIL.COM3005 DESERT SKY BLVD··GlendaleAZ85373N/AN/A
PRVPRV-213672026-10-07T04:39:26Z Morgan—Benjamin1941-05-03nullUNKNOWNN/A-8904 Main Street Apt 25Fresno··CA93709nullN/A
PRVPRV-213972026-03-10T13:42:13ZNicoleKOrtega13-09-2005··--NULL-376 Baseline RoadCHANDLERAZ85283nullnull
PRVPRV-26892 2026-01-28T15:18:36ZAmber—Lawrence4/18/1978UHC-53728-11—(808) 488-8038-1461 Bayshore DrFresnoCalifornia93794——
PRVPRV-261362026-08-07T00:53:33Z·Donna—Sullivan19980101UHC-84309-27N/A5786888092NULL7269 Broadway·AtlantaGA30393--
PRVPRV-232182026-09-19T14:40:34ZSofia—KignOct 18, 1959UHC-08034-30—NULL··NULL————-—
PRVPRV-241872026-04-20T21:48:36ZjacquelineJ.montgomery28-10-1946——(659) 879-8371·JACQUELINE.MONTGOMERY25@AOL.COM4351 HARBOR BLVDEden Prairie···mn55344··NULL-
PRVPRV-224872026-05-04T14:28:11ZAdams··—Jacqueline19960609UHC6521545N/A··—5404 Spring StreetHouston··TX77067—-
PRVPRV-231272026-08-22T06:48:07ZEddie—Daniels1985-10-27UHC-52432-11-··+1 334 317 2163—8035 CENTRAL AVENUETampa·FL33615—NULL
PRVPRV-209632026-10-08T00:41:35ZGrace—Bell··1995-11-19·UHC-02851-25—2544018753··6185 RIVER RDSan Antoniotx78256UNKNOWN-
PRVPRV-225072026-08-10T16:50:58ZDon—Fialds1981-05-24UHC-22806-16•••-••-07994973747885donald.fields68@icloud.com7784 BroadwayHOUSTONTexas77076—··
PRVPRV-21474 2026-10-09T13:06:14ZJANICE—COX1955-09-19UHC-66627-67•••-••-74364294239462null··6590 Elm StreetEden PrairieMinnesota55304UNKNOWN—
PRVPRV-233032026-08-30T15:16:19ZCarlson, Ana——1940-37-18N/A··•••-••-1490320-280-1604—6642 CHURCH STColumbusOH43287—-
PRVPRV-273432026-08-04T13:50:35Zkelly—burton10/12/80·UHC0639861•••-••-6096767-458-7524N/A9072 Park PlaceDALLASTX75217-8631N/A—
PRVPRV-28191 2026-05-29T03:56:08Z·Aaron—Reid1968-04-25-N/A764-579-5913null1642 APACHE BLVDMIAMIFL·33146—-··
PRVPRV-216152026-07-30T04:30:45ZMason··Gomez··1962-04-19-UNKNOWN7955081423····3565 HILLCREST ROADGilbertaz85264··—
PRVPRV-208662026-04-19T19:11:27ZFields, LarryZ—1965-01-26UHC-33543-82N/Anull—9784 Forest AveHOUSTONTX77060—NULL
PRVPRV-279552026-01-06T08:26:43ZJustin—Nichols1978-08-23NULL—280-793-7863—7207 HIGHLAND AVEPlanoTX75083nullnull
PRVPRV-272532026-04-14T08:09:17ZVALENTINA—KENNEDY19430806UHC-03137-73nullUNKNOWNUNKNOWN5500 Ocean AveGlendaleAZ85369-null
PRVPRV-255862026-08-22T06:58:44ZELIJAHBRUIZ1981-01-18N/ANULL241-415-0805elijah.ruiz@aol.com1368 GRAND AVENUEMesaAZ85249—UNKNOWN
PRV PRV-240832026-06-08T12:06:54ZSOPHIA—HART1944-01-04UHC-60761-45-690-470-5630-··4177 Grand AveLas VegasNV89109NULLN/A
PRVPRV-234832026-07-21T16:06:30ZMichael··Bishop··05/08/41—N/A12478581256—5310 LINCOLN WAYTempeAZ85231N/ACORE-HMO
PRV PRV-271182026-06-23T16:28:33Zdanielle—herrera1948-03-21··UHC-14995-82····14577387148NULL3140 Lincoln WayDENVERColorado80238-9269UNKNOWNN/A
PRVPRV-237442026-07-12T13:29:11ZAllen, Gloria——1976-12-08··UHC-05703-45N/A3084703302N/A585 River RoadAustin·TX78773-8631—NULL
PRVPRV-250482026-09-01T02:59:54ZFrank—Knight16-12-1986··—UNKNOWN5119229frank.knight94@aol.com··UNKNOWN-····N/A··N/A
PRVPRV-257402026-01-07T22:08:55ZNAH—ROBERTS1953-07-09··UHC-09396-38null+1 685 836 2098noah.roberts72@hotmail.com5412 MAIN STREETMESAaz85216-NULL
PRVPRV-248672026-03-24T16:45:54ZRamirez, Kimberly——9/17/1961UHC-25631-35—942-443-7075-8356 PARK PLDALLASTX75263··—
PRVPRV-239272026-04-16T16:52:27ZKELYL—·HARTJan 16, 1972UNKNOWN•••-••-5185+1 338 778 4809NULL1560 Canyon Road Apt 25MiamiFL33199null—
PRVPRV-23658 2026-01-24T17:57:32ZBrendaM.Hery2004-01-05UHC-97888-54NULLnull—·2034 Cedar LnCHANDLERAZ85232--
PRVPRV-246922026-05-12T07:07:04Zmason—austin19861216UHC-03632-16—(605) 347-7192N/A4635 Willow CtDallasTX75217NULL—
PRVPRV-256922026-02-13T16:09:19ZBerry—Keith·2006-04-02N/A——UNKNOWN810 VALLEY VIEW DRIVEMesaAZ85262--
PRVPRV-237272026-03-24T16:13:17ZASHLEYD.SCHMIDT01-03-1947·nullnull865.840.8318··UNKNOWN4122 Grand AveTucson·AZ85714—null
PRVPRV-247952026-06-30T02:26:07Zarjn——21-04-1986UHC-50680-83•••-••-25227978268816—2780 Spring StreetLos AngelesCA90063N/A—
PRVPRV-262732026-04-30T05:41:03ZCarol—Rose1975-01-26UHC-39091-36-4889698carol.rose89@outlook.com4217 Willow CourtTampaFL33639UNKNOWNUNKNOWN
PRVPRV-279762026-02-07T03:32:46ZHudsonKAlexander19640317UHC-67582-64•••-••-7341412.639.4110—965 Hillcrest RoadGILBERTAZ·85290-1709UNKNOWNOPTIONS-PPO
PRVPRV-265122026-09-30T21:52:33ZPRIYA—ALLEN9191-02-12UHC-44110-15UNKNOWN+1 575 279 6999UNKNOWN4591 MAPLE AVETampaFL33688nullCORE-HMO
PRVPRV-254242026-05-15T01:40:32ZNicoleB··KimJan 20, 1945UHC-08143-43—2258863384·nicole.kim71@gmail.com9473 JEFFERSON AVENUE #868GlendaleAZ85350UNKNOWNCORE-HMO
PRVPRV-247752026-04-26T23:16:39ZDANIELLE—FOSTER1954-06-27UHC-72462-66UNKNOWN+1 837 539 5481-4979 Sage Ct·OrlandoFLUNKNOWN—N/A
PRVPRV-27874 2026-05-30T07:53:12ZRebeccaDMeendoza03/10/2006——UNKNOWN-9585 Baseline Road #463HoustonTX··77094-N/A
PRVPRV-217972026-07-25T12:38:44Z·Patricia—Diaz12-12-1988UHC-24304-39N/A224.914.3798patricia.diaz7@aol.com1160 Washington StreetMinneapolisMN55427—-
PRVPRV-230572026-03-01T03:49:23ZPAUL—·BAILEYJan 6, 1947UHC-74026-83N/A3434219269N/A2994 Pine DrLas VegasNevada-NULLOPTIONS-PPO
PRVPRV-255382026-09-18T07:01:39ZCarl—Burke1952-04-12N/A-12152580897—9767 Willow Ct··MinneapolisMN·55464-8952—SELECT-EPO
PRVPRV-212922026-01-01T23:20:02ZBryanNFreeman11/21/1951N/Anull17866862770—7670 Valley View DrivePlanoTX75079—·choice-plus-ppo
PRVPRV-210802026-04-09T09:10:32Z Green, Fatima——1/19/1971UHC-56858-96—8975855235—764 River RdMINNEAPOLISMinnesota55442-1107-—
9,596 rows, page 189 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:03.754Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty