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-1070082026-07-04T07:50:43ZVICTORIA····LAWSON1999-08-01··UHC-84803-60•••-••-0536+1 487 656 2336··UNKNOWN7779 CENTRAL AVENUE··AustinTX··78723GRP-8678CHOICE-PLUS-PPO
ENRENR-1157592026-04-30T09:18:05ZMariaAWoods1969-06-16UHC-43006-38··•••-••-1461nullmaria.woods12@aol.com1048 Forest AveDENVERco80204GRP-2906MEDICARE-ADV-B
ENRENR-1009792026-05-13T04:56:03ZwayneUduncan1946-04-15UHC-81346-56•••-••-4895+1 366 358 9837·WAYNE.DUNCAN@AOL.COM7593 Market StreetMesaaz85293GRP-0967MEDICARE-ADV-B
ENRENR-1143032026-02-04T19:32:23Zjoseph—watkins—UHC-68165-43•••-••-4783483-980-7908joseph.watkins@yahoo.com8272 SUNSET BLVDCharlotte·NC28277GRP-2378MEDICARE-ADV-A
ENRENR-1044072026-03-23T07:54:36ZJudith—·Pena7/1/1942UHC-33351-65•••-••-09063577501573JUDITH.PENA58@YAHOO.COM495 Willow CtGLENDALE·AZ·85335GRP-2281MEDICARE-ADV-A··
ENRENR-1225982026-05-06T07:42:16ZSantiagoM.Ferguson1970-12-15··UHC-71174-76•••-••-3066+1 646 683 3057··SANTIAGO.FERGUSON36@AOL.COM2728 HILLCREST RDFRESNOCAUNKNOWNGRP-5539·SELECT-EPO
ENRENR-1240222026-09-10T09:12:55ZJeffrey—Garrett01/04/1938UHC-19175-98•••-••-8693—jeffrey.garrett76@proton.me1295 SAGE CTChandlerAZ85250GRP-3536SELECT-EPO
ENRENR-1044002026-09-23T13:24:14ZVazquez, Heather——1997-06-06·UHC-76189-52•••-••-7352—HEATHER.VAZQUEZ66@AOL.COM2802 PARK PLSan AntonioTX78238GRP-2992MEDICARE-ADV-A
ENRENR-1352952026-05-26T10:08:10ZChristopher—Carpenter1969-05-10UHC-61694-01•••-••-772818997561401CHRISTOPHER.CARPENTER62@PROTON.ME1372 Grand AvenueMinneapolisMN·55475·GRP-9161NAVIGATE-HMO
ENRENR-1169362026-04-19T10:37:34ZTYLERJBARNES02-09-1950UHC-07520-05N/A18109063689tyler.barnes54@outlook.com2150 INDIAN SCHOOL ROADSeattleWA98177GRP-3205CHOICE-PLUS-PPO
ENRENR-1235162026-01-12T15:28:47ZDouglas··Jenkins1981-12-13UHC-58420-34•••-••-4035(939) 746-1990DOUGLAS.JENKINS94@HOTMAIL.COM7972 Camelback Road·ColumbusOH43250GRP-3382MEDICARE-ADV-A··
ENRENR-1023102026-06-19T19:36:21ZKennethRMarshall2003-03-20UHC-85421-07•••-••-543116645396274kenneth.marshall77@icloud.com··7655 Camelback Rd·Las VegasNV-GRP-5332SELECT-EPO··
ENRENR-1021912026-01-23T11:05:11ZAlexis····Little07/16/84UHC-97948-59•••-••-2132700.519.1828··—3461 Baseline Road #710ChandlerAZ85260GRP-9549SELECT-EPO
ENRENR-1362452026-09-05T02:41:42ZRaymondL.Phillips1/28/1995UHC-34319-11•••-••-6557(403) 734-1297NULL1479 Baseline Rd··GlendaleAZ85314GRP-7940·CHOICE-PLUS-PPO
ENRENR-1040712026-06-14T13:04:51ZSamantha—Vazquez19720108UHC-23134-85•••-••-9908(934) 893-0838—9424 Highland AvenueGlendaleAZ85312GRP-9749CORE-HMO
ENRENR-1178142026-08-19T09:48:48ZNatalieQBell2005-03-27UHC-15700-52•••-••-5995—natalie.bell87@yahoo.com2327 Highland AvenueSacramentoca··—GRP-2900··CHOICE-PLUS-PPO
ENRENR-1046242026-06-18T04:19:50ZShaw, Kelly··N··19941210UHC-70062-36•••-••-54086076675610KELLY.SHAW91@OUTLOOK.COM7662 Lake View RdChandlerAZ85265GRP-1623CORE-HMO
ENRENR-1110812026-01-18T10:30:38ZHenderson, AnthonyE—1989-01-09UHC9293547UNKNOWN(226) 227-0341ANTHONY.HENDERSON14@GMAIL.COM3140 Central AvenueTucsonAZ85701GRP-2465NAVIGATE-HMO
ENRENR-1180012026-04-13T19:29:17ZMark—Butler11/12/81UHC-21957-53•••-••-2218UNKNOWNmark.butler@yahoo.com·6042 River RdColumbusOH43275GRP-8401MEDICARE-ADV-A
ENRENR-1029422026-02-01T01:46:14ZEspinoza, AmberP—1948-01-22UHC-65231-24•••-••-09467003070359amber.espinoza@icloud.com·1009 Mountain View DriveLOS ANGELESCA90062GRP-2881NAVIGATE-HMO
ENRENR-1390682026-03-17T02:02:06ZSandraGHart···1957-12-16UHC-88610-44•••-••-00818397903·sandra.hart@hotmail.com9810 JEFFERSON AVESAN DIEGOCA92119GRP-6806SELECT-EPO
ENRENR-1009002026-06-20T08:39:24ZWalker, Sean——1942-01-28UHC-66374-17•••-••-356519216832371SEAN.WALKER68@HOTMAIL.COM329 Jefferson AveTucsonAZ85784GRP-9607OPTIONS-PPO
ENRENR-1100052026-06-18T12:18:48ZGregory—Wagner1987-12-28UHC-51627-22•••-••-7771(941) 838-3423gregory.wagner82@icloud.com6925 BroadwayMIAMIFlorida33105GRP-0528OPTIONS-PPO
ENRENR-1267992026-04-12T01:49:43ZPatrickL.Chavez09/23/1957UHC-06289-61NULL414-681-3859PATRICK.CHAVEZ@HOTMAIL.COM6009 BASELINE ROADDenverCO80283GRP-7985CORE-HMO
ENRENR-1110242026-03-12T07:31:34ZJACQUELINE—YANG1995-11-26UHC-86549-94•••-••-05979155081646·jacqueline.yang78@yahoo.com100 Ocean AvenueAustinTX78774GRP-6312CORE-HMO
ENRENR-1144762026-02-10T08:14:21ZAdaam—Mendez26-12-1974UHC-06210-34··•••-••-667214866742353adam.mendez36@outlook.com·2377 Ridge RdOrlandoFL··—GRP-9132CORE-HMO
ENRENR-1241612026-06-03T19:57:18Z·DORISICHAVEZ09/12/1966UHC-21944-44•••-••-80696686305734doris.chavez@proton.me6224 Grand AvenuePhoenixArizona85014GRP-0452MEDICARE-ADV-A
ENRENR-1372942026-04-10T09:19:07ZBurton, Samantha——1994-07-02UHC-14642-65•••-••-4297575-322-0567samantha.burton30@aol.com·2849 Mesa DriveSACRAMENTOCA95840GRP-9825SELECT-EPO
ENRENR-1182682026-08-31T03:13:26ZGREGORY··L.MARQUEZ1958-06-14UHC0972702•••-••-2671724-843-5785gregory.marquez84@gmail.com5659 Ridge RoadLOS ANGELESCalifornia90054GRP-5686MEDICARE-ADV-A
ENRENR-1417412026-05-31T15:13:07ZAlexis—McCoy1984-03-02UHC-08132-83··null16277050590··alexis.mccoy20@outlook.com4642 Forest AvenueLas VegasNV89104GRP-0551CHOICE-PLUS-PPO
ENR ENR-1131202026-03-23T16:12:35Zlori F··—gardner1955-11-11UHC-82159-44•••-••-1751(771) 588-3281lori.gardner73@aol.com·6077 WASHINGTON STDallasTX75287··GRP-5988NAVIGATE-HMO
ENRENR-1167882026-08-08T17:38:45ZJOSHUAI.MOENO1994-08-02UHC-31320-52•••-••-1961(452) 523-6822··JOSHUA.MORENO10@PROTON.ME5782 Market StreetMesaAZ85262GRP-2966·NAVIGATE-HMO
ENRENR-1281972026-01-19T05:46:42Z·LoganF.Mills··2004-06-12UHC2198389•••-••-75435779904428LOGAN.MILLS18@GMAIL.COM3968 GRAND AVE #848Sacramento··CA95851GRP-5175NAVIGATE-HMO
ENRENR-1371072026-03-20T06:46:18ZAdams, AnaO.—1944-07-09UHC-91260-01•••-••-40449769096894ana.adams@outlook.com9369 OCEAN AVENUEPHOENIXazUNKNOWNGRP-9849NAVIGATE-HMO
ENRENR-1424022026-07-18T17:00:40ZDAVIDXHOWELL1978-06-19UHC-89122-31•••-••-3577+1 318 687 8158david.howell@aol.com1246 Camelback RoadColumbusoh43210-0775GRP-0847MEDICARE-ADV-A
ENRENR-1217502026-07-26T07:16:22ZLARRY—MORENO1940-07-06UHC-71808-93•••-••-5207782-999-0173larry.moreno@icloud.com572 BASELINE RD··LAS VEGASNV89101GRP-3796NAVIGATE-HMO··
ENRENR-1381882026-07-24T16:43:23ZAmyKMorrison1977-02-06UHC-29243-33•••-••-1847484-639-6784amy.morrison@icloud.com4055 Palm DriveAustinTX78794··GRP-1225options-ppo
ENRENR-1239522026-10-02T15:42:47ZJudithG··Cunningham1986-06-05·UHC-73518-90•••-••-1094713-519-4974JUDITH.CUNNINGHAM@ICLOUD.COM··244 BroadwaySacramentoCA95828GRP-0234NAVIGATE-HMO
ENRENR-1242722026-07-20T07:04:06ZpriyaW.henderson1942-09-26UHC-79286-86•••-••-8364(733) 398-7726priya.henderson@aol.com3004 Cedar LaneTucsonAZ85718GRP-9253CORE-HMO
ENRENR-1266942026-08-16T07:12:24ZGREGORYXRIVERA1956-02-21UHC-01682-52•••-••-9102942-662-8580gregory.rivera@gmail.com40 Park PlaceOrlandoFL—GRP-2604MEDICARE-ADV-B
ENRENR-1196072026-01-11T07:09:41Z alert—james1962-11-11UHC-00467-13•••-••-9241(835) 757-2854albert.james@aol.com2638 Forest Ave #327Tempe··AZ85266GRP-3919MEDICARE-ADV-B
ENRENR-1405402026-06-20T09:29:56ZDENNIS—BROWN1944-05-22UHC-22981-87•••-••-2007506-291-5317dennis.brown@proton.me5143 Cedar LnMINNEAPOLISMN55447-0725GRP-0905MEDICARE-ADV-A
ENRENR-1050692026-03-11T18:42:34ZGEORGE··—MALDONADO2003-06-28UHC-54438-55•••-••-50594502481101NULL·8555 PALM DRIVETampaFL33677GRP-4486SELECT-EPO
ENRENR-1068652026-01-21T22:19:29ZAnthony—Guerrero1993-12-01UHC-84143-49•••-••-1347(617) 772-5230anthony.guerrero@hotmail.com5499 Church StreetLos AngelesCA90034GRP-9452NAVIGATE-HMO
ENRENR-1219702026-05-14T00:13:47ZHamilton, PaulS—1992-07-03UHC-41906-30•••-••-4493(315) 674-6589paul.hamilton84@icloud.com5227 Lake View RoadAtlantaGA30300·GRP-5394MEDICARE-ADV-A
ENRENR-1016312026-08-21T13:40:43ZJessica—Weaver1990-02-13UHC-56598-09•••-••-78767916246jessica.weaver@icloud.com5857 HARBOR BLVDChandlerAZ85230GRP-0648MEDICARE-ADV-A
ENRENR-108333 2026-07-18T14:39:03Zsteven—rivera19-04-1957UHC-73623-40•••-••-9344(426) 332-1532steven.rivera86@aol.com5363 Hillcrest RoadLas VegasNV89149GRP-6797SELECT-EPO
ENRENR-1303642026-09-23T01:54:23Z·CAROLYN—EVANS0051-19-80UHC-34615-37•••-••-4150452-239-3819carolyn.evans@outlook.com2666 BroadwayScottsdaleAZ85203GRP-1688CHOICE-PLUS-PPO··
ENRENR-1350152026-05-28T13:10:55ZCATHERINEGDEAN1945-09-01UHC-42593-03•••-••-5987(287) 347-6345catherine.dean47@icloud.com417 Union StOrlandoFL·32866GRP-7189·CORE-HMO
ENRENR-1151992026-08-10T00:43:16Z Green, Gary——1981-07-19UHC3902135•••-••-1771355-913-8172——UNKNOWNN/A—GRP-4259SELECT-EPO
43,101 rows, page 111 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:37.751Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty