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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-138928 2026-01-23T22:15:25ZDiane—Santos10/21/1953uhc-33702-74•••-••-4870(596) 814-8239diane.santos95@aol.com7033 Highland AvenueLos AngelesCA90085GRP-7328CORE-HMO
ENRENR-1128582026-01-16T12:31:36ZFrancesP.Park1989-03-11UHC-19056-35-6772472946FRANCES.PARK87@HOTMAIL.COM4370 DESERT SKY BOULEVARDSan DiegoCA92152GRP-6996OPTIONS-PPO
ENRENR-1306772026-03-31T18:24:10Z amberUwillis1990-08-08··UHC-07211-06•••-••-1279804-943-2313NULL9561 Mountain View DrSacramento··CA95848GRP-1948SELECT-EPO
ENRENR-1111842026-09-18T08:36:05ZLauren—Green06/15/1960UHC-54175-26•••-••-24596364516835lauren.green91@yahoo.com8367 BAYSHORE DROrlandoFL32855GRP-4766CHOICE-PLUS-PPO
ENRENR-110792 2026-03-24T06:28:30ZJoshuaP.Dunn04/20/57UHC-21385-42•••-••-458617145359909joshua.dunn@aol.com4674 BroadwayTucsonArizona85776GRP-8136MEDICARE-ADV-B
ENRENR-1173132026-09-07T15:28:30ZChristian—RogersSep 13, 1938·UHC-98160-36•••-••-49819252559574CHRISTIAN.ROGERS63@AOL.COM5617 MESA DRIVETampaFL33610-8508GRP-5262CORE-HMO
ENRENR-1052652026-07-25T00:31:26ZSteven·KGuzman··2001-11-20-•••-••-3890+1 676 225 8210N/A6461 MESA DRIVELAS VEGASNV89120GRP-8953MEDICARE-ADV-A
ENRENR-1128272026-02-12T07:03:31ZMEGAN····REED20051111UHC-55099-86•••-••-86602428131623megan.reed17@proton.me8402 Mesa DriveSacramento··California95812GRP-1069SELECT-EPO
ENRENR-1136492026-09-04T12:28:38ZRogerMMcDonald1945-07-11UHC-13355-77•••-••-34743053638748roger.mcdonald3@yahoo.com2896 Forest AvenueDenverCO80255··GRP-3100NAVIGATE-HMO
ENRENR-1382352026-05-22T13:06:05ZJack·M.Myers19440924UHC-71455-41•••-••-2723734-236-2890jack.myers@outlook.com··8322 Church StSeattleWA98161·GRP-7051OPTIONS-PPO
ENRENR-1428442026-02-20T18:27:26ZSteve—Vega1991-10-06UHC-24111-06•••-••-7287589-836-6080·steven.vega@outlook.com4935 Central AvenueLas VegasNV89151GRP-1062OPTIONS-PPO
ENRENR-1362692026-08-25T18:35:44ZBRADLEYPGILBERT1985-10-09UHC7672884•••-••-1964701-894-8607bradley.gilbert31@hotmail.com·3443 OAK STGlendaleArizona85334GRP-9086MEDICARE-ADV-B
ENRENR-1317152026-07-31T04:13:34ZJOYCEL.WALKER1951-04-10UHC-58752-20•••-••-159415439218373joyce.walker41@hotmail.com··8654 Jefferson AveLos Angelesca·90020GRP-2038MEDICARE-ADV-B
ENR ENR-1261112026-02-04T15:52:40ZCrolGGarrett1971-01-17UHC6590292•••-••-6981(907) 652-5042··carol.garrett@aol.com1631 River RdTEMPEAZ85213-0027GRP-3890SELECT-EPO
ENRENR-1047402026-03-10T04:31:42ZRebeccaQWilliams1972-11-15UHC-01047-48•••-••-3999418-696-6872REBECCA.WILLIAMS29@YAHOO.COM5115 Elm StDallasTX75257GRP-0594NAVIGATE-HMO
ENRENR-1416022026-07-27T11:58:49ZRANDYGSOTO··1976-10-12uhc-71386-98•••-••-96124938157366-N/A—N/A-GRP-1461CHOICE-PLUS-PPO
ENRENR-1340822026-04-17T09:55:45ZMelissa S.—Hicks·Jan 18, 1954UHC-05893-60•••-••-2293785-375-4493melissa.hicks73@outlook.com8011 Central AveTEMPE·Arizona85266GRP-3530NAVIGATE-HMO
ENRENR-105632 2026-08-30T02:12:23ZHelen—McCoy1999-07-23uhc-48762-31•••-••-2456(375) 952-2691HELEN.MCCOY44@ICLOUD.COM858 Market StTampa···FloridanullGRP-1536MEDICARE-ADV-A
ENRENR-1125152026-04-18T14:54:30ZGarrett, Adam····—12/1/1986UHC-27878-40•••-••-7008—adam.garrett@aol.com1633 Palm DrLos AngelesCA90078-5535GRP-3997SELECT-EPO
ENRENR-1129572026-06-01T00:25:40ZBRITTANY—RICHARDSONOct 5, 1997UHC-79106-17•••-••-40255088088204—7009 Bayshore DrMinneapolisMN55482GRP-4911OPTIONS-PPO
ENRENR-1222462026-10-12T21:34:59ZPAULU.LAWSON04/09/05···UHC-29000-24N/A13639530976PAUL.LAWSON@OUTLOOK.COM2360 Mesa Drive·Eden PrairieMN55372GRP-7253CHOICE-PLUS-PPO
ENRENR-1343632026-04-13T07:28:17ZNathan··Mendoza2004-08-10··UHC-18219-11•••-••-30518696064665nathan.mendoza@yahoo.com1975 Mountain View DriveMiamiFL33120-4523·GRP-5787MEDICARE-ADV-A
ENRENR-138913 2026-07-10T11:08:34ZKevinBBurton2/28/1974··UHC-40231-03•••-••-42118846081503KEVIN.BURTON96@AOL.COM2103 FOREST AVETAMPAFL33656GRP-6733SELECT-EPO
ENRENR-1244732026-07-01T08:12:27ZEdwardJ.Stone2000-01-07—•••-••-1738——7743 Jefferson AvenueOrlandoFL32819GRP-9478·OPTIONS-PPO
ENRENR-1095792026-06-15T15:15:01ZMadisonOGarrett1942-04-18UHC-53981-25•••-••-0385327.641.4185MADISON.GARRETT67@OUTLOOK.COM8801 Desert Sky BlvdDallasTX75229GRP-4856MEDICARE-ADV-B
ENRENR-1358542026-10-11T10:50:17ZJOAN—·GRAY02/15/73UHC-12802-83•••-••-158419429561437joan.gray25@outlook.com8322 Ridge RdColumbusOH43218GRP-4156CORE-HMO
ENRENR-1012682026-07-17T08:11:26ZJoan··Singh1960-03-25UHC-03484-76··•••-••-9133724-891-9613null5676 Palm Drive #496EDEN PRAIRIEMN55317-1886GRP-2122CHOICE-PLUS-PPO
ENRENR-1354192026-03-15T12:33:10Z·PAMELA—LARSON15-02-1972UHC-93705-75•••-••-9740+1 673 755 6806pamela.larson21@outlook.com5652 Broadway #392TampaFL33658GRP-0234·MEDICARE-ADV-B
ENRENR-1151472026-04-13T07:11:43ZHarold—Coleman1981-01-25UHC-70461-01•••-••-8798(301) 974-8043harold.coleman@hotmail.com9830 Hillcrest RoadAustinTX··78717GRP-5161CORE-HMO
ENRENR-1059802026-01-20T18:36:25ZTimothyMTran1958-04-25UHC-04978-95null465-764-5355UNKNOWN5906 APACHE BOULEVARDGlendaleAZ85384GRP-2761CORE-HMO
ENRENR-1271732026-09-02T02:24:09ZEmmaSGriffin1961-04-16UHC-91839-84UNKNOWN988-868-6331emma.griffin@proton.me6820 HILLCREST ROADLos AngelesCA90022-2678GRP-5144NAVIGATE-HMO
ENRENR-1120212026-06-03T09:38:30Z Jackson, Ana——1950-11-11UHC-49207-26•••-••-44585348613124··NULL9519 Indian School RoadTUCSONAZ85768GRP-1765SELECT-EPO··
ENRENR-1077452026-05-03T04:32:57ZHunt, Stephanie——10/16/38UHC-49424-93··-4562020786·UNKNOWN1688 GRAND AVENUESan DiegoCA92143GRP-6011CORE-HMO
ENRENR-1405172026-01-12T10:43:31ZKATHERINE—GONZALEZ1958-10-26UHC-99110-29•••-••-07684764510371KATHERINE.GONZALEZ@YAHOO.COM3627 HIGHLAND AVETampaFL33637GRP-8710NAVIGATE-HMO
ENRENR-1074732026-05-15T09:11:55ZOLIVIA—CHAVEZ01/15/73UHC-71126-91•••-••-2985(615) 662-8928··olivia.chavez21@outlook.com5964 Meadow LnAtlantaGeorgia30371GRP-8530MEDICARE-ADV-B
ENRENR-1175942026-10-03T06:56:49ZJORDAN—ALVARADO03/12/1984UHC-21426-35•••-••-8611——4827 Lake View RoadFresno·CA93725-7231GRP-6733CORE-HMO
ENRENR-1113412026-05-11T12:52:41ZRobertK.·Palmer1968-04-05UHC-10171-50··•••-••-2325—-9175 Maple Ave Apt 4OrlandoFL··32873GRP-2883MEDICARE-ADV-B··
ENRENR-1264912026-07-10T18:41:01ZGabriel—Andrews·1952-08-17UHC-06638-96•••-••-780518406479207N/A816 MESA DRMESAAZ85266GRP-8802OPTIONS-PPO
ENRENR-1154912026-09-09T02:39:21ZALBERTN.·GUZMAN1968-01-08UHC3454949—4009229853ALBERT.GUZMAN73@YAHOO.COM2821 Highland AvenueGlendale··AZ··—GRP-0286OPTIONS-PPO
ENRENR-1034272026-09-14T17:31:30ZkellyUlittle1942-11-21UHC2994937•••-••-16394801857-5921 Spring StJACKSONVILLEFL32293GRP-6696NAVIGATE-HMO··
ENRENR-1354312026-09-17T06:47:29ZSusanBPrry1982-01-01UHC-81329-96•••-••-8128433-908-3741susan.perry56@yahoo.com4635 Main StTampaFL33645GRP-4676MEDICARE-ADV-A
ENRENR-1018702026-07-13T04:02:17ZMelissaDCruz·9/15/1996UHC-43441-53UNKNOWN(722) 467-3408melissa.cruz@gmail.com8804 Mesa DriveGilbertAZ85249GRP-8548options-ppo
ENRENR-1146372026-09-04T17:43:11ZCamilaZ.Roberts1987-10-16UHC-48203-37•••-••-48747609570632camila.roberts69@proton.me95 BAYSHORE DRIVESCOTTSDALEAZ85288GRP-1597MEDICARE-ADV-B
ENRENR-1396642026-09-16T13:34:34ZAishaR·Gray1983-12-18·UHC6607828•••-••-4588712.942.1644—8462 Main Street·MinneapolisMN55488GRP-0622NAVIGATE-HMO
ENRENR-114959 2026-08-08T20:33:48ZGREGORY—SALAZAR3/17/1955UHC-54013-72•••-••-19613938067388gregory.salazar97@outlook.com5228 Harbor BoulevardLos AngelesCA·90079GRP-1780OPTIONS-PPO
ENRENR-1110672026-04-13T15:19:19ZKaren····Wells1989-06-21·UHC1591351•••-••-8418730-664-7348karen.wells@outlook.com3908 SUNSET BLVDNashvilleTN37236GRP-6397NAVIGATE-HMO
ENRENR-111835 2026-09-13T08:02:06ZPatrick—Lewis1979-06-05UHC-15634-12•••-••-9612(618) 423-4663-4359 Forest AvenueNashvilleTN37277GRP-7617·NAVIGATE-HMO
ENRENR-1021422026-03-05T07:18:12ZARJUNQKING1960-06-07UHC-56570-64•••-••-60465037507155arjun.king@gmail.com5823 Highland AvenueGilbertAZ·85266GRP-3249··OPTIONS-PPO
ENRENR-1296142026-10-10T02:35:14Z JulieCRan2001-03-26UHC-73740-43•••-••-6201754.233.3896NULL9125 Bayshore DrGilbertAZ85295GRP-4965SELECT-EPO
ENRENR-1272222026-01-15T03:24:05ZDENNIST.TORRES1989-07-28·UHC-67334-94•••-••-2763514-426-5239UNKNOWN8678 Highland AveFresnoCA93732GRP-5981OPTIONS-PPO
43,101 rows, page 194 of 863PreviousNext

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