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-4320852026-03-28T19:34:41Zwilliam—wels1996-06-27N/ANULLnull—4905 Lake View RoadPhoenixAZ85085GRP-0110-
CLMCLM-4218142026-10-07T10:57:27ZAbigail—Allen1999-01-07UHC-78813-14•••-••-8969····—2171 OAK STREET #361TampaFlorida33683GRP-4779NAVIGATE-HMO
CLM CLM-4072462026-04-20T05:04:47ZGrace··—·Hayes1964-09-27UHC-70367-18UNKNOWN(222) 562-1741—4935 Apache BlvdOrlandoFLUNKNOWNGRP-0743MEDICARE-ADV-A
CLMCLM-4295642026-10-11T11:22:07ZRobert—Robinson10/05/88—NULL8587292705··-6663 BAYSHORE DRIVESan AntonioTX78288GRP-8155CORE-HMO
CLMCLM-4280502026-03-11T14:13:37ZEvelyn—Black1953-10-02UHC-03263-23•••-••-0639-N/A8411 Union StreetColumbusOH43228GRP-6410-
CLMCLM-4030332026-04-15T09:26:10Z Keith—Morales1973-08-27UHC-51608-34•••-••-4885——9255 Washington Street #573··PlanoTX75009-NULL
CLMCLM-4210892026-07-28T00:25:59ZRoger—Thomas·1953-10-06UHC4117615UNKNOWN·896.766.4439N/A-NULL-nullGRP-7266··NULL
CLMCLM-4295372026-09-06T14:53:49ZJEFFREY····PHILLIPS1977-06-27UHC-08341-30—N/A··8994 Highland AvePhoenixAZ85065-3559GRP-1106—
CLMCLM-4269082026-07-01T17:32:54ZFrakn—·Garcia1940-07-01UHC-99822-51UNKNOWN(736) 751-4389—9059 Market St #371DenverCON/AGRP-0844CHOICE-PLUS-PPO
CLMCLM-4271142026-10-04T15:32:44ZGEORGEI.WEST1993-12-28UHC-85557-32•••-••-8565·--1635 Mountain View DriveMesaAZ85219GRP-1457NAVIGATE-HMO
CLMCLM-4306822026-05-13T03:41:57ZDennis—Delgado—UHC3704784null378-898-4725dennis.delgado@icloud.com7235 Bayshore DrFresnoCA93725GRP-8528-
CLMCLM-4320752026-07-05T08:41:28ZEMILY—SHAW1992-02-13UNKNOWN•••-••-7617426.215.0652—1137 WASHINGTON STREET·GilbertAZ85258GRP-7072·-
CLMCLM-431403 2026-08-04T02:26:51ZMatthews, Gary——1945-11-13UHC2720951•••-••-6632(681) 866-5792GARY.MATTHEWS@GMAIL.COM4842 PINE DRIVECharlotteNorth Carolina28266N/AMEDICARE-ADV-B
CLMCLM-4257932026-08-14T13:37:25ZMedina, Sarah——19711214UHC-08978-41•••-••-62688102627525sarah.medina99@aol.com6277 Elm StGilbertAZ85250GRP-2453OPTIONS-PPO
CLMCLM-4324402026-08-31T21:14:59ZMICHAEL—RAMIREZ2007-02-19UHC-59993-39•••-••-5233N/A—UNKNOWN··-··NULL—MEDICARE-ADV-B
CLMCLM-4200212026-05-11T11:09:50ZHIROSHI—GUERRERO19591027N/AN/A921-433-6320·UNKNOWN3471 Baseline RoadAtlantaGA30352GRP-6973UNKNOWN
CLMCLM-402675 2026-08-04T22:07:35ZAngela—GeorgeDec 24, 1994UHC-43479-59-N/Anull—————NAVIGATE-HMO
CLMCLM-4274112026-02-01T22:31:59ZRay····Fox5/6/2005·UHC-79354-74—·N/A—9046 Desert Sky BlvdMinneapolisMN·55484·GRP-2307MEDICARE-ADV-B
CLMCLM-4169542026-05-18T21:37:24Zolivia—padilla2001-03-03UHC-79554-60•••-••-5455—··847 MARKET STREETTempeaz-GRP-6657null
CLMCLM-4263892026-03-12T06:31:08ZDebra—Sullivan··2002-06-28··—•••-••-5950—-··9094 UNION STSan DiegoCA92148GRP-5562MEDICARE-ADV-A··
CLMCLM-4147012026-05-19T06:20:23ZAlexander—Washington7/9/1959·UHC-78887-44——NULL5736 RIVER ROAD #502San AntonioTX78247-0907GRP-7400—
CLMCLM-4032362026-02-06T05:27:41ZRichard—Luna··01/18/86UHC-69234-20•••-••-7373——-···UNKNOWNN/A—N/AN/A
CLMCLM-4275802026-07-01T20:58:06ZRALPH—PETERSON1995-08-04··N/ANULL——1958 MARKET STSACRAMENTOCA95883GRP-0505··
CLMCLM-429446 2026-04-07T07:30:17ZANNA—REED19930610··UHC-81319-46—15678013180—5711 Park PlJacksonvilleFL32274GRP-5769MEDICARE-ADV-B
CLMCLM-4109652026-06-12T17:23:43ZAngela—Vargas1955-09-02——(777) 697-2854angela.vargas77@outlook.comUNKNOWN—-NULL—MEDICARE-ADV-B
CLMCLM-4170732026-05-15T08:04:43ZHannah····Williams1972-04-05N/AUNKNOWN(681) 202-1493UNKNOWN7890 Oak StreetSan DiegoCA—GRP-8891-
CLMCLM-4116142026-03-03T12:08:13ZDEBBIE—HOWARD·1958-08-08UHC-46791-90—(413) 753-6810—6384 MAPLE AVENUEEden PrairieMN55305··—CHOICE-PLUS-PPO
CLMCLM-4277572026-07-14T03:01:16ZDENNIS—KELLY03/19/2005null—(568) 839-8896-5781 Elm StreetNashvilleTN37270GRP-3383—
CLMCLM-4177302026-04-27T21:10:37ZJoyceMWebb21-07-1940UHC-86059-45null4087064188—4877 Grand AveSEATTLEWashington98187GRP-0839CORE-HMO
CLMCLM-4005062026-03-19T00:22:42ZWILLIAMM.FERGUSON9/19/1965—UNKNOWN+1 481 211 0400NULL29 Market StAustinTX78774GRP-9531CHOICE-PLUS-PPO
CLMCLM-4199912026-07-30T21:06:30ZMarcus—Salazar··2000-01-18·UHC-25548-17-—NULL2563 BroadwayAustinTX78772··GRP-8068MEDICARE-ADV-A
CLMCLM-4063972026-10-03T16:02:47ZBARBARA—SIMPSON1949-07-18UNKNOWNnull-—5234 WASHINGTON STREETDenverCO80205GRP-5792SELECT-EPO
CLMCLM-4148542026-03-17T22:11:03ZDONALD····GONZALES2006-10-09UHC-12549-84—943-583-3336N/A179 Forest Avenue··JACKSONVILLEFL32280GRP-3461OPTIONS-PPO
CLMCLM-4247562026-08-28T17:34:25Z———8/9/1948UHC-15768-95•••-••-5567665.295.1829UNKNOWN1765 MESA DRMinneapolisMN55462GRP-2412null
CLMCLM-4179012026-02-05T05:12:59Z VALENTINA—HAYES1952-04-28UHC-86120-56•••-••-0007241-740-7827—6380 Washington StScottsdaleAZ85229—null
CLMCLM-4001452026-08-20T11:35:54ZKatherine—Young1985-06-08UHC-45033-96———9786 Mountain View DrAustinTX78765GRP-6874SELECT-EPO
CLMCLM-4246352026-08-18T06:58:24ZDYLAN—WELCH05-07-1956NULL•••-••-3047602.926.0546null··5659 Ocean AveSan DiegoCA92115UNKNOWN—
CLM CLM-4131322026-05-26T09:41:03ZKelly, Steven——03/01/88··null•••-••-6785—-1297 Spring StreetScottsdaleAZ—GRP-4872CHOICE-PLUS-PPO··
CLMCLM-4274932026-07-29T14:36:21Z·MARIA—HENDERSON2001-11-21UNKNOWN•••-••-2879—N/A2611 CANYON ROADGlendaleAZ85384——
CLMCLM-4180822026-04-03T10:53:35ZCharles—Ross1992-12-15UHC-90074-48•••-••-5273—NULL8583 Elm St #675Fresnoca93771—N/A
CLMCLM-4061312026-05-24T02:13:47ZKYLE—·WARD14-05-1996UHC-48973-10null—·-131 Canyon RdColumbusOH43227GRP-8480core-hmo
CLMCLM-4315382026-06-08T19:54:54ZRICHARD—WHITE4/21/1967UHC-57024-22•••-••-81629234712099···371 PALM DRIVE·HoustonTX77000—UNKNOWN
CLMCLM-4034392026-04-15T09:45:48ZSofia—·Jimenez2000-07-28UHC-48462-32··•••-••-676712117655769N/A1804 Canyon RdOrlandoFlorida32855-3323-N/A
CLMCLM-4320802026-10-04T05:46:17ZSCOTT—CAMPBELL··06/03/47UNKNOWN—380-342-4135NULL15 Hillcrest RoadSACRAMENTOCA95811NULLMEDICARE-ADV-A
CLMCLM-4173562026-09-20T21:05:09ZPaul—Woods2007-09-24UHC-41066-57NULLnull-8824 Spring StSCOTTSDALEArizona85296GRP-8751·MEDICARE-ADV-B
CLMCLM-4175432026-01-27T17:35:31ZSandraRHart09/18/1950UHC5198499··——·N/A9811 MAPLE AVENUE #933·OrlandoFLNULLGRP-1092OPTIONS-PPO
CLMCLM-4167822026-01-25T01:09:30Zkaren—meyerDec 9, 1970-NULL--211 RIDGE RDAtlantaGA30338·GRP-8996UNKNOWN
CLMCLM-4017822026-03-03T09:04:24ZJeremy—Bailey6/22/1956N/A··nullNULLNULL-——nullGRP-2622MEDICARE-ADV-A
CLMCLM-422051 2026-08-07T19:00:43ZRoy—Wlilis1997-05-27—•••-••-2468·nullnull7433 Indian School RdMiamiFL33101N/AUNKNOWN
CLMCLM-4114912026-06-30T12:00:18ZGerald—Marquez1943-05-27UHC-44996-73——N/A7247 Valley View DriveTempeAZ85279GRP-3492··NAVIGATE-HMO
32,829 rows, page 100 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.457Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty