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-112425ENREtan Alvraez1955-12-04UHC-95573-589707017180349 Mountain View Dr, Nashville, TN, 372690.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-104502ENRTimothy Hamilton1952-01-26UHC-90711-4582046088046114 Church St, Eden Prairie, MN, 553590.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-110970ENRAlexander I Shaw1938-03-04UHC-11225-3949054399615813 Market St, Orlando, FL0.52Middle initial moved out of first nameDate of birth reformattedPhone reformattedZIP missing+2 more
ENR-114586ENRKing Sofia1959-10-18UHC-08034-3045460295071813 Valley View Dr Apt 31, Scottsdale, AZ, 852480.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-117606ENREmily X Willis2001-01-12UHC-12444-5825645376721859 Market St, Miami, FL, 331680.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-101409ENROlivia I Carrr1950-07-25—67784417303834 Forest Ave Apt 20, Jacksonville, FL, 322220.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-100846ENRJustin Robertson2005-01-13UHC-36053-5055747068011356 River Rd, San Antonio, TX, 782380.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102972ENRSean K Jenkins1946-04-18—97965439502326 Desert Sky Blvd, Chandler, AZ, 852630.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-118078ENRJoshua O Lawson1965-11-09—53048864487160 Apache Blvd, Denver, CO0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126267ENRXJunk1994-02-07UHC-72104-0586035194478276 Spring St, Las Vegas, NV0.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126268ENRXJunk1994-02-07UHC-72104-0586035194478276 Spring St, Las Vegas, NV0.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-122321ENRSara C Burton—UHC-23295-3049261451779018 Bayshore Dr, Gilbert, AZ, 852850.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-120562ENRAnna C Fox1995-06-05UHC-77555-1849383021038586 Central Ave, San Diego, CA0.52Middle initial moved out of first namePhone reformattedCity re-casedZIP missing+2 more
ENR-108626ENRKevin Boyd2007-02-20UHC-41277-6842292424779379 Ridge Rd Apt 30, Columbus, OH0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-102311ENRKenneth Marshall—UHC-85421-0766453962747655 Camelback Rd # 370, Las Vegas, NV, 891900.52Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-133719ENRJazon H Ruuiz2000-12-27UHC-96989-7858138238915935 Jefferson Ave, Chandler, AZ, 852510.52Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-105083ENRDorothy T Clakr1989-03-13UHC-97273-05—9671 Sunset Blvd, San Antonio, TX0.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-109712ENRAmber Z Moreno—UHC-42609-2546347849217167 Elm St, Chandler, AZ, 852400.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-136287ENRBradley E Lawrence1991-06-06UHC-86126-6582353236454747 Desert Sky Blvd, Jacksonville, FL0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137572ENRChristopher Young1993-07-09UHC-27607-79—1866 Church St, Chandler, AZ, 852690.52Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-101416ENRMartha C Murphy1950-02-01UHC-96988-5761877603698376 Camelback Rd, Scottsdale, AZ, 852320.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-138672ENRNicholas V Wood2001-03-23UHC-57484-4944956109913622 Oak St, Tampa, FL, 336750.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-140720ENRJose H Sims1986-01-20UHC-00961-2368224785183700 Park Pl, Las Vegas, NV, 891010.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-138527ENRDeborah Y Waard1989-10-07UHC-37082-416374497703817 Willow Ct, Minneapolis, MN, 554470.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-133431ENRKelly Wallace2001-09-05UHC-98623-51—9436 Oak St, Scottsdale, AZ, 852870.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-114249ENRMegan P Carpenter1946-06-01UHC-78670-6350257052843675 Willow Ct, Nashville, TN, 372310.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-100549ENRJoshua Willis1945-04-07UHC-25334-7943376392596663 Oak St Apt 14, Sacramento, CA, 958350.52Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+2 more
ENR-127021ENRCarolyn Z Porter1995-04-15UHC-44477-87—5268 Church St, Seattle, WA, 981880.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
ENR-140830ENRElizzabeth V Lucas2008-07-01UHC-40561-1380982350848572 Sage Ct Apt 37, Plano, TX0.52Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
ENR-111851ENRJuan Carroll1960-11-20UHC-88791-7821643618006460 Church St # 925, San Antonio, TX0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-114075ENREthna Jacobs1943-12-05UHC-87152-4172443544598666 Mountain View Dr, Glendale, AZ0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-124988ENRJuan C Powll1986-03-20UHC-26955-3670772659483389 Pine Dr, Fresno, CA, 937360.52Middle initial moved out of first namePhone reformattedMember ID reformattedSSN last four extracted+2 more
ENR-121198ENRGeorge C Sanchez1970-05-24UHC-75107-9022571964521944 Park Pl Apt 15, Seattle, WA0.52Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+2 more
ENR-121170ENRDonald OJunk1999-01-19UHC-13344-8043769137795902 Broadway # 844, Eden Prairie, MN, 553220.52Name re-casedDate of birth reformattedUnit split from streetGender normalised+2 more
ENR-116061ENRArjun O Wong1993-08-22UHC-77127-4142939483461565 Sunset Blvd, Gilbert, AZ, 852420.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-127954ENRVictoria G Kelley2004-12-11UHC-58308-81—3826 Washington St, Glendale, AZ, 853210.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-142495ENRAna N Mendoza—UHC-36196-3355187274962702 Lake View Rd, Atlanta, GA, 303070.52Middle initial moved out of first nameDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-111645ENRMarilyn A Contreras1977-05-23UHC-19912-8938295764401227 Highland Ave, San Antonio, TX, 782650.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-134254ENRJese P Park1950-02-11UHC-31353-2494872256765096 Valley View Dr, Charlotte, NC0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-139045ENRDon Hudson1964-02-07UHC-48273-26—6118 Lake View Rd, Minneapolis, MN, 554440.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-104001ENRAnn O Adams1964-03-09UHC-49487-8994766135654774 Broadway, Scottsdale, AZ0.52Name re-casedTwo-digit birth yearPhone reformattedZIP missing+2 more
ENR-123399ENRAnthony J Ramirez1948-04-19UHC-63508-4463684777926106 Spring St, Dallas, TX, 752850.52Middle initial moved out of first nameName re-casedPhone reformattedSSN last four extracted+2 more
ENR-134691ENRDennis Warren1969-11-23UHC-83107-2687189280535204 Bayshore Dr, Dallas, TX0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-116002ENRSharon J Duncan1994-04-22UHC-94928-4885867557961226 Mountain View Dr, Gilbert, AZ, 852280.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-104853ENRCole Jack1966-03-02UHC-23453-2633437297453178 Desert Sky Blvd, Seattle, WA, 981970.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-106091ENRScott Q Singh1941-06-19UHC-63799-3443348968452352 Oak St Apt 18, Nashville, TN, 372050.52Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-106085ENREugene Perkins1991-05-21UHC-74376-0940926401958300 Canyon Rd, San Antonio, TX, 782430.52Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+2 more
ENR-136187ENRJoyce V Chapman2007-02-23UHC-27758-5735144924777447 Canyon Rd, Tempe, AZ, 852220.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-124089ENRDenise S Ward1959-07-06UHC-58871-56—8358 Lake View Rd, Miami, FL, 331130.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-103198ENRSandra Morris1976-08-19UHC-98911-1662283487888039 Valley View Dr, Minneapolis, MN, 554280.52Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed+2 more
43,101 rows, page 83 of 863PreviousNext