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

Claims only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLM CLM-4211232026-09-03T22:09:19Zmaria—tran0301-19-62UHC-91217-99UNKNOWN7703936409-··6940 Forest Ave·SacramentoCA·95826—MEDICARE-ADV-A··
CLMCLM-4002082026-05-17T10:16:37ZMaria—Martin1991-05-20UHC3674415•••-••-4796853-685-4230··—5568 INDIAN SCHOOL ROADPhoenix·azN/AGRP-7835MEDICARE-ADV-A··
CLMCLM-4226192026-07-03T14:43:28Zdanielle—·lee10/25/1975—•••-••-4997874.533.1126—7026 Jefferson AveATLANTAGA30306-7620UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4315082026-06-28T15:22:42ZLuis—Sanders1927-12-14UHC-37937-73•••-••-0299-—7051 Canyon RdGlendaleAZ85301-9401GRP-2348·-
CLMCLM-4154282026-04-07T21:21:13ZCYNTHIA—·ALVAREZ·1953-07-13—-803-226-1633-NULL·NULL——GRP-0326MEDICARE-ADV-B
CLMCLM-4310732026-08-10T06:12:38Zbrenda—carpenter1993-02-15UHC-00720-73nullnull—7814 Willow CtColumbusOH43217GRP-4387—
CLMCLM-4192622026-03-23T06:37:03Z Grace··—Grant1953-04-22UHC-16119-17—·263.663.0863UNKNOWN8371 Baseline RdFresnoCA93773NULL—
CLMCLM-4131082026-10-12T17:57:23ZKennethS.Perkins24-07-2003UHC-16787-95NULL(304) 637-0785NULL4677 Valley View DriveScottsdaleAZ85266GRP-2685N/A
CLMCLM-4243792026-08-20T22:45:58ZNICOLEGBRYANT3/24/1973—·UNKNOWN-—····nullUNKNOWN—GRP-1045MEDICARE-ADV-A
CLMCLM-4217092026-02-04T10:37:02ZTHOMAS—RODRIGUEZ09/10/48UHC-16493-55•••-••-89008356459710—6430 MAPLE AVEMinneapolisMN55497GRP-6907···-
CLMCLM-4054812026-04-01T10:16:56ZMegan—Reynolds··1954-09-13UHC-83388-10-··——9684 Highland Avenue Apt 14DALLASTX75253—NULL
CLMCLM-4298572026-10-14T10:58:53ZCampbell, Noah——1961-12-01UHC2527268—+1 303 386 3621N/A7910 HARBOR BLVDOrlandoFL32880——
CLM CLM-4062532026-07-07T09:22:00Z———2007-12-16UHC-88685-49•••-••-4971512-526-9792—4941 Highland AveCOLUMBUSOH43231-—
CLMCLM-4049012026-01-10T11:20:35ZCox, Geralld——1971-10-05UHC-87483-13UNKNOWN(733) 492-3654gerald.cox4@yahoo.com————-NULL
CLMCLM-410707 2026-01-04T10:29:42ZDlan—Espinoza06/26/55UHC-01683-02··•••-••-7240—DYLAN.ESPINOZA41@AOL.COM——UNKNOWN-GRP-9254SELECT-EPO
CLMCLM-4260752026-03-25T20:22:40ZDORUTHY—PETERSON1947-10-04··•••-••-1649—NULL1631 Camelback RoadPhoenixAZ85062GRP-4015null
CLMCLM-4101322026-07-10T09:38:36ZnicoleZporter1973-01-24NULLnull3604564633—8253 RIVER RD·SeattleWA98181GRP-6171SELECT-EPO
CLMCLM-4126382026-01-30T15:15:18ZEvelyn—Jacobs19500904UHC-71656-05•••-••-6400N/A—N/A—N/ANULL-—
CLM CLM-4037662026-04-15T07:50:13ZKelly······Munoz1944-09-17UHC-78676-71•••-••-8343-—8886 Central AvenuePLANOTX75066-MEDICARE-ADV-A
CLMCLM-4185792026-03-11T15:16:52ZSAMUEL—SANTIAGO1960-07-21·UHC-56570-42•••-••-5526·--NULL-—-N/AN/A
CLMCLM-4272312026-03-23T02:41:34ZValentina····Hunter2002-01-18UHC-84540-84•••-••-9859—UNKNOWN8014 CAMELBACK RDGILBERTAZ85213GRP-4119CORE-HMO
CLMCLM-4149842026-01-07T13:39:31ZJUDITH—ROMERO1965-12-01—-6459399856··-1753 River RdAUSTINTX78784GRP-7727MEDICARE-ADV-B
CLM CLM-4225032026-05-09T13:12:01Z·vincent—gilbert1982-09-08UHC-83259-66—N/A—UNKNOWNnullnull-GRP-9350SELECT-EPO
CLM CLM-4312542026-10-15T16:10:57ZJulie—Martinez1955-04-23UHC-50684-90N/A(882) 471-1056-··19 MAPLE AVENUETampaFL··33635GRP-9382—
CLMCLM-4066282026-02-02T05:26:01ZANTHONY—COLLINS1966-02-19UHC5986058-—null·1720 PINE DRIVECHARLOTTENC28251·GRP-9639·null
CLMCLM-4074492026-04-08T16:42:48ZJORDAN—PARKER05/25/83————NULL—UNKNOWN··—GRP-3725NAVIGATE-HMO
CLMCLM-4137992026-06-01T04:50:10ZANGELA—MITCHELL1938-07-05UHC-96967-57•••-••-2109(265) 544-0593·UNKNOWN2801 JEFFERSON AVENUETUCSONaz·85771GRP-4913MEDICARE-ADV-A
CLMCLM-4085002026-10-12T14:50:00ZJoe—Matthews1945-05-09UHC-80322-37•••-••-2066+1 989 789 9766joe.matthews@gmail.com1238 Willow CtLas VegasNV89183UNKNOWN··CHOICE-PLUS-PPO
CLMCLM-4189972026-10-10T21:55:13ZMaria—Schmidt··1985-08-21UHC-33033-18NULL803-677-8112N/A4552 Canyon RoadDallasTX75272nullMEDICARE-ADV-A
CLMCLM-400480 2026-07-02T01:44:02ZOrtega, Hiroshi——1979-11-11UHC-36461-06•••-••-0754NULLNULL188 Elm StAUSTINTexas78799GRP-1116-
CLMCLM-4093362026-07-07T07:40:09ZSCTOT—JACOBS1954-07-22N/A——-9154 Cedar LnSEATTLEWA98102GRP-1987NULL··
CLMCLM-4293862026-01-31T19:55:59ZMADISONB.GRAHAM19480225UHC-92091-04•••-••-5512+1 653 489 7342-1690 Forest AveGlendaleAZ85369-6752GRP-2699CORE-HMO
CLMCLM-4284042026-04-01T08:24:47ZJulie··Evans1989-03-18UNKNOWN•••-••-2086·314-758-8213NULL8423 MAIN STPlanoTX75054-8909GRP-2111N/A
CLMCLM-4303832026-01-11T00:03:22Zkaren—mitchell1949-09-02····•••-••-6393N/A—5453 SPRING STLos AngelesCA90075GRP-9293N/A··
CLMCLM-4023782026-10-01T02:41:29ZJulia—Bailey06-05-1954UHC-66212-73UNKNOWN+1 240 929 4354—9691 Church St·CharlotteNorth Carolina28251—NAVIGATE-HMO
CLMCLM-4258542026-03-19T06:24:44ZJose—Barnes1956-09-18-null2502099380··—-N/A-GRP-9595MEDICARE-ADV-B
CLMCLM-4110092026-01-23T20:05:40ZRichards, Teresa——08/22/1985UHC-83111-34NULL12689870712—808 Canyon RoadTampaFlorida33661-OPTIONS-PPO
CLMCLM-4310812026-05-09T20:47:47ZMei—Vega20080122UHC-96916-94-466-963-2303UNKNOWN641 Highland AveGilbertAZ85208GRP-7611MEDICARE-ADV-A
CLMCLM-4103742026-03-23T16:22:03ZRONALDBESPINOZA19380426UHC-18202-18•••-••-6991(564) 384-0310NULL4348 River RdNashvilleTN··37289··-MEDICARE-ADV-A
CLMCLM-4226902026-06-14T15:47:20ZRICHARDO··SANTIAGO1986-05-09UHC-26774-18NULL(660) 745-1570··9782 Bayshore DriveAustinTX78722GRP-3077—
CLMCLM-413855 2026-04-24T06:18:00ZCruz—Sandra07/06/39null•••-••-05352958452158—·649 Elm StreetSAN DIEGOCA92101GRP-2161NULL
CLMCLM-4133392026-06-29T07:22:28ZKeith—Smith5/6/1997UHC-42383-68-——8139 Washington StJACKSONVILLEFL32275-5161N/ANAVIGATE-HMO
CLMCLM-4128292026-05-06T06:57:24ZMEGAN··—·PORTER10-01-1975UHC4610145N/A-null3600 Harbor Boulevard·San AntonioTX78210··—N/A
CLMCLM-4283182026-08-01T21:34:02ZAlice—Collins05/23/1986—NULL4313914173-null—nullNULLNULLMEDICARE-ADV-B
CLMCLM-4199802026-04-10T22:18:16Zjeremy—robertsDec 2, 1994UHC-19875-43•••-••-6376·-jeremy.roberts@icloud.com9863 Sage CourtColumbusoh43260-1377——
CLMCLM-4131812026-09-01T12:55:43ZMcDonald, Vincnet——6/9/1971—-9578139017N/A6869 WASHINGTON STREETTucsonAZ85755UNKNOWNMEDICARE-ADV-B
CLMCLM-4224542026-05-29T09:31:53ZBRITTANY—VASQUEZ1953-09-23NULL•••-••-7468560.241.8709null8014 Baseline Road··TampaFL33684GRP-4706··N/A
CLMCLM-4032122026-07-04T01:27:03ZRussell··—Tucker19530314UHC-79982-50•••-••-2962-—7821 Central AveSCOTTSDALEAZ··85262—··
CLMCLM-4175342026-02-17T11:09:10ZJose—Ryn1948-06-08———jose.ryan@yahoo.com5976 MARKET ST··GILBERTAZ85281GRP-4858CHOICE-PLUS-PPO
CLMCLM-4016302026-08-27T09:47:22Z·Kathleen—Haarrison2001-07-15N/A•••-••-0819636-308-4368null·9163 Mountain View DrCHARLOTTENC··28233GRP-3977SELECT-EPO
32,829 rows, page 121 of 657PreviousNext

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