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-1403932026-05-30T10:36:45ZSara—Palmer1998-05-20UHC4732020•••-••-8028259-629-1534SARA.PALMER73@OUTLOOK.COM133 ELM STGilbertAZ85272··GRP-9208MEDICARE-ADV-B
ENRENR-1238722026-05-11T21:04:45ZChristopher··VCunningham1990-03-02UHC-09111-69•••-••-6371-CHRISTOPHER.CUNNINGHAM43@HOTMAIL.COM··9136 Apache BlvdSeattleWA98120GRP-8165OPTIONS-PPO
ENRENR-1030652026-01-04T22:19:10ZJOSEPHI.MOORE1968-12-18UHC-87309-83•••-••-85269088273592joseph.moore@outlook.com1466 Desert Sky Boulevard Apt 20·DallasTX75239GRP-5165MEDICARE-ADV-A
ENRENR-1034122026-06-12T10:44:15ZHanson, Kathleen··——NULLUHC-09595-21•••-••-5947259-561-4710kathleen.hanson7@aol.com1114 Grand AvenueGilbertAZN/A··GRP-0785CHOICE-PLUS-PPO
ENRENR-1145592026-03-12T23:30:58ZMichelle—·Welh1980-07-10UHC-94322-99•••-••-94342743881517MICHELLE.WELCH@AOL.COM2280 LINCOLN WAYColumbusOH43238GRP-7737CORE-HMO
ENRENR-1115052026-02-26T20:08:55Z Marquez, Catherine——2000-01-20UHC-51377-30•••-••-4563+1 300 526 8145catherine.marquez@gmail.com5431 Church StAustinTX78725GRP-1495MEDICARE-ADV-A
ENRENR-1047672026-09-13T22:53:39ZLAWRENCEVESTRADA·1944-10-22UHC7146418•••-••-46796532633lawrence.estrada@outlook.com4645 HARBOR BOULEVARDColumbus··OH43290··GRP-4097··SELECT-EPO
ENRENR-1287452026-03-27T03:21:18ZDOUGLASG.SOTO·1984-12-21UHC-83412-14•••-••-0144311.817.6795—5646 Canyon RoadFRESNOCalifornia93708GRP-0352MEDICARE-ADV-B
ENRENR-1266162026-01-28T15:16:24ZKEITHIGORDON1965-09-11UHC-14722-66•••-••-9537(393) 629-3122keith.gordon@yahoo.com9536 LAKE VIEW RDDallasTX75240··GRP-3765··CORE-HMO
ENRENR-1012692026-04-12T02:15:16ZBetty—·Pena19460814UHC-11904-51•••-••-20246844316552—590 RIDGE RDJacksonvilleFL32228·GRP-0859SELECT-EPO
ENRENR-1170762026-08-08T16:59:38Z·LAUREN·S.VALDEZ·Jun 21, 1944UHC7310823•••-••-74217699924425lauren.valdez@yahoo.com1720 MARKET STREET #963Tucson·AZ85766GRP-2317·SELECT-EPO
ENRENR-1308192026-01-16T07:55:27Z———5/12/1982UHC-21771-63•••-••-4967(372) 274-8775N/A8499 MAIN STREETColumbusOH43254GRP-3953MEDICARE-ADV-A
ENRENR-1117422026-04-06T17:02:13ZGeorgeZ·Simpson1953-11-01··UHC-39695-27•••-••-0467·8714628675george.simpson@aol.com3637 HARBOR BOULEVARD·OrlandoFL32889GRP-6601CORE-HMO
ENRENR-1108582026-07-24T07:48:18Z ·JULIAA.ESTRADA1999-12-16··UHC-94226-56•••-••-1820+1 841 942 8442··9472 BAYSHORE DRSan DiegoCA92173·GRP-9803MEDICARE-ADV-A
ENRENR-1095722026-03-18T18:40:49ZSullivan, Patrycia——19600806UHC-32585-72•••-••-27097888162357patricia.sullivan70@aol.com7284 Grand AvenuePlanoTX75022GRP-3962medicare-adv-a··
ENRENR-1295452026-05-27T16:53:47Z SOFIAYGRANT02/03/1953UHC-68246-83··•••-••-8643UNKNOWN—5696 Bayshore DriveFresnoCA·N/A·GRP-7105OPTIONS-PPO
ENRENR-1116712026-09-07T11:23:29ZWagner, KayllaH··—1973-12-01UHC-41223-83•••-••-6916—kayla.wagner@hotmail.com··8933 Park PlDenverColorado80218GRP-4429··MEDICARE-ADV-B
ENRENR-1148782026-03-07T21:52:56ZNicholas—Bradley07/09/2001UHC-19450-99•••-••-1926989-378-8116··nicholas.bradley47@aol.com3447 Ridge RoadPhoenixaz85001GRP-3051CORE-HMO
ENRENR-1096282026-01-05T05:32:50ZDorothy·VHolmes1970-11-14UHC-54912-35··—8295569564dorothy.holmes@aol.com8960 SPRING STNashvilleTennessee37225-8175GRP-6334MEDICARE-ADV-B
ENRENR-1339572026-06-25T19:13:03ZBILLY—GARRETT1994-10-03UHC-70339-26•••-••-236417954096500billy.garrett41@hotmail.com··9151 Broadway·GilbertAZ85278GRP-4749SELECT-EPO
ENRENR-1415272026-02-17T03:29:19ZLauren—Ramirez··Aug 16, 1948UHC-84759-98•••-••-5999391-448-6285lauren.ramirez36@yahoo.com3078 LINCOLN WAY #726San AntonioTX78217GRP-6866select-epo
ENRENR-1202162026-03-22T02:09:06ZRley, Diego——11/1/1998UHC-57585-88•••-••-4494(783) 433-1029diego.riley@gmail.com5313 Highland AveDenverCO80289GRP-1772CORE-HMO
ENRENR-1420042026-05-28T17:22:49ZDeborahDHicks1990-09-01UHC-77986-71—(278) 621-6722DEBORAH.HICKS30@GMAIL.COM··1597 Bayshore DriveSeattleWA98104GRP-6760··MEDICARE-ADV-A
ENRENR-1069642026-07-20T10:58:49ZJackson, DanielleQ—·Oct 11, 1954UHC-84944-11•••-••-9249+1 265 293 8377danielle.jackson14@yahoo.com3506 Spring Street···DENVERCO80238GRP-9953CHOICE-PLUS-PPO
ENR ENR-1014852026-02-22T11:11:00ZMARIA—BERRY20-06-1946UHC-38529-44•••-••-1540272.234.4177maria.berry3@proton.me6589 Camelback RoadAtlantaGeorgia30314··GRP-8702···OPTIONS-PPO
ENRENR-1025162026-06-20T02:53:32ZSarhDGrant1/4/1999UHC-93690-53•••-••-8700(354) 323-3551sarah.grant@aol.com4672 CANYON RDMinneapolisMN55413GRP-7053select-epo
ENRENR-1217062026-09-28T02:35:58ZGraceV·Fisher1971-03-01UHC-44389-91•••-••-75053313736736N/A5229 Church StAustinTX78719GRP-2346CHOICE-PLUS-PPO
ENRENR-1128882026-01-04T07:12:01ZJustin—Gibson··2005-01-06UHC-79224-70•••-••-3969—justin.gibson@hotmail.com8984 MAPLE AVENUEColumbusOhio—GRP-1804options-ppo
ENRENR-1198912026-02-27T17:39:25ZMartha—Ortega1980-06-16UHC-68860-37•••-••-3015673.966.3647martha.ortega19@outlook.com9115 Lake View RoadColumbusOhio43222GRP-1133OPTIONS-PPO··
ENRENR-1224292026-04-29T11:29:39Zjordan—hill2001-11-11UHC-10282-21•••-••-8779(268) 716-1978jordan.hill6@hotmail.com6475 Washington Street··OrlandoFL32877GRP-8271MEDICARE-ADV-B
ENRENR-1125262026-02-12T09:57:45ZNicole—Torres1957-03-02UHC-00087-21—UNKNOWN—6740 Pine DrSeattleWA98157GRP-2775NAVIGATE-HMO
ENRENR-1072732026-10-17T05:21:32ZCherlyN.··Munoz··5/5/1946uhc-39247-46•••-••-92328498714888UNKNOWN5559 SAGE CT··MesaAZ85276GRP-0308··CORE-HMO
ENRENR-1255092026-03-31T14:37:54ZBARBARA··CCHAVEZ1984-04-28··UHC-52218-29•••-••-6903(913) 771-2861barbara.chavez25@aol.com6126 Indian School RoadSAN ANTONIOTexas78257GRP-5560CORE-HMO
ENR ENR-1298582026-08-14T01:08:07ZHannah··Q.Morales1981-04-13UHC8434556•••-••-3405-·hannah.morales26@gmail.com1616 MARKET STREETDenverCO-GRP-3010SELECT-EPO
ENRENR-1359122026-06-14T21:38:12ZKAREN—LNE24-03-1961UHC-82536-31•••-••-3619—NULL2769 River RdNashvilletn37228GRP-9413CHOICE-PLUS-PPO
ENRENR-1148042026-02-28T22:28:33Zgabriel—gray2001-08-25UHC-14318-72•••-••-4186(338) 815-3032··gabriel.gray63@proton.me8384 Lincoln WayGilbertAZ—GRP-8067OPTIONS-PPO
ENRENR-1084222026-03-09T20:21:20ZRandy—ParkerAug 23, 1965···UHC8536222•••-••-9552(488) 307-1610RANDY.PARKER@PROTON.ME129 Meadow Ln #701·ChandlerAZ85208-5306GRP-2493MEDICARE-ADV-B
ENRENR-1297802026-01-29T13:29:33ZTHERESATMALDONADO1399-05-08UHC-45767-75N/A+1 806 531 9468THERESA.MALDONADO10@PROTON.ME6139 Elm StreetDallasTX75293GRP-9167NAVIGATE-HMO
ENRENR-1321782026-06-06T12:12:01ZChristianO.Dixon1981-08-13UHC-02015-72•••-••-402312074119575null2166 Ocean AveTampaFL33635GRP-4931·SELECT-EPO
ENRENR-1007652026-05-02T02:44:31ZROGERI.BELLNov 2, 1986·UHC-49797-35•••-••-1403957.875.3466roger.bell4@hotmail.com··7058 Meadow LaneMiami·FL33133GRP-8391MEDICARE-ADV-B··
ENR ENR-1150592026-10-11T04:48:54ZBENDSTONE1987-12-28UHC-41687-73•••-••-60383274549377—7644 Grand AvenueTEMPEAZ85220GRP-6641CHOICE-PLUS-PPO
ENRENR-1193402026-06-26T01:45:08ZANNM.SCHMIDT1977-05-05UHC-80695-60•••-••-7001+1 387 876 0394ANN.SCHMIDT@PROTON.ME9812 Palm DriveSacramentoCA95888GRP-8548NAVIGATE-HMO
ENRENR-1257502026-06-22T21:11:40ZMarianaXKelllyAug 25, 1981UHC-11420-45N/A16816069230··mariana.kelly@proton.me5286 INDIAN SCHOOL RD Apt 40·MiamiFL33119GRP-7670MEDICARE-ADV-A
ENRENR-1191482026-09-24T13:43:38Z ·DIANASMENDEZ1998-04-20UHC-96329-81•••-••-6271(351) 819-7282diana.mendez89@hotmail.com9376 Pine DriveJACKSONVILLEFL32260·GRP-0448MEDICARE-ADV-A
ENRENR-1314712026-08-07T05:40:16Z MarcusDThomas28-04-1959UHC-45703-19•••-••-392017384551260·MARCUS.THOMAS@PROTON.ME3707 Ocean AveHoustonTX77043··GRP-1260NAVIGATE-HMO
ENR ENR-1009412026-01-10T06:19:34ZCollins, MarcusX—1946-03-20UHC-00187-28•••-••-8907377.252.4734marcus.collins@icloud.com3486 Harbor BlvdFresnoCA93786GRP-9413OPTIONS-PPO
ENRENR-1117842026-07-27T11:43:55ZHerrera, JimX—2007-10-15·UHC-91233-31NULL(550) 659-3172·james.herrera@icloud.com3206 Washington StreetLas Vegas·NV·UNKNOWNGRP-7790CHOICE-PLUS-PPO
ENRENR-1362782026-02-09T21:59:57Zmariana—chen1992-11-11UHC-99463-67•••-••-5662(965) 234-5337mariana.chen@icloud.com··5602 Ridge Road Apt 20San DiegoCA92173GRP-2682OPTIONS-PPO
ENRENR-1394962026-07-24T02:39:58ZCarroll, Roger——2003-09-20uhc-99287-92•••-••-15335507948842roger.carroll@outlook.com8485 Meadow LnMinneapolisMN55402GRP-9338NAVIGATE-HMO
ENRENR-1140562026-05-22T19:06:25ZJoeWHughes1955-01-13UHC-57265-41—13046555256joe.hughes@proton.me3153 PARK PLDenverCO80206GRP-1720CORE-HMO
43,101 rows, page 4 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.415Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty