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-4111782026-02-09T23:51:52ZVICTORIA—PADILLA1952-10-26·uhc-84331-08-15064162948—5959 CANYON RDLas VegasNV89122N/ANULL
CLMCLM-4129382026-02-16T01:10:33ZEMMA—DUNN6/10/1942—•••-••-7546—null9660 Meadow Ln Apt 33San DiegoCA92122—CORE-HMO
ENRENR-1244612026-04-17T01:44:52ZOrtega, DebraY—19981109UHC-53202-94N/A12993726462debra.ortega@aol.com3452 MEADOW LANEORLANDOFLUNKNOWNGRP-9290SELECT-EPO
CLMCLM-4243822026-04-04T10:23:17Z·Richard—Chapman1999-11-01-•••-••-7598+1 831 458 1341—5513 Desert Sky Blvd··PlanoTX—GRP-1016NULL
CLMCLM-4186492026-09-18T00:52:55ZBILLY—WEAVER19530524UHC-92169-35UNKNOWN(653) 802-2577NULL1760 Pine Drive Apt 6SacramentoCA95874GRP-6055—
TPATPA-577362026-01-01T08:13:00ZNICHOLAS—BROOKS·1982-04-20UNKNOWN—-nicholas.brooks@icloud.com9470 BAYSHORE DRIVEFresnoCA93760--
ENRENR-1149392026-08-06T05:36:09ZJeffreyJHawkins·2004-01-09UHC-53749-90•••-••-396917926244151···jeffrey.hawkins61@hotmail.com8662 Camelback RoadSan Diegoca·92137GRP-3814NAVIGATE-HMO
CLMCLM-4102372026-02-26T20:12:42ZWright, Sarah··—Jul 9, 2007UHC-88130-96··-+1 537 421 3025—·3671 Sunset BlvdNASHVILLETN37271GRP-0854-
ENRENR-1423112026-04-18T11:45:42ZKelly—DeanJan 9, 1960UHC-68694-75•••-••-77362293781581kelly.dean@hotmail.com7340 Washington StreetSeattleWA98179GRP-9576MEDICARE-ADV-A
PRV PRV-232592026-09-30T17:33:45ZKennedy, Patricia——17-09-1991---PATRICIA.KENNEDY19@ICLOUD.COM6142 Harbor BoulevardLos AngelesCA90015NULLCHOICE-PLUS-PPO
PRVPRV-245832026-01-21T05:45:40ZDebra··Stone··1984-04-14N/A—(343) 384-6337null··1874 Maple AveAtlantaGeorgia30385—UNKNOWN
ENRENR-1317952026-03-18T04:01:14ZRONALD—HUNT1943-08-08UHC-25904-18NULL+1 613 978 2142ronald.hunt79@hotmail.com8537 Mesa DrivePlano···TX75006GRP-5823·OPTIONS-PPO
ENRENR-107720 2026-02-23T18:17:06ZRALPHRWILLIAMSON7/26/1987UHC-12735-84UNKNOWN+1 480 530 0172ralph.williamson@yahoo.com1667 Palm DriveScottsdaleAZ·85254GRP-8397NAVIGATE-HMO
PRVPRV-224262026-05-15T20:47:05ZNatalie—Medina1972-05-23UHC-72744-31UNKNOWN397.290.0505NATALIE.MEDINA@PROTON.MENULL————N/A
ENRENR-1313272026-02-28T03:26:33ZSAMANTHALROSE1967-01-14UHC7968058•••-••-6075·339.355.3725samantha.rose81@aol.com3541 Pine DrPlanoTX75004GRP-4788NAVIGATE-HMO
PRVPRV-276222026-08-31T21:24:07ZScott—Duncan06-06-1970——201-442-1258SCOTT.DUNCAN35@GMAIL.COM71 Bayshore DrLOS ANGELES···CA90071-—
CLMCLM-4323092026-10-14T18:40:21Z George··MillerDec 18, 1950UHC-23025-90-N/A————-GRP-3360SELECT-EPO
ENRENR-1254132026-01-26T09:49:30ZKatherine M—·Lucas1966-07-23UHC2911596•••-••-0626·436.840.1595NULL6724 Market StAustinTXNULLGRP-1890OPTIONS-PPO
CLMCLM-4152732026-02-20T06:07:36ZKimberly—Marquez1942-05-15-•••-••-03889042302544·KIMBERLY.MARQUEZ@AOL.COM1432 Valley View Dr #146Las VegasNV89170GRP-3132··OPTIONS-PPO
ENRENR-1010112026-07-03T04:26:56ZMichelle···CRomero1977-06-07·UHC1370840•••-••-62686413121NULL923 Church StTampa··FL33681GRP-3195MEDICARE-ADV-B
ENRENR-1013772026-07-05T10:51:24ZDANELLE····PETERSON1988-10-09UHC-45787-62•••-••-06173366219165danielle.peterson@gmail.com5586 LAKE VIEW RDAustinTX78770GRP-7552CHOICE-PLUS-PPO
TPATPA-572372026-06-28T12:36:40ZJudith—OBrien1942-09-19UHC6023299nullN/A··judith.obrien@aol.com3631 Highland AvenueTempeAZ·85233—·MEDICARE-ADV-A
ENR ENR-1241782026-04-30T22:25:20ZJennifer·QRay01-12-2001UHC-14459-04•••-••-6465279-795-6929N/A2114 Jefferson AvenueChandlerAZ85288GRP-5942CORE-HMO
ENRENR-117172 2026-04-20T19:03:10ZPATRICKESCHULTZ2006-05-19UHC-92985-01—4855623762patrick.schultz19@aol.com·9209 OAK STREETAustinTX·78798·GRP-3557CHOICE-PLUS-PPO
TPATPA-570332026-09-26T15:22:50ZWebb, Cynthia——1953-08-22nullNULL—null4802 Hillcrest RdSCOTTSDALEAZnullGRP-6575NULL
CLMCLM-4032942026-01-03T12:24:20ZBILLY—ROBINSON10/12/1984··UHC-48999-54•••-••-9859UNKNOWNNULL8106 Main StTucsonArizona85787—null
TPATPA-565512026-01-01T14:44:04ZRandyB·Meyer1984-07-26UHC3929388UNKNOWN7072619905—2773 MOUNTAIN VIEW DRIVETucsonaz·85753-2859·-null
ENRENR-1167992026-04-29T04:20:38ZKatherineRGrant3/16/1989UHC-46664-54•••-••-5818nullKATHERINE.GRANT@GMAIL.COM7120 PARK PLACECHANDLERAZ·85243GRP-1208MEDICARE-ADV-A
TPATPA-561872026-04-24T14:28:46ZRios, Keith——·08/24/62-NULL(804) 752-6055KEITH.RIOS@OUTLOOK.COM1341 Cedar LnGlendaleAZ85343····OPTIONS-PPO
ENRENR-1275602026-09-26T20:17:27ZRonaldSWilliamson1983-02-23UHC-04062-47•••-••-2224+1 380 922 0573ronald.williamson85@yahoo.com3583 BroadwayNashvilleTN37278-5424GRP-4267·CORE-HMO
CLMCLM-4169012026-06-01T00:30:05Z·Michelle—Andrews24-08-1993UHC-95441-15null237-787-1199··MICHELLE.ANDREWS@ICLOUD.COM6315 Highland AvenueOrlandoFL32874GRP-0188—
PRV PRV-247682026-08-23T15:00:55ZSANDRA··OCAMPBELL1965-04-91—NULL5726450816—8853 Hillcrest RdTampaFL33678——
CLMCLM-4314672026-01-21T06:09:03ZHEATHER—KIM01/04/2006·uhc-33481-45—(631) 858-7406-4203 Harbor BoulevardTempeAZ85255GRP-3229CORE-HMO
PRVPRV-292642026-10-15T12:24:51ZChristine··Wallace1961-08-25UHC-56875-41NULL2527295340UNKNOWN··8665 Camelback RoadEden PrairieMN55309UNKNOWNN/A
ENRENR-1168412026-02-02T02:45:27ZSantiago—Dominguez·1998-11-18—•••-••-31093123935797santiago.dominguez@outlook.com2418 SUNSET BOULEVARD···SEATTLEWA98177GRP-1845MEDICARE-ADV-A
CLMCLM-4025642026-09-19T19:56:22ZJacobAWilson··1965-02-09UHC-87096-71—4539048478NULL1598 Lincoln WayAtlantaga30322GRP-9167navigate-hmo
ENRENR-1052182026-05-22T08:45:33ZKnight, Justin——1998-02-03··UHC-81943-51•••-••-47267134918314JUSTIN.KNIGHT81@YAHOO.COM2710 Cedar LaneCharlotteNC28272GRP-0580MEDICARE-ADV-B
ENRENR-1015402026-06-06T16:15:48ZHernandez, Daniel——1991-03-02UHC-23992-53•••-••-2209(677) 384-0337NULL6493 PINE DRCharlotteNC—GRP-8312OPTIONS-PPO
CLM CLM-4306512026-07-22T12:03:32ZGeorge—Hughes1957-09-12UHC-74485-63NULL(583) 720-5436··—2144 Hillcrest RdSan DiegoCA·92144GRP-8549OPTIONS-PPO
ENRENR-1193822026-10-04T20:29:21ZDONNA·FHUDSON1977-05-12UHC-54328-52•••-••-5970278-646-8077·DONNA.HUDSON@ICLOUD.COM1234 Sage CourtSEATTLEwa98185GRP-9747CHOICE-PLUS-PPO
CLMCLM-4205712026-02-14T11:11:37ZLINDA—MCDONALD1980-04-09UNKNOWN··•••-••-778316556550558—6056 Highland AvenueAtlantaGA30385GRP-7982·UNKNOWN
ENRENR-1180602026-04-14T05:25:14ZAlice—Moore19610701UHC-34995-20NULL12615822785·····6180 Lake View RdDenverCO80227GRP-6444CORE-HMO
ENRENR-1377702026-09-06T19:54:16ZJunathanMSnyder1967-03-07UHC-98421-67•••-••-4675972.229.8767JONATHAN.SNYDER@AOL.COM7183 Lake View RdColumbusOH43257GRP-1920MEDICARE-ADV-A
CLMCLM-4077592026-09-02T13:27:23ZDaniel··—Wang01-08-1963UHC3061560N/A+1 212 371 8667—1901 Valley View Dr·DENVER·CO80235GRP-8194SELECT-EPO
ENRENR-1096062026-07-15T02:42:17ZCAROLYN—MORALES1953-04-20UHC-97852-59•••-••-5057(963) 507-4445carolyn.morales@proton.me395 Church StAustinTexasnullGRP-5329CHOICE-PLUS-PPO
ENRENR-1010772026-04-05T18:02:41Zhelen—miller2000-10-25UHC-64897-38•••-••-2068(386) 659-4456helen.miller83@outlook.com4779 SUNSET BOULEVARDEden PrairieMN55352GRP-6252NAVIGATE-HMO
ENRENR-1342222026-05-03T21:41:56ZArnold, Janet——0410-19-96UHC-22906-03•••-••-0590938.923.9146·JANET.ARNOLD@ICLOUD.COM1157 Main StreetTempe··AZ85227··GRP-7671MEDICARE-ADV-B
CLMCLM-4214352026-05-06T16:52:27ZBetty—Nguyen1970-04-07null·UNKNOWN(516) 607-3683NULL———nullGRP-5685-
ENRENR-1081212026-01-12T07:08:27ZSimmons, Nicholas——Sep 28, 1971UHC-65254-29•••-••-9792487-847-2857nicholas.simmons@aol.com1270 Grand AvenueSan AntonioTX78298GRP-3581CORE-HMO
CLMCLM-4023812026-06-23T21:02:46ZalanOgarza1955-01-28UHC-67562-83•••-••-7355(473) 915-9766-8771 Canyon RoadPhoenixaz85074GRP-6668MEDICARE-ADV-A
100,000 rows, page 213 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:37.727Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty