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
CLM CLM-4028512026-01-08T17:50:21ZChapman, Olivia——1975-01-18N/A•••-••-356016167377091NULL9683 Market StreetEden PrairieMN55397GRP-0269NULL
CLMCLM-4026332026-02-22T05:00:39ZBryan—Yang1961-08-06UHC-24123-48•••-••-9474——N/AUNKNOWN—nullGRP-7362—
CLMCLM-4319412026-04-25T09:01:29ZDIEGO—DOMINUEZ1985-01-01——(666) 723-2138diego.dominguez@outlook.com····-··—UNKNOWN-OPTIONS-PPO
CLMCLM-4212952026-08-19T10:54:01ZHARROLD—ESPINOZA1984-09-28UHC-90072-37•••-••-1051NULL—3889 CANYON RDGlendaleAZ85302-2147GRP-0792N/A
CLMCLM-4102352026-04-13T13:51:10ZJANICE··LOPEZ5/11/1947UHC-64105-04N/A+1 788 316 3428UNKNOWN2564 Lincoln WaySan AntonioTexas78293GRP-2251null··
CLMCLM-4293732026-05-13T09:47:50ZJennifer—Parker19771109UHC-33407-88•••-••-2403494.659.4255NULL241 Forest AvenueAustinTX78716—null
CLMCLM-4306622026-09-15T13:47:05ZCARLARIOS1990-02-14UHC-55056-63N/A-—UNKNOWN—--GRP-5557N/A
CLMCLM-4009042026-09-01T19:55:00Zalexander—watkinsNov 20, 1942UHC-52797-12-—ALEXANDER.WATKINS@OUTLOOK.COMNULL—nullnullGRP-1643CORE-HMO
CLM CLM-4210422026-01-02T19:55:14ZDOROTHY—ALVAREZ··Nov 6, 1990·UHC-40595-14null8043562146····9758 Oak StTampaFL33657GRP-8775MEDICARE-ADV-A
CLMCLM-4296812026-08-02T04:12:29ZCheryl—Howell1987-07-07—null9025578865··null—nullNULLUNKNOWNGRP-2402NULL
CLMCLM-4202432026-07-23T23:53:15ZEMMA—PENA·12/15/2007uhc-89588-48•••-••-22942135477737··—1716 Sunset BlvdAustinTX·78701nullCORE-HMO
CLMCLM-4128842026-07-08T11:47:01ZcynthiaValvarez1976-06-12····N/ANULLUNKNOWN··5389 Palm Dr··ColumbusOH43224GRP-3342··CORE-HMO
CLMCLM-4236342026-10-09T01:04:39ZFranklin, CarolM—·1938-04-22UHC-98866-30N/AN/A—8103 UNION STTempeaz85292-NAVIGATE-HMO
CLM CLM-4320402026-10-05T04:20:01ZBrittany—Shaw·1961-00-84UHC4313016•••-••-0615507-617-0562N/A6327 RIDGE RDDenver·Colorado80299GRP-7431MEDICARE-ADV-B
CLM CLM-4020362026-08-25T02:44:46ZChavze, Thomas——21-01-1958UHC-08205-93-N/ANULL6626 Market StMiamiFL33199GRP-3762UNKNOWN
CLMCLM-4110582026-05-31T10:01:04ZDORISE.YANG1968-12-03UHC0936979UNKNOWN2282448221—3736 Pine DrPHOENIXAZ85014GRP-0195MEDICARE-ADV-A
CLMCLM-4296262026-08-26T11:05:00ZARTHUR—DEAN2/4/1960UHC-82188-54NULL—UNKNOWN····-nullUNKNOWNN/AUNKNOWN
CLMCLM-4059082026-02-20T13:26:54ZSteven—Salazar1950-05-26UNKNOWNnull(438) 585-2568—694 BAYSHORE DRFresnoCA93798GRP-7140-
CLMCLM-4297482026-07-12T13:41:28ZBradley—Santiago02/23/1976UHC-26632-77—UNKNOWN··null7766 RIDGE ROADSan Antonio··TX78231GRP-0916MEDICARE-ADV-A
CLMCLM-4323242026-01-10T12:09:11Z Tyler—Daniels1980-04-06uhc-58970-27-—-1390 HILLCREST RD·LAS VEGASNV··89104··GRP-7770SELECT-EPO
CLMCLM-4103072026-05-02T12:58:09ZHelen··—Phillips1969-10-04UNKNOWN•••-••-114415747149073null1268 Church StScottsdaleAZ85207GRP-1432—
CLMCLM-4186982026-03-29T11:23:25ZGeorgeE.Shew1984-10-20UHC-36004-77-(799) 653-9568null6572 Bayshore DrTucsonAZ85780GRP-8580SELECT-EPO
CLM CLM-4066752026-05-13T06:19:04ZWILIAM—·VASQUEZ1939-01-24N/AUNKNOWN··—3942 Union StMinneapolisMN55411null—
CLMCLM-4171442026-03-10T12:26:59ZANNA—BURKE1938-07-28NULL•••-••-9831N/A—6502 Mesa DriveDallasTX75203·-MEDICARE-ADV-A
CLMCLM-4005672026-04-28T19:06:02ZVirginia—Hill1962-09-15UHC-08541-98··nullnull·5020 Ridge RoadTampaFL33666—NAVIGATE-HMO
CLMCLM-4084242026-10-14T02:55:26ZJulia··ACastillo—null•••-••-3013513.566.4821—6225 Bayshore Dr··Eden PrairieMN55382GRP-4003SELECT-EPO
CLMCLM-4056202026-05-13T09:20:15ZJessica—Taylor1951-02-22UHC-33596-12•••-••-1156344.890.0471·null2381 Lincoln Way #287NashvilleTNNULL·GRP-1811··
CLMCLM-4158792026-05-11T18:45:41Z·BETTY—HRAT04/17/93UHC-32493-85—8180225null··4852 Union StCharlotteNC··28229·N/AN/A
CLMCLM-4088062026-08-14T18:33:11ZJOAN—ORTEGA1958-03-20··UHC-14047-49•••-••-0335NULL—6390 Ocean AvenueJacksonville·FL32210GRP-8860CHOICE-PLUS-PPO
CLMCLM-4069202026-02-07T13:04:47ZRobert··—Romero11/18/86··UHC-84309-91N/A289.243.6915-4570 Baseline RoadTucsonAZ85780GRP-6258SELECT-EPO
CLMCLM-4016602026-07-06T06:04:27Zchristina—sandoval·1983-12-28UHC-51663-15-UNKNOWN—·257 MEADOW LANEFresnoCA93762NULL··MEDICARE-ADV-B
CLMCLM-4172192026-10-06T07:20:38ZJacqueline—James1991-03-25UHC-45653-48UNKNOWN621-951-1568·UNKNOWN—N/Anull—N/AN/A
CLMCLM-4209212026-03-04T00:17:11ZDeniseJLucas1997-06-10UHC-21721-41·--N/A··1042 SUNSET BOULEVARDTampaFL—GRP-6446NULL
CLM CLM-4072662026-07-12T03:31:30ZGeorge, JuliaD—1959-01-27UNKNOWNN/A(469) 498-1212-2430 VALLEY VIEW DRCharlotteNCNULLGRP-6506··UNKNOWN
CLMCLM-4082872026-01-15T07:26:33ZJanice··—Stone1974-07-18UHC-82115-89UNKNOWNN/AUNKNOWN6480 Ocean Avenue··ChandlerAZ85290GRP-7510OPTIONS-PPO
CLMCLM-4178862026-05-04T07:58:05Z MEI—GEORGE19431207UHC-37000-03•••-••-5354(611) 331-9020-6041 Lincoln WayMiamiFL33159GRP-2076CORE-HMO
CLMCLM-4049442026-10-10T07:19:46ZRussell—MoralesFeb 22, 1969UHC-05073-10null+1 254 322 8009—4402 Desert Sky BoulevardTucsonaz85744GRP-2270UNKNOWN
CLMCLM-4143962026-02-07T03:51:42Zsantiago—miller··1969-04-28null•••-••-51133279644892-3679 Meadow LaneMesaaz85216GRP-3924—
CLMCLM-4042722026-05-07T12:30:06ZGary—Welch1940-12-20UHC-29174-76•••-••-5313—UNKNOWN1042 Church StreetTampaFL33621-3727-NULL
CLMCLM-431140 2026-05-27T21:19:39Z·Franklin, Roger———NULL•••-••-3618—-—UNKNOWN-null··NAVIGATE-HMO
CLMCLM-4201552026-06-04T13:18:49ZTheresa—Tucker1972-03-03UHC-63388-86•••-••-0148—UNKNOWN884 Maple AvenueSAN DIEGOCA92197UNKNOWNMEDICARE-ADV-B
CLMCLM-409456 2026-09-02T22:19:52ZMARK—KELLEY08/22/88UHC-28980-76•••-••-8372N/AN/A2938 Spring StMiamiFL33105··GRP-4030CHOICE-PLUS-PPO
CLMCLM-4110252026-09-05T03:00:24ZAndrews, Sara——11/2/1961UHC-45537-10—6398433N/ANULL—N/AN/AnullN/A
CLMCLM-4040602026-01-10T07:28:16Z·LAUREN—WONG1955-10-13null-5612442592-7046 Lincoln WayEden Prairie·MN55329GRP-5710CORE-HMO
CLMCLM-4004752026-03-15T19:56:26ZrobertQwelch1985-02-09-UNKNOWN463-689-2094-NULLNULLUNKNOWNN/AGRP-0247null
CLMCLM-4324462026-03-07T18:24:44ZKEVIN E.—MILLER1950-07-07UHC-85557-90null6526712237—nullnull-NULLGRP-7595NAVIGATE-HMO
CLMCLM-4084422026-10-09T23:05:48ZLarryF·Willis1967-01-25——6269209877··-427 Maple AveSeattleWA98126nullMEDICARE-ADV-B
CLMCLM-4233752026-02-07T04:46:10ZericFtaylor3/16/1965··UHC-85425-75•••-••-0644-NULLN/A—UNKNOWNNULL——
CLMCLM-4204372026-06-20T16:24:30ZEllis, Ronald——2007-01-06—•••-••-4100UNKNOWNRONALD.ELLIS@GMAIL.COM1443 APACHE BLVDDENVERCO80260-3245GRP-7923N/A
CLMCLM-4261542026-09-12T13:29:29ZTyler··DWebb1969-11-25UHC-69644-36—582.724.3067··9487 RIVER RDMESAAZ85212GRP-3296CORE-HMO
32,829 rows, page 25 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.794Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty