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-4319042026-04-21T06:59:50ZMarilyn—Bradley09/13/66UHC-97072-12N/Anull··—901 FOREST AVENUESeattleWA98166GRP-3140UNKNOWN
CLMCLM-4232212026-05-10T05:58:52ZRachel··Coleman1971-12-27UHC-90276-54--··null-——-GRP-2465N/A
CLMCLM-4069792026-06-16T16:58:45ZRalph····Howell1978-12-28UHC-98002-75UNKNOWN389.995.8949UNKNOWN6338 Mountain View DriveLos AngelesCA90030··-—
CLMCLM-4189812026-04-30T07:38:51Z·MarkI.Hoffman1993-10-18N/A—(372) 376-3077—7240 UNION STREETNashvilleTN37228-—
CLMCLM-4006702026-06-28T05:48:43Zmelissa—palmer1949-04-01null•••-••-3693(282) 969-1073—1984 Washington StreetTampaFL33614—-
CLM CLM-4248992026-08-25T19:52:01ZDiego—Freeeman12/28/71UHC-98952-98——diego.freeman41@gmail.com3303 OCEAN AVENUEGlendaleAZ····GRP-8290OPTIONS-PPO
CLMCLM-4099472026-09-07T22:42:42ZMASON—MCDONALD08/20/03··UHC-59502-09··-null2210 CEDAR LNATLANTAGA30379GRP-6591CHOICE-PLUS-PPO
CLMCLM-4276672026-05-12T10:51:02ZDavis, Stephen——1963-12-19UHC1036758-UNKNOWN··stephen.davis@yahoo.com4730 Washington StreetLas VegasNevada89174GRP-6187·N/A
CLMCLM-4058762026-10-17T21:45:25ZDeborah—Ramos05/03/96UHC1345214•••-••-25196499736227UNKNOWN2747 BASELINE RDLOS ANGELESCA90008-1147NULLselect-epo
CLMCLM-4304652026-07-18T18:53:19ZJoyceGSanders1972-01-18····•••-••-5241—N/A566 UNION STREETLas VegasNV89177··GRP-0932—
CLMCLM-4055432026-06-27T12:44:44Zwilliam····rose12/13/1961UHC-42141-56····895.310.2756NULL4362 Ocean AvenueFRESNOCA93762GRP-9683CORE-HMO
CLMCLM-4016612026-01-27T22:18:52ZCHRISTINA—SANDOVAL19831228—•••-••-3925+1 671 380 7910-257 Meadow LaneFresnoCA93762-5095GRP-0237MEDICARE-ADV-B
CLMCLM-4006682026-01-15T23:49:50ZAshley—·Jones1969-09-11UHC-95558-79•••-••-8580UNKNOWN—1608 Desert Sky BoulevardTucson··Arizona85744nullOPTIONS-PPO
CLMCLM-4227232026-05-29T15:58:17Z·Terry—West19821125··—17538299365—4900 Church StLos AngelesCA··90086-2284—MEDICARE-ADV-B
CLMCLM-4248512026-03-07T19:30:47ZOlivia······Nunez1941-10-20UHC-17412-39—7642945244NULL—-nullUNKNOWNGRP-9090OPTIONS-PPO
CLMCLM-4007762026-09-05T22:03:09ZMelissaJ.Alexander1944-12-03—•••-••-8026(333) 250-5168UNKNOWN8745 Ocean AvenueCharlotteNorth Carolina·28210GRP-2708NAVIGATE-HMO
CLMCLM-4152152026-06-20T12:43:28ZArmstrong, Jerry——1940-04-10UHC-40480-51•••-••-8098N/ANULLUNKNOWNNULL-UNKNOWNGRP-4322—
CLMCLM-4237152026-06-30T06:07:56ZSteven—Carroll1948-01-03——UNKNOWN-7881 Highland AvenueHoustonTX77080UNKNOWNNAVIGATE-HMO
CLMCLM-4037592026-01-18T15:04:53ZJonathan—Valdez1938-07-06UHC-09612-40UNKNOWN4458108877NULL1279 BAYSHORE DRIVENashvilleTennessee37286N/A·NAVIGATE-HMO
CLMCLM-4059612026-09-09T05:41:35ZJudy··—Wells1938-01-11UHC-84471-03•••-••-6438—NULL9036 VALLEY VIEW DRIVETempeArizona85211GRP-7168NAVIGATE-HMO
CLMCLM-4247852026-05-18T01:11:10ZKellyBWillis1971-12-19NULL———8540 Sage CtLOS ANGELESCA90029GRP-7826SELECT-EPO
CLMCLM-4065092026-09-23T05:28:25ZKaylaS.Henry··1969-11-11—•••-••-2236729.834.8501—5247 Spring StColumbusOH43222--
CLMCLM-4029832026-01-19T18:31:45ZWard, Carolyn——03/16/2004UHC-59025-32····——9472 Desert Sky BlvdChandlerAZ85298NULL··UNKNOWN
CLMCLM-4326442026-05-10T05:23:44ZHiroshiP.Peterson1947-08-28UHC-47694-32—(374) 386-3817NULL6875 Apache BlvdGilbertAZ··85234-7129GRP-3311UNKNOWN
CLMCLM-4124812026-03-18T06:57:07ZLaura—Watkins19950708UHC-10917-24N/A2267314736—9483 Elm StreetTucsonAZ85710GRP-3141N/A
CLMCLM-4097892026-05-14T06:54:32ZHannah—Lewis2002-06-28——+1 891 806 7254—236 Church Street #728DenverCO80227GRP-4426SELECT-EPO
CLMCLM-4300342026-08-14T11:40:38ZOLIVIAS.JACKSON·1939-08-05UHC-00850-94··•••-••-6840NULLUNKNOWN8395 Highland AvenueDallasTX75286GRP-4477····
CLMCLM-4112502026-03-14T02:24:09ZLuis—Watsno2007-09-15N/A·UNKNOWN(588) 601-3478null265 Spring StreetLos AngelesCAN/A—CHOICE-PLUS-PPO
CLMCLM-4325452026-09-10T02:50:51ZJdy—Wells6/18/1989·null•••-••-9859—null5771 INDIAN SCHOOL ROADSCOTTSDALEArizonaUNKNOWNN/Achoice-plus-ppo
CLMCLM-4281762026-09-09T04:24:48ZGreg····Rosse1940-80-26UHC-54198-54•••-••-9639NULLNULL—null··N/AGRP-2983CHOICE-PLUS-PPO
CLMCLM-4054192026-05-26T12:04:40Zroger—carroll1972-03-04UHC-21603-47—361-352-3313ROGER.CARROLL@AOL.COM8894 Pine DrPlanoTX75047null—
CLMCLM-4246592026-04-28T14:53:50ZJoyce··Sanchez1966-10-24——507-907-1539NULL2620 Market StLas Vegas··NV89104GRP-1779CORE-HMO
CLMCLM-4072622026-09-07T11:00:29Z AIBGAIL··STONE··20081207UHC-76973-20—N/AUNKNOWN-——····GRP-9208CHOICE-PLUS-PPO
CLMCLM-4268152026-04-14T02:46:06Z Watson, Keith——19910208UHC-99757-95UNKNOWN—NULLnull-NULL—GRP-3210-
CLM CLM-4050642026-10-09T21:16:58ZAUSTIN—BERRYApr 7, 2007UHC-63286-32N/A5375701799NULL9431 Central Ave·Eden PrairieMN55329GRP-3471OPTIONS-PPO
CLMCLM-4090892026-05-23T03:16:47ZEspinoza, Jose——08/14/1996UHC-99113-02N/A7514200056-8225 Market StSeattleWA98129NULLSELECT-EPO
CLMCLM-4247282026-08-23T16:33:27ZDnielleCBerry1956-04-17UHC-59273-12—·nullnull4271 Canyon RoadTempeAZ·85273GRP-7750CORE-HMO
CLMCLM-4291332026-01-26T08:07:53ZJuan, Murray——1960-12-26UHC-76789-10•••-••-5422-JUAN.MURRAY@ICLOUD.COM9062 PARK PLACEGilbertArizona85263··N/AOPTIONS-PPO
CLMCLM-4151652026-03-06T14:27:01ZDaniel—Hunteer1990-12-19UHC-08541-87•••-••-6612·17019672836N/Anull—N/A—GRP-3261OPTIONS-PPO
CLMCLM-4152882026-01-26T07:53:40Z·albertSknight1994-08-07UHC-52355-58——null·6424 Mesa Dr Apt 10TEMPEAZ—GRP-7233CHOICE-PLUS-PPO
CLMCLM-4254202026-08-02T03:52:54ZPatrick—Gilbert··1986-05-26UHC-38235-14-17817051727NULL9878 INDIAN SCHOOL RDAtlantaGeorgia30300GRP-9428CHOICE-PLUS-PPO
CLMCLM-4323342026-03-26T04:46:34ZLARRY—FIELDS1966-04-23null—·(644) 856-6042null7205 BroadwayMiamiFL33100GRP-2554-
CLMCLM-4168892026-04-09T11:14:19ZHUGHES—JERRY1983-05-26UHC-35049-87•••-••-5123N/A—1707 Hillcrest RoadSeattleWA98147null··-
CLMCLM-4180412026-08-14T22:12:14Z MADIOSNASALAZAR1984-11-24N/A-714-650-5589-··-———GRP-8965-
CLMCLM-4260292026-04-06T08:18:01Z·debra—jimenez5/16/1996UHC-59536-77··•••-••-40307399225717N/A8170 Maple AvenueGilbertAZ85208GRP-9853NULL
CLMCLM-4130392026-03-26T03:34:50ZRachel—Black1956-03-05N/A—-UNKNOWN··UNKNOWN——UNKNOWNMEDICARE-ADV-A
CLMCLM-4291322026-08-27T12:26:32ZMAY—MALDONADOMay 10, 1962nullN/AN/A··NULL2125 Willow CtNashvilleTN37207GRP-0184N/A
CLMCLM-4168212026-10-17T08:01:21Znancy··—hansen1975-80-24-—(587) 405-2485—8671 Harbor BlvdCharlotteNC28282GRP-7847SELECT-EPO
CLMCLM-4040032026-05-29T16:28:16Z Justin—Knight19980203UHC-81943-51•••-••-4726——8250 WILLOW COURTFresnoCA··93774NULL-
CLMCLM-4310052026-04-15T04:08:07ZDouglas—Smith1939-02-21UHC-05345-58——-··6704 Valley View Dr··SeattleWA98166—MEDICARE-ADV-A
32,829 rows, page 209 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:43.432Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty