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-4305662026-10-09T22:12:50ZLogan—Greene1941-01-16—UNKNOWN+1 609 552 8497N/A··8341 Market StGlendaleAZ85355····UNKNOWN
CLMCLM-4300982026-01-08T12:27:50ZVALENTINAXWILLIAMS·21-09-1982null•••-••-8991null··null8185 MESA DRColumbusOH43287GRP-7325-
CLMCLM-4200252026-01-31T07:08:45ZKayla—Richards1976-01-10—•••-••-5895N/AN/A·2779 Pine DriveDALLASTX75256-OPTIONS-PPO
CLM CLM-4096282026-09-26T02:09:24ZVirginiaT.Rice1942-12-26UHC-60262-09•••-••-2105N/AUNKNOWNUNKNOWN—NULL··——NAVIGATE-HMO
CLMCLM-4102532026-04-28T01:12:17ZFRANK—CATER1947-02-18UHC-10287-51•••-••-0190·(446) 890-8032UNKNOWN8754 Meadow LaneTempeArizona85277N/AUNKNOWN
CLMCLM-4075282026-01-22T12:45:46ZJustin—LittleJun 17, 1966N/A•••-••-69256579115337—7591 Cedar Ln·HoustonTX77007GRP-5710NAVIGATE-HMO
CLMCLM-4139112026-09-06T00:27:38ZPAULTKNIGHT1972-09-06UHC-66169-12•••-••-5100UNKNOWN····2787 Grand AveLas VegasNV89140GRP-8028··—
CLMCLM-4247462026-05-07T20:48:09ZPatrick—Kim1962-11-14UHC-96604-35•••-••-0117N/A—2124 Valley View DrTampaFLUNKNOWN·GRP-0498—
CLMCLM-4269612026-02-12T12:26:41ZRuth—LittleJan 3, 1959UHC-82691-02•••-••-95877763988605—9184 Pine DriveMiamiFL33137nullCHOICE-PLUS-PPO
CLMCLM-4258522026-08-24T20:17:35ZALEXIS—MITCHELL1973-02-06··N/A•••-••-2956····null1919 PARK PLACEJacksonville··Florida32209GRP-3369—
CLMCLM-4155542026-01-06T17:33:28ZGREGORY—HOWARD1941-03-20UHC-16734-85•••-••-1093——·101 Main StTucsonAZ85777GRP-9645CORE-HMO
CLMCLM-4187872026-06-25T06:19:27ZLarry··—Green1958-08-24UHC-67519-46NULL·nullN/A7068 LAKE VIEW RDOrlandoFL32830··—NAVIGATE-HMO
CLMCLM-4101172026-06-16T14:04:15Z Cheryl·····VazquezNov 15, 1985·null•••-••-99036724130143··8857 MOUNTAIN VIEW DRGilbertAZ85239nullNAVIGATE-HMO
CLM CLM-4038642026-06-04T21:19:38ZMegan—Richardson1971-07-22NULL•••-••-795118647372651—4111 PARK PLACE·San AntonioTX78210GRP-2198MEDICARE-ADV-B
CLMCLM-4191992026-02-27T07:04:18ZMei—West06/26/1967UHC-89424-95—(686) 885-2208-9560 Lincoln WayAustinTX78729····SELECT-EPO
CLMCLM-4056932026-01-02T14:53:46Zbradley—·vazquez1943-01-07NULL··nullnull—9117 MEADOW LANEAtlantaGeorgia30368·GRP-8422CHOICE-PLUS-PPO
CLMCLM-4286962026-09-11T04:36:51ZJOYCE··—HANSONJan 25, 1963UHC-16292-82•••-••-2836N/A—7610 Mountain View DrivePlanoTX75019-—
CLMCLM-4031682026-09-04T01:46:21ZANN····GILBERT10/07/2004UHC-20636-06•••-••-44825677011970—2196 Sage CtCHANDLERArizona··85274UNKNOWNNAVIGATE-HMO
CLMCLM-4187022026-07-21T02:43:37ZPaul··—Martinez1953-03-19-··•••-••-90288315175723N/A2801 Grand AveFresnoCalifornianullGRP-5783MEDICARE-ADV-B
CLMCLM-4248262026-05-04T10:59:32ZDENNIS—·THOMPSON1956-10-11NULL·-(468) 758-6380—2670 Union StSeattleWA98143NULLCORE-HMO
CLMCLM-4250082026-05-06T20:44:55ZMaason—Bradley1986-07-19·UHC-43681-03——N/A2852 APACHE BOULEVARDMINNEAPOLIS·MN·55414-2153—SELECT-EPO
CLMCLM-4126672026-01-01T23:15:15ZYUKI—HOFFMAN·1940-03-10UHC-91732-54•••-••-6103——2368 HARBOR BOULEVARDLas VegasNV89100—MEDICARE-ADV-B
CLMCLM-4233402026-07-02T18:17:58ZRobert—Watkins2001-07-07—·NULL(640) 987-0505—8144 Grand Ave Apt 23DALLASTX75245N/ANAVIGATE-HMO
CLMCLM-4037832026-01-10T09:38:36ZHeather—Walsh1942-10-11UHC-45163-98•••-••-1610UNKNOWN——-—UNKNOWNnullNULL
CLMCLM-4113522026-04-04T12:52:27ZBowman—Gerald1991-02-02UHC-87238-28——gerald.bowman@outlook.com··—N/ANULLUNKNOWNGRP-7028OPTIONS-PPO
CLMCLM-4259702026-07-29T17:40:49ZSophiaG.Walker5/18/1996·UHC-84938-93•••-••-9861981.967.7772N/A2087 Highland AveLas VegasNV89140GRP-7826MEDICARE-ADV-A
CLMCLM-4212282026-07-01T11:06:23ZSharon—Reynolds1980-02-01UHC-55069-69-5148055266-653 Ocean AveSan DiegoCA92167UNKNOWN—
CLMCLM-4190692026-05-21T07:55:17ZBanks, Christine——1957-10-20-—UNKNOWNUNKNOWNN/ANULL—null··N/A—
CLMCLM-4055712026-03-06T03:46:36ZSullivan, Lawrence····—0112-02-01UHC-85120-50··UNKNOWNNULLUNKNOWNN/A———GRP-4069MEDICARE-ADV-A
CLMCLM-4025512026-03-17T05:41:49ZWalker, Russell——03/18/1990UHC-74532-97•••-••-2366·437-286-5571—3949 MAIN STOrlandoFL32835GRP-1845—
CLMCLM-4303022026-07-20T03:23:57Zdebbie—perez—NULL·N/A-null2625 Highland AveChandlerAZ85246-2725GRP-9416·UNKNOWN
CLMCLM-4116432026-03-21T01:48:10ZPamela—Webb19610711UHC-81941-48NULL641.220.4459UNKNOWN5174 Lake View RoadSan DiegoCA92163NULLCORE-HMO
CLMCLM-4165292026-06-28T17:31:06Zsophia—guerrero19720606UHC-35263-16•••-••-23683778730768N/A1068 Grand AveCharlotteNC··28226——
CLMCLM-432519 2026-09-16T04:53:34Zjoe····stevensJul 16, 1952UNKNOWN—-—6977 APACHE BOULEVARDSeattleWA98174—SELECT-EPO
CLMCLM-4110172026-04-10T00:48:56ZKeith—Palmer21-02-1984··UHC-38493-61-UNKNOWN—7266 Meadow LnColumbusOH43211—UNKNOWN
CLMCLM-4034072026-04-16T10:02:13ZMARIANAFWEBB1960-07-07UHC-20825-98•••-••-0923——9040 Canyon RdHoustonTX77026GRP-3195NULL
CLMCLM-4104042026-05-27T15:37:09ZSmith, Debbie——·Feb 11, 1955UHC-06521-05•••-••-9405N/A—805 Market StPlanoTX75081-0636GRP-6888·OPTIONS-PPO
CLMCLM-4301292026-03-07T17:20:54ZMelissa—Maldonado19710616UHC-80701-58•••-••-8572——7835 CHURCH STREETSan AntonioTX78272GRP-5911N/A
CLMCLM-4020892026-04-04T19:22:51ZThomas—Harvey05-03-1944NULLNULL—thomas.harvey@proton.me7820 BAYSHORE DRIVELas VegasNV89123UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4018372026-04-09T05:58:38ZANTHONY—HERNANDEZJan 3, 2003UHC-96290-74—UNKNOWN—9167 Main StreetCHARLOTTENC28204—NULL
CLMCLM-4318762026-09-18T12:59:04ZPatrick—Padilla1968-02-15—•••-••-0317nullUNKNOWN4783 Oak StreetMESAAZ85264GRP-4059UNKNOWN
CLMCLM-4063292026-09-16T21:51:25ZSusan—Cruz1999-02-13NULL—(861) 965-4207—9775 Cedar LnAtlantaGA30338UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4058562026-03-28T06:55:57ZGibson, Dylan——1946-04-15——-—nullNULLN/A—GRP-2797-
CLMCLM-4254692026-09-18T18:28:38ZSTEVEN—RAMOS1969-01-26nullNULLNULL—1184 Hillcrest Rd Apt 12SacramentoCA··UNKNOWNnullnull
CLMCLM-4299932026-05-18T06:08:49ZTERRY—HENDERSON1940-10-05—•••-••-3465+1 443 318 2087···NULL6152 Meadow LaneMinneapolisMNnullGRP-0458—
CLMCLM-4227992026-03-05T00:03:10ZDuncan, Terry———uhc-48122-41··-14503059619—3045 Highland AvePlanoTX·75088GRP-3999null
CLMCLM-4007292026-03-18T11:33:34ZJACOB—GRANT1995-02-18-—+1 440 783 9259UNKNOWN1832 Oak StreetSEATTLEWA98172N/A·CORE-HMO
CLMCLM-4182952026-07-18T18:51:24ZMatthews, AngelaC—1953-01-07NULLnull(846) 683-7684··UNKNOWNN/A-—UNKNOWN·GRP-1223OPTIONS-PPO
CLMCLM-4198082026-08-24T18:55:12ZAARONUORTIZ12/1/1972NULL—·5676906186—3890 Baseline RoadTempeAZ85238GRP-6960CHOICE-PLUS-PPO
CLMCLM-4162362026-09-25T03:54:10Z Gloria—Harper1943-06-01—•••-••-8737398-374-9184N/A—null——GRP-7609MEDICARE-ADV-B
32,829 rows, page 97 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:37.773Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty