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-4175282026-09-07T18:30:35ZAilce—GriffinFeb 1, 1973UHC-73266-95NULL4854263168UNKNOWN··393 PARK PLDENVERCOUNKNOWNnull-
CLMCLM-4147822026-02-22T08:15:34Z·Abigail—Schultz12/14/2005·UHC-61086-64•••-••-4101·UNKNOWNnull2337 RIVER ROAD Apt 27Chandler··AZ85232GRP-7736CHOICE-PLUS-PPO
CLMCLM-4303912026-03-03T01:14:50Zkeith··kennedy04/08/2007——-UNKNOWN8920 Palm DriveHouston·TX77003GRP-6607-
CLMCLM-4231032026-05-04T02:46:56Z KENNETH—RIOS1940-03-10UHC-43039-54null8148105963NULL1594 WASHINGTON STMESAAZ85226GRP-7933CHOICE-PLUS-PPO
CLMCLM-4236442026-06-15T16:33:10Z Daniel—Lawrence12-09-1953UHC-08974-21-null··null6349 Church StAtlantaGA30377—choice-plus-ppo
CLMCLM-4089932026-01-29T21:57:40Zkathleeen··clark1999-06-28UHC-53597-08•••-••-7592UNKNOWN—7249 SPRING STLAS VEGASNV89186GRP-4420CHOICE-PLUS-PPO
CLMCLM-4241582026-08-20T21:52:55ZDanielle—Herrera1948-03-21UHC-14995-82•••-••-8860N/ANULL3140 Lincoln WayDenverCO80238GRP-3533—
CLMCLM-4073352026-09-27T08:10:24ZVIRGINIA—WEBERN/AUHC-10635-06····—·-—-nullnullGRP-2307OPTIONS-PPO
CLM CLM-4072372026-07-17T07:26:26ZJASON—RYAN10-06-1993N/A—NULL—1933 Lake View Rd·GILBERTAZ85207—-
CLMCLM-4081412026-07-03T05:43:26ZEdwards, Elizabeth——2004-12-03UHC-73277-83NULL3411644—2881 Bayshore Dr Apt 6PhoenixAZ85007GRP-2758—
CLM CLM-4244812026-01-02T15:35:20ZDONALD—GRAYAug 23, 1950UHC-42611-30-(338) 657-7713—1411 MOUNTAIN VIEW DRIVEGlendaleAZ85384—-
CLMCLM-4305872026-05-28T06:23:57ZAhmed—Ford1982-09-17null—7536705··nullUNKNOWNUNKNOWN-NULLGRP-2211N/A
CLMCLM-4197932026-05-08T10:12:24ZLarryCMcCoy2005-05-04·UHC2749772—N/A-9155 Indian School RdMIAMIFL··33149-N/A
CLMCLM-4080032026-01-14T11:20:51ZDennis··—Gilbert·1970-04-09UNKNOWN-541.872.4398-5790 Jefferson AvenueDenverCO80291N/AUNKNOWN
CLMCLM-4124592026-03-04T05:51:08Z·AMY··WILLIAMSON1988-06-15N/A—(566) 223-5739UNKNOWN··2430 Pine DriveORLANDOFL32868—N/A
CLMCLM-4233412026-08-19T02:13:47ZWatkins, Robert——07/07/2001UHC-29270-37•••-••-6205NULLN/A··—nullnull—GRP-4967NAVIGATE-HMO
CLMCLM-4249832026-05-09T11:38:31ZJames, Marilyn—····06/17/52UHC-01639-27··•••-••-5413——1285 Palm DriveGLENDALEAZ··85367GRP-6572SELECT-EPO
CLMCLM-4222452026-10-06T17:47:41ZMEGANXCASTILLO1955-03-05UHC-34234-24NULLnull—NULLNULL—NULL··GRP-9822··null
CLMCLM-4240472026-07-10T07:01:36ZHENRY—ROSS1987-12-05UHC-22131-74N/A—UNKNOWN2139 SPRING STTUCSONAZ85788NULLN/A
CLMCLM-4252072026-04-13T17:57:32Zkaren—owensSep 7, 2002UHC-11443-63-null··N/A4662 Harbor BoulevardMinneapolisMN55481UNKNOWNNAVIGATE-HMO
CLMCLM-4304642026-03-08T21:43:10ZEmilyT.Gonzalez09/26/86·UHC1000389UNKNOWN6078871437—4296 WILLOW COURTSan AntonioTX·78260GRP-5642·MEDICARE-ADV-A
CLMCLM-4025892026-10-06T12:44:15ZSophia—Jenkins1983-05-12UHC-46590-40NULL—····3545 RIVER RDPlanoTX75065GRP-8707NAVIGATE-HMO
CLM CLM-4019072026-07-21T05:05:42ZWALTER—HARVEY1982-01-11UHC-29088-65UNKNOWN566-235-3926—836 SPRING STEden PrairieMN55362GRP-4101SELECT-EPO
CLMCLM-4309972026-04-13T19:35:47ZLawrence—Moore1994-07-19UHC-61864-11—-N/A4563 Elm St #643DallasTexas·75260GRP-5397MEDICARE-ADV-A
CLMCLM-4096102026-03-11T18:57:50ZBRADLEY—BROWN06/11/2004UHC1908169—null—·4265 Grand AvenueHOUSTONTX77064GRP-3831—
CLMCLM-4251192026-01-04T23:11:58ZAlice—Morrson1/13/1965UHC-39317-97•••-••-9742—UNKNOWN7940 Sage CtSan AntonioTX78265GRP-4726OPTIONS-PPO
CLMCLM-4227872026-08-26T14:11:42Zalexis—diaz1981-05-20·N/A—nullNULL5203 MESA DRJacksonvilleFL32257GRP-8825OPTIONS-PPO··
CLMCLM-4237852026-06-04T03:57:39ZDouglasIReynolds12-01-2008--+1 273 652 0040—8095 Highland Ave Apt 3MINNEAPOLISMN55414N/A·N/A
CLMCLM-4037112026-06-14T22:44:44ZKEITH···IVAZQUEZ1965-05-23-··——N/A6164 Grand AvenueScottsdaleAZ——MEDICARE-ADV-B
CLMCLM-4236712026-01-28T21:24:07ZDONNA··—OWENS1956-08-12UHC-44246-61N/AN/Anull7269 PINE DRIVEScottsdaleAZ85254-8764—-··
CLMCLM-4049412026-04-26T16:53:44Z·Carlos—Brooks1950-05-09NULLN/AN/Acarlos.brooks13@aol.com3873 BroadwayColumbusOhio43255GRP-4925N/A
CLMCLM-4239412026-08-21T11:16:53ZMARCUS—MYERS1949-12-23UHC-16071-16—NULLUNKNOWN2919 Harbor Boulevard #295ScottsdaleAZ·85218GRP-2075CHOICE-PLUS-PPO
CLMCLM-4289902026-04-27T01:10:15ZPRIYA—RYAN1989-06-17UHC-94155-47•••-••-9179—null6949 Canyon RdChandlerAZ··85249—null
CLMCLM-4312802026-02-09T09:30:52ZRamos, Hannah····—1952-09-18—NULL-—8140 BroadwayTempeAZ85258GRP-8154UNKNOWN
CLM CLM-4210072026-02-12T10:26:06ZAdam—McDonaldAug 22, 1986UHC-42579-42•••-••-6189(681) 523-0456··———NULLN/AGRP-5527null
CLMCLM-4195192026-01-27T18:17:37Z·KAREN—PDILLA1998-05-28UHC-05442-22——null8532 FOREST AVETucsonAZ85740GRP-9339NAVIGATE-HMO
CLMCLM-4024172026-02-13T15:54:42Zkayla··hart19500627UHC5688149nullUNKNOWNN/A7021 Highland Avenue·MESA·AZ85211GRP-7522UNKNOWN
CLMCLM-4312962026-02-26T17:48:27ZvasquezSdavid1976-04-28·UHC8741832•••-••-3539UNKNOWN—414 SAGE CTScottsdaleArizona85231GRP-3174UNKNOWN
CLMCLM-4169922026-03-02T12:54:29ZJennifer—Little6/6/1954UHC-31231-20UNKNOWNnullJENNIFER.LITTLE@YAHOO.COM6996 Lincoln WayJacksonvilleFlorida32230GRP-8212NAVIGATE-HMO
CLMCLM-4168942026-10-04T02:21:00ZJordan—Mendez06/10/1971UHC-72598-96—16963667600—7025 BASELINE ROADSAN ANTONIOTX·78285GRP-9584null··
CLMCLM-4323412026-10-10T15:26:52ZWalterPRice12/07/1977——665-860-8479null5345 Maple AvenueSan DiegoCA92113N/AMEDICARE-ADV-B
CLMCLM-4090442026-08-11T19:37:03ZFord, Doirs——1985-08-03UNKNOWN—+1 274 493 8096—4869 Meadow LnMESAArizona85259GRP-0805··NULL
CLMCLM-4113532026-02-20T08:58:50ZJEFFREYJHAWKINS2004-01-09UHC-53749-90NULLNULL—8662 CAMELBACK ROADSan DiegoCA··92137N/A-
CLMCLM-4019402026-04-08T02:05:49ZEmma—Munoz1994-09-16·-•••-••-4078(314) 528-3398N/A·2062 Jefferson AveDallasTX·75213—OPTIONS-PPO
CLMCLM-4262342026-02-13T05:41:39ZRussell—Holmes07/10/1969··UHC-68851-64—NULLNULL6297 Sage CtAtlantaGA30312-5736GRP-8967CHOICE-PLUS-PPO
CLMCLM-426469 2026-04-30T23:48:31ZBobby—Dean·1941-05-26—•••-••-3823——·717 VALLEY VIEW DRJacksonvilleFL32287··GRP-4668··—
CLM CLM-4276662026-06-21T18:53:45ZALEXIS—BENNETT1968-06-04UHC-65598-14•••-••-6548(967) 433-3853UNKNOWN8577 BroadwaySacramentoCA95882GRP-3914—
CLMCLM-4081292026-03-08T14:44:15ZChristian—Romero02/08/57—•••-••-0284NULL—NULLN/A———NAVIGATE-HMO
CLMCLM-4105442026-07-31T07:47:57ZNicole—NunezUNKNOWNUNKNOWN•••-••-7682null—6643 Valley View DriveDallasTX··nullMEDICARE-ADV-B
CLMCLM-4237842026-04-18T07:03:18ZAMANDA—MARTINEZ1962-06-21UHC-64839-47•••-••-53365305175038NULL·nullN/A—null—null··
32,829 rows, page 178 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:40.614Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty