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-4099982026-10-17T06:38:46ZPAMELA—·HICKS·09/04/90N/A-(233) 690-0495NULL6514 MOUNTAIN VIEW DRPlanoTX75056-4181GRP-9479-
CLMCLM-4105822026-07-31T13:32:45ZWALTERS.GRIFFIN26-02-1960UNKNOWNN/AUNKNOWN—6093 Hillcrest RoadCOLUMBUSOH43295GRP-2295-
CLMCLM-4265122026-05-18T22:37:40ZBRIAN—CARPENTER09/10/1975UHC-74079-84•••-••-06955332447——nullN/A·UNKNOWNGRP-9712—
CLMCLM-4111262026-02-18T16:04:03ZEthan—GriffinOct 13, 1999UHC-23197-88—303.357.4813-8239 Willow CtMinneapolisMN55423GRP-3887UNKNOWN
CLMCLM-4062892026-09-05T08:53:05ZJUDY—ALEXANDER1990-09-12—•••-••-9682null-6007 GRAND AVENUEDallasTX75261GRP-8030SELECT-EPO
CLMCLM-4067452026-02-05T07:06:28ZPatricia—Mendez20040701-•••-••-9713——7575 Union St··Minneapolis··MN55404GRP-3407MEDICARE-ADV-A
CLMCLM-4013092026-05-28T00:59:51ZSara······Hall1958-06-02··UHC-08168-65•••-••-8162N/AUNKNOWN7589 DESERT SKY BLVDTEMPEAZ85276GRP-8457CORE-HMO
CLMCLM-4207372026-03-19T21:57:30ZRebecca—Henry—UHC-09021-94NULL9670897-8916 Spring StreetLOS ANGELESCA90017··GRP-0626MEDICARE-ADV-B··
CLMCLM-4106132026-10-04T21:02:54ZMei—Weber2005-05-07UHC-36230-97•••-••-1616(526) 349-1293mei.weber@yahoo.com3077 Jefferson AveSan AntonioTX78217—null
CLMCLM-4281332026-08-09T09:12:11ZJack—Wheeler·3/14/1946-•••-••-40562299443579····1276 CENTRAL AVETempeAZ85227GRP-3229NULL
CLM CLM-4153042026-07-28T11:54:39ZAmy—·Lawrence9/23/2003—N/AN/A··null··2012 MOUNTAIN VIEW DRIVEDenverColorado80247GRP-6488UNKNOWN
CLM CLM-4225662026-03-03T21:28:35ZRyan—Harrison16-11-1958·UHC-72506-79•••-••-43235703612668—2325 Washington StreetAtlantaGA30353GRP-3110MEDICARE-ADV-B
CLMCLM-4084462026-06-15T08:58:19ZALICE—HOWARD05/11/1990UNKNOWN—2779082283N/A8259 Grand AvenueFresnoCA93726N/ASELECT-EPO
CLMCLM-4007692026-04-13T14:30:00ZSaraKPhillips2002-08-13uhc-60451-51•••-••-4472971-999-3287N/A5025 Desert Sky Blvd #533ORLANDOFL32803—SELECT-EPO··
CLMCLM-4149792026-02-23T03:27:50ZDIEGOMFOX·2002-12-07—•••-••-0403N/A-—-NULLUNKNOWNGRP-9919SELECT-EPO
CLMCLM-4288512026-04-12T04:53:46ZNancy—Soto19660702—N/A(671) 373-2691N/A4811 WASHINGTON STNASHVILLETN37257NULLN/A
CLMCLM-4074172026-06-07T09:35:29ZRachel—Munoz03/17/04UHC1593704—8985084666null7646 BAYSHORE DRIVEEden Prairiemn55307GRP-5816-
CLMCLM-4047632026-06-13T05:16:49ZROBERTB.PERKINS1968-11-24UHC-38217-24-UNKNOWN—7520 Ocean AvenueJacksonvilleFL32240GRP-3467N/A
CLMCLM-4260592026-03-27T03:27:40ZCarol—Arnold1994-11-22·uhc-29564-55—+1 431 775 1242—8501 Central AvenueMinneapolisMN55461GRP-8487N/A
CLMCLM-4232702026-04-30T07:24:53ZBRITTANYO.SANDOVAL·1970-02-25UHC-22787-33··•••-••-37479126413441··—9784 Jefferson AvenueCharlotteNC28253-1603GRP-0624—
CLMCLM-4285362026-04-07T16:19:49Zvictoria—coleman1979-06-14UHC4837466•••-••-5615N/A··7682 VALLEY VIEW DRScottsdale··AZ85292UNKNOWNnull
CLMCLM-4271432026-07-30T21:35:58ZMargaret—Foster1950-06-28UHC-01099-35—N/A—9550 Highland AvenuePhoenix·AZ85045—MEDICARE-ADV-A
CLMCLM-4213162026-08-11T16:13:46ZABIGAIL—SOTO1975-12-20—•••-••-4347453-303-0412N/A——UNKNOWN··—GRP-5127options-ppo
CLMCLM-4221902026-06-04T16:47:09Ztimothy—harris19600808UHC-02413-69•••-••-4461—-1631 Lincoln WayLos Angelesca90003UNKNOWNNAVIGATE-HMO
CLMCLM-4191662026-07-21T09:56:27ZAlbert—Carr1966-02-09UHC-81559-93—·NULL—·-NULLN/A··nullNULLOPTIONS-PPO
CLMCLM-4075242026-07-09T06:08:06ZKELLY—NUNEZ1969-07-08UHC-71535-19N/A—NULL2972 WASHINGTON STREETPHOENIXAZ85025GRP-2423OPTIONS-PPO
CLMCLM-4312152026-04-05T22:22:10ZSophia—Daniels5/6/1983——UNKNOWNNULL9788 JEFFERSON AVEDenverColorado80275-6118GRP-3411OPTIONS-PPO
CLMCLM-4015222026-04-12T08:21:13ZDenise··Peters1980-10-22null··•••-••-1272+1 841 469 4491—·9572 MESA DRIVESan AntonioTexas78291N/AMEDICARE-ADV-A··
CLMCLM-4172932026-09-17T23:31:44ZDEBRAC.MATTHEWSOct 28, 1973UNKNOWNNULL··—UNKNOWN3697 LAKE VIEW ROADCHANDLERAZ85267GRP-9695choice-plus-ppo
CLMCLM-4088612026-10-02T23:40:20ZCheryl—Wallace2008-11-01UHC7578168····UNKNOWNUNKNOWN7965 Camelback RoadEden PrairieMN55323GRP-5560CHOICE-PLUS-PPO
CLMCLM-4112132026-08-18T00:59:42ZTorres, StephanieZ···2006-11-14UHC-99975-09NULL-······3934 FOREST AVENUEMESAAZ85295NULLNULL
CLMCLM-4004262026-08-16T21:38:51ZChen, Jacqueline——08/07/97UHC-37309-92null··UNKNOWN—5143 Grand AvenueLos AngelesCA—GRP-4377SELECT-EPO
CLMCLM-4246562026-01-19T08:15:45ZFrank—Washington07/08/78UHC-91228-72-··N/A—-N/A——GRP-5992—
CLMCLM-4197812026-10-08T09:07:59ZChris—Meyer2004-02-28——517-883-8557—8041 Main StreetNashvilleTN37251··——
CLMCLM-4317322026-08-06T05:06:50Z·YUKI—WILLIAMSON2000-30-19UHC-67835-34··2598489270—4914 Sage CourtJacksonvilleFL32270GRP-5116NAVIGATE-HMO
CLMCLM-4128242026-05-20T03:44:16ZGeorge—Padilla2002-10-05N/A•••-••-0407—-7600 Valley View DriveCharlotteNC28274GRP-9813MEDICARE-ADV-B
CLMCLM-4208712026-04-27T05:58:27ZDONNA····COK1978-02-12—•••-••-3433879-870-8298—6772 Desert Sky BoulevardNashvilleTN37276GRP-4591—
CLMCLM-4230392026-06-14T03:49:25ZChristina—Andrews1967-08-12N/A•••-••-79253806597145UNKNOWN6878 Pine DriveOrlandoFL32832··GRP-5600SELECT-EPO
CLMCLM-4175912026-05-27T12:53:31ZDylan—Meyer··1984-05-05UHC-95805-53•••-••-39489836406382—6395 Park Place·ScottsdaleAZ85238—null
CLMCLM-4245962026-03-16T00:29:24ZJerry—Thomas1975-09-28UHC-77632-15N/A——8244 Washington StreetSacramentoCA95889GRP-6534SELECT-EPO
CLMCLM-4297492026-06-19T16:37:15ZBradley·····Santiago1976-02-23UHC-26632-77N/A927-924-6403N/A9398 Spring StreetFRESNOCA93776NULL—
CLMCLM-4086212026-06-25T02:16:02ZKYLE—VEGA1943-01-08-NULLUNKNOWN—7308 Harbor BoulevardMiamifl··33134GRP-0751CHOICE-PLUS-PPO
CLMCLM-4011782026-10-12T23:38:29ZGomez, Mark——9/20/1962··UNKNOWNNULL(484) 905-6405MARK.GOMEZ12@GMAIL.COM5250 Indian School RoadEden PrairieMN55378GRP-7904MEDICARE-ADV-A
CLMCLM-4012142026-01-10T11:03:33ZCARL—MORRISON1989-06-26——665-449-1872carl.morrison45@gmail.com3084 River RdDenverCO80236GRP-7832NAVIGATE-HMO
CLMCLM-4124682026-08-15T03:57:42ZMATT—ARNOLD·8/7/1944UHC-10919-83N/A6837939NULL-—UNKNOWNNULL-SELECT-EPO
CLMCLM-4117902026-02-25T05:23:37ZSAMV.ROMERRO08/07/1976UHC-70881-28——·NULL909 LINCOLN WAY #740Minneapolismn55447nullnull
CLMCLM-4278582026-09-29T08:16:34ZBradley—Hernandez1998-05-27··UNKNOWN—nullNULL2161 WASHINGTON STREETSacramentoCalifornia95872GRP-9596—
CLMCLM-4065962026-09-13T18:10:17Z Lewis, Hiroshi——·09/13/54-—N/AN/A3962 Main StScottsdaleAZNULL—N/A
CLMCLM-4014682026-01-01T12:46:23ZJerry—Pierce2/27/2005·UHC0182746•••-••-5762(275) 373-5096-3308 Baseline Rd #173PhoenixAZ85020GRP-3862MEDICARE-ADV-B
CLMCLM-4195752026-09-17T16:23:09Z DYLAN—ROBINSON15-07-2007UHC-25806-40null——3396 Maple AveOrlando·FL32819-3137GRP-0634MEDICARE-ADV-A
32,829 rows, page 68 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.723Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty