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-4032962026-02-15T15:49:28Zbilly—robinson1984-10-12null•••-••-9859NULLN/A8106 Main StreetTucsonAZ85787GRP-5474UNKNOWN
CLMCLM-4193092026-09-14T12:04:54ZREBECCA—MUNOZ2001-02-01—•••-••-1492766.283.8843N/A7527 MAPLE AVENUE Apt 20SCOTTSDALEAZ85219nullUNKNOWN
CLMCLM-4069252026-05-20T19:34:51ZJOEZMURRAY1968-09-19UHC-76185-69•••-••-65626389378683····7800 Ridge RdSan DiegoCA92104GRP-4701CORE-HMO
CLMCLM-4200192026-07-22T03:10:45ZJUAN—GORDON08/06/1979null•••-••-5471N/A-7373 WASHINGTON STAtlanta·GA30391GRP-9022UNKNOWN
CLMCLM-4124482026-10-10T06:51:40ZKevin—Lewis··06/28/72N/Anull273-614-7265UNKNOWN8730 Sage CtSan Diego··CA92157GRP-6646CHOICE-PLUS-PPO
CLMCLM-4044832026-04-16T23:32:02Z·HenryIAnderson··11/06/1953uhc-79339-20-559-283-1672··--nullUNKNOWNN/AGRP-4645·NULL
CLMCLM-4011102026-08-02T08:59:26ZTimothy—Harnandez07/06/1991—NULL——3939 Pine DrDALLASTX75204GRP-9769··
CLMCLM-4255482026-08-15T07:41:21ZAisha—Maldonado1965-04-08UHC-43714-18•••-••-2771(240) 630-8438NULL6060 SAGE CTORLANDOFL32867GRP-3041MEDICARE-ADV-B
CLMCLM-4238722026-07-03T10:53:29ZLauren··—Johnston··1983-11-27—-+1 678 346 3128—NULLN/ANULL——NULL
CLMCLM-4100502026-08-24T23:44:36ZGerald—Meyer27-09-1943UHC-45403-71NULLUNKNOWNNULL—UNKNOWN-—GRP-8790—
CLMCLM-4046922026-06-11T20:18:37ZMiller, Margaret——12-01-1941·UHC-71305-12•••-••-2166-UNKNOWN8565 Church StGilbertAZ85262GRP-6544UNKNOWN
CLMCLM-4003012026-01-02T21:50:40ZLAUREN S.—DAVIS1997-11-20UNKNOWN•••-••-0544+1 534 302 8354N/A4206 BASELINE RDSCOTTSDALEAZ85264—NULL
CLMCLM-4145372026-08-22T18:44:32ZTran, Joyce——4/24/1939NULL—NULLJOYCE.TRAN44@GMAIL.COM·NULL——NULL-OPTIONS-PPO··
CLMCLM-4297782026-08-03T21:06:52ZKATHRYN—MENDEZ19680622UHC-53197-07UNKNOWN+1 743 348 4944-——--—null
CLMCLM-4062692026-06-06T17:25:30ZNANCY—HOFFMAN1945-06-23N/ANULL2851377··—1994 Maple AveDallasTX75217GRP-7411—
CLM CLM-4235782026-04-19T22:01:35ZArthur—Garrett1991-02-17UHC-98433-73•••-••-7671NULLnull4997 Camelback RoadMIAMIFlorida33122—NAVIGATE-HMO
CLMCLM-4017032026-07-06T04:02:57ZJOHN··ESTRADA1991-01-14NULL•••-••-6457null—7030 BASELINE ROADSan AntonioTX78290GRP-6989—
CLMCLM-4251222026-10-06T01:25:48ZSamantha—Lawrence04/12/40UHC-39266-73-··—samantha.lawrence11@yahoo.com7120 Washington StreetTucsonAZUNKNOWNGRP-0112UNKNOWN
CLMCLM-401571 2026-04-22T07:54:37ZDAVID—GRAHAMSep 12, 2003UHC-28829-66null·9077284379N/A2470 Lincoln Way #239PlanoTX75031GRP-8526—
CLMCLM-4216892026-01-20T04:10:26ZCarroll, JerryP—2007-12-04UHC-29926-01•••-••-3151(889) 981-0753-8806 Lincoln Way··JacksonvilleFL32287N/ANULL
CLMCLM-4287012026-09-04T21:25:10ZSusan—Hamilton19831209·UHC-49973-47•••-••-2250UNKNOWN—4288 Church StreetSacramentoCANULLNULLCHOICE-PLUS-PPO
CLMCLM-4025672026-01-30T07:18:42ZSantos, Logan—··1972-02-24UHC-71830-89-N/A-UNKNOWN—UNKNOWN—-CORE-HMO··
CLMCLM-4296532026-08-18T13:31:33ZDYLAN—GOMEZ8/12/1963UHC-44561-38··•••-••-3883UNKNOWNNULL5409 Union StreetLos AngelesCA90029NULL··CORE-HMO
CLM CLM-418171 2026-06-19T11:26:30ZAdams, Ahmed——12/06/01UHC-61442-82•••-••-6684+1 642 226 2115NULL3121 Union StreetLas VegasNV89139UNKNOWN—
CLMCLM-4120302026-01-22T00:59:28ZKeithZLopez··Dec 7, 1954UHC8581938•••-••-6501(492) 607-7912-5191 Spring StFresnoCalifornia93714GRP-1382navigate-hmo
CLMCLM-4250552026-10-02T19:37:01Zpatricia—martin1947-04-24UHC-85046-13•••-••-3386—UNKNOWN1060 Desert Sky Boulevard #860San AntonioTX78264-—
CLM CLM-405879 2026-05-29T08:43:48Z·Ethan—Sullivan19980816UHC-35905-45•••-••-2490—ethan.sullivan55@aol.com2307 Market StNASHVILLETN37224GRP-8001··-
CLMCLM-4315562026-03-19T14:18:26ZYuki—Simpson1964-09-27··UHC-06184-67•••-••-3737254.236.6654N/A3800 Ridge RoadCharlotteNC28212N/ASELECT-EPO
CLMCLM-4309782026-07-27T20:33:57Zstephanie—berryOct 4, 1985UHC-59549-90•••-••-877013814564568—N/Anull-—·GRP-5007··
CLMCLM-4066682026-06-17T10:57:41Z JeanI.Brrown1938-02-24UHC-02515-86•••-••-1657NULL-9596 Lake View RoadGlendaleAZ85354GRP-9635—
CLMCLM-4038532026-08-30T18:20:31Z·MargaretM.Torres22-06-1995··UHC-34210-05•••-••-9787855-449-7827—1549 Ridge Rd·JacksonvilleFL32292-2613GRP-7073—
CLMCLM-4087922026-02-03T17:52:47ZMoreno, Angela——1953-07-10—•••-••-6906nullNULL5173 BroadwayAtlantaga30357-2985UNKNOWN—
CLMCLM-4026422026-08-08T16:03:44ZADAM—DELGADO1403-19-58UHC-54823-07——UNKNOWN7282 MAPLE AVENUETampaFL33672GRP-6161null
CLMCLM-4109082026-02-22T20:03:33ZJoan—LeeAug 21, 1951N/A··UNKNOWN··joan.lee@aol.com··5901 River Road··PlanoTX75013—MEDICARE-ADV-A
CLMCLM-4040692026-03-16T17:56:23ZHnut, Abigail——11/28/1979UHC-64284-36—····N/A8501 Park PlaceHoustonTX77002GRP-3245CORE-HMO
CLMCLM-4193632026-03-15T16:48:17ZSofiaY.WallaceJul 10, 1989UHC-07269-10nullUNKNOWN·NULL1093 Ocean AvenueOrlando···FL32845GRP-8516MEDICARE-ADV-A
CLMCLM-4125692026-01-29T15:35:12ZGregoryXPerez1972-05-25UHC-27476-32--····7630 BroadwayTUCSONAZ··85735nullCORE-HMO
CLMCLM-4079602026-09-09T17:48:31ZKAYLA—HAMILTON10/04/57UHC-77535-79null-N/A4222 Lincoln WayGlendaleAZ85362·GRP-3337CHOICE-PLUS-PPO
CLMCLM-4068972026-07-03T00:19:45ZKelly—Laura2/22/1957—N/Anull·NULL9767 BroadwayMinneapolisMN55477GRP-8357OPTIONS-PPO
CLMCLM-4029912026-02-27T11:22:51ZWood, Jennifer——19950305UHC-28217-72UNKNOWN340-956-0955-84 Union StreetSan AntonioTexas78269GRP-0183SELECT-EPO
CLMCLM-4241132026-08-09T05:21:29ZThomas—Lee1944-08-16UHC-50821-71—+1 596 211 1858UNKNOWN1963 SUNSET BOULEVARDAUSTINTX78757··——
CLMCLM-4040512026-05-27T19:37:43ZNicholas····Cox1943-10-01—•••-••-4977nullN/A3321 Spring StreetSACRAMENTOCA95883nullNAVIGATE-HMO
CLMCLM-4145842026-07-19T05:32:36ZNICOLE—LONG1966-04-13UHC-11303-28NULL667-233-6262-200 Grand AveChandlerAZ85203null—
CLMCLM-4123142026-06-02T09:36:17Zpriya—warren19871126UHC-51416-35•••-••-5858nullUNKNOWNNULL··NULLnull··——navigate-hmo
CLMCLM-4085652026-09-26T19:48:44ZJanet—Carroll1980-01-11UHC-53874-23nullN/A-4277 Elm Street··TucsonAZ—GRP-7086—
CLMCLM-4204742026-01-18T16:47:33ZFord, Terry——1994-10-01UHC-24331-17N/A-··—UNKNOWN-UNKNOWN-GRP-4083OPTIONS-PPO
CLMCLM-4026322026-09-16T09:13:09ZKAYLA—HART1966-12-18UHC-59228-60—····NULL61 Washington StTEMPE·AZ85220·GRP-0395UNKNOWN
CLMCLM-4123302026-01-20T11:22:09ZAdams, AmberS··—19730914UHC-14192-29null15052656345UNKNOWN-NULLNULLN/A—N/A
CLMCLM-4127582026-02-12T17:21:52ZRANDY—HUNT20031026·UHC-14907-14UNKNOWN-·UNKNOWN·3340 Main StSan DiegoCA92198GRP-2523CHOICE-PLUS-PPO
CLMCLM-4289342026-03-31T12:30:57ZBEVERLY—DAVIS1976-12-19UHC-39550-29-12642854470null9037 Cedar LnHoustonTexas77065GRP-7022SELECT-EPO
32,829 rows, page 149 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:40.335Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty