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-1225932026-04-14T14:40:55Z DOROTHYQSANDERS1947-07-13UHC-55807-35•••-••-6895+1 878 431 9401—5954 BAYSHORE DROrlandoFL32856GRP-8990CHOICE-PLUS-PPO
ENRENR-1077052026-06-19T07:22:52Z·BrittanyY.Johnston2004-06-16··UHC-35387-53—949.747.8867N/A2464 Lincoln WaySan AntonioTX78215GRP-6873NAVIGATE-HMO
ENRENR-1004902026-05-14T08:20:33Z HannahADominguez1988-11-24··UHC-53763-37•••-••-5425980-250-0576hannah.dominguez66@gmail.com-nullNULLnull··GRP-9040MEDICARE-ADV-B
ENRENR-1048692026-01-05T10:02:40ZHenryFLitle1944-12-26UHC-93359-73•••-••-2716(243) 574-6946NULL266 Camelback RdAtlantaGA30361·GRP-2610CHOICE-PLUS-PPO
ENRENR-1421312026-09-09T15:40:41ZbillyM·chen2000-09-16UHC-15741-75•••-••-06356455957963billy.chen@yahoo.com2005 Church StreetORLANDOFL32812GRP-9451OPTIONS-PPO
ENRENR-1201942026-07-09T01:56:33ZGabriel—Cruz1997-09-17UHC-57724-99•••-••-88205227360272GABRIEL.CRUZ@ICLOUD.COM·4464 Jefferson AvenueJacksonvilleFL32289GRP-0389options-ppo··
ENRENR-1142792026-04-01T01:39:26ZCarlG.Parker10/06/75·UHC-03174-48•••-••-252612872582478carl.parker@hotmail.com8659 WASHINGTON STChandlerAZ85216GRP-6006MEDICARE-ADV-B
ENRENR-1300882026-02-17T20:32:59ZMei··—Park1960-05-05UHC-20042-67•••-••-4298687-502-7457MEI.PARK57@GMAIL.COM·8522 Cedar LaneMINNEAPOLISMN55403GRP-2525·OPTIONS-PPO
ENRENR-1016582026-06-11T17:14:49ZSofia—Boyd··11/10/1999UHC-60032-56•••-••-85648718868419sofia.boyd@gmail.com3819 Forest Avenue·SEATTLEWA98176GRP-5444MEDICARE-ADV-B
ENRENR-1411832026-04-11T21:28:51Z Gonzales, Nicole··—02/13/41UHC-80545-64•••-••-8574——4175 FOREST AVENUEOrlandoFL·32880-0266GRP-5424·MEDICARE-ADV-B
ENRENR-1215492026-01-20T11:53:03ZAISHAZCHAPMAN1961-09-18UHC-86057-39•••-••-4042225.469.7944-4462 CEDAR LANE··MiamiFL··33191GRP-8634OPTIONS-PPO
ENRENR-1323122026-07-12T23:27:29ZAEXANDER—KIM2005-12-08UHC-44823-31•••-••-5799350-975-8423alexander.kim56@gmail.com1877 MAIN STHoustonTX77011··GRP-3090NAVIGATE-HMO
ENRENR-1112612026-02-13T06:53:56ZANNA—MASON17-04-1996UHC-83078-50•••-••-7003254.682.0406anna.mason9@proton.me5640 Harbor BoulevardTucson··AZ85781GRP-1527MEDICARE-ADV-A
ENRENR-1000072026-02-12T13:23:38ZEVELYN—WATKINS1994-09-17UHC-98409-62NULL+1 321 349 3348··evelyn.watkins60@aol.com6607 BroadwayChandleraz85248GRP-4596CHOICE-PLUS-PPO
ENRENR-1346442026-05-08T18:08:59Z Anna—RuizJun 2, 1956UHC-41827-45•••-••-13084843439310anna.ruiz6@icloud.com8106 Canyon RdAtlantaGA30390GRP-9811options-ppo
ENRENR-1312482026-01-22T23:36:23ZRebeccaZAdams1994-10-12UHC-47476-14··•••-••-32224777199200—1167 Bayshore DrFresnoCA93721GRP-3789OPTIONS-PPO
ENRENR-1270742026-09-15T17:02:01ZSamuel—Franklin05/03/92·UHC-56314-59•••-••-7340520-711-6506-2707 Washington StGilbert·AZ85241GRP-3914CORE-HMO
ENRENR-1076092026-06-10T08:52:35ZAMANDAS··LARSON1946-09-26UHC-81514-74•••-••-8352N/AAMANDA.LARSON18@GMAIL.COM1439 DESERT SKY BLVDTempeAZ85258GRP-7258CORE-HMO
ENRENR-1138202026-08-01T13:52:26ZBradley—Perkins8/26/2003UHC-98736-97•••-••-38234055901924BRADLEY.PERKINS@OUTLOOK.COM616 LINCOLN WAYSACRAMENTOCA·95898GRP-2294CHOICE-PLUS-PPO
ENRENR-1426612026-05-21T07:34:45ZWeiJMurphyDec 7, 1984UHC-56968-18N/A7407703635WEI.MURPHY36@OUTLOOK.COM··492 Elm StColumbusOH43230GRP-0233OPTIONS-PPO
ENRENR-1073012026-02-09T10:35:49Zbrian··X.martin1955-12-12UHC-59137-20•••-••-7959NULL··BRIAN.MARTIN57@AOL.COM8828 CEDAR LANESeattleWashington98113GRP-3481SELECT-EPO
ENRENR-1347712026-03-16T20:38:15ZAlan—Smith20041104UHC-62253-64•••-••-5071922.666.8786-8017 HIGHLAND AVEGlendaleArizona85346··GRP-5121choice-plus-ppo
ENRENR-123354 2026-01-07T07:33:17ZWayneTGarza11/24/1990UHC-17167-67N/ANULLwayne.garza@outlook.com7840 Forest Avenue #508·JacksonvilleFL32295GRP-1066MEDICARE-ADV-A
ENRENR-1321522026-02-07T20:07:51ZPAULXEVANS1972-11-03UHC-64104-74•••-••-45886496623518paul.evans79@outlook.com3078 Main StreetEden PrairieMN55310GRP-3770CORE-HMO
ENRENR-1314602026-02-21T03:10:49ZbobbbyKmurray1993-12-01UHC-88662-78•••-••-76283249799456bobby.murray@gmail.com2508 HIGHLAND AVE··MIAMIFL33174GRP-0603CHOICE-PLUS-PPO
ENRENR-1415322026-08-06T08:11:11ZRobertYWagner01/15/83UHC-47936-01•••-••-6829N/AUNKNOWN3375 Palm DriveSacramentoCA··95829GRP-9585CORE-HMO
ENRENR-1271102026-08-06T11:36:18ZJordanUGordon1968-10-01UHC-26833-47—(890) 383-0382·UNKNOWN7980 Indian School RdDallasTX75227GRP-0987CORE-HMO
ENR ENR-1388992026-08-14T09:42:42Zdiane P.—snyder1952-05-14UHC-24704-03•••-••-6287—diane.snyder56@gmail.com2666 SPRING STAustinTX78738GRP-3694NAVIGATE-HMO
ENRENR-1107752026-08-29T04:54:27ZJohnson, Kayla··——01/07/90UHC-82773-21•••-••-6252(601) 971-4583··KAYLA.JOHNSON@HOTMAIL.COM9081 River RoadTampaFL33639GRP-5902·MEDICARE-ADV-A
ENRENR-1328772026-06-14T06:27:17ZROGERN.ESPINOZA1989-07-23UHC-47267-85•••-••-41516048284342roger.espinoza55@outlook.com··655 Canyon RdGilbertAZ85298GRP-9752CHOICE-PLUS-PPO
ENRENR-1308542026-04-29T17:50:57ZPeterYHernandez2/20/1986UHC-11079-43•••-••-9194889-460-0573peter.hernandez87@outlook.com7574 Baseline RdGILBERTAZNULLGRP-2990MEDICARE-ADV-A
ENRENR-1108402026-02-18T22:03:49ZCarroll, Julia··U—07/10/72UHC-35780-70•••-••-7905(831) 283-7561JULIA.CARROLL@ICLOUD.COM—nullUNKNOWNNULL··GRP-2765CHOICE-PLUS-PPO
ENR ENR-140897 2026-05-23T20:49:40ZMICHELLE—RODRIGUEZ16-06-1972UHC-00229-95•••-••-66566906439463michelle.rodriguez@yahoo.com7685 Desert Sky BoulevardGLENDALEAZ85328GRP-2513OPTIONS-PPO
ENRENR-1258642026-07-17T00:02:54ZelizabethU··moreno1965-12-24UHC-58804-83•••-••-0736(774) 765-0251elizabeth.moreno24@gmail.com1996 Park PlSEATTLEwa98130GRP-1695NAVIGATE-HMO
ENRENR-1420932026-01-19T07:05:11ZWeiL··Rogers09/25/1991UHC-97411-91•••-••-1006--9562 Elm StOrlandoFL32889GRP-2242MEDICARE-ADV-A
ENR ENR-1127892026-08-05T16:45:28ZElijah—·Castillo1953-09-23UHC-83539-81•••-••-0186470-702-3292elijah.castillo87@yahoo.com2305 Oak StChandlerAZN/AGRP-9689··MEDICARE-ADV-A
ENRENR-1083652026-02-23T12:59:27ZVirginiaG.Graham05-12-1943UHC-43956-72•••-••-5982274-620-9937—4639 Palm DrSan DiegoCANULLGRP-0145medicare-adv-a
ENRENR-115467 2026-03-11T04:55:42ZDavidG··RiosAug 14, 1978UHC-80713-52•••-••-996415563472654-6708 Church StAtlantaGA30351GRP-7428CORE-HMO
ENRENR-1408482026-05-26T08:56:43ZAmberP.Herrera—UHC-91429-67•••-••-9863912-404-5238·amber.herrera65@yahoo.com7215 Mesa DrJacksonvilleFL32259GRP-3814··NAVIGATE-HMO
ENRENR-1271422026-03-31T11:18:15ZKathleenQ.··Grififn1972-06-12UHC-05268-94•••-••-8621934-267-1648kathleen.griffin42@icloud.com451 Ridge Rd Apt 30FresnoCA93761GRP-3074CHOICE-PLUS-PPO
ENRENR-1309392026-06-01T19:05:21ZVasquez, MasonM.—12/01/52UHC5659406•••-••-7527·6696404326mason.vasquez@hotmail.com7154 MAPLE AVELos AngelesCA90097-4187GRP-2119MEDICARE-ADV-A··
ENRENR-1428982026-06-16T13:03:54ZBryan—Walker12-01-1961UHC-36656-10•••-••-2794N/Abryan.walker98@proton.me2491 Sunset BlvdTempeAZ85272··GRP-3856MEDICARE-ADV-B
ENRENR-1404592026-03-14T15:07:55Z·Roger—Marshall1998-11-17UHC-50010-56•••-••-4786—roger.marshall@yahoo.com9125 Camelback RoadMinneapolis··MN55418-6548GRP-5493options-ppo
ENRENR-1034762026-03-11T17:35:33Z JUDY····TURNER1957-08-03UHC-54618-59•••-••-0768779-735-8923judy.turner11@icloud.com5845 Central AveDENVERCO80296GRP-5471MEDICARE-ADV-B
ENRENR-1143872026-05-31T00:23:40ZCarlUOrtega2004-02-20UHC-44602-19•••-••-90779746255carl.ortega@proton.me6941 Ocean AvenueHoustonTX77095GRP-8962·OPTIONS-PPO
ENRENR-1349212026-05-16T13:14:59Z SofiaNDavis1971-05-14UHC-61212-01•••-••-03369016006678sofia.davis@aol.com1769 LINCOLN WAYPlanoTX75021GRP-5602MEDICARE-ADV-B
ENRENR-1136982026-05-09T15:10:12Zsara—campbell1942-12-26UHC-92906-33•••-••-4651nullN/A5159 Desert Sky Boulevard Apt 24GilbertAZ85261GRP-4756CHOICE-PLUS-PPO
ENRENR-1204532026-01-27T09:48:41ZKyala··CAllen07/01/43UHC-42496-43•••-••-7089981-701-9238—6027 Elm StreetLas VegasNV89124··GRP-7301CHOICE-PLUS-PPO
ENRENR-1395352026-02-17T03:06:23ZRYANGROMERO03/08/2001UHC-85681-80•••-••-84536402488647—4956 Highland AveCOLUMBUSOH43221GRP-1799OPTIONS-PPO
ENRENR-1134102026-06-25T15:16:57Z·DENISEQGUERRERO1997-11-18·UHC-92483-29•••-••-8831584.711.3510··DENISE.GUERRERO@GMAIL.COM4184 HIGHLAND AVETucsonArizona85734-6518GRP-8036MEDICARE-ADV-A
43,101 rows, page 151 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:38.476Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty