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-4222562026-05-07T00:02:15ZBOBBY—SANTOS1965-03-28UHC-83369-97null9554350null7250 APACHE BLVDDALLASTX75217GRP-8950SELECT-EPO
CLMCLM-4066982026-08-28T19:29:31ZDONALD—CASTILLO··1942-07-26UHC-10489-73··UNKNOWN·518-342-4288NULL2970 MARKET STPhoenixAZ85095-6857N/ACHOICE-PLUS-PPO
CLMCLM-4208812026-04-20T04:34:02ZHEATHER—KENNEDY2008-04-19UHC-93835-23•••-••-9770920.235.6149HEATHER.KENNEDY60@PROTON.ME9077 Maple AveTEMPE·AZ85207GRP-8361MEDICARE-ADV-B
CLMCLM-4254392026-04-18T06:22:36Zcharlotte—meyer1965-07-01UHC-88643-22null6923729310——NULLUNKNOWN-GRP-8997SELECT-EPO
CLMCLM-4268622026-06-06T05:24:47ZEUGENEMCRAWFORD1954-05-05—•••-••-6851NULL—4182 HIGHLAND AVENUENashvilleTN37248-7162-·MEDICARE-ADV-B
CLMCLM-4052252026-01-23T16:57:08ZKatherine··—Soto18-09-1956UHC-31504-63•••-••-9929944-752-1887····1461 Ridge RoadMesaAZ··85235—CORE-HMO
CLMCLM-4203622026-06-13T01:43:09ZDENNIS—COLE01/09/50UHC-96366-62NULL(750) 924-8916-4920 Pine Dr·PhoenixAZUNKNOWNGRP-7823NAVIGATE-HMO
CLMCLM-4224442026-03-25T15:56:18ZAmanda—Alexander1938-02-27UHC-10695-82•••-••-6567(933) 683-2337null··879 SUNSET BLVD Apt 23HoustonTX77027GRP-9538null
CLMCLM-4288602026-10-08T13:49:54ZCarulyn—Sullivan27-04-1960UHC-93054-21N/A·NULL-3287 Washington Street··Tampafl33607GRP-8451—
CLMCLM-4096062026-08-22T10:25:08ZCatherine—Mendez2006-03-23UHC-12032-61—448-675-7724N/AN/AN/AUNKNOWN—GRP-5672—
CLMCLM-4036432026-06-16T04:56:48ZElijah····Stephens1961-12-16·UHC-35712-96•••-••-29539421924null6193 Cedar LaneEden PrairieMN55393·GRP-8191—
CLM CLM-4313722026-09-03T07:02:54ZWilliam—Collins1973-01-09—N/AUNKNOWNnullnull———N/AN/A
CLMCLM-4327202026-03-08T19:13:50ZMARCUS—CARTER·12/2/1973UHC-88098-45•••-••-0210(292) 271-9033—2539 Desert Sky BoulevardColumbusOH43272—MEDICARE-ADV-B
CLMCLM-4261752026-06-10T19:01:20ZKENNETHR·GARZA1982-07-11UHC-59034-04——UNKNOWN9788 SPRING STREETORLANDOFL32821GRP-6301OPTIONS-PPO
CLMCLM-4248912026-07-22T16:12:00ZBrandonNSmith·1958-10-14UHC-72514-77•••-••-6972-NULL1746 BAYSHORE DRIVEDALLASTXUNKNOWNGRP-6791N/A
CLMCLM-4304222026-04-22T13:33:19ZJacqueline—Mendoza1990-02-14UHC-51173-49null6345392198—6121 Cedar LaneLas VegasNV89110GRP-1741OPTIONS-PPO
CLMCLM-4150792026-08-29T10:16:06ZGARYLMORGAN1956-05-06UHC-94931-37—·-·N/A8136 Oak StJacksonvilleFL32203GRP-1819null
CLMCLM-4153082026-09-16T20:05:01ZPierce, Christine——2000-10-11null—UNKNOWNchristine.pierce97@yahoo.com-nullN/ANULLGRP-0486NULL
CLMCLM-4011622026-04-29T15:09:07ZBRENDATBRADLEY1946-05-19null•••-••-5771960-452-3025—7376 Bayshore DrChandlerAZ85281GRP-8746choice-plus-ppo
CLMCLM-4105332026-07-01T22:09:29ZAHMED—BURKE1958-06-22··UHC-38144-72NULLnull—2720 Spring StMinneapolis···MN55435GRP-3216CORE-HMO
CLMCLM-4294582026-10-15T10:07:03ZVictoria—Gray1978-09-01UHC-19111-25-··——580 Sage CtEden Prairie·MN-nullOPTIONS-PPO
CLMCLM-4293462026-07-30T22:29:14ZJoyce—Spencer9/14/1967UHC-65674-90—(314) 863-9728··—9339 Oak StreetEden PrairieMN55317GRP-4743SELECT-EPO
CLMCLM-4121112026-03-27T20:33:57ZPatricia—Ford03/04/1988·UHC-44592-27-N/A····nullN/A·UNKNOWNN/AGRP-8568NAVIGATE-HMO
CLMCLM-4163392026-06-14T09:36:23ZjuanHbradleySep 17, 1979UHC-92505-70UNKNOWN—NULL2720 CENTRAL AVE·SAN ANTONIOTX78213——
CLMCLM-4180962026-04-03T12:21:46Z victoria—peterson·2004-03-17UHC-99908-60—+1 367 390 2205—5416 Sunset BlvdGilbertAZ85228GRP-0530null
CLMCLM-4000192026-09-13T22:05:05Z Henry, AustinZ—2008-03-02UHC-53911-82—710-406-9848-NULLNULL·NULL——CHOICE-PLUS-PPO
CLMCLM-4316142026-09-28T07:00:20ZSEAN—HAMILTON··1939-06-15N/A•••-••-0402N/A—·4965 Palm DriveSEATTLEwa98113-6363GRP-6024OPTIONS-PPO
CLMCLM-400713 2026-03-15T22:21:53ZMATTHEW··HAYES1993-02-07UHC-78677-80-4649219132NULL5670 River RoadDenver··CO80220GRP-0673NAVIGATE-HMO
CLMCLM-4261282026-03-11T06:06:36ZJOSEPH—HAYES1967-08-14UNKNOWN·NULLUNKNOWN——NULL—-GRP-5200medicare-adv-b
CLMCLM-4319192026-08-09T02:31:13ZAnn—Perez19930811UHC-58834-40—null—2559 Baseline Rd #496··PHOENIXAZ85046GRP-6900CORE-HMO··
CLMCLM-4014592026-09-22T18:49:29Z·ALBERT—CASTRO1982-05-10UHC-91693-71•••-••-6153390.344.3809—3576 Desert Sky BoulevardSacramento··CA··95809nullMEDICARE-ADV-A
CLMCLM-4003322026-01-29T00:14:15ZTerry—Edwards··1951-05-18N/AN/A—N/A1429 DESERT SKY BLVDMiamiFL33169GRP-4954CHOICE-PLUS-PPO
CLMCLM-4008072026-02-17T07:02:56ZDebra—Simmons20050627UHC-13215-75•••-••-4833(244) 332-7255·NULL———UNKNOWNGRP-4287—
CLMCLM-4005652026-05-20T03:19:54Z JANICE—KELLEY1960-05-25—•••-••-4854——5743 Pine DrLOS ANGELESCA90036—MEDICARE-ADV-B
CLMCLM-4110612026-03-07T03:20:04ZPRIYAP.RIVERA01/18/91UHC-73259-41—·+1 631 676 8422priya.rivera@icloud.com7262 Ocean AvenueOrlando·FL32880··GRP-9587MEDICARE-ADV-B
CLMCLM-4138002026-02-06T19:31:53ZAngela—Mitchell1938-07-05UHC9696757•••-••-2109—angela.mitchell95@icloud.com2710 Valley View DrSan DiegoCA92105—MEDICARE-ADV-A
CLMCLM-4283242026-09-24T17:35:35ZAngela—Johnston1938-09-11UHC-84082-76•••-••-7272UNKNOWNangela.johnston76@icloud.com-N/A—-GRP-3671N/A
CLMCLM-4300622026-02-26T14:59:57ZPTRICK—HAYES1989-06-27UHC-62613-40•••-••-12329055286223—·N/AN/A——GRP-9143—
CLMCLM-4030532026-09-02T05:20:02ZRichard—WrightJul 20, 1965UNKNOWNUNKNOWN826-519-4705N/A7463 Mesa DrAustinTX78731UNKNOWNNULL
CLMCLM-4033272026-07-24T12:18:40ZJEAN—KELLY20031120UHC-50100-19NULL5893437985—--nullNULLGRP-6155MEDICARE-ADV-B
CLMCLM-4124082026-04-25T21:46:50ZShirley··Hoawrd3/21/1995UHC-42640-50··3086782307····9430 Lincoln WayCHARLOTTENC28274··SELECT-EPO
CLMCLM-4001472026-05-18T00:29:18ZCarlos—McCooy1998-06-19··•••-••-4525N/Anull—N/AN/AnullNULL-
CLMCLM-4325952026-03-26T16:50:30Zemily—hamilton1958-04-24UHC-45306-29··—+1 792 778 4735—1869 Apache Boulevard #528San AntonioTX78278—NAVIGATE-HMO
CLMCLM-4322512026-06-26T00:25:06ZCATHERINE—ROMERO1952-02-09NULLnull(944) 537-9019-9615 Camelback RoadTempeAZ85263UNKNOWNMEDICARE-ADV-B
CLMCLM-4228612026-08-06T11:41:17ZDIANA—SANTIAGO··02-12-1990—•••-••-64742425485707null7726 Oak StTempeAZ85202GRP-2721N/A
CLM CLM-4169552026-01-06T12:17:43ZJANYCE—CARPENTER1984-04-20—·null786-777-5858·janice.carpenter@aol.com2154 Hillcrest Rd·JacksonvilleFL32213GRP-3112CHOICE-PLUS-PPO
CLMCLM-4162412026-07-24T01:40:16ZJerry—Andrews1953-01-18UHC-76255-49NULL-······3655 Camelback RdTucsonAZ85792GRP-3293OPTIONS-PPO
CLMCLM-4178672026-03-05T17:42:39ZSeanNHicks19710122UHC-17934-68null··——NULL---GRP-6074—
CLMCLM-4006932026-09-03T02:15:00ZROBERT—·NCIHOLS10/24/07UHC-85970-41NULL6913974850N/A5023 Cedar LnSeattleWA98131nullN/A
CLMCLM-4148272026-01-10T13:33:48ZCHRISTINA—ORTEGA07/03/1971·UHC-06273-61•••-••-5031——2874 River RoadTUCSONAZ85765UNKNOWNNULL
32,829 rows, page 83 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.752Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty