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-1262712026-09-01T02:39:31ZMATEOOHANSEN23-01-1996UHC-39094-52•••-••-2856UNKNOWNmateo.hansen2@aol.com1668 JEFFERSON AVENUEChandler··AZ85243GRP-9170OPTIONS-PPO
ENRENR-1392332026-06-12T04:35:34Z Wells, Terry—····1979-08-25UHC-40621-57•••-••-9857(476) 468-3172terry.wells@hotmail.com818 BASELINE RD·MinneapolisMN·55497GRP-0525CHOICE-PLUS-PPO
ENRENR-101934 2026-07-21T15:40:02ZROBERTC··ALEXANDER3/8/1959UHC-08776-21•••-••-1445nullNULL814 CAMELBACK RDOrlandoFlorida32866-7129GRP-2692MEDICARE-ADV-B··
ENRENR-1078902026-02-17T18:48:07ZVICKY—WILSON1992-12-13UHC-22620-08•••-••-83203796636994·victoria.wilson19@gmail.com6030 Desert Sky BlvdJacksonvilleFL·32276·GRP-9263NAVIGATE-HMO
ENRENR-1022172026-04-05T10:50:17ZMateoKWarren1972-02-18UHC-09427-02•••-••-4662(662) 856-4848-9718 ELM STSacramentoCA95860GRP-1288CHOICE-PLUS-PPO
ENRENR-1331022026-04-09T12:37:35ZTERESA—CAMPBELL9161-04-18UHC-61936-67•••-••-1624931-983-5392teresa.campbell@gmail.com8865 Mountain View Drive··EDEN PRAIRIEMinnesota55357GRP-2903CORE-HMO
ENRENR-1106122026-06-07T05:41:19ZJOYCE—BAILEY19910218UHC-28841-84•••-••-99935255147377JOYCE.BAILEY@AOL.COM··6045 SUNSET BOULEVARDTucsonAZ85728GRP-9899core-hmo
ENRENR-1228052026-03-06T19:49:33ZLOGAN····RUSSELL22-11-1958UHC-41401-75•••-••-0367—logan.russell@outlook.com·8117 Apache BoulevardTampaFL··33682·GRP-2208MEDICARE-ADV-B
ENRENR-1006112026-08-30T12:06:34ZJOEVFERGUSON1963-11-02UHC-45515-59•••-••-74172183520876joe.ferguson@outlook.com4324 Jefferson AvenueCharlotteNC—·GRP-8561MEDICARE-ADV-B
ENRENR-1106042026-03-14T12:37:42ZJoseV.Maldonado1953-02-07UHC-41703-31•••-••-1515null··jose.maldonado6@hotmail.com7502 Meadow LnSan AntonioTX78212GRP-6931medicare-adv-a
ENRENR-1296662026-10-13T10:43:17ZETHANWJOHNSON··1976-05-26UHC-62410-16•••-••-3395—ethan.johnson@outlook.com9007 Hillcrest RdGlendaleAZ85384GRP-7141·OPTIONS-PPO
ENRENR-1428112026-04-29T15:30:21ZAnn··Lewis1960-10-11UHC-05814-43··815-934-3553ann.lewis@icloud.com7741 MESA DRIVE·TampaFlorida33681GRP-4882CORE-HMO
ENRENR-104716 2026-06-03T18:22:26ZNicole—Wood5/7/2002UHC-81471-19•••-••-6217null—3460 SAGE COURTSan AntonioTX78286GRP-8377CHOICE-PLUS-PPO
ENRENR-1375032026-06-01T21:45:54ZGary—Vargas09/07/1949UHC-01629-87•••-••-1584(367) 236-2843gary.vargas41@gmail.com4106 Canyon RoadHoustonTX77057GRP-9781SELECT-EPO
ENRENR-1196412026-05-20T02:33:45ZDiana—Wright1963-07-12UHC-33929-60•••-••-29477694183111—5912 DESERT SKY BLVDTucsonAZ85795GRP-9534SELECT-EPO··
ENRENR-1275572026-02-04T20:50:35ZVALENTINAJALVAREZ11/16/1962UHC-86730-68•••-••-08459802741149—2460 Jefferson AveAtlantaGA30378GRP-5752CORE-HMO
ENR ENR-1237982026-09-11T20:50:35ZAlexisSPena1998-02-07UHC-80594-44•••-••-5925298.691.8991alexis.pena4@gmail.com2715 Harbor BlvdGilbertAZ85222GRP-3311OPTIONS-PPO
ENRENR-1116502026-02-12T00:03:49ZRoyFBaker1988-08-17UHC-30265-04•••-••-9411609-912-0916··—·3050 ELM STREETPhoenixAZ85061GRP-2112select-epo
ENRENR-1028782026-08-19T23:34:37ZJASON—MEDINA10/28/1983··UHC-26945-97—9517626420jason.medina@proton.me9662 MAPLE AVESan AntonioTexas78252GRP-6166NAVIGATE-HMO
ENRENR-1326652026-09-25T05:01:22ZAaron·S.MedinaJul 2, 1965UHC-82011-22•••-••-2857(761) 809-7513aaron.medina10@gmail.com2075 Baseline RoadOrlandoFL32824GRP-1909NAVIGATE-HMO
ENRENR-117839 2026-07-25T23:22:18ZLauren—·Hill11/09/70··UHC7151782•••-••-9392(391) 724-0818lauren.hill@yahoo.com···7973 Park PlaceDenverCO80283GRP-8239OPTIONS-PPO
ENRENR-1247552026-05-16T03:14:23ZHelen—Estrada1950-12-12UHC7001961•••-••-9293—helen.estrada@gmail.com8146 Jefferson AvenueGilbertAZ85269··GRP-9886OPTIONS-PPO
ENRENR-136302 2026-01-15T00:36:28ZBENJAMINIMEJIA1944-06-10UHC-73524-90•••-••-9884(893) 649-9579benjamin.mejia69@proton.me2779 Cedar LnPlano··TX75061GRP-1179MEDICARE-ADV-A
ENRENR-1322612026-05-30T17:49:16ZMORENOGTIMOTHY1950-01-12UHC-33145-37•••-••-6099UNKNOWNTIMOTHY.MORENO30@ICLOUD.COM3220 Baseline RoadHoustonTX77041GRP-4422select-epo
ENRENR-1378102026-10-09T19:55:54ZNICHOLAS—KING··1992-05-02UHC-48082-65•••-••-56482465985861nicholas.king@yahoo.com2780 Oak StSan AntonioTX78231GRP-4140CHOICE-PLUS-PPO
ENRENR-1270922026-06-10T14:03:46ZMargaretWCarlson···05/22/1982UHC-27339-67•••-••-6117(570) 879-7604null4067 Ridge RoadPLANOTX75003GRP-8805MEDICARE-ADV-A
ENRENR-1361032026-04-26T07:02:35ZJanet—Dixon1983-02-25UHC-86590-78•••-••-6884(305) 281-5865JANET.DIXON@GMAIL.COM6872 PALM DRSeattleWA98184GRP-0326·CORE-HMO
ENRENR-1109232026-09-26T04:40:16ZMRK—SILVVA1994-06-25UHC-12194-34•••-••-23319606861955MARK.SILVA@AOL.COM1331 SUNSET BLVDAustinTX····GRP-9713CORE-HMO
ENRENR-1110002026-08-14T13:30:17ZSarahPGreene06/16/01—•••-••-2885·+1 902 933 5743SARAH.GREENE10@PROTON.ME8369 Canyon RdLos AngelesCA—GRP-6743SELECT-EPO
ENRENR-1371132026-02-14T16:36:08ZHannahZHarris1962-05-09UHC-42317-04UNKNOWN570-309-5337hannah.harris@gmail.com··4928 BAYSHORE DRGlendaleAZ85356GRP-7201CHOICE-PLUS-PPO
ENRENR-1219812026-08-12T15:24:43ZJEAN—·MORENO19880701UHC-83260-90•••-••-06603163637604null···739 MEADOW LANEDenver·CO80224-8961GRP-2906NAVIGATE-HMO
ENRENR-1056682026-10-04T06:43:27ZMEGANQFOX1971-06-23··UHC0650128•••-••-4033398-256-1019megan.fox@outlook.com7489 Union St·GlendaleAZNULLGRP-3314MEDICARE-ADV-B
ENRENR-1168342026-08-16T11:54:28ZJUSTIN—JENKINSApr 23, 2001UHC3939063··•••-••-62777803143492-2202 HARBOR BLVDDallas·TX75277··GRP-7227MEDICARE-ADV-B
ENRENR-1335812026-09-06T05:08:26ZSandraH.Franklin1959-05-10UHC-47968-23•••-••-8899(821) 305-5969—·1529 Camelback RoadSan AntonioTX78289GRP-1364OPTIONS-PPO
ENRENR-1092422026-08-09T04:15:49ZDONNA—GARZA9/22/1997··UHC-07556-64•••-••-7875337.566.3352—8852 Maple AveColumbus··OH43299GRP-9110MEDICARE-ADV-A
ENRENR-1235942026-06-08T08:29:26ZLARRY—ROGERS1970-02-10UHC-32272-09•••-••-0631(418) 949-3983larry.rogers@proton.me7957 HIGHLAND AVENUE··EDEN PRAIRIEMinnesota·55349GRP-2171··MEDICARE-ADV-A
ENRENR-1327702026-04-04T15:06:44ZAMYQSIMPSON2/17/1969UHC-73157-40•••-••-06867244985amy.simpson@gmail.com8176 Bayshore DriveLas VegasNV89144GRP-7649OPTIONS-PPO
ENRENR-1110152026-03-08T14:07:34ZMARIANAD.FIELDS11/22/60UHC-96749-28·null·602-228-5654null4850 APACHE BOULEVARD··MESAAZ85234GRP-1044NAVIGATE-HMO
ENRENR-1355132026-08-05T02:11:54ZMARIANA—WILLIAMSON1411-19-58UHC-04332-28•••-••-6817nullMARIANA.WILLIAMSON@PROTON.ME8477 River Road Apt 35GilbertAZ85258GRP-8758MEDICARE-ADV-B
ENRENR-1061702026-07-17T01:09:55ZPATRICKS··CASTILLO1989-01-01UHC-12275-94•••-••-2980·+1 815 456 0222patrick.castillo73@proton.me106 RIDGE RDNashvilleTN37210GRP-3087CORE-HMO··
ENRENR-1071992026-02-03T17:12:45Zpatrick··Rselazar1950-10-08UHC-04135-23•••-••-1907202-798-1261—·920 Main StreetGlendaleAZ85377GRP-6729MEDICARE-ADV-A
ENRENR-1039522026-07-02T23:21:23ZkimberlyWespinoza··1961-04-10UHC-60403-35•••-••-96744553350626KIMBERLY.ESPINOZA73@GMAIL.COM·229 Harbor BlvdTempeAZ85257GRP-2308OPTIONS-PPO
ENRENR-1147312026-06-28T14:59:38ZroyI··olson12/13/56··UHC-80127-17··•••-••-9989(227) 218-9033-1270 Sunset BlvdSacramentoCA95897··GRP-7239MEDICARE-ADV-B
ENRENR-1139922026-02-05T01:05:59Z·Willie—·Gibson1994-04-23UHC-28593-69•••-••-74313512575155willie.gibson@aol.com3603 Harbor BoulevardTampa·Florida33695GRP-8272MEDICARE-ADV-B
ENRENR-100087 2026-06-14T21:15:09ZARMSTRONG—VINCENT···1980-04-15UHC-92198-01•••-••-42039833958vincent.armstrong@aol.com2765 Bayshore DrFresnoca93752·GRP-4607SELECT-EPO
ENRENR-1376012026-03-18T08:24:14ZKevin—Hunt1991-04-08UHC-33272-12··•••-••-670717133598236UNKNOWN3595 INDIAN SCHOOL RD #596Las VegasNV89118GRP-3164CORE-HMO
ENRENR-1169942026-05-18T17:54:47ZCheryl·KGuzman··2008-10-09UHC7161342•••-••-8891(967) 716-6258cheryl.guzman95@proton.me9620 Main StMinneapolis·MN55422GRP-1703··NAVIGATE-HMO
ENRENR-1290632026-07-04T14:47:40ZLORI—ROBINSON1955-05-14UHC2813943•••-••-3670(988) 545-7599··LORI.ROBINSON@AOL.COM1793 Mountain View DriveTAMPAFL33627GRP-6201medicare-adv-b
ENR ENR-1033472026-03-13T12:50:15ZKeith X.—Wells03/11/51UHC-14936-06•••-••-89252749000423keith.wells@hotmail.com9270 CAMELBACK ROADSan AntonioTX78287GRP-6251OPTIONS-PPO··
ENRENR-1283672026-08-30T10:13:30ZLuna—Andrea1944-04-19UHC-02184-82•••-••-5544270-483-3885UNKNOWN5085 OCEAN AVEColumbusOH43297··GRP-0859SELECT-EPO
43,101 rows, page 252 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.638Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty