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-1121072026-03-03T10:25:48Z DONNA·GPORTER1942-05-20UHC-49476-54NULL·+1 870 416 2777donna.porter@outlook.com6116 UNION STEden PrairieMinnesota55338GRP-8819CORE-HMO
ENRENR-1185132026-02-13T06:37:33ZJoey—Geene·Nov 3, 1966UHC-02610-23··(810) 409-0778N/A2364 Palm Dr·TempeArizona85298GRP-4355CORE-HMO
ENRENR-1030002026-05-26T00:15:37Z TOM—·OBRIEN1989-03-17··UHC-36282-16•••-••-7468787-816-2910thomas.obrien67@yahoo.com7540 Forest AvenueSEATTLEWA98161GRP-5218OPTIONS-PPO
ENRENR-1018752026-04-25T19:53:18ZJoseI·Holmes1985-12-04UHC-12934-41•••-••-1425-JOSE.HOLMES@ICLOUD.COM4006 Pine DrMinneapolisMN55467GRP-5188CORE-HMO
ENRENR-1138782026-06-03T22:22:30ZMADISON—WHEELER2008-01-14UHC-41642-51•••-••-9652+1 240 515 4299·MADISON.WHEELER9@PROTON.ME4424 Forest AveColumbusOH43276GRP-4188OPTIONS-PPO
ENRENR-1377672026-08-20T02:56:08ZAlvarez, NatalieA—·11/26/01UHC-85005-33•••-••-2764(346) 946-3185natalie.alvarez85@proton.me9730 CANYON RDAustinTX78760GRP-1082SELECT-EPO
ENRENR-1037662026-02-23T05:13:18ZEdwards, BetttyI—19680511UHC-46319-99•••-••-6766442-384-0908UNKNOWN·7053 MAIN STSeattleWA98147GRP-7686MEDICARE-ADV-A
ENRENR-1149002026-01-09T14:15:26ZSeanKMoore21-11-1955UHC-28439-67•••-••-4922(755) 512-8204N/A3487 Pine DrSCOTTSDALE··AZ85291GRP-2677CHOICE-PLUS-PPO
ENRENR-1430302026-06-05T15:00:42ZBrown, RachelC—19520505UHC-87859-77•••-••-14342527223594rachel.brown58@aol.com4485 Main StMiami··FL33180GRP-2298NAVIGATE-HMO
ENRENR-1035542026-09-27T03:55:19ZAlexis—Alvarado2002-07-18uhc-08236-43•••-••-7426690-844-3487alexis.alvarado43@hotmail.com7620 Harbor BlvdCOLUMBUSoh43299GRP-9150CHOICE-PLUS-PPO
ENRENR-1310882026-05-18T08:30:30ZJean—Garza6/2/1980UHC-27370-28•••-••-0724841-946-0041··jean.garza@hotmail.com9241 Ridge RdGilbertAZ85249GRP-6567CORE-HMO
ENRENR-124012 2026-08-06T15:24:17ZmarianaV.fowler11/05/86UHC-92162-53•••-••-99603238211928MARIANA.FOWLER@OUTLOOK.COM6958 Mountain View DrScottsdaleArizona85292GRP-8570CORE-HMO
ENRENR-1068402026-09-08T03:30:19ZMATTHEW—AGUILAR1967-04-14UHC-53275-17•••-••-75293224923904MATTHEW.AGUILAR60@AOL.COM2553 Ridge Rd Apt 12·Scottsdale·AZ·85253GRP-6208MEDICARE-ADV-A
ENRENR-137088 2026-01-29T02:34:53ZCarolQ.Stephens3/25/2001UHC-58061-49null(489) 547-2072CAROL.STEPHENS@OUTLOOK.COM959 MARKET STREETSAN DIEGOCA92158GRP-4330NAVIGATE-HMO··
ENRENR-1274182026-08-18T18:31:57ZHarrison, Steve M——1955-03-22UHC-14162-85•••-••-9897(375) 284-7338—9547 INDIAN SCHOOL ROADSAN ANTONIOTX-GRP-9106CHOICE-PLUS-PPO
ENRENR-1101122026-07-24T10:20:26ZJennifer····Harvey1995-04-14UHC-95867-94•••-••-6629N/AUNKNOWN2807 Lake View RoadMiamiFlorida33182GRP-8491NAVIGATE-HMO
ENRENR-1389602026-06-08T07:55:02ZgloriaC.··hernandez1982-06-04UHC-15718-66•••-••-9600408-938-4926··gloria.hernandez1@yahoo.com8945 Spring StGilbertAZ-GRP-6255core-hmo
ENRENR-1377152026-03-10T11:59:36ZPhillips, PriyaL····03-06-1984UHC-39705-39•••-••-4745+1 485 313 4742UNKNOWN1868 Hillcrest RdMiamiFlorida33156··GRP-6437MEDICARE-ADV-B
ENRENR-1022142026-01-31T08:21:10ZBRYANX.WANG1947-05-24UHC-66628-01NULL7274317BRYAN.WANG@AOL.COM2094 Church StreetTucsonArizona85726GRP-2395OPTIONS-PPO
ENRENR-1169632026-03-01T16:22:28Z KELLYIBURTON1987-02-09UHC-12563-88•••-••-6499846.493.1887kelly.burton@aol.com··7158 RIVER RDChandlerAZ85281GRP-6851·CORE-HMO
ENRENR-1257282026-02-01T21:40:17ZMariana—Porter9/19/2006UHC-17545-71•••-••-0619(869) 358-4406mariana.porter@proton.me6954 PINE DRPHOENIXAZ85082-9053GRP-3874MEDICARE-ADV-B
ENRENR-1158002026-07-23T07:10:52ZJESSENPENA-··UHC-04366-25•••-••-6979NULLjesse.pena98@proton.me2100 JEFFERSON AVENUECHARLOTTENC28220GRP-3812SELECT-EPO··
ENRENR-1000432026-05-12T06:38:56ZJulieGCarter1979-07-02UHC-96665-30•••-••-6962593.906.0630julie.carter@proton.me1136 DESERT SKY BOULEVARDCHARLOTTENorth Carolina28292GRP-1112·MEDICARE-ADV-B
ENRENR-1068242026-03-19T20:33:46Zdylan··henry1989-09-13UHC-03499-91•••-••-5926(464) 286-8548dylan.henry@hotmail.com6887 CAMELBACK ROADPhoenixAZ85058GRP-7940OPTIONS-PPO
ENRENR-1027942026-07-21T17:57:39ZMateo—TranDec 1, 1990UHC-35473-23•••-••-5364—mateo.tran5@hotmail.com849 Elm StreetSan Antonio··TX78207GRP-8210MEDICARE-ADV-A
ENRENR-1080852026-02-16T02:36:10ZLAURENBRUIZ··24-11-1965·UHC-00323-88•••-••-0942—lauren.ruiz15@icloud.com5229 Cedar LaneAustinTX78743GRP-1617NAVIGATE-HMO
ENRENR-1018412026-09-19T14:48:52ZBian—Cox1980-04-19UHC-39816-02•••-••-8709660-339-9913brian.cox@gmail.com4972 Washington StreetEden Prairie·Minnesota55352GRP-3965core-hmo
ENRENR-1382042026-02-24T10:02:23ZROGER····LAWRENCE10/28/1963··UHC-53970-06•••-••-8119—ROGER.LAWRENCE@AOL.COM305 Pine DrLas Vegas·NV89108··GRP-4409CHOICE-PLUS-PPO
ENRENR-1335582026-01-20T19:58:52ZLISA·BWALKER19500228UHC-69000-23•••-••-79339696295974—7489 Valley View DriveDenverCON/AGRP-3353·MEDICARE-ADV-B
ENRENR-1302122026-01-10T03:10:50ZMarilynDBryant1956-07-24UHC-01965-82—(774) 933-2441··N/A9387 APACHE BOULEVARDTampaFlorida33674GRP-6408OPTIONS-PPO
ENRENR-1085602026-08-19T03:39:30Z Alan—Montgomery1979-04-12UHC-39258-97··•••-••-6336706.975.3185alan.montgomery85@aol.com·8755 JEFFERSON AVEColumbusOH43287GRP-8994MEDICARE-ADV-A··
ENRENR-1308782026-04-30T02:03:11ZMei—Chen1942-09-16UHC-42834-46•••-••-0017337-401-5916MEI.CHEN57@YAHOO.COM6397 Jefferson AveEden PrairieMN55313GRP-3088CORE-HMO
ENRENR-1028342026-08-24T22:01:45ZRebeccaV.Clark2004-07-06UHC-91106-06•••-••-5857N/A—4900 Market StSAN ANTONIOTX78263GRP-0124SELECT-EPO
ENRENR-1166142026-08-01T12:35:43ZOmarRBaker1982-12-17UHC-82232-61•••-••-2095794.695.5898—5030 Desert Sky BlvdOrlandoFL32808GRP-6402MEDICARE-ADV-A
ENRENR-1063462026-05-09T06:08:51ZJOHN··VDIAZ1973-02-15UHC-09680-90··•••-••-7872·2097273612JOHN.DIAZ@PROTON.ME1634 Willow CtSacramentoCalifornia95877··GRP-6216CHOICE-PLUS-PPO
ENRENR-1161862026-01-07T14:09:00ZSharon··Z.Davis16-12-1962UHC-46510-63··•••-••-00175394251076sharon.davis@proton.me··5576 Highland AveFresnoCA93750GRP-2183NAVIGATE-HMO
ENRENR-1214802026-05-07T02:24:58ZDEBORAHWMALDONADO1957-04-28UHC-25667-87•••-••-19858394392191deborah.maldonado@hotmail.com904 Canyon RoadFresnoCA93786GRP-7845OPTIONS-PPO
ENRENR-1226662026-08-25T22:09:51ZMariaLRyan1965-03-01UHC-53814-07•••-••-4361·289-811-8492maria.ryan@icloud.com8437 Lake View Road··AtlantaGeorgia30370GRP-4742CHOICE-PLUS-PPO
ENRENR-1029932026-01-03T03:49:08ZPeters, JesseC—19820406UHC8539038•••-••-3085520-389-2262JESSE.PETERS@OUTLOOK.COM6712 Ridge RdGlendaleAZ85361-3957GRP-9936CORE-HMO
ENR ENR-1026422026-09-05T12:23:46ZGonzales, Kevin·Z—1979-04-17uhc-66033-82•••-••-6218·7632167898—2112 Hillcrest RdCHANDLERAZ85260·GRP-7283MEDICARE-ADV-A
ENRENR-1131332026-05-29T02:08:03ZNancyPRodriguez1956-12-05UHC-89474-55•••-••-9427(888) 799-0590null8581 FOREST AVESan DiegoCA92199GRP-6692OPTIONS-PPO
ENRENR-1079042026-06-05T22:45:14ZGary R.—Daniels10/23/1979UHC-32904-97··•••-••-05743065197364gary.daniels95@outlook.com5753 Pine DriveOrlandoFL32801GRP-4073MEDICARE-ADV-B
ENR ENR-1247742026-03-06T15:10:59ZNichols, Bruce——1996-11-06UHC-20624-46—421-501-1526bruce.nichols55@icloud.com7232 Forest AveMesaAZ85236-8561GRP-8635NAVIGATE-HMO··
ENR ENR-1410662026-04-02T08:31:08Z·ChristineA.Turner1987-04-04UHC-86075-96•••-••-8091510-843-9347christine.turner@proton.me1696 INDIAN SCHOOL ROADSacramentoCA95820GRP-9593medicare-adv-b
ENRENR-136116 2026-04-04T10:34:22Z·TylerQGarza1957-12-20··UHC-89324-68UNKNOWN475-756-5105tyler.garza@hotmail.com··396 Ocean AveCHARLOTTENC28236GRP-6761CHOICE-PLUS-PPO
ENRENR-1294872026-04-27T13:16:56ZJudyZ.Foster··2002-03-24UHC-43426-86-(339) 657-8993judy.foster@icloud.com638 Harbor BoulevardMinneapolisMN—GRP-7220·options-ppo
ENRENR-1311972026-10-18T22:41:17ZLAURENJSTEWART2005-06-01UHC-04022-90•••-••-7200871.805.4070lauren.stewart@outlook.com8165 HARBOR BOULEVARDCharlotteNC28227GRP-4670CHOICE-PLUS-PPO
ENRENR-1020142026-08-28T10:24:13ZSamantha····Meyer03/20/92UHC-98383-40•••-••-95138155948815null8827 Main StreetChandlerAZ85240GRP-0294CORE-HMO
ENRENR-1271692026-05-22T17:13:27ZElizabethLDaniels23-05-1976UHC-23922-02•••-••-1115(475) 812-1793elizabeth.daniels@icloud.com605 Lincoln WayAustinTXUNKNOWN·GRP-9782SELECT-EPO··
ENRENR-1183602026-03-03T12:17:48ZARTHURE.VEGA1996-03-07UHC-36270-21•••-••-3053726-455-5533null8131 Church StHoustonTX77092GRP-2934MEDICARE-ADV-A
43,101 rows, page 158 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:38.486Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty