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-1305632026-01-22T01:56:17ZAMBERNLAWRENCE1978-04-18UHC-53728-11•••-••-0731N/AAMBER.LAWRENCE@OUTLOOK.COM1461 Bayshore DriveFresnoCA93794GRP-1219··MEDICARE-ADV-B
ENRENR-1369632026-02-06T15:35:15Z matthew—sandoval02/01/1956UHC-42875-42•••-••-2940(806) 563-3752··7835 CEDAR LNAustin··TX78786GRP-6562MEDICARE-ADV-B
ENRENR-1381042026-04-14T10:32:46ZMARGAREET··STEWART04/20/78UHC-19455-68··(620) 906-8342MARGARET.STEWART@OUTLOOK.COM3045 Willow CtPhoenixAZ85088GRP-9064MEDICARE-ADV-A
ENRENR-133995 2026-04-11T07:47:19ZJessicaEPierce·Jan 22, 1997UHC-58153-46•••-••-0213N/AJESSICA.PIERCE25@ICLOUD.COMNULL—null—GRP-8684CHOICE-PLUS-PPO
ENRENR-1179702026-07-11T05:59:38ZBryn—Ferguson1977-11-06UHC5113440•••-••-5297N/Abryan.ferguson43@outlook.com323 Lincoln WayTampaFlorida33643GRP-2075CHOICE-PLUS-PPO
ENRENR-1080012026-05-24T20:24:06ZFields, LindaV—10/11/1968UHC-49146-78•••-••-0857909-707-3704—·1120 Pine DrivePHOENIXAZ85081-4932GRP-1222MEDICARE-ADV-B
ENRENR-1127362026-06-05T04:05:32ZJamesBAguilar1996-05-17UHC-01258-69•••-••-2209411.732.5497null6531 MEADOW LANEGlendaleAZ85395·GRP-9755SELECT-EPO
ENRENR-1321062026-04-05T02:12:44Z·Alexis—·Graham2008-10-24UHC-73092-99•••-••-204314774245420··null7422 Willow CtMesaAZ85237GRP-5655OPTIONS-PPO
ENRENR-1222292026-05-23T19:49:44ZJoshuaGWatsunDec 12, 1984UHC6289670•••-••-7824(301) 860-1747-7627 Highland AvenueCHANDLERAZ85204-7041GRP-5921NAVIGATE-HMO
ENRENR-1185222026-07-13T11:57:19ZMATTHEW—SULLIVAN3/27/1959UHC-21478-31•••-••-9308(576) 701-4173null1146 Indian School Road Apt 1GLENDALEAZ·NULLGRP-5072medicare-adv-b
ENRENR-1380492026-07-24T08:50:00ZBradley··R.Reyes04/02/1964UHC-09729-29null266-381-3251—6270 Canyon RoadFresnoCA93744GRP-7391MEDICARE-ADV-B
ENRENR-1043822026-01-22T00:47:05ZBRANDON—BURKEDec 18, 1978UHC-96135-51•••-••-2860+1 218 982 4790-7916 Meadow LaneGilbertAZ85271GRP-0548OPTIONS-PPO
ENRENR-1387872026-05-06T18:19:44ZALEXISN.··ARMSTRONG2004-09-05UHC-43400-99•••-••-1658(456) 603-3923alexis.armstrong91@icloud.com9668 Lincoln WayScottsdaleAZ85212-5619·GRP-8255CHOICE-PLUS-PPO
ENRENR-1306782026-08-11T15:14:54ZAmber—Willis··19900880UHC-07211-06•••-••-12798049432313amber.willis70@outlook.com9561 Mountain View Dr···SacramentoCA·95848GRP-1948SELECT-EPO
ENRENR-125076 2026-01-06T10:52:53ZNATALIENRMAOS··4/23/1958UHC5443424•••-••-1587—natalie.ramos89@outlook.com7803 WASHINGTON ST·PhoenixAZ85046GRP-4248MEDICARE-ADV-B
ENRENR-134320 2026-06-05T07:01:52ZJordanQSalazarMar 24, 1941UHC-76563-01··•••-••-624719665089533—3003 Camelback RdScottsdaleAZ85242··GRP-5662OPTIONS-PPO
ENRENR-102600 2026-01-01T10:48:34Zbryan—davis19600909UHC-83339-25•••-••-8050(278) 799-2735bryan.davis35@hotmail.com6748 River RoadAustinTX78755GRP-1331MEDICARE-ADV-B
ENRENR-1377652026-05-26T09:16:15ZBillyZ.Vargas10/23/1955UHC5586583··•••-••-0864(314) 419-2218BILLY.VARGAS@ICLOUD.COM4649 SAGE COURTSAN ANTONIOTX78278··GRP-9643NAVIGATE-HMO
ENRENR-1242802026-01-11T23:01:47ZbruceS.dunn··1962-11-25UHC-09543-24•••-••-97876733786713bruce.dunn@icloud.com805 Grand AvenueGILBERTAZ85235GRP-8098CHOICE-PLUS-PPO
ENRENR-1320632026-10-09T09:29:56ZELIJAH—CLARK1945-08-06UHC-88160-82•••-••-3887(740) 963-6047elijah.clark@hotmail.com1361 Desert Sky BoulevardEden PrairieMN55362GRP-4244CORE-HMO
ENRENR-1232522026-08-17T02:51:02ZJESSICA—ARMSTRONG2003-10-26UHC-93452-87•••-••-2792+1 688 534 7508··JESSICA.ARMSTRONG@ICLOUD.COM····null-—GRP-7672MEDICARE-ADV-B
ENRENR-1237182026-03-23T04:32:25ZAlanR.·Duncan1974-03-18UHC-33937-60•••-••-3981605-431-2076alan.duncan74@gmail.com5209 Sunset BlvdNashvilleTN37222-8885GRP-2502CHOICE-PLUS-PPO
ENRENR-1249102026-03-15T11:06:37ZCAMILA—KELLEY1964-06-15UHC-72531-64•••-••-442913328715388camila.kelley@icloud.com3227 Desert Sky BlvdMIAMIFL33182GRP-1509·CORE-HMO
ENRENR-1070172026-09-28T08:47:43ZAlbert·JLi1973-10-24UHC-19977-98•••-••-89529639072435albert.li93@outlook.com1364 PARK PLCharlotteNorth CarolinaUNKNOWNGRP-2188CHOICE-PLUS-PPO
ENRENR-1292732026-05-13T09:38:17ZETHANJ.OLIVERNov 5, 1938uhc-62085-27•••-••-9206219-328-9700—646 Ridge RdSacramentoCA95800GRP-0273OPTIONS-PPO
ENRENR-1178672026-08-01T03:41:59ZDeborahU.Wheeler19670110UHC-06112-10•••-••-4579nullNULL1852 VALLEY VIEW DRIVELas VegasNV89116GRP-6600CORE-HMO
ENRENR-1301122026-01-01T08:10:46ZSaandra—HernandezAug 13, 1985NULL•••-••-36982518417342····8229 Market Street·Houstontx77091·GRP-5515CORE-HMO
ENRENR-1380162026-06-07T15:36:45ZMasonA.Perkins1994-10-14UHC-30649-64N/A(383) 989-0583mason.perkins@outlook.com9500 Apache BlvdOrlando·FL32833GRP-6708CHOICE-PLUS-PPO
ENRENR-1262512026-03-03T23:26:23ZCharlesKBaker05/09/79UHC-20459-98•••-••-7102730-628-9105charles.baker5@proton.me784 Park PlaceTucson·Arizona85705GRP-3314SELECT-EPO
ENRENR-1358122026-08-13T14:13:09Zlisa—obrienOct 24, 2004UHC-77989-41•••-••-375819677505355null3140 Lake View RoadTucson·AZ85730GRP-0116NAVIGATE-HMO
ENRENR-1218802026-01-08T11:58:36ZOLIVIAY.SIMS2004-05-23uhc-02622-39•••-••-3931553-473-2145olivia.sims@hotmail.com1854 Elm StMesaAZ85225GRP-2878CORE-HMO
ENRENR-1299782026-03-10T15:00:58ZDENNISGMOORE2005-12-23·UHC-56195-86•••-••-03332743862735-4899 Main StreetChandlerAZ85249GRP-7077MEDICARE-ADV-A
ENRENR-1412332026-03-29T06:18:28ZArnold, GabrielY.—1960-03-04UHC3116302•••-••-3414—gabriel.arnold@icloud.com1148 Canyon RdSan AntonioTX78263-1144GRP-6137CORE-HMO
ENRENR-1233292026-09-10T10:06:42ZLori—Contreras1964-02-14UHC-34891-72•••-••-332618594720235—5981 Maple AveDALLASTX75273GRP-2666MEDICARE-ADV-B
ENRENR-1109192026-08-26T22:25:06ZGuerrero, Carolyn··Q—1958-04-17UHC-58494-83•••-••-7884(735) 979-5535carolyn.guerrero86@icloud.com1751 Baseline RoadSacramentoCA95840GRP-2942CHOICE-PLUS-PPO
ENRENR-135433 2026-08-17T04:38:00ZJOE—DEAN2006-12-13UHC-39253-08•••-••-7908UNKNOWNjoe.dean76@icloud.com2090 Ridge RdPhoenixArizona85043GRP-0792CORE-HMO
ENRENR-1294662026-09-28T02:45:12Zstephen—weber1945-09-02UHC-21855-17UNKNOWN(606) 706-0381··stephen.weber32@outlook.com4201 Highland AvenueGlendaleAZ85316··GRP-5614MEDICARE-ADV-A
ENRENR-1425112026-03-15T23:21:25ZMargaret—McCoy11/17/1995UHC-69568-79null340-815-0346··margaret.mccoy65@gmail.com-N/ANULLN/AGRP-0709MEDICARE-ADV-B
ENRENR-1274772026-04-09T11:08:56ZandreaV.peters05/26/62UHC-05108-52•••-••-0821925.427.9059andrea.peters@yahoo.com5022 Lake View RoadTampaFL—GRP-4012CORE-HMO··
ENRENR-1138142026-09-21T12:11:54ZMelissaPPatterson1964-03-08UHC-28496-26UNKNOWN+1 308 573 8275melissa.patterson@icloud.com64 Elm St #866SacramentoCA95845··GRP-7389SELECT-EPO
ENRENR-1331692026-01-01T22:23:22ZDotN·Patterson07/14/1963UHC-01755-52•••-••-9861939-940-6003DOROTHY.PATTERSON21@AOL.COM3384 Cedar LaneNASHVILLETN37266GRP-0433MEDICARE-ADV-B
ENRENR-1114992026-08-01T20:50:02Z·EvelynCLane04/14/85··UHC-61513-03•••-••-7795567-766-6790EVELYN.LANE26@YAHOO.COM2837 CEDAR LNJacksonville··FL32248·GRP-9724MEDICARE-ADV-B
ENRENR-1269412026-06-20T08:34:30ZCox, Michael O.——1998-01-16UHC-12578-94•••-••-8228·412-713-5896·michael.cox97@proton.me1486 Apache Blvd #413SeattleWA·UNKNOWNGRP-9200SELECT-EPO
ENRENR-1097522026-01-05T03:14:29ZamberX.fowler2000-03-12UHC8854195•••-••-78785392307779null2749 BROADWAY·ChandlerAZ85262GRP-9052SELECT-EPO
ENRENR-1124492026-01-03T16:37:36ZJerry—Anderson2006-12-25UHC-02296-66—7557009346jerry.anderson@aol.com5218 Lake View RoadSan AntonioTexas78227GRP-4348··MEDICARE-ADV-A
ENRENR-1112232026-03-15T00:07:29ZJoanR.·Hanson10/28/1970UHC-65084-63•••-••-46513413620546JOAN.HANSON95@OUTLOOK.COM·6881 Grand AvenueOrlandoFL32801GRP-2802MEDICARE-ADV-A
ENRENR-1167502026-06-29T11:03:44ZAustin—Simpson··1993-02-27··UHC-42582-05•••-••-27785882944453N/A3090 OCEAN AVELos AngelesCA90093GRP-3103OPTIONS-PPO
ENRENR-1012392026-09-06T13:22:47Z BRANDON—GONZELES1966-05-07UHC-09464-72•••-••-827317926031562BRANDON.GONZALES@HOTMAIL.COM1764 OCEAN AVENUEPLANOTX75060-5705GRP-0304CORE-HMO
ENRENR-133884 2026-05-31T23:55:20ZDIANAPCASTRO9/25/1971UNKNOWN•••-••-70365593207667—7398 Pine Drive··ColumbusOH43278GRP-3477OPTIONS-PPO
ENRENR-1240062026-07-10T00:21:40ZTIMOTHYGFLORES··2004-12-25UHC-33320-20··•••-••-89875955097374timothy.flores@gmail.com9089 VALLEY VIEW DRIVEScottsdaleAZ85277GRP-2326OPTIONS-PPO
43,101 rows, page 176 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.308Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty