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-4044042026-08-14T22:22:32ZRachel—Davis1993-10-04UHC-17326-95•••-••-1564null—4711 RIVER ROADCharlotteNC28247GRP-4928CORE-HMO
CLMCLM-4060292026-01-17T18:52:16ZDouglas—Sandoval·2005-06-15·-—3089498236null—UNKNOWNUNKNOWNUNKNOWN··null—
CLMCLM-4104132026-09-11T08:13:06ZFatima—Nunez19440312·N/A•••-••-2436·9225465460NULL4927 HILLCREST ROADHoustonTX77039UNKNOWNMEDICARE-ADV-B
CLMCLM-4178602026-01-05T20:18:29Zkevin—walker19851227null-262.676.8000··8453 Washington StLOS ANGELESCA90085-CORE-HMO
CLMCLM-4313532026-02-28T16:57:48Z Batsy··N.Duncan10/24/77··UHC-69532-26··—8268116452—328 Hillcrest RdGlendaleAZ85342GRP-5163··CORE-HMO
CLMCLM-4114932026-09-14T09:45:30ZGerald—Marquez1943-05-27UNKNOWN•••-••-25162539868N/A7247 Valley View DriveTempeArizona85279GRP-3492NAVIGATE-HMO
CLMCLM-4127432026-03-16T05:55:06ZJosePBryant1974-02-01UHC-24385-05··NULL591-976-5784null7395 HARBOR BOULEVARDSAN ANTONIOTX·78238nullUNKNOWN
CLMCLM-4128132026-05-20T16:06:12ZCAMILA··—BAKERnullNULL-·900.957.8885NULL815 Ocean AvenueLas VegasNV89195GRP-8722-
CLMCLM-4060272026-09-17T02:26:10Z·Sandoval, Douglas——15-06-2006null——DOUGLAS.SANDOVAL@OUTLOOK.COMUNKNOWNUNKNOWNUNKNOWNNULLGRP-9372MEDICARE-ADV-A
CLMCLM-4261102026-08-17T18:06:48ZGilbert, MarcusD—1994-03-03UHC-89377-66N/A—MARCUS.GILBERT99@PROTON.ME6817 Forest AveGlendaleAZ85358——
CLMCLM-4283042026-09-05T14:01:53Z·Janice··Soto1955-05-28-····(277) 271-9495null·3265 Mountain View DriveLas VegasNevada89127GRP-0189—
CLM CLM-4171392026-02-23T09:23:40ZDanielECooper19690718NULL··—620.801.1209null142 River RdAustinTX78775——
CLMCLM-4202152026-04-02T20:57:31ZKyle··Moore1984-03-11UHC-18856-78—null—N/AN/A—·NULLGRP-3750MEDICARE-ADV-B
CLMCLM-4043522026-03-16T20:50:53ZPAMELA—CONTRERAS1991-04-02UNKNOWN—977.716.6114N/A8748 ELM ST··Las VegasNV89196GRP-4096NULL
CLMCLM-4291602026-05-24T05:58:46ZJasonZ.Thompson1994-08-22—•••-••-9236(591) 303-0233—1783 Indian School RoadNashvilleTennessee37241N/AUNKNOWN
CLMCLM-4075482026-01-11T20:47:46ZBRUCE—SANCHEZ1966-12-13UHC-67947-39—NULL-9891 Highland AveTEMPEAZ85216—CHOICE-PLUS-PPO
CLMCLM-4122442026-02-25T02:52:28ZRoss, VictoraO—Jun 16, 1978—•••-••-9640·UNKNOWN—8429 Camelback RdDallasTX75251—NULL
CLMCLM-4297332026-03-05T19:58:07ZRONALD—DANIELS1967-06-11UHC-10524-07null9574886605null·8619 Central AvenueSan DiegoCA92134—-
CLMCLM-4269382026-04-11T00:24:37ZRYAN—DIXON2007-03-03UHC-90343-37UNKNOWN879-597-9163—3550 Lake View RoadSan DiegoCA92195-9817GRP-5879NAVIGATE-HMO
CLMCLM-4146862026-01-27T07:54:15Zalice—gutierrez20080202UHC-29633-39•••-••-9344-—8084 Baseline RoadTampaFL33626GRP-8619—
CLMCLM-4060552026-04-01T21:40:59ZHANNAH—GREEN1981-12-16··—UNKNOWN—UNKNOWN9332 Camelback RoadDallas··TX75293UNKNOWNCHOICE-PLUS-PPO··
CLMCLM-4152392026-05-19T10:20:51ZAisha—Owens2002-06-26··UHC8448896•••-••-3521(231) 707-5318null7806 Main StreetORLANDOFlorida32868N/A·MEDICARE-ADV-A
CLMCLM-4216672026-08-22T10:00:59ZRichard—Hamillton2001-10-03UHC-08968-49N/A2156053528UNKNOWN4119 Highland AveColumbusOhio———
CLMCLM-4037292026-03-18T19:55:02Z———1994-01-11UHC-83075-14————NULLN/A—GRP-2045N/A
CLMCLM-4069542026-02-11T17:42:25Zkevin—jacobs1973-08-14—•••-••-9235·N/AUNKNOWN·9820 Harbor BlvdJacksonvilleFL·32202GRP-8723—
CLMCLM-4220952026-04-28T20:15:28Z———09/18/67UHC-42415-03N/A535-505-4321null8889 Bayshore DriveDallastx75201··GRP-1768null
CLMCLM-4200112026-04-19T20:16:00ZGloriaX·Torres1991-11-21UHC6588012•••-••-4607——156 Sunset Blvd #806CharlotteNC28268—OPTIONS-PPO
CLMCLM-4192052026-05-13T23:54:10ZCharlotte—Burns19701225null•••-••-1761466-415-0992NULL1008 River RoadGlendaleAZ85368-0632——
CLMCLM-4200712026-09-22T21:14:41ZOlson, ChristineI—1984-12-03UHC-78090-69•••-••-3185—UNKNOWN7619 PINE DRIVEFresnoCA93738GRP-7174-
CLMCLM-4083962026-04-08T10:38:31ZJacqueline—Grant··19781202NULL——null9887 Spring StCharlotteNC28269N/AMEDICARE-ADV-B
CLMCLM-4211672026-10-05T00:10:17ZASHLEY—PATTERSON04/24/89UHC0759345nullNULL—9026 Lake View RdDenverCO80220GRP-6162—
CLMCLM-4100262026-08-28T03:08:14ZKYLE—ALEXANDER1961-02-18··UHC7243058····(478) 951-5500—9366 Elm StSCOTTSDALEAZ85298null···N/A
CLMCLM-4120822026-06-26T00:21:16Z Willie—Price1976-01-15UHC3890457•••-••-542315106652657N/A2918 Highland AveSan DiegoCA92176GRP-4183-
CLMCLM-422984 2026-08-08T04:30:54ZJeffrey··—Payne19661115UHC2881519UNKNOWN410-873-7703—8073 LAKE VIEW RD Apt 2TempeAZ85256GRP-4877·MEDICARE-ADV-B
CLMCLM-4065992026-03-03T01:42:44ZEmmaXMeyernullUHC-13185-09•••-••-8228—emma.meyer@icloud.com5206 Sunset BlvdColumbusOH43225—null
CLMCLM-4017022026-02-20T05:06:08ZJOHNCESTRADA1991-01-14UHC-95931-01—N/A—3522 Market St··MiamiFL33185GRP-6989-
CLMCLM-4024852026-02-28T11:03:48ZBrittanyN··Wright19460525UHC-09549-37—N/A—UNKNOWN—UNKNOWN—UNKNOWNNAVIGATE-HMO
CLMCLM-4199432026-09-01T22:55:57ZRobertQPrice·1967-04-12null•••-••-4191—UNKNOWN1156 MEADOW LNAtlantaGA30313—·SELECT-EPO
CLMCLM-4212932026-02-11T21:56:54ZJoseph—Stephns1975-05-21UHC-66802-91UNKNOWNUNKNOWNNULL1800 Willow CourtMiamiFlorida33111UNKNOWNNAVIGATE-HMO
CLMCLM-4089972026-04-28T06:12:33ZArjun—Fowler1960-06-25UHC-82747-93-2239484975—NULLUNKNOWNN/A—-choice-plus-ppo
CLMCLM-4156732026-05-20T14:14:04ZAaron—Vazquez2003-11-22UHC-00207-30•••-••-3666·-·N/A5948 Apache BoulevardGILBERTAZ85252GRP-7959UNKNOWN
CLMCLM-4134332026-02-11T13:05:09ZVALENTINA—RICE06/23/56UHC-63637-02nullNULLN/A5500 BroadwayDallasTX75282GRP-9804—
CLMCLM-4122182026-05-04T22:51:41ZWalch, Noah——12-12-1978·UHC-89604-28•••-••-056118893605124—4394 PINE DRDenverCO80245GRP-3807OPTIONS-PPO
CLMCLM-4059792026-09-19T15:15:19Zalexander—·aguilar1999-03-21·UHC-60515-47•••-••-1383—NULL2890 Jefferson Ave Apt 9COLUMBUSOH43238GRP-2700CORE-HMO
CLMCLM-4257492026-05-03T15:13:33ZSAAR—ROBERTSON19620412UHC-65179-24null··N/A—910 Forest AvenuePhoenixAZ85005N/A··NAVIGATE-HMO
CLMCLM-4014422026-06-14T17:09:17ZDENIEL—LEE·1956-02-05-···null15797499867NULLnullNULL—N/ANULL—
CLMCLM-4193932026-05-18T06:49:24ZZACHARYITHOMPSON01/28/1994··UHC-57296-58-—NULL8390 Forest AveSeattleWA98195GRP-3527—
CLMCLM-4009622026-10-04T19:52:27ZJACK—PATERSON1984-09-04NULLN/A·UNKNOWNnull—UNKNOWNN/A··nullUNKNOWNSELECT-EPO
CLMCLM-4324012026-06-23T09:24:06ZALICEYMCDONALD23-09-1993UHC-21511-16—709-216-1458null4747 Elm StreetLos AngelesCA90057GRP-4837NULL
CLMCLM-4000482026-08-07T14:45:58ZGarza, DorisF—1957-12-18N/A•••-••-4697——5194 Desert Sky BoulevardLOS ANGELESca90000GRP-8008CORE-HMO
32,829 rows, page 37 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.682Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty