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
CLMCLM-4239332026-10-16T01:31:19ZWallace, SaraI—04/20/1992—•••-••-3495(940) 761-4454sara.wallace17@yahoo.com1117 Baseline RoadTempeAZ85202GRP-5227CHOICE-PLUS-PPO
CLMCLM-4127002026-01-22T06:12:09Zsara—wheeler··1989-11-13—•••-••-87396665486492—5897 Baseline RoadLos Angeles···CA90028GRP-1730N/A
CLMCLM-4190452026-05-30T20:42:31ZFATIMAJ.BRYANTAug 14, 1991-UNKNOWN—-9517 Lincoln WaySacramentoCalifornia95858GRP-2838—
CLMCLM-428740 2026-10-06T08:33:05ZKathryn—Wilson19940408UHC-08465-26null——4396 SAGE CTChandlerAZ85243·GRP-0406N/A
CLM CLM-4129612026-01-13T09:04:11ZPayne, Ruth——1977-11-16UHC-75266-66UNKNOWNUNKNOWNN/A6794 Church StreetJacksonvilleFL32290-7870··GRP-4051SELECT-EPO
CLMCLM-4199372026-08-07T00:17:46ZMATEOSDYAZ1952-06-25UHC-92907-25UNKNOWN525.372.1839NULL2968 Apache BlvdHOUSTONTX77085GRP-1621—
CLMCLM-4030012026-06-08T05:04:58ZSarahXWeaver19440809UHC-47275-12N/A—N/A979 CENTRAL AVELas VegasNV89114—SELECT-EPO
CLMCLM-4213102026-01-19T03:42:40ZDOUGLAS—PADILLA1983-05-27UHC-70673-95nullUNKNOWN····6987 PARK PLACEAtlantaGeorgia30312GRP-8061·NULL
CLMCLM-4229172026-04-02T07:55:15ZJUSTIN—HAMILTON1945-09-22UHC4110042•••-••-6357731-612-4405—9352 Church StFresnoCA93763GRP-6188··-
CLMCLM-4142392026-05-17T10:39:08ZJeffrey—Alvarado2000-61-24—null(275) 851-9425-374 PALM DRCharlotteNC28268nullCHOICE-PLUS-PPO
CLMCLM-4147372026-01-14T12:36:37ZyukiGfoster1987-04-23-——UNKNOWN3566 Lake View RdSacramentoca95847GRP-5580null
CLMCLM-4200092026-02-18T05:08:58Z EDWARD····ELLIOTT1979-05-08UHC3318088•••-••-8778—null2976 Park PlaceTEMPEAZ85230GRP-7937CHOICE-PLUS-PPO
CLMCLM-4215432026-04-18T14:52:51ZMegan—Medina1944-10-12UNKNOWN—352-967-5550megan.medina1@hotmail.com··-——UNKNOWNGRP-8434MEDICARE-ADV-A
CLMCLM-4322492026-01-16T16:09:02ZLynch, AlanS—1959-07-02UHC-97250-45•••-••-0860383-922-6600N/A··7020 Elm St #345OrlandoFL32886UNKNOWN—
CLMCLM-4283942026-07-23T16:15:00ZARRTHUR—RIVERA1966-04-15UHC-43347-56N/AN/A—8948 Apache BlvdHOUSTONTX77054GRP-0177UNKNOWN
CLMCLM-4090262026-10-01T05:43:45ZEmilyWMurrayAug 23, 1963UHC-02083-82•••-••-2768901-566-4820NULL-N/ANULLNULL···GRP-8609CHOICE-PLUS-PPO
CLMCLM-4320902026-09-03T15:01:15ZbrittanyIgarrett01/05/70·UHC-07264-35•••-••-5854—N/A3896 Hillcrest RoadLos AngelesCA90031GRP-3222·N/A
CLMCLM-4210762026-09-20T02:01:46ZJun—Wells1963-12-02UHC-62005-75•••-••-4794751-429-9935-943 Lincoln Way·DallasTX75235GRP-1361CHOICE-PLUS-PPO
CLMCLM-4320542026-07-21T20:48:50ZAMYH.GILBERTNov 4, 1973UHC-06665-71-(565) 363-1605—4705 MOUNTAIN VIEW DRIVE Apt 18SAN ANTONIO·TX78229GRP-0508N/A
CLMCLM-4068722026-10-05T19:51:49ZROY—DUNN2005-06-22UHC-64037-81NULL(468) 780-3368—4764 OCEAN AVENUEGlendaleAZ85329NULL—
CLMCLM-4216992026-03-02T19:42:34ZMARIANAGWILSON1947-07-01NULL•••-••-3927—UNKNOWN4779 CANYON ROADDALLASTX·75272——
CLMCLM-4322012026-04-15T08:08:58ZMary····Mason5/25/1942UHC-32557-02•••-••-2805nullNULL3145 MAIN STFresnoCA93784··—UNKNOWN
CLMCLM-4112212026-06-08T16:35:08ZMARTHA—ESTRADA1998-07-19————nullUNKNOWN—N/AUNKNOWNNAVIGATE-HMO
CLMCLM-4265312026-06-08T23:44:00ZRalph—Armstrong1957-02-11UHC-05114-18—8344856892ralph.armstrong@outlook.com7059 Desert Sky Blvd·GlendaleAZ85367GRP-8168—
CLMCLM-4113542026-04-30T03:33:34ZMARY—FIELDS1941-09-09UHC-14826-97N/Anull-N/AN/A——GRP-7064MEDICARE-ADV-B
CLMCLM-4014612026-01-31T04:00:26ZPat—BishopOct 3, 1974UNKNOWNN/ANULLnullnullN/AUNKNOWNN/AN/ACHOICE-PLUS-PPO
CLMCLM-4217052026-08-25T00:28:13ZLuis—Dominguez1998-11-25UHC-35367-03•••-••-4490(902) 685-1946—5547 BASELINE ROAD #215·PlanoTexas75009UNKNOWNCORE-HMO
CLMCLM-4055542026-01-16T03:10:56ZHEATHER—AUTSIN10/11/1990UHC-98318-39·NULL(766) 986-5307NULL6047 Lincoln WayAustinTX·78774NULL··UNKNOWN
CLMCLM-4181572026-05-01T13:45:46ZCunningham, Christopher——19890302····—NULLchristopher.cunningham43@hotmail.com9136 Apache BoulevardSEATTLE··WA98120GRP-8165OPTIONS-PPO
CLMCLM-4223632026-04-06T14:14:19ZMary—Bennett08/27/1992UHC-46137-46•••-••-1454NULLNULL9251 SUNSET BOULEVARDAtlantaGeorgia30354GRP-8297UNKNOWN
CLM CLM-4188332026-02-21T03:16:24ZHENRY—SCOTT07/01/59—··—NULL6046 Baseline Rd #381DenverCO80268nullSELECT-EPO
CLMCLM-4263072026-04-25T17:15:47ZRUTH—COLLINS1938-02-06UHC-81446-80—14306046951—4725 HARBOR BLVDCharlotteNC28279N/A—
CLMCLM-4264482026-01-14T15:27:34ZMASONZJACOBS·19881228——340-772-9815—4277 River Rd #316Los AngelesCA90057GRP-2411select-epo··
CLMCLM-4116582026-05-07T11:30:41Z·Lisa—Sanchez1951-01-20nullN/A318-778-3038N/AUNKNOWNUNKNOWN—-—null
CLMCLM-4216432026-01-11T03:16:41ZBRENDA··—SMITH19400414null•••-••-6599—UNKNOWN4140 Ocean AveSan DiegoCA92153-2967··GRP-3661MEDICARE-ADV-A
CLMCLM-4306752026-03-25T03:57:13ZEdward—AndersonJan 9, 2007UHC-38788-96-328.843.1070——NULL—N/AGRP-5567MEDICARE-ADV-A
CLMCLM-4077322026-01-15T07:09:52ZBeverly—Padilla1954-10-26UHC3580315•••-••-1485(539) 534-8170····6136 Park PlaceMesaArizona85225GRP-1644UNKNOWN
CLMCLM-4044232026-08-06T23:21:15Zeric—austin1995-06-07UHC-94411-49UNKNOWN——7540 Ridge RdEden PrairieMN55368··GRP-7818OPTIONS-PPO
CLMCLM-4300272026-05-02T18:36:59ZLi, CarolynP—07/28/47·-•••-••-2424·-carolyn.li71@outlook.com6525 Highland AveNASHVILLETN37205—MEDICARE-ADV-B
CLMCLM-4050162026-02-23T04:21:51ZALAN—WAGNER19700301UHC-75092-90•••-••-1190—-6466 BroadwayLos AngelesCA·90063GRP-2573··MEDICARE-ADV-A
CLMCLM-4290092026-08-04T06:25:11ZANDREA····POWELL1943-09-24UNKNOWN—nullnull5969 Sage CourtHouston··TXnullNULLNULL··
CLMCLM-4313892026-06-17T08:16:01ZWayne—Howard1957-01-13UHC-15907-37•••-••-9075null—·3649 Ridge Rd Apt 22FresnoCA93718GRP-7107MEDICARE-ADV-A
CLMCLM-4257182026-02-01T21:39:37Z·Teresa····Fisher·Apr 26, 1959UHC-20504-81•••-••-8579N/A·null5150 Main StreetScottsdaleAZ85299GRP-1960CHOICE-PLUS-PPO
CLMCLM-4297512026-03-20T07:49:47ZBETTYM.·BURKE1966-02-08UHC-91816-98null·NULL-——--—NAVIGATE-HMO
CLMCLM-4138722026-04-05T21:35:50Znicholas—bowman1965-06-26UHC-26614-77··•••-••-537719727230482··——-null——options-ppo
CLMCLM-432795 2026-08-21T07:11:25Z·STEPHEN—MURRAY1962-05-26—·null(811) 384-8702STEPHEN.MURRAY@GMAIL.COM4148 MAIN STSeattleWA98101-0536GRP-5620NAVIGATE-HMO
CLMCLM-4082822026-06-08T11:06:51ZBetty—Williamson2006-04-21UHC-78528-57—nullbetty.williamson38@yahoo.com9404 Camelback RoadSeattleWA98111——
CLMCLM-4204912026-07-31T21:18:40ZMargaretFStephens08-06-1953····N/A-N/A1667 PARK PL #124SeattleWA98147GRP-4732NULL
CLMCLM-4049312026-09-18T21:20:00ZCynthia—·Chapman05/02/78UHC-75673-50•••-••-9804·nullnull8451 Willow CourtDallasTX75209-2729NULLUNKNOWN
CLMCLM-4071582026-06-24T17:31:32ZDylan—Stewart1969-11-13null—N/Adylan.stewart@gmail.com1139 Willow CourtMesaAZ85254null-
32,829 rows, page 131 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.504Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty