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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4133162026-03-25T19:45:13ZJon—Ellis1979-09-23UHC-80469-45•••-••-8209UNKNOWN—5849 PALM DRTampaFL33609——
CLMCLM-4031132026-03-10T05:31:04ZCarlosV.White1989-01-05uhc-71477-56•••-••-30822306632369carlos.white@outlook.comN/AUNKNOWN—nullN/ACORE-HMO
TPATPA-636572026-08-16T00:46:37ZEthanS.·Garza2002-06-26·····-(349) 681-5937null9873 MARKET STAtlantaGA30335GRP-5429NULL
TPATPA-574212026-07-08T17:41:17ZHoward, Kathleen··—1986-01-21null•••-••-43157765295—3370 Oak StHoustonTX77060GRP-1240—
ENRENR-1118532026-10-05T17:56:32ZSharon—Lynch1991-10-09UHC-20961-58•••-••-4923(702) 697-5895sharon.lynch@gmail.com5384 Desert Sky BlvdAustinTXN/AGRP-7477MEDICARE-ADV-A
CLMCLM-4314302026-05-02T01:03:07ZWei—Cooper··1953-10-25UHC-84241-56····(705) 608-8883N/A5751 RIVER RDChandlerAZ85261GRP-3458CHOICE-PLUS-PPO
ENRENR-1298672026-03-28T14:43:48ZYoung, Elijah——Nov 26, 1952UHC-77203-39•••-••-0411—ELIJAH.YOUNG@ICLOUD.COM··6380 Lake View RdTampaFL33681GRP-6846CORE-HMO
CLM CLM-4122392026-09-04T13:42:02ZJULIEILEWIS1963-03-22—•••-••-4641·········7632 CHURCH STSeattle··WA98167-medicare-adv-a
PRVPRV-274542026-09-15T14:21:22ZHicks, Timothy··——03/13/97UHC-44481-21—·(766) 238-4445TIMOTHY.HICKS80@GMAIL.COM-null-·-null—
TPATPA-567482026-04-17T04:17:08Z·Wilson, Pamela——Jul 21, 1942UHC-01249-68•••-••-88149678349119UNKNOWN175 Camelback RdSan AntonioTexas—NULLOPTIONS-PPO
CLMCLM-4258702026-02-07T10:03:11ZJacobs, Kathy——Feb 7, 1999—•••-••-4681(565) 228-8069-2475 Harbor Blvd·HOUSTONTX77074GRP-0104NAVIGATE-HMO
CLMCLM-4253412026-04-10T06:31:13ZTHOMAS—GONZALEZ1975-09-24UHC-73038-56null8923921982NULL1811 Indian School RoadPhoenix·AZ85024GRP-5685—
CLMCLM-4020202026-04-30T07:35:42ZDIANA··THOMAS1990-11-12UHC-72609-55UNKNOWN+1 724 276 9111N/A785 Indian School RdTucsonAZ85741GRP-4392-
ENRENR-143029 2026-07-07T07:53:48ZSEAN—GARDNER1975-11-13uhc-79247-78•••-••-9180(405) 630-0697-6474 Main StAtlantaGA30303GRP-8319CORE-HMO
ENRENR-1426352026-09-05T11:18:52ZCheryl·COliver1950-08-04UHC-04381-26•••-••-5603N/ACHERYL.OLIVER92@OUTLOOK.COM6848 Sage CtGilbertAZ··85234-9450GRP-8604CORE-HMO
ENRENR-1203722026-03-09T06:50:31Z·DIANA I.—WILLIS28-12-1993··UHC-24003-43•••-••-82984202627379DIANA.WILLIS86@OUTLOOK.COM435 Washington StAtlantaga30301GRP-3468OPTIONS-PPO
PRVPRV-289412026-05-02T14:49:48ZFrances—Powell1968-11-17UHC-90782-54UNKNOWN644.288.7489null7489 Sunset BoulevardFRESNOCA93710-2600NULLCORE-HMO
ENRENR-1113862026-09-27T12:45:00ZPeter—Sims1987-12-08UHC-97502-64•••-••-0171+1 574 263 2837null4145 LINCOLN WAYChandlerAZ85291GRP-5815SELECT-EPO
ENRENR-1233732026-02-17T06:21:30ZValdez, PriyaB—1986-04-28UHC-59028-98•••-••-17915067940364priya.valdez@gmail.com8682 HIGHLAND AVETUCSONAZ85744GRP-5723OPTIONS-PPO
ENRENR-1257932026-02-05T12:28:43ZCharles·Y.Alvarez1994-01-24UHC-12886-26•••-••-0016(532) 596-8481CHARLES.ALVAREZ@YAHOO.COM4176 Meadow LnTempe·AZ85264GRP-9091NAVIGATE-HMO
ENRENR-1228202026-09-08T15:55:41Z MICHAELR.FLORES5/13/2000UHC-18243-61•••-••-3172—michael.flores26@yahoo.com7265 MAPLE AVENUE···Las VegasNV·UNKNOWNGRP-6936··medicare-adv-a
CLMCLM-4038992026-04-15T09:21:20ZGeorge—Reid1995-01-28··UHC-80313-49•••-••-2968351-523-1738george.reid62@aol.comNULL—N/AUNKNOWNGRP-0719NAVIGATE-HMO
ENRENR-1104982026-03-01T11:38:15ZLAWRENCEEDIAZ·6/3/1938UHC-21905-26•••-••-98439309440897UNKNOWN6968 MESA DRIVEChandlerAZ85254GRP-7335MEDICARE-ADV-A
TPATPA-611702026-09-04T19:38:27ZRoy····Spencer1981-07-16null•••-••-3293null-7299 Main StreetFRESNOCA93758—CORE-HMO
ENRENR-1004012026-10-09T22:33:36ZdavidOmurray1945-08-01UHC-38623-43•••-••-0876(837) 733-6787david.murray@aol.com4943 Canyon RdDallasTX75262-0415GRP-2459CORE-HMO
CLMCLM-4082312026-05-06T23:21:22ZOlivia—StephensOct 25, 1966UHC-83378-94-(577) 690-6962—2367 Desert Sky BlvdSan DiegoCA·92136nullNAVIGATE-HMO
CLMCLM-4123842026-10-01T05:10:43ZMARIANAU.WAGNER02/27/1966··UHC-61747-82•••-••-6948-MARIANA.WAGNER@HOTMAIL.COM-—-·NULLGRP-7086choice-plus-ppo··
CLMCLM-4085732026-05-04T16:50:17ZIsabella····Vargas··1979-09-10-UNKNOWN·(223) 922-1480N/A8194 SUNSET BOULEVARD··MiamiFL33120NULLNAVIGATE-HMO
ENRENR-1189312026-01-25T02:14:53ZBryanXFlores5/9/1958—•••-••-2594(519) 635-5859·bryan.flores19@hotmail.com·8892 River RoadMesaAZ·85222GRP-6278CHOICE-PLUS-PPO
CLMCLM-4129102026-05-20T19:21:23ZVirginia—Foster1940-02-10··NULL———8712 Central AveGILBERTAZ85221GRP-3042·MEDICARE-ADV-A
CLMCLM-4270922026-04-04T06:38:44ZCatherine—Marshall1990-03-26UHC-96098-86—(530) 847-2517NULL8858 Grand AveSacramentoCA95889GRP-1011SELECT-EPO
CLMCLM-4251812026-09-07T18:17:17ZJordan—Hall2007-01-06UHC-42253-16-(250) 321-5315N/A2292 PINE DRIVELAS VEGASNV89103nullchoice-plus-ppo
ENRENR-1385682026-05-15T17:25:06ZKYLEA.DIAZ19480121UHC-72638-46•••-••-3494+1 270 428 2167kyle.diaz63@icloud.com7281 RIDGE RDDallasTX75274-3239GRP-3607NAVIGATE-HMO
ENRENR-1321552026-04-15T01:28:13Zteresa—boyd09/14/1996UHC-40965-47•••-••-4325·5766965620N/A2967 Washington StTempeAZ85216GRP-5746MEDICARE-ADV-B
ENRENR-1165332026-03-26T05:45:58Z·NahE.··Sims··2002-05-14UHC-54449-78•••-••-147414558356842UNKNOWN7793 Harbor BlvdChandlerAZ··85215GRP-9465CHOICE-PLUS-PPO
ENRENR-1211402026-05-07T21:20:24ZDeborah—Morales1968-08-17···UHC-91939-51•••-••-9150581.536.9177N/A9045 RIDGE RDDenverco80224GRP-9505MEDICARE-ADV-B
TPATPA-563912026-06-27T09:23:54ZSandra··Guzman03/22/41UNKNOWNN/A309-940-3596UNKNOWN1098 CENTRAL AVECHANDLERAZ85241N/AMEDICARE-ADV-B
CLMCLM-4271842026-09-01T06:55:24Zalbert··Ujohnston1961-05-09UHC-58242-57····554.877.8504··5512 Highland AvenueTucsonArizona85750GRP-3804SELECT-EPO
ENRENR-1190752026-06-22T03:47:08ZAmanda—Perkins02/19/43UHC4982737•••-••-24807633485186amanda.perkins@yahoo.com5497 Forest AvenuePhoenixAZ85009GRP-9373·CHOICE-PLUS-PPO
PRV PRV-267822026-01-29T13:59:25ZsusanXwebb19521006UHC-58050-50•••-••-0080·428.928.5824N/A2347 Lincoln Way·Eden PrairieMinnesota55390—NAVIGATE-HMO··
ENRENR-1314502026-07-29T16:26:36ZNICHOLAS—ROBERTSON1948-05-21UHC-77797-13•••-••-0263(484) 763-9215nicholas.robertson80@proton.me8153 Jefferson AvenueGlendaleAZ85311GRP-7992MEDICARE-ADV-B
CLMCLM-4029622026-05-24T16:29:45ZRebecca—Warren06-04-1997UHC-69309-05•••-••-1090-—····———N/AMEDICARE-ADV-A··
ENRENR-1072972026-05-21T11:51:00ZWlter·MChavez1969-02-03··UHC-84604-12··•••-••-1382852-715-7445NULL··4549 Market StGILBERTArizona··85204GRP-9137MEDICARE-ADV-A
CLMCLM-422784 2026-08-20T00:24:52ZARTHUR—MATTHEWS2006-07-12UHC6872472——-5542 Pine DriveLos AngelesCA90052·GRP-2165CHOICE-PLUS-PPO
ENRENR-1011612026-01-13T22:57:40ZMARGARET·GCARR1982-07-26UHC-97098-05•••-••-9317·806-409-5702margaret.carr@icloud.com8548 HILLCREST RDSan DiegoCA··92177GRP-7941SELECT-EPO
TPATPA-641922026-06-10T21:16:31ZANGELA—ORTIZ1957-07-23———N/A8747 OAK STREETPHOENIXAZ85041-5582··—OPTIONS-PPO
PRVPRV-242102026-03-19T11:02:13ZLarryI.BanksJan 4, 2006UHC-51013-04•••-••-2852(390) 487-4762—152 Lincoln WayAtlantaGA30367··-null
TPATPA-508302026-04-14T06:54:53ZSantiago—Carter1994-09-01N/AUNKNOWNNULLNULLUNKNOWNnullnull———
CLMCLM-407650 2026-02-20T20:41:10Zaustin—stone·1957-12-23UHC-48905-18-——5773 Cedar LaneMiamiFL33104GRP-7147CHOICE-PLUS-PPO
TPATPA-612832026-03-07T02:19:29ZBYAN—VAZQUEZ2000-06-07--—null9177 Canyon RdSacramentoCA95830····N/A
100,000 rows, page 173 of 2,000PreviousNext

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.710Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty