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-4148382026-10-12T06:26:32ZLAWRENCETOWENSUNKNOWN··N/A-—lawrence.owens@outlook.com2445 GRAND AVENUEScottsdaleAZ85205GRP-9927N/A
CLMCLM-4185332026-01-15T12:59:06ZKIMBERLY—PIERCE1978-12-17UHC-02314-68-·NULL····8849 Valley View DrColumbusOH43253GRP-0198CHOICE-PLUS-PPO
CLMCLM-4135162026-09-27T06:01:45Z Elizabeth—Perez05/21/1978··UHC-65690-96—(793) 643-4049—7103 Pine DrDallasTX75278GRP-2089NAVIGATE-HMO
CLMCLM-4051392026-08-20T12:07:06Zraymond—schmidt1954-07-01UHC-32279-47——UNKNOWN8835 VALLEY VIEW DRJacksonvilleFL32261GRP-3485MEDICARE-ADV-B
CLMCLM-4039002026-05-16T12:32:32Z George—MaldonadoJun 28, 2003UHC-54438-55-—GEORGE.MALDONADO21@AOL.COM8555 PALM DRIVETampaFL33677GRP-4486—
CLMCLM-4190422026-08-17T12:28:15ZKAREN···RIVERA1984-05-22UHC-62284-61NULL643-959-5537-9144 Ridge RoadFresnoca93779GRP-4200-
CLMCLM-4314802026-02-24T20:47:20ZahmedJ.kelly1965-02-21UHC-98117-22•••-••-6208·N/AN/A4968 WILLOW CTTucsonAZ85776GRP-7742OPTIONS-PPO
CLMCLM-4110332026-09-05T03:22:40ZALICE—·JAMAS1974-10-42UHC5023034•••-••-3216·NULLUNKNOWN1005 Forest Ave #764PhoenixAZ85036nullCORE-HMO
CLMCLM-4279512026-07-22T01:38:10ZELIJAHGGILBERT1998-08-12···NULLN/A-—7681 Canyon RdCharlotteNC28207UNKNOWNN/A
CLMCLM-4302972026-06-11T09:06:19ZAlexanderDSnyder1955-03-26UHC-61149-15UNKNOWN(805) 865-3225N/A6314 CENTRAL AVEPlanoTX75057N/AN/A
CLMCLM-4191862026-07-01T00:46:35ZEmmaJGardner1946-01-01UHC-09094-51•••-••-0259null—1132 Sage CtOrlandoFL32855GRP-2417CHOICE-PLUS-PPO
CLMCLM-4106342026-01-17T13:21:15ZBENJAMIN—MALDONADO1996-12-12UHC-15233-04•••-••-8064—null3930 Apache Blvd #131ScottsdaleAZ85283GRP-8001—
CLMCLM-4064332026-10-18T09:35:03ZPhilip—Bradley19450628UHC-47879-82•••-••-4225-—2457 HILLCREST ROAD··MinneapolisMN-GRP-9547UNKNOWN
CLMCLM-4067812026-02-18T17:43:51ZPerez, Billy——10/05/78null•••-••-7593+1 256 296 3049UNKNOWNnull—NULLNULLGRP-0450NAVIGATE-HMO··
CLM CLM-4026282026-10-05T16:58:02Z·RUTH—VARGAS2001-04-09UHC-73294-75—846-927-0847UNKNOWN7794 UNION STREETGlendaleArizonanullGRP-5891SELECT-EPO
CLMCLM-4036772026-06-23T03:24:29ZRaymond··—Delgado··19661106—-—-··961 Cedar LnSan AntonioTexas78231—MEDICARE-ADV-B
CLMCLM-4280032026-10-02T08:25:48ZHelen—Garcia1973-01-28UHC-38530-83•••-••-3873908-260-5200—8801 FOREST AVENUEFresno·CA93720GRP-1225CHOICE-PLUS-PPO
CLMCLM-4262042026-08-13T21:17:00ZEvelyn—Ortega1989-08-23UHC-60381-37N/A——null———nullCHOICE-PLUS-PPO
CLMCLM-4198372026-03-16T01:04:06ZTeresa··—Dixon1970-04-03UHC-78294-80null703.945.6181-5177 Camelback RdDALLASTX··75270-8154··—MEDICARE-ADV-A
CLMCLM-4071692026-06-26T18:40:03ZISABELLA—DAVIS08/21/1976UHC-86806-72•••-••-8937(499) 835-5063··NULL3286 Bayshore Drive·AtlantaGA30333GRP-3500N/A
CLMCLM-4072032026-07-16T17:56:32ZJANETB.··BOYD1976-01-03UHC-81858-35·NULL-—711 Desert Sky Boulevard·Nashville·TN37271GRP-6378—
CLMCLM-4143472026-08-29T09:09:04ZHENRY—JENKISN19520623NULL•••-••-6381—henry.jenkins52@outlook.com8487 WASHINGTON STSan DiegoCA92100NULLNULL
CLMCLM-4271512026-06-23T02:53:04ZGrace—Davis2000-05-18UHC-22284-67N/AN/AUNKNOWNNULL—NULLN/A··GRP-7197null
CLMCLM-4032032026-09-05T19:47:50ZAnthony—Knight06/22/73N/AN/A446-983-9018—NULLNULL-N/AGRP-9526MEDICARE-ADV-A
CLMCLM-4232602026-05-12T03:06:32Zstephen—gonzalesMay 6, 1985UHC-33555-92NULL—NULL789 Highland AvenueTUCSONAZ85780—MEDICARE-ADV-A··
CLMCLM-4304012026-09-21T12:45:19ZRuth—Rice4/9/1957—UNKNOWNnull—8970 Elm StCOLUMBUSOhio43234N/AMEDICARE-ADV-A
CLMCLM-4026222026-08-21T22:45:52ZLUIS—VEGA1938-07-28·-UNKNOWN898-425-9619NULL2560 OCEAN AVENUE··MinneapolisMinnesota55458··-NAVIGATE-HMO··
CLMCLM-4236232026-06-05T07:09:11ZAna—Arnold2000-05-21-UNKNOWN······UNKNOWN3439 Spring StFRESNOCA93754·GRP-8427OPTIONS-PPO
CLMCLM-4194302026-03-30T12:39:21ZchristineWstevens19830613UHC-87437-98nullNULLchristine.stevens@icloud.com9540 BroadwaySan AntonioTX78215··GRP-2838MEDICARE-ADV-A
CLMCLM-4223202026-02-10T05:23:08Z·Deborah··RobinsonUNKNOWNUHC8432714•••-••-2905+1 384 706 3063—UNKNOWNNULL·N/A——NULL
CLMCLM-4264632026-01-12T19:52:33Zmartha—soto··21-07-1987·UHC-39559-98nullnull—1011 LINCOLN WAYGlendaleAZ··85337UNKNOWNOPTIONS-PPO
CLMCLM-4149492026-05-21T01:56:19ZRandy—Singh1989-05-12··UHC-68184-37•••-••-1705UNKNOWN-·9754 Central AvePhoenixAZ85000-3588——
CLMCLM-4263662026-08-21T00:44:13ZMaryZFord1986-07-04null-null—278 Broadway··GilbertAZ85251UNKNOWNNAVIGATE-HMO
CLMCLM-4007542026-10-08T20:17:46ZCamila—·Munoz1992-07-04—•••-••-9829—-9042 Canyon RdTampaFlorida33697GRP-6691·-
CLMCLM-4206372026-01-10T01:56:50ZGRACCE—NUNEZ1978-02-13—•••-••-55953572996240UNKNOWN7396 Forest AveNashvilleTN37265UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4021572026-08-22T04:16:24ZLuis—Sullivan1943-02-09NULL•••-••-5202(282) 634-0299UNKNOWN2265 Maple AveLos AngelesCalifornia·90010GRP-4098—
CLMCLM-4313102026-09-09T05:52:52ZDANAL.RAMOS1986-05-16UHC-53674-02•••-••-9748(428) 257-0259null3376 Sunset Boulevard·Los AngelesCA90058-6901GRP-5061CORE-HMO
CLMCLM-4217772026-02-05T00:14:57ZDennisYMorris··1990-23-10··UHC-83204-10•••-••-0785+1 509 342 9408N/A1592 CEDAR LANESeattleWA·98162NULLNAVIGATE-HMO
CLMCLM-4206962026-03-26T02:11:53ZSarah—Hill1954-06-20—null(753) 500-1484—9678 MARKET STCharlotteNC28281-0957GRP-5825NULL
CLM CLM-4059672026-05-17T05:26:07ZAdam—Riley11/05/1942null———8342 Church St··FresnoCA·93744——
CLM CLM-4105682026-01-08T15:40:34Z MARILYNIPATTERSON05-01-1997UHC4347166null15688744256N/A9305 Meadow LaneORLANDOFL32888GRP-5805MEDICARE-ADV-A
CLMCLM-4259762026-08-08T06:47:15ZSmith, George—····2008-06-25UHC-87014-69—nullnull8472 CEDAR LANEFresnoCA·93783··CORE-HMO
CLMCLM-4013892026-04-03T17:14:57Zscott—evans1939-08-08UHC-99603-38—751.741.7209null9001 Union StNashvilleTN37274GRP-5512OPTIONS-PPO
CLMCLM-4221892026-04-22T08:19:33ZRaymond—RobinsonApr 12, 1942N/A•••-••-6417893-556-7214—1979 Union StreetAtlantaga30370GRP-8902CHOICE-PLUS-PPO
CLMCLM-4308132026-09-18T02:56:11Z andrea—harrisonJun 22, 1956N/A•••-••-9115-NULL1180 MEADOW LANEPHOENIXAZ85054··GRP-6490UNKNOWN
CLMCLM-4046722026-07-30T18:38:59ZJacobAElliott1986-05-14UHC-71005-90—NULLJACOB.ELLIOTT@HOTMAIL.COM8435 Camelback RoadSacramentoCA95809GRP-2297—
CLM CLM-432616 2026-04-21T05:48:46ZLewis, Ann——1960-10-11UHC-05814-43•••-••-8644nullann.lewis@icloud.com7741 Mesa Dr Apt 10TampaFL33681-6198nullCORE-HMO
CLMCLM-4045132026-05-16T14:32:02ZBRYAN··—FREEMAN1951-11-21—-786.686.2770NULL7670 Valley View Drive Apt 6PlanoTX75079—null
CLMCLM-4111722026-07-10T12:29:50Zjuan—dixonApr 10, 1982UNKNOWN··—juan.dixon51@outlook.com··7198 Church StreetAtlantaGA30367GRP-3373—
CLMCLM-4160212026-03-06T21:15:19Zmark—hartJan 20, 1986-•••-••-21338049933833N/A··9124 PARK PL··AtlantaGA·30313GRP-1431MEDICARE-ADV-A
32,829 rows, page 55 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:36.707Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty