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-1061962026-01-05T08:01:20ZseanZmarquez1972-11-08UHC-81150-79•••-••-460512559182310—4151 Market StreetCHARLOTTENC28295GRP-5596NAVIGATE-HMO
ENRENR-1115962026-09-10T17:45:46Z PaulRPtaelJul 13, 1969UHC-67044-34•••-••-0921(528) 349-3801PAUL.PATEL14@YAHOO.COM9164 Union StSacramentoCA95802··GRP-0105CHOICE-PLUS-PPO
ENRENR-1005172026-06-23T22:10:56ZRbeccaG.Reed06/08/1958UHC-81612-39•••-••-8615793-215-7291—2410 Canyon RdAtlantaGA30360GRP-8722MEDICARE-ADV-A
ENRENR-1026562026-07-04T22:00:30ZAustin—Cox17-03-1973UHC-51901-82•••-••-5123—AUSTIN.COX5@OUTLOOK.COM6963 Maple AveScottsdaleAZ85267GRP-8495CHOICE-PLUS-PPO
ENRENR-1080332026-06-19T19:36:53Z·Jacqueline—Ryan1973-08-41··UHC-97443-27•••-••-9354855.563.5183—5196 Mesa DriveHoustonTX77024GRP-4623·MEDICARE-ADV-A
ENRENR-1026142026-07-13T11:09:49ZMariaNButler1984-08-02UHC-08890-59•••-••-83192375262333—726 Valley View DrDallasTexas75210GRP-7079SELECT-EPO
ENRENR-1355062026-09-17T10:10:26ZMeryTGibson10/10/2003UHC-23222-22•••-••-7491+1 276 390 1042—4420 DESERT SKY BLVDAtlantaGA30339GRP-5735CHOICE-PLUS-PPO
ENRENR-1149312026-09-27T21:38:02ZDavid··Boyd1993-08-09UHC-93178-42•••-••-980717982233800null··3922 Hillcrest RoadMinneapolisMN55416··GRP-7241CORE-HMO··
ENRENR-1250082026-01-28T13:53:16ZDoris—Alvarado1944-08-04UHC-57048-76•••-••-2488(322) 882-6793DORIS.ALVARADO41@PROTON.ME8878 Mountain View DrChandlerArizona85293GRP-0407CORE-HMO
ENRENR-1385862026-03-23T07:15:19ZRAYMONDJ.DAY1984-07-02UHC-13009-12··•••-••-97278372569229raymond.day78@gmail.com227 Elm Street··TUCSONAZ85757GRP-5920CHOICE-PLUS-PPO
ENRENR-1348272026-09-30T12:33:10Z·KarenQ·Ryan1939-03-07UHC-99293-59··•••-••-2962(305) 290-0134karen.ryan53@hotmail.com1190 BAYSHORE DRAtlantaGA30360··GRP-9791core-hmo
ENRENR-1241842026-09-07T13:05:45ZJoeV.Flores1994-08-08UHC-97798-95•••-••-81822804909-6068 Sunset Boulevard #859··Charlotte·NC28283GRP-0341CORE-HMO
ENRENR-1416622026-06-01T05:52:25ZREBECCA—ESPINOZA1954-12-27UHC9195897•••-••-35749055432749—8352 Main StPhoenixAZ85042GRP-6325MEDICARE-ADV-A
ENRENR-1239732026-03-15T21:04:47ZTheresaTHarvey4/6/2001UHC-35453-33•••-••-5589NULLUNKNOWN2571 Pine DriveOrlandoFL·32850GRP-0251medicare-adv-b
ENRENR-1087032026-01-15T04:17:26ZBrandon··—Allen1947-06-06UHC-43546-14•••-••-6183nullnull2892 Maple AvenueColumbusOH43228GRP-1155CORE-HMO
ENRENR-1099952026-05-04T09:40:22Zfrances·····west1971-03-02UHC-96840-78•••-••-4936+1 480 889 0299FRANCES.WEST@HOTMAIL.COM4234 Harbor BlvdHoustonTX77069GRP-9407CORE-HMO
ENRENR-1272162026-02-13T08:44:45ZDonnaXGuerrero1993-09-18UHC-56642-68-(473) 297-0994donna.guerrero15@proton.me5282 Main StreetCharlotteNC28204GRP-0833·NAVIGATE-HMO
ENR ENR-1114692026-09-12T15:38:07ZGARYSSTONE9139-03-24UHC-26978-96•••-••-38287758827769gary.stone@proton.me7116 Camelback Road·NashvilleTN37294GRP-7433SELECT-EPO
ENRENR-1123712026-01-02T10:07:05ZTran, DianeJ····02/07/1943UHC-37638-51•••-••-27184469908920diane.tran@proton.me··7600 Park PlaceOrlandoFL32836GRP-1350MEDICARE-ADV-B
ENRENR-1285052026-01-25T18:04:34ZGLORIAMWONG19891105UHC-81570-84•••-••-0170453-401-1384·gloria.wong@proton.me1351 Elm StreetMinneapolisMN55440GRP-2636MEDICARE-ADV-B
ENRENR-1270752026-04-01T12:35:18Z lindaPbanks12/22/1986··UHC-50474-51•••-••-8784280-818-2550LINDA.BANKS37@PROTON.ME8760 Camelback RoadScottsdaleaz85289GRP-4886··MEDICARE-ADV-A
ENRENR-1415642026-07-22T03:07:13Z———1943-11-23uhc-29336-47•••-••-5164(577) 398-5494CHARLES.VEGA@ICLOUD.COM··227 Jefferson AveAustinTX78716GRP-6504CHOICE-PLUS-PPO
ENRENR-1342792026-07-15T07:44:07ZYuki—Ortiz19850707UHC-63912-94•••-••-0645809-427-7256—6483 Mesa DriveSan AntonioTX78203GRP-6106NAVIGATE-HMO
ENR ENR-1281302026-04-07T19:24:50ZCruzAPaul1993-04-08UHC-90990-14NULL+1 571 872 1444-9141 RIDGE RDSan AntonioTX78236GRP-2399MEDICARE-ADV-A
ENRENR-1262502026-07-30T17:02:06ZValentina—Matthews19970127UHC-48680-26•••-••-7167-valentina.matthews23@outlook.com7998 Camelback RoadDenverCO··80255GRP-7580OPTIONS-PPO
ENRENR-1193812026-09-15T14:38:11ZPatricia—Murray1968-07-24UHC-73821-46•••-••-3272+1 570 837 0604patricia.murray54@outlook.com9826 SUNSET BOULEVARDDenverCO80232GRP-3331CHOICE-PLUS-PPO
ENRENR-1402312026-04-19T21:20:19ZGRACE—ROBERTSON1988-04-08UHC-40193-36····609.444.8226UNKNOWN548 ELM STREETGLENDALEAZ85361GRP-7628CORE-HMO
ENRENR-124589 2026-01-07T19:39:14ZWILLIAMTREID20050801UHC-35354-11•••-••-3392877-709-6726william.reid1@yahoo.com7293 Elm StHOUSTONTX77039GRP-0919MEDICARE-ADV-A
ENRENR-1373632026-06-22T07:55:13ZLarry—SantiagoJan 14, 1958··UHC-60044-91•••-••-8296520.675.9256larry.santiago@outlook.com8243 Ridge RoadGILBERTAZ··85221GRP-4842SELECT-EPO··
ENRENR-1218932026-02-20T00:17:43Z·NoahWHall1946-05-18UHC-25198-97··•••-••-125815488354315N/A7972 Forest AveSeattleWA98119GRP-8248OPTIONS-PPO
ENRENR-1075422026-08-12T14:07:29ZMason, BobbyO—2003-05-20UHC-43823-71•••-••-98847065716092—2306 MESA DRCharlotteNC28203GRP-8100select-epo
ENRENR-1024992026-07-09T16:12:56ZKATHERINEQMONTGOMERY·1996-08-07UHC-26954-37··•••-••-2674+1 932 554 5090KATHERINE.MONTGOMERY@OUTLOOK.COM6855 SUNSET BOULEVARDTempeAZ85282-3737GRP-1576MEDICARE-ADV-A
ENRENR-1326022026-09-22T23:12:08Zsara—davis1977-04-06UHC-11295-01•••-••-3809+1 314 488 7525-8848 WILLOW COURT Apt 18Las Vegas··NV89172GRP-0101·MEDICARE-ADV-B
ENRENR-1369742026-01-02T08:23:56ZMarilynHCastro1987-10-05UHC-38734-29··•••-••-51587084503marilyn.castro50@proton.me4304 Park PlGILBERTAZ85295GRP-5751MEDICARE-ADV-B
ENRENR-1028502026-01-28T18:32:40ZRussellO.·Wood1958-08-17UHC-18978-12N/A+1 650 459 1886russell.wood@outlook.com667 Lake View RoadPhoenixAZ85043GRP-4569NAVIGATE-HMO
ENRENR-1258942026-01-26T15:50:07Zbryan—jenkins05/18/45UHC-40066-17•••-••-0821780.421.0538bryan.jenkins38@gmail.com5150 Cedar LnSan DiegoCA92139GRP-5445NAVIGATE-HMO
ENRENR-1234182026-04-21T00:09:34ZAndrewXArnold10/9/1963UHC-61812-60•••-••-5023357-855-7360andrew.arnold20@yahoo.com6581 JEFFERSON AVE Apt 24JacksonvilleFL32233GRP-1835CORE-HMO
ENRENR-1102522026-01-27T12:53:08ZHIROSHIV.VALDEZ19-10-1969UHC-16176-62•••-••-6209(805) 610-5283hiroshi.valdez89@yahoo.com3890 Lincoln WayHOUSTON·Texas77066GRP-7328CHOICE-PLUS-PPO
ENRENR-1137092026-03-06T18:46:29ZANNA·····HAMILTON1947-07-28UHC-64350-02•••-••-7935572-308-2398ANNA.HAMILTON@YAHOO.COM1273 MESA DRIVE··ChandlerAZNULLGRP-5562CHOICE-PLUS-PPO
ENRENR-1003672026-09-30T20:50:29ZMadisonHBoyd1997-10-09UHC-60296-67•••-••-3525·(495) 763-1430madison.boyd@yahoo.com5761 Central AveNashvilletnUNKNOWNGRP-1278CHOICE-PLUS-PPO
ENRENR-1400202026-08-03T12:27:46ZMorris—WayneJun 7, 1956UHC-81299-54—+1 418 951 8316wayne.morris@hotmail.com6002 Baseline RoadCHARLOTTENC28297-0745GRP-6032OPTIONS-PPO··
ENRENR-1159112026-03-29T02:01:43ZPAMELA··HUNT10/25/55UHC-33974-06NULL9553073739··PAMELA.HUNT73@AOL.COM8769 Meadow LaneDallasTX75298GRP-6001CORE-HMO
ENRENR-1014402026-08-27T03:14:30Z justin—jacobs1969-06-04UHC-85981-27NULL(316) 334-7790—3445 Mountain View DrCHARLOTTENC28286GRP-4399medicare-adv-b
ENRENR-1155102026-08-20T09:22:36ZRachel J—Hunter18-06-1985null•••-••-2691(270) 458-7905rachel.hunter@hotmail.com4290 PARK PLSeattleWA98176GRP-8692CHOICE-PLUS-PPO
ENRENR-1210572026-08-01T22:30:01ZTeresa—Reyes06/10/99UHC-34995-40•••-••-2875(317) 634-8127teresa.reyes@yahoo.com1268 Hillcrest RoadLas VegasNV89101-9534GRP-3491CORE-HMO··
ENRENR-1135992026-03-12T10:05:33ZTorres, KeithA.··—1955-12-22UHC-89886-91•••-••-8113····keith.torres60@proton.me8102 MAIN STHoustonTX··77018GRP-6506SELECT-EPO
ENRENR-1174042026-06-09T14:08:48ZKEREN—MORRISON06/28/2000UHC-23765-47•••-••-9613476-411-6775—5196 Cedar LaneMiamiFL33141GRP-0614OPTIONS-PPO
ENR ENR-1171932026-02-22T17:28:20Z·Sarah—Tucker1943-09-21UHC4650660•••-••-4452—UNKNOWN··8369 MOUNTAIN VIEW DRIVESacramentoCalifornia95819GRP-6637NAVIGATE-HMO
ENRENR-1054282026-06-18T11:49:36ZISABELLAY.GUZMAN·1996-02-09UHC-38211-19•••-••-2788519-475-7274ISABELLA.GUZMAN39@PROTON.ME7548 Lincoln WayLas VegasNV89128GRP-8624CORE-HMO
ENRENR-1076012026-02-02T08:24:51ZAishaOGriffin2005-09-04··UHC-65002-81—(366) 784-2451AISHA.GRIFFIN@GMAIL.COM5361 ELM STREETChandlerAZ85229GRP-6675NAVIGATE-HMO
43,101 rows, page 304 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:43.596Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty