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

Third-party administrator, lowest dq score first

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-61001TPAChristopher Gray2000-08-20——6500 Elm St, Minneapolis, MN, 554110.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-55711TPAJeremy Castillo1981-09-28——3847 Grand Ave, Tempe, AZ, 852350.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56531TPADnise Harrison1977-01-12———0.80Name re-casedDate of birth reformattedPhone missing area codePlaceholder values cleared
TPA-57566TPAPhilip C Ross1944-12-11—35454789283455 Park Pl, Tucson, AZ, 857730.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63370TPAHelen Ellis2008-02-12——2899 Broadway, Denver, CO, 802590.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-51778TPABeverly Fuller1941-08-02——1857 Willow Ct, Minneapolis, MN, 554160.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55071TPAMary Martin1983-10-15——9709 Union St, Orlando, FL, 328500.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-55070TPAMary Martin1983-10-15——9709 Union St, Orlando, FL, 328500.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-60183TPAWalter Y Mitchell1982-10-27—27932471459681 Elm St, Fresno, CA, 937860.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57646TPALori Obrien1983-05-16—6914429605232 Indian School Rd, San Diego, CA, 921910.80Name split from “Last, First”Name re-casedPhone reformattedPlaceholder values cleared
TPA-63112TPACarl G Marquez1958-09-18—81991892802916 Sage Ct, Miami, FL, 331170.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53362TPAMichelle Kelley1996-03-02—69549204373767 Forest Ave, Tucson, AZ, 857300.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50958TPAKimberly West1987-09-24——1188 Pine Dr, Los Angeles, CA, 900050.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63765TPACarter Larry1981-10-14——1439 Maple Ave, Scottsdale, AZ, 852560.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57725TPACarolyn Carter1986-05-27UHC-89438-45—9813 Sunset Blvd, Sacramento, CA, 958110.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-56847TPACamila Moore2004-08-02—77794188149833 Lake View Rd, Chandler, AZ, 852310.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52076TPAGabriel Moreno1963-03-04UHC-78406-358767701307492 Pine Dr, Los Angeles, CA, 900490.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56332TPAParker William1968-06-08——4856 Mountain View Dr, Nashville, TN, 372130.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-63421TPADenise Steens1970-11-16——7600 Mountain View Dr, Houston, TX, 770530.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54626TPASean Silva1959-05-03UHC-15160-88—7819 Church St, Chandler, AZ, 852210.80Date of birth reformattedPhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-60943TPAElizabeth O Nunez2008-08-01——5625 Washington St, Sacramento, CA, 958320.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63905TPARoger Reid1961-06-04UHC-97347-56—9877 Valley View Dr, Sacramento, CA, 958800.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55160TPAWei Robinson1985-07-06—20253153965506 Desert Sky Blvd, Los Angeles, CA, 900050.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-59491TPADiana Webb1967-05-27——5776 Oak St, Scottsdale, AZ, 852440.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61196TPAChristopher Hansen2002-05-03—2219238600—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-53014TPAAaron Smith1947-09-28——6483 Washington St, Gilbert, AZ, 852530.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50553TPAJean Ortiz1969-08-16—72778867129151 Pine Dr, Fresno, CA, 937680.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54599TPAVincent West1939-07-15——5605 Desert Sky Blvd, Austin, TX, 787350.80Email lower-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58229TPAAnna Edwards2001-12-09——3858 Willow Ct, Seattle, WA, 981350.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63811TPAEmily Foster1988-02-21——1701 Meadow Ln, Gilbert, AZ, 852820.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56739TPAJacike McCoy1939-11-01———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-55982TPABeverly Elliott1993-12-28——4808 Lincoln Way, Minneapolis, MN, 554640.80Name re-casedCity re-casedGender normalisedWhitespace trimmed
TPA-54785TPAAlice Armstrong1984-04-18—34429207127640 Forest Ave, Columbus, OH, 432610.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51096TPADiana Bennett1964-09-14—64898802257866 Sunset Blvd, Minneapolis, MN, 554870.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61617TPAAaron Daavis1968-09-21—7727838164—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63695TPACarlos Pena2008-10-25——2038 Park Pl, Eden Prairie, MN, 553000.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53947TPASara Schmidt1983-10-15—25248647666820 Willow Ct # 596, Nashville, TN, 372750.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-55806TPAAustin Warren2000-12-22——917 Indian School Rd, Scottsdale, AZ, 852020.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-57944TPADot Andrews1946-10-15UHC-47197-7986255533068554 Hillcrest Rd, Denver, CO, 802270.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59383TPACamila Jackson1961-05-15UHC-96379-79——0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-54511TPADebbie Z Morrison1975-03-18——8651 Central Ave, Tempe, AZ, 852980.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61195TPAEvelyn Medina1964-03-05——9638 Baseline Rd, Orlando, FL, 328140.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-64215TPADiane Chavez1971-09-18——7566 Mountain View Dr, Jacksonville, FL, 322550.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61557TPAJessica Pierce1960-03-20——1226 Jefferson Ave, Los Angeles, CA, 900200.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50939TPAKimberly Morris1946-08-16———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-55905TPANoah Chapman1994-12-08UHC-64405-2290548733147353 Mountain View Dr, Dallas, TX, 752680.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50449TPAGloria Moore1955-06-15——3587 Spring St, San Diego, CA, 921360.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-55046TPATerry Arnold————0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
TPA-57959TPAJanet Dixon2002-09-08—3676740820—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52747TPAShirley U Sandoval1957-12-19—24735102072901 Jefferson Ave, Eden Prairie, MN, 553390.80Middle initial moved out of first nameName re-casedPhone reformattedPlaceholder values cleared
14,474 rows, page 168 of 290PreviousNext