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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPA TPA-528442026-10-05T19:22:32Zlara—ryan1993-01-22N/AUNKNOWN—NULLN/A---—-
CLM CLM-4062292026-09-16T01:35:57Z·Billy—Contreras·1984-05-25NULL——N/A1811 Valley View Drive··MIAMI·FLNULLGRP-8820null
CLMCLM-4240902026-03-22T05:41:50ZJACKLFRANKLIN··1968-02-01UHC-20855-62··—12224380255NULL··3069 MOUNTAIN VIEW DRIVE Apt 9Tampafl33640UNKNOWNCORE-HMO
CLMCLM-4207452026-09-10T17:13:47ZSUSAN—VAZQUEZ2000-59-06UHC-65517-83UNKNOWN-——N/AUNKNOWNUNKNOWN—CHOICE-PLUS-PPO
TPATPA-530352026-06-09T06:51:58ZSamuel—Williamson2003-01-11NULLNULLUNKNOWN-8488 VALLEY VIEW DRIVEAustinTX78798GRP-8474N/A
TPATPA-510702026-04-05T08:38:57ZDouglas—Morgan1974-01-02-•••-••-4086+1 778 390 0003-4328 Grand Ave··ChandlerArizona85207GRP-1978-
CLMCLM-4199262026-10-18T18:23:17ZArmstrong, Olivia——1995-09-11UHC-25797-48•••-••-6239———NULL····NULLN/AN/A
CLM CLM-4066382026-08-21T21:14:17ZAMY—DANIELS2007-04-08UHC-31366-36N/A756-802-2992-1993 MAIN ST·SAN ANTONIO·TXNULLGRP-2637—
ENRENR-1198702026-09-08T20:23:43ZMadisonNMartinez19960313UHC-94395-72•••-••-06645257693563madison.martinez@gmail.com1768 Meadow LaneMINNEAPOLISMN55444GRP-5269MEDICARE-ADV-A
ENRENR-1000982026-01-06T04:11:54ZWarren, ValentinaD—·1959-11-17UHC6424081•••-••-6931(737) 536-6901N/A9049 Maple Avenue··DALLASTX··75225GRP-1647MEDICARE-ADV-B
ENRENR-103748 2026-04-03T14:05:00ZPeter—Brooks·Sep 18, 1965UHC-56867-96•••-••-514412474697906··UNKNOWN2138 Union St Apt 6SeattleWA—GRP-5083MEDICARE-ADV-B
CLMCLM-4132952026-09-25T06:01:30ZandrewH.montgomery19440727UHC-31571-55•••-••-6986·UNKNOWN—4498 SUNSET BOULEVARDColumbusOH43296-OPTIONS-PPO
CLMCLM-4260162026-04-16T05:31:41ZLarson, Albert——·19390303UHC-99616-93UNKNOWNUNKNOWNNULL197 Park PlaceGlendaleArizona85399—null
ENRENR-1392592026-07-14T20:05:15ZFrances—Hansen1958-11-10··UHC-28727-85null··(744) 286-4153UNKNOWN8848 Lincoln WaySan DiegoCA92179GRP-5413CHOICE-PLUS-PPO
ENRENR-1417832026-04-19T17:37:44ZMaryA··Lawrence1974-11-24UHC-37820-56•••-••-3596UNKNOWNMARY.LAWRENCE75@PROTON.ME895 Indian School RdHoustonTX77051-5030GRP-9188SELECT-EPO
TPATPA-537132026-08-12T03:41:08ZRoy—Mendez1937-06-03N/A—(773) 220-6513-N/Anull··-nullGRP-4999·null
TPATPA-637272026-01-31T22:25:47ZYukiS.Rios·09/05/1995—nullUNKNOWN—·16 Lake View RdTampaFL33645NULL—
ENRENR-1375222026-03-02T19:11:43ZDENNISG.OBRIEN1948-01-16·UHC-12014-13•••-••-6977910.507.4548dennis.obrien@icloud.com3718 Valley View DriveTucsonAZ85707GRP-3127MEDICARE-ADV-A
ENR ENR-1307132026-02-22T10:51:23Z·Joe—·Rose05-05-1960UHC-43042-02•••-••-9318420-519-5338joe.rose@icloud.com1086 Elm StAtlantaGA30395GRP-5606MEDICARE-ADV-B
TPATPA-520392026-07-27T21:28:42ZLe, Lori——1962-06-12UNKNOWN—nullUNKNOWN7963 Jefferson AvenueMINNEAPOLISMN55485··GRP-8823SELECT-EPO
TPA TPA-507822026-07-25T22:30:00ZhiroshiBcoleman06-04-1985null·UNKNOWN-null3352 CENTRAL AVENUESan AntonioTXNULL··N/AUNKNOWN
ENRENR-1061342026-01-20T15:36:44ZDEB—HUDSON·01-07-1938UHC-17166-07•••-••-7199(463) 611-2740·DEBORAH.HUDSON@GMAIL.COM8863 Main StreetTempeAZ85227GRP-0426CHOICE-PLUS-PPO
ENRENR-112550 2026-06-30T00:20:35ZRussellFCarlson1973-60-28··UHC-77117-13•••-••-41009526754342russell.carlson67@hotmail.com1243 Main StMiamiFL33176GRP-6621MEDICARE-ADV-B
TPATPA-631532026-09-26T09:15:45Z JULIA—·CHAPMAN26-09-2008nullnull-———-NULL··GRP-8892null
PRVPRV-213872026-03-20T10:07:12ZWilliam—Fox·1961-11-11UHC-95380-97—(375) 348-9670UNKNOWN2561 SPRING STCharlotteNC28243-NULL
PRVPRV-27063 2026-07-03T20:12:29ZJason—Burns1975-12-26UHC-85963-06N/A7353537719jason.burns@gmail.com5434 CAMELBACK ROADEden PrairieMN—-UNKNOWN
ENRENR-1364242026-07-28T03:59:09ZRONALDISTEPHENS1959-08-10UHC-60140-60•••-••-08562215353721NULL617 SUNSET BOULEVARD··MesaAZ85257GRP-5238NAVIGATE-HMO
CLMCLM-4277402026-06-10T21:59:28ZGrant, Gloria——8/13/1952·UHC-18393-21•••-••-71986624198244GLORIA.GRANT98@ICLOUD.COM6583 Ridge Rd #273Las VegasNV89187-—
CLMCLM-4066482026-03-06T11:01:01ZMason—Aguilar1941-07-11UHC-36480-04N/A7956968359mason.aguilar13@outlook.com811 RIVER RDGlendaleaz85390GRP-7959MEDICARE-ADV-A
CLMCLM-4029282026-09-21T11:28:20ZLINDA—HENRY1982-07-14UHC-84983-22•••-••-9682(411) 268-7226—7924 Church StreetTampaFL33607—OPTIONS-PPO
TPATPA-580552026-06-11T18:48:28ZSharonKMendoza11/23/1971N/A-—sharon.mendoza@outlook.com8627 Willow CtJacksonvilleFL32294NULLOPTIONS-PPO
ENRENR-1222222026-07-22T17:50:11ZCharlieL.Webb1990-08-11UHC-53654-01•••-••-2251444-407-9877—2023 Desert Sky Blvd Apt 3Las VegasNV89154GRP-6569CHOICE-PLUS-PPO
CLMCLM-418388 2026-03-09T03:40:35ZMary—Fuller1963-10-05UHC-43878-46····738-679-9935-6246 Church StreetSACRAMENTOCA95834N/A—
TPATPA-546792026-03-12T01:32:14ZCAROLYN—KING13-07-1957—·N/A—UNKNOWN2064 PARK PLSan Antonio··TX78271UNKNOWNN/A
PRVPRV-287922026-02-27T09:28:55ZVIRGINIAASANTIAGO19920313UHC-36147-93•••-••-5255+1 223 402 2365virginia.santiago@hotmail.com4239 SPRING STREETScottsdaleAZ85275—UNKNOWN
TPATPA-561252026-01-10T19:39:20ZNatalie—Park04/25/04——UNKNOWN—3479 Ocean AvenueGilbertArizona85240-0372nullUNKNOWN
CLMCLM-4049772026-07-01T01:37:42ZJack—Marshall1963-06-13UHC-15423-91NULL(430) 269-6871—··—NULL··GRP-8836—
CLMCLM-4284312026-09-24T22:45:47ZDOUGLAS—KNIGHT1967-12-22UHC-58513-50•••-••-3637—UNKNOWN427 Central AvenueCHANDLERAZN/AGRP-7855null
CLMCLM-4312662026-01-08T04:26:01ZPRIYA··FERNANDEZ2007-10-11-null9449883064—595 Elm StAtlanta·Georgia30305GRP-2450MEDICARE-ADV-B··
ENRENR-119491 2026-09-25T01:14:05ZBeverly·SRobinson1960-09-17UHC-62680-99•••-••-6898583.372.4030beverly.robinson@icloud.com5505 BASELINE RDSan AntonioTXNULLGRP-7004NAVIGATE-HMO
ENRENR-1335112026-04-04T23:35:18ZDEBRA—MASON1984-03-24UHC-18910-69•••-••-8478279-722-4165DEBRA.MASON41@HOTMAIL.COM8297 Spring StreetJacksonvilleFL32265GRP-9296NAVIGATE-HMO
ENRENR-1244372026-09-26T17:29:13Z·Watson, RuthV—1963-01-03··UHC1300042•••-••-6274·(446) 897-4507—2307 Sunset Boulevard··JacksonvilleFL32283GRP-3519MEDICARE-ADV-A
CLM CLM-4313862026-07-31T20:56:02ZKimberly—Mills07-12-1955UHC-05503-20·UNKNOWN(801) 623-4112UNKNOWN9137 Main StreetGilbertAZ85208UNKNOWN·OPTIONS-PPO
ENRENR-1105072026-01-13T09:43:22ZRachel—Rose1929-07-19UHC-27499-03N/A··+1 613 518 7642rachel.rose76@proton.me5491 Baseline RdMiamiFL33115GRP-5482SELECT-EPO
ENRENR-1175452026-03-04T04:00:29ZRUTH—SANDERSOct 18, 1976UHC-33824-96•••-••-9167(810) 585-2778·ruth.sanders67@gmail.com8937 OCEAN AVENUE·MesaArizona85255GRP-9734MEDICARE-ADV-B
CLMCLM-4051222026-02-10T06:06:14Zsteven—·knight2004-04-20UHC-60419-18•••-••-8170-······8607 Ocean Ave··MiamiFL33105GRP-7911—
ENR ENR-1113742026-07-05T00:27:28Zjames····nguyen1966-02-04UHC-49719-49•••-••-9812+1 771 857 4072··james.nguyen@yahoo.com9889 HILLCREST RD Apt 16COLUMBUSOH43254GRP-7936MEDICARE-ADV-B
PRVPRV-213562026-06-17T15:46:05ZAmy—·FullerAug 24, 1982—NULL749-276-0762—6125 PINE DRIVETucsonAZ85746nullCORE-HMO
CLMCLM-4311102026-10-02T15:44:21ZLAURAUCRUZNov 24, 1974—•••-••-0424NULLNULL5143 BROADWAYSacramentoCA·95882·GRP-4092-
ENRENR-1087012026-07-26T19:05:59ZJoyce P—Perry09/08/72UHC-51288-35•••-••-8261UNKNOWNjoyce.perry@proton.me—NULL-nullGRP-8864SELECT-EPO
100,000 rows, page 166 of 2,000PreviousNext

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:36.707Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty