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-4212502026-04-22T02:59:44ZSteven—Alvarez2007-02-25UHC-39225-34•••-••-0114UNKNOWNnullN/ANULLnullUNKNOWNNULL—
CLMCLM-4030582026-10-17T18:21:09ZWayne—Jones1975-01-24UHC-18856-20N/A(529) 997-5980wayne.jones2@icloud.com408 Canyon RoadJacksonvilleFL32204GRP-6885CHOICE-PLUS-PPO
CLMCLM-4280642026-08-05T09:46:20ZTERESALSNYDER1995-03-08UHC-84031-93•••-••-3989341.690.0947null7579 Indian School RdHoustonTexas77042N/A—
CLMCLM-4195912026-08-27T03:33:27ZDouglasTLong··1951-05-02uhc-91066-27—505-811-5307N/A5253 Willow CourtAtlantaGA30312—CORE-HMO
CLMCLM-4084202026-03-06T17:06:31ZZachary—WeberJan 21, 1945UHC-61312-95N/A463-641-1510-1671 Elm StreetMiamiFlorida33142GRP-9617UNKNOWN
CLMCLM-4298792026-04-11T15:02:38ZPena, Julie——14-12-1994UNKNOWN•••-••-8529—null9289 Ridge RoadAtlantaGeorgia30309-5023GRP-7301—
CLMCLM-4001432026-02-13T20:35:41ZYoung, Katherine—··1985-06-08UHC-45033-96UNKNOWN—UNKNOWN-null—NULL··GRP-6874SELECT-EPO
CLMCLM-4205902026-06-23T21:00:13ZEmmaA.SandersAug 6, 1948UNKNOWN—12228543447UNKNOWN6865 Sage CtNASHVILLETennessee37297GRP-1150—
CLMCLM-4308962026-07-10T18:42:32Z VALENTINA—REID1965-04-06N/AUNKNOWNnull—4462 Lake View RoadPhoenixaz85029-0361GRP-8788—
CLMCLM-409774 2026-01-01T02:58:28Zmarcus···scott10/26/66UHC-10294-58—UNKNOWNN/AN/A——N/AUNKNOWN—
CLMCLM-4045012026-09-03T16:18:05Zkatherine—payne11/11/1948··UHC-49443-83-nullnull5085 Hillcrest RdAustinTX··78727GRP-8717SELECT-EPO
CLMCLM-4192132026-03-24T04:30:16ZgarySpatterson·2000-03-08UHC-74046-14•••-••-5812(790) 234-2108—704 Apache BoulevardTempeAZ85257GRP-4737OPTIONS-PPO
CLMCLM-4289882026-04-12T13:40:07ZWalter—·Payne1960-04-08NULL—UNKNOWN—4196 Main StPhoenixAZ85012·GRP-2938CORE-HMO
CLMCLM-4126492026-07-24T22:52:44ZJANETJYOUNG2450-19-76UNKNOWN•••-••-9282——3328 Oak StreetNashvilleTN37280GRP-9298NAVIGATE-HMO
CLMCLM-4115932026-01-27T00:16:16ZWebb, Kimberly——10/11/01UHC-74710-86··•••-••-9226(723) 896-2839N/A1437 Grand Avenue·NashvilleTennessee37292—·N/A
CLMCLM-4130762026-05-13T01:41:37Z Arthur—Rios1946-09-08UHC-81700-16null··7056318299arthur.rios58@proton.me8960 Baseline RdSan DiegoCA92132GRP-8981·OPTIONS-PPO
CLMCLM-4297252026-06-25T06:06:31ZDENISE—BURNSFeb 12, 1987UHC-01051-87•••-••-8828-denise.burns@gmail.com501 GRAND AVEMESAAZ85299GRP-7041—
CLMCLM-4195102026-02-17T02:46:37ZAngelaG.Flores1985-04-07··N/AUNKNOWNUNKNOWN9795 Washington St #636Los AngelesCA90021··GRP-2027NULL
CLMCLM-4052142026-10-05T00:13:24ZBARBARA—HOWARD2002-07-14UHC-62387-23•••-••-5401210-262-0539·NULL6324 Mountain View Dr Apt 6JacksonvilleFL·32235—null
CLMCLM-4248422026-07-05T02:05:08ZJOHN—BLL1957-01-01UHC-95187-29N/A··—null8461 Union StreetLos AngelesCA90040-9079UNKNOWN—
CLMCLM-4123982026-10-02T14:43:49ZGilbert, Scott——12-05-1940——12482628548UNKNOWN1979 Pine DrHoustonTX77078—CHOICE-PLUS-PPO
CLMCLM-4111762026-05-12T14:02:38ZBetty—Wheeeler15-10-2002UHC-47951-04NULL··-null2733 CHURCH STCHARLOTTENorth Carolina28288GRP-6246-
CLMCLM-4061802026-01-28T18:34:27ZSandraTLucas2007-12-14··UHC-39711-12•••-••-6419(537) 405-1445SANDRA.LUCAS56@YAHOO.COM··5385 River RdDenverCO··80249··GRP-5920UNKNOWN
CLMCLM-4255812026-09-13T13:26:20ZDouglas—Gutierrez2005-03-01——614-763-7752····25 BROADWAYPlanoTX75095——
CLMCLM-4043742026-02-18T13:08:19Z·Betty—Soto12/6/1974uhc-59887-21•••-••-4151nullbetty.soto@proton.me8097 BAYSHORE DRMiamiFL33158GRP-2412UNKNOWN
CLMCLM-4094442026-06-29T20:53:09ZETHAN—ALVAREZ··Dec 4, 1955UHC-95573-58--N/A349 MOUNTAIN VIEW DRNashvilleTN37269UNKNOWNOPTIONS-PPO
CLMCLM-4107582026-10-14T20:55:12ZCHRISTINA—RAMOS1963-02-12UHC-50875-92-UNKNOWN·UNKNOWN7083 Grand AvenueSeattleWA98178·GRP-8615OPTIONS-PPO
CLMCLM-429819 2026-04-26T09:56:29Zdonald—chapman8/9/2003UHC-60622-70•••-••-5532·4353948718donald.chapman@proton.me-null——GRP-1216MEDICARE-ADV-A
CLMCLM-4265872026-10-12T08:14:30ZJacob—Jimenez11/07/1983—•••-••-5669·710-301-7058NULL·1086 OCEAN AVEHouston··tx77041GRP-9790CHOICE-PLUS-PPO
CLMCLM-4320482026-04-09T05:20:26ZNATHAN—HERNANDEZ1998-90-28UHC-51466-53•••-••-388016626810799—7291 Union StFresnoCA93756GRP-1010CORE-HMO
CLMCLM-4114122026-04-28T04:04:36ZSCOTT—ELLIOTT1983-11-11UHC-82085-28•••-••-075515012428848-5169 BroadwayAUSTINTX78704—MEDICARE-ADV-B
CLMCLM-4178312026-07-21T08:22:41ZJESSICA—MARTINEZ1992-08-15UHC-78420-75•••-••-2932+1 287 250 4621—4361 Forest AveSacramentoCAN/AGRP-9770—
CLMCLM-4174742026-03-08T03:32:27ZWilliam—Patterson02/18/74UHC7067352-UNKNOWN-9035 Sunset BoulevardMIAMIFL33172-medicare-adv-b
CLMCLM-4111792026-01-24T08:56:36ZJean—Morrison01/18/1942null•••-••-3090(892) 970-7534-1239 Spring StTampaFlorida33615GRP-6122—
CLMCLM-4162002026-07-20T10:34:58ZJeremyZWilliamson09-05-2001UHC-36275-30N/AN/A··9294 MAPLE AVESan Antonio··TX78298GRP-6662NAVIGATE-HMO
CLMCLM-4309932026-03-02T11:13:13ZSofia—Webb1960-12-02UHC-18146-96•••-••-0631·(729) 820-0070—265 Ridge Rd··TampaFL33645GRP-6026null··
CLMCLM-4098172026-09-02T13:23:22ZHiroshiFRce1947-09-04N/A•••-••-8954UNKNOWNUNKNOWN5783 Oak StreetJacksonvilleFL·32271GRP-8213—
CLMCLM-4312482026-07-24T12:43:50Zkatherine—jenkins12/03/1941—-null—6551 DESERT SKY BOULEVARDScottsdaleAZ85284—N/A
CLMCLM-4039202026-02-03T06:38:06ZzacharyG.carlson10/23/03NULL•••-••-2089·UNKNOWN·NULL6475 Jefferson AvenueDenverco80273··GRP-4758CHOICE-PLUS-PPO
CLMCLM-4175812026-01-11T00:11:40ZHenry—Graham·Apr 4, 1969UHC-16030-05·-815-263-3479-46 Grand Ave Apt 17PlanoTX75023UNKNOWNMEDICARE-ADV-A··
CLMCLM-4126982026-01-18T03:51:06ZNathan—Franklin08/05/1942UHC-12055-16•••-••-0784883.240.3615N/A3003 Sage CtChandlerArizona85202-5852-UNKNOWN
CLMCLM-4247192026-09-30T21:56:59ZPaul M—Gordon1954-05-19—UNKNOWN6838472125—9470 CAMELBACK RDMiamiFL33165GRP-0510OPTIONS-PPO
CLMCLM-423058 2026-04-14T14:29:05ZJanice—Rice2060-06-26NULL—-N/A7691 Forest AvenueGlendaleAZ85325GRP-7509—
CLMCLM-4112312026-08-27T10:08:18ZCamila—Turner1990-05-10—•••-••-6958NULLUNKNOWN9865 MESA DRIVECharlotteNC28218GRP-5273NAVIGATE-HMO
CLMCLM-4133492026-03-09T23:29:01ZFrances—Carpenter07/13/1989··UHC9435346·N/A2789370578N/A1399 MOUNTAIN VIEW DRPlanoTX75046—options-ppo
CLMCLM-4114942026-05-16T21:38:43ZKayla—Carr05/19/1964NULL-UNKNOWN—37 Camelback RdPhoenix··AZ··85042-6833N/A—
CLMCLM-4292672026-05-03T20:51:29ZTerry—Russell1940-06-04·UHC-49834-84UNKNOWN——8387 APACHE BLVD Apt 25CharlotteNC28204-0780UNKNOWNUNKNOWN
CLMCLM-4203452026-02-17T04:48:38Zdavid—yang1947-05-10UHC-30445-94--UNKNOWN··1680 Jefferson Ave··NashvilleTN37270GRP-4497··
CLM CLM-4153192026-03-27T18:58:51ZANDREA—BLACK19970828NULL•••-••-7621null—7581 Mesa DrDallasTX75287—CORE-HMO
CLMCLM-4026372026-09-11T18:55:28ZJulia—Nguyen1941-11-07UHC-90442-51—nullUNKNOWN5856 RIVER RDPlanoTexas75085UNKNOWN—
32,829 rows, page 38 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.684Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty