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-4156192026-10-14T06:35:10ZGREEN··D.THERESA1948-11-06UHC9772562—665-518-6500——UNKNOWNNULL-GRP-0897SELECT-EPO
CLMCLM-4102492026-02-14T13:03:00ZVirginia—Hayes10/14/43UHC-15953-18null—NULL—UNKNOWNNULL——·NAVIGATE-HMO
CLMCLM-4222392026-02-23T02:11:12Z RUTH—OLSON10/19/1960—•••-••-1713694-413-6596—8833 Sage CtSEATTLEWA98120NULLOPTIONS-PPO
CLMCLM-4070652026-06-29T12:50:39ZBrenda····Wells1997-08-04null•••-••-4167—NULL3625 Willow Court #221ScottsdaleAZ—GRP-7170SELECT-EPO
CLMCLM-4080402026-02-20T07:06:09Z JESSE—CLARK1997-05-22UHC-50171-70•••-••-7198-jesse.clark32@aol.comnull··null—nullGRP-0528—
CLMCLM-4089562026-04-08T08:46:26ZANDREA—CARROLL2007-19-88—•••-••-2034N/ANULL6828 OAK STSacramentoCA95878—CORE-HMO
CLMCLM-4013862026-03-03T12:28:03ZJEANM.BENNETT19880722·uhc-16157-76•••-••-8525—NULL—UNKNOWNN/AUNKNOWNGRP-8567NULL
CLMCLM-4171722026-03-31T02:18:43ZHarold—Simmons1948-07-21UHC-09892-81N/A921-867-4345null1157 Desert Sky Boulevard·GILBERTAZ85227-1237·GRP-9120··
CLMCLM-4153532026-05-03T16:37:47ZKen—Kennedy1997-07-03UHC-75623-35•••-••-3238NULL-2830 Valley View Drive··MinneapolisMN55413GRP-6252NULL
CLMCLM-4007712026-05-24T11:31:05ZAngela—Yang1970-01-18··—•••-••-8894+1 981 601 9278—7662 OAK STREETAustintx78702GRP-5036N/A
CLMCLM-4130322026-08-15T13:02:14ZBrittany—Lucas03/27/2000null•••-••-4458—N/A1258 PARK PLPlanoTexas75017GRP-2696UNKNOWN
CLMCLM-4174192026-03-02T13:38:17ZBRANDUN··SHAWNov 7, 1960NULL····N/Anull7007 OAK STREETDenverCO80237GRP-0327OPTIONS-PPO
CLMCLM-4123052026-04-28T04:29:49ZDavis, Sharon——1692-12-16—•••-••-0017+1 539 425 1076—·5576 HIGHLAND AVENUEFresnoCAN/AUNKNOWN-
CLMCLM-4020262026-07-11T20:59:52ZDENISE—JOHNSTON2008-03-09UHC-49425-51-··N/AN/A6538 PALM DRGilbertAZ85210GRP-8477SELECT-EPO
CLMCLM-4204482026-08-27T09:26:45ZPatrick—Boyd1977-05-24—·-N/A—7545 Mesa DriveMesa··AZ85230GRP-2893MEDICARE-ADV-A
CLM CLM-4234332026-08-30T10:47:06ZVALENTINA—FREEMANJan 26, 1967UHC-64211-41•••-••-850116844721103—5602 Harbor BoulevardLas VegasNV89139··NAVIGATE-HMO
CLMCLM-421009 2026-02-26T06:25:25ZMargaret—Dean2000-06-07UHC-39451-79NULL(514) 961-1106UNKNOWN2873 Maple AveTampaFL33674—·MEDICARE-ADV-B
CLMCLM-4091092026-07-12T11:09:45ZDonald—Wlaker2002-06-26UHC2325048NULL12969652931—6076 PALM DRIVETEMPEAZ-GRP-3131CORE-HMO
CLMCLM-4064412026-01-05T08:46:36ZPriya—Stone06/10/1946UHC-32131-64•••-••-2973(971) 223-0293N/A8768 Bayshore DriveEDEN PRAIRIEMN··55373GRP-2463UNKNOWN
CLMCLM-4120932026-02-09T17:50:15Z miller—billy··28-04-1959-•••-••-0985NULLnull3528 Baseline Road·ScottsdaleAZ85202GRP-4533·MEDICARE-ADV-A
CLMCLM-4083792026-01-15T20:01:23ZRalph—Graham27-01-1981NULL•••-••-0229(401) 440-9012UNKNOWN3792 Palm Drive Apt 22San DiegoCA92127GRP-8922—
CLMCLM-411624 2026-10-11T01:47:09ZGEORGE—DAY19630928N/A—4607260N/A6255 River RoadPHOENIX··AZ85095GRP-3990UNKNOWN
CLMCLM-4142372026-10-07T06:31:17ZLOIRIAUSTIN2003-07-23UHC-45897-76•••-••-7398nullUNKNOWN500 Camelback RoadSan DiegoCA·92121N/Anull
CLMCLM-4073022026-03-02T08:30:54ZBryan—Bradley1941-10-26UHC-11645-27•••-••-5277—BRYAN.BRADLEY51@YAHOO.COM8041 PARK PLFresnoCA93764GRP-7065NULL
CLMCLM-4273202026-05-31T16:36:59ZCHARLES—GONZALEZ20-07-1974UHC-02909-70··——559 Desert Sky BlvdMesa·AZ85295··GRP-9170SELECT-EPO··
CLMCLM-4042752026-08-24T03:00:35ZMedina, Andrea——08/16/87··—•••-••-1487·null—4090 CHURCH STTucsonAZ85757GRP-6311CORE-HMO
CLMCLM-4050772026-03-16T00:41:37ZLuis—·Ramos1965-11-22UHC-28626-89··•••-••-40277892327072UNKNOWN8960 Apache BoulevardMinneapolis·MN55436GRP-7447—
CLMCLM-4044222026-04-12T05:35:18ZGLORIA—ORTEGA2007-02-20UNKNOWN-NULL-··—UNKNOWNUNKNOWNGRP-5834—
CLMCLM-4253562026-01-18T11:53:38ZLuciaMGuerrero20050310UHC-27035-87UNKNOWNNULLlucia.guerrero54@yahoo.com4320 Maple AveSacramentoCA95806GRP-4995N/A
CLMCLM-4026032026-05-13T10:41:29ZOMAR—JENKINS2/18/1959UHC-84841-49UNKNOWN·N/A—-—NULLnull—NAVIGATE-HMO
CLMCLM-4250342026-03-09T11:29:37ZARJUN··—COLMAN1985-06-02UHC-09851-77•••-••-5363NULL—9309 Willow Ct··ScottsdaleAZ85233GRP-0946—
CLMCLM-400183 2026-07-03T05:20:30ZAnthonyURoss19920418NULL•••-••-6203(375) 800-2080-6561 Valley View DrivePLANOTX·75066—UNKNOWN
CLMCLM-418653 2026-09-01T11:02:58ZSchultz, Ronald——1972-12-11UHC-86558-91•••-••-6477UNKNOWNN/A··8492 Forest AveLos AngelesCA90046—NAVIGATE-HMO
CLMCLM-4273492026-07-01T07:21:48ZWillie··Chavez·2007-02-03UHC-34974-99nullN/AUNKNOWNUNKNOWN-NULL—GRP-0541NAVIGATE-HMO
CLMCLM-4131142026-09-30T06:18:13ZCarolG.Fowler1995-04-09··null•••-••-9801227.516.8933NULL7684 LINCOLN WAYSacramento·CA95821··GRP-7734·MEDICARE-ADV-A
CLMCLM-4250872026-02-03T21:03:46ZJoanZBennett1943-20-10N/A•••-••-76406647783668N/A6070 Union StSan DiegoCA92146GRP-3380—
CLMCLM-4320422026-04-12T04:55:48ZVirginia··—Carlson1993-03-18UHC-04926-88•••-••-7845N/A—4591 Valley View Dr Apt 18DallasTexas75241-8837··nullN/A
CLMCLM-4079272026-01-12T23:39:19ZJEREMY—REYES1973-02-03UHC-87372-54null5131662UNKNOWN5668 CHURCH STTempeAZ85276GRP-2281··
CLMCLM-4081372026-04-19T22:45:13ZJOSEPH—SCOTT1975-08-21UNKNOWN•••-••-7139(427) 689-1203joseph.scott10@aol.com7502 Desert Sky BoulevardAustinTX78761GRP-1972null
CLMCLM-4153962026-06-04T09:08:55ZKATHYNWATKINS5/26/1972UHC-19886-37NULL18113903013-630 DESERT SKY BOULEVARDCharlotteNC28297-2727GRP-5006OPTIONS-PPO
CLMCLM-4048822026-09-26T13:08:03ZKayla—Williamson07/14/2008null•••-••-1974+1 443 244 6373———UNKNOWNUNKNOWNGRP-0637CHOICE-PLUS-PPO
CLMCLM-4186652026-05-25T03:57:43ZGary—Brown1950-01-24UHC-63458-01•••-••-5967(458) 847-6731gary.brown@gmail.com5247 Jefferson AvenueTucsonArizona··85789—null
CLMCLM-4259852026-10-11T08:12:51ZMichelle—JimenezSep 17, 1994——(656) 389-8913null5351 HILLCREST ROADScottsdaleAZ85255—NAVIGATE-HMO
CLM CLM-4304082026-05-05T00:06:06ZLUCIA—CAMPBELL·1990-05-09UHC-20371-54null-—8774 Maple AveFresnoCA93723··GRP-0849CHOICE-PLUS-PPO
CLMCLM-4048752026-07-24T22:18:07ZJerry—Hawkins—UHC-79567-63•••-••-45769046466195-——--GRP-6335NULL
CLMCLM-4225722026-03-13T13:44:12ZCARL—BURNS08-04-1967UHC-58968-04NULL5543241443UNKNOWN8720 Highland AvenueGlendaleAZ85393null—
CLMCLM-4159842026-02-23T09:01:15ZYuki··Porter1995-02-05-—-—8028 Mesa DrFresnoCA93749··GRP-3009CORE-HMO
CLMCLM-4151462026-01-08T16:20:00Z·CAROL—RAMIREZ23-09-1944-—UNKNOWN—1707 Maple AveMINNEAPOLISMN55464GRP-8170NULL
CLMCLM-4123072026-09-15T07:32:03ZIsabella—Black·09/02/88·NULL•••-••-7548868-657-4633—521 Spring StreetSan DiegoCA92104GRP-9725SELECT-EPO
CLMCLM-4236112026-01-27T06:57:28ZMEI—CARTERJun 24, 1992UHC-88572-18NULL467-259-4055NULLUNKNOWN—UNKNOWNnullGRP-3826NULL
32,829 rows, page 16 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.777Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty