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-50212TPAFatima Kim1976-08-22——6634 Baseline Rd, Charlotte, NC, 282220.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54432TPASteven Ward1974-11-26——6742 Elm St, Las Vegas, NV, 891340.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-64390TPAMateo Black1994-09-12UHC-06260-45—1266 Jefferson Ave, Tucson, AZ, 857220.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54370TPANoah Reid1965-08-22——360 Sage Ct, Charlotte, NC, 282080.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-62096TPAMei Vasquez1958-03-22———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-57621TPAJames Soto2002-03-26—53023811977915 Meadow Ln, Atlanta, GA, 303420.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60407TPAVirginia Burton1994-09-10——210 River Rd, Dallas, TX0.80Name re-casedDate of birth reformattedZIP missingPlaceholder values cleared
TPA-57441TPAJacob Little1974-07-12—69869381376323 Canyon Rd, Atlanta, GA, 303820.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57296TPAShirley Rogers1971-12-14—23042692745718 Lake View Rd, Columbus, OH, 432030.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-60733TPAJoseph Johnston1950-10-17——1263 Central Ave, Scottsdale, AZ, 852730.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51460TPAGrace Bell1995-11-19——6185 River Rd, San Antonio, TX, 782560.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61555TPAGloria Salazar1943-01-13——944 Forest Ave, Orlando, FL, 328050.80Name re-casedStreet suffix standardisedAddress re-casedCity re-cased
TPA-57657TPAJerry Ramos1974-10-07—38940922735136 Elm St, Sacramento, CA, 958800.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-55789TPADiiana Jacobs1955-07-17—2874254739—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60638TPAWalter Nelson2000-07-28——4332 Oak St, Phoenix, AZ, 850100.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63496TPAAlbert Stephens1990-04-16———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57806TPAChristopher Johnson1938-01-19—95178427878530 Cedar Ln, Minneapolis, MN, 554120.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56219TPAChristian UJunk1942-03-18———0.80Date of birth reformattedWhitespace trimmedPlaceholder values clearedNo usable name (quarantined)
TPA-50983TPANoah Cox1963-08-03UHC-36111-12——0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57111TPALisa Mills1942-08-12UHC-79129-20—4582 Pine Dr, Las Vegas, NV, 891070.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-64445TPAJoan Wbeer1973-06-08UHC-20455-78—9509 Park Pl, San Diego, CA, 921530.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-55043TPATheresa Jimenez1971-10-04——3652 River Rd, Fresno, CA, 937770.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60491TPAJacob Turner1993-10-01——5366 Church St, Nashville, TN, 372340.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-60492TPAJacob Turner1993-10-01——5366 Church St, Nashville, TN, 372340.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-53970TPAAdam Mejia1987-08-25—75184555117973 Baseline Rd # 462, Scottsdale, AZ, 852980.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-51558TPADaniel Dean1950-10-04——3184 Spring St, Austin, TX, 787760.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61425TPAScott Ducan1970-06-06UHC-34340-60—71 Bayshore Dr, Los Angeles, CA, 900710.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58115TPAJack Williamson1973-01-11———0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-53672TPAGloria Ferguson1941-07-02UHC-59505-65——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54721TPALauren Perry1954-10-27—96643269691166 Camelback Rd, Eden Prairie, MN, 553000.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54038TPACynthia B Elliott2007-09-02——9248 Sage Ct, San Antonio, TX, 782000.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-59550TPAHelen Santiago1959-06-06——9467 Spring St, Houston, TX, 770850.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61409TPAAlexnder Palmer1984-03-01——8899 Apache Blvd, Dallas, TX, 752780.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62081TPAMary Carroll2002-08-18——2762 Maple Ave, Orlando, FL, 328860.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50098TPADeboarh Murry2003-04-24———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-59505TPATeresa Chavez1955-12-19UHC-86083-0589728579388567 Church St, Houston, TX, 770190.80Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased
TPA-56381TPAEugene Washington1980-11-20——9165 Lake View Rd, Houston, TX, 770990.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-55906TPAAbby O Walker1944-08-21——9062 Ridge Rd, Sacramento, CA, 958150.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-51141TPABilly King2001-11-28—72146036812775 Broadway, Columbus, OH, 432880.80Phone reformattedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-52144TPACatherine Fosteer1998-10-10——6272 River Rd, Miami, FL, 331150.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-57639TPALawrence Chapman1975-10-20——3172 Ocean Ave, Austin, TX, 787700.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60013TPACarlos Daniels1974-11-06——7882 Harbor Blvd, San Diego, CA, 921320.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53461TPAJose Perry1967-07-03—91569355617548 Mountain View Dr, Fresno, CA, 937490.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56388TPAJoan Torres1963-04-07——7239 Ridge Rd, Orlando, FL, 328940.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-62775TPASusan Z Barnes1999-01-17—28941371189887 Lincoln Way, Seattle, WA, 981490.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61690TPARoy Lawrence1993-06-09———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-64249TPAAmber Ruiz1947-11-07—82884188589109 Union St, Scottsdale, AZ, 852810.80Phone reformattedCity re-casedGender normalisedPlaceholder values cleared
TPA-56703TPAMartha P Ferguson1990-08-18——6568 Broadway, San Antonio, TX, 782880.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57984TPADenise Padilla1970-09-21——5052 Church St, Phoenix, AZ, 850800.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-55743TPAAnthony Lewis1952-08-09——7328 Union St, Houston, TX, 770580.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 174 of 290PreviousNext