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-4111132026-03-21T16:17:47ZKimberly—SullivanJul 8, 1957null--NULL1633 FOREST AVESCOTTSDALEaz85221-4348·GRP-1862NULL
CLMCLM-4129052026-08-14T15:21:05ZCook, Amanda——1976-05-04UHC-27610-61—NULL··N/AnullUNKNOWN—UNKNOWN··GRP-9012SELECT-EPO
CLMCLM-427715 2026-10-17T12:32:32ZBilly····Palmer·Sep 23, 1993UHC-01676-73•••-••-69073007539041N/A7861 Hillcrest RdSEATTLEwa98101GRP-6011N/A
CLMCLM-4082302026-08-27T07:03:50ZJASON—RAMIREZ1998-11-21UHC-37350-18nullnull—6727 Valley View DriveMINNEAPOLISMN55491GRP-5055NULL
CLMCLM-4233162026-01-16T09:31:05ZWILLIE—HILL19540217nullUNKNOWN4047319190null6950 Camelback Rd Apt 20GilbertAZ85250NULLNAVIGATE-HMO
CLMCLM-4257482026-06-29T03:30:42Zsraa—robertson12-04-1962UHC-65179-24—nullN/A910 Forest AvenuePhoenixArizona85005—NAVIGATE-HMO
CLMCLM-4303392026-03-14T14:38:47ZSamuel—GrayAug 6, 1970UHC-28025-58NULL(214) 223-6265···N/ANULLUNKNOWNN/Anull-NAVIGATE-HMO
CLMCLM-4015162026-01-24T07:10:23ZAlice—Le01/22/1943-······—845 Bayshore DrCharlotteNCN/AGRP-2006N/A··
CLM CLM-4190042026-06-05T02:11:13ZWei, Reynolds——1973-07-01UHC-28141-19—N/A—2782 APACHE BLVDScottsdaleAZ85297UNKNOWN-
CLMCLM-4109562026-05-18T10:11:46Z·JERRY—MYERS1986-04-12UHC-09953-85NULL··342.977.9510··NULLN/AUNKNOWNN/AGRP-6805N/A
CLMCLM-4058452026-06-01T08:49:32ZRogers, Jessica—····1941-09-24UHC-93976-99•••-••-232014656874356—3358 Central AveSan DiegoCA92198··GRP-8535N/A
CLMCLM-4325412026-01-03T20:57:38Z Sophia··Reid1987-11-27UHC-92033-81N/ANULL—4481 Bayshore Dr #582Las VegasNV89121GRP-6536CHOICE-PLUS-PPO
CLMCLM-4271192026-07-26T16:54:07ZGabrielLGonzalez1939-10-10UHC-48725-02N/A755.603.9946gabriel.gonzalez@gmail.com2465 Central AveOrlandoFL32877GRP-7794··MEDICARE-ADV-A
CLMCLM-4012472026-06-12T00:34:10ZKevinAGray1944-07-03UHC4194442-9134016009UNKNOWN——N/A—nullCORE-HMO
CLMCLM-4063792026-05-14T03:56:51ZMark—Roberts1955-12-08UHC-20647-47NULL(281) 859-0566—9141 Hillcrest Rd·Dallas·TX75281GRP-0954MEDICARE-ADV-A
CLMCLM-4245712026-02-05T15:31:30ZEUGENE—NICHOLS1980-03-11··UHC-77317-26—··N/A1911 PALM DRIVEPHOENIXAZ85031-2293GRP-4279NAVIGATE-HMO
CLMCLM-4158912026-04-15T18:57:59ZWAYNE—GUERRERO1961-09-03N/AUNKNOWN9145693394nullnull—N/ANULLnullCORE-HMO
CLMCLM-4115202026-07-21T20:27:40ZKATHLEEN—ROBERTSON5/13/1975UHC4723625•••-••-4860352.281.4693—7407 Pine Dr #203TampaFL33685GRP-6444CORE-HMO
CLMCLM-4266112026-05-23T04:01:34ZBarbara—Johnston19731210··—NULLUNKNOWNNULLN/AN/AN/Anull—
CLMCLM-4046792026-04-19T09:49:17Zjulia—murray08/10/1975UHC-55303-54•••-••-4860573-757-4995N/A—-null——··
CLMCLM-4235012026-02-03T06:22:40Z Omar—Silva1962-06-26UHC-10513-43N/A(356) 499-3674—4924 MOUNTAIN VIEW DR··SeattleWA98179GRP-2070—
CLMCLM-4230022026-05-02T17:02:32Z Rob····Maldonado20-03-1994UHC-70978-88NULL8314695053-8660 VALLEY VIEW DROrlandoFL32850GRP-6472UNKNOWN
CLMCLM-4029122026-05-11T16:52:18ZDuncan, Kate——1958-06-19··—•••-••-3120822.200.4053—5680 Maple AveNASHVILLE·TN37295—NULL
CLMCLM-4146542026-10-14T04:42:30ZAISHA—LAWSON2002-08-08UHC-24582-90—-N/A6933 Mesa DrGilbertAZ85281GRP-3889NAVIGATE-HMO
CLMCLM-4143862026-02-03T21:47:27ZKayla····Flores1968-07-09-··+1 326 740 4190—9041 Central Avenue #308Eden PrairieMN55309GRP-2091—
CLMCLM-4119062026-05-25T03:42:54ZJONATHANBHARRIS··1997-12-08UHC-49757-35—(541) 493-9008JONATHAN.HARRIS@HOTMAIL.COM4530 INDIAN SCHOOL RDLAS VEGASNV89149GRP-3565CHOICE-PLUS-PPO
CLMCLM-4272662026-06-03T20:00:10ZDoris—Ryan1981-08-24UHC0416633null··3596909950———null—N/A-
CLMCLM-4145232026-02-13T06:52:43ZMariana—Walker05/06/61—····(700) 969-0386nullN/Anullnull·nullGRP-3217MEDICARE-ADV-A
CLMCLM-4251712026-09-15T02:18:45ZAMANDA—SIMMONS19450214UHC-72306-59•••-••-5629——4107 INDIAN SCHOOL ROADSan Diego··CA92111GRP-3947-
CLMCLM-4305052026-04-06T10:44:50ZKEVIN—ANDREWS1982-03-06—null+1 916 417 1251NULL7867 OCEAN AVESan DiegoCA92114GRP-7885—
CLMCLM-4295182026-03-06T17:31:11ZJulia—Luna1971-02-15·-•••-••-0988—null··N/A—-GRP-9371CHOICE-PLUS-PPO
CLMCLM-4112672026-09-07T21:01:30ZOmar—Thomas1983-02-04UHC-30987-31UNKNOWNnull—3899 Union StEden PrairieMNnullGRP-8145·OPTIONS-PPO
CLMCLM-4221472026-03-18T18:08:29ZKEITHPJORDAN23-05-1998UHC-51305-30•••-••-0766UNKNOWN——-NULL··-GRP-3697-
CLMCLM-4295072026-10-15T13:15:58ZDOUGLAS—ALVARADO··2000-03-27UHC-27382-79•••-••-8384—N/A1453 Indian School Road Apt 2JACKSONVILLEFL32253GRP-3811—
CLMCLM-4251432026-04-26T11:00:08ZMichael····Jimenez··5/15/1996N/AUNKNOWN+1 820 894 9504—9534 Canyon RdGilbertAZ85298GRP-8364CHOICE-PLUS-PPO
CLMCLM-4153012026-01-14T13:04:45ZAmy—Lawrence2309-20-30··UHC-73297-66•••-••-2500NULL—2012 MOUNTAIN VIEW DRIVEDenverCO80247-0432GRP-6488··NULL
CLMCLM-4089702026-03-25T11:21:45ZEric—Ross10/25/1961UHC-96969-93•••-••-7243N/A—1312 Hillcrest Rd··HOUSTONTX77033GRP-1280NULL
CLMCLM-4280092026-03-30T19:11:13Z·Sophia—Johnston28-05-1970—•••-••-0388N/A·NULL—UNKNOWNUNKNOWN-GRP-3188SELECT-EPO
CLMCLM-4232792026-05-27T23:09:38ZJennifer—Aguuilar1942-11-23·UNKNOWN•••-••-24582219304712—3751 Forest AvenueLos AngelesCA90061GRP-7506—
CLMCLM-4256582026-03-02T09:37:55ZJen—Castro04/02/1950·UHC-02041-85•••-••-81857699394722jennifer.castro65@icloud.com1633 SAGE COURTJacksonvilleFL32287GRP-1653CHOICE-PLUS-PPO··
CLMCLM-4018962026-01-17T22:15:49ZRuth—Larson·1977-09-13NULLnull(751) 599-1851N/Anull·N/A-—GRP-0430OPTIONS-PPO
CLMCLM-4079192026-04-18T09:27:43ZDebra····Price19480726UHC-28103-90•••-••-1750(433) 308-5023null7061 Willow CourtHoustonTX77082GRP-2423SELECT-EPO
CLMCLM-4223582026-02-20T12:15:33Z·Bruce—Bradley2002-03-26UHC-60709-46—(201) 456-0359—2156 Ocean AvenueSan Diegoca92153N/AMEDICARE-ADV-B
CLMCLM-4162082026-01-05T17:55:34ZMaria—Meyer1957-11-25UHC7302552•••-••-8503+1 789 941 0388UNKNOWN7272 Mesa Drive·DallasTX75247GRP-9565SELECT-EPO
CLMCLM-4180222026-07-23T08:21:26ZJESSICA··GORDON19650914UHC-38164-21null—UNKNOWN7519 PINE DRSacramentoCA95810GRP-4546—
CLMCLM-4216022026-09-20T12:50:59ZSHIRLEYCGILBERT··1982-10-02-•••-••-79155247431763null8549 LAKE VIEW ROADMinneapolisMN55408—SELECT-EPO
CLM CLM-4077712026-05-18T13:19:23ZBrian—Wang1954-12-26·UHC-03998-29—UNKNOWNN/A2019 Valley View Drive #248Eden PrairieMN55356-8078-CHOICE-PLUS-PPO
CLMCLM-4197912026-05-28T06:37:35ZRONALDQFOWLER0201-04-05UHC-11532-40NULL8608026760ronald.fowler45@hotmail.com6612 Park PlSan Diegoca92110GRP-8572—
CLMCLM-4017462026-04-23T17:38:09ZRice, Bradlley——1983-03-12N/A•••-••-00542807381003nullN/A—nullNULLGRP-8433—
CLMCLM-4061532026-03-24T22:28:51ZJustin—Parker1994-05-17UHC-60302-08—-NULL—-N/AUNKNOWNnullCHOICE-PLUS-PPO
32,829 rows, page 95 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.770Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty