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-4206382026-05-29T05:13:16Z ———1994-10-23·UHC-58138-74•••-••-6327null—-NULLNULL—GRP-6963null
CLMCLM-4305002026-09-13T16:28:31ZMelissa—Lewis1999-01-05UHC-02738-68•••-••-1899677.201.0880N/A5700 Apache BoulevardLas VegasNV89125GRP-9133—
CLMCLM-4224482026-06-05T03:01:40Z JEERRY—MORRISON2001-04-26—•••-••-9501(576) 798-6753NULL4585 Ridge RdSacramentoCalifornia95859GRP-2375CHOICE-PLUS-PPO
CLMCLM-4160602026-07-03T19:06:08ZNATHAN—POWELL2008-10-26UHC-52217-20··•••-••-3581null—4106 Cedar LanePhoenixAZ·85080GRP-8355·-
CLMCLM-4168652026-05-20T07:18:55ZAngela—·Garrett·19480506-•••-••-52673277786956N/AUNKNOWNUNKNOWN——nullCHOICE-PLUS-PPO
CLMCLM-4059752026-04-01T03:25:54ZRomero, Zachary··—1987-08-21··UHC-63280-47•••-••-8360NULL··zachary.romero50@gmail.com7869 Camelback RdSacramentoCalifornia95833—CHOICE-PLUS-PPO
CLMCLM-4103962026-07-03T22:38:03ZPhilipAWood1946-02-19—·nullnull——-····——CHOICE-PLUS-PPO
CLMCLM-4047692026-07-27T04:17:52ZLUIS·U.PARK1950-09-14UHC-72273-24UNKNOWN-—-—nullN/AGRP-0576null
CLMCLM-4267572026-01-08T02:13:38ZKarenYHerrera6/10/1997N/Anull·214-789-7640———N/AUNKNOWNGRP-0554MEDICARE-ADV-A
CLMCLM-4054552026-06-05T00:43:28ZPHILIP··LAWRENCE1991-10-02UHC-27655-89•••-••-1678802-322-2072UNKNOWNUNKNOWN——·N/ANULLCHOICE-PLUS-PPO
CLMCLM-4032722026-07-11T15:05:02ZBrandon—Pierce1995-12-09null•••-••-7069····UNKNOWN1835 SPRING STCharlotteNC28289GRP-1585-
CLMCLM-4137512026-10-09T14:59:54ZGregory—Mendez05/15/47UHC-93422-08N/A——3586 HARBOR BLVDHoustonTX77003·GRP-3900OPTIONS-PPO
CLMCLM-4312332026-10-16T16:14:09ZJoan—Rivera1989-12-18UHC-22799-76UNKNOWN—UNKNOWN7244 OAK STREETMiami··FL33179-6183GRP-4230NAVIGATE-HMO
CLMCLM-4325822026-08-20T06:01:03ZCharlotte—Ross2004-10-21UHC7460796—nullNULL3803 Willow Ct Apt 38HoustonTX77017GRP-0539NAVIGATE-HMO
CLMCLM-4278452026-10-16T15:42:00ZBryanY.Mitchell1999-02-03nullNULL664.705.9422BRYAN.MITCHELL37@OUTLOOK.COM7660 Baseline RdSacramentoCalifornia95833-N/A
CLMCLM-4307432026-04-24T20:54:49ZLARRY—HANSEN19990813NULLnullN/A—N/AUNKNOWN—-GRP-3847CORE-HMO
CLMCLM-4260112026-10-02T12:39:33ZBrendaDLee1955-11-20UHC-79610-84UNKNOWN····brenda.lee68@hotmail.com1869 CEDAR LNHOUSTONTX77051GRP-4541MEDICARE-ADV-A
CLM CLM-4203602026-09-04T22:28:32ZDONNA—GREENE1989-01-17UHC-31782-23•••-••-1640nullnull5500 Hillcrest RoadSan DiegoCA92179··N/AMEDICARE-ADV-A
CLMCLM-4099202026-09-10T04:32:24Z larryI.black03/15/61UHC-17622-95•••-••-69683864735026··5388 Jefferson AveDenver·CO80277GRP-6853··CHOICE-PLUS-PPO
CLMCLM-4279292026-07-02T13:36:33ZGuerrero—Kevin1956-03-23UHC-55296-65•••-••-9830—N/A4927 RIVER RDFresnoCA··93783GRP-5331select-epo
CLMCLM-4182582026-03-23T07:50:00ZMariana··—Fowler1986-11-05UHC-92162-53····null—6958 MOUNTAIN VIEW DRIVEScottsdaleAZ85292GRP-8570····
CLMCLM-4160502026-04-07T08:13:07ZEugeneX.Bailey1968-02-11UHC-60178-10•••-••-9386null—5402 Church StTempe··AZ85252-options-ppo
CLMCLM-413754 2026-08-05T01:24:33ZAadm—Snyder1946-09-27UHC-25891-48•••-••-9530NULL—9660 Market StreetDenverCO80265——
CLMCLM-4292062026-07-06T01:54:27ZEric—MartinAug 28, 1956UHC2765665—955-444-0435NULL2962 Jefferson AveMiamiFL33197GRP-4913·null
CLM CLM-4068832026-03-20T00:19:48Z keith—dixon2004-09-02UHC-86166-19•••-••-3408UNKNOWNUNKNOWN·UNKNOWN-NULL—GRP-9351null
CLMCLM-4221092026-06-07T07:15:13ZEIMLYC.BENNETT02/04/81NULL•••-••-0952(398) 664-2803NULL5579 LAKE VIEW RDFRESNOCA93723GRP-5277OPTIONS-PPO
CLMCLM-4150672026-02-15T21:32:50ZDENISEJRICHARDSON2002-10-07UHC-40221-43—·(593) 381-1522UNKNOWN—UNKNOWN-··GRP-2041UNKNOWN
CLMCLM-4128632026-05-21T20:28:14ZAmber—Riley12/12/1998uhc-46144-77•••-••-4503539-814-0665—3250 Forest AveJacksonvilleFlorida——SELECT-EPO
CLMCLM-4134852026-03-14T22:10:13ZArthur—Torres2005-05-12UHC-83889-10N/A330-541-6365-3615 VALLEY VIEW DRDENVERCO80265·-—
CLMCLM-4314712026-06-18T19:27:33Z·Rebecca—Jones1967-05-27UHC-46908-53N/A753-583-3803—7642 Lincoln Way Apt 8SeattleWAN/AGRP-0894··—
CLMCLM-4235542026-05-01T07:40:23Zsarah··—franklin19-02-1979UHC-19757-48•••-••-9779N/AN/Anull——N/A-CORE-HMO
CLMCLM-4025482026-09-04T09:30:42ZHernandez, DianaA.—11/2/1968UNKNOWN-··929.867.5262null2531 Indian School RoadTucsonAZ··85707-··OPTIONS-PPO
CLMCLM-4212412026-09-15T00:28:56ZWEBERKFRANCES02/15/63··UHC-72878-47nullnullnull4716 Camelback Rd Apt 35Los AngelesCalifornia90013UNKNOWNcore-hmo
CLM CLM-4011952026-07-24T21:56:50ZWast, Noah——12/14/2008UHC-54131-68N/A(395) 624-8427UNKNOWN5602 CENTRAL AVENUEDenverCO80264GRP-2799—
CLM CLM-4292952026-04-08T06:59:44ZVALENTINA···SINGH1955-11-26NULLNULLNULLNULL4496 UNION STREETDallasTX75295GRP-8093CORE-HMO
CLMCLM-4047972026-09-02T09:31:37Z Alice—Perry0424-14-93UHC-53984-35•••-••-8976209-671-4901·null9138 HARBOR BLVD··DenverCO80219GRP-5494OPTIONS-PPO
CLM CLM-4212032026-05-06T02:10:10Z Kathleen—Santiago11-10-1943—-15027555551-UNKNOWNNULL——GRP-9707CHOICE-PLUS-PPO
CLMCLM-4135432026-08-10T18:10:15ZJaanet—Valdez1943-04-01··UHC-35323-58····4779931—7016 Ridge Rd··CHANDLERAZ85226N/Anull
CLMCLM-411314 2026-10-10T05:44:51ZJuy—Rivera1960-05-09UHC-37285-52•••-••-9002-··—6789 Main StreetCharlotteNC28209GRP-8564SELECT-EPO··
CLMCLM-4136342026-09-14T06:55:04Zjoshua··bell1951-09-15-UNKNOWNN/Ajoshua.bell83@outlook.comUNKNOWNNULL——GRP-6874—
CLMCLM-4268762026-08-26T03:41:27ZPhilip—Johnston7026-19-66UHC-61230-27•••-••-4955-philip.johnston71@yahoo.com9556 River RoadTUCSONAZ85789GRP-9569·MEDICARE-ADV-B
CLMCLM-4148082026-06-10T21:45:38ZCynthia—JensenMay 28, 1959UHC-82520-15nullN/AN/A454 APACHE BOULEVARDColumbusOH43277··GRP-8939CORE-HMO··
CLM CLM-4290012026-01-18T15:33:39ZGeorge—Berry1987-02-04··UHC-94256-16—9482191848—4676 Ocean Avenue·ChandlerAZ85299GRP-4306—
CLMCLM-4232972026-08-13T13:39:00ZMADISONRBROOKS1973-11-20··UHC6686528··-9136669109null4130 Desert Sky BoulevardAtlantaGeorgia30398UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4283392026-10-02T11:06:03ZArjunWRiosMay 7, 1946UHC-87030-13•••-••-129716252517938—5830 Desert Sky BoulevardPhoenixAZ85019GRP-7136NAVIGATE-HMO
CLMCLM-4067652026-09-20T16:16:35ZCamila—MillerFeb 11, 1961·UHC-19495-23NULL—-7163 Main StPlanoTX··75021··CHOICE-PLUS-PPO
CLMCLM-4284452026-04-11T23:57:43Z·Mike—Holmes·5/15/1999NULL•••-••-4471(472) 628-6045-6651 BroadwayDallasTX75263NULLUNKNOWN
CLMCLM-4284172026-03-18T04:17:01ZTYLER—WASHINGTON·Aug 11, 1941UHC7786445nullNULLN/A4828 Harbor BlvdSacramentoCA95892GRP-0847-
CLM CLM-4081852026-06-30T11:09:33ZCheryl··—Herrera·06-09-1975UHC-59021-38—nullcheryl.herrera@gmail.comNULLUNKNOWNUNKNOWNNULL-NULL
CLMCLM-4201702026-02-01T11:11:02ZMARIA G··ARMSTRONG1965-02-02UHC-58502-70UNKNOWNnull··6800 MAPLE AVETampaFL33677UNKNOWNNULL
32,829 rows, page 84 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.753Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty