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-1188852026-03-06T20:20:11Zkayla—knight·1945-02-22UHC-65232-63•••-••-3841-kayla.knight82@icloud.com··null—nullGRP-9793NAVIGATE-HMO
ENRENR-1394952026-03-16T10:54:36Z ·CARLOSZ.BOYD··1983-03-26UHC-50719-93•••-••-5750(941) 375-8219CARLOS.BOYD@YAHOO.COM2441 Spring StreetSeattlewa98165GRP-5949MEDICARE-ADV-B
ENRENR-1177912026-04-06T00:27:27ZMelissa—Whie05/10/00uhc-48799-02•••-••-27574706417155melissa.white17@aol.com8965 Main StreetTempeAZN/AGRP-1135·NAVIGATE-HMO
ENRENR-1364312026-02-17T21:07:54ZSchmidt, PaulE—·26-07-1957UHC-33818-80•••-••-10074433951762—6695 Washington StreetNashville··TN37229GRP-2234MEDICARE-ADV-B
ENRENR-1223602026-05-17T17:06:13ZruthPross1973-06-03UHC-15276-51•••-••-030817468187777RUTH.ROSS@GMAIL.COM4968 Lincoln WayCHANDLERAZ85285GRP-1399MEDICARE-ADV-B
ENRENR-1201552026-08-29T00:22:02ZAllen, Julie——2006-07-18UHC-71841-70•••-••-4121958-617-9676null455 INDIAN SCHOOL ROADDallasTX75215··GRP-0554CHOICE-PLUS-PPO
ENRENR-1032472026-09-20T17:02:01ZDEBRA—NGUYEN1948-10-05UHC-07786-72•••-••-44772652205441—2389 MESA DR·AustinTexas78736GRP-1220··CHOICE-PLUS-PPO
ENRENR-1135862026-03-06T16:16:21ZjuliaS.nguyen1969-11-02UHC-27419-79•••-••-0054465-803-1478JULIA.NGUYEN9@OUTLOOK.COM5776 MEADOW LANE Apt 20··CHARLOTTENorth Carolina28293GRP-2829MEDICARE-ADV-B
ENRENR-1025532026-05-26T11:47:02ZShirley—Wagner6/17/1975UHC-16792-74•••-••-4987+1 496 461 0251SHIRLEY.WAGNER46@ICLOUD.COM433 Spring StGilbertAZ85248GRP-8639MEDICARE-ADV-B··
ENRENR-1120152026-04-13T15:35:31ZLuisL·Greene15-06-2000UHC-14290-02•••-••-91215998528539··luis.greene@gmail.com5329 LINCOLN WAYAtlantaGA30372GRP-7057MEDICARE-ADV-A
ENRENR-1289572026-05-31T06:39:19ZJEAN—CHAVEZJun 7, 1965UHC-97809-22··•••-••-3686767-331-3354jean.chavez85@outlook.com1806 River RdSan Diegoca—GRP-9507choice-plus-ppo
ENRENR-1110072026-05-20T20:48:50ZAlexander—Perez1993-06-05UHC5807333•••-••-4140756-654-4101alexander.perez@aol.com1775 Lincoln Way··PhoenixArizona—GRP-3899MEDICARE-ADV-B
ENRENR-1104842026-07-24T06:21:41ZJESSICA—RIVERA2006-11-22UHC-07697-36•••-••-8993359-692-3588jessica.rivera93@yahoo.com207 Canyon RoadMiamiFL33103GRP-6435NAVIGATE-HMO
ENRENR-1265722026-09-08T16:21:13ZAISHA K—·JOHNSTON1974-07-24UHC-09878-17null3627002411····9013 HIGHLAND AVEColumbusOH43281GRP-0723medicare-adv-b
ENRENR-1418012026-01-14T13:41:36ZSNYDER—YUKI19570126UHC-83924-17•••-••-1130+1 862 572 4176yuki.snyder@gmail.com1331 Lincoln WaySacramentoCA95808GRP-1377NAVIGATE-HMO
ENRENR-1130692026-06-23T05:14:44Zevelyn—lee···Jun 8, 1981UHC-80205-94•••-••-9429—evelyn.lee@aol.com8558 CAMELBACK RDMinneapolisMN55409-8769GRP-8707SELECT-EPO
ENRENR-1380132026-06-07T00:26:45Z Anthony—Williamson1945-06-19UHC-42109-67•••-••-4338(869) 946-0594·N/A·6586 Indian School RoadLas VegasNevada89121GRP-1187·CORE-HMO
ENRENR-1228752026-04-22T14:32:33ZHenry—Chen1983-04-24UHC-49957-77N/A—N/A3732 PALM DRTucsonAZ··85754GRP-3972SELECT-EPO
ENRENR-1312062026-06-20T07:20:57ZFisher, Ralph····—1989-03-18UHC-77097-62•••-••-1081(867) 935-0563—5993 Bayshore DrLas VegasNV89157GRP-5288OPTIONS-PPO
ENRENR-1388192026-09-25T15:57:48ZJoan—Mason2/8/1973UHC-00755-30NULL6092016351··JOAN.MASON@ICLOUD.COM9406 Central Ave #927ColumbusOH·43270GRP-5428CORE-HMO
ENRENR-1264352026-01-24T22:29:14ZLAURENZKELLY11/07/03UHC9624464—····lauren.kelly@yahoo.com··1212 Hillcrest RdChandlerAZ85240GRP-7560CHOICE-PLUS-PPO
ENRENR-1303832026-06-30T03:25:51ZDianaB.Perkins04/01/72UHC-40992-46•••-••-5595(746) 972-3876diana.perkins@gmail.com7397 Church StreetNashvilleTN37297GRP-3048·MEDICARE-ADV-A
ENRENR-1427962026-07-08T04:11:48ZYUKIQ.ROSS22-08-1993UHC-61230-96•••-••-4302584-599-7999UNKNOWN7576 Indian School RdATLANTAGeorgia30325GRP-5106··MEDICARE-ADV-B
ENRENR-1137902026-09-10T17:13:09ZKayla—Bailey1981-10-10·UHC-99784-06•••-••-36616419740117kayla.bailey@icloud.com9032 Sunset BlvdTempeAZ85267GRP-9802MEDICARE-ADV-A
ENRENR-1095802026-04-25T07:02:36Z·ChristianSGibson2007-02-06N/A··•••-••-2425(331) 590-9253··christian.gibson@icloud.com7443 Palm DriveGlendaleAZ85301GRP-3144MEDICARE-ADV-B
ENRENR-1028212026-01-02T22:34:02ZBRYAN····WARREN19740214UHC-40178-96··728-213-2622BRYAN.WARREN44@OUTLOOK.COM8514 DESERT SKY BOULEVARDPhoenixAZN/AGRP-2064NAVIGATE-HMO
ENRENR-1000032026-08-29T03:30:19ZLaura—Alvarado1939-03-06UHC-46111-16•••-••-369612082046344laura.alvarado30@gmail.com4347 Church StPlanoTX·75086GRP-5461navigate-hmo
ENRENR-1152052026-10-08T14:12:47ZALEXANDERVSCHULTZ11/5/1967UHC-44327-61•••-••-2264—ALEXANDER.SCHULTZ@PROTON.ME7629 Desert Sky BlvdTucson·AZ85748GRP-2983SELECT-EPO
ENRENR-1421242026-04-11T22:39:54ZJacob—Garcia2/20/1988UNKNOWN•••-••-9532(335) 627-1115JACOB.GARCIA89@GMAIL.COM·4780 Meadow LnSeattleWA98126GRP-4114SELECT-EPO
ENRENR-1045772026-10-11T08:22:08ZRonald··GAlvarado1971-07-17UHC-24064-83•••-••-2602(580) 600-0138RONALD.ALVARADO6@PROTON.ME431 Lake View RoadMesaAZ85294GRP-8018CHOICE-PLUS-PPO
ENRENR-1137062026-01-02T11:25:33ZBennett, CatherineY.—1945-01-20UHC-61792-31··•••-••-0720·491.845.2836null9312 Indian School RoadORLANDOFL32854GRP-8343OPTIONS-PPO
ENRENR-1224582026-03-14T13:56:26ZdebraNvazquez1958-08-12UHC-72933-28•••-••-9715209-376-9922—1489 Main StreetMiamiFL33173·GRP-3914SELECT-EPO
ENRENR-1252262026-03-30T01:12:37ZDiegoERenolds1965-08-28UHC-43474-86•••-••-6834781-679-1916—3944 Market StPhoenixArizona85056GRP-8437MEDICARE-ADV-A
ENRENR-1392602026-01-25T06:05:34ZBRUCE—GARZA··1948-11-15UHC-00733-12•••-••-8594733-324-5407UNKNOWN··3302 JEFFERSON AVEPLANOTXUNKNOWNGRP-3928SELECT-EPO
ENRENR-1055492026-02-27T06:39:59ZRodriguez, Priya——Nov 12, 1950UHC-48070-64•••-••-873816889821901-3100 Apache BlvdSEATTLEWashington—GRP-4288CHOICE-PLUS-PPO
ENRENR-1016762026-08-26T19:26:15ZScottJGarrdner19950509UHC-89463-27•••-••-1259(807) 236-4122—7640 CENTRAL AVE Apt 36·Las VegasNV89111-0998GRP-3056CORE-HMO
ENRENR-1387232026-02-11T20:49:30ZJason, WillisU.··—1994-01-20UHC-47418-08•••-••-95936305161918jason.willis@proton.me5423 MEADOW LANEGilbertAZ85294GRP-7492SELECT-EPO
ENRENR-1137842026-01-19T13:55:06ZSAMUEL—MARTINEZ··1964-04-01uhc-28309-59•••-••-6049459-731-2304samuel.martinez@yahoo.com6530 Cedar LnGlendaleAZ85303··GRP-9640SELECT-EPO
ENRENR-1106682026-10-09T03:55:02ZBryanZSanders21-04-1976UHC-11135-76··•••-••-747217023817340bryan.sanders@icloud.com1169 MARKET STORLANDOFL32817GRP-5631OPTIONS-PPO
ENRENR-1130812026-04-10T02:54:05ZAlexis—Ruiz·May 5, 1973UHC-51707-54•••-••-7317··alexis.ruiz@yahoo.com3858 Harbor Boulevard #905SacramentoCA95828GRP-1695MEDICARE-ADV-A
ENRENR-1214752026-01-21T12:25:59ZHIROSHIZ.··SANCHEZ15-06-1999UHC-87722-88UNKNOWN··NULL—5705 Union StSACRAMENTOCalifornia·95809-5028GRP-2252OPTIONS-PPO
ENRENR-1063602026-06-03T01:41:06ZRuthEEspinoza03/03/1985·UHC6776880—3072056243ruth.espinoza37@gmail.com3435 Willow CourtColumbus··oh43296GRP-3602SELECT-EPO
ENRENR-1362332026-05-19T16:08:35ZFatima·K.Reid01/17/1946UHC3135909··——fatima.reid53@gmail.com1099 Baseline RoadDallasTexas75278GRP-7150·CHOICE-PLUS-PPO
ENRENR-1022822026-03-15T06:26:35ZJack—Clark·1994-03-13UHC-43129-98•••-••-6702(424) 819-1784JACK.CLARK60@HOTMAIL.COM·null-null—GRP-6882MEDICARE-ADV-B··
ENRENR-1371382026-01-27T00:55:02ZJoseph··BCollins··1939-04-21·UHC-89807-12•••-••-2804942-570-6991NULL2657 Willow CtScottsdaleAZ85256GRP-1045CORE-HMO
ENRENR-1216262026-07-12T06:14:55Zkimberly—matthews04/26/95UHC-07806-94•••-••-8476N/Akimberly.matthews@hotmail.com·8851 LAKE VIEW RDAustintx78745GRP-6078··CHOICE-PLUS-PPO
ENRENR-1191962026-05-29T06:33:42ZMarianaZWest·1971-08-21·UHC-37899-83•••-••-86166869797115—8020 Spring StreetMINNEAPOLISMN55453GRP-1176NAVIGATE-HMO
ENRENR-1378502026-10-05T05:24:15ZKATHLEEN—BOYDNov 5, 1948UHC-93061-53•••-••-20037916350971kathleen.boyd@icloud.com253 Oak StreetSan DiegoCA92153-8159GRP-2673NAVIGATE-HMO
ENRENR-1183522026-02-27T20:12:46ZFrances—King1988-05-04UHC-31602-81•••-••-61085065820088frances.king37@proton.me6888 Forest AveTempeAZ85254GRP-6655OPTIONS-PPO
ENRENR-1335172026-08-13T16:20:22Z Fox, PeterG—2000-02-11·UHC4385532NULL13789476021peter.fox20@gmail.com5462 FOREST AVENUEHOUSTONTX77083GRP-1451··MEDICARE-ADV-A
43,101 rows, page 279 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.436Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty