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-1316012026-09-04T10:36:22ZNguyen, HaroldK—2001-08-19UHC4444180•••-••-35752844345446HAROLD.NGUYEN55@HOTMAIL.COM6451 Hillcrest RoadPhoenixAZ85081GRP-3135NAVIGATE-HMO
ENRENR-1005842026-01-09T09:22:10ZJacqueline—Chen07-08-1997UHC-37309-92•••-••-2824(703) 247-8775JACQUELINE.CHEN31@AOL.COM5143 Grand Ave #239Los AngelesCA90011GRP-4377CORE-HMO
ENR ENR-1369722026-03-04T07:18:22ZSusanL··Vasquez2/24/1965UHC9284307•••-••-0097(601) 999-8736susan.vasquez41@aol.com4067 Grand AveColumbusOhio-GRP-5300NAVIGATE-HMO
ENRENR-1370292026-06-27T02:38:13ZRichardHJackson2004-02-11UHC-03936-31•••-••-0382(515) 779-1955richard.jackson21@icloud.com4069 Washington StHoustonTX77010-5615GRP-9088NAVIGATE-HMO
ENRENR-1245162026-09-04T04:45:34Z ABIGAILCHARRISON·1961-11-20UHC-44752-52•••-••-4553(667) 578-9859·abigail.harrison@proton.me8701 River RdHouston··TX77026GRP-3823MEDICARE-ADV-B
ENRENR-1317192026-08-26T19:54:27ZJeffrey··ORiley1946-11-14UHC2501703•••-••-1407(858) 942-7856JEFFREY.RILEY@YAHOO.COM·7277 Park PlChandlerAZ85234··GRP-9819··MEDICARE-ADV-B
ENRENR-1359922026-07-03T02:36:17ZWei—Peterson··1981-03-11UHC-91249-27null9382467605WEI.PETERSON70@GMAIL.COM6533 Palm DrSeattleWA98117GRP-4878MEDICARE-ADV-B
ENRENR-1126312026-04-13T16:49:17ZAdam—Turner··6/10/1959UHC0055615•••-••-2129(819) 960-3611··adam.turner5@gmail.com6333 Valley View DriveFresno··CA··93726GRP-3334MEDICARE-ADV-A
ENRENR-1400012026-03-22T08:55:51ZFrannkZBailey1963-12-16uhc-35199-95•••-••-81553979114661UNKNOWN7511 Ridge RdTucsonAZ85765GRP-8342SELECT-EPO
ENRENR-1275332026-07-01T18:25:26ZJoan—·Jordan1971-03-27UHC-20551-16•••-••-3160(772) 355-6936joan.jordan@yahoo.com2197 HARBOR BOULEVARDMinneapolisMN55439GRP-9311MEDICARE-ADV-B
ENRENR-1052292026-09-06T18:42:29ZDEBORAH··O.WASHINGTON1977-04-15UHC-12760-52•••-••-1218+1 621 406 1998deborah.washington@icloud.com3063 PINE DROrlandofl··32856GRP-3045CHOICE-PLUS-PPO
ENRENR-1214292026-07-30T18:19:34Zjulia····hall1959-10-07UHC-31952-97•••-••-9831547-413-7922JULIA.HALL36@OUTLOOK.COM9540 Jefferson AvenueLos AngelesCA90038GRP-9957CORE-HMO
ENRENR-1271642026-05-14T08:39:24ZMICHAELCPIERCE1992-03-04UHC-60874-56•••-••-769613454479000michael.pierce83@aol.com1979 Sage CtAtlantaGA30339GRP-8162MEDICARE-ADV-B
ENRENR-1423962026-02-10T05:20:19ZPatricia—·Porter1945-01-11UHC-96889-07•••-••-6680291-451-3224··patricia.porter@aol.com7521 Valley View DrPHOENIXAZ85058GRP-5698··MEDICARE-ADV-B
ENRENR-1137672026-03-13T10:21:50ZNathanM.Hall08/26/39··-•••-••-8291346.611.5388nathan.hall@outlook.com··7748 Bayshore Drive Apt 6AustinTexas78735GRP-9652CHOICE-PLUS-PPO
ENRENR-1008652026-02-05T17:14:49ZWillie—Walsh1959-01-26UHC-12852-84•••-••-0210241-432-7954WILLIE.WALSH2@AOL.COM4995 BROADWAYLos AngelesCA90095-2098GRP-9282OPTIONS-PPO
ENRENR-1042412026-09-07T18:00:48ZCarroll, ChristianY—08-11-1994UHC-50313-94•••-••-1583NULLchristian.carroll30@icloud.com626 CENTRAL AVENUEFRESNOCA93716GRP-7490MEDICARE-ADV-A
ENRENR-1230282026-07-10T16:19:05ZREBECCAVHERNANDEZ1981-02-28UHC-12071-81•••-••-4069(214) 438-7855REBECCA.HERNANDEZ39@PROTON.ME4084 Mountain View DrMiamiFL33178GRP-7763MEDICARE-ADV-B
ENRENR-1329112026-04-14T09:19:57ZBRADLAY—WELLS1980-12-02UHC-44434-27•••-••-978413636471737N/A1813 ELM STJacksonville·FL32280GRP-1731NAVIGATE-HMO
ENRENR-1366372026-05-22T21:17:08ZAndrewH.Guzman2002-06-03·UHC-05891-32•••-••-6836+1 930 856 8848andrew.guzman@aol.com8103 Meadow LaneJacksonvilleFL32220GRP-5434CHOICE-PLUS-PPO
ENRENR-1367752026-10-01T09:42:04ZEvelyn—Black1953-01-02UHC-03263-23•••-••-0639756.668.5455evelyn.black44@aol.com··3361 Sunset Boulevard Apt 23OrlandoFL··32861GRP-6410MEDICARE-ADV-A
ENRENR-1241012026-08-31T22:08:01ZPAMELA—BRYANT1960-03-17UHC-85849-44•••-••-201216159289513NULL609 LAKE VIEW ROAD #154··Los AngelesCA90019GRP-2604OPTIONS-PPO
ENRENR-1366122026-07-21T20:32:01ZANDREA—OLSON19900416UHC-41097-65•••-••-7512—andrea.olson64@aol.com4035 Forest AvenueGlendaleaz·85314GRP-9043SELECT-EPO
ENRENR-1015962026-02-24T23:07:14Zsara··W.stone··1964-02-27UHC-23544-97•••-••-1440N/Asara.stone@hotmail.com7258 HILLCREST ROADSEATTLEWA98154GRP-4065navigate-hmo
ENRENR-1147742026-05-04T07:57:30Z·Billy—Hill1988-05-04UHC-24705-10—-billy.hill68@aol.com7097 RIDGE RD #814HoustonTX77002GRP-2976options-ppo
ENRENR-1192302026-05-15T01:41:44ZVincent··Vasquez1990-10-25··UHC-98819-71•••-••-03476657468652vincent.vasquez@aol.com9056 Willow CourtOrlandoFL32868GRP-5607MEDICARE-ADV-A
ENRENR-1056732026-10-14T01:52:34ZWillis, Patryck····—07/03/66UHC-50932-49•••-••-137014114404827patrick.willis15@yahoo.com1850 Cedar LnDENVERCO80233-1105GRP-4988choice-plus-ppo
ENR ENR-1110062026-05-18T10:11:34ZPatricia—George11/23/1959UHC-24055-04•••-••-1794·+1 293 311 9747patricia.george96@yahoo.com8439 Forest Ave #622JacksonvilleFL32267GRP-4274SELECT-EPO
ENRENR-1166712026-03-31T15:46:59ZMariaTSchmidt2002-05-17··UHC0909390•••-••-6410361-864-6924maria.schmidt@gmail.com4327 RIVER ROADLOS ANGELES··CA90070·GRP-8087CORE-HMO
ENRENR-104886 2026-03-02T09:32:48ZAlexanderJMarshall1969-09-02UHC-93972-26•••-••-2448(945) 547-7468alexander.marshall@hotmail.com9664 Highland AveDallasTX75230GRP-5742NAVIGATE-HMO
ENRENR-1131722026-05-02T21:44:02ZMARKFWASHINGTON1964-09-02UHC-44921-94•••-••-9837912.251.5141-4833 Grand Avenue #987PhoenixAZ85062-6432GRP-9054SELECT-EPO
ENRENR-1088872026-07-07T10:33:27ZJacob N—King1970-03-14UHC-22406-82•••-••-703515236796588JACOB.KING64@YAHOO.COM7963 Lake View RdTempeAZ··85266·GRP-2769CHOICE-PLUS-PPO
ENRENR-1056692026-04-23T18:33:02Z ChristopherR.Wheeler2002-02-26UHC-90652-92•••-••-80584664970523christopher.wheeler74@outlook.com6621 Washington StTucsonAZ85744GRP-4701MEDICARE-ADV-A
ENRENR-1018092026-01-05T02:06:53ZDon····Butler·1960-09-20UHC-55767-80•••-••-1075(283) 378-2540donald.butler@hotmail.com321 Jefferson Avenue··TampaFL33648GRP-6597choice-plus-ppo
ENRENR-1096122026-06-25T05:22:35ZDylan—Bennett2007-07-02··UHC-79922-03•••-••-318712649023335dylan.bennett@proton.me1538 Grand AvenueSacramentoCA95859GRP-1139OPTIONS-PPO
ENRENR-1095712026-08-12T12:11:40Znicole—chavez2006-01-20UHC-14317-71•••-••-30168759477522·nicole.chavez@gmail.com7177 Lake View RoadSeattleWA98199-3629GRP-7680CHOICE-PLUS-PPO
ENRENR-1032012026-07-11T21:24:40Z·Barbara—McDonald14-01-1983UHC-32514-51··•••-••-7551(286) 694-0840··BARBARA.MCDONALD61@AOL.COM2086 Washington StCharlotteNC·28227GRP-1066CHOICE-PLUS-PPO··
ENRENR-1034982026-03-16T20:22:10Zelizabeth——13-02-1949UHC-51524-84•••-••-79559452067176ELIZABETH.SANDOVAL@PROTON.ME·3180 RIVER ROADGilbert·az85221GRP-6984CORE-HMO
ENRENR-1008892026-09-05T01:51:37ZKarenPGutierrez5/20/1983uhc-40050-34——N/A4665 Valley View DrivePHOENIXAZ85075GRP-6601OPTIONS-PPO
ENRENR-1251982026-04-17T18:00:44ZHarold—Marquez1987-02-02UHC-77141-58•••-••-5402(934) 983-3759harold.marquez21@yahoo.com7215 Highland AvenueCharlotteNC28260··GRP-1358CHOICE-PLUS-PPO
ENRENR-119848 2026-04-26T03:49:23ZHannahW.Little08/05/1946UHC-24374-25-443-657-1144hannah.little@hotmail.com·4540 APACHE BOULEVARDSan DiegoCA92193-2218GRP-7769medicare-adv-b
ENRENR-135518 2026-04-03T12:23:27ZKathryn—Bennett20061114UHC-30653-36UNKNOWN18524400006KATHRYN.BENNETT12@HOTMAIL.COM6482 Union StreetMESAAZ85241GRP-5990MEDICARE-ADV-A
ENRENR-1260082026-02-27T01:40:37ZnoahM.greene1950-02-17UHC-68781-12•••-••-50246764416981noah.greene93@gmail.com1784 River RoadAtlantaGeorgia30300GRP-2577CHOICE-PLUS-PPO
ENRENR-1136872026-03-07T09:09:29Zfatima—nunez1944-03-12UHC-67055-02•••-••-24369225465460N/A4927 Hillcrest RoadHoustonTX—GRP-8955MEDICARE-ADV-B
ENRENR-1041762026-03-30T05:19:42ZDiana····McDonald1981-11-08UHC-42901-26•••-••-5571325-325-5106diana.mcdonald79@gmail.com9636 Mountain View Drive·CharlotteNC28273GRP-3682MEDICARE-ADV-B
ENRENR-1219102026-08-13T11:48:39ZRoss, Brenda——19850917UHC-61529-52·N/A791-594-3305BRENDA.ROSS@HOTMAIL.COM·2276 Ocean AveJacksonvilleFL32291GRP-3472CHOICE-PLUS-PPO
ENRENR-1151532026-04-04T15:37:03ZCarlV.··McCyo2008-07-20UHC-90578-64•••-••-2536(402) 391-8125-9103 Palm DriveTampaFL33697GRP-7591medicare-adv-a
ENR ENR-1119032026-02-16T10:17:30ZArjunR.Fowler1960-06-25··UHC-82747-93•••-••-94532239484975NULL8561 INDIAN SCHOOL ROADEden PrairieMN55392GRP-9551SELECT-EPO
ENRENR-1171682026-02-21T21:28:20ZBobbyHDelgado1940-10-26UHC9367706•••-••-7424(547) 704-6486bobby.delgado70@icloud.com··1156 RIDGE RD·ChandlerAZ85211GRP-6648NAVIGATE-HMO
ENRENR-1083022026-06-02T20:50:30ZWagner, Mason——1962-08-16UHC-02115-55•••-••-2424914-318-2055·mason.wagner@yahoo.com1593 Church StSan AntonioTX·N/AGRP-2798CHOICE-PLUS-PPO
43,101 rows, page 155 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.480Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty