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-1172372026-08-08T14:00:49ZRANDYE··CAMPBELL1993-02-28UHC-32395-41•••-••-74169172610930randy.campbell@icloud.com3768 Maple AvenueTAMPAFL33608GRP-5405··CORE-HMO
ENRENR-1056482026-08-25T18:23:32ZAlan—Hughes08/02/1999UHC-66937-28•••-••-42672263422473alan.hughes21@yahoo.com7184 HIGHLAND AVENUEGlendaleAZ··85369GRP-8976CORE-HMO
ENRENR-1180382026-05-13T02:46:54ZNicole—Fisher—UHC-63867-60•••-••-9043·346.344.4500nicole.fisher@proton.me7671 Palm DrTucson··AZ85793GRP-8921CORE-HMO
ENRENR-1136522026-08-08T03:26:57ZLucia—·Owens1974-11-22UHC-52968-42•••-••-99709672899100LUCIA.OWENS@HOTMAIL.COM2627 Desert Sky BlvdSCOTTSDALEAZ85240GRP-3183CHOICE-PLUS-PPO
ENRENR-1228822026-03-14T20:34:11ZJesseV.Herrera1960-04-12UHC-67077-73•••-••-75312222791894·JESSE.HERRERA@ICLOUD.COM2224 Union StreetSeattleWA98197GRP-6861MEDICARE-ADV-B
ENRENR-1166402026-01-17T05:26:02ZEricRPierce2011-20-03UHC-40910-11•••-••-7822nulleric.pierce83@gmail.com6563 SAGE COURTCHANDLERAZ85292GRP-2043MEDICARE-ADV-A
ENRENR-1324692026-02-16T02:47:02ZTHERESAA.PADILLA1944-12-07UHC-76628-92•••-••-0949NULLtheresa.padilla@outlook.com5793 Hillcrest Rd Apt 3ColumbusOHnullGRP-6656··OPTIONS-PPO
ENRENR-1078062026-10-14T18:53:56Z Maria—Daniels1982-10-09UHC-72420-88—988-275-1065—5183 Sunset BlvdFresnoCA93783GRP-0817MEDICARE-ADV-A
ENRENR-1210482026-09-02T12:48:50ZCHRISTINE·CHARVEY·1997-03-09UHC-40603-08•••-••-0673379.326.1896christine.harvey@outlook.com141 Apache Boulevard··TucsonAZ85753GRP-2866CHOICE-PLUS-PPO
ENRENR-1427482026-07-28T19:20:43ZVirginiaMLewsi12/11/1993UHC-57113-59-628-636-1711UNKNOWN5768 Forest AveFresnoCA93787GRP-9107MEDICARE-ADV-A
ENRENR-1424912026-02-24T02:26:36ZAMY··LSANCHEZ1972-07-02UHC-63205-92NULL4658717286AMY.SANCHEZ93@YAHOO.COM7045 DESERT SKY BOULEVARDSacramentoCA95892GRP-2838CORE-HMO
ENRENR-1163992026-06-20T15:10:00ZAustinRGrant1998-01-03··UHC4859016•••-••-71732462057098austin.grant@yahoo.com4761 River Rd Apt 2HoustonTX77049GRP-9912··NAVIGATE-HMO
ENRENR-1021632026-03-11T03:37:52ZTimothyW··CarpenterFeb 1, 1991N/AUNKNOWN949-509-1317··TIMOTHY.CARPENTER7@GMAIL.COM·9850 Mesa DrSan AntonioTX78252-7600GRP-8336OPTIONS-PPO
ENRENR-1155862026-07-16T18:45:59Zaaron—sandoval2006-04-13UHC-29436-35•••-••-6372(720) 567-4403NULL··8939 Valley View DriveJacksonvilleFL··32220GRP-6730NAVIGATE-HMO
ENRENR-1143262026-08-15T21:55:41ZChavezDDouglas2007-11-20··UHC-61707-44•••-••-4107·(403) 592-4423douglas.chavez@aol.com2683 Palm DrPlanoTX75053GRP-4334OPTIONS-PPO
ENRENR-1195632026-06-06T22:12:24ZWeiIRomero1986-01-19UHC-06004-43•••-••-0437·2228584516wei.romero22@icloud.com8922 WILLOW CTScottsdaleAZ85280GRP-4394MEDICARE-ADV-A
ENRENR-1390182026-08-14T13:41:02ZJERRY··—FREEMAN1959-01-28UHC-67528-45•••-••-29528875586339null2241 Canyon RdLAS VEGASNV··89166GRP-9756OPTIONS-PPO
ENRENR-1179652026-01-19T00:27:48ZSANTIAGON.HUDSON09/25/1951UHC-21919-41··282-754-6907santiago.hudson26@proton.me6607 MEADOW LNHoustonTX··77077GRP-9034CHOICE-PLUS-PPO
ENRENR-1210992026-01-20T14:14:18ZCHERILIROSE19980822UHC-60983-94•••-••-6251—cheryl.rose@hotmail.com1514 CHURCH STREETHOUSTON·TX77017GRP-8401MEDICARE-ADV-B
ENRENR-1362592026-03-12T12:41:40ZHAROD—WALKER1957-04-10UHC-67930-06•••-••-5746663.571.1748harold.walker47@gmail.com406 Hillcrest RdTempeAZ85250GRP-8274NAVIGATE-HMO
ENRENR-1085452026-09-03T11:42:24ZJSESEUPIERCE1960-02-11UHC-50645-43•••-••-6702(443) 909-3185jesse.pierce21@gmail.com·8153 BroadwayLas VegasNV89190GRP-5358MEDICARE-ADV-A
ENRENR-1140592026-10-02T02:45:42Z·Reynolds, Diana——1970-07-19UHC3227244UNKNOWN9379063652··DIANA.REYNOLDS@HOTMAIL.COM6536 LAKE VIEW RDFresnoca··93700GRP-5677··OPTIONS-PPO
ENRENR-1351652026-09-16T17:05:55ZAnthony—Fox1976-04-21UHC-66246-41•••-••-2559582-686-7633ANTHONY.FOX@AOL.COM4923 Church StPlanoTX75023GRP-6907CHOICE-PLUS-PPO
ENRENR-1241742026-02-25T22:48:33ZPHILIP····LARSON1953-11-19UHC-32280-28•••-••-4148460.946.5524PHILIP.LARSON@PROTON.ME5533 Market StreetTucsonAZ85703-4655GRP-8145CHOICE-PLUS-PPO
ENRENR-1384282026-09-01T18:26:11ZAnn—Sims1992-02-16UHC8490939•••-••-4006402-950-7313ann.sims28@icloud.com2701 Pine DrGilbertAZ—GRP-9011NAVIGATE-HMO
ENRENR-1076492026-05-27T23:35:50ZRACHELG.LONG1987-01-10·UHC-19067-72•••-••-2064353-722-4817rachel.long76@icloud.com1076 River Road Apt 12MesaAZ-GRP-6243CORE-HMO
ENRENR-1298972026-10-04T14:43:20ZTimothyTButler2006-02-24UHC-21650-45•••-••-42563862237626timothy.butler19@gmail.com4267 CHURCH STSEATTLEWA98157GRP-5636MEDICARE-ADV-A
ENRENR-1234482026-08-02T09:52:56ZHenry—Austin05/03/04UHC-64407-01•••-••-8292936.769.4293henry.austin99@hotmail.com··535 Sage CourtTampaFL33671·GRP-1227·MEDICARE-ADV-B
ENRENR-1352452026-06-30T05:33:50Z Justin—Salazar2000-10-21UHC-48165-59•••-••-0047+1 412 379 4664null5286 Main StMinneapolismn55414-6774GRP-0698CORE-HMO
ENRENR-1259302026-08-23T00:02:27ZshirleyH.fuller12/03/49UHC1380810—17165413300shirley.fuller@aol.com2023 Highland AvenueFresnoCA93748-8321GRP-4756··MEDICARE-ADV-A
ENRENR-1020572026-07-05T23:18:27ZHANNAH—COLEMAN1957-12-14UHC-98061-34•••-••-3046881.734.6540··hannah.coleman59@outlook.com295 DESERT SKY BOULEVARDMinneapolisMN55409·GRP-7057MEDICARE-ADV-A
ENRENR-1105242026-09-13T06:24:37ZFernandez, AsheyO.—2003-03-19UHC-00933-59•••-••-8097(377) 685-0003·ashley.fernandez68@outlook.com6961 Lake View Road Apt 31FresnoCA93793GRP-2459CHOICE-PLUS-PPO
ENRENR-1411792026-09-12T07:10:28ZRobinson, Christine——1972-06-05UHC-30697-65•••-••-1613513-371-9111christine.robinson89@outlook.com9172 Meadow LnLas VegasNV89111GRP-3877NAVIGATE-HMO
ENRENR-1124682026-05-16T11:42:30ZJACKZMENDOZA1978-09-13UHC-85398-59•••-••-6328-JACK.MENDOZA@YAHOO.COM6468 CAMELBACK RDCHANDLERAZ85243-4534GRP-0464NAVIGATE-HMO··
ENRENR-1154102026-05-16T15:44:38ZGREGORYTHARPER1950-12-20·UHC-80986-61•••-••-36075295128998gregory.harper44@outlook.com3135 WILLOW COURTSacramentoCA95809-2851··GRP-7093CORE-HMO
ENRENR-1207582026-06-28T00:25:46ZGerogeFSalazar1959-01-03UHC-05285-32•••-••-3333(779) 405-8397·UNKNOWN1928 Palm DrSan Antonio··TX78272·GRP-8781OPTIONS-PPO
ENRENR-1186142026-03-21T10:50:51ZNATHANW.··HUDSON19681107UHC-52176-20•••-••-91156234399117nathan.hudson@icloud.com432 Main St·AtlantaGA30373GRP-0312MEDICARE-ADV-A
ENRENR-1376852026-02-07T10:22:51ZLoriP.Simpson1941-10-25UHC-23112-10•••-••-22266165750709lori.simpson33@outlook.com1352 CEDAR LN Apt 7AustinTexas78765GRP-3475CORE-HMO
ENRENR-1035382026-06-22T21:47:47ZHENRYTMILLER·1942-02-17UHC-16895-11N/A8569658872henry.miller@aol.com9028 SPRING STREETColumbusOH43294GRP-4087CHOICE-PLUS-PPO
ENRENR-1109212026-04-22T11:22:27ZDebra—Fuller1993-07-20UHC-42995-06··-568-983-3222—4128 MOUNTAIN VIEW DRChandlerAZ85223GRP-9688OPTIONS-PPO
ENRENR-1215382026-08-05T17:44:19Z LauraCPerez1961-02-26UHC-48980-78N/A677-468-5000—·4678 Bayshore DrDallasTX75288GRP-3289·OPTIONS-PPO
ENRENR-1389162026-06-14T12:42:14ZJERRYUCHEN19480504—•••-••-6392NULLjerry.chen62@icloud.com5108 Maple AveOrlandoFL32812GRP-3109CHOICE-PLUS-PPO
ENRENR-1327202026-09-09T19:40:38ZWayne—·OBrieen·01/20/73UHC-06710-35•••-••-276414597804684WAYNE.OBRIEN@GMAIL.COM1154 MOUNTAIN VIEW DRDENVERCO80293-4531GRP-2838CORE-HMO
ENRENR-131740 2026-08-24T04:52:40ZAISHAPWALKER1952-12-22UHC-06107-12•••-••-260313002560759aisha.walker@proton.me7821 Ocean AvenueAtlantaGA·30305GRP-6093OPTIONS-PPO
ENRENR-1172712026-05-06T12:19:19ZJERRYCRAMIREZ1968-11-21UHC-59013-51•••-••-5376344.644.6705jerry.ramirez82@proton.me··3215 Forest Ave·AustinTX78790GRP-7197CHOICE-PLUS-PPO
ENRENR-1074712026-02-03T23:53:08ZPAMELAO.FULLER2006-09-01UHC3460858null5995254923pamela.fuller52@hotmail.com4097 Desert Sky BlvdDenverCO80220GRP-3869MEDICARE-ADV-B
ENR ENR-1245362026-02-11T04:41:47ZPETERE.GRAY1964-10-26UHC-04342-32•••-••-9434337-607-9810NULL3465 Church StreetGLENDALEAZ·85332GRP-0579MEDICARE-ADV-B
ENRENR-1398382026-07-31T23:15:11ZSANTIAGO··PALMER2008-12-05UHC-36429-45•••-••-7550878-284-3984UNKNOWN9709 Ridge RdNashvilleTN37258GRP-2779SELECT-EPO
ENRENR-1193622026-08-27T00:04:19Zsofia—stone07/25/57UHC-26887-79•••-••-39904694220762sofia.stone18@hotmail.com9671 HIGHLAND AVE··TucsonAZ85724GRP-6316OPTIONS-PPO
ENRENR-120873 2026-08-21T13:58:40ZLaurenE.·Davis1980-12-09UHC-50623-59•••-••-8341792-339-3453LAUREN.DAVIS37@HOTMAIL.COM3712 MAIN STREETColumbusoh43293-1508GRP-7458NAVIGATE-HMO··
43,101 rows, page 125 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:37.766Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty