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-56642TPADenise Richardson2002-10-07—59338115226090 Spring St, Chandler, AZ, 852530.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61346TPAJack Coleman1964-09-02—37793674668122 Main St, Phoenix, AZ, 850880.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52471TPAEdward Robertson1995-11-16—9648396355—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-61471TPAEthan Sanchez1971-12-04UHC-35179-03—1217 Oak St, San Antonio, TX, 782520.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-60486TPAMarcus Coleman1946-04-27—61951912169477 Highland Ave, Sacramento, CA, 958200.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61178TPAAna Warren1963-01-25———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-59421TPAYuki Contreras1997-03-01—44189739964549 Broadway, Phoenix, AZ, 850460.78Date of birth reformattedPhone reformattedAddress re-casedState name converted to code+1 more
TPA-54970TPALauren Y Cook1991-09-16—42077043015042 Highland Ave, San Antonio, TX, 782020.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52566TPAChristina Washington1957-03-02——6381 Palm Dr, Las Vegas, NV, 891260.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58956TPAMary M Garrett2007-12-22—39621122812645 Lake View Rd, Phoenix, AZ, 850180.78Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-51985TPASusan Rojas1992-10-15UHC-20787-07—8825 Sage Ct, Tampa, FL, 336140.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62027TPADorothy Howell1990-10-05UHC-62871-7431969102698359 Maple Ave, San Diego, CA, 921670.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61965TPATimothy Wang1948-06-10UHC-63226-4464288771829121 Willow Ct, Houston, TX, 770310.78Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+1 more
TPA-61081TPABruce Wong1945-02-10——5043 Apache Blvd, San Diego, CA, 921280.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53069TPADonna Padilla1951-10-28—73226273176322 Bayshore Dr, Sacramento, CA, 958750.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54841TPARobert Stevens1948-10-10——6132 Maple Ave, Columbus, OH0.78Name re-casedDate of birth reformattedCity re-casedZIP missing+1 more
TPA-60823TPADeborah Ferrnandez———5013 Broadway, Miami, FL, 331570.78Name re-casedDate of birth unreadableAddress re-casedWhitespace trimmed+1 more
TPA-57722TPAHeather Lawrence1986-03-19——9108 Forest Ave, Los Angeles, CA, 900920.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-59081TPAKaren Y Perez1955-07-03——2263 Palm Dr, Nashville, TN, 372500.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51568TPABrandon Lopez1955-02-03——4254 Desert Sky Blvd, Seattle, WA0.78Name re-casedCity re-casedZIP missingWhitespace trimmed+1 more
TPA-56729TPAAlbert Gray1946-07-15——3904 Valley View Dr, Dallas, TX, 752730.78Date of birth reformattedCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-62918TPAKen McDonald2002-12-23——1501 River Rd, Tampa, FL, 336100.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53756TPAArjun Smith1946-09-23——7371 Bayshore Dr, Minneapolis, MN, 554090.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53241TPALucia Payne1989-01-05——2663 Broadway, Plano, TX, 750750.78Date of birth reformattedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-57300TPALogan Bailey2001-10-07—21868128044259 Indian School Rd, Minneapolis, MN, 554130.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-57519TPALawrence Greene1988-01-10—2909195527—0.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-57172TPAChristine Dominguez1966-02-20—85443558607719 Market St, Las Vegas, NV, 891400.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60342TPAJoan Woods1963-12-01——9615 Central Ave, Dallas, TX, 752840.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55638TPACharlotte E Wasshington2007-01-27UHC-47321-13—7562 Union St, Seattle, WA, 981720.78Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51032TPABobby Park1979-02-20——3122 Park Pl, Nashville, TN, 372300.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59364TPAJacqueline Berry1949-03-17—48180949281043 Ocean Ave, Jacksonville, FL, 322010.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-53686TPAAhmed H Wagner1981-01-01—3142204944212 Bayshore Dr # 636, Seattle, WA, 981210.78Name re-casedDate of birth reformattedUnit split from streetWhitespace trimmed+1 more
TPA-54083TPARobert B Edwards2004-07-11——3734 Desert Sky Blvd, Austin, TX, 787320.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59291TPADenise Riley1990-08-11UHC-76596-67—4126 Bayshore Dr, Minneapolis, MN, 554350.78Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52243TPACarlo Fisher1991-11-18—83140676115545 Park Pl, Scottsdale, AZ, 852850.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51750TPADiego Washington1945-11-12——7030 Willow Ct, San Diego, CA, 921110.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56468TPABrenda Sullivan1992-01-01—98448029301728 Highland Ave, Orlando, FL, 328900.78Phone reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-50348TPANoah Montgomery1994-06-17—39830562186546 Elm St, Glendale, AZ, 853800.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56429TPAMason Weaver1946-08-27——248 Palm Dr, Fresno, CA, 937060.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56010TPAAnthony Palmer1953-06-21—6407435110867 Elm St, Fresno, CA, 937550.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54141TPACamila Nelson1997-01-14—61327719241110 Sunset Blvd, Fresno, CA, 937470.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52732TPABeverly Freeman1963-07-23——8881 Mountain View Dr, Tucson, AZ, 857740.78Date of birth reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-58876TPAFrank Lynch1946-11-05——3708 Apache Blvd, Scottsdale, AZ, 852150.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51312TPALwarence Lawson1947-11-27—55792133463465 Park Pl, Phoenix, AZ, 850110.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52963TPAGloria Nichols1998-05-17UHC-58730-814856129268328 Willow Ct, Dallas, TX, 752020.78Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+1 more
TPA-54993TPATheresa Ferguson1999-05-07UHC-58580-7662126426359633 Palm Dr, Tucson, AZ, 857120.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51970TPAHeather Griffin1987-08-11——8521 Palm Dr, Jacksonville, FL, 322780.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56172TPAKayla Watkins1977-02-06——5154 Harbor Blvd, Mesa, AZ, 852670.78Name re-casedCity re-casedGender normalisedPlan code upper-cased+1 more
TPA-57601TPAWillie C Elliott1943-01-20——9782 Ridge Rd, Tempe, AZ, 852890.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57136TPAChrristian Moreno1942-07-05UHC-86524-2350280617045524 Highland Ave, Phoenix, AZ, 850890.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 157 of 290PreviousNext