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-223392026-06-22T22:38:40ZRebeccaFHughes04/18/82UHC-55608-51•••-••-7544(910) 410-6444·rebecca.hughes@yahoo.com6044 Palm DrSan DiegoCA92170-NULL
PRVPRV-248162026-03-03T19:53:09Z LarryZRichardson1968-09-23—•••-••-360519896256904null397 Oak Street··OrlandoFL32811NULLNAVIGATE-HMO
PRVPRV-293452026-09-23T04:10:37ZMichael—Garrett2003-11-10UHC-15377-59—nullmichael.garrett@outlook.com2144 Apache Blvd·ScottsdaleAZ85248—NULL
PRVPRV-282292026-07-16T14:16:35ZKathlenD.Campbell1977-12-12··——(914) 239-4560kathleen.campbell31@proton.me·3195 Elm StMinneapolisMN55409null—
PRVPRV-289112026-08-20T17:02:21ZfrankZbailey12/16/1963UHC-35199-95N/A(397) 911-4661—4978 Pine DrDallasTexas75292UNKNOWNSELECT-EPO
PRVPRV-287122026-04-24T19:01:23ZJEREMY—MOORE19950927UHC-26263-45•••-••-8417(945) 573-1222jeremy.moore56@proton.me--—-nullUNKNOWN
PRVPRV-223622026-04-02T13:53:42ZEdwardXCunningham1941-03-16—UNKNOWN—EDWARD.CUNNINGHAM93@HOTMAIL.COM2332 BROADWAYDallasTX75240·NULL-
PRV PRV-222472026-09-21T06:52:49ZJoeGTurner1997-09-21UHC-65327-39-6117624390joe.turner@icloud.com3679 LINCOLN WAY Apt 34DenverCO80227N/A—
PRVPRV-231752026-10-08T22:51:42ZGabriel—Ferguson1942-03-27—-(341) 281-8924UNKNOWN2571 Spring StMesaAZ85225····null
PRVPRV-225152026-07-27T20:47:31ZKnnethULarson1982-07-22UHC-86392-72N/A(322) 438-6680··—3899 Central AvenueTempeAZ85267NULL—
PRVPRV-223092026-04-16T19:52:00ZSCOTTXLONG2005-01-19—-336-522-7421scott.long@hotmail.com333 PINE DRIVESAN DIEGOCA92132·NULL····
PRVPRV-216742026-03-09T09:40:31ZChristopher····Keelley1959-08-12UHC-48024-33NULLUNKNOWNNULL9760 Highland AveSacramento··CA95867-CHOICE-PLUS-PPO
PRVPRV-281852026-08-08T10:20:28ZPamela—Thompson1997-01-21uhc-25513-16N/A408-212-4357··—5987 FOREST AVENUEDenverCO80250null—
PRVPRV-295902026-02-09T07:31:40ZVirginiaWGuerrero19390702UHC-49764-58—(652) 748-8366—7836 OCEAN AVEMIAMIFLNULL-null
PRVPRV-271202026-05-11T08:28:40Z RussellP.·Hudson1997-12-26UHC-77582-79—18539230202null2756 Washington StSan Antonio··TX78297··N/A—
PRVPRV-201482026-03-15T23:48:38ZArthur—Wright1943-12-18UNKNOWNNULL7375308335—NULL-———N/A
PRVPRV-240572026-05-08T19:10:31ZOlivia—Huunt2002-12-18UHC-49329-86—2317836571N/A1027 Oak StreetMesaAZ85241NULL—
PRV PRV-234072026-01-29T09:28:54Z·ashley—reyesOct 5, 1948—N/A(543) 776-5037—6513 Central AveSCOTTSDALEAZ85236——
PRVPRV-202792026-09-27T23:04:13Z Ethan—Hudson27-04-1939-null——7173 Baseline RdHoustonTX77029—OPTIONS-PPO
PRVPRV-25945 2026-07-18T15:24:45ZDorothy··Weaver26-10-1941—····3279370475—916 Jefferson AvenueSeattleWANULLUNKNOWNN/A
PRV PRV-269172026-08-09T03:57:49ZCarlos—Palmer·1983-09-21UNKNOWN··UNKNOWN460-723-3450-9440 Palm Drive #423TampaFL33651——
PRVPRV-257762026-02-09T21:33:50ZSOFIA—MATTHEWS1948-02-23—-(710) 972-6382—UNKNOWN-NULLN/AN/A-
PRVPRV-292612026-06-08T06:29:10ZGerald—Gordon2005-01-03—-430-309-7705UNKNOWN9126 MAIN STREETMesaAZ85201NULL-
PRVPRV-252522026-06-19T00:47:33ZCheryl—Cunningham1963-02-20nullNULL··——9223 Elm StSeattleWashington98192—SELECT-EPO
PRVPRV-295212026-07-26T10:07:34ZALAN—HARRIS1946-08-05—-(676) 592-5049·ALAN.HARRIS19@ICLOUD.COM1221 UNION STREETMINNEAPOLISMN55422····—
PRVPRV-228882026-05-04T08:17:56ZSCOTTS··HARTApr 2, 1962UHC-39979-07N/A4126057459-··7942 OAK STMiamiFL33100··null-
PRVPRV-273512026-07-31T10:47:19Z BRITTANY—ALVARADOSep 17, 1991UHC-89357-17N/A(597) 582-6766null7794 BASELINE ROADPhoenixAZ85044N/Anull
PRVPRV-226402026-05-18T10:31:33ZJenniferKOliver1972-09-17UHC-58266-53NULL+1 712 209 1092—8588 UNION ST··OrlandoFL32874-—
PRVPRV-256172026-02-22T00:42:25ZKAREN—PHILLIPS1976-08-27—null17004942434··UNKNOWN6656 Washington StTempeAZ85282N/A-
PRVPRV-214632026-04-20T19:31:00ZDIANAO.HARRISON··06-08-1966NULLUNKNOWN4013185529·diana.harrison99@hotmail.com7744 Central AvenueGILBERTAZ85264-7803—····
PRVPRV-225082026-02-17T16:22:40ZPriya—Ray1985-09-26UHC-69452-31•••-••-775715644196221N/A727 CANYON RDDenverCO80252··-·-
PRVPRV-221022026-06-18T15:31:19ZOlson, Camila G——Jan 7, 1949nullNULL15246510806-3970 Sage CtATLANTAGeorgia30342NULL—
PRVPRV-217502026-06-23T15:07:01ZSHIRLEY····HALnull··•••-••-6777—shirley.hall@yahoo.com·8151 Jefferson AvenueSacramentoCA··95837NULLOPTIONS-PPO
PRVPRV-275332026-01-05T22:10:23ZTIMOTHY—HICKS1942-12-19UHC-95337-33-528-647-9517N/A4810 CHURCH STScottsdale·AZ85295——
PRVPRV-215532026-02-01T07:10:39ZRoy—Jordan·2002-06-11——13167770903null3977 Main StreetMiamiFL33122UNKNOWNnull
PRVPRV-259182026-03-02T10:54:04ZHENRYZ.·MUNOZ2000-08-25UHC7764808··—495-308-8610henry.munoz38@proton.me9181 Oak StTempeAZ85216—NULL
PRVPRV-202592026-04-15T04:53:02ZalexisYcarlson1947-08-07UHC-56124-47•••-••-9230—N/ANULL—-———
PRV PRV-235412026-06-21T21:14:22ZJensen, Jerry—··1955-08-28·UHC-63050-35—9586582UNKNOWN4916 Sunset BoulevardNASHVILLETennessee37255NULLCORE-HMO
PRVPRV-265162026-03-02T04:20:50Z Garcia, BrittanyP—1976-07-09UHC-27108-61UNKNOWN8594870886brittany.garcia@proton.me9096 Meadow LanePhoenixAZ85007NULL—
PRVPRV-210632026-01-22T06:30:18Zcheryl··—colilns1973-08-10--(904) 964-3456N/ANULL····null-null··MEDICARE-ADV-B
PRVPRV-249022026-08-25T10:40:35ZFRANCES—BLACK1973-01-08NULL•••-••-3697765.364.3713UNKNOWNN/ANULLUNKNOWN-N/AMEDICARE-ADV-B
PRVPRV-253872026-10-02T02:39:25ZRahel—Maldonado1992-09-16-null932-610-9587rachel.maldonado33@yahoo.com7516 Meadow LnScottsdaleAZ85254UNKNOWNOPTIONS-PPO
PRVPRV-270282026-02-14T23:43:46ZAissha—Brooks1951-06-13—NULL··256-324-7034UNKNOWN3747 Canyon Rd #880·Jacksonvillefl32260····CHOICE-PLUS-PPO
PRVPRV-278562026-01-10T22:16:16ZJORDAN—·WEAVER1947-11-19UHC-41990-34·N/A5623143035····4916 SUNSET BOULEVARDPhoenixAZ85065—null
PRVPRV-258432026-07-19T20:52:39ZDorothy—Lawrence11-04-1966NULLN/A··(444) 211-5814UNKNOWN1167 Canyon RoadLos AngelesCA90087——
PRVPRV-203182026-09-10T14:29:28ZBobby—Garcia1940-10-09UHC7571745—3767933181—3222 Valley View Drive Apt 33Minneapolis·MN55428N/A—
PRVPRV-280232026-08-24T06:39:24ZDANIEL—NUNEZ1/9/1954nullUNKNOWN(217) 621-7578—null——··-—
PRVPRV-276972026-10-13T23:37:40ZMATEO—SIMS1959-11-11-N/A-UNKNOWN7841 BAYSHORE DRPhoenix·Arizona85007··MEDICARE-ADV-A
PRVPRV-256312026-10-07T02:10:36ZKathyCSalazar1961-02-05UHC-01997-43UNKNOWN+1 452 995 4335NULL9016 Ocean AvenueFresnoCA93733N/A—
PRVPRV-274332026-09-18T15:14:11ZOmar····Mendez1980-09-18N/A—8877150749omar.mendez96@icloud.com6109 BroadwayPhoenixAZ85004NULL-
9,596 rows, page 155 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:00.184Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty