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-54403TPAMichelle Owens2006-04-18——3887 Church St, Atlanta, GA, 303890.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-51098TPAWod Carl1976-03-07——7718 Willow Ct, Dallas, TX, 752920.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58933TPASandra Mejia1979-07-28—92644098755213 Valley View Dr, Scottsdale, AZ0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-62959TPABetty Wright1996-05-07——6345 Desert Sky Blvd, Miami, FL, 331020.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63034TPALucia Le1959-09-08UHC-53838-39—7725 Pine Dr, Las Vegas, NV, 891680.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53043TPAKelly Griffin1952-07-16—49393979367750 Canyon Rd, Mesa, AZ, 852310.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55367TPASean L Fuller1986-08-24——1395 Grand Ave, Chandler, AZ, 852010.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-64150TPAJak Yang1992-01-27——1847 Central Ave, Gilbert, AZ, 852090.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53580TPAChristian N Taylor1940-05-07——5386 Valley View Dr, Dallas, TX, 752640.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52385TPAMaria Ramirez1999-04-23—45192460381102 Market St, Los Angeles, CA, 900370.80Date of birth reformattedPhone reformattedState name converted to codePlaceholder values cleared
TPA-58728TPAJustin Elliott2007-08-16——797 Mountain View Dr, Phoenix, AZ, 850430.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58738TPAAaron Ortiz1971-12-01UHC-59807-57—3890 Baseline Rd, Tempe, AZ, 852380.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51404TPAZachary Reynolds2006-09-10—90776722861038 Main St, Plano, TX, 750370.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64369TPAWillie Reyes1967-07-18——9120 Mountain View Dr, Nashville, TN, 372250.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-64373TPAJose Z Walker1967-09-02—92646529313288 Apache Blvd, Dallas, TX, 752870.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50027TPAPatricia Anderson1974-04-15——1229 Desert Sky Blvd, Charlotte, NC, 282350.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56315TPAMarilyn Hicks1943-02-26——4833 Mountain View Dr, Austin, TX, 787990.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
TPA-53217TPAJason Fowler1940-08-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60460TPASandra Vasquez1938-09-12——5203 Church St, Dallas, TX, 752830.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60466TPASamantha Reid1977-02-22——5376 Canyon Rd, Los Angeles, CA, 900920.80Name re-casedTwo-digit birth yearCity re-casedPlaceholder values cleared
TPA-55194TPAMary Guerrero1980-09-18——6697 Valley View Dr, Tucson, AZ, 857890.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61966TPAJoshua Herrera1954-10-01—72360779928343 Washington St, Columbus, OH, 432490.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-53060TPAAustin Flores1945-03-14———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56228TPAJonathan Peterson1939-09-22——3469 Spring St, Plano, TX, 750190.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57904TPAAmanda Fisher1970-08-21——5090 Willow Ct, Phoenix, AZ, 850070.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62405TPAKayla Jensen1992-05-06——3522 Park Pl, Phoenix, AZ, 850450.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60703TPADeborah E Vargas1944-06-26——4953 Apache Blvd, Minneapolis, MN, 554730.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-58075TPABrandon Jenkins1992-09-25——617 Indian School Rd, Tucson, AZ, 857530.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60168TPADouglas Wallace2001-08-24——6536 Lake View Rd, Glendale, AZ, 853790.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54266TPAGabriel Chen1997-06-05UHC-42326-53—3512 Washington St, Fresno, CA, 937360.80Two-digit birth yearMember ID reformattedCity re-casedPlaceholder values cleared
TPA-52304TPARandy Nichols2004-09-25——3698 Forest Ave, Scottsdale, AZ, 852430.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-52925TPACynthia Owens1961-04-27——9409 Main St, Phoenix, AZ, 850510.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-57087TPATommy Harvey1977-10-25——6330 Cedar Ln, Plano, TX, 750960.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51939TPARussell Davis1962-06-08——1029 Spring St, Columbus, OH, 432020.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63644TPANicholas Morales1978-01-24——7526 Broadway, Fresno, CA, 937100.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-58468TPANathan Harrison1967-09-23—5368123885452 Highland Ave, Chandler, AZ, 852310.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-57119TPAGlooria Harper1943-06-01UHC-02195-3939837491845253 River Rd, Plano, TX, 750890.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55973TPASteve Hansen1985-08-18—51944571553118 Sunset Blvd, Nashville, TN, 372560.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
TPA-57909TPASarah Wilson1976-07-19UHC-82292-39—5348 Park Pl, Mesa, AZ, 852920.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57910TPASarah Wilson1976-07-19UHC-82292-39—5348 Park Pl, Mesa, AZ, 852920.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64157TPAEmily Shaw1992-02-13——1137 Washington St, Gilbert, AZ, 852580.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61817TPABradley Bishop2002-09-22UHC-02311-67—3761 Oak St, Chandler, AZ, 852210.80City re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56978TPAOlivia D Hunter1948-05-23—2374301747785 Cedar Ln, Seattle, WA, 981660.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58509TPACamila Peterson1947-10-05——8381 River Rd, Phoenix, AZ, 850300.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54359TPAHenry Espinoza1959-07-26UHC-08632-94—1745 Church St, Austin, TX, 787950.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56285TPAGabriel Q Shaw1941-11-06——3336 Willow Ct, Nashville, TN, 372100.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-54586TPAElizabeth X Black1964-02-19———0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-63770TPATim Bishop1978-10-26—76250345552293 Washington St, Jacksonville, FL, 322520.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52824TPAPhilip Bradley1945-06-28——2457 Hillcrest Rd, Minneapolis, MN, 554480.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-52071TPAAnna I Mason1972-01-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 166 of 290PreviousNext