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-286422026-07-02T23:13:53ZJacob·JEstrada2/10/2003N/A·NULL(763) 524-6727—3162 PARK PLACE··MIAMI··FL33198UNKNOWN—
PRV PRV-295732026-04-02T12:44:51ZMadison··U.Thomas05/25/45N/A··UNKNOWN385.386.3289-9336 Maple AvenueMinneapolisMN55440——
PRVPRV-250612026-04-12T07:23:07ZSarah—Jenkins04/18/1938··-—-UNKNOWN4815 Ridge RoadORLANDOFL32889—-
PRVPRV-232012026-02-08T22:09:31ZLAURENZSCHMIDT17-01-1973—NULL3603419548—4410 LINCOLN WAY #409HoustonTX77025—··
PRVPRV-235592026-01-10T09:38:21ZSOPHIA—MURPHY··1975-06-15——4433302133····7694 Pine DriveGlendaleaz85314—UNKNOWN
PRVPRV-233122026-08-15T01:29:22ZLinda—Smith1989-09-17UHC-68199-20•••-••-6889890-945-0678NULL6905 Hillcrest RdTempeAZ85222··—
PRVPRV-265442026-04-28T02:51:15ZJenkins, Caimla——1941-05-25null•••-••-67867182886714null7506 Market StreetMINNEAPOLISMN···55423—UNKNOWN
PRVPRV-260342026-09-02T23:49:09ZMelissa—Ramos2002-06-10UHC9903101-+1 876 376 9108NULL7751 BAYSHORE DRChandlerAZ85233··UNKNOWN
PRVPRV-230892026-05-26T20:43:57Z·AARON··REID22-12-1996——(712) 304-0949AARON.REID15@HOTMAIL.COM9152 Jefferson AveMESA·AZ85276—N/A
PRVPRV-262132026-09-07T13:40:25ZJerry R—Garrett04/05/70··——·(406) 504-0895-4320 Valley View Drive·OrlandoFL——null
PRVPRV-235292026-01-12T16:44:22ZDenise—·Estrada12/20/79N/A•••-••-8896N/AUNKNOWN··9543 Highland AveCOLUMBUSoh··43252—UNKNOWN
PRVPRV-205742026-07-07T11:29:29ZSARAHDGRANT01/04/99-—3543233551sarah.grant@aol.com4672 CANYON RDMinneapolismn55413NULLSELECT-EPO
PRVPRV-291462026-05-26T23:13:03ZStephanie··—Brown1980-11-02UHC-58523-40NULL16625605636NULL7753 Desert Sky BlvdJacksonvilleFL32297N/AUNKNOWN
PRVPRV-235762026-03-01T07:53:14ZHeather—Berry09/19/49··—842-708-4547NULL1192 Hillcrest RoadScottsdaleAZ85284UNKNOWNNULL
PRVPRV-207352026-03-26T08:37:25Z DOUGLAS·····MORGAN·1974-01-02UHC-20227-50null(778) 390-0003NULL4328 Grand AveChandlerAZ85207-5376NULL—
PRVPRV-21017 2026-08-10T23:43:29ZERIC—WOODS1986-03-05—•••-••-6096-eric.woods57@icloud.com9334 SUNSET BLVDOrlandoFL32817null-
PRVPRV-282402026-07-25T01:37:31ZDiana··Brooks1970-11-24UHC-64888-77•••-••-8872(669) 660-3198UNKNOWN-null——UNKNOWNMEDICARE-ADV-B
PRVPRV-281002026-04-05T16:23:23ZRosA.Gary6/13/1970NULLN/A(801) 534-0747·null6125 Sunset Blvd·ColumbusOhio43268NULLchoice-plus-ppo
PRVPRV-217432026-03-11T18:13:01ZZachary—·Harris·1972-03-02null—7524419031··N/AN/Anullnull··nullUNKNOWN
PRVPRV-27488 2026-06-24T12:57:14ZPerkins, Sean——1943-10-17-N/A—··2758 HARBOR BLVDMesaArizona85242—N/A
PRVPRV-286082026-03-04T20:31:22ZJANETBMYERS··1976-03-26UHC-34234-73—3436329039janet.myers99@outlook.com1433 Jefferson AveJacksonvilleFL32206-2213N/ASELECT-EPO
PRVPRV-255022026-04-08T23:07:51ZROYQ.SIMPSON1956-07-16nullnull9677755119—9767 HARBOR BOULEVARDGilbertaz85278—N/A
PRVPRV-205662026-04-08T00:12:12ZMontgomery, Katherine——1996-08-07UHC-26954-37—(932) 554-5090··katherine.montgomery@outlook.com6855 SUNSET BLVDTEMPEAZ-—·N/A
PRVPRV-24962 2026-01-08T05:51:53Z·Robert—Vargas1940-08-18UNKNOWNUNKNOWN(821) 720-1848—7375 BASELINE ROADJacksonvilleFlorida32228NULLnull
PRVPRV-267232026-06-26T00:34:56ZTerry—Turner1971-11-01——2737798336N/A1967 Valley View DrHoustonTX77002——
PRVPRV-231842026-04-04T09:56:02ZGloria····Gordon1952-09-04·NULL•••-••-73513825752341NULL-—-—NULLnull
PRVPRV-232852026-06-07T23:25:38ZRyan—WoodsMay 18, 2003—UNKNOWN9485923241null3049 Church StEden PrairieMN55361——
PRVPRV-252602026-05-28T23:52:39ZGraceSRomeroAug 24, 1978··N/A—6328209186null6656 LINCOLN WAYNashville··TN37237——
PRVPRV-290652026-09-18T00:03:56ZSarah—Dunn·1966-04-16N/AUNKNOWN2545140687··N/A4136 Grand AvenueDALLASTexas··75268······OPTIONS-PPO
PRVPRV-249162026-06-02T22:23:50ZJUILA—HANSEN07/22/1986null··—662.489.1593··N/A2065 MOUNTAIN VIEW DRPhoenixAZ85019—CORE-HMO
PRVPRV-270512026-09-30T08:56:56Z Albert····Garrett1982-08-01NULLUNKNOWN+1 953 302 0547-9517 Desert Sky BlvdEden PrairieMN———
PRVPRV-228402026-09-30T14:04:13Z·Hannah—Riley11-12-1964null•••-••-6794(800) 813-1959NULL2847 SAGE CT Apt 7HoustonTX77074nullN/A
PRVPRV-291502026-06-20T16:34:15ZSTEPHEN—BUTLER2000-08-09N/A—(623) 387-9235stephen.butler16@yahoo.com1461 Pine DrAtlantaGA30354——
PRVPRV-291382026-03-02T16:58:01ZTYLER—WALLACE1992-09-05UHC-31842-98—3919207989··tyler.wallace@proton.me1949 Pine DrOrlando··FL32859—N/A
PRVPRV-230632026-10-05T01:07:55ZCarol—Hart5/28/1945UHC-35612-34•••-••-3948nullCAROL.HART@PROTON.ME7981 Pine DrAustinTexas78789——
PRVPRV-212242026-05-02T09:34:57ZLaura—McDonald·1592-11-18N/AUNKNOWN9449547043··-8089 Pine DriveATLANTAGA30382null-
PRVPRV-270922026-04-29T14:18:45ZRalph—Espinoza09/14/1938UHC-65631-51——RALPH.ESPINOZA@YAHOO.COM··2235 Highland Avenue Apt 26TempeAZ85211—null
PRVPRV-215382026-07-22T12:27:13ZScottA—Oct 9, 1991UHC8579090—7074612-3667 River RoadGilbert··az85216null-
PRVPRV-220652026-09-08T07:13:40ZANNA—BURTON6/22/1951NULLN/A619-228-5891-3373 Valley View DrATLANTAGA30362—null··
PRVPRV-210602026-09-30T06:23:45ZBryanAGuerrero··1988-06-06UHC-91293-76UNKNOWN300-578-0486NULL7948 RIDGE ROADSacramentoCA95888-··NULL
PRVPRV-248552026-03-23T23:33:47ZDeniseE··Hamilton06/25/88—-(701) 401-6989NULL9833 SAGE CTMinneapolisMN55441UNKNOWNN/A
PRVPRV-242932026-05-28T10:57:39ZMason—Ellis-UHC6461874····6457339—5237 INDIAN SCHOOL RDGlendaleAZ85388-5113UNKNOWNSELECT-EPO
PRVPRV-280012026-04-04T03:21:17ZColeman, MaryN—·19950614·-•••-••-618515556313855·mary.coleman@aol.comnull··——N/A—null
PRVPRV-277702026-09-26T10:46:10ZHawkins—Maria06/26/94·UHC-12919-09•••-••-0654(741) 883-8368null7375 Forest Avenue Apt 10ColumbusOH43233--
PRVPRV-262302026-06-05T05:31:56Zthomas··—wang1959-12-08UHC-80935-49··N/A8855269941NULL2879 Hillcrest RoadSan AntonioTX78296-—
PRVPRV-283042026-02-10T21:37:21ZdennisOdeanFeb 6, 1974UHC-07591-25-(365) 386-6925DENNIS.DEAN83@ICLOUD.COM863 FOREST AVENUE··GilbertAZ85273N/A-
PRVPRV-292502026-09-03T07:38:57ZBRANDON·SFLORES2001-04-20-•••-••-8884298-879-5108null9616 Apache BlvdMesaAZ85232····—
PRVPRV-258682026-04-08T06:14:24ZGEORGEEJAMES11/26/1951UNKNOWN-·(395) 820-3155UNKNOWN4063 WILLOW COURT #191ColumbusOH43203——
PRVPRV-217672026-04-27T12:15:45ZOBrien, Julie——Mar 21, 1980NULLN/A17799567668NULL4488 Washington St·CharlotteNC28283N/Anull
PRVPRV-254212026-05-02T14:18:02ZSEAN—GORDON1987-10-04UHC-32543-22N/A(375) 724-9175sean.gordon71@outlook.com6154 Canyon RoadMesaAZ85230UNKNOWNnull
9,596 rows, page 114 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:52.248Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty