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-63499TPAEric V Owens1963-08-24——1197 Willow Ct, Orlando, FL, 328720.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64240TPAJason Wells1979-06-12——7236 Valley View Dr, San Antonio, TX, 782960.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-61422TPAMatthew Bowman1992-11-25—30752314724383 Palm Dr, Miami, FL, 331430.78Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-51476TPABrian Allen1951-05-13—26223485599215 Lincoln Way, Austin, TX, 787360.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55843TPACarl Park1963-01-14——9297 Ocean Ave, Fresno, CA, 937410.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60303TPANicole Arnold1979-05-10—56233361843165 Mesa Dr, Chandler, AZ, 852310.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50670TPAWayne Mitchell1969-03-13——6633 Central Ave, Fresno, CA, 937890.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-54058TPARussell D Bryant1960-11-27——2305 Willow Ct, Chandler, AZ, 852020.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63618TPADavid N Phillips1938-01-10——7151 Spring St, Chandler, AZ, 852990.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59325TPABrenda Simmons1992-05-23——6890 Spring St, Sacramento, CA, 958820.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51235TPAKaren Bishop1983-05-01—86070643905869 Mountain View Dr, Atlanta, GA0.78Date of birth reformattedPhone reformattedCity re-casedZIP missing+1 more
TPA-54733TPATeresa Fisher1991-05-02——8299 Meadow Ln, Dallas, TX, 752510.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64147TPAWayne Li1960-01-10—61846141687279 Mountain View Dr Apt 10, Jacksonville, FL, 322650.78Name re-casedPhone reformattedUnit split from streetEmail lower-cased+1 more
TPA-52496TPALori Li1994-08-08—45746078254073 Camelback Rd, Tucson, AZ, 857840.78Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-61464TPAAhmed Grza1940-04-10UHC-76720-2964923160624490 Elm St, Scottsdale, AZ0.78Date of birth reformattedPhone reformattedZIP missingPlan code upper-cased+1 more
TPA-64176TPADiez Bernda1986-07-16—20187335626985 Broadway Apt 5, Denver, CO, 802440.78Name re-casedDate of birth reformattedUnit split from streetWhitespace trimmed+1 more
TPA-62143TPAKimberly Robertson1940-11-18——9549 Apache Blvd, Tempe, AZ, 852960.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61371TPAJames Parekr2002-05-11—22538833908408 Canyon Rd, Phoenix, AZ, 850400.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-53152TPAJanet Boyd1967-01-03—7848160075711 Desert Sky Blvd, Nashville, TN, 372710.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58757TPARonald Lucas2006-07-08——2996 Camelback Rd, Plano, TX, 750190.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-53727TPABrian D Jensen2001-09-21——3976 Canyon Rd, Charlotte, NC, 282760.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50167TPAChristopher Pierce1944-11-18——3313 Desert Sky Blvd, Minneapolis, MN, 554050.78Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-51386TPACarolyn King1997-06-22——6321 Highland Ave, Fresno, CA, 937680.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63316TPAJohn Mattthews1957-08-27UHC-47617-95——0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-53694TPAZachary Weber1945-01-21——1671 Elm St, Miami, FL, 331420.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57165TPAHiroshi Sanchez1999-06-15——5705 Union St, Sacramento, CA, 958090.78Date of birth reformattedCity re-casedState code upper-casedGender normalised+1 more
TPA-52977TPARobert Murphy1999-04-24——7979 Apache Blvd, Charlotte, NC, 282580.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50790TPAJoyce Carlson1956-07-15——2610 Baseline Rd, Glendale, AZ, 853270.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54294TPAOlivia Bradley1969-04-23——3185 Apache Blvd, Las Vegas, NV, 891160.78Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-58085TPADoris Peterson1989-06-09——5401 Desert Sky Blvd, Fresno, CA, 937530.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-50519TPADaniel Carroll1951-02-04—27954246725784 Highland Ave, Houston, TX, 770020.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53619TPAJerry Myers1953-12-14——7557 Union St, Nashville, TN, 372270.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61767TPAJulie Hart1940-08-25——3705 Harbor Blvd, Mesa, AZ, 852450.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52841TPABrian Guerrero2003-07-22UHC-77891-8977682482781517 Apache Blvd, Houston, TX, 770380.78Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-61250TPAStephen Cox1959-07-01——2758 Mountain View Dr, Gilbert, AZ, 852270.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63528TPAAlice Day2001-05-06—69697884546309 Union St, Dallas, TX, 752880.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62124TPAJessica Butler1982-07-23—72991245634446 Sage Ct, Houston, TX, 770410.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59159TPACarl Cole1950-02-14UHC-38847-192696234016—0.78Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more
TPA-59350TPAMaria P Lunna1998-08-15—4407334607801 Indian School Rd, Glendale, AZ, 853320.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-51679TPARaymond Ramos2003-12-14UHC-67665-2957494914122185 Church St, Minneapolis, MN, 554880.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60367TPADavid Brooks1939-05-06——5972 Jefferson Ave, Jacksonville, FL, 322620.78Name re-casedZIP+4 trimmedPlan code upper-casedWhitespace trimmed+1 more
TPA-52908TPABrenda P Bradley1954-10-17—61675243125192 Meadow Ln, Jacksonville, FL, 322420.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56570TPAGloria Nguyen1948-12-13—5784812748242 Desert Sky Blvd, Denver, CO, 802230.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62839TPAMorrison Russell1952-07-14——6556 Spring St, Houston, TX, 770890.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58963TPALauren Martin1970-10-25——7667 Willow Ct, Sacramento, CA, 958980.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-57540TPAOmar Gardner1953-09-05——2622 Sunset Blvd, Nashville, TN, 372710.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-57541TPAOmar Gardner1953-09-05——2622 Sunset Blvd, Nashville, TN, 372710.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-57028TPAJudith C Mills1943-05-28UHC-96992-51—7674 Pine Dr, Denver, CO, 802050.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-55324TPAWalter Alvarez1941-06-02——4448 Sage Ct, Houston, TX, 770310.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51204TPAPatrick Chapman1938-04-13UHC-67096-014178858332493 Camelback Rd, Dallas, TX, 752690.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 144 of 290PreviousNext