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

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-58801TPAGregory Wagner1968-04-22——3175 Mesa Dr, Scottsdale, AZ, 852280.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53368TPAChristine Carpenter1987-07-20——3743 Harbor Blvd, Charlotte, NC, 282410.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
TPA-62811TPAHarold Hall1978-02-20——4518 Union St, Dallas, TX, 752980.66Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-57712TPAJoseph Welch1999-12-19——4470 Apache Blvd, San Antonio, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-53211TPASara Mitchell2007-05-01——9648 Oak St, Tampa, FL, 336360.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-56263TPAGregory F Jimenez1938-02-23——8862 Sunset Blvd, Plano, TX, 750040.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58930TPASandra Kelley1960-02-27—36833864026943 Lincoln Way, Tucson, AZ, 857050.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-63249TPARalph Porter1943-05-08—83186319852418 Valley View Dr, Nashville, TN, 372620.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-53388TPAAlice EJunk1950-07-12—87354220596473 Central Ave, Los Angeles, CA, 900440.66Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared+1 more
TPA-57117TPASteven Young1950-05-13——6301 Ocean Ave, Las Vegas, NV, 891020.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-58835TPAMark Leewis1995-06-14UHC-34718-55—1859 Indian School Rd, Austin, TX, 787660.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-60742TPANick Keley1975-12-01——6841 Main St # 458, Atlanta, GA, 303410.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52336TPAGeorge Sims1997-01-02—9832619092461 Jefferson Ave, Plano, TX, 750940.66Name re-casedCity re-casedState name converted to codeZIP+4 trimmed+1 more
TPA-56505TPABenjamin Thompson1992-01-19—70599326246338 Broadway, Los Angeles, CA0.66Address re-casedState name converted to codeZIP missingWhitespace trimmed+1 more
TPA-60837TPADiana Castro1977-10-11——2172 Ocean Ave, Orlando, FL, 328380.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-62373TPAHannah Santos1941-06-09——2094 Sunset Blvd, San Antonio, TX, 782710.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-53261TPAGloria Fowler1964-09-07——6908 Sage Ct, Tucson, AZ, 857530.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-55154TPALinda Woods1985-02-22UHC-71404-9042222397852889 Palm Dr, Austin, TX, 787360.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55574TPAOlivia Dominguez1977-08-09——7574 Bayshore Dr, Scottsdale, AZ0.66Street suffix standardisedAddress re-casedState code upper-casedZIP missing+1 more
TPA-55023TPAMadison Moreno1946-08-02——4686 Ocean Ave, Eden Prairie, MN, 553260.66Two-digit birth yearCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-62716TPAJacob Grant1969-10-22——3053 Harbor Blvd, Tucson, AZ, 857240.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-59573TPAKathleen Tran1975-04-20——4373 Central Ave, Miami, FL, 331660.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60535TPAAaron Hill——92047612836660 Willow Ct, Nashville, TN, 372560.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50634TPACastro Albert1982-05-10——3576 Desert Sky Blvd, Sacramento, CA0.66Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+1 more
TPA-60729TPAHenry Riz1992-02-13——86 Bayshore Dr, San Antonio, TX, 782960.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-54847TPALuis Garcia1978-11-12——8262 Main St, Scottsdale, AZ, 852960.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63248TPAMadison Payne1995-11-13——1413 Central Ave, Nashville, TN, 372600.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62900TPALinda V Carter2002-07-16——1257 Jefferson Ave, Gilbert, AZ, 852940.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60411TPAEugene Morales1976-03-11—55599341767390 Bayshore Dr, Austin, TX, 787660.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-57738TPAJohn Romero1990-02-19——5768 Lincoln Way, Phoenix, AZ0.66Date of birth reformattedCity re-casedZIP missingGender normalised+1 more
TPA-58518TPAKayla Grent1939-01-16—31664474063675 Market St, Glendale, AZ, 853270.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-50899TPADaniel Lawrence1978-07-10—87266984998162 Spring St, Plano, TX, 750040.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55417TPAMattehw Holmes2006-09-25——7504 Meadow Ln, Charlotte, NC, 282800.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-62397TPAChristian D King1952-07-18——5526 Sunset Blvd, Tempe, AZ, 852150.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-58245TPALawrence Cruz1994-02-12——8376 Church St Apt 38, Orlando, FL, 328660.66Two-digit birth yearUnit split from streetEmail lower-casedWhitespace trimmed+1 more
TPA-51219TPAPamela Fields1988-04-12—60559713839331 Spring St, Charlotte, NC, 282370.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61284TPADouglas Edwards1962-05-28——3224 Desert Sky Blvd # 150, Sacramento, CA, 958300.66Name split from “Last, First”Unit split from streetCity re-casedState code upper-cased+1 more
TPA-56495TPAMary B Young1996-07-16——9853 Sage Ct, Mesa, AZ, 852600.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-64405TPABrian Hughes1940-08-27——6137 Valley View Dr, Charlotte, NC0.66Name split from “Last, First”City re-casedZIP missingWhitespace trimmed+1 more
TPA-62666TPARichard Riley1961-07-11——3721 Mesa Dr, Tucson, AZ, 857280.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-51187TPALucia Bryant1975-06-09——7161 Canyon Rd, Houston, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-53439TPAEmily Armstrong1959-12-08——4902 Palm Dr, Chandler, AZ, 852890.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63743TPAAlexis Murray1990-12-15——5747 Camelback Rd, San Diego, CA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-59152TPAAlexander Derba1976-05-03——4973 Palm Dr, Chandler, AZ, 852620.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53654TPAThomas Richardson1996-01-21——8105 Bayshore Dr, Tucson, AZ, 857750.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-64434TPAHarold P Martinez1974-02-21——8897 Broadway # 479, Gilbert, AZ, 852370.66Name re-casedUnit split from streetCity re-casedGender normalised+1 more
TPA-62098TPADnona Reynolds1941-10-22UHC-84859-7496343130996169 Elm St, Chandler, AZ, 852510.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58453TPAAustin Murray—UHC-61729-64—6579 Washington St, Austin, TX, 787600.66Name re-casedDate of birth unreadableGender normalisedWhitespace trimmed+1 more
TPA-62482TPAGerald Parker1970-07-24——7751 Mesa Dr, Chandler, AZ, 852280.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-51423TPAOmar Rios1987-10-15UHC-69358-19—5383 Union St, Plano, TX, 750430.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
14,474 rows, page 73 of 290PreviousNext