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-100870 2026-02-01T02:52:59ZSpencer, WilliamL.—2003-07-20UHC-77918-24—7996100622N/A6014 Baseline RdSACRAMENTOCA95821GRP-7567MEDICARE-ADV-A
ENRENR-1115672026-07-02T02:00:57ZBailey, Dylan——05/07/1960UHC-82883-31·-7243237361dylan.bailey35@proton.me4044 Sunset BlvdLos AngelesCA90003GRP-0196CHOICE-PLUS-PPO
ENRENR-139938 2026-08-28T17:32:29Zdennis··—nelson1992-09-02UHC-45196-98•••-••-1692(957) 776-2306··dennis.nelson60@aol.com8076 Valley View Dr··ScottsdaleAZ85218GRP-1540CORE-HMO
ENRENR-1212362026-07-26T23:38:19ZHeather—Parker10/05/1963UHC-09095-27··•••-••-3483—·heather.parker@proton.me4494 Market StreetMinneapolisMN55458GRP-9858CORE-HMO
ENRENR-1379652026-09-26T22:17:33ZSOFIAWELLIS19861124·UHC-04054-91•••-••-6041—sofia.ellis@gmail.com2636 CHURCH STREETORLANDOFL32888-3983GRP-0299MEDICARE-ADV-B
ENRENR-1232602026-01-18T18:58:48ZBenjaminVCollins1496-03-27UHC0858829•••-••-808418878730572BENJAMIN.COLLINS29@ICLOUD.COM100 CENTRAL AVENUECharlotteNC—GRP-8427CORE-HMO
ENRENR-1141042026-09-15T10:42:54Z KEVIN—PARKER··2006-06-06UHC-33578-30•••-••-83285375484730KEVIN.PARKER61@AOL.COM4924 Lake View RdPhoenixAZ85082GRP-2544SELECT-EPO
ENRENR-1104222026-08-26T00:34:25ZADAM····WALSH19721101UHC-68037-68•••-••-7892941.638.5838adam.walsh@gmail.com7280 Ocean AvenuePlanoTX75020··GRP-2610OPTIONS-PPO
ENRENR-1196142026-10-14T02:33:07ZDENNIS··—HAMILTON08/11/38UHC-89766-39•••-••-5847UNKNOWNNULL3844 FOREST AVELos AngelesCA90079GRP-1513MEDICARE-ADV-A
ENRENR-1231162026-01-25T02:03:56ZJacob—Cooper6/10/1976UHC-40451-39•••-••-8547982-957-4303—7873 JEFFERSON AVENUESAN DIEGOCA92167GRP-3422CORE-HMO
ENRENR-127226 2026-03-22T14:46:24ZDENNIS—RAY1961-07-12UHC-11585-25•••-••-9875363-969-1845dennis.ray@hotmail.com959 Sunset BlvdAtlantaGA30368GRP-0529·OPTIONS-PPO
ENRENR-1261032026-08-02T06:59:23ZkyleJ.garrett1972-02-20UHC-88130-48•••-••-4977508-657-8915kyle.garrett15@proton.me1381 Apache BoulevardJacksonvilleFL32299GRP-7672CHOICE-PLUS-PPO
ENRENR-1096202026-05-04T00:09:54ZJudy·DClark04-12-1983UHC-51036-46•••-••-1621(831) 579-4265null6401 Highland Avenue·GLENDALEArizona85334GRP-3473MEDICARE-ADV-B
ENRENR-1247362026-09-30T04:06:25ZMeganS.Perkins··1971-02-17uhc-57518-79•••-••-9082·781-937-0943—7113 APACHE BLVDDenverCO80209GRP-6841CORE-HMO
ENRENR-1308872026-09-19T10:44:19ZGERALDK.PERKINS10/22/83UHC-47298-31•••-••-6085(339) 624-7346-9658 Maple Avenue··GlendaleAZ··85394GRP-0209MEDICARE-ADV-B
ENRENR-1192732026-03-23T10:04:01ZEvelynVHawkins7/18/1945UHC-71285-92•••-••-0046(493) 812-2050evelyn.hawkins23@outlook.com5677 Harbor BlvdCharlotteNC28280GRP-6415CORE-HMO
ENRENR-1179412026-10-10T00:18:37ZBRENDAPJIMENZE11/9/1948UHC-65193-54N/A4265998327brenda.jimenez@hotmail.com1286 Indian School RoadSeattleWA98116GRP-3361OPTIONS-PPO
ENRENR-1079062026-04-09T10:09:53ZLoganQ.Carpenter13-02-1977UHC-39590-29•••-••-3359nulllogan.carpenter@hotmail.com8727 LINCOLN WAYColumbusOHN/AGRP-7310SELECT-EPO
ENRENR-1249272026-02-03T17:10:54ZCAROLBGIBSON01/10/1941UHC-92939-34•••-••-566813465222203CAROL.GIBSON35@OUTLOOK.COM6007 OAK STREETTempeAZ85235GRP-7004CORE-HMO
ENRENR-1197842026-08-15T19:58:19ZPamela—Austin1943-06-16UHC-05115-47•••-••-28206653008pamela.austin24@icloud.com4921 Grand AvenueScottsdale··AZ85250-4542GRP-7599SELECT-EPO
ENRENR-1225782026-07-15T13:34:24ZRACHELQ.··BURTON1959-08-26UHC-31823-84•••-••-6536(634) 203-5015rachel.burton@proton.me7580 Maple AveEDEN PRAIRIEMN·55354GRP-2806medicare-adv-b
ENRENR-1124032026-07-18T10:02:03ZROBERT—EDWARDS2004-07-11UHC-38119-75•••-••-6337+1 286 616 3981····3734 Desert Sky BoulevardAustinTX78732GRP-1359NAVIGATE-HMO
ENRENR-1426952026-05-15T22:03:41ZPAUL··AMORRIS8/17/1987UHC-21357-84•••-••-8682(397) 445-6187paul.morris35@yahoo.com·9224 Sunset BlvdLas Vegas···NV·89157-8289GRP-8839··MEDICARE-ADV-A
ENRENR-1205822026-10-02T10:20:04ZLindaEGreen08/10/70UHC-04889-62•••-••-9904+1 607 782 6178—8032 Valley View DriveLos AngelesCalifornia90038-8247GRP-7112··MEDICARE-ADV-A
ENRENR-1095782026-09-15T08:41:28ZPowell··F.·Lisa10/19/1963UHC0570734•••-••-54116445209309lisa.powell@yahoo.com4384 Meadow LnSeattleWA98122GRP-2858CHOICE-PLUS-PPO
ENRENR-1352532026-01-14T05:13:03ZWeiO·Garza05/16/1973UHC-65237-74•••-••-3453831-611-2926··wei.garza@gmail.com4564 Ocean AvenueAtlantaGA30306GRP-9260NAVIGATE-HMO
ENR ENR-1150012026-02-26T12:40:07ZWatson, KathleenB—2/22/1959UHC-97472-60•••-••-5727·13643213792null2651 Pine DrHoustonTexas77032·GRP-0901·CHOICE-PLUS-PPO
ENRENR-1371632026-02-02T02:04:31ZWard, Meria—····1993-12-23UHC-62524-86NULL362-698-1115N/A7942 Lincoln Way #765PlanoTX·75034GRP-8212MEDICARE-ADV-B
ENRENR-132694 2026-03-13T10:46:03ZALAN—MENDEZ1999-04-23··UHC-09937-27•••-••-08142705100280null9237 LINCOLN WAYLas VegasNevada89135GRP-6633CHOICE-PLUS-PPO
ENRENR-1174822026-05-13T17:34:51ZKathleen—Oliver91490302UHC0605818•••-••-9372(845) 642-0416-3595 Spring StTampaFL33603GRP-3860CORE-HMO
ENR ENR-1253862026-07-12T19:08:43ZStephenHAlexanderFeb 1, 2006UHC-25900-07•••-••-7718267-215-3210stephen.alexander68@yahoo.com4982 MAIN STEden PrairieMN····GRP-2042NAVIGATE-HMO
ENRENR-126381 2026-09-22T01:25:06ZJUUANE.PADILLA2004-10-21UHC-00148-63—7244135479JUAN.PADILLA49@ICLOUD.COM2287 CEDAR LNSan AntonioTX78260GRP-3055MEDICARE-ADV-B
ENRENR-1306292026-10-10T08:31:12Z ELIJAH—SHAW1988-05-16UHC-98614-28•••-••-7579(752) 578-3872—1204 Cedar LnMinneapolisMN55466GRP-7323NAVIGATE-HMO
ENR ENR-1010462026-08-27T11:04:09ZDeborah—Butler2/19/1994UHC-90382-97•••-••-7538nullN/A6452 Church StreetSAN ANTONIOTexas··78232GRP-1777OPTIONS-PPO
ENRENR-1124212026-01-03T01:34:19ZEMILY—STEWART11/5/2005UHC0933670•••-••-0137727-601-0399emily.stewart18@icloud.com4286 Forest Avenue #201AtlantaGA30366GRP-4810OPTIONS-PPO
ENRENR-1239942026-07-06T10:04:46ZYuki—Barnes··19570403··UHC-87254-53•••-••-1104(779) 535-7853·null63 WILLOW CT Apt 27TucsonAZ85750-6856··GRP-5805MEDICARE-ADV-B
ENRENR-1274542026-04-24T05:55:37ZChristine··Simmons1969-07-11UHC-21756-63•••-••-68998657541704-5236 Cedar LnMesaAZ85281·GRP-0790MEDICARE-ADV-B
ENR ENR-1244322026-08-22T02:48:51ZGraham, Lauren——1979-06-03UHC-12369-48•••-••-565914347087361··LAUREN.GRAHAM@HOTMAIL.COM7492 Jefferson AvenueScottsdaleAZ·85207GRP-2897CHOICE-PLUS-PPO
ENRENR-1350582026-02-05T22:21:34ZHANNAH··—FORD1986-05-08UHC-68283-93•••-••-5373-··-5236 WILLOW COURTFresnoCA93752GRP-5363SELECT-EPO
ENRENR-1282762026-08-25T12:01:51ZElijah—Simpson19660823UHC-27833-58··NULL—ELIJAH.SIMPSON@ICLOUD.COM4031 Highland AveFresnoCA93764GRP-3145select-epo
ENRENR-1026502026-06-10T07:42:53ZBoyd, MichaelZ—1992-07-23UHC1925778•••-••-0601397-543-1757—5328 Ridge RoadSan AntonioTX78231GRP-7333MEDICARE-ADV-A··
ENRENR-1331702026-04-09T10:29:35ZCarl—Hunt··Jul 25, 1952UHC-78785-52•••-••-8846347-303-5200carl.hunt42@proton.me8099 SPRING ST·SAN ANTONIOTX78203GRP-9837CORE-HMO
ENRENR-1282992026-09-15T02:55:35ZEthan—Morgan19640818UHC-58214-69•••-••-6038(689) 948-5344NULL3620 Spring St #283Houston··TX77014GRP-2640SELECT-EPO
ENRENR-1264782026-04-14T19:25:56Z·BARBZ.GORDON1974-10-13UHC-06105-89•••-••-8578(815) 265-7950BARBARA.GORDON89@ICLOUD.COM3289 Washington StreetOrlandoFL32852GRP-6293CHOICE-PLUS-PPO
ENRENR-1188322026-07-24T23:16:06Zroger—wheeler1951-05-03UHC-53655-70•••-••-8154247.437.9538·roger.wheeler@aol.com7260 Jefferson AvenueTucsonAZ·NULLGRP-1564select-epo
ENRENR-1198292026-07-10T10:55:43ZRaymondFKim2002-05-10UHC8985622•••-••-8659—NULL1535 Main StTempeAZ—GRP-8547NAVIGATE-HMO
ENRENR-1131452026-05-05T11:16:03ZSofia··Allen·28-04-1977UHC-34121-21•••-••-1202989-342-7204SOFIA.ALLEN7@ICLOUD.COM·2567 OAK STREETSan AntonioTX·78237GRP-6380CHOICE-PLUS-PPO
ENRENR-1103902026-03-12T23:02:27ZSamantha—Elliott08/03/1975UHC-46587-22•••-••-4631(415) 591-5524samantha.elliott@outlook.com·5177 Highland Ave Apt 24ScottsdaleAZ85223GRP-2950MEDICARE-ADV-A
ENRENR-1316682026-04-16T14:07:33ZBishop, AishaH—23-05-2006UHC-47775-45•••-••-7397(970) 265-6384aisha.bishop@aol.com2430 Maple AveORLANDOFL··—GRP-6589OPTIONS-PPO··
ENRENR-1185392026-01-28T21:25:25ZkathyS.morris10/27/1962UHC-93103-06•••-••-36517348017940··3402 HIGHLAND AVENUEDallasTexas75236GRP-7280OPTIONS-PPO
43,101 rows, page 6 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-19T19:54:25.416Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty