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-4056942026-08-31T19:52:59ZMeedina, Kenneth——1992-03-26··—•••-••-1889UNKNOWNnull4894 OCEAN AVENUELas VegasNV89112NULLNAVIGATE-HMO
CLMCLM-4168922026-10-01T02:10:00ZElijah··Myers1989-12-09UHC-19261-88—5506243373NULL3062 HIGHLAND AVEDallas··TX75233·GRP-3646CHOICE-PLUS-PPO
CLMCLM-4239672026-08-30T12:49:24ZJONATHAN—DOMINGUEZ·1990-09-08·UHC-77804-72N/A4502350403-null—N/A—GRP-5805MEDICARE-ADV-A
CLMCLM-4204682026-09-14T21:48:34ZHicks, JanetT—06/24/80UHC-23608-84—428-322-6184janet.hicks@hotmail.com8500 Apache BlvdTucson·AZ85711··--
CLMCLM-4123752026-04-12T03:21:38ZMeiW.Lee1996-04-03UHC-44193-52N/A——NULL—NULL-UNKNOWNMEDICARE-ADV-B
CLMCLM-4072492026-04-16T11:40:31ZBobby—Turner1938-02-19UHC-59366-90—·UNKNOWN—7255 Church StHOUSTONTX77053GRP-6248-
CLMCLM-4088602026-05-10T12:49:16ZJoanT.Hoffman09/13/68UHC-43415-86—nullnull8411 Ridge Road··MesaArizona85275·GRP-1955N/A
CLMCLM-4168052026-01-22T22:19:40ZAARON—HERNANDEZ1991-12-10—•••-••-7614——4536 Union StreetTempeAZNULLNULL····
CLMCLM-4167262026-01-15T13:06:36ZGrace—Hernandez1950-12-14UHC-88884-27•••-••-1760UNKNOWNN/A1280 Sunset BoulevardChandlerAZ85229GRP-0874null
CLMCLM-4204462026-09-23T08:13:22ZPatrick—Boyd24-05-1977UHC-93836-29UNKNOWN218.891.3290NULL7545 Mesa DriveMESA·AZ85230GRP-2893—
CLMCLM-4295702026-04-02T07:01:02Z·Matthews, JustinK····2/18/2008UHC-38023-50NULLN/AN/A5546 Maple AveCharlotteNC28255-··navigate-hmo
CLMCLM-4060062026-01-13T21:25:35ZAdrea—Wood·2008-06-21UHC-17270-65•••-••-7869865.695.2746null2241 Desert Sky BlvdMINNEAPOLISMN55405GRP-0966CHOICE-PLUS-PPO
CLMCLM-4171562026-06-27T23:52:23ZJESSE—DEAN1985-05-24UHC-90899-50———8179 Ridge RdChandlerAZ85206-5782UNKNOWN—
CLMCLM-4089282026-04-23T12:44:27ZPaul—Warren11-02-1988UHC-23202-90•••-••-715716558986393NULL4438 Willow CourtLos AngelesCA90034UNKNOWNMEDICARE-ADV-B
CLMCLM-4209922026-03-22T23:59:26Zdoris··—gilbert07/11/1945N/A—12979854632UNKNOWN8676 Canyon RdLAS VEGASNevada89190-3559GRP-2508CORE-HMO
CLMCLM-4298882026-04-05T10:16:59ZAlan—Olson1953-01-19—•••-••-7308(403) 224-9395ALAN.OLSON@OUTLOOK.COM9036 Ridge RoadSan AntonioTX78201GRP-4577UNKNOWN
CLMCLM-415225 2026-04-08T21:45:41ZTeresa—Le1961-11-04UHC-37931-16·-2303182685N/A76 Park PlTempeAZ85208GRP-5752MEDICARE-ADV-A
CLMCLM-4300042026-05-17T01:12:54ZYUKI····VASQUEZ19761023··nullNULL(581) 363-5194UNKNOWNUNKNOWNUNKNOWN—NULLGRP-2038OPTIONS-PPO
CLMCLM-4313162026-10-06T06:56:49ZEdwardKBurton10/20/2004UHC-96686-35N/Anull-1763 Palm DrMesa·AZ85244N/AMEDICARE-ADV-B
CLMCLM-4232982026-09-23T20:10:55ZNATHAN—TURNER1987-05-06UHC0855762———528 Market StreetGilbertAZ85275GRP-4888CORE-HMO
CLMCLM-4302402026-10-13T18:18:31ZAustin—Robinson1955-04-05UHC-83901-95-2439902597··1519 RIDGE ROADTampaFlorida33661-9642·GRP-6693-
CLMCLM-405470 2026-04-22T09:03:10ZNATHAN—OBRIEN1939-90-27UHC-35857-33•••-••-0107UNKNOWNN/A9887 APACHE BLVDTempeArizona85200GRP-5221UNKNOWN
CLMCLM-4106102026-10-12T02:03:13ZAustinLPena19730508··uhc-44306-49null569-240-6719N/A5302 Mountain View DrGlendaleAZ85328UNKNOWNN/A
CLMCLM-4007942026-09-28T16:30:58ZBRITTANYXESTRADA02/12/67N/A•••-••-145614737247689null—NULL—nullGRP-3927-
CLMCLM-4080362026-09-21T08:08:15Z·CarlosPStewart06/01/96UHC-94711-24•••-••-0629····carlos.stewart56@icloud.com8243 Highland AveMiamiFL33144UNKNOWNnull
CLMCLM-4207012026-08-24T08:40:44ZLAUREN—GUTIERREZ·1942-11-00·UHC-72049-97•••-••-2031nullNULL5474 Indian School RdChandlerAZ85220—MEDICARE-ADV-A
CLMCLM-4173862026-06-29T05:34:59ZChristain—Nguyen1978-12-13·UHC-03910-55null··—UNKNOWN5012 Ocean AveDallasTX75209nullUNKNOWN
CLMCLM-4191002026-03-03T20:49:40ZJulia·WAlexander1993-08-02UHC-68877-99UNKNOWNUNKNOWNNULL5257 Elm StGilbertAZ85225N/A-
CLMCLM-4062372026-01-27T08:58:38ZHanson, Sharon··——2000-07-07UHC-65180-55—+1 242 703 3344---———MEDICARE-ADV-A
CLMCLM-4148912026-03-17T06:42:59ZDevidRRyan1956-10-15UNKNOWN•••-••-2279UNKNOWNnull5705 PINE DRIVETEMPEArizona85247GRP-8668CHOICE-PLUS-PPO
CLMCLM-4212842026-04-12T01:32:14ZShirleyLMorris19850317UHC-89888-33•••-••-1258218-286-2611UNKNOWN7543 Canyon RdAtlantaGA30375GRP-7022—
CLMCLM-4273812026-10-08T00:56:07Z·Austni—Herrera1951-06-11UHC-82062-87N/AUNKNOWN··N/AnullnullNULL—GRP-7732—
CLMCLM-4050332026-08-31T02:04:43ZChris··Cunningham1946-04-04N/A•••-••-1098N/AnullUNKNOWNnull·null—-—
CLM CLM-4027302026-06-27T13:37:28ZRonaldP.·Howard1974-04-01UHC-34914-04—··N/A3729 Sage CourtGlendaleArizona85322GRP-0202N/A
CLMCLM-4247452026-01-16T02:31:55ZRonaldL.Murray1999-01-17UHC-20380-41•••-••-1404—UNKNOWN7410 PARK PLDenverCO80203nullnull
CLMCLM-4038242026-03-26T02:31:41ZSCOTT··—SCHULTZ1938-06-06nullnull4324935516·NULL—N/Anull—NULLMEDICARE-ADV-A
CLMCLM-4074122026-01-27T05:41:45ZCAROLYN—JIMENEZ1947-10-28UHC-43087-38UNKNOWN··—3589 Pine DrColumbusOH43242GRP-8630—
CLMCLM-4102952026-08-02T13:31:42ZGabriel—Padilla2007-08-22UHC-42797-52•••-••-76684564186944··-—null—N/AGRP-0386CORE-HMO··
CLMCLM-4295942026-06-24T00:35:49ZMartha—Watkins1953-01-33uhc-39674-45•••-••-798017984442945UNKNOWN6223 SPRING STSEATTLEWA98127GRP-9473UNKNOWN
CLMCLM-4284672026-03-28T14:50:42ZDanielle—Hayes1960-03-09N/ANULL··—null4866 HILLCREST RDGlendaleAZ85327——
CLMCLM-4238502026-10-03T02:17:11ZOmar—Nunez19821016UHC-16297-37•••-••-0342N/AUNKNOWN518 Baseline Rd #798MESAAZ85227GRP-5397OPTIONS-PPO
CLMCLM-4048932026-02-20T06:25:20ZWei—Harrison··1954-03-02UHC-67650-36—450-968-9142UNKNOWN—-N/AnullNULL·N/A
CLMCLM-4292202026-08-15T19:40:47ZAisha—Larson1949-09-22··UNKNOWN•••-••-8638-aisha.larson@gmail.com3250 BroadwayEden PrairieMNN/AGRP-1530—
CLMCLM-4057972026-05-06T23:41:18ZJORDAN—DUNCAN1993-06-11UHC-11088-69NULL(786) 319-0096—4713 Indian School RoadHoustonTX77066GRP-9330NULL
CLMCLM-4310232026-02-19T20:40:50ZAaron—Freeman1944-07-07·NULL—null-6995 Oak St Apt 8MesaAZ85216—NAVIGATE-HMO
CLM CLM-4323842026-07-19T21:45:07ZGaryFSantos03/08/1957UHC-60618-10—2328547760N/A947 Grand AvenueMiamiFL33168GRP-1203NAVIGATE-HMO
CLMCLM-4011552026-06-28T20:23:34ZJackie··Weber01/06/1980··UHC-14018-87•••-••-8998(300) 537-0105NULL·2662 CAMELBACK ROADMesaAZ85260GRP-2001NAVIGATE-HMO
CLMCLM-4312532026-02-05T17:11:20ZHill, KimberlyO—1945-12-18nullNULL770.748.2301—6792 OCEAN AVENUEMesaAZ85234GRP-6582—
CLMCLM-4276362026-02-25T09:12:32ZSTEVEN—COLE3/7/1970UHC-33866-79•••-••-0993N/A·NULL8077 Willow CtTempeAZ··85258GRP-6033SELECT-EPO
CLMCLM-4314592026-08-17T22:43:43ZShirley—Jenkins1973-05-17UHC-29779-72—(909) 592-1322N/A7004 Washington St··NashvilleTN37207—CHOICE-PLUS-PPO
32,829 rows, page 9 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-19T19:54:25.420Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty