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-1367522026-05-18T10:20:35ZLAUREN—CASTILLO1995-02-27UHC-82470-95•••-••-4613583-830-2953N/A1958 Highland Ave Apt 14··Austin··TX78734GRP-0189MEDICARE-ADV-B
ENRENR-1118532026-10-05T17:56:32ZSharon—Lynch1991-10-09UHC-20961-58•••-••-4923(702) 697-5895sharon.lynch@gmail.com5384 Desert Sky BlvdAustinTXN/AGRP-7477MEDICARE-ADV-A
ENRENR-1298672026-03-28T14:43:48ZYoung, Elijah——Nov 26, 1952UHC-77203-39•••-••-0411—ELIJAH.YOUNG@ICLOUD.COM··6380 Lake View RdTampaFL33681GRP-6846CORE-HMO
ENRENR-143029 2026-07-07T07:53:48ZSEAN—GARDNER1975-11-13uhc-79247-78•••-••-9180(405) 630-0697-6474 Main StAtlantaGA30303GRP-8319CORE-HMO
ENRENR-1426352026-09-05T11:18:52ZCheryl·COliver1950-08-04UHC-04381-26•••-••-5603N/ACHERYL.OLIVER92@OUTLOOK.COM6848 Sage CtGilbertAZ··85234-9450GRP-8604CORE-HMO
ENRENR-1203722026-03-09T06:50:31Z·DIANA I.—WILLIS28-12-1993··UHC-24003-43•••-••-82984202627379DIANA.WILLIS86@OUTLOOK.COM435 Washington StAtlantaga30301GRP-3468OPTIONS-PPO
ENRENR-1113862026-09-27T12:45:00ZPeter—Sims1987-12-08UHC-97502-64•••-••-0171+1 574 263 2837null4145 LINCOLN WAYChandlerAZ85291GRP-5815SELECT-EPO
ENRENR-1233732026-02-17T06:21:30ZValdez, PriyaB—1986-04-28UHC-59028-98•••-••-17915067940364priya.valdez@gmail.com8682 HIGHLAND AVETUCSONAZ85744GRP-5723OPTIONS-PPO
ENRENR-1257932026-02-05T12:28:43ZCharles·Y.Alvarez1994-01-24UHC-12886-26•••-••-0016(532) 596-8481CHARLES.ALVAREZ@YAHOO.COM4176 Meadow LnTempe·AZ85264GRP-9091NAVIGATE-HMO
ENRENR-1228202026-09-08T15:55:41Z MICHAELR.FLORES5/13/2000UHC-18243-61•••-••-3172—michael.flores26@yahoo.com7265 MAPLE AVENUE···Las VegasNV·UNKNOWNGRP-6936··medicare-adv-a
ENRENR-1104982026-03-01T11:38:15ZLAWRENCEEDIAZ·6/3/1938UHC-21905-26•••-••-98439309440897UNKNOWN6968 MESA DRIVEChandlerAZ85254GRP-7335MEDICARE-ADV-A
ENRENR-1004012026-10-09T22:33:36ZdavidOmurray1945-08-01UHC-38623-43•••-••-0876(837) 733-6787david.murray@aol.com4943 Canyon RdDallasTX75262-0415GRP-2459CORE-HMO
ENRENR-1189312026-01-25T02:14:53ZBryanXFlores5/9/1958—•••-••-2594(519) 635-5859·bryan.flores19@hotmail.com·8892 River RoadMesaAZ·85222GRP-6278CHOICE-PLUS-PPO
ENRENR-1385682026-05-15T17:25:06ZKYLEA.DIAZ19480121UHC-72638-46•••-••-3494+1 270 428 2167kyle.diaz63@icloud.com7281 RIDGE RDDallasTX75274-3239GRP-3607NAVIGATE-HMO
ENRENR-1321552026-04-15T01:28:13Zteresa—boyd09/14/1996UHC-40965-47•••-••-4325·5766965620N/A2967 Washington StTempeAZ85216GRP-5746MEDICARE-ADV-B
ENRENR-1165332026-03-26T05:45:58Z·NahE.··Sims··2002-05-14UHC-54449-78•••-••-147414558356842UNKNOWN7793 Harbor BlvdChandlerAZ··85215GRP-9465CHOICE-PLUS-PPO
ENRENR-1211402026-05-07T21:20:24ZDeborah—Morales1968-08-17···UHC-91939-51•••-••-9150581.536.9177N/A9045 RIDGE RDDenverco80224GRP-9505MEDICARE-ADV-B
ENRENR-1190752026-06-22T03:47:08ZAmanda—Perkins02/19/43UHC4982737•••-••-24807633485186amanda.perkins@yahoo.com5497 Forest AvenuePhoenixAZ85009GRP-9373·CHOICE-PLUS-PPO
ENRENR-1314502026-07-29T16:26:36ZNICHOLAS—ROBERTSON1948-05-21UHC-77797-13•••-••-0263(484) 763-9215nicholas.robertson80@proton.me8153 Jefferson AvenueGlendaleAZ85311GRP-7992MEDICARE-ADV-B
ENRENR-1072972026-05-21T11:51:00ZWlter·MChavez1969-02-03··UHC-84604-12··•••-••-1382852-715-7445NULL··4549 Market StGILBERTArizona··85204GRP-9137MEDICARE-ADV-A
ENRENR-1011612026-01-13T22:57:40ZMARGARET·GCARR1982-07-26UHC-97098-05•••-••-9317·806-409-5702margaret.carr@icloud.com8548 HILLCREST RDSan DiegoCA··92177GRP-7941SELECT-EPO
ENRENR-120643 2026-01-04T07:13:11ZSharonO.Stevens1985-05-24UHC-10278-31•••-••-5906762-809-4049··sharon.stevens@outlook.com1993 SAGE COURT #947NashvilleTennessee37250GRP-4005··MEDICARE-ADV-B
ENRENR-1134302026-08-21T06:59:19ZMaria—Myers1949-11-10UHC-25623-45•••-••-8135(684) 857-5252maria.myers@aol.com2789 Sage CourtGlendaleAZ85369··GRP-3994SELECT-EPO
ENRENR-1154472026-07-12T06:10:44Z·Wagner, Jeffrey N——1981-04-19UHC-02624-89··•••-••-248717676570707jeffrey.wagner@outlook.com8796 River RdNashvilleTN37299GRP-6667CORE-HMO
ENRENR-1122762026-04-29T13:20:18ZBRADLEYWJONES07/11/80UHC-91461-93•••-••-8219818-907-2740·N/A2163 Baseline RoadLAS VEGASNV··89162GRP-1505·MEDICARE-ADV-B
ENRENR-1274672026-09-25T12:32:47ZGraceNPatterson1983-10-22UHC6518374··NULL+1 957 905 4803—2433 Forest AvenueJacksonvilleFL32214-1689GRP-9956NAVIGATE-HMO
ENRENR-1228262026-05-25T20:28:10Zkelly T—dayJan 19, 1983UHC-30774-01•••-••-1188977-622-9722kelly.day@yahoo.com8106 Forest AvenueGILBERTAZ85277··GRP-2591SELECT-EPO
ENRENR-1098122026-09-17T17:48:58ZAbigail—·Hicks4/5/2001UHC-46842-79•••-••-7361····abigail.hicks@yahoo.com251 HILLCREST RDSEATTLEWA98176GRP-2410NAVIGATE-HMO
ENRENR-1189072026-05-28T17:37:10ZKimberlyH.··George1958-03-08·UHC-06108-11•••-••-76913043669565kimberly.george@aol.com252 Harbor BoulevardNashvilleTN37296GRP-0639MEDICARE-ADV-B
ENRENR-1116242026-05-11T21:03:57Z·Alice—Fox1596-01-28UHC-49138-69•••-••-3661(755) 691-8267alice.fox27@outlook.com4968 Mountain View DriveCharlotteNCN/AGRP-5260CHOICE-PLUS-PPO
ENRENR-1070602026-02-16T14:33:21Z·RoyPJordan2002-06-11UHC-59020-72•••-••-419913167770903UNKNOWN3977 Main StMiamiFL33122-7378GRP-1433navigate-hmo
ENRENR-1215022026-09-27T04:32:01ZStevenN.Ramirez1952-06-15UHC-82095-13··•••-••-97135604422STEVEN.RAMIREZ@YAHOO.COM5837 Indian School RoadColumbusoh43282GRP-7759OPTIONS-PPO
ENRENR-1120282026-09-16T05:01:21ZDOUGLAS—BRYANT24-09-1970UHC-85493-63•••-••-9593315-848-0114douglas.bryant@gmail.com6227 Mesa DriveEden PrairieMN55327GRP-3931MEDICARE-ADV-B
ENRENR-1204572026-03-14T02:11:57Z·ANNA—LI02/06/2002UHC-38800-76•••-••-86758983243993ANNA.LI@GMAIL.COM6393 BroadwayScottsdaleAZ·85266GRP-6900·OPTIONS-PPO
ENRENR-1175862026-09-18T14:55:16ZLoriP.Singh06/04/1973UHC-68004-93—·NULLlori.singh60@proton.me2288 CANYON ROADDenverCO80250-2825GRP-5195CHOICE-PLUS-PPO
ENRENR-1307582026-09-24T02:32:05ZMarianaYMaritnez1973-02-25UHC-91751-31•••-••-571314526045419··N/A29 Sage CourtSAN ANTONIOTX78274GRP-8321CHOICE-PLUS-PPO
ENRENR-1084632026-05-23T08:53:31ZJudith—Olsoon04/11/1966·UHC-31184-68•••-••-4822(351) 686-1068judith.olson@outlook.com4157 HILLCREST ROAD #811·PhoenixAZ85023GRP-1341CHOICE-PLUS-PPO
ENRENR-1367592026-05-03T17:06:45ZRalph··ALee··1941-05-14·UHC-36004-46··N/A··ralph.lee73@proton.me9298 OAK STSan AntonioTX78272GRP-8940CORE-HMO
ENRENR-1340492026-09-30T19:39:56ZIsabellaVLewis·1986-12-27UHC-29437-16•••-••-1990610-209-1011N/A4245 LINCOLN WAY··AustinTX78764GRP-7459··NAVIGATE-HMO
ENR ENR-1237152026-10-16T05:35:57ZJulie—Salazar1945-11-07UHC-75947-68•••-••-6054(456) 825-3507julie.salazar@hotmail.com7977 Forest AvenueSacramentoCA95807GRP-3876MEDICARE-ADV-A··
ENR ENR-1275642026-07-05T05:53:40ZBarnes, Deborah····—03/09/95UHC-31108-31•••-••-1651(553) 411-2107·DEBORAH.BARNES@YAHOO.COM8022 Hillcrest Road·MinneapolisMN55460GRP-5479CORE-HMO
ENRENR-1374232026-07-01T12:44:01ZDiego—Fissher8/4/1960UHC-25301-98•••-••-06063823714663diego.fisher76@gmail.com872 JEFFERSON AVENUEColumbusOhio43295GRP-8133MEDICARE-ADV-B··
ENRENR-1329562026-03-16T02:11:58ZArthurZWaallaceJul 10, 1961UHC-29082-43•••-••-09356658667099null4639 Lake View RdTucsonArizona··85766··GRP-7422OPTIONS-PPO
ENRENR-1189222026-08-12T18:23:00ZRussell··Snyder19850505UHC-96661-27•••-••-0741N/A··russell.snyder@hotmail.com5414 Maple AvenueDenverCO80264GRP-1324MEDICARE-ADV-B
ENRENR-1046072026-01-26T01:02:27Z MEGAN—DAVIS·1994-06-27UHC-00007-16•••-••-4557(909) 642-7424·megan.davis77@aol.com4311 Church StAtlantaGA30320GRP-6769MEDICARE-ADV-B
ENRENR-1160272026-09-21T19:51:59ZNANCY—BURTON1983-05-02UHC-12094-80•••-••-9636(735) 773-7778NULL3984 LAKE VIEW ROADScottsdaleArizona85221GRP-5559·CHOICE-PLUS-PPO
ENRENR-1108962026-01-05T01:19:29Z PAMELA—HICKS1951-06-04UHC-52905-09N/A·(516) 457-2256N/A5492 HIGHLAND AVESeattleWA98198GRP-1938CHOICE-PLUS-PPO
ENRENR-1006722026-04-10T10:49:21ZCARRL····ALVARADOSep 23, 1938UHC-22730-30•••-••-6204441-580-5614carl.alvarado@outlook.com2830 Maple AvenueSACRAMENTOCA95803GRP-1559OPTIONS-PPO
ENRENR-1078142026-01-04T04:25:32ZKEITH··Z.WILLIS06/07/46UHC-74143-65•••-••-2258278-841-5730NULL8299 Willow CtSAN DIEGOCA92187GRP-8137OPTIONS-PPO
ENRENR-1050902026-09-06T01:30:47ZNatlaieQDunn1966-06-23UHC-17711-10•••-••-4795285.230.9296NATALIE.DUNN@GMAIL.COM4281 MESA DRLos AngelesCA90018GRP-0773MEDICARE-ADV-B
43,101 rows, page 76 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:36.710Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty