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-64029TPADiana Salazar2001-02-17——9622 Desert Sky Blvd, Sacramento, CA, 958840.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56863TPATheresa Young1940-01-10——97 Broadway, Sacramento, CA, 958430.78Name split from “Last, First”Date of birth reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-54167TPAMason M Kelley1942-11-17——7144 Bayshore Dr, Miami, FL, 331980.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-54002TPAJonathan Davis1970-02-15—39693680436574 Sage Ct, Gilbert, AZ, 852070.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58336TPAMariana Ferguson1992-09-24UHC-69580-2640950104913155 Pine Dr, Jacksonville, FL, 322950.78Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-63407TPAKeith Kennedy2007-04-08——8920 Palm Dr, Houston, TX, 770030.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54531TPAEdward O Peterson1969-01-12UHC-42460-1297527017164454 Harbor Blvd, Houston, TX, 770720.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-60977TPANatalie Hayes1954-11-18—92182859035420 Ridge Rd, Plano, TX, 750320.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-61656TPAJudith T Robinson2005-10-03——9430 Baseline Rd, Fresno, CA, 937420.78Name re-casedStreet suffix standardisedAddress re-casedPlan code upper-cased+1 more
TPA-54118TPABrian Hawkins1990-02-01——9646 Spring St, Nashville, TN, 372750.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56456TPAWilliam Powell1973-01-13—45547921341719 Ridge Rd, Eden Prairie, MN, 553370.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-54979TPABrittany M Wilson1979-01-02——891 Union St, San Diego, CA, 921320.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-52769TPALarry K Hall1976-01-12——2039 Maple Ave, Tucson, AZ, 857390.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-54768TPARyan Knyght1952-11-19—94777388318974 Willow Ct, Houston, TX, 770500.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-63453TPAStepheen Herrera1950-05-18——1373 Park Pl, Minneapolis, MN, 554490.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50573TPAAdam Sanders1998-12-16——8671 Valley View Dr, Fresno, CA, 937130.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55651TPARyan Grant1989-09-27UHC-15044-36—6174 Valley View Dr, Tucson, AZ, 857080.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63663TPAJean Scott2008-07-28———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-63662TPAJean Scott2008-07-28———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-62785TPAVictoria Castro2006-07-13—36756602902915 Central Ave, Tucson, AZ, 857970.78Name re-casedPhone reformattedCity re-casedState name converted to code+1 more
TPA-56933TPAJeremy Duncan1969-05-17——6026 Main St, Fresno, CA, 937310.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-60982TPAJack Padilla1944-09-12——2861 Mountain View Dr, San Antonio, TX, 782680.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51102TPALawrence Long1978-02-09UHC-47581-55—2494 Palm Dr, Denver, CO, 802530.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54329TPALarry Alvarado1978-05-04—71877671503582 Church St, Glendale, AZ, 853610.78Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-51508TPARaymond Riley1973-12-25—8128431450375 Market St, Scottsdale, AZ, 852690.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63782TPAJean Nunez2008-01-15—61764078231238 Central Ave, Nashville, TN, 372940.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53881TPACaroln Clark2000-02-04UHC-25927-01—7512 Meadow Ln, Tampa, FL, 336290.78Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50943TPARussell O Wood1958-08-17——667 Lake View Rd, Phoenix, AZ, 850430.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-55104TPAGabriel Nguyen1949-04-25UHC-08946-13—5009 Jefferson Ave, Chandler, AZ, 852120.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-50458TPAJacob Hart1990-11-02——7461 Market St, Tampa, FL, 336250.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51290TPAArjun Turner1984-09-08—76967179818735 Valley View Dr, Phoenix, AZ, 850670.78Name split from “Last, First”Phone reformattedCity re-casedState code upper-cased+1 more
TPA-53477TPAMaria Arnold1986-03-13—74787053053117 Valley View Dr, Mesa, AZ, 852290.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63178TPANoah Tucker1993-06-02——2659 Park Pl, Columbus, OH, 432190.78Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-54284TPALucia Santos2005-05-25—87689608971203 Baseline Rd, Tempe, AZ, 852110.78Name re-casedPhone reformattedSSN last four extractedWhitespace trimmed+1 more
TPA-52559TPAMatthew Ryan1972-02-10UHC-87039-03—2434 Willow Ct, Eden Prairie, MN, 553860.78Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58934TPANathan A Bell1942-12-03—26030643471240 Park Pl, Miami, FL, 331700.78Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-51633TPALawrence Reyes1964-06-27——9251 Hillcrest Rd, Las Vegas, NV, 891730.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64064TPAJeremy Duncan1977-04-20——3976 Mountain View Dr, Fresno, CA, 937090.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56142TPASean Tucker1984-10-08—43296172084906 Sage Ct, Gilbert, AZ, 852630.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51611TPAMichael Fields1967-07-20—8716336458—0.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-57855TPAJustni L Gordon1958-09-10—34378284648913 Mountain View Dr, Phoenix, AZ, 850690.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61395TPAJsse Fields1948-08-24——2531 Mountain View Dr, Denver, CO, 802550.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54484TPAMtaeo Harris————0.78Name re-casedDate of birth reformattedDate of birth unreadableWhitespace trimmed+1 more
TPA-56169TPAGregory Hernandez1963-06-25——1634 Park Pl, Los Angeles, CA, 900080.78Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-53624TPAJordan Richards1950-09-09——8419 Washington St, Sacramento, CA, 958470.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63519TPAHelen Ryan1998-10-21—63058300913533 Pine Dr, Atlanta, GA, 303660.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63520TPAHelen Ryan1998-10-21—63058300913533 Pine Dr, Atlanta, GA, 303660.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50000TPABilly Woods1966-12-16——9218 Palm Dr, Los Angeles, CA, 900650.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51445TPABruce Schultz1994-08-09——7122 Indian School Rd, San Diego, CA, 921130.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-51505TPADennis T Weber1990-02-17—27129356964987 Camelback Rd, Houston, TX0.78Name re-casedPhone reformattedZIP missingEmail lower-cased+1 more
14,474 rows, page 130 of 290PreviousNext