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-1133922026-07-24T20:00:08ZHenryNMcDonaldMay 19, 2007UHC-49111-77•••-••-1754(700) 779-5185henry.mcdonald85@aol.com2866 Grand AveOrlandoFL32829GRP-9154MEDICARE-ADV-B
ENRENR-1354122026-08-11T14:13:51ZTerryV.Le1984-03-25UHC-38720-12··•••-••-12472108168784terry.le42@aol.com825 Union StDenverCO80279GRP-4896NAVIGATE-HMO
ENRENR-110504 2026-05-06T21:10:09ZWeaver, Juan——·1948-10-15UHC-49719-35•••-••-7229329.502.6983juan.weaver98@icloud.com9101 Harbor BoulevardHOUSTONTX77021GRP-5110·SELECT-EPO
ENRENR-1181602026-01-17T11:07:30ZAMBER··—BYD1950-04-27UHC-22070-97•••-••-7995(466) 515-2046UNKNOWN93 Park PlLos AngelesCA90092·GRP-5949MEDICARE-ADV-A
ENRENR-1423292026-05-09T12:31:38ZRonaldR.Ford19631011UHC-97301-31•••-••-21013682391657N/A137 Hillcrest RoadAtlanta·GA30351GRP-7807·CHOICE-PLUS-PPO
ENRENR-1313432026-04-30T16:25:54ZIsabellaIEdwards19480923UHC-90465-53•••-••-01328766377116··ISABELLA.EDWARDS87@ICLOUD.COM2003 Washington StTucsonAZ85704GRP-2332OPTIONS-PPO
ENRENR-1372792026-08-06T04:51:08ZMarilynNVazquez1941-05-20UHC-02087-63•••-••-06807948827844UNKNOWN8011 Meadow LaneGilbertAZ85241GRP-1165CHOICE-PLUS-PPO
ENRENR-1390782026-09-05T16:21:57Z ZacharyLReyes1977-04-28UHC-41213-20•••-••-901019016106841-2144 Church Street Apt 15MiamiFL33175GRP-2374CHOICE-PLUS-PPO
ENRENR-1253902026-05-20T23:46:34Zchristopher—perkins1980-12-20UHC-86844-01··null9087919382christopher.perkins@aol.com8198 BASELINE RDScottsdaleAZ85256-8600GRP-4849choice-plus-ppo
ENRENR-1416332026-05-26T15:28:33ZYuki·XWilliamson2000-03-19UHC-67835-34•••-••-3277259-848-9270YUKI.WILLIAMSON@ICLOUD.COM4914 SAGE CTJACKSONVILLEFL32270GRP-5116NAVIGATE-HMO
ENRENR-1191492026-01-30T18:33:37ZKatherineWMitchell1964-03-04UHC-07605-24•••-••-8390(648) 955-2005katherine.mitchell94@yahoo.com···40 Elm StMesaAZ85274GRP-4236MEDICARE-ADV-B
ENRENR-1077942026-03-04T07:37:41Zwalter—rivera1994-12-28UHC9762467•••-••-89966347227260walter.rivera17@outlook.com2298 MAIN STREETMinneapolisMN55425GRP-9740medicare-adv-a
ENRENR-1235672026-03-10T19:45:03ZScottHKelley19461218UHC-55410-23•••-••-4595(676) 918-5708scott.kelley59@proton.me8103 RIDGE RDGilbertAZ85245GRP-8233·select-epo
ENRENR-1143722026-03-01T18:33:10Z NOAH—ROBERTS1962-03-21UHC-53705-72·UNKNOWN+1 739 783 6496noah.roberts@outlook.com3264 Sunset BlvdHoustonTX77093GRP-0810CHOICE-PLUS-PPO
ENRENR-1412752026-05-16T02:47:21ZJeremy—Roberts08/08/02UHC-15499-53•••-••-36922922886180—1986 CHURCH STREET··AtlantaGA30319-3958GRP-2215CHOICE-PLUS-PPO
ENRENR-100786 2026-05-21T05:29:29ZJacob··N.WashingtonFeb 4, 1973UHC-73966-23•••-••-70647009054219UNKNOWN3679 BroadwayDallasTX75297·GRP-6191NAVIGATE-HMO
ENRENR-1302372026-07-23T05:36:29Zjean—lawzon1973-10-24UHC-32919-07•••-••-5205339-262-7553JEAN.LAWSON64@HOTMAIL.COM5880 Highland AveNashvilleTN37241GRP-9412CHOICE-PLUS-PPO
ENRENR-1283152026-01-10T06:16:31ZOilviaM.Gonzales1943-12-80··UHC-00411-18•••-••-60939682994643olivia.gonzales49@hotmail.com8846 Apache BoulevardSeattleWA98151GRP-4122·SELECT-EPO
ENRENR-1009782026-05-22T04:35:06ZWAYNEUDUNCAN15-04-1946UHC-81346-56•••-••-48953663589837—7593 Market St Apt 32MesaAZ85293·GRP-0967MEDICARE-ADV-B
ENRENR-1369662026-07-19T04:26:28ZJEANO·GEORGE10/26/81UHC-52843-78•••-••-6176·15964563520jean.george77@outlook.com4731 JEFFERSON AVENUEHoustonTX77030GRP-5460CHOICE-PLUS-PPO
ENRENR-1404972026-05-17T11:55:40ZSandraXJackson1946-04-25·UHC-53077-56•••-••-60404792888883sandra.jackson@aol.com··3183 Union StreetFRESNOCA93728GRP-3340OPTIONS-PPO
ENRENR-113753 2026-05-04T19:40:08Z·MARIANAE.HERRERA09/25/79UHC-47508-09•••-••-4583·N/Amariana.herrera@icloud.com4823 MOUNTAIN VIEW DRIVESACRAMENTO·CA95863GRP-6363OPTIONS-PPO
ENRENR-1174562026-04-11T02:09:23ZSantiagoL.Olivia2005-05-15UHC-85487-41•••-••-8460963-964-1046OLIVIA.SANTIAGO@HOTMAIL.COM842 Canyon RdMesaAZ85256GRP-5281MEDICARE-ADV-A
ENRENR-1324352026-09-28T02:43:25ZCHRISTOPHERICONTRERAS1951-12-19··UHC-60511-18UNKNOWN420-975-3682N/A8960 MAIN STLas VegasNV89176GRP-7550CHOICE-PLUS-PPO
ENRENR-1164962026-08-29T16:46:34ZSetwart, GabrielJ—2001-05-26UHC-98340-36•••-••-4505925-287-8598gabriel.stewart@gmail.com6498 Palm DrDenver··CO80274GRP-3174SELECT-EPO
ENRENR-1120442026-06-13T04:27:05ZGreen, Omar——1975-11-18UHC-55015-60•••-••-14817545319554··OMAR.GREEN@OUTLOOK.COM6592 Hillcrest RdMiamiFL33193GRP-5616OPTIONS-PPO
ENRENR-1111412026-05-16T13:27:03ZTIMOTHYU.LYNCHOct 20, 1976··UHC-17134-18•••-••-14732686015298TIMOTHY.LYNCH@AOL.COM5599 HIGHLAND AVE··MIAMIFL33124GRP-7726MEDICARE-ADV-A
ENRENR-1282782026-10-01T05:42:03ZRichardson, BrittanyC··—Apr 8, 1992UHC8555072•••-••-9863+1 365 294 0002BRITTANY.RICHARDSON@YAHOO.COM4591 Lincoln WayTucsonAZ85731GRP-7038MEDICARE-ADV-A
ENRENR-1147522026-07-13T08:43:32ZSTEPHANIE—TORRES2006-11-14UHC-99975-09•••-••-5765(628) 250-8197stephanie.torres@aol.com3934 FOREST AVEMesaAZ·85295GRP-8647MEDICARE-ADV-B··
ENRENR-1148662026-02-10T12:57:08ZMariaYSngh19870218uhc-25269-47•••-••-2274421.287.6631maria.singh63@yahoo.com3060 LINCOLN WAY··AUSTINTX78790GRP-3973MEDICARE-ADV-B
ENRENR-1285282026-05-10T09:44:09ZJOHN—ELLIS1967-12-18··UHC-60213-77•••-••-2650(735) 990-2102NULL1681 River RdScottsdaleAZ85221GRP-3614MEDICARE-ADV-A
ENRENR-1306532026-02-10T15:16:54Z·Madison—Hawkins··1950-04-28·UHC-18827-80•••-••-2626636-543-2404madison.hawkins@hotmail.com3643 Forest Avenue Apt 20GilbertAZ85231··GRP-7551MEDICARE-ADV-B
ENRENR-1054262026-08-06T17:46:10ZJckD.Lopez1939-01-02UHC-39912-26null4199459800null6158 CEDAR LNAustinTX78782GRP-0733NAVIGATE-HMO
ENRENR-1172892026-03-21T12:56:59ZTIMOTHYSSTONE1970-03-26UHC-35791-77•••-••-0650·2627238203timothy.stone@gmail.com1872 Ridge RoadChandlerAZ85237GRP-5255CHOICE-PLUS-PPO
ENRENR-1028592026-09-21T14:27:12ZMaryC·Ward1948-03-13UHC1762599•••-••-26879532774··mary.ward70@hotmail.com4346 Indian School RoadHoustonTX77059·GRP-6967CHOICE-PLUS-PPO
ENRENR-1033812026-08-05T03:22:49ZTorres, DonnaG—10/11/1981UHC-70484-11•••-••-80649959668DONNA.TORRES70@PROTON.ME8447 Willow Court Apt 11·Orlandofl32879-2412GRP-8174NAVIGATE-HMO
ENRENR-1026942026-06-04T05:13:00ZKELLYV.EVANS19900711UHC-53747-07•••-••-8327876.587.3832kelly.evans@hotmail.com2275 MEADOW LANEFresnoCalifornia93780·GRP-4875medicare-adv-b
ENRENR-1008182026-01-31T22:16:10ZMarcus—Hall1946-12-15UHC-89525-68NULL654-763-0255marcus.hall@aol.com2861 MAPLE AVENUETucsonAZ85712GRP-3315··CHOICE-PLUS-PPO
ENRENR-1381392026-02-12T17:09:06ZPhilipNGarrett04/13/98UHC-73051-83•••-••-9985316.385.0943philip.garrett@yahoo.com2283 MARKET STREETAtlantaGA30375GRP-9744MEDICARE-ADV-B
ENRENR-1176602026-07-17T11:10:52ZMyers, DoorthyO.—1983-07-22UHC-06278-26•••-••-052012969997738dorothy.myers42@gmail.com8147 HARBOR BOULEVARDHoustonTexas77041GRP-0502CHOICE-PLUS-PPO
ENRENR-1357092026-03-14T19:27:16ZMICHELLE—SOTO06/18/1948UHC7179495···(459) 671-5037michelle.soto@proton.me4713 Lincoln WayScottsdaleaz85295-0692GRP-8018NAVIGATE-HMO
ENRENR-1072752026-10-06T10:33:27ZNATHANKTUCKER1982-07-18UHC-69609-12•••-••-4480505.895.5843nathan.tucker@proton.me573 UNION STREETHoustonTX77009GRP-4582NAVIGATE-HMO
ENRENR-1245502026-07-12T09:50:38Z AndreaQContreras2003-07-26UHC-43923-96•••-••-50044053634910ANDREA.CONTRERAS@PROTON.ME2966 MARKET STREETDenverCO80210GRP-4492NAVIGATE-HMO
ENRENR-122443 2026-01-21T19:24:43ZChristina—Hamilton10/13/1958UHC-45758-40•••-••-6795297-545-2179christina.hamilton@aol.com5486 Willow CtMinneapolisMinnesota55484··GRP-6072CORE-HMO
ENRENR-1030322026-07-28T21:49:07ZABBYWELLIS·1967-06-11UHC-68582-42•••-••-4346(542) 430-4509abigail.ellis@aol.com4371 CAMELBACK RDAustinTX78766GRP-3899CORE-HMO
ENRENR-1057892026-04-29T10:36:09ZAlexis·VDay··1997-09-07UHC-68769-03•••-••-3017648-220-9403ALEXIS.DAY67@OUTLOOK.COM5370 Ocean AveSan AntonioTX78239GRP-2995OPTIONS-PPO
ENRENR-1374982026-06-22T21:32:51ZKENNETHP.VALDEZ1947-10-28UHC-39425-26•••-••-308313699945930kenneth.valdez@proton.me9128 Ridge RdSacramentoCA95804GRP-2317NAVIGATE-HMO··
ENRENR-1307902026-10-12T19:45:23ZReyes, TheresaZ—1943-03-20UHC-09610-32•••-••-0937747.573.6121··—NULL—NULLGRP-1001CORE-HMO··
ENRENR-1356092026-04-14T01:35:09Z EVELYN X—GARZA2000-07-13UHC-78260-67··•••-••-4545757.999.6738evelyn.garza@proton.me7059 Sage CourtCOLUMBUSOH43272GRP-3689CORE-HMO
ENRENR-1274952026-08-30T16:50:09ZMeganU·Young12/18/48UHC-21896-85•••-••-6881718-571-6491UNKNOWN2273 Park PlGlendale··AZ85302GRP-6611OPTIONS-PPO
43,101 rows, page 108 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.748Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty