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-1097252026-09-27T16:09:25Zrachel—munozMar 17, 2004UHC-15937-04•••-••-3375(898) 508-4666-7646 Bayshore DriveEDEN PRAIRIEMinnesota55307··GRP-5816CHOICE-PLUS-PPO
ENRENR-1269182026-04-15T08:45:39Zjanet—morales1992-01-17··UHC-08987-22•••-••-6055256-252-4520JANET.MORALES66@YAHOO.COM1780 Spring StreetChandlerAZ··85240GRP-7508MEDICARE-ADV-B
ENRENR-1399892026-07-05T19:33:08ZAustinCWillis1996-10-05UHC-64753-14•••-••-6210-austin.willis98@gmail.com9501 SPRING STREET #137FresnoCA93714GRP-4231·OPTIONS-PPO
ENRENR-1306242026-09-11T05:26:03ZAndreaFDay1944-08-25uhc-82896-39•••-••-3058(345) 388-0772—6254 Cedar LnNashville··TN37283GRP-1983CHOICE-PLUS-PPO
ENRENR-140911 2026-06-29T14:31:57ZCHRISTOPHER—MEYER19970628UHC-42589-19•••-••-6272N/A-·4989 Sage CtMesa·AZ85216GRP-7987CHOICE-PLUS-PPO
ENRENR-1277862026-04-07T13:16:50ZGARY—GUERRERO·Dec 10, 1985UHC1872571•••-••-5385410-594-5149null5571 JEFFERSON AVENUELos Angelesca90070-0590GRP-9963OPTIONS-PPO
ENRENR-1258522026-01-06T05:57:36ZAngelaLWagner1942-12-13·-•••-••-90504498171—1573 Maple AvenueTucsonAZ85713GRP-4411NAVIGATE-HMO
ENRENR-1162932026-01-17T11:24:41ZRONALDX··BOYD1942-11-04UHC-40835-40•••-••-246318828864355RONALD.BOYD@HOTMAIL.COM6867 Baseline RoadTucsonAZ85798GRP-8757CHOICE-PLUS-PPO
ENRENR-1413872026-02-02T07:36:16ZkathrynKcampbell1983-12-01··UHC-94996-67•••-••-82026057720741null3280 Valley View DrLos AngelesCA90059GRP-0465NAVIGATE-HMO
ENRENR-1151322026-05-25T01:45:09ZMARY—MARTIN··1983-10-15UHC-02890-69··•••-••-15922564091693··mary.martin@aol.com9709 Union Street #493·OrlandoFL32850GRP-5491medicare-adv-b
ENR ENR-1282602026-02-16T19:32:43ZDiana—Vazquez1993-07-23UHC-02734-70•••-••-199614708913657DIANA.VAZQUEZ@PROTON.ME5173 RIVER RDJacksonvilleFL32292GRP-1046SELECT-EPO
ENRENR-1065232026-03-08T21:10:25Z·KeithDRuiz1948-05-02UHC-75807-16•••-••-0318(656) 496-2285KEITH.RUIZ88@PROTON.ME5718 Mesa Drive #484CharlotteNC28202GRP-3529medicare-adv-a
ENRENR-1124452026-04-19T05:05:55ZPrice, Aisha—····Aug 27, 1939UHC-23862-75•••-••-7612(406) 228-3541aisha.price86@yahoo.com2027 Ocean AveMIAMIFL33124·GRP-4309SELECT-EPO
ENRENR-1386732026-10-08T12:27:34ZMarcus—Rios1979-05-16UHC-71790-05•••-••-1268-marcus.rios@yahoo.com8761 HIGHLAND AVENUETucsonAZ85714-7294GRP-4316CHOICE-PLUS-PPO
ENRENR-1422512026-06-28T05:07:14ZTEERSAJ.HOFFMAN1969-07-13··UHC6862956•••-••-09795417593513UNKNOWN2386 Cedar LaneTampaFL·33654GRP-6164NAVIGATE-HMO
ENRENR-1402822026-02-24T10:25:29ZReed, Wayne——1949-07-04UHC-80993-98•••-••-4533713-390-9503wayne.reed31@proton.me4643 HILLCREST RDTempeAZ85200GRP-1689CHOICE-PLUS-PPO
ENRENR-1092552026-10-18T02:47:26ZALEXANDR—ALLEN1948-08-01UHC4657079•••-••-1393393-995-7465ALEXANDER.ALLEN47@YAHOO.COM6664 Forest AveDallasTX75221GRP-1433navigate-hmo··
ENRENR-1193052026-03-30T07:46:11ZTERRYXCOOK1972-05-04·UHC-61203-53•••-••-3063276-817-4444—1367 Forest AvenueFresnoCaliforniaN/AGRP-8502CHOICE-PLUS-PPO
ENRENR-1278162026-01-20T23:36:43ZDianeVPetersonMay 14, 1945UHC-44831-58•••-••-7060-DIANE.PETERSON67@YAHOO.COM7230 CHURCH STJacksonvilleFL32223GRP-0293CHOICE-PLUS-PPO
ENRENR-1230622026-07-22T04:22:54Zemily—johnsonSep 13, 1975UHC-34879-85•••-••-3119+1 428 998 1778EMILY.JOHNSON@HOTMAIL.COM··7510 Meadow LaneMiamiFlorida··33103GRP-3470CHOICE-PLUS-PPO
ENRENR-1031022026-08-25T02:29:54ZJAMESKWELCH1940-10-26UHC-63981-37•••-••-36362538935806james.welch@proton.me2755 Canyon Road··AustinTexas78771GRP-8715SELECT-EPO
ENRENR-102819 2026-06-19T19:55:16ZANDREWC.COOPER1/17/1975UHC-60313-72•••-••-786615254063091andrew.cooper@yahoo.com4864 Church StSan AntonioTX78275GRP-5318NAVIGATE-HMO
ENRENR-1171992026-05-11T11:39:24ZWang, JasonB.—07/04/42UHC-43783-35•••-••-2003(535) 431-9408JASON.WANG99@HOTMAIL.COMUNKNOWN—·UNKNOWNN/AGRP-0785OPTIONS-PPO
ENRENR-1068052026-02-23T16:50:18ZJohn—Daniels1964-03-14UHC-60949-65•••-••-9265+1 582 927 2496john.daniels99@icloud.com··5533 CENTRAL AVENUESan AntonioTexas78225GRP-2171CORE-HMO
ENRENR-1024032026-02-06T11:41:13Z anaPgarcia20030513UHC-21471-68•••-••-8600·(628) 291-8564ana.garcia@aol.com7115 Ocean Avenue··DENVER·CO80252GRP-5154SELECT-EPO
ENRENR-1223792026-07-22T18:42:39ZMADISON—TAYLOR1957-06-12··UHC-49436-32•••-••-74008817784455madison.taylor@gmail.com4368 SAGE CTSacramentoCalifornia95847GRP-2720·MEDICARE-ADV-B
ENRENR-1068752026-01-22T17:20:47ZDANIELLE—SILVA·11/19/1965UHC-68389-91•••-••-1001392-419-0147danielle.silva@yahoo.com·1052 JEFFERSON AVENUEPhoenixAZUNKNOWNGRP-4493SELECT-EPO
ENRENR-1369412026-05-14T11:24:52ZDYLAANUKING1938-09-20UHC-53344-87··•••-••-21244276498907··DYLAN.KING66@PROTON.ME2534 MARKET ST··COLUMBUSOH43275GRP-7417CORE-HMO
ENRENR-1254452026-10-14T20:14:30ZBillyOHayesFeb 14, 1996UHC-57906-35UNKNOWN865.572.6696billy.hayes35@proton.me6433 Ocean AvenueJacksonvillefl32281GRP-4263··CHOICE-PLUS-PPO
ENRENR-1415332026-05-03T21:30:55ZSamuelSVargas··20-02-1967UHC-87239-70•••-••-3047299-274-3281samuel.vargas75@outlook.com8009 Forest AvenueJACKSONVILLE·FL32221GRP-4528CORE-HMO
ENRENR-1326352026-08-27T15:58:49ZMaryG.Li1962-12-14UHC-75835-27•••-••-43516656680175····3250 Canyon RoadAustinTX··NULLGRP-4336CORE-HMO
ENRENR-1275592026-05-01T08:38:24ZKATHLEENU.—Aug 17, 1981··UHC-96127-46•••-••-7893(413) 703-8990KATHLEEN.CLARK33@ICLOUD.COM3451 SUNSET BOULEVARDOrlandoFL32860GRP-0772CORE-HMO
ENRENR-1348112026-06-10T23:21:06ZMATTHEW—SPENCER··08/26/02·UHC-03454-35•••-••-7830UNKNOWNmatthew.spencer25@aol.com3364 Forest AveJACKSONVILLEFL32217GRP-4686CHOICE-PLUS-PPO
ENRENR-1006312026-02-11T10:31:10ZKENNETHYEDWARDS07-12-2002UHC-87921-71•••-••-8149910-815-1752kenneth.edwards@yahoo.com·6068 Forest AvenueSacramentoCA95807-2071GRP-3483NAVIGATE-HMO··
ENRENR-1024062026-05-21T05:35:22ZEdward····Dunn1967-07-08UHC-58248-42•••-••-19172204327679edward.dunn19@icloud.com442 BROADWAYSCOTTSDALEaz85299GRP-1890MEDICARE-ADV-B
ENRENR-1169412026-03-30T05:28:00ZJoyce—Morrison09/09/76UHC-80236-49•••-••-10399802069359NULL4704 LINCOLN WAYColumbusOH43278··GRP-1917CORE-HMO··
ENRENR-1419232026-08-16T22:44:21Z·TYLER—FISHER10/15/70UHC-12257-40•••-••-0973597-724-2002tyler.fisher66@proton.me7191 Forest AvenueFresnoCA··93796GRP-6635CHOICE-PLUS-PPO
ENRENR-1142562026-02-27T08:34:34ZHIROSHIR.ELLIOTT1970-05-26··UHC-09860-18•••-••-5384201-937-9785null9492 Maple AvenueChandlerAZ85239GRP-6536SELECT-EPO
ENRENR-1024262026-10-07T23:27:25ZISABELLA—BOWMAN1953-10-22UHC-75417-10•••-••-4658-null1711 UNION STChandlerAZnullGRP-0873SELECT-EPO
ENRENR-1337742026-03-16T00:54:13ZRuth—Lucas1998-05-26UHC-14315-74•••-••-2149925.872.4151ruth.lucas41@icloud.com4141 BroadwayTempe·AZ85224GRP-6750SELECT-EPO
ENRENR-1344772026-05-24T06:24:26ZRuthKCollins19380206UHC-81446-80•••-••-52656046951RUTH.COLLINS@AOL.COM4725 Harbor BlvdCharlotteNC28279GRP-5432NAVIGATE-HMO
ENRENR-1240202026-04-15T19:26:14ZVINCCENT—HENDERSON1962-06-21UHC-29621-21N/A8365092297VINCENT.HENDERSON81@OUTLOOK.COM4468 Ocean AvenueHoustonTX77084-6553·GRP-8925NAVIGATE-HMO
ENR ENR-1047432026-02-05T11:09:21ZPHILIPV.NICHOLS20-02-1995UHC-60512-53•••-••-0012+1 228 726 2876philip.nichols94@proton.me9885 Cedar LaneNashvilleTN37243GRP-6860MEDICARE-ADV-B
ENRENR-1368412026-02-13T09:03:06ZDorothy—Baker1947-11-27UHC-63667-39•••-••-611015425975122DOROTHY.BAKER31@YAHOO.COM8973 Apache BlvdMinneapolisMN55424GRP-5907CORE-HMO
ENRENR-1106032026-01-14T03:02:32ZSCOTT—PENA1993-10-14UHC9509666•••-••-7701222-957-8212N/A2019 Oak StTucsonAZ85798-0265GRP-8093OPTIONS-PPO
ENRENR-1369182026-04-15T02:06:07ZjeffreyOsimpson04/16/1943UHC-82165-72•••-••-66136005883898jeffrey.simpson@proton.me4147 INDIAN SCHOOL ROAD Apt 36MIAMIFL33101GRP-5161OPTIONS-PPO
ENRENR-1135712026-08-25T18:50:24ZRoss, Jose——07/10/05UHC-02279-47-(920) 524-5106jose.ross69@aol.com477 Willow CtAustinTX78727·GRP-5126MEDICARE-ADV-A
ENRENR-1197192026-07-23T22:42:47ZgeorgeShernandez·3/23/1955UHC-67581-90•••-••-54852286317709george.hernandez6@gmail.com6868 Ridge Road #437MesaAZ85297-5712GRP-6677NAVIGATE-HMO
ENRENR-1040962026-05-27T12:33:16Z·Hawkins, Carolyn——1955-08-14UHC-24623-34•••-••-5415695.497.8570—354 Sunset BlvdSEATTLEWA98105-7626GRP-7737SELECT-EPO
ENRENR-1368792026-06-30T08:14:30ZJOSEPH—·MURRAY08-12-1968UHC-30365-32•••-••-2446+1 785 863 7017null·6592 Park PlPhoenixArizona85023GRP-9001NAVIGATE-HMO
43,101 rows, page 236 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.616Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty