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-4067962026-05-20T01:42:11ZEstrada, Glorya——1945-01-03UHC-90670-68•••-••-9140(915) 939-4695—9236 SPRING STREETHoustonTX77013GRP-8927-
CLMCLM-4094242026-10-14T06:52:49ZHarold—Bishop2006-05-25UHC5828464-595-697-2075N/A1322 Willow CourtSeattleWA98103—null
CLMCLM-4038012026-02-22T23:11:11ZFrances—Jacobs1986-09-08—•••-••-1981——9439 Baseline Road Apt 31AtlantaGA30373GRP-9791CHOICE-PLUS-PPO
CLMCLM-4012762026-06-24T10:23:39ZALBERTP.CLARK15-05-1977UHC-36686-91N/A18862532948UNKNOWNnullnullN/AN/A··GRP-6361NULL
CLMCLM-4244772026-08-05T18:59:02ZDIANA—TURNER19701106UHC-55479-79NULL+1 793 969 0217UNKNOWN3212 Lake View RoadGilbertAZ85235NULLNULL
CLMCLM-4220402026-02-27T21:45:30ZPATRICK··NICHOLS1945-08-01UNKNOWNN/A··(587) 569-0437N/A6749 HILLCREST RDSacramentoCA95837GRP-0745NAVIGATE-HMO
CLMCLM-4233672026-08-14T21:01:07Zyuki—wright1986-02-22UHC-59968-86-946-683-5588—·9017 Pine Dr #800JACKSONVILLEFL32241-1287GRP-6785—
CLMCLM-4311972026-08-05T00:26:35Zscott—stnoe19860626UHC-07176-62—3568083476NULLN/A—UNKNOWN··—GRP-8565····
CLMCLM-4189572026-06-24T22:45:41ZVINCENT—LE1947-02-13···N/A•••-••-1130920-289-8359VINCENT.LE78@OUTLOOK.COM1141 Ocean AvenueTempeAZ85219GRP-7235—
CLMCLM-4261922026-01-16T20:59:44Z ·Karen—Myers1996-06-23UHC-60681-55-9159541863null2203 Washington St #840SAN ANTONIOTX78274GRP-6507·CORE-HMO
CLMCLM-4242142026-02-15T19:21:26Zroy··—campbell1965-02-19UHC-44341-02—802-294-7510—4888 Union StreetPhoenixAZ··85060GRP-8562··CHOICE-PLUS-PPO
CLMCLM-4170642026-10-14T00:52:18ZRUTH—MARTIN··1995-04-11UHC1418210—null—3526 Maple AveTucsonAZ85762GRP-3109NULL
CLMCLM-4242672026-01-19T16:23:59ZBarnes, Jack········1940-07-25NULLNULLNULLnull5734 Washington StreetAtlantaGeorgia·30356GRP-9378NAVIGATE-HMO
CLMCLM-4321752026-08-03T10:43:16ZANTHONY—PARK02/22/01UHC-76242-39null(276) 313-9632anthony.park@yahoo.com379 Oak StreetDallas·TX75231NULL—
CLMCLM-4276512026-05-28T20:57:00ZRaymond—Phillips1995-01-28·UHC3431911—nullUNKNOWNNULL———GRP-7940UNKNOWN
CLMCLM-4097562026-04-22T21:23:39Z·WILLIE—REED19990202UHC-69931-09•••-••-8487UNKNOWN—N/AN/A—UNKNOWN—null
CLMCLM-4280742026-04-18T17:13:08ZChrisian—King1952-07-18UHC-48234-46··•••-••-4201+1 308 767 3267—5526 SUNSET BOULEVARDTempeAZ85215GRP-1478—
CLMCLM-4317532026-06-04T10:24:49ZWilliamIVargaas1981-12-28UHC-52456-25——UNKNOWN5990 Apache BlvdNashvilleTN37247-0881N/AMEDICARE-ADV-B··
CLMCLM-4140122026-03-10T00:55:38ZGloria—JenkinsDec 21, 1951UHC-11177-62-N/A—6842 MOUNTAIN VIEW DRIVESeattleWA98138GRP-1232-
CLMCLM-4238662026-05-05T08:13:26ZJERRY····HUNTER1998-11-13UHC-02293-76•••-••-6790UNKNOWNnullUNKNOWNNULLNULL··GRP-0904—
CLMCLM-4130832026-09-25T11:36:51ZHIROSHI—ROGERSAug 7, 1986UHC-98848-91—474.610.7880NULL·3858 BASELINE RDMIAMIFL-—OPTIONS-PPO
CLMCLM-4078672026-02-08T04:55:01ZPark, Angela——2004-01-02UHC-74100-67··•••-••-9110427-729-2616UNKNOWN2773 River RoadCOLUMBUSOhio—GRP-8683··UNKNOWN
CLMCLM-4252112026-03-31T10:25:00ZANDREAQ.HUDON0221-29-60UHC-74064-92•••-••-7856——2166 Lake View Road··Los AngelesCA90067GRP-9769·CHOICE-PLUS-PPO
CLMCLM-4304742026-01-27T16:32:22ZHannah—MorrisonNULLUHC-56979-48•••-••-6510—N/A3111 Grand AveAUSTINTX78728GRP-6416—
CLMCLM-4218362026-04-08T15:37:13Z sandraGfranklin07-06-2007nullN/A(551) 494-1927NULL8987 Palm DriveJacksonvilleFL32257UNKNOWNSELECT-EPO
CLM CLM-4147642026-08-24T02:53:04ZBenjamin—Thompson1992-01-19UHC-12484-48-——6338 BroadwayLos AngelesCA90045GRP-2682UNKNOWN
CLMCLM-4225642026-04-11T20:40:39ZDylan—Reid1943-12-05UHC-30535-48•••-••-7085——2056 Mesa DrPlanoTX75058UNKNOWNMEDICARE-ADV-B
CLM CLM-4188582026-05-06T15:36:40Z Kyle··OBryant1976-09-16UHC-45658-55—582-435-9988-······null-null—CHOICE-PLUS-PPO
CLMCLM-4206012026-07-01T03:23:11Znicholas··—·clark11/09/1963UHC-59054-98•••-••-4791-—7847 Highland AvenueSan DiegoCA92198——
CLMCLM-4184222026-06-29T15:27:58ZJOSEPH··—VARGAS1967-03-08-•••-••-93857969068393—8941 BASELINE ROADTEMPEAZ85247··GRP-0797medicare-adv-a
CLMCLM-4179402026-05-03T06:06:36ZJanice··Greene08/15/1986UHC-32981-06—--3408 Spring StSacramentoCA95829GRP-8995—
CLMCLM-4255362026-02-24T22:22:28ZBEVERLYK.CUNNINGHAM··1961-03-23··•••-••-9626(431) 714-6211—5678 Meadow LaneMiamiFL33173GRP-2211CORE-HMO
CLMCLM-4147582026-06-04T08:03:55Z·Alice—Marquez1978-07-81UHC-69942-61•••-••-2598—UNKNOWN···664 Oak StJacksonville·FL32229N/ACORE-HMO
CLMCLM-413500 2026-07-21T20:59:39Zlarry—·freeman1973-10-19·UHC-74769-25-—larry.freeman@aol.com8114 Sage CtTAMPAFL33688NULLNULL
CLMCLM-4101512026-10-06T15:32:52Z·HENRY—HUNTER06/03/1991UHC-15194-32——N/A1192 Oak StreetLas VegasNV89128GRP-1438CHOICE-PLUS-PPO
CLMCLM-420124 2026-03-01T11:01:37ZJULIA—·RICE·04/10/1993UHC-46090-42NULL263-721-4551··NULLUNKNOWNNULL····--··NAVIGATE-HMO
CLMCLM-4286902026-08-08T10:50:26ZRios, Lucia——1939-04-02UNKNOWN-nullLUCIA.RIOS@AOL.COM5436 CAMELBACK ROADDenverCO80248UNKNOWNMEDICARE-ADV-B
CLMCLM-4011762026-08-25T17:12:56ZJerry—West2005-09-21UHC-63267-01•••-••-5603UNKNOWN—-—N/A-—MEDICARE-ADV-B
CLMCLM-4162032026-08-20T13:28:34ZPamela—Ruiz1973-02-23UHC-19463-21•••-••-5562(769) 541-4373NULL383 Meadow LnCharlotteNC28235GRP-3665—
CLMCLM-4177372026-10-04T23:43:45ZWAYNE—CASTRO1950-09-06—•••-••-0212814-991-2985··-···2524 BASELINE RDSacramentoCA95862GRP-4266null
CLMCLM-432407 2026-02-25T06:50:05ZLori—Luna··2005-04-02UHC-97259-41•••-••-910117614348248··6738 MESA DRAtlantaGA30328GRP-8465CORE-HMO
CLMCLM-4228452026-06-28T08:55:11ZANA—GILBERT1979-03-17UHC-96425-46··-·338-695-3263—3101 Ridge Rd·HoustonTexas··77068NULL—
CLMCLM-4156092026-05-17T02:15:04ZJoshua—Coleman1999-09-26UHC9776178•••-••-5293+1 524 527 8049·null3148 WILLOW COURTChandlerAZ85286··GRP-5210—
CLMCLM-4274532026-03-01T11:17:39ZKathryn—Hart1947-01-10UHC-34576-96··•••-••-29974636167714null—---—SELECT-EPO
CLMCLM-4151182026-06-15T11:25:45ZCharlie—Burke08-11-1955UHC-58990-73N/A·NULLnull5211 SUNSET BOULEVARD #664Atlanta··GA30354-5254GRP-8328··SELECT-EPO
CLMCLM-4066202026-01-31T17:28:09ZBrendaTPorter0310-02-03-—448-807-9590—-NULL—N/A——
CLMCLM-4127772026-05-09T20:42:44ZERIC—BELL1947-07-17UHC-12364-05NULL16585341501UNKNOWN··5298 Highland AveLos AngelesCA90027GRP-9231··-
CLMCLM-4196132026-07-14T01:29:40ZCynthia—Banks1996-04-05UHC2179389—-—8267 Ridge RdMinneapolisMN55489-2704GRP-3095CORE-HMO
CLMCLM-421078 2026-04-04T22:43:07ZLucia··Smith·1964-01-03UHC-39153-37•••-••-7762——866 BROADWAYTempeAZ85275-—
CLMCLM-4156142026-01-12T05:16:29ZSingh, Terry··——May 20, 1956UHC-09840-40•••-••-5041UNKNOWN—·7381 MAIN STREETSeattleWA—·GRP-5929—
32,829 rows, page 15 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:34.776Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty