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-57594TPAMason Armstrong1938-08-21——3613 Highland Ave Apt 37, Columbus, OH, 432500.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-64297TPAJeremy Murphy1938-01-10—6127206749—0.80Name re-casedPhone reformattedSSN last four extractedPlaceholder values cleared
TPA-54630TPAMarilyn I Patterson1997-01-05——9305 Meadow Ln, Orlando, FL, 328880.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62331TPAMarcus Montgomery1966-02-07——1942 Meadow Ln, Chandler, AZ, 852030.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52360TPASofia G Brown2003-06-02—26240866018770 Lake View Rd, Scottsdale, AZ, 852470.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-59803TPAEdward Reed1957-05-20——1422 Lincoln Way, San Antonio, TX, 782070.80Date of birth reformattedPhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-61058TPAAshley Oliver1973-04-06——229 Bayshore Dr, Gilbert, AZ, 852010.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57367TPASandra Vega1949-12-23——2681 Lake View Rd, Glendale, AZ, 853700.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60828TPAVargas Keith1955-03-05——720 Meadow Ln, Seattle, WA, 981110.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-62707TPABobby Ward1955-10-01——5410 Ocean Ave, Nashville, TN, 372550.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-53707TPABobby Jacobs1942-09-25—29494386311545 Jefferson Ave, San Antonio, TX, 782850.82Name re-casedPhone reformattedState name converted to code
TPA-55928TPAMelissa Palmer1959-06-18—72669025876404 Lincoln Way, Nashville, TN, 372050.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-51853TPASantiago Hrrera1964-05-20——9406 Washington St # 370, Mesa, AZ, 852670.82Unit split from streetCity re-casedPlaceholder values cleared
TPA-55721TPAAngela Watkins1997-08-02——2215 Canyon Rd, Tampa, FL, 336130.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60800TPANicholas Burns1982-06-07——2447 Grand Ave, Eden Prairie, MN, 553680.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-56323TPAChristopher Maldonado2000-04-22——6080 Ridge Rd, Las Vegas, NV, 891100.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-63804TPAMartha Rice1956-08-23——6052 Desert Sky Blvd, Tampa, FL0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-63805TPAMartha Rice1956-08-23——6052 Desert Sky Blvd, Tampa, FL0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-57705TPAChristopher Ellis1986-04-05UHC-61611-07—3925 Broadway, San Diego, CA, 921780.82Name re-casedGender normalisedPlaceholder values cleared
TPA-57704TPAChristopher Ellis1986-04-05UHC-61611-07—3925 Broadway, San Diego, CA, 921780.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-58194TPAGeorge Z Li1955-11-01———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-64074TPAMariana M Little———4453 Market St, Chandler, AZ, 852860.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-63266TPAMartha Powell2008-12-24——6225 Church St, Nashville, TN, 372140.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52003TPAJessica Kim1992-02-14——4433 Camelback Rd, Sacramento, CA0.82Name re-casedZIP missingPlaceholder values cleared
TPA-50426TPALisa K Campbell1982-04-21——4118 Highland Ave, Nashville, TN, 372890.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63879TPAKathryn Dominnguez1939-12-18——6195 Apache Blvd, Sacramento, CA, 958540.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59882TPAGrace Carter——25227855721028 Church St, Denver, CO, 802360.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-51577TPANicole Wood2002-05-07———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-52830TPABrian Flores2001-06-10——438 Baseline Rd, Tucson, AZ0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-64170TPABrenda Black1961-12-20—97993414765314 Church St, Tempe, AZ, 852660.82Phone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-53920TPAPatrick Lewis1979-06-05—61842346634359 Forest Ave, Nashville, TN, 372770.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-55059TPAValentina Marquez1979-09-06——6197 Highland Ave, Nashville, TN, 372280.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63298TPAMegn Hawkins1951-05-16——667 River Rd, Sacramento, CA, 958120.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-54108TPADouglas Robisnon1974-11-27——9031 Apache Blvd, Nashville, TN, 372420.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54812TPAJim Watkins1957-08-25UHC-77031-08—3160 Union St, Austin, TX, 787160.82Name re-casedState name converted to codePlaceholder values cleared
TPA-50286TPABrian W Hughes1973-09-07UHC-74866-18—2261 Mesa Dr, Dallas, TX, 752870.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-52339TPADick Jimenez1941-09-12——792 Desert Sky Blvd, Sacramento, CA, 958590.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63749TPAJoe Vargas————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-61875TPAPhilip Johnston1966-07-26——9556 River Rd, Tucson, AZ, 857890.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50500TPAOmar Burton1964-04-13UHC-87703-12—8162 Apache Blvd, Chandler, AZ, 852040.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62783TPAWillie Bryant1993-06-21——4783 Central Ave, San Diego, CA0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-52645TPAZachary Harris1972-03-02——6872 Sage Ct, Miami, FL, 331030.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-50337TPAKathryn King1996-11-05—5949485491862 Camelback Rd, San Diego, CA, 921710.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-51113TPAEmma A Perez1997-09-25———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-53475TPAJennifer Moore1994-12-06——3483 Church St, San Diego, CA, 921520.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55301TPATimothy Young1949-07-22—80067147482331 Jefferson Ave # 257, Tampa, FL, 336560.82Phone reformattedUnit split from streetPlaceholder values cleared
TPA-58863TPAZachary T Marshall2001-11-21——7657 Lake View Rd, Atlanta, GA, 303400.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50731TPAAbby Coleman1951-01-12—61779743256206 Ridge Rd, Denver, CO0.82Date of birth reformattedZIP missingWhitespace trimmed
TPA-51275TPAMaria Snyder1940-07-24——6204 Ocean Ave, Plano, TX, 750300.82Name re-casedGender normalisedPlaceholder values cleared
TPA-58608TPAJack Vazquez2006-09-18—72374372297549 Broadway, San Antonio, TX0.82Phone reformattedZIP missingWhitespace trimmed
14,474 rows, page 196 of 290PreviousNext