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-1206382026-01-03T03:53:38Zglorya··anderson1988-01-25UHC-90380-35NULL229-214-6547gloria.anderson64@gmail.com2801 CEDAR LNMINNEAPOLISMN55401GRP-3558MEDICARE-ADV-A
ENRENR-1047922026-05-10T11:44:38ZRAYMONDN··ARMSTRONG1984-08-09UHC-54364-17•••-••-2261880-858-9858raymond.armstrong@yahoo.com2275 Forest Ave Apt 36SacramentoCAUNKNOWNGRP-2872CORE-HMO
ENRENR-1133662026-01-15T03:18:24ZalexisSbrooksMar 25, 1966·UHC-40867-57•••-••-7105337-598-7024alexis.brooks@outlook.com741 Ridge RoadSan AntonioTX78284GRP-1624NAVIGATE-HMO
ENRENR-1302102026-04-29T14:05:03ZMark W—Day1989-60-07UHC-40883-26•••-••-76688694762010-··9298 Bayshore Dr··Charlotte··NC28276GRP-2776·CORE-HMO
ENRENR-1084432026-09-29T15:44:14Z GLORIAD·LARSON·1942-03-08UHC-61814-19•••-••-2104(908) 912-5064gloria.larson@yahoo.com5998 Sunset Blvd #574SacramentoCA95842GRP-3948MEDICARE-ADV-B
ENRENR-1081912026-07-08T01:08:27ZHENRYM.SNYDER09/18/1946UHC-07445-14•••-••-9613nullNULL4659 CHURCH ST··HoustonTX—GRP-4308MEDICARE-ADV-A
ENRENR-1220962026-06-03T20:32:58ZKyle—Watkins1984-12-10UHC-94843-45•••-••-4837N/AKYLE.WATKINS@AOL.COM2406 Palm Drive··TampaFL33648GRP-5401CORE-HMO
ENRENR-1320862026-09-09T13:42:05ZGrant, Douglas——04/15/2005UHC-69967-87•••-••-1241·745.270.3908douglas.grant11@proton.me4836 Spring StreetGILBERTAZ85268GRP-2145MEDICARE-ADV-B··
ENR ENR-1407132026-03-22T06:15:29ZBOBBYISPENCERMay 20, 2004UHC-93132-84•••-••-9681869.481.9464bobby.spencer43@yahoo.com1905 Sage CtJacksonvilleFL32210GRP-9258OPTIONS-PPO
ENRENR-1416822026-08-24T11:18:38ZAshleyX.Carter02/25/1951UHC-23575-96··•••-••-125014692681630ashley.carter@yahoo.com970 MESA DRDALLASTX75260GRP-8101OPTIONS-PPO
ENRENR-1042622026-05-03T00:42:08ZomarW.rios1897-10-15UHC-69358-19•••-••-5962370-522-1701omar.rios@icloud.com5383 Union StPlanoTX75043-8307GRP-7862SELECT-EPO
ENRENR-1015632026-07-26T07:24:23ZSHIRLY—HAYES·1958-10-25uhc-53138-46•••-••-1302(551) 364-7709shirley.hayes@proton.me114 Church Street··Las VegasNV89146GRP-8788CHOICE-PLUS-PPO··
ENRENR-1020662026-08-23T05:40:06ZHoward, RonaldR.—20000414UHC-79531-36•••-••-6079·+1 244 693 0748UNKNOWN4968 Valley View DriveJacksonville··FL—GRP-2709MEDICARE-ADV-B
ENRENR-1020542026-10-08T14:19:46ZGonzales, TerryE—1960-11-26UHC-11646-83•••-••-4530(845) 577-2299UNKNOWN3192 Spring StreetTampaFL33685GRP-2736··CORE-HMO
ENRENR-1016322026-05-06T05:56:21ZLoriBBell19-07-1954UHC-32635-68•••-••-893616116405032·lori.bell@hotmail.com8024 Desert Sky BoulevardEDEN PRAIRIE·MN55392GRP-4928NAVIGATE-HMO
ENRENR-1252492026-02-16T16:26:38Z·Sharon—Chapman14-01-1967UHC4064474•••-••-3971718-826-5245SHARON.CHAPMAN@ICLOUD.COM249 Ocean AvenueLos AngelesCA90051-9169GRP-3779SELECT-EPO
ENRENR-1066922026-07-21T22:45:36ZMargaret—McCoy07/09/1969UHC-88924-63•••-••-2988584-230-1903margaret.mccoy@icloud.com4305 Meadow LaneDenverCO80235GRP-4860CORE-HMO
ENRENR-1335902026-02-14T11:02:06ZSUSANWRIOS19491119UHC-60800-01•••-••-4044N/Asusan.rios33@yahoo.com6263 Highland AveGlendaleAZ85368GRP-1914NAVIGATE-HMO
ENRENR-1348292026-01-03T23:58:21ZMasunXPalmmer2005-01-19UHC-10433-05•••-••-7917+1 371 473 3434mason.palmer@outlook.com334 LINCOLN WAYATLANTAGeorgia30351GRP-6564MEDICARE-ADV-B
ENRENR-1289062026-04-06T08:31:58ZMason—Mitcheell1970-02-12UHC-65663-44•••-••-51495912815733·mason.mitchell@yahoo.com3286 Cedar LaneHouston·TX77009-7803GRP-1283NAVIGATE-HMO
ENRENR-1197962026-01-15T01:08:27ZvirginiaR.sullivan1985-09-04UHC-10615-39•••-••-7317(720) 766-8412UNKNOWN9699 WASHINGTON STREETAtlantaGA30321GRP-5910·NAVIGATE-HMO
ENRENR-1417922026-07-05T04:05:45Z·ROYU.JMES2008-11-12UHC-07344-39•••-••-6659(555) 719-3929·roy.james@proton.me6635 Park PlLas Vegasnv89178-4210GRP-7736CORE-HMO··
ENR ENR-100739 2026-03-18T00:36:38ZAnthonyVRiley02-09-1961·UHC-63628-62N/A+1 340 844 8924ANTHONY.RILEY5@AOL.COM4452 Harbor BlvdSan DiegoCA··92151GRP-2514CORE-HMO
ENRENR-1062722026-07-26T23:53:27Zlucia····jenkins1994-12-04UHC-65576-36•••-••-4680NULLNULL1182 MAIN STGlendaleaz85317GRP-3235SELECT-EPO
ENRENR-1031092026-09-22T08:27:44ZGARYZPICE1976-10-01UHC-09967-57•••-••-908219218690091gary.price77@proton.me8120 Bayshore DrChandlerAZ85219GRP-5111CORE-HMO
ENRENR-1053732026-05-22T17:58:59ZMICCHELLE—HART1972-02-27·UHC-85848-93•••-••-84617917072618—8716 Hillcrest RoadMesaAZ85214GRP-8793CHOICE-PLUS-PPO
ENRENR-1268902026-08-10T07:15:04Z·DONALDBELLIS1939-01-25UHC-39148-42•••-••-6509280.901.1502·UNKNOWN9268 Union StreetTempeAZ85269GRP-2035MEDICARE-ADV-A
ENR ENR-1233222026-08-28T06:01:45ZAMY—BOYD·4/9/1941UHC-38686-34•••-••-3378·(579) 320-9927AMY.BOYD75@ICLOUD.COM2242 INDIAN SCHOOL ROADTampaFlorida33655GRP-8008MEDICARE-ADV-A
ENRENR-1411592026-05-08T01:19:12ZHenry··—·Jensen05/09/1975UHC-86555-86•••-••-0033837-283-6491NULL8650 Sunset BoulevardLAS VEGASnv89193GRP-9908core-hmo
ENRENR-1254942026-08-17T04:42:44ZGLORIAMSTONE1945-12-08UHC3580459•••-••-6059+1 489 797 6147GLORIA.STONE25@ICLOUD.COM5334 Ocean AvenueMESAAZ85249GRP-8983SELECT-EPO
ENRENR-1355432026-06-24T15:48:31ZKyle—Taylor··1943-03-04UHC-59965-33•••-••-73548165268kyle.taylor84@gmail.com8402 GRAND AVEEden PrairieMinnesota·55389GRP-7154SELECT-EPO··
ENRENR-1272862026-10-07T12:04:48ZASHLEY·WWALKER1952-12-07UHC9481045•••-••-8085306-571-3948·ashley.walker@hotmail.com524 Indian School RdAtlantaGA30310GRP-9026OPTIONS-PPO
ENRENR-1169042026-05-16T10:37:50ZKATHRYN—LAWRENCE1992-05-09·uhc-50224-09•••-••-9375(405) 766-0111KATHRYN.LAWRENCE@AOL.COM···6151 BroadwayColumbusOH43227GRP-6592SELECT-EPO
ENRENR-1364682026-07-27T08:21:04Z Sophhia—RyanAug 3, 1966UHC-48990-31··•••-••-78635818771242-8766 SPRING STREETSEATTLEWashington—GRP-9245MEDICARE-ADV-A
ENRENR-1116872026-06-21T01:07:02ZMrathaB.··Soto·1957-12-05UHC-45087-63•••-••-65025014708672martha.soto@outlook.com2000 HARBOR BLVDAUSTINTX78700GRP-7711MEDICARE-ADV-A
ENRENR-1419842026-03-04T15:36:12ZAMBER—GARRETT1965-02-08UHC-76042-07•••-••-6310(382) 419-0602AMBER.GARRETT65@PROTON.ME7536 Park Place·AtlantaGeorgia30344GRP-6913CHOICE-PLUS-PPO
ENRENR-1074062026-02-15T06:46:19Z·Laura—Wong1951-08-09UHC-97344-52•••-••-2510(493) 244-7322—·4997 Meadow LnSacramentoCA95867GRP-1216MEDICARE-ADV-B
ENR ENR-1269432026-09-24T07:29:51ZPhilip·LHolmes1963-12-14UHC8376230•••-••-02145527026796philip.holmes88@proton.me9662 INDIAN SCHOOL RDGilbertAZ85255GRP-0245SELECT-EPO
ENRENR-1018152026-09-27T20:48:55ZHughes, PriyaZ—1998-09-22UHC-84393-22•••-••-55339629412867NULL63 Sunset BlvdATLANTAGA30389GRP-2438MEDICARE-ADV-A
ENRENR-1409132026-10-15T10:22:40ZChristinaNGriffin19401108UHC-88176-08UNKNOWN7854759863NULL7775 Oak StreetMinneapolisMN55405GRP-8582CHOICE-PLUS-PPO
ENRENR-1221892026-07-16T06:58:26ZNatalieZShaw10/12/1944UHC-26251-27•••-••-3973759-415-4971natalie.shaw97@yahoo.com4059 BroadwayGlendaleAZ85308GRP-5701MEDICARE-ADV-A
ENRENR-1201662026-06-25T12:25:58Z·Sims, Danielle——1961-10-28·UHC-89107-01•••-••-3280239-475-7039UNKNOWN3165 Willow Court Apt 40·TampaFL33607GRP-8145CHOICE-PLUS-PPO
ENRENR-1382632026-09-01T03:36:27ZAISHAI··POWELL1963-07-22UHC8057939—UNKNOWNAISHA.POWELL47@AOL.COM7207 PALM DRSacramentoca95899··GRP-6459MEDICARE-ADV-A
ENRENR-1158662026-03-19T13:26:57Z Nicole—Pena1991-09-09·UHC-03671-49•••-••-9288—NICOLE.PENA70@HOTMAIL.COM294 LINCOLN WAYTempeAZ85264GRP-0719medicare-adv-b
ENRENR-1426362026-05-23T21:47:09ZLUISCJONESMay 16, 1948UHC-28777-79•••-••-8431(977) 804-7251LUIS.JONES@OUTLOOK.COM2298 Sage CourtPhoenixAZ85096GRP-0814CORE-HMO
ENRENR-1365332026-04-05T09:37:25ZCHERYL·L.PETERSON3/10/1958UHC-22463-54•••-••-2058834-409-9831CHERYL.PETERSON23@AOL.COM8368 HILLCREST ROADDENVERCO—GRP-5598NAVIGATE-HMO
ENRENR-1149872026-08-25T06:13:57ZLUCIA—PHILLIPS1942-08-28UHC-76505-18•••-••-2598225.929.1878-6449 CHURCH STTucsonAZ··85775GRP-8325OPTIONS-PPO
ENRENR-1298552026-10-05T12:29:26ZMeganKJohnston1999-09-12UHC-38617-08•••-••-80064864921881-6312 RIDGE ROAD·SAN DIEGOCaliforniaNULLGRP-3181select-epo
ENRENR-1004632026-07-17T11:37:28ZSUSAN—MYERS03-07-1986UHC-25021-80•••-••-5347874-966-6263·susan.myers93@gmail.com2325 HARBOR BOULEVARDSAN ANTONIOTX78218GRP-6264MEDICARE-ADV-B
ENRENR-1369482026-05-11T22:31:23ZPadillaRSharon10/26/52UHC8214281•••-••-6391447-223-7586SHARON.PADILLA@OUTLOOK.COM134 Indian School RdNashvilletn37257GRP-4311medicare-adv-a
43,101 rows, page 247 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:40.632Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty