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-1010142026-05-07T09:11:46ZSpencer, StephenV.—·19720627UHC-01478-55nullnullstephen.spencer94@yahoo.com334 SPRING STREETAustinTX78785GRP-8994OPTIONS-PPO
ENR ENR-1089222026-07-12T18:02:35ZSamuel····Murphy1938-03-23UHC8851169•••-••-3613(649) 629-9727SAMUEL.MURPHY46@ICLOUD.COM5850 Main Street·SAN DIEGOCA92114GRP-6374CHOICE-PLUS-PPO
ENRENR-1291122026-08-14T22:16:22ZReyes, Kevin——1938-04-09UHC-54672-04•••-••-7373571.647.8007kevin.reyes34@proton.me172 Sage CourtSeattleWA·NULLGRP-9023··SELECT-EPO
ENR ENR-1274432026-02-16T07:55:43ZPaulDBenett···17-06-1970UHC-74898-50•••-••-0436+1 969 409 4238N/A479 CAMELBACK RDAustinTexas··78772··GRP-5652MEDICARE-ADV-B
ENRENR-1198092026-05-20T10:21:59ZyukiQrussell1942-02-14UHC-06443-59•••-••-5975N/A··4736 RIDGE RDMesaAZ85223GRP-4057OPTIONS-PPO
ENRENR-1089412026-01-06T19:51:48ZJacobWJenkins1968-04-24UHC-53925-63•••-••-45658642535jacob.jenkins@hotmail.com3294 Union St Apt 12GlendaleAZ85355GRP-6851CORE-HMO
ENRENR-131495 2026-06-18T04:47:37Znathan··Tmyers··17-12-1951UHC-34928-07—7016920NATHAN.MYERS@HOTMAIL.COM2856 SPRING ST··CHARLOTTENC28297GRP-2617MEDICARE-ADV-B
ENRENR-1185262026-03-16T21:55:29ZHunt, AndreaZ—1980-01-21UHC-49474-85•••-••-8295(723) 331-1893andrea.hunt@gmail.com354 Lincoln WayScottsdaleAZ··-GRP-5265MEDICARE-ADV-B
ENRENR-1327222026-01-14T12:59:17ZAnthony—Gutierrez·1965-10-07UHC-23206-63•••-••-470415195151949anthony.gutierrez@outlook.com1170 Mountain View DrHoustonTX77028GRP-7274MEDICARE-ADV-B
ENRENR-1178542026-09-07T03:09:39ZWilson, VincentA—24-02-1981·UHC-67482-99•••-••-0743(231) 841-2337NULL3708 JEFFERSON AVENUE Apt 27Eden PrairieMN55367GRP-5054NAVIGATE-HMO··
ENRENR-1411732026-04-23T17:24:45ZDorisDTuckr1951-04-18··UHC-44970-38•••-••-8951+1 745 336 8473doris.tucker@gmail.com8068 BroadwayMiamiFL33128GRP-1062··MEDICARE-ADV-A
ENRENR-1081172026-09-13T11:36:49ZFRANCESJHARPER1983-08-01UHC-84962-90•••-••-1506(754) 795-8329FRANCES.HARPER@PROTON.ME5850 WILLOW COURTCHARLOTTENC28207GRP-6549MEDICARE-ADV-A
ENRENR-1269272026-01-06T16:21:39ZJeremyB.Dunan1949-03-10UHC-03261-36•••-••-7412652-711-2314jeremy.duncan79@proton.me2243 Central Ave··DallasTX75240GRP-8875·NAVIGATE-HMO
ENRENR-1192142026-06-16T12:08:53ZHowaard, Laura——·1997-03-08UHC-87745-99•••-••-8551·(368) 822-2370laura.howard@yahoo.com1777 Maple AveCharlotte·nc28257··GRP-5881MEDICARE-ADV-A
ENRENR-1028842026-04-03T07:13:33Z SofiaFDay1938-07-28UHC-43857-58•••-••-7483463.859.5313sofia.day96@icloud.com2714 Ocean AveChandlerAZ85245-3369GRP-2112NAVIGATE-HMO
ENRENR-1251972026-05-05T04:44:52ZOmar···Tran1958-03-04UHC-82234-71•••-••-7381·NULL—3320 Jefferson AveGilbertAZ85283-4162GRP-9868NAVIGATE-HMO
ENRENR-1152442026-02-23T23:50:02ZkevynR.nguyen19600917UHC-91720-45•••-••-9015886-981-6826N/A7436 Cedar LaneNashvilleTennessee-GRP-4719NAVIGATE-HMO
ENRENR-1303902026-05-21T19:52:28ZLISSAS.ANDERSON1951-12-09UHC-07284-72•••-••-41278696558856·lisa.anderson@icloud.com2347 Market StreetJacksonvilleFL32216GRP-7803MEDICARE-ADV-A
ENRENR-1189852026-08-24T07:56:09ZKennethYHolmes··05/17/1945·UHC-49321-66•••-••-62399282680443—5668 CHURCH STLos Angeles·CA—GRP-9458·SELECT-EPO
ENRENR-1054952026-08-22T11:22:35ZBILLYNHUNTER03/17/40UHC-35886-73•••-••-6315—BILLY.HUNTER@ICLOUD.COM··7361 Spring StreetPLANOTX75018-8172GRP-0846CORE-HMO
ENRENR-1079192026-06-27T20:39:03ZThomasCLuna2008-12-01UHC-14024-11•••-••-7403(478) 846-6840·THOMAS.LUNA@AOL.COM7184 LINCOLN WAYScottsdaleAZ85294·GRP-4518MEDICARE-ADV-A
ENRENR-1146752026-01-12T18:25:41ZKELLY—SMITH1992-03-27UHC-61111-64•••-••-54427669133363kelly.smith79@hotmail.com3349 Sage Court·OrlandoFlorida32889GRP-9100CORE-HMO
ENRENR-1345992026-07-18T19:56:26ZAlan—Price·Oct 17, 1973·UHC-25488-41•••-••-0761(208) 274-1262alan.price@hotmail.comnullNULLnullnullGRP-9902CHOICE-PLUS-PPO
ENRENR-1247342026-07-29T16:40:54Z·Madison····Vazquez10/9/1994UHC-54474-87•••-••-67677814970madison.vazquez@outlook.com6427 Mesa DriveMiamiFL33109·GRP-7374NAVIGATE-HMO
ENRENR-1039282026-01-30T04:25:19Zaustin—warren2008-07-28UHC-54396-70—3698148462AUSTIN.WARREN@YAHOO.COM5121 Mesa DrTampaFL33625GRP-9465MEDICARE-ADV-B
ENRENR-1027502026-07-04T17:21:14ZJustin—Vazquez1965-05-05UHC-39870-95•••-••-2095922.489.4138JUSTIN.VAZQUEZ41@YAHOO.COM742 River RoadNASHVILLETN37228GRP-1616SELECT-EPO
ENRENR-1007482026-03-05T21:12:47ZCarlosP·Kim12/10/67UHC-90592-89•••-••-2770678-233-6264carlos.kim@hotmail.com··1107 PARK PLACEColumbusOH43233GRP-9015MEDICARE-ADV-A
ENRENR-1334732026-02-20T08:03:32ZMitchell, Teresa——2001-09-12UHC-68340-13•••-••-5012(809) 758-8651teresa.mitchell@aol.com1695 CEDAR LANESan AntonioTX78272GRP-3114CORE-HMO
ENRENR-1263482026-04-26T11:21:02ZDebra—Coleman3/28/1972UHC-55489-25•••-••-9215(545) 281-7895—6947 OCEAN AVENUETempeArizona—·GRP-7972CHOICE-PLUS-PPO
ENR ENR-1079532026-07-17T14:04:11ZMariaI.Chapman1965-07-03UHC-48655-61•••-••-13312043254323N/A3669 Spring StreetMinneapolisMN55466GRP-2735MEDICARE-ADV-B
ENRENR-1062292026-07-28T09:20:29ZRichardZ.Bailey1960-04-13UHC-37971-65•••-••-5541444.628.6798NULL6762 Union StMinneapolisMN55445GRP-0954CHOICE-PLUS-PPO
ENRENR-1090792026-10-08T01:47:22ZGraham, DennisY—1941-08-25UHC-29375-09•••-••-0744(451) 838-2689··dennis.graham1@outlook.com7449 MARKET STREETLos AngelesCA90048GRP-0946MEDICARE-ADV-B
ENRENR-1253382026-06-29T19:17:41ZArjun—Hill19871013·UHC-61760-65—17608273828ARJUN.HILL31@AOL.COM3066 Maple AvenueEden PrairieMN55318-1473GRP-1781··MEDICARE-ADV-B
ENRENR-1360362026-05-29T03:14:21ZHenderson, Maria——20101121UHC-96129-77•••-••-2879946.294.2356—·7846 WASHINGTON STPhoenix·AZ85083GRP-3902MEDICARE-ADV-A
ENRENR-1417272026-10-07T02:38:02ZNathan—Day··3/20/2004·uhc-18540-15—(614) 562-5518nathan.day88@hotmail.com4425 Broadway Apt 22DALLAStx—GRP-1257NAVIGATE-HMO
ENRENR-1353392026-06-19T14:56:42ZSusan—Snyder08/26/68UHC-37162-19•••-••-3659(306) 631-3551NULL6602 River RoadDallasTX75238GRP-6352MEDICARE-ADV-A
ENRENR-1198002026-08-21T21:55:02ZMejia, Christine·D—1945-11-20UHC-22167-31•••-••-0279(878) 575-8153christine.mejia52@gmail.com6041 Lincoln WayOrlandoFL32808-1964GRP-6998MEDICARE-ADV-B
ENRENR-1109732026-06-16T16:00:32ZAbigail—Simmons1944-10-04UHC-94316-67•••-••-2231(256) 484-7168·abigail.simmons84@proton.me5286 CEDAR LNEden Prairie··MN55328GRP-8138NAVIGATE-HMO
ENRENR-1347052026-10-18T13:25:16ZPeterG.··Johnson1977-12-09·UHC-58303-89•••-••-87058343939346peter.johnson71@aol.com6608 ELM STFresnoCA—GRP-2915MEDICARE-ADV-A
ENRENR-1186812026-04-05T19:26:29ZLuciaWBanks1952-09-01UHC-23418-63•••-••-1676601.285.0584lucia.banks43@aol.com2860 JEFFERSON AVENUEChandlerAZ85277·GRP-1222NAVIGATE-HMO
ENRENR-1410982026-06-14T18:32:53Zluis··I.marshall5/12/1950UHC-04345-86·UNKNOWNNULLUNKNOWN895 Cedar LaneDenverCO80281GRP-3622NAVIGATE-HMO
ENRENR-1407912026-06-01T04:48:17ZAshleyZMendoza1974-02-09UHC-10098-84—501-693-9670ashley.mendoza@aol.com8058 Palm DriveCHANDLER··AZ85235GRP-9166MEDICARE-ADV-B
ENRENR-1188012026-02-23T02:07:02ZMargaretORice2001-03-12UHC2878131•••-••-3478+1 981 228 0735UNKNOWN·5498 Main StScottsdaleAZ85243GRP-5429NAVIGATE-HMO
ENRENR-1232242026-06-06T07:52:57ZJAMESDBELL06/24/1982UHC-41404-50•••-••-697619536814112—1829 MOUNTAIN VIEW DRIVEAtlantaGeorgia30312GRP-2291OPTIONS-PPO
ENRENR-1259512026-01-08T14:39:50ZMarilyn—James10/05/69UHC-34608-53··-(430) 416-5070—4451 Forest Ave Apt 23SCOTTSDALEArizona85265GRP-0190MEDICARE-ADV-A
ENRENR-1133582026-08-04T02:31:32ZvictoriaXwhite23-06-1948UHC-30480-57•••-••-7981(223) 615-0248victoria.white@proton.me7135 Hillcrest RdDALLASTX—GRP-7606CORE-HMO
ENRENR-1042612026-05-30T05:19:18Z·MadisonYThompson23-10-1989UHC-79249-04•••-••-2324482-542-1823madison.thompson90@proton.me2280 Highland AvenueSan DiegoCA92136GRP-3906CORE-HMO
ENRENR-1376842026-03-25T04:47:07ZMARIA—REED1980-11-20UHC-56361-37•••-••-2941937.343.0231—7395 Willow CtSCOTTSDALEArizona85251··GRP-1831OPTIONS-PPO
ENR ENR-1305782026-03-07T12:51:17ZSEAN—GUERREO·1950-04-09UHC-78198-88•••-••-7730366-936-1407SEAN.GUERRERO79@ICLOUD.COM·86 Market StTampaFL·33617GRP-1633navigate-hmo
ENRENR-1113662026-08-22T04:57:28ZKYLETVEGA19430108··UHC-33957-43•••-••-4489(476) 318-2938null7308 Harbor BoulevardMiamiFL33134GRP-0751CHOICE-PLUS-PPO
43,101 rows, page 313 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:43.606Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty