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-4132402026-05-27T05:47:13ZLISA—MENDEZ1953-09-05UHC-19854-24•••-••-4947—-··9253 Jefferson AvenueSan DiegoCA92186——
CLMCLM-4158892026-07-20T01:17:43ZNATALIE—MURPHY·1958-12-02—•••-••-5190(232) 670-4718NULL9355 Meadow LaneSan AntonioTX78215-1920—N/A
CLMCLM-4033122026-07-08T01:52:55Z·JUSTINIPALMER1950-09-24·UHC-44225-20NULL—null··7502 Pine Drive··PHOENIXAZ85043GRP-8364MEDICARE-ADV-B
CLMCLM-4233202026-08-19T12:58:00ZHAROLD—RAMIREZ28-04-1943UNKNOWN•••-••-03027223160778-——N/AnullGRP-4984MEDICARE-ADV-A
CLMCLM-4233152026-01-29T01:06:21Z·Mark—ElliottAug 23, 1981UHC-53509-99•••-••-62092728556363mark.elliott58@gmail.com7325 HARBOR BLVDMinneapolismn··—·GRP-3364-
CLMCLM-4149942026-09-06T06:01:59ZCatro, Cheryl——1950-02-04UHC-39022-48-—UNKNOWN570 BroadwayPHOENIXAZ85002GRP-7936—
CLMCLM-4311322026-08-03T00:19:14ZNANCY—RIOS12/11/1977UHC-76965-35•••-••-7143—null9570 BROADWAYScottsdaleAZ85294GRP-7293····
CLMCLM-4184422026-09-29T15:58:04ZPriya·WHenderson1942-09-26··UHC-79286-86•••-••-8364—null3004 Cedar LaneTucsonAZ··85718—null
CLMCLM-4061362026-03-10T21:27:58ZAnna—Yang·1985-06-26UHC-14522-23•••-••-55419366818769null2243 Baseline RdDALLAS··TX··75213GRP-4082OPTIONS-PPO
CLMCLM-4061462026-04-04T16:53:18ZJoyce—Griffin1968-07-25·-—3388322N/A6425 OCEAN AVENUETampaFL33676UNKNOWNCORE-HMO
CLMCLM-4041652026-04-21T19:05:45ZLARRY—FRANKLIN1973-09-04UHC-64798-78•••-••-0981416-840-5275N/A9897 Sunset BlvdHOUSTONTX77017—··
CLMCLM-4221642026-05-28T13:58:29ZRonaldM.Edwards··04/08/1948N/A•••-••-8909—N/A·3088 Sage CtATLANTAGA30363GRP-5226MEDICARE-ADV-A
CLMCLM-4018922026-09-26T16:54:23ZOLIVIA—PETERSON19810821uhc-82814-76UNKNOWN--··NULL—-——-
CLMCLM-425435 2026-06-20T05:27:10ZLogan H—Hoffman1944-05-19UHC-61403-22··•••-••-1164NULLnull9891 Lincoln WayGlendaleaz85385GRP-1017CHOICE-PLUS-PPO
CLMCLM-4108902026-09-11T05:30:00ZBell, Katherine——·Jul 13, 1997nullN/A9027914060··8466 Bayshore Drive··Tempe·AZ85265GRP-3482CHOICE-PLUS-PPO
CLMCLM-4040142026-06-07T16:28:44Z MarthaRHall··1974-09-23UHC-14363-03•••-••-1247804-715-7691—-NULL·UNKNOWNN/AN/ASELECT-EPO··
CLMCLM-4208372026-07-27T12:43:03ZKAREN····MARTIN1984-04-01UHC-08306-99•••-••-2740(241) 502-9347null3754 Main StreetMiamiFL33149-8803GRP-2325SELECT-EPO
CLMCLM-4025712026-07-28T04:52:21Z·Anna—Chapman1947-10-17UNKNOWNNULL3139061549N/A··NULLNULL··N/AUNKNOWNNULL—
CLMCLM-4144732026-05-27T05:56:35ZDONNA—WELCH1976-06-06UHC-78754-72-4405110UNKNOWNNULL—nullUNKNOWNN/AN/A
CLMCLM-4233852026-08-21T04:07:50ZBARBARAOPATEL·1957-02-05nullNULL2108121415——NULL——GRP-1756OPTIONS-PPO
CLMCLM-4191852026-07-01T00:46:35ZEmmaJGardner1946-01-01UHC-09094-51•••-••-0259null—1132 Sage CtOrlandoFL32855GRP-2417CHOICE-PLUS-PPO
CLMCLM-4281282026-08-23T05:22:22ZRUTHMMEYER2004-06-19UHC-88349-27null·7358107—8704 Central AveGlendaleAZ85341-SELECT-EPO
CLMCLM-4265522026-10-03T05:41:00ZMASON—PALMER2005-01-19—•••-••-791713714733434MASON.PALMER@OUTLOOK.COM334 LINCOLN WAYATLANTAGA30351GRP-6564—
CLMCLM-4305792026-04-10T21:37:53ZMatthew—Long1990-05-18UHC-59379-93•••-••-7906—NULL5571 Meadow LaneGlendaleaz85358··GRP-3727CORE-HMO
CLMCLM-4123962026-06-09T15:48:10ZDebra—Le1951-05-14—····NULL—6850 Washington StPlanoTX75009UNKNOWNMEDICARE-ADV-B
CLMCLM-4315972026-03-23T16:44:46ZRichard—ChavezNov 18, 1969·UHC-25871-69•••-••-4795····-2382 Baseline Road·Las VegasNV89101GRP-2677CHOICE-PLUS-PPO
CLMCLM-4126612026-03-05T05:22:11ZOlivia—Wong1959-01-01UHC-39385-26··•••-••-5148—UNKNOWN68 Valley View DriveColumbusOH43209··N/ANULL
CLMCLM-4149192026-01-05T01:39:13ZJack··W·Butler9/3/1943—nullnull—3465 BroadwayOrlandoFL··32833GRP-7374null
CLMCLM-4190072026-01-31T08:16:57ZWALTER··GILBERTMay 27, 1963··UHC-67455-85null4285885393walter.gilbert@hotmail.com2595 MAPLE AVE·ChandlerAZ·85266NULL··null
CLMCLM-4016072026-05-22T07:48:25ZAbby—JordanFeb 5, 2000··—•••-••-6595—nullNULL——NULLGRP-5548—
CLMCLM-4313042026-06-03T18:18:53ZAmber—Mills··1988-04-07UHC8392302nullN/A—NULLNULLNULLnull—UNKNOWN
CLMCLM-4056162026-07-02T12:06:18ZlaurenQhawkins10/25/83UHC-71458-08•••-••-3714—NULL6596 ELM STREETDenverCO80298GRP-8544—
CLMCLM-4269552026-01-02T14:14:50ZgeraldV.··dean1964-08-14UHC-07212-83•••-••-0724(221) 540-9780-——-—NULL—
CLMCLM-4183942026-02-22T22:17:37ZLauraXFowler1995-10-11UHC-12216-11NULL7144179532——N/ANULL——options-ppo
CLMCLM-4105902026-01-08T08:33:12ZTyer—Russell12/09/1958UHC-38785-33———596 Hillcrest RdOrlandoFL32866GRP-7537—
CLMCLM-4314432026-05-24T20:14:10ZEmily—Henderson1966-08-08—···8598035084N/A·3328 Church StreetSAN DIEGOCA92107GRP-7932-
CLM CLM-4152542026-08-10T00:54:38ZRalph—·Pena1993-05-10·UHC-16904-99NULL·4703598893UNKNOWN154 Central AvenueJacksonvilleFL··32215GRP-6150—
CLMCLM-4277342026-03-16T16:34:36ZBeverlyK.Padilla02/20/1940UHC7758182nullnullnull··—NULLUNKNOWN··GRP-7297—
CLMCLM-4167022026-03-02T11:17:40Z DouglasAVargas1955-09-10UHC9565014——DOUGLAS.VARGAS@HOTMAIL.COM750 BroadwayMinneapolisMN55459UNKNOWN—
CLMCLM-4083172026-05-16T05:04:42Zaaron—murphy·1951-03-16UHC-20453-66•••-••-18243288083null8883 Canyon Road #127NashvilleTN37236GRP-6915navigate-hmo
CLMCLM-4237532026-01-21T23:47:50ZKIMBERLY····STEPHENS1939-11-27UHC-60875-27•••-••-6361-—3347 Elm StreetFresnoCA93711GRP-6549····
CLM CLM-4281922026-07-31T14:20:59ZREBECCA—CAMPBELL1938-06-11UHC-89802-47—587-775-0928N/A7151 Church StreetAustinTX·78776GRP-2103N/A··
CLM CLM-4321122026-04-10T06:58:02ZERIC—GORDON·2004-09-23uhc-02481-34··•••-••-1144N/A—9291 Main StSeattle·WA98164GRP-0232NAVIGATE-HMO
CLMCLM-4257192026-04-18T11:16:35Z·Nancy—Peterson1982-02-14UHC-74186-80•••-••-7771UNKNOWN—4126 Highland AveLOS ANGELESCA90052——
CLMCLM-4278662026-04-14T13:03:54ZJacqueline—·YoungJan 1, 1990UHC-68305-08N/A-····5721 VALLEY VIEW DRGilbertaz85223GRP-6012NAVIGATE-HMO
CLMCLM-4207792026-07-05T22:02:53ZBenjamin—GibsonNov 28, 1990—nullN/A—559 CANYON ROAD Apt 35ColumbusOH43281··nullNAVIGATE-HMO
CLMCLM-4101262026-07-19T23:12:09Zbruce—watson··Oct 1, 1956UHC-58660-37···NULL-—8285 Ocean Ave·MesaArizona85289GRP-6817NULL
CLMCLM-4162752026-08-06T17:35:13Z·JACOB—JENSEN1944-06-02UHC5580344—982-804-7639··null3352 Mountain View DriveLAS VEGASNV··89159GRP-6358null
CLMCLM-4081232026-09-01T04:53:54ZJASON—·MASONSep 2, 1984UHC-84953-50—NULLN/AN/A—-—GRP-9555-
CLMCLM-4147042026-02-08T04:22:01ZCynthia—Green1979-06-21UHC-66762-67—nullUNKNOWN1316 Jefferson Avenue··ORLANDO··FL32883GRP-6707·MEDICARE-ADV-A
32,829 rows, page 150 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.336Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty