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-60442TPAJacqueline Daniels2000-10-28——5622 Valley View Dr, Miami, FL0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-50069TPARuth Ferguson1945-10-09——9177 Jefferson Ave, Mesa, AZ0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
TPA-52511TPAEugene Contreras1987-08-05UHC-38123-34—2194 Valley View Dr, Gilbert, AZ, 852220.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-50598TPAAndrea McDonald1960-02-20——8541 Camelback Rd, Tempe, AZ, 852380.54Two-digit birth yearState name converted to codeEmail lower-casedGender normalised+1 more
TPA-63485TPAWei Jordan1988-12-16——5392 Union St, Nashville, TN, 372400.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
TPA-64449TPAJesse Hunter1943-06-08——1690 Willow Ct, Phoenix, AZ, 850350.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-54713TPAAnna Scott1966-07-27UHC-14025-28—2964 Central Ave, Columbus, OH, 432930.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-56746TPAGeorge Dominguez2001-04-12——974 Sage Ct, Seattle, WA, 981940.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-50644TPARobert Alexander1959-03-08——814 Camelback Rd, Orlando, FL, 328660.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
TPA-50645TPARobert Alexander1959-03-08——814 Camelback Rd, Orlando, FL, 328660.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
TPA-57227TPAGregory Campbell2003-06-18—68787804186371 Mountain View Dr, Austin, TX, 787910.54Two-digit birth yearState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
TPA-63317TPAJohn Matthhews1957-08-27——5065 Indian School Rd Apt 25, Plano, TX, 750290.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-56733TPARaymond Hansen1966-09-17——4381 Palm Dr, San Diego, CA0.54State name converted to codeZIP missingGender normalisedWhitespace trimmed+1 more
TPA-57659TPARuth Meyer1986-12-01—83858549632426 Forest Ave, Charlotte, NC0.54Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
TPA-56044TPAAizha Bradley1973-12-24——6799 Spring St, Fresno, CA, 937500.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-59688TPAAlexander Turner1965-08-27——429 Pine Dr # 222, Sacramento, CA, 958970.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-58668TPADanielle X Cox1943-04-12——5635 Spring St, Sacramento, CA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-58667TPADanielle X Cox1943-04-12——5635 Spring St, Sacramento, CA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-50817TPALucia Z Campbell1947-06-23——3984 Broadway, Glendale, AZ, 853820.54Name split from “Last, First”SSN last four extractedGender normalisedWhitespace trimmed+1 more
TPA-64440TPAOmar Hoffman1946-01-16——5459 Ridge Rd, Sacramento, CA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
TPA-50814TPAGary Walker1999-02-04—78530452096703 Cedar Ln Apt 19, San Diego, CA, 921890.54Phone reformattedUnit split from streetState name converted to codeGender normalised+1 more
TPA-54112TPABryan Owens1952-11-02——9413 Ocean Ave, Minneapolis, MN, 554850.54Name split from “Last, First”Two-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
TPA-54153TPADaniel Lynch2001-05-17——2820 Valley View Dr, Mesa, AZ, 852240.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
TPA-55546TPAChristopher Chavez1944-04-25——5415 Forest Ave, Los Angeles, CA, 900430.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-52255TPAElijah X Flores1966-09-10——7879 Market St, Los Angeles, CA, 900400.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-61591TPAThomas Andrson1943-05-21—65149955721774 Willow Ct, Seattle, WA, 981100.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-57290TPADebra Wagner1967-06-21——4557 Canyon Rd, San Antonio, TX, 782400.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
TPA-60251TPANathan Turner1987-05-06——528 Market St, Gilbert, AZ, 852750.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-59492TPADiana Webb1967-05-27——5776 Oak St, Scottsdale, AZ0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-59744TPARaymond Robinson1942-04-12UHC-17881-72—1979 Union St, Atlanta, GA0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
TPA-64256TPAAustin Morgan2003-05-17——6020 Sunset Blvd, Dallas, TX, 752250.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-53485TPAMichelle Lee1952-02-03——88 Highland Ave, Charlotte, NC, 282110.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-64238TPALarry Webb2004-10-23——6503 Church St, Orlando, FL0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-54887TPAJustin Mason2002-01-09—76042262728634 Sunset Blvd, Dallas, TX0.54Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+1 more
TPA-54886TPAJustin Mason2002-01-09—76042262728634 Sunset Blvd, Dallas, TX0.54Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+1 more
TPA-50067TPAEvelyn Singh1976-01-08——9466 Union St, Minneapolis, MN, 554770.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-54273TPAHiroshi Rice———5783 Oak St, Jacksonville, FL, 322710.54Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-56708TPAAnn Gonzalez1960-10-27UHC-34996-4927883622924617 Grand Ave, Sacramento, CA, 958550.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
TPA-54640TPASara Ortiz1979-04-07—30524940466585 Lake View Rd, Minneapolis, MN, 554110.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
TPA-50529TPADanielle Young1954-06-21—67338143393852 Market St, Scottsdale, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
TPA-63756TPANathan Thompson1947-04-04——8222 Jefferson Ave, Denver, CO0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
TPA-63133TPATimothy Simmons———4725 Ocean Ave # 843, Orlando, FL, 328720.54Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-54529TPAElizabeth Morrison1967-12-24——7434 Sunset Blvd, Fresno, CA, 937230.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
TPA-53387TPANatalie N Wagner1965-07-26—79037885189743 Sunset Blvd, Orlando, FL, 328180.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
TPA-63581TPAJesse Bryant1948-07-25——9551 Sunset Blvd, Los Angeles, CA, 900890.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-53326TPAJoe Turner1997-09-21——3679 Lincoln Way, Denver, CO0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
TPA-51202TPALuis W Wallace———6713 Main St, Columbus, OH, 432320.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60277TPAGerald Ruiz1989-02-10—23464812638019 Canyon Rd, Columbus, OH, 432510.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-52918TPABill Howard———9694 Bayshore Dr, Nashville, TN0.54Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-63443TPABrittany Ferguson1944-05-18UHC-92938-61—6556 Ocean Ave # 772, San Diego, CA, 921270.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
14,474 rows, page 28 of 290PreviousNext