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-418490 2026-09-03T14:33:06ZLINDA—KELLY8/10/1950-•••-••-3128—-5183 Ridge RdColumbusOH43262—OPTIONS-PPO
CLMCLM-4005072026-05-12T18:57:38ZWillM.Ferguson1965-09-19··UHC-03740-18•••-••-4212+1 481 211 0400—29 Market StreetAustinTX—NULL—
CLMCLM-4272352026-09-13T09:16:23Z JosephG.Turner1957-06-14—-·NULLN/A4916 Camelback RdTampaFlorida33682N/ANULL
CLMCLM-4163192026-10-01T10:06:05ZPatricia—Vasquez8/25/1975UHC-55742-93•••-••-8188-NULL—NULL———NULL
CLMCLM-4187732026-04-13T00:19:29ZALICE—JACKSON1968-01-20UNKNOWNNULL—-3218 ELM STDenver··CO80247GRP-0805CORE-HMO
CLM CLM-4184192026-06-25T00:19:00ZWells, Henry··S··11/01/38UHC-53311-49-N/A—539 LINCOLN WAYPlanoTX75092GRP-5593NAVIGATE-HMO
CLMCLM-4036802026-03-01T18:42:39ZSARAH—ALVARADO··1963-04-16UHC-19247-27NULL2095581648NULL6407 GRAND AVENUE Apt 35OrlandoFL32893—SELECT-EPO
CLMCLM-4051992026-02-19T06:29:56ZLinda··Peterson1992-10-04UHC-87559-07—(610) 860-5316—9153 Lake View RoadDallasTX75211GRP-0206CORE-HMO
CLMCLM-431953 2026-01-31T06:49:26ZDOUGALS—CASTILLO1962-12-03··UHC-86309-17··•••-••-0186UNKNOWNnull81 MESA DRIVEPhoenixAZ85050GRP-5575CORE-HMO
CLMCLM-4225732026-03-08T10:04:14ZDoris—Coopar1998-12-23UHC-85207-56—5122392743NULL9722 Palm DriveHoustonTX77098GRP-4269SELECT-EPO
CLMCLM-4270542026-02-12T10:43:16ZSARAH—MILEROct 7, 1953UHC-52058-49———————GRP-6210NULL
CLMCLM-4069412026-10-16T22:58:35ZJESSE··RALEXANDER2/13/2007·UHC-98335-18-(315) 653-1933——N/A——GRP-7163—
CLMCLM-4199012026-05-22T07:49:37ZRobinson, KathrynY—5/13/1968UHC-69124-67—UNKNOWN—8157 Ridge Rd·CHARLOTTENC28201GRP-7620-
CLMCLM-4258492026-03-02T19:42:25Zcarl—robertson1976-08-12UHC-87750-98null·(298) 370-6148—1832 BroadwayColumbusOH·43231GRP-2559-
CLMCLM-4291572026-07-17T08:45:57ZPETERRBAKER1945-12-21UHC-62009-75-408-752-3519—7980 Union StreetSan AntonioTX78275GRP-2573UNKNOWN
CLMCLM-4053332026-03-31T03:03:50Z Olivia—Cox1958-07-16·UHC-53008-24•••-••-619919579960055—8025 Maple AvenueFresnoCA93761GRP-7493—
CLMCLM-4068712026-01-23T16:46:57Z·Aaron—Smith1947-09-28UNKNOWN··NULL13963702963NULL6483 Washington StGilbertAZ85253GRP-2389OPTIONS-PPO
CLM CLM-4034612026-02-02T07:08:57ZMason—YangUNKNOWNUHC-23214-93N/A5309965779UNKNOWN5607 BROADWAYSeattleWA98186GRP-8886N/A
CLMCLM-4254902026-09-15T23:36:19ZAmber—Baker2/20/1975UHC-69086-47NULL(958) 295-8441—8203 BAYSHORE DR Apt 23AustinTX78727··GRP-0257MEDICARE-ADV-B
CLMCLM-4212882026-03-19T14:54:27ZLAWRENCE—JOHNSTON1976-02-23-····nullUNKNOWN4994 DESERT SKY BOULEVARDTempeArizona85295nullMEDICARE-ADV-A
CLMCLM-4213302026-10-03T02:56:59ZRebecca—Mitchell1963-12-03UHC-70908-34—623-797-9279NULL8905 CANYON RDPlanoTX75071GRP-8976CHOICE-PLUS-PPO
CLMCLM-4098532026-04-02T15:36:26Z·DENISE—STEPHENS1995-08-16N/AUNKNOWNUNKNOWNN/A····NULLnull—GRP-6908-
CLMCLM-4158732026-03-11T09:29:04ZJudy··—Williams1997-09-06N/A•••-••-8045UNKNOWNnullNULLUNKNOWNN/A—GRP-5942MEDICARE-ADV-A
CLM CLM-401264 2026-09-16T03:09:58Z·Marilyn—Long1982-08-17UHC-18585-05•••-••-7168N/AUNKNOWN4829 Oak StAtlantaGA30357GRP-1168-
CLMCLM-4217852026-05-27T22:24:45ZROGER—DOMINGUEZ19440515—•••-••-5200720-412-1553nullUNKNOWN—--GRP-9586N/A
CLMCLM-4009862026-08-23T23:48:13ZAMANDA—ESTRADA04/18/1941UHC-05928-02UNKNOWN——NULLnullNULLNULLGRP-9358—
CLMCLM-4222582026-08-10T17:56:58ZALBERT—SANDERS1976-05-06····•••-••-4495—N/A5471 CAMELBACK ROADLas Vegas·NVN/AUNKNOWN-
CLMCLM-4039222026-10-03T04:01:31ZZACHARY—CARLSON10/23/03UHC0586291NULL—N/A6475 Jefferson AvenueDenverco80273—CHOICE-PLUS-PPO
CLMCLM-4026882026-08-02T16:15:32Znoah—lawrence··07/20/1965—null(289) 561-3596··—·169 Baseline RoadMinneapolis·MN55443GRP-8456N/A
CLMCLM-4041212026-01-29T20:55:37Zlisa—wlker1979-01-20····•••-••-2281686-925-0852lisa.walker@icloud.com5732 Forest AveTEMPEArizona85276GRP-5181MEDICARE-ADV-A
CLMCLM-4119282026-01-08T23:38:42Z·DOROTHYWWILLIAMSON10/05/58UNKNOWN··UNKNOWN6962228594—6047 LINCOLN WAYDallasTX75210GRP-2039N/A
CLMCLM-4076842026-03-17T09:34:21ZMark—Robertson19560514··UNKNOWN——UNKNOWN3376 Indian School Rd #922PhoenixAZ85053··—MEDICARE-ADV-A
CLMCLM-4088092026-08-21T13:49:24ZERIC—FORD1971-07-12UHC-06150-22nullUNKNOWN—5382 WILLOW COURTCOLUMBUSoh··43295GRP-1680N/A
CLMCLM-4234022026-08-24T03:41:00ZCAROLYNJMARTIN1986-03-17UHC-41069-52—428.279.0462N/A5919 Church StreetPlanoTX——null
CLMCLM-4040772026-04-18T09:02:44Zsandra—hansen07/06/2005NULL•••-••-2998N/Asandra.hansen@icloud.com···7281 Willow CtSan DiegoCA92175GRP-8927MEDICARE-ADV-B
CLMCLM-4140402026-09-27T07:55:18ZDAVID—HERNANDEZ19870628UHC-79977-02··(691) 308-6821-8201 Camelback RdOrlandoFL32825GRP-5652—
CLMCLM-4236362026-06-22T12:43:31Z Olivia—Wang1/19/1970—•••-••-7786(570) 872-0991UNKNOWN5888 Lincoln Way #449GilbertAZ85259UNKNOWNNAVIGATE-HMO
CLMCLM-4091032026-07-23T08:43:04Z Sarah—Ward1954-02-01UHC-85737-85•••-••-5180·2306518673NULL9079 Cedar LnGilbertAZ85291GRP-7951OPTIONS-PPO
CLMCLM-4032522026-02-01T23:00:25ZTERRY—RODRIGUEZ·1964-02-21—•••-••-8508(349) 265-9436—N/A-N/AUNKNOWNGRP-4390UNKNOWN
CLMCLM-4124512026-07-29T13:14:30Z·Benjamin··Robinson2006-11-02UHC-34560-42——-5706 Church StreetScottsdaleAZ85295——
CLMCLM-4249342026-08-25T22:19:51Z Jeffrey—Jenkins1992-05-11——·839.989.8724N/A··413 Baseline RoadHoustonTX77084N/A—
CLMCLM-4272152026-07-15T04:11:23ZBowman, AshleyM—27-07-1954--4277801336——N/A—N/A·nullNAVIGATE-HMO
CLMCLM-4144112026-04-08T18:11:04ZWalter—Andrews··20-06-1962UHC-25990-64UNKNOWN9725950422-7531 Ocean Avenue Apt 34PhoenixAZ··85084GRP-2330·MEDICARE-ADV-B
CLMCLM-4325322026-07-08T09:57:55ZDONALD—WALLACE··19660522UHC-15888-67•••-••-9862—UNKNOWN3382 Main StreetAustinTX78763·-NAVIGATE-HMO··
CLMCLM-4212072026-03-29T09:55:04ZKayla··DRice09/14/59UHC-12753-25-—UNKNOWN—UNKNOWN—NULLGRP-8133CHOICE-PLUS-PPO
CLMCLM-4199882026-01-07T04:15:12ZjuliaPmaon1972-01-02UHC-75209-77—+1 519 221 8721····2791 Elm StPlanoTX75038NULL—
CLM CLM-4128822026-07-05T08:38:18Zjames—·cooper1945-03-27—-—NULL2166 APACHE BOULEVARDSan AntonioTX78219GRP-9871OPTIONS-PPO
CLMCLM-4080292026-09-13T17:31:19ZVIRGINIA—HUGHES8/27/1964—····13489110886UNKNOWN8827 LINCOLN WAYDenverCO80238GRP-2805NULL
CLMCLM-4119962026-03-27T12:39:30ZBriian—Johnson19390802N/A•••-••-9837N/ANULL···8350 Mesa DrMiamiFL33172GRP-9995—
CLMCLM-4286732026-08-24T15:55:55ZWOODUJORDANMay 5, 2004··UHC-07231-79NULL403-642-7703null7709 Park PlaceDallasTX75285·GRP-1026CORE-HMO
32,829 rows, page 138 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.318Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty