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-4116402026-07-21T08:03:19ZAnna—DominguezJan 8, 1988NULL•••-••-2906NULLN/A·1499 Indian School RoadSeattleWA98150N/AN/A
CLMCLM-4049642026-02-13T10:36:37ZDEBRAWMOORE1957-05-26·UHC-81059-05———3078 Jefferson AvePlanoTX75046GRP-1003null
CLMCLM-4030262026-04-01T09:20:54ZJordanFGardner1969-10-17··UHC-58120-60NULL—nullnull——nullGRP-3513NAVIGATE-HMO
CLMCLM-4118452026-09-25T13:16:38ZKIM—LEE06/28/1997UHC2217188——kimberly.lee32@aol.com4083 PINE DRSacramentoCA95899nullMEDICARE-ADV-B
CLMCLM-4110452026-06-26T10:16:58ZMei—Hudson05/03/61UHC-21510-91•••-••-6456(254) 680-9363—6252 Ocean Ave··TampaFL33610—····
CLMCLM-4251362026-06-07T15:06:14ZCarter, Hiroshi——1967-11-03—•••-••-5450N/A—5104 Ocean AvenueDenver·CO80296GRP-6919null
CLMCLM-4019432026-08-20T01:33:55ZBrittany—LunaJan 21, 1972UHC-53411-19•••-••-5329(573) 710-4001—4902 Lincoln Way··San AntonioTexas78252··GRP-7835—
CLMCLM-4101202026-04-25T06:09:17ZAARONX.CRUZ2008-01-18UHC-89556-76UNKNOWN15962960753N/Anull—-—GRP-5720—
CLM CLM-4102912026-09-30T11:53:17ZKaren····Morrison1985-06-12··UHC-03154-63null941-703-5798—9358 Mountain View DriveFresnoCalifornia93727GRP-3099—
CLMCLM-4248282026-07-01T22:10:32Z ElizabethO.Nuunez2008-08-01UHC-94641-83•••-••-8282—null··5625 WASHINGTON STREETSACRAMENTOCA95832GRP-0736-
CLMCLM-4103192026-04-11T21:25:37Z·cheryl—barnes20-12-1967UHC-40226-91•••-••-0403NULLnull··--UNKNOWN—NULLCHOICE-PLUS-PPO
CLMCLM-4048962026-01-25T11:58:34ZWayne N—Weaver1954-08-08UHC-84816-21—·284.934.4569NULL8045 Main StreetAustinTX78710GRP-9885SELECT-EPO
CLMCLM-4179152026-05-15T03:17:42ZJudithHWest1965-07-26N/A•••-••-7460null-9842 BroadwayGilbert···AZ85238UNKNOWNN/A
CLM CLM-4287642026-07-23T21:02:22Zelizabeth—rose2006-10-22N/A•••-••-2462386-345-7873—4365 BASELINE RDSAN ANTONIOTX78235GRP-2582MEDICARE-ADV-B
CLMCLM-4024422026-07-24T09:33:11ZRICHARD—PATTERSON23-06-1998UHC-63925-81•••-••-6931-NULL2676 Market StreetNashvilleTN37243GRP-5900MEDICARE-ADV-B
CLMCLM-4153552026-04-15T07:52:19ZKENNETH—KANNEDY07/03/97UHC-75623-35•••-••-3238·563.866.6962null2830 Valley View DrMinneapolisMN55413GRP-6252-
CLMCLM-4163732026-02-13T02:43:54ZJEFFREY—RICHARDSON2/3/2002nullN/AUNKNOWNjeffrey.richardson@aol.com7932 Union StTempeAZ·85288GRP-9259CORE-HMO
CLM CLM-4113672026-05-25T20:06:07Zjonathan—wheeler·20071020null-UNKNOWNUNKNOWN8429 Hillcrest Road #900ScottsdaleArizona85285GRP-4743—
CLMCLM-4188142026-03-02T01:26:14ZMARIANA—FERGUSON1992-09-24UHC-69580-26—409-501-0491NULL3155 Pine DriveJacksonvilleFL32295GRP-6313MEDICARE-ADV-B
CLMCLM-4179132026-07-14T04:53:59ZFernandez, Amy——2005-10-02··-null——8451 Willow CtAustinTX78787GRP-6851—
CLMCLM-4248692026-04-12T18:06:08ZNANY—MILLSFeb 27, 1950·N/A-··N/A4406 SUNSET BOULEVARDChandlerAZ85251GRP-5870NULL
CLMCLM-4194082026-06-17T07:16:26ZTorres, Mary······1951-03-26—•••-••-5780NULLnull5562 HIGHLAND AVENUEColumbusOH43298GRP-5496CHOICE-PLUS-PPO
CLMCLM-4226232026-04-20T15:30:12ZSOFIA··—MITCHELL1023-14-93-•••-••-092114854661548null3017 Meadow LnSAN DIEGOCA92186GRP-6757—
CLMCLM-4323562026-03-15T09:59:02ZRoy—·James·1967-08-14—-——8311 Main StTucsonAZ85778GRP-9873NULL
CLMCLM-4081892026-05-18T19:26:06Z HeatherRFreeman2004-06-07UHC-21700-64•••-••-3197206-687-8379————UNKNOWNN/A—
CLMCLM-4046022026-08-26T17:17:27ZRUSSELL··ELLIOTT2002-09-26UHC-72403-52NULL763-516-5615—nullN/A—NULLGRP-0951SELECT-EPO
CLM CLM-4310432026-05-23T02:51:20ZDorisT.Mendez1997-11-25UHC-89129-89null——4014 HARBOR BOULEVARDMiamiFlorida33178GRP-7243··NAVIGATE-HMO
CLMCLM-4270182026-09-05T16:06:46ZRICHARD F.—JAMES1974-11-02UHC-68219-53NULL685-467-6221—-—nullN/AnullCHOICE-PLUS-PPO
CLMCLM-4139202026-01-21T17:00:33ZGRACE—RAMMOS09-08-1991UHC-74116-69NULL····N/A683 HILLCREST RDCharlotteNC28231UNKNOWN—
CLMCLM-4115122026-06-12T18:22:03ZJudith—Castillo12-08-1984uhc-17837-26nullNULL··N/A5562 Pine DriveTucsonAZ85793GRP-8952·SELECT-EPO
CLMCLM-4113612026-06-02T08:37:27ZMarcus—Wong2006-10-05UHC-03574-75null—NULL8541 DESERT SKY BOULEVARDMesa··AZ85278NULLCORE-HMO
CLMCLM-4127362026-08-19T12:57:15ZJeffrey—Carlson1997-09-21UHC-10902-45•••-••-7785(754) 274-2574null6708 Market StFresno·California93724GRP-9476—
CLMCLM-4178432026-04-14T22:05:21Z Dominguez, Walter——03-11-1944UHC6857783-nullN/A7860 PALM DRIVEAtlantaGA30304-7881GRP-8567null
CLMCLM-4063772026-06-16T17:40:18ZMargaret—Lawrence1965-05-19uhc-37511-76—+1 794 744 2603———--GRP-2523MEDICARE-ADV-A
CLMCLM-4214382026-06-13T13:13:42ZPeterRFerguson1948-03-25—UNKNOWN—UNKNOWN1560 Central Avenue··HOUSTONTX77066GRP-0108—
CLMCLM-4251822026-08-09T08:47:09Z Henry—Ruiz1973-01-02UHC-65473-87•••-••-49708145226501UNKNOWN662 Willow CourtLas VegasNV89154UNKNOWN-
CLMCLM-4049342026-10-13T03:14:36ZVINCENTY.HOWARD1993-07-20UHC-15428-40—679-563-3875null1898 Meadow LaneFresnoCA93715GRP-5807NAVIGATE-HMO
CLMCLM-4095922026-04-27T00:07:53Z Evelyn O.—·Olson2005-11-27··NULL—6593857016null8984 Jefferson AveJacksonvilleFL32276N/AMEDICARE-ADV-B
CLMCLM-4178902026-06-25T09:17:59Z·ryan—wright03/20/1953UHC-72160-97•••-••-0957790.280.1373NULL2436 Maple Avenue·San DiegoCA92120GRP-6501CHOICE-PLUS-PPO
CLMCLM-4044592026-03-16T13:15:20ZKELLY—BAKER2006-08-28N/A——KELLY.BAKER74@OUTLOOK.COM4218 SUNSET BOULEVARD #126San DiegoCA92180-SELECT-EPO
CLMCLM-4162682026-04-18T20:54:40Zrichard—brooks1960-04-23···UHC-17374-35null——5687 HIGHLAND AVENUEHoustonTX77044—OPTIONS-PPO
CLM CLM-4269512026-02-27T09:57:57ZPowell, Karen——1988-04-09—UNKNOWN19648633370--UNKNOWNNULLNULLGRP-1921···NULL
CLMCLM-4047242026-03-25T10:44:51ZROBERT····BROOKS1945-01-05UHC2106319•••-••-3026UNKNOWN—5786 Desert Sky BlvdLOS ANGELESCA90074GRP-8234—
CLMCLM-4020082026-09-17T10:20:42ZGrant, ArthurM—1960-10-23UHC-68341-63•••-••-62266057398363NULL3750 SUNSET BLVDNashvilleTN37221-0656····CORE-HMO
CLMCLM-4079372026-06-15T07:24:27ZNoah—Clark07/26/48uhc-89607-22•••-••-085412773709227null6089 Hillcrest Road·SeattleWA··98121··MEDICARE-ADV-B
CLMCLM-4220072026-03-20T23:33:14ZRuth—Sandoval1984-05-06null•••-••-9328-————NULL··——
CLMCLM-4177492026-03-31T04:25:45ZScott, Jose——·1979-05-02UHC-23800-23•••-••-4784—jose.scott14@hotmail.com1716 Ridge Rd·NASHVILLETN37283GRP-7917OPTIONS-PPO
CLMCLM-4153992026-06-14T07:51:26ZDiana—Hughes1975-03-01UHC-99954-49—(589) 650-3515····8291 Palm DriveDALLASTX75254-9397GRP-4361MEDICARE-ADV-A
CLMCLM-4218992026-07-07T11:29:02Zalexis—price9/9/1958NULLnull903.494.0566-UNKNOWN··N/AUNKNOWN-—SELECT-EPO··
CLMCLM-4066082026-09-26T20:50:43Z Ralph—Torres19450917UHC4430715··-NULLN/A7823 LINCOLN WAYPhoenixAZ85014—-
32,829 rows, page 36 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:36.681Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty