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-1227142026-07-12T19:45:48Zlori··—mills1997-04-24UHC-32856-97•••-••-6125+1 202 376 1406lori.mills62@yahoo.com4405 Ridge RdMesa···AZ85220GRP-6375·SELECT-EPO
ENRENR-1201502026-06-28T15:01:09ZWhite, RyanL.—1997-06-15UHC-97161-39—(554) 894-3833—1067 OAK STREETAustinTX78761GRP-2674MEDICARE-ADV-B
ENRENR-1386582026-05-24T03:48:10ZJonathan—Green·2005-09-06UHC-90939-16•••-••-5665····JONATHAN.GREEN21@PROTON.ME43 DESERT SKY BOULEVARDORLANDOFL32851GRP-9102CORE-HMO
ENRENR-1183022026-09-15T12:57:17ZPadilla, SamuelV··—19-10-1955UHC-58277-73•••-••-3917+1 305 271 4392SAMUEL.PADILLA@HOTMAIL.COM6345 JEFFERSON AVENUE··MinneapolisMN55470·GRP-9864NAVIGATE-HMO
ENRENR-1189022026-08-23T23:42:49ZhenryJsullivan·1951-01-08UHC-26067-06•••-••-9749NULLhenry.sullivan@hotmail.com1538 Harbor Boulevard··Los AngelesCA90076GRP-1533MEDICARE-ADV-A
ENRENR-1251542026-07-21T03:51:01ZRandy···Harrison2000-01-26UHC-87479-89•••-••-0602(259) 250-9132randy.harrison@aol.com7261 Hillcrest RdDenverColorado80221GRP-1918CHOICE-PLUS-PPO
ENRENR-1025832026-06-06T18:21:45Z RUTH—MURRAY05/13/1938UHC-90896-58•••-••-97382893116770ruth.murray@hotmail.com1962 LAKE VIEW ROADDallasTX75259GRP-5012CORE-HMO
ENRENR-1304272026-07-09T02:46:03ZBrittanyOSandoval1970-02-25UHC-22787-33•••-••-374719126413441—9784 Jefferson AveCHARLOTTENC28253GRP-0624··OPTIONS-PPO
ENRENR-1015172026-09-10T11:47:41ZMARK—GOMEZ1962-09-20UHC-29262-82··•••-••-7246(484) 905-6405MARK.GOMEZ12@GMAIL.COM5250 INDIAN SCHOOL ROADEden PrairieMN55378·GRP-7904MEDICARE-ADV-A
ENRENR-1127222026-09-11T01:00:14Z·TimQWelch··03-03-1945UHC-08254-58•••-••-57415102788020timothy.welch43@yahoo.com7717 Central AveScottsdaleAZ85289GRP-5200OPTIONS-PPO
ENRENR-1366582026-07-28T05:32:06ZBeverlyM.Martin1939-09-14··UHC-82779-58•••-••-9487(790) 781-0395BEVERLY.MARTIN72@PROTON.ME5732 Harbor BlvdTampaFlorida33628GRP-7290SELECT-EPO
ENRENR-1117582026-08-15T21:35:55Z PaulJStevens19730121·UHC-50401-72•••-••-4607·(946) 743-8869—9296 HARBOR BOULEVARDPlano··TX75098GRP-3269CHOICE-PLUS-PPO
ENRENR-1351032026-04-07T01:48:42Zsandra—patel2000-10-27UHC-42242-89UNKNOWN·8219423767sandra.patel@gmail.com1212 Lake View RdAustinTexas78746GRP-7780MEDICARE-ADV-B
ENRENR-1325142026-07-09T15:17:45ZDanielleWFord1950-05-11UHC-82549-91•••-••-2400369.600.7392··—7202 Oak StreetMesaAZ85290GRP-9107MEDICARE-ADV-A
ENRENR-1126212026-03-01T09:23:26ZSTEPHANIEX.SINGH·4/21/1998UHC-03575-18•••-••-5515(270) 590-2576N/A3788 Elm StColumbusOH43231GRP-5114CHOICE-PLUS-PPO
ENRENR-1017212026-06-14T01:07:22ZANGELAT··PENA2003-11-09··UHC7693448··—735-264-5965null··7321 Main StTampaFlorida33686GRP-3662MEDICARE-ADV-A
ENRENR-1368382026-05-08T22:16:10ZWilliamMHughes1/2/1978UHC-08089-69•••-••-5587(822) 456-3791william.hughes4@icloud.com9230 CANYON ROADMinneapolisMN··55426GRP-4499··CORE-HMO
ENRENR-1199702026-05-24T06:43:00ZSUSANHNELSON1962-09-22UHC-12236-44-841.514.5279susan.nelson20@gmail.com2924 Mountain View DriveMinneapolisMN55448GRP-6885MEDICARE-ADV-A
ENRENR-1155382026-05-08T11:46:49ZJessica—Valdez1954-05-06UHC-85656-59•••-••-2078—jessica.valdez60@gmail.com4450 PARK PLMesaAZ85297·GRP-2392CORE-HMO
ENRENR-1169282026-08-22T10:06:43ZBarbara—Vazquez1994-03-23·UHC-62480-15•••-••-4632(680) 457-6521barbara.vazquez84@hotmail.com6376 Forest Ave #172CHARLOTTENorth Carolina28203GRP-9180·MEDICARE-ADV-A
ENRENR-1150702026-09-11T16:08:16Z·ETHANX.··VASQUEZ06/11/1973UHC-61918-98•••-••-1885334-559-5001ETHAN.VASQUEZ@HOTMAIL.COM9113 WASHINGTON STREETLAS VEGASNevada89122GRP-9264MEDICARE-ADV-A
ENRENR-1171052026-10-03T20:37:31ZHaroldFHerrerra1971-11-22UHC-66704-26•••-••-18906588357376-3971 Grand AvenueMesaaz85294GRP-0868··CORE-HMO
ENRENR-1039382026-05-21T22:19:45ZWILLIAM—WEBB2004-10-25UHC-11907-97-8444813279WILLIAM.WEBB49@PROTON.ME3529 WILLOW COURTPhoenixAZ85087GRP-7129NAVIGATE-HMO
ENRENR-108079 2026-07-16T08:04:05ZAustin—Robertson1968-04-21UHC-38894-44•••-••-49012078587613austin.robertson@proton.me8721 Palm DriveLas VegasNV89127GRP-3089choice-plus-ppo
ENRENR-1252312026-03-19T02:40:00ZEugene····Bell2/8/1960UHC-07032-53•••-••-7927-N/A8207 Highland AvenueLas Vegas··NV89197-3309GRP-4325OPTIONS-PPO
ENRENR-1010992026-10-13T22:57:41ZYukiS.Fernandez1966-03-28UHC7416737•••-••-65427228011236YUKI.FERNANDEZ@HOTMAIL.COM9530 Indian School RdMesaAZ85291GRP-5385NAVIGATE-HMO
ENRENR-1399422026-01-21T03:37:38ZSophiaYWelch16-07-1938UHC0896987•••-••-1777(830) 319-8136NULL·9297 CHURCH STSan DiegoCA92171GRP-9830NAVIGATE-HMO
ENRENR-1108352026-09-09T17:02:13ZAngela—Montgmoery1972-11-26UHC-50629-28•••-••-5512+1 527 879 6421ANGELA.MONTGOMERY@ICLOUD.COM5712 Baseline Rd··PlanoTX75047GRP-8402CHOICE-PLUS-PPO
ENRENR-1404012026-08-18T08:05:43ZSTEPHANIE—COLLINS19780902·UHC-66946-05•••-••-10054836074739stephanie.collins@hotmail.com·5460 BASELINE RDMesaAZN/AGRP-5803CHOICE-PLUS-PPO
ENRENR-1241432026-05-13T15:23:58ZKellyH.Richardson··1959-01-18UHC-72131-03•••-••-74958436497305kelly.richardson@proton.me1166 Sunset Blvd Apt 39ATLANTAGA30394GRP-3759MEDICARE-ADV-A
ENRENR-1184562026-01-22T00:34:26ZrchardOwelch·11/08/44UHC-94329-01•••-••-5587(216) 959-0351richard.welch79@yahoo.com765 Jefferson AvePhoenixAZ85063GRP-2299SELECT-EPO
ENRENR-1183702026-01-03T19:26:38Z JustinJ.Carr10/9/1997UHC-30556-62—-justin.carr61@gmail.com6158 Lake View RoadATLANTAGA30361GRP-1064MEDICARE-ADV-A
ENRENR-1360682026-10-12T23:00:43ZLaurenR.Murphy1969-08-21··UHC4639791•••-••-2383923-729-7088NULL2578 Lake View Road #376OrlandoFL··32845GRP-3939medicare-adv-b
ENRENR-1041912026-08-20T15:17:38Zphilip—gray06-10-1948UHC-41519-25•••-••-44068574170224UNKNOWN9035 WILLOW COURT #251SeattleWA98164GRP-9140NAVIGATE-HMO
ENRENR-1235012026-10-10T02:27:38ZROGERQ.MORENO2005-01-25UHC-14982-28—(719) 989-9165roger.moreno@gmail.com5583 DESERT SKY BOULEVARDMiamiFlorida33163GRP-7222CHOICE-PLUS-PPO
ENR ENR-1228722026-07-10T22:36:14Z·EMILY—HARRIS19671025UHC-11654-18•••-••-0697(985) 476-8765emily.harris15@hotmail.com5568 Apache BoulevardOrlandoFL32860GRP-1238NAVIGATE-HMO
ENRENR-1235952026-03-11T12:32:19Z·JULIEGMYERS06/16/1971UHC-98913-91•••-••-91406525140597julie.myers84@yahoo.com2119 APACHE BOULEVARDFresnoCA93706··GRP-8920CORE-HMO
ENRENR-1013722026-02-25T12:48:16ZParker, KennethN—2001-02-16UHC-71358-38•••-••-8372NULLkenneth.parker63@proton.me6628 Baseline RdCharlotteNC28215GRP-0930OPTIONS-PPO
ENRENR-1254192026-04-07T09:50:18ZaliceJrojas1959-09-24UHC-48755-05•••-••-4150—-7541 Meadow LaneFresnoCA93736GRP-6320CORE-HMO
ENRENR-1321562026-07-27T01:38:45ZJoseFFord3/16/1992··UHC-20986-90•••-••-57018933759581JOSE.FORD@YAHOO.COM7707 Bayshore DrFresnoCA·93798GRP-0484MEDICARE-ADV-A··
ENRENR-1290922026-07-10T23:32:33ZScottHSpencer·25-04-1986——+1 630 538 3877—8322 Apache BoulevardJACKSONVILLEFL32255GRP-0797CHOICE-PLUS-PPO
ENRENR-1158452026-06-14T20:10:50ZryanNhart2006-11-18UHC-90985-99•••-••-9459621-373-5090ryan.hart70@hotmail.com27 Sunset BlvdAtlantaga30318GRP-7063CHOICE-PLUS-PPO
ENRENR-1256032026-01-09T22:47:38ZPatricia—Flores1940-05-14UHC-06947-85•••-••-5513UNKNOWNpatricia.flores27@outlook.com8097 Sage CourtGilbertAZUNKNOWNGRP-9137CORE-HMO
ENRENR-1425242026-06-27T11:19:01ZBEVERLY—CARLSON··05/25/81UHC-50578-50•••-••-2248337.273.7487N/A7248 Grand Avenue··Austin··TX78747GRP-5379SELECT-EPO
ENRENR-1369802026-05-15T04:26:08ZRANDYDWARD1966-08-21UHC-18923-49•••-••-448318625117728randy.ward@outlook.com5264 SAGE CTMesaAZ85277GRP-6609NAVIGATE-HMO
ENRENR-1154152026-07-16T10:12:15ZELIZABETH—GRANTJun 1, 1992UHC-04739-79•••-••-89336785805174elizabeth.grant98@hotmail.com3021 Apache BlvdEDEN PRAIRIEMinnesota55386GRP-8342MEDICARE-ADV-B
ENRENR-1252902026-08-03T15:57:50ZAnaHHanson1988-10-27UHC-31344-33•••-••-7667(292) 777-9579ana.hanson94@icloud.com7596 Palm DriveMiamiFL33176·GRP-3340MEDICARE-ADV-A
ENR ENR-1223882026-02-03T11:52:17ZJoan, Cooer——1/5/1991UHC-11316-57•••-••-271912995173552joan.cooper@icloud.com2610 SAGE COURTJACKSONVILLE··FL32272GRP-3163CHOICE-PLUS-PPO
ENRENR-1199092026-03-01T17:36:52ZJoeC.Garrett20050528UHC-59014-53•••-••-4895NULLN/A2495 HILLCREST RDTEMPEAZ85223GRP-5630CHOICE-PLUS-PPO
ENRENR-1180222026-02-20T15:32:24ZTYLERLVARGAS·1952-02-02UHC-56719-66•••-••-1696899-793-8447tyler.vargas@proton.me3827 Main Street·COLUMBUSOH43218GRP-1854OPTIONS-PPO
43,101 rows, page 294 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.455Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty