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-4013242026-03-20T07:39:54ZLogan—Padilla··1976-02-04UHC-20084-25NULLnullNULLNULL··NULL—UNKNOWNGRP-0386CORE-HMO
CLMCLM-4060572026-09-12T19:34:11Zzachary—hudson12/12/1952—•••-••-2862N/Anull3391 Jefferson AveGilbertAZ85288GRP-1265—
CLMCLM-4323502026-04-09T00:06:52ZJAMES·KKIM1968-09-24UHC-64142-84··-N/A—9095 ELM STNashvilleTN37272GRP-6213MEDICARE-ADV-A
CLMCLM-4193952026-06-26T06:49:16ZSOPHIAP.MORENO1978-04-16UHC-86788-83N/A9439019688UNKNOWN7487 RIDGE ROADTucsonArizona85721GRP-1938medicare-adv-a
CLMCLM-4039622026-04-26T14:27:33ZBrittany—Maldonado19600722UHC-58633-21•••-••-05615311783NULL—N/A—NULLUNKNOWNNAVIGATE-HMO
CLMCLM-4121182026-05-09T07:18:29ZAaron····Daniels··2004-01-07—•••-••-9249nullAARON.DANIELS@OUTLOOK.COMnull·NULL——·nullUNKNOWN
CLMCLM-4203262026-01-18T17:56:41ZAndrew—MatthewsJul 4, 1980NULL•••-••-916314503420006—606 Church StMiamiFL33129NULLSELECT-EPO
CLM CLM-4209602026-04-25T00:34:54ZBilly··—Freeman··—UNKNOWN··•••-••-4033885-855-5367william.freeman53@proton.me765 Highland AvePlanoTX-GRP-7298NAVIGATE-HMO
CLMCLM-4019012026-02-13T17:59:26ZSamuel—·Burns2001-12-03-—·NULLUNKNOWN3883 Canyon RoadSeattleWA98162GRP-1891MEDICARE-ADV-A
CLMCLM-4040752026-09-26T11:35:18ZLORI····CONTRERAS··1990-09-21—NULLN/A-null—nullNULLGRP-1235—
CLMCLM-4243232026-08-18T10:35:20Z·ALAN—POWELL·91980304UHC-25780-72NULLUNKNOWNnull——N/A--CHOICE-PLUS-PPO
CLMCLM-4261442026-07-08T18:45:40ZRichard····Espinoza05/16/57UHC-68182-02•••-••-2977516-339-6241NULLN/A··—NULLGRP-4493MEDICARE-ADV-A
CLMCLM-4094552026-08-10T08:03:51ZYang—Pamela1/6/1945UHC-06553-73N/ANULLnull4873 Market St #826DallasTX·75230GRP-7329·medicare-adv-a
CLMCLM-4210452026-10-12T15:03:00ZWilliamson, Joshua——·1987-07-19—•••-••-1163N/ANULL2202 APACHE BOULEVARDJacksonvilleFL32286GRP-8030-
CLMCLM-4017402026-06-28T17:32:24ZTersa······HansonNov 19, 1968-null—UNKNOWN·6035 Indian School Road #188JacksonvilleFL32265GRP-0818NULL
CLMCLM-430770 2026-05-26T15:36:06ZAndrea—·Kim18-01-1939UHC-58093-27—9198035UNKNOWN152 Market StreetHoustonTX77022-5162GRP-2679NAVIGATE-HMO
CLMCLM-4011082026-09-13T06:09:36ZKathryn—Holmes02/10/39UHC-21580-23-N/AUNKNOWN1223 Canyon RdAUSTINTX78717—NAVIGATE-HMO
CLMCLM-4245522026-10-12T01:16:13ZBILYL—LARSONMar 8, 1991—•••-••-3271481-978-0523-2175 Mesa Dr #178AUSTINTX78780GRP-0265-
CLMCLM-4264942026-03-19T07:42:40ZamandaUmcdonald·1961-09-28—•••-••-8659UNKNOWNamanda.mcdonald63@yahoo.com6337 Apache BoulevardMiamiFlorida33178UNKNOWN—
CLMCLM-4020442026-07-31T09:18:50ZbrianK.wong1946-09-25UHC-95997-72•••-••-91249883648520—2639 Canyon RoadPLANOTX75033GRP-2182—
CLMCLM-4041512026-03-28T15:05:36Zpaul—crawford1973-04-11··-•••-••-0097N/AN/A6341 Grand AvenueTampaFL33672GRP-4452SELECT-EPO
CLMCLM-4289992026-09-14T21:26:28ZMason—Perkins10/14/1994null•••-••-3452—UNKNOWN———UNKNOWN·GRP-6708null
CLMCLM-4141832026-01-24T23:40:02ZEMMA··—·HUDSON1957-12-12-UNKNOWNN/ANULL5153 Sunset BlvdPHOENIXAZ85085—CORE-HMO
CLMCLM-4015052026-04-28T02:39:45ZBrian—Hansen·12/21/1985UHC-10706-35N/A——2266 Ridge RoadGlendaleAZ85316GRP-9141CORE-HMO··
CLMCLM-4289102026-01-23T04:58:33ZBILLY—LEWIS1942-04-19·uhc-32201-16-+1 221 273 1809··—·1864 Main Street·Eden PrairieMN55369-6574UNKNOWNCORE-HMO
CLMCLM-4088902026-06-19T21:54:35ZKATHRYN—BAILEY1952-03-04UHC-55375-25null—UNKNOWN4062 Baseline RoadTampaFL33627GRP-1663CORE-HMO
CLMCLM-4023752026-04-28T15:08:19ZAUSTINMYANG07/18/1983UHC-35695-44··•••-••-4416—UNKNOWN1442 Meadow LnJACKSONVILLEFL32212N/ANAVIGATE-HMO
CLMCLM-4251052026-02-15T19:24:45ZMarkZJimenez···6/8/1974UHC-85724-40•••-••-1440—UNKNOWN3944 VALLEY VIEW DRIVEDenverCO80279GRP-8990CORE-HMO
CLMCLM-4216492026-10-11T04:38:16ZMark—Washigton2006-12-27N/A•••-••-5070760.764.0652—5914 Ridge RoadMinneapolisMN55434-3829GRP-7600SELECT-EPO
CLMCLM-4182732026-04-14T11:04:51ZPhilip—Singh1975-11-10UHC-22844-24•••-••-5517——9171 Canyon RoadJacksonvilleFlorida32261nullMEDICARE-ADV-A
CLMCLM-4297172026-09-12T16:35:57ZLawrence—Ramirez1993-03-11UHC-95611-07•••-••-5273N/Alawrence.ramirez78@yahoo.com1423 Cedar LaneTucsonAZ85769GRP-3654··OPTIONS-PPO
CLMCLM-4062812026-01-25T21:25:00ZCAROL··—WILLIS1978-04-14uhc-44523-10•••-••-7448·329-818-0918—3797 Palm Dr··Los AngelesCA90057—MEDICARE-ADV-A
CLMCLM-4176662026-04-19T19:43:20Zfrank—james05/28/1954··—•••-••-3029null—1373 Highland AvenueMIAMIFlorida33150GRP-9168··SELECT-EPO··
CLM CLM-4055112026-03-14T14:13:35Z larry—dean1985-10-03UHC-23098-85•••-••-90176533495722—NULL—·UNKNOWNUNKNOWN-MEDICARE-ADV-A
CLMCLM-4168292026-07-19T02:44:25ZZACHARY—WOOD1997-04-09UHC-69285-61-··—N/A6841 Oak StDenverCO80276GRP-6950—
CLMCLM-4244842026-08-11T12:06:43ZSHARONQALEXANDER1992-04-27UHC-08955-29N/A+1 452 684 2501—4450 Ocean AvenueDallasTX75213-3729NULL··
CLMCLM-4087632026-04-14T06:43:10ZALVAREZ—GERALD14-10-1956UHC-63558-98-6056733343null··3604 Mountain View Dr Apt 27MiamiFL33132—OPTIONS-PPO
CLMCLM-4071652026-09-15T07:20:50ZBEVERLY··CRUZ12/13/2004UHC1285242NULLN/ANULLN/A—NULLNULLGRP-8868null
CLMCLM-4063522026-01-24T10:20:15ZAngela—Lawson1966-08-21UNKNOWN—332.528.5419null1035 BAYSHORE DRDALLASTX75283GRP-3147·OPTIONS-PPO
CLMCLM-4318342026-02-10T00:49:10ZVicky—Yang1943-09-22··UHC-95449-76•••-••-9640N/A····2579 HILLCREST ROADTampa··FL·33650-4446GRP-7339UNKNOWN
CLMCLM-4261422026-02-05T17:41:33ZTERRY—BURNS1948-12-24N/Anull8913826248N/A3680 RIDGE ROADDallasTX75211GRP-9213CHOICE-PLUS-PPO··
CLMCLM-4039052026-05-22T09:54:40ZRalph—Martin3/7/1998—N/AN/AN/A3214 Valley View DriveLOS ANGELESCA90098GRP-6621-
CLMCLM-4168562026-08-14T01:24:56ZJanet—Cruz1942-09-25UHC-97798-27null+1 921 823 6106-9160 Sage CtNashvilleTN37254UNKNOWN—
CLMCLM-4262072026-02-17T20:31:46ZAnna··PayeNov 27, 1966UHC9345664•••-••-2402null—-—NULLNULL-—
CLMCLM-4294842026-07-22T10:51:13ZKing, StephenZ.—20-01-1969UHC-15796-58—UNKNOWNstephen.king47@gmail.com5493 MEADOW LNLos Angeles··CA90019—null
CLMCLM-4000622026-06-03T12:06:36Zchristian—ruz-UHC-95544-56•••-••-4553-nullNULLUNKNOWNNULLUNKNOWNnullMEDICARE-ADV-B
CLMCLM-4297152026-05-22T19:11:33ZGloriia—Martin9/15/1989—•••-••-3700UNKNOWNNULL6216 CANYON ROADMiamiFL33155GRP-6616MEDICARE-ADV-B
CLMCLM-418980 2026-09-19T16:22:01ZASHLEY··—HUNT1993-02-17UHC1713504NULL717.515.1481null-——··GRP-1969-
CLMCLM-4249622026-03-16T07:58:05Z·DAVID—BENNETT2008-07-02UHC-52325-21—6314243075null··4502 Sunset BlvdLos AngelesCA·90029GRP-7191····
CLMCLM-4262032026-05-13T16:04:26ZLuciaIMorrison08-08-1949UHC-40834-54NULL—lucia.morrison@yahoo.com3272 Forest AveDallastx75243——
32,829 rows, page 162 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.356Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty