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-4157562026-03-03T22:10:32ZNicole—Daniels2002-09-27UHC-34186-32—NULL—6952 CENTRAL AVENUETampaFL33627—NAVIGATE-HMO
CLMCLM-4289662026-07-16T20:53:37ZRussell—Lee1969-11-26··UHC-11734-93—6108866920NULL244 Mesa DriveGlendaleAZ85350GRP-5004NAVIGATE-HMO
CLMCLM-4043532026-01-07T15:26:18Z·BRENAD—SINGH1998-10-19NULL•••-••-6094(436) 890-1966—7889 Union StreetSeattleWA·98138·GRP-1775—
CLMCLM-4100762026-08-11T11:49:18Zjulie—sims1980-02-25UHC-52677-23nullnulljulie.sims86@yahoo.com4819 Valley View DrSan AntonioTX·78220GRP-9400MEDICARE-ADV-A
CLMCLM-4197592026-06-09T18:54:55ZDouglas—Rice9/12/1968UHC-71875-98—(824) 222-5479NULL6348 Pine Drive·ChandlerAZ·85274GRP-7041CORE-HMO
CLMCLM-4102642026-04-20T19:35:04ZSHIRLEY—PHILLIPS1962-01-13UNKNOWNN/A442-508-5432UNKNOWNN/A-—NULL-MEDICARE-ADV-B
CLMCLM-4148072026-07-10T23:16:44ZWilliam—NelsonFeb 23, 1969UHC-40816-54•••-••-8631(417) 458-5752—·3672 Main StSAN ANTONIOTX78268GRP-8617NULL
CLMCLM-4255432026-03-24T09:46:40ZSteveG.··Spencer1948-07-11UHC-81845-88•••-••-0206——605 SUNSET BOULEVARDSan AntonioTX··78274—MEDICARE-ADV-B
CLMCLM-4141392026-03-23T22:05:46ZRaymondXBanks··19660428UHC-72994-01•••-••-4260652-810-2518UNKNOWN-N/AnullUNKNOWN··SELECT-EPO
CLMCLM-4007882026-04-14T09:13:26ZAlice—·Knight1958-06-21··UHC-58125-21——alice.knight@icloud.com6465 Pine Drive Apt 11OrlandoFL32859NULL—
CLMCLM-4159502026-06-21T18:30:17ZJUAN··—BUTLER1952-03-08UHC-52359-45——NULL4309 Willow CourtPLANOTX—GRP-3957NULL
CLMCLM-4119822026-02-05T06:27:58ZCHRISTIAN—FULLER1993-07-18N/A--NULL7702 HARBOR BLVD Apt 39MinneapolisMN55431GRP-4554·MEDICARE-ADV-A
CLM CLM-4203862026-07-29T03:45:02ZAnthonyXHenry1962-05-02NULL•••-••-3673813-597-4576—UNKNOWN—UNKNOWN-GRP-0116MEDICARE-ADV-B
CLMCLM-4301652026-08-17T15:31:43ZRaymond··Castillo19441219-•••-••-5821——3054 Central AvenueNashvilleTN37289GRP-4783—
CLM CLM-4126052026-03-11T15:46:22ZLORI—CAMPBELLJan 13, 1980UNKNOWN··—-LORI.CAMPBELL89@YAHOO.COM231 BroadwayFRESNOCalifornia93734-7809GRP-0825··—
CLMCLM-4004452026-07-06T01:21:51ZSean—Evans1958-08-01UHC-66436-57•••-••-354417539335895-5226 OAK STLos AngelesCA··90009N/AN/A
CLMCLM-4005692026-04-13T22:41:24ZStephanie—Campbell··03/15/60UHC-45143-38N/A399.788.6790—8660 Central AvenueAtlantaGA30368GRP-6928N/A
CLMCLM-4123472026-02-02T03:51:49ZCatherine—James1988-09-11null•••-••-8841NULL—6878 Ridge RoadAustinTX78756GRP-8919null
CLM CLM-4121692026-07-02T03:08:30ZElizabeth—Young01/13/1979UHC-34103-14•••-••-7192UNKNOWN—6703 SAGE COURTMiamiFL33133GRP-9661CORE-HMO
CLMCLM-4028962026-01-12T11:19:53Z·BradleyQHayes07/10/43—•••-••-30902463906813—8430 FOREST AVELAS VEGASNV89118GRP-3961UNKNOWN
CLMCLM-4306662026-04-12T20:17:03Zbetty—griffin1956-02-08UHC-23779-75•••-••-9558+1 391 827 4461NULL4989 Central AveLas VegasNV89163GRP-1931CHOICE-PLUS-PPO
CLMCLM-4154412026-07-19T05:27:59Z Eric—Cole1986-10-13UHC-82550-35UNKNOWN7849853245eric.cole@outlook.com5747 Washington StreetDALLASTexas75299GRP-4572··—
CLMCLM-4283172026-08-30T03:36:54ZVincentL.West1/17/2003-•••-••-7819—UNKNOWN8724 Central AvenuePLANOTX75011··NULLNAVIGATE-HMO
CLMCLM-4293052026-01-12T22:21:31ZKimberlyHBoyd1994-11-10uhc-72399-15··N/A··—NULL5470 Central Ave·FresnoCA93751-7902GRP-0873NAVIGATE-HMO
CLMCLM-4057952026-04-27T06:46:54ZEUGENE—BARNES19830709——3544877383N/A————GRP-1866CHOICE-PLUS-PPO
CLMCLM-4279002026-09-07T00:27:32ZLarson—Keith1994-01-19-—2916371340null6408 Lincoln WayLos AngelesCA90046NULLMEDICARE-ADV-A
CLMCLM-427612 2026-01-13T23:32:55ZKeith, Banks····—08/09/1985—•••-••-24717187738586—6227 Park PlaceCHARLOTTENC28200-4558GRP-5683-
CLMCLM-4062302026-03-23T11:39:18ZMkie—·Murphy09/25/1979UHC7413137•••-••-6952N/ANULL4048 Broadway·ChandlerAZ85251-7181GRP-4371MEDICARE-ADV-B
CLMCLM-4125972026-03-06T05:10:10ZBrown, KathleenV—Aug 14, 1994·UHC4316947•••-••-7491—N/A3092 Sage Court Apt 8OrlandoFL32854GRP-9243MEDICARE-ADV-A
CLMCLM-4070922026-01-14T03:46:53ZGrray, Lucia——1981-03-26UHC-38544-29•••-••-2642+1 451 249 5460NULL5550 Lincoln WayCharlotteNC28253GRP-6994-
CLMCLM-4107722026-05-03T13:14:33ZABIGAIL—JOHNSTON2002-06-09UHC-13519-75•••-••-8491NULL—5319 MEADOW LANEDallasTX··75235——
CLMCLM-4140492026-02-06T01:49:34ZANDREW—MUNOZ1978-02-12—UNKNOWN(828) 506-4570N/A9411 LINCOLN WAYGlendaleAZ··85334··NULLMEDICARE-ADV-A
CLM CLM-4279022026-05-01T03:19:18ZChuck F.—Sims··19880308UHC-42845-48•••-••-4239429.575.6670N/A1382 Sunset BlvdTampaFL33692GRP-3803-
CLMCLM-4199202026-09-23T19:28:41ZWang, DouglasE—1938-02-04UNKNOWN•••-••-1288null—566 PINE DRSan DiegoCA92145—SELECT-EPO
CLMCLM-4279752026-08-25T02:43:04ZMCCOY—ABIGAIL02/08/66UHC-03347-22—(414) 973-4441UNKNOWN1161 Meadow LnColumbusOH··43277GRP-6683NAVIGATE-HMO
CLMCLM-4059902026-08-25T17:10:20Z JoshuaB.Marshall1942-02-26UHC-44961-96NULL—joshua.marshall39@yahoo.com8078 Canyon RoadMesaAZN/AGRP-7852N/A
CLMCLM-4242132026-05-24T21:42:08ZRoy—Campbell1965-02-19—null18022947510-4888 UNION ST Apt 1PhoenixAZ85060UNKNOWNN/A
CLMCLM-4061742026-03-05T06:16:01ZKelly, Jean——2007-01-26NULL•••-••-3022null—1655 CEDAR LN·ChandlerAZ—GRP-1447NULL
CLMCLM-4107602026-03-08T06:09:03ZAhmed—Wells2/11/1988UHC-76495-59•••-••-3334NULL-7072 Central AveColumbusOH43298GRP-1906—
CLMCLM-4080072026-08-23T02:04:14ZYUKI—DOMINGUEZ09/13/1982UHC-20110-23—+1 573 355 2265——N/ANULL—GRP-7204MEDICARE-ADV-A
CLM CLM-4274202026-10-01T03:10:18ZJerry—Weaver2001-11-04··UHC-98671-03NULL····UNKNOWN4457 Central AvenueAtlantaGeorgia30340UNKNOWNMEDICARE-ADV-A
CLMCLM-4134052026-06-30T18:38:17ZLORI—SINGH1973-06-04··--572-689-7822—2288 Canyon RdDENVERCO80250UNKNOWNCHOICE-PLUS-PPO
CLMCLM-426715 2026-09-02T17:57:23ZMEELISSA—BUTLER1987-07-14—•••-••-6252+1 692 280 8759NULL2905 BROADWAYCharlotteNC28285GRP-9413—
CLMCLM-4035802026-06-21T03:15:25ZCruz, Brittany——1964-02-22NULL·N/A(304) 730-7115N/A··2650 Market StreetGilbertAZ85297·GRP-4804CHOICE-PLUS-PPO
CLMCLM-4261882026-09-16T17:54:43ZMARK—·MARQUEZ2/28/1953——710-642-7661··NULL——····null··GRP-0985N/A
CLMCLM-4074292026-02-01T14:15:47Z·Cynthia—·Ward1969-07-16UHC-59138-15—NULLUNKNOWN3700 Hillcrest RoadCharlotteNC28226—CORE-HMO··
CLM CLM-4300742026-06-25T19:59:14ZArthur—Cooper1974-01-05-———9829 Canyon RdMesaAZ85250GRP-2633CHOICE-PLUS-PPO
CLMCLM-4148932026-01-11T17:46:41ZWILL—DANIELS·1969-09-18UHC-94662-39null+1 565 254 5974UNKNOWN9324 Bayshore DrMinneapolisMN55452GRP-6232MEDICARE-ADV-A
CLMCLM-4104542026-01-02T09:13:04Z—····—07/15/62UHC-95184-37•••-••-0673-UNKNOWN————GRP-7295SELECT-EPO
CLMCLM-4110242026-03-28T22:04:21ZOlivia—Ramirez09/06/2002—•••-••-5401—null3487 Oak StAUSTINTX78763GRP-6143CORE-HMO
32,829 rows, page 129 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:38.501Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty