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-58834TPADoris Foster1950-02-27——5527 Pine Dr, Las Vegas, NV, 891540.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54218TPALawrence Banks1978-09-08—53542290688422 Jefferson Ave, Columbus, OH0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-57261TPAWayne Rojas1963-03-11—31462444706144 Spring St, Atlanta, GA, 303610.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63696TPAAmanda Andrews—UHC-57948-95—7758 Central Ave, Chandler, AZ, 852750.80Date of birth unreadableCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-52616TPADorothy Wagner1953-08-05——4345 Market St, Columbus, OH, 432070.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53197TPASamuel Rojas1980-08-07—92488344094200 Central Ave, Tampa, FL, 336980.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59313TPAAmy Romero1975-11-21UHC-51754-584474549405—0.80Phone reformattedEmail lower-casedGender normalisedPlaceholder values cleared
TPA-50906TPARuth Mendez2007-11-17——7365 Spring St, San Antonio, TX, 782770.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63702TPACamila Schmidt1963-11-21—76454232837202 Market St, Las Vegas, NV, 891150.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50507TPASara Guzman1958-06-21——3218 Hillcrest Rd, Eden Prairie, MN, 553540.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-53634TPAVictoira Y James1946-03-05——4992 Hillcrest Rd, Denver, CO, 802190.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50745TPAPriya Fuller1954-10-08——3466 Bayshore Dr, Eden Prairie, MN, 553840.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51213TPABruce Ryan1978-05-26—76380377257237 Mountain View Dr, Chandler, AZ, 852260.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61360TPASharon Stevens1948-08-04UHC-69450-6268284598455794 Jefferson Ave Apt 3, Los Angeles, CA, 900840.80Phone reformattedUnit split from streetState code upper-casedPlaceholder values cleared
TPA-50585TPACatherine X Ellis1939-12-19———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51482TPABrian Flores1958-06-18——9152 Lincoln Way, Las Vegas, NV, 891620.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62741TPAAustin G Gordon1963-02-27UHC-97336-32—1575 Desert Sky Blvd, Dallas, TX, 752510.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61306TPAEdward Alvarado1960-06-18UHC-97144-40—6451 Sage Ct, San Antonio, TX, 782440.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-54115TPAMargaret Stone1979-11-12—5038517790—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58901TPADiego Lawrence2005-03-13UHC-68548-08—1001 Hillcrest Rd, Tempe, AZ, 852030.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-55548TPARoy Hart1938-02-10——241 Forest Ave # 287, San Antonio, TX, 782020.80Unit split from streetCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-54839TPABarbara R Espinoza2001-10-25——4396 Valley View Dr, Tempe, AZ, 852240.80City re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-54498TPADonald Bennett1977-02-28UHC-07240-34—2493 Elm St, Fresno, CA, 937020.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61121TPAJeryr Hamilton1954-08-31—2096707176—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55595TPAJudy E Jackson1966-08-27——1493 Lincoln Way, Nashville, TN, 372560.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-50604TPAAlexander Lee1971-04-24—60835424711021 Desert Sky Blvd, Austin, TX, 787060.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50354TPAStehpen V Spencer1972-06-27——334 Spring St, Austin, TX, 787850.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55862TPAJerry Le1965-05-13—9118037455—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55935TPAEdward Diaz1968-07-16—3487057870—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61847TPAJoe Bishop1967-10-04——3979 Elm St, Gilbert, AZ, 852640.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63690TPAKaren Thomas2005-11-05——6718 Mesa Dr, Houston, TX, 770820.80Date of birth reformattedCity re-casedGender normalisedPlaceholder values cleared
TPA-59972TPAPaul Hoffman1939-12-10——8814 Apache Blvd, Nashville, TN, 372080.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52375TPARandy Hill1982-10-03—3512855122234 Canyon Rd, Fresno, CA0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-57075TPAJonathan Burke1984-10-02——4277 Washington St, Denver, CO, 802090.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52253TPAMartha Jones———4291 Market St, San Diego, CA, 921870.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-63484TPAJustin Fowler1981-12-21———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55771TPASara Espinoza1997-01-27——5773 Central Ave, Los Angeles, CA, 900720.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56985TPAPriya Morales1938-05-26——7223 Sunset Blvd, Chandler, AZ, 852330.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-54900TPAVirginia Hudson1954-05-12——4992 Washington St, Dallas, TX, 752260.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50618TPAMaria Singh1983-05-20——8998 Jefferson Ave, Las Vegas, NV, 891950.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55207TPAZachary Holmes1960-05-10—69853790945767 Broadway, Sacramento, CA, 958560.80Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed
TPA-52119TPAOlivia Shaw2002-09-01——8294 Sage Ct, Phoenix, AZ, 850730.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56032TPASara Franklin1955-09-04——3518 Central Ave, Las Vegas, NV, 891410.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59161TPAChristian Elliott1972-07-07——3066 Apache Blvd, Tucson, AZ, 857240.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50433TPAAmy I Torres1959-05-04——5688 Cedar Ln, Austin, TX, 787830.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55915TPASteve Dixon1996-11-03——8339 Meadow Ln, Dallas, TX, 752220.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55914TPASteve Dixon1996-11-03——8339 Meadow Ln, Dallas, TX, 752220.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62468TPAJesse Y Baker1985-01-05—31993291326412 Lincoln Way, Houston, TX0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-58536TPAPatrick Valdez2004-08-20—59632464164711 Pine Dr, Columbus, OH, 432100.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-55315TPAHnnah Sims1985-11-24——9768 Sunset Blvd, Dallas, TX, 752560.80Name re-casedDate of birth reformattedState name converted to codePlaceholder values cleared
14,474 rows, page 169 of 290PreviousNext