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-1266652026-04-09T09:15:26Z·MARCUSSWOG··19880410··UHC-05531-33•••-••-4895803-459-3381—3182 Union StGilbertArizona85211GRP-2442SELECT-EPO
ENRENR-1317122026-03-30T03:21:59ZWALTER—CARTER19980114UHC-11426-79•••-••-8158380-475-9540UNKNOWN8437 Lincoln WayDenverColorado80206GRP-5103OPTIONS-PPO
ENRENR-1063872026-08-01T14:23:33Zbarbara··Tweaver2006-11-02··UHC-82682-70•••-••-66253023324524N/A9677 Lincoln WayFRESNOCA93756GRP-3644·CHOICE-PLUS-PPO
ENRENR-1180712026-02-18T23:57:48ZNATHANWBARNES1986-05-06UHC-62649-74•••-••-7827(424) 824-5509—7470 Desert Sky Boulevard··MINNEAPOLISMN55434GRP-9435CORE-HMO
ENRENR-1171162026-06-01T14:55:50ZRoger·SSoto01-04-1973UHC-49041-01•••-••-4659(563) 862-3572—7812 Highland AveDallasTX75283·GRP-8527CHOICE-PLUS-PPO
ENR ENR-1231012026-09-03T04:39:52ZDiana—Ortega1940-12-05UHC-23434-48•••-••-53109779867067diana.ortega1@outlook.com5111 Forest AvenueTucsonAZ85789GRP-7374NAVIGATE-HMO
ENR ENR-1424992026-09-23T23:35:48ZAmanda····Yang1941-10-25UHC9990718•••-••-0259·257-522-3460null1855 Baseline RoadMesaAZ85237GRP-6953medicare-adv-b
ENRENR-1391842026-08-27T09:15:08ZRoger—Ross1969-11-10UHC-85620-84•••-••-79948073967007roger.ross@outlook.com7008 PALM DRGLENDALEAZ85363GRP-1534MEDICARE-ADV-B
ENRENR-1080192026-07-02T00:13:28ZLINDAYGOEMZDec 22, 2002UHC-79026-95•••-••-9012(836) 919-0647linda.gomez@yahoo.com2234 Mesa Drive Apt 7GILBERTAZNULLGRP-2161SELECT-EPO
ENRENR-1360052026-06-04T18:17:23ZPRIYA····BOWMAN1985-06-27UHC-20261-11•••-••-1369(707) 337-0279PRIYA.BOWMAN93@GMAIL.COM8188 Willow CtNashvilleTennessee··37260GRP-9749OPTIONS-PPO
ENRENR-1404352026-08-12T01:39:41ZPAUL—PRICE1/19/1991UHC2489046•••-••-1185752-596-7410null5622 Mountain View DriveMesaAZ·85286GRP-1965CHOICE-PLUS-PPO
ENRENR-1202772026-07-03T06:48:30ZEVELYNZFREEMAN1958-03-22UHC-35259-03•••-••-5151(574) 477-0213N/A1736 Mountain View DrAtlantaGA30364-8125GRP-8117NAVIGATE-HMO
ENRENR-1187852026-09-24T01:24:42ZVALENTINABCOLEMANApr 9, 1984NULL•••-••-1415(640) 861-1472valentina.coleman46@proton.me5143 Market StreetNashville··TN37207-9191GRP-2168··MEDICARE-ADV-A
ENRENR-1375472026-01-23T15:25:27ZDavidPSimmons1980-07-07UHC-57111-04•••-••-4682(358) 968-0219DAVID.SIMMONS@HOTMAIL.COM741 LINCOLN WAYSACRAMENTOCalifornia95884-7137GRP-7467OPTIONS-PPO
ENRENR-1410282026-05-29T11:03:16ZTylerXWallacce1992-09-05UHC-31842-98UNKNOWN391-920-7989tyler.wallace@proton.me1949 Pine DrOrlandoFlorida32859GRP-5472MEDICARE-ADV-B
ENRENR-1132892026-03-22T21:20:16ZRobertYHunter1967-12-10UHC-35728-26•••-••-3076nullROBERT.HUNTER7@AOL.COM·399 Broadway Apt 2·Los AngelesCA90040GRP-5416CHOICE-PLUS-PPO
ENRENR-1105462026-10-04T12:16:30ZDenise A.··—Reed1970-06-23UHC-12612-90•••-••-322715639488879UNKNOWN9294 Canyon RoadDallasTX75264-4537GRP-7210CORE-HMO
ENRENR-1272482026-04-21T22:40:03ZRuth—Hernandez1955-05-15uhc-45614-74•••-••-8977259-709-8822null1617 Lincoln WayMIAMIFlorida33139GRP-5370CHOICE-PLUS-PPO
ENRENR-1141002026-07-09T00:50:49Z Cunningham, KevinU·····10/27/1942UHC-96334-53•••-••-675917536705354··kevin.cunningham@proton.me··4976 CEDAR LANE #439OrlandoFL32813GRP-3308CORE-HMO
ENRENR-1216522026-01-06T14:46:57ZfatimaTwilson1955-05-22UHC-30785-80•••-••-14584022308476FATIMA.WILSON@GMAIL.COM2962 River RdTUCSONArizona85783GRP-4006CORE-HMO
ENRENR-1042902026-01-24T02:10:29ZDavidF.··Garcia2008-01-09UHC-62582-34•••-••-47392635653685—6698 Mesa DriveSan DiegoCA92147GRP-4591··CORE-HMO
ENRENR-1398532026-09-06T19:35:00ZGarrett, Mariana——2003-11-15UHC-39140-72··N/A+1 829 735 6353mariana.garrett76@yahoo.com6949 SUNSET BLVD·Mesaaz85258GRP-7459CORE-HMO
ENRENR-1116982026-06-23T03:29:27ZGuzman, Angela——1958-01-27UHC-35394-38•••-••-1959(857) 879-9408——····N/A··GRP-8667navigate-hmo
ENRENR-1128092026-09-17T00:44:17ZJennifer—Carr—UHC-51101-28•••-••-82164305755720jennifer.carr76@icloud.com1164 FOREST AVELas Vegas··Nevada··89148··GRP-3562MEDICARE-ADV-B
ENRENR-1380852026-01-30T22:12:44ZSantos, Omar——9191-06-04UHC-67223-77•••-••-8611(468) 769-8289··OMAR.SANTOS@PROTON.ME7590 Willow Court··Denver··CO80247GRP-8844MEDICARE-ADV-B
ENRENR-1320722026-05-16T02:20:36ZJesse—Fernandez03/09/54UHC-88309-60··+1 807 592 2637jesse.fernandez23@yahoo.com··4226 JEFFERSON AVEPlanoTX75088GRP-9483MEDICARE-ADV-B
ENRENR-1091192026-02-05T16:42:17ZDOUGLAS R—PETERSON1980-05-13UHC-56966-41•••-••-1441—····991 Mountain View DriveFresnoCalifornia93793GRP-5766MEDICARE-ADV-A
ENRENR-1299582026-06-27T09:08:36Z BradleyARodriguez·20-08-1956UHC-54839-19•••-••-4600·14422875080—6966 Canyon Road·Tampa·FL33620GRP-7996choice-plus-ppo
ENRENR-1329662026-01-03T16:30:37ZHamilton, Jerry——1954-08-13UHC-24792-31•••-••-95382096707176jerry.hamilton75@proton.me3452 Ocean AvenueSeattleWA98145GRP-8128··MEDICARE-ADV-B
ENRENR-1129782026-08-18T07:16:16ZAmber—Li1943-02-26UHC-49748-88•••-••-8234(654) 792-8037—2607 Apache BoulevardEDEN PRAIRIEMN55397··GRP-3708··MEDICARE-ADV-A
ENRENR-1198372026-03-18T12:05:10Z Mateo—Rojas2000-08-17UHC-82548-93··•••-••-9475····—8931 Ridge Rd Apt 22JACKSONVILLEFL32269GRP-9266CORE-HMO
ENRENR-1375382026-02-23T22:55:55ZAaronE··Sims19680520UHC-61920-76•••-••-1580692-557-7505NULL·7525 Spring StreetMiami··FL33132··GRP-5493···NAVIGATE-HMO
ENRENR-1420862026-04-08T09:31:18ZThomasN.··Meeyr20011001UHC-55702-01—7506869766null1824 Canyon RdGilbertArizona85206-6436·GRP-3687MEDICARE-ADV-A
ENRENR-1069092026-03-06T21:17:20ZAlexanderNCrawford1994-02-06UHC-69787-09——ALEXANDER.CRAWFORD@GMAIL.COM1954 Ocean Ave #791Los AngelesCA90087GRP-5725MEDICARE-ADV-B
ENRENR-1280992026-06-22T20:11:39ZRalphAJimenez07/12/89UHC-36480-49N/A(402) 644-0112—5171 Desert Sky BoulevardLOS ANGELESCalifornia90063GRP-1357MEDICARE-ADV-B
ENRENR-1420372026-05-29T01:48:55ZBanks, MatthewX—·04/27/78UHC-11963-65··•••-••-9886N/Amatthew.banks@icloud.com8415 Desert Sky Blvd·SEATTLE·WA98198GRP-2791CHOICE-PLUS-PPO
ENRENR-1028602026-09-21T14:27:12ZMaryC·Ward1948-03-13UHC1762599•••-••-26879532774··mary.ward70@hotmail.com4346 Indian School RoadHoustonTX77059·GRP-6967CHOICE-PLUS-PPO
ENRENR-1097012026-09-13T23:08:06ZROBERT—CARPENTER·1963-10-19UHC-38371-75•••-••-5910(852) 307-5541ROBERT.CARPENTER48@ICLOUD.COM3977 RIDGE ROAD··TucsonAZ85784GRP-0482··MEDICARE-ADV-B
ENRENR-1000922026-01-05T03:04:32ZPATRIK—PETERSON1977-05-10UHC-36259-70null4866264109N/A··7825 SAGE COURTOrlandoFL32885GRP-2799··select-epo
ENRENR-1304932026-01-28T16:03:36ZJOYCE Z.—CLARK1/21/1949UHC-03973-63·NULL12748927201joyce.clark@yahoo.com9737 Sunset BlvdColumbusOH43279GRP-7471MEDICARE-ADV-A
ENRENR-1180402026-10-17T01:02:13ZCharlotte—Kelyl1989-05-21UHC-07800-37•••-••-56149854999892-3950 Lincoln WayAtlantaGA30314-6814GRP-0791·OPTIONS-PPO
ENRENR-1055452026-01-08T05:39:27ZSANDRAQ.·HENRY1954-08-15uhc-32427-83•••-••-7933761-611-6831sandra.henry@proton.me6380 UNION STMiamiFlorida33159··GRP-5180··CORE-HMO
ENRENR-1299442026-10-07T12:07:53ZJoanMHayes2007-06-19UHC-58787-64NULL··—joan.hayes@proton.me1258 Oak StreetTucsonAZ85722GRP-0543CHOICE-PLUS-PPO
ENRENR-1000522026-09-27T15:11:59ZGEORGEFRIVERA16-06-1939UHC-83812-73—+1 627 487 0388george.rivera@hotmail.com21 Indian School RdFresnoCA93707GRP-5233SELECT-EPO
ENRENR-1022002026-06-11T03:04:32ZCarl—King1958-02-06UHC-56378-01•••-••-7997+1 263 340 4744—·6441 Mesa DriveHoustonTX77050GRP-2046··OPTIONS-PPO
ENRENR-1064362026-09-03T07:00:37ZDANIELLE—LYNCH1968-05-23uhc-12247-26•••-••-86354214510163—2337 Mountain View Drive··TAMPAFL33692GRP-0920CHOICE-PLUS-PPO
ENRENR-1121642026-09-12T19:01:03ZLOGAN—HAMILTONJan 12, 1972UHC-20469-91•••-••-58333447825010N/A7925 Pine DrCharlotte··NC28217GRP-8065·CORE-HMO
ENRENR-1110732026-01-05T15:47:51ZJones, Nancy——1964-10-04UHC0978734•••-••-12523044336054N/A—UNKNOWNNULL—GRP-0990MEDICARE-ADV-A
ENR ENR-107162 2026-08-26T07:05:30ZDIANAH··WASHINGTON1986-09-08·UHC-00989-26•••-••-65854842114851DIANA.WASHINGTON@ICLOUD.COM6512 OCEAN AVENUEGilbertAZ85210GRP-6414CORE-HMO
ENRENR-1392062026-05-13T04:45:04ZgloriaLjones1962-03-25UHC-51437-89•••-••-7770957-396-9615GLORIA.JONES11@GMAIL.COM304 Oak StreetScottsdaleAZ85277GRP-4882MEDICARE-ADV-A
43,101 rows, page 191 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.329Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty