Normalised records

Normalised records (silver)

Each raw row is parsed into consistently formatted fields. Every change from the raw value is recorded as a data-quality flag.

Normalised rows
99,495
usable in matching
Flagged rows
99,881
99.9% carry at least one flag
Junk quarantined
505
no usable last name
Average quality score
0.75
1.00 = no corrections needed

Quality flags

What normalisation had to do, and how often. Select a flag to filter the table.

Normalised records

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-121949ENRAlbert C Parker2002-03-03UHC-63627-892387815960258 Market St, Scottsdale, AZ, 852550.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-124081ENRArjun A Olson1990-05-15UHC-60248-068113078829769 Cedar Ln, Dallas, TX, 752250.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103367ENRAndrea M James1953-02-16UHC-49092-78—4986 Highland Ave, Plano, TX, 750530.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103366ENRAndrea M James1953-02-16UHC-49092-78—4986 Highland Ave, Plano, TX, 750530.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141664ENRDylan HJunk2003-08-15—55592343134658 Valley View Dr, Los Angeles, CA, 900280.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-138468ENRCarl C Milller—UHC-42305-559457385035170 Willow Ct, Miami, FL0.38Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-140528ENRArthur T Reid—UHC-82158-1444997424444854 Church St, Miami, FL, 331630.38Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127418ENRSteve M Harrison1955-03-22UHC-14162-8537528473389547 Indian School Rd, San Antonio, TX0.38Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
ENR-119858ENRHeather N Hart1940-09-07UHC-30106-3420897630473708 Hillcrest Rd, Miami, FL0.38Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-136545ENRSamantha C Cruz—UHC-37990-57—4590 Bayshore Dr, Columbus, OH, 432500.38Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-100140ENRAsutin O Aguilar1993-07-28UHC-85487-9465069675633665 River Rd, Los Angeles, CA, 900490.38Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-104265ENRDiego Jimenez1940-09-20UHC-73976-8758731812635774 Hillcrest Rd Apt 21, Tampa, FL, 336750.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-141216ENRMark E Edwards1956-10-11UHC-45206-3370977373117708 Highland Ave, Eden Prairie, MN, 553390.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140916ENREthan Y Thompson1939-03-09UHC-90196-9580490262401975 Desert Sky Blvd Apt 39, Glendale, AZ, 853120.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-134733ENRBryan Matthews1988-07-28UHC-23750-6192463300128907 Harbor Blvd, Plano, TX, 750850.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101967ENRCheryl A Cunningham1949-09-03UHC-44238-0182297307751762 Cedar Ln, Chandler, AZ, 852800.38Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-132234ENRAndrew Vargas1941-06-24UHC-46683-84—8072 Mountain View Dr # 982, San Diego, CA, 921040.38Name split from “Last, First”Date of birth reformattedSSN last four extractedUnit split from street+3 more
ENR-109321ENRAlice N Spencer—UHC-71190-27—4684 Mountain View Dr # 932, Houston, TX, 770170.38Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
ENR-109322ENRAlice N Spencer—UHC-71190-27—4684 Mountain View Dr # 932, Houston, TX, 770170.38Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
ENR-100627ENRJuulia N Obrien1941-01-03UHC-51219-306657760070497 Oak St, Gilbert, AZ, 852800.38Middle initial moved out of first nameName re-casedTwo-digit birth yearStreet suffix standardised+3 more
ENR-109454ENRSofiia Robertson1956-08-16UHC-53644-18—1630 Mesa Dr, Minneapolis, MN, 554680.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-105205ENREmma Jimenez1947-03-08UHC-12284-5025976806336157 Palm Dr, Glendale, AZ0.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114808ENRDeborah Romero1954-12-26UHC-22670-8984261493908812 Lincoln Way, Los Angeles, CA, 900760.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-112221ENRRachel W Elliott1995-11-25UHC-94005-3296128520339231 River Rd, San Antonio, TX, 782410.38Middle initial moved out of first namePhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-103110ENRGary Price1976-10-01UHC-09967-5792186900918120 Bayshore Dr # 842, Chandler, AZ, 852190.38Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-133097ENRRalph R Grreen1994-02-21UHC-95379-38—831 Ridge Rd Apt 33, Mesa, AZ0.38Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
ENR-103508ENRJeffrey R Rice1986-06-14UHC-50934-22—788 Washington St # 129, Mesa, AZ, 852610.38Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-120588ENRDiana P Ruiz—UHC-17013-5248436395696684 Indian School Rd, Tucson, AZ, 857710.38Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-105526ENRWillie N Gonzalez1938-08-11UHC-09367-6849975649278463 Indian School Rd Apt 10, Seattle, WA, 981600.38Middle initial moved out of first namePhone reformattedMember ID reformattedUnit split from street+3 more
ENR-118274ENREmma A Rios1960-01-12UHC-40743-44—1383 Willow Ct, Denver, CO, 802970.38Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141838ENRAna P Lewis1951-03-11—39246694787077 Palm Dr # 323, Austin, TX, 787180.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-104799ENRBradley W Hart1967-02-21UHC-04020-5323966984151900 Sunset Blvd Apt 4, Las Vegas, NV, 891250.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-140280ENRJessica V Wood2004-05-24UHC-42569-5755963426083017 Camelback Rd, Scottsdale, AZ, 852700.38Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-120825ENRGerald Hunter—UHC-11413-0344573388035105 Sunset Blvd, Columbus, OH0.38Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108073ENREmily Lopez2004-08-12UHC-26356-0841270162753277 Forest Ave, Seattle, WA, 981530.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106341ENRDiego S Espinoza1992-02-11UHC-74540-6846361960166172 Willow Ct, Houston, TX, 770620.38Name split from “Last, First”Two-digit birth yearSSN last four extractedStreet suffix standardised+3 more
ENR-107594ENRAhmed Munoz1980-06-16UHC-44111-0938277641972523 Bayshore Dr Apt 31, Austin, TX, 787080.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-105245ENRRichard J Thompson1994-09-10UHC-33481-1153346791144153 Jefferson Ave, Houston, TX, 770630.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-139262ENRDanielle E Young2004-09-22UHC-09608-9797981983865918 Baseline Rd, Sacramento, CA, 958110.38Name split from “Last, First”Phone reformattedSSN last four extractedState name converted to code+3 more
ENR-119735ENRAmber T Berry1995-05-11UHC-99791-8222941230395315 Palm Dr # 310, Atlanta, GA, 303690.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-117581ENRDiego Bowman1973-10-25UHC-16501-7698185409358183 Sunset Blvd, Charlotte, NC0.38Name split from “Last, First”Phone reformattedSSN last four extractedZIP missing+3 more
ENR-114647ENRRoy U Kim1972-11-02UHC-44848-3964837367511602 Church St # 795, Nashville, TN0.38Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-100488ENRPhilip W Cole1991-03-27UHC-87676-1441380169404018 Highland Ave, Sacramento, CA, 958370.38Name split from “Last, First”Two-digit birth yearPhone reformattedState name converted to code+3 more
ENR-141206ENRTerry Tucker1978-04-18UHC-71283-357739769186525 Meadow Ln, Minneapolis, MN, 554590.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122676ENRGeorge E Porter1959-02-20UHC-03769-5172762869051997 Elm St, Eden Prairie, MN, 553280.38Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-130215ENRAna Knight1992-08-10UHC-00835-2657735969684791 Harbor Blvd # 125, Glendale, AZ, 853270.38Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-104139ENRBrenda R Estrada1963-12-15UHC-89999-03—8397 Canyon Rd, Tucson, AZ, 857380.38Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-115664ENRElizabeth Q Dominguez1974-03-10UHC-35965-9367662741704119 Church St, Charlotte, NC, 282510.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109867ENRDeborah X Harvey1986-10-11UHC-95099-5596142487108313 Market St, Tampa, FL, 336490.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-115675ENRScott Z Reyes—UHC-64259-9896335127716572 Forest Ave, Houston, TX, 770110.38Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
43,101 rows, page 17 of 863PreviousNext