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-1092102026-04-15T16:23:12ZJOSEPHKPETERS1973-09-07UHC-30404-02•••-••-78952112295769JOSEPH.PETERS68@AOL.COM6481 Broadway Apt 24NASHVILLETN37274GRP-8174OPTIONS-PPO
ENRENR-1257692026-07-31T14:23:39ZRachelO.Wagner1967-02-28UHC-69511-69•••-••-0495688-430-1702rachel.wagner39@yahoo.com3551 Palm DrColumbusOH43210-0471GRP-3815SELECT-EPO
ENRENR-1307352026-05-30T07:15:28ZSalazar, Joe——1994-01-16UHC-89970-58•••-••-502318732759175·JOE.SALAZAR34@GMAIL.COM2559 Mountain View DriveDallasTX75260GRP-3777MEDICARE-ADV-B
ENRENR-1279262026-04-30T18:54:53ZFerguson, ChrisU—2003-09-16UHC-41567-67•••-••-9415773-531-1242christine.ferguson5@outlook.com·541 SAGE CTFRESNOCalifornia93728··GRP-4825OPTIONS-PPO
ENRENR-1224312026-01-03T01:39:04Z Hannah—Garertt03/11/1979··UHC-85281-97•••-••-52563349712961hannah.garrett46@outlook.com1141 Maple AveCharlotteNCNULLGRP-2612OPTIONS-PPO
ENRENR-1014292026-08-04T23:51:45ZgraceN··young12/3/1959UHC-64513-41•••-••-9080(373) 976-5223··grace.young56@icloud.com3752 MESA DRIVETempeAZ—GRP-9410·NAVIGATE-HMO
ENRENR-125359 2026-02-04T10:42:40ZMoore, Joseph——May 26, 1990UHC-14260-60··NULL(292) 470-3851JOSEPH.MOORE16@GMAIL.COM5602 Mesa DriveTucsonAZ··85740GRP-9869CHOICE-PLUS-PPO
ENRENR-1070612026-06-06T02:24:02ZKeithF·GonzalesOct 18, 1961UHC7877187•••-••-98976159857209··keith.gonzales@icloud.com7370 Desert Sky BlvdPhoenixAZ·85029GRP-7485··OPTIONS-PPO
ENRENR-1382692026-02-14T13:58:44ZJUDYLROMEROMar 7, 1948UHC-34330-29•••-••-3336····—3855 River RoadSeattleWA98100GRP-8298OPTIONS-PPO
ENRENR-1066082026-04-24T13:04:30ZBruce··YFuller1988-04-26UHC-98369-58•••-••-6730798-969-9926—9452 Cedar LnAtlantaGA30302GRP-7474MEDICARE-ADV-A
ENRENR-1318582026-01-08T20:37:37ZCarroll, Keith——19880827UHC-89001-42•••-••-776719754329905keith.carroll31@icloud.com··3969 Apache BlvdTempeArizona85202-9552GRP-7835CHOICE-PLUS-PPO
ENRENR-1022042026-02-22T17:48:59ZDanielQHunt1979-10-23uhc-65220-77•••-••-9746782.587.0869daniel.hunt@outlook.com1014 ELM ST #245LOS ANGELESCA90069GRP-9636CORE-HMO
ENRENR-110487 2026-03-25T09:51:54ZJeremyWHillDec 10, 1999UHC-25891-17•••-••-3271612-500-7852·jeremy.hill4@gmail.com6424 Harbor Boulevard·GlendaleAZ··85341GRP-9789MEDICARE-ADV-B
ENRENR-1051192026-04-15T04:09:29ZPiarce, Eric——1995-01-10UHC-41724-95•••-••-8729380-635-1338eric.pierce@hotmail.com5615 Market StLAS VEGASNV89126·GRP-4389SELECT-EPO
ENRENR-1307742026-09-05T11:06:36ZEmaX.Thomas03/16/1970UHC-83839-38•••-••-6851480.276.8039UNKNOWN1953 RIVER RDCHARLOTTE··NC28289GRP-8456··SELECT-EPO
ENRENR-1079252026-09-01T18:50:45ZRACHELOCARROLL··1956-11-10··UHC-07257-67•••-••-6390955-403-6284N/A6558 Union StMiamiFlorida33163GRP-3594··OPTIONS-PPO
ENRENR-1257452026-01-04T19:12:14ZRachelD.James1973-09-03UHC8106682•••-••-779118296245689N/A6196 Broadway Apt 4DenverCO80203GRP-3255CHOICE-PLUS-PPO
ENRENR-1101322026-08-07T11:40:55ZJudith—Gray·Nov 4, 1999UHC-94603-39—3685078996·JUDITH.GRAY@PROTON.ME466 MESA DRIVETucsonAZ85750GRP-6946OPTIONS-PPO
ENRENR-1060982026-05-29T14:41:37ZCynthiaCWeaver1948-07-26··UHC3477023··•••-••-86629045077889cynthia.weaver24@gmail.com5617 Washington StreetNashvilleTN37263GRP-8024core-hmo
ENRENR-1359852026-03-17T01:30:59ZAaronQ.Munoz07/01/73UHC8933767•••-••-73574904978412aaron.munoz@hotmail.com7523 MAPLE AVEEden PrairieMN55399GRP-9162CORE-HMO
ENRENR-139114 2026-09-10T10:34:27Z·VirgginiaOWelch1960-01-07UHC-88505-96null··(964) 430-1229-6082 PINE DRIVEDENVER··CO80209GRP-8673NAVIGATE-HMO
ENRENR-1373852026-01-19T08:34:27ZMATEO—·BERRY1952-02-23UHC-83479-46•••-••-2880····UNKNOWN4999 PINE DRIVESacramentoCA·95814-6345GRP-2557OPTIONS-PPO
ENRENR-1308682026-08-23T03:56:12ZOLIVIAF.DAY1963-05-16UHC-80025-41•••-••-1847942.253.6990olivia.day16@proton.me364 SPRING STDALLASTX75295GRP-5467NAVIGATE-HMO
ENRENR-1317852026-02-24T23:06:05ZMedina, Heather··Z—2001-02-91UHC-25268-76•••-••-1936—heather.medina99@proton.me7546 Baseline RdCharlotteNC28257-3694GRP-7460medicare-adv-a
ENRENR-1046422026-06-01T07:57:37ZCYNTHIA—RODRIGUEZ1/27/1977UHC-17553-20•••-••-98025005479875cynthia.rodriguez@yahoo.com··9288 OAK STAUSTINTX78757GRP-5490NAVIGATE-HMO
ENRENR-1005562026-08-29T08:28:13ZrobertChoffmna1980-04-20UHC-41946-58UNKNOWN937-778-8548robert.hoffman43@yahoo.com8892 SPRING STREETDallasTX75231GRP-7133CHOICE-PLUS-PPO
ENRENR-1393352026-04-08T02:43:46ZyukiF.vasquez1976-10-23UHC-11306-08····-—6384 Willow Court··DENVERCO80217·GRP-2038OPTIONS-PPO
ENRENR-1389702026-02-24T09:54:43ZSHARON—HILL··7/9/2000UHC-93224-49•••-••-6910(321) 618-5439UNKNOWN··4947 Oak StScottsdale·AZ85270GRP-2940MEDICARE-ADV-B
ENRENR-1081652026-04-15T02:12:41ZKathryn—Ramirez—·UHC-00624-02•••-••-2227861-621-2548UNKNOWN9294 Park Place·GILBERTAZ85281GRP-9675·SELECT-EPO
ENRENR-1428142026-08-28T22:46:30Z CAROLYN—WRIGHT05/19/76UHC-94808-34null858-472-8544carolyn.wright69@gmail.com3585 JEFFERSON AVENUEDALLASTexas75210GRP-1214MEDICARE-ADV-A··
ENR ENR-1263942026-02-11T12:30:06ZJoyce—Watson1938-11-17UHC-18256-92—4017122581UNKNOWN3969 LINCOLN WAYJACKSONVILLEFlorida32297GRP-7194NAVIGATE-HMO
ENRENR-1015252026-02-17T10:09:25Ztimothy—reed3/14/1963UHC-65404-55•••-••-7899216.870.0023timothy.reed4@proton.me6904 Lincoln WayColumbusOH43203GRP-7261CHOICE-PLUS-PPO
ENRENR-1183432026-05-02T04:08:41ZSean, Vargas——1992-06-05UHC-30722-64•••-••-978117168257969sean.vargas@gmail.com1611 LINCOLN WAYMesaAZ··—·GRP-1802MEDICARE-ADV-B
ENRENR-1051652026-06-25T20:43:26ZEthan—Harper1995-12-25UHC5076274N/A-UNKNOWN1497 Baseline RoadLas VegasNV89114GRP-9875CHOICE-PLUS-PPO
ENRENR-1383362026-05-16T01:44:03ZJohn—Moore19960411UHC-80866-83•••-••-40862061847JOHN.MOORE22@YAHOO.COM3523 MARKET STSACRAMENTOCA95863GRP-8753SELECT-EPO
ENRENR-1148812026-06-09T22:15:21ZJOYCECFULLER1999-02-20UHC-03777-19··•••-••-0824887-646-7752joyce.fuller@outlook.com·1031 Willow CtTAMPAFL33607GRP-5432NAVIGATE-HMO
ENRENR-1008852026-09-11T20:40:21ZArjun—Lucas1993-03-09UHC-83630-69•••-••-683112897502616arjun.lucas94@aol.com7452 Indian School RdNashvilleTN37237GRP-1598CHOICE-PLUS-PPO
ENRENR-1001212026-07-22T07:37:46ZMarkZ.Burke1994-05-26UHC-86223-27•••-••-8216····mark.burke47@icloud.com4572 Forest AvenueNashvilleTennessee37289GRP-1864CHOICE-PLUS-PPO··
ENRENR-1275882026-10-14T10:09:02ZHawkins, ThomasV—Mar 15, 1966UHC-30123-45UNKNOWN(721) 784-9964thomas.hawkins14@hotmail.comUNKNOWN——N/AGRP-5764MEDICARE-ADV-A
ENRENR-1136252026-10-18T01:02:35ZCAMILA··H·HAMILTON91710204UHC-11513-95•••-••-1419(979) 380-6921camila.hamilton62@proton.me2058 BroadwaySan AntonioTexas78253GRP-0150SELECT-EPO
ENRENR-1351622026-03-30T21:40:32ZJESSICA—WILLIAMSON1963-09-19UHC-41493-30•••-••-8168442-933-8171JESSICA.WILLIAMSON38@AOL.COM832 Canyon RoadJacksonvilleFL32255GRP-2153SELECT-EPO
ENRENR-1284902026-08-08T12:25:30ZKathryn··I.Perkins·13-02-2006UHC-22220-60•••-••-8639318.312.9339—8377 PINE DRIVEPLANOTX75042··GRP-6821SELECT-EPO
ENRENR-1232722026-02-01T08:32:41ZAmyI.Mason1963-06-15UHC-04213-55•••-••-4106678-938-5780—8372 Grand AvenueAtlantaGA30364GRP-0480MEDICARE-ADV-B
ENRENR-1412932026-07-21T04:27:04ZNicoleYRiec·06/05/1998UHC-50385-77•••-••-5060+1 963 476 0847nicole.rice@aol.com735 Mesa DrDenverCO80260GRP-4781CHOICE-PLUS-PPO
ENRENR-1005592026-02-26T18:25:12ZCHRISTINEW.BENNETT···19900823UHC-46148-59•••-••-6729(642) 515-5425CHRISTINE.BENNETT52@ICLOUD.COM1835 SUNSET BLVDGlendaleAZ85304-0194GRP-2445CORE-HMO
ENRENR-1170642026-06-20T21:58:50Z BenjaminXChen1976-09-15UHC-26104-20NULL6567646035·benjamin.chen@gmail.com1923 RIVER RDSeattleWA98142GRP-4966MEDICARE-ADV-A
ENRENR-1332362026-02-18T14:48:44ZSamanthaR.Palmer02/16/2007UHC-09047-81•••-••-8714378-734-6621SAMANTHA.PALMER99@GMAIL.COM523 LAKE VIEW RDLos AngelesCA—GRP-4623MEDICARE-ADV-A
ENRENR-1213582026-02-16T22:51:45ZAMY··D··MASON1974-07-27UHC-63861-38•••-••-7072UNKNOWN-5602 Camelback RdLas VegasNV··89113-8422GRP-6433MEDICARE-ADV-A
ENR ENR-1090242026-03-29T03:55:58ZAnn—Warren2006-02-08UHC-05037-76•••-••-7003(209) 893-9907-2342 Central AveDenverCO80200GRP-3981CORE-HMO
ENRENR-1241872026-08-12T13:24:48ZJeffrey—Bryant1955-12-05—•••-••-3296·969-766-8740jeffrey.bryant83@proton.me356 Camelback RdSacramentoCalifornia95823·GRP-2735NAVIGATE-HMO··
43,101 rows, page 297 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.458Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty