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-58344TPALuis Smith1986-03-25—29577450101207 Camelback Rd, Columbus, OH, 432680.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61062TPAAndrea I Payne2008-12-09——185 Ocean Ave, Los Angeles, CA, 900490.78Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-61429TPAMaria Gardner1995-01-03—66353571284165 Lake View Rd, Nashville, TN, 372320.78Name re-casedPhone reformattedCity re-casedState name converted to code+1 more
TPA-52552TPAChristina R Estrada1992-01-23——2304 Washington St, Atlanta, GA, 303170.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-54291TPABobby Vazquez1940-03-17—45477148098042 Baseline Rd, Nashville, TN, 372240.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56051TPAFrank Walsh1944-01-16—55982548076557 Church St, Tampa, FL, 336240.78Two-digit birth yearPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-57012TPAChristian Carter1964-06-17——2175 Spring St, Tucson, AZ, 857200.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-57381TPABrandon Morris1961-09-27—58296311753009 Maple Ave, Tampa, FL, 336260.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50552TPALogan Weber2004-12-10——4097 Ridge Rd, Tucson, AZ, 857920.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62009TPAJennifer Lee1984-05-11—24168926422678 Palm Dr, Nashville, TN, 372560.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56837TPARonald Hoffman1958-08-16—98921992668607 Ocean Ave, Tucson, AZ, 857150.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-59942TPAMaarilyn Yang1980-11-06—41291069997292 River Rd, Charlotte, NC, 282090.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62605TPAJordan Moore1991-03-02—83025007278323 Union St, Tampa, FL, 336900.78Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-63550TPAAlan I Aguilar1965-11-24—68581707042959 Lake View Rd, Atlanta, GA, 303920.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59560TPADonald V Rojas1981-02-18—61189293103130 Grand Ave, Charlotte, NC, 282770.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-50316TPASusan Bennett1951-07-12—98943623118267 Jefferson Ave, Denver, CO, 802030.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55208TPAZachary Holmes1960-05-10UHC-72648-9169853790945767 Broadway, Sacramento, CA, 958560.78Date of birth reformattedState code upper-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-62077TPAKaren Lopez1992-01-05—68880451704053 Grand Ave, Orlando, FL, 328500.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55773TPADylan Hunter1970-12-16——4137 Sunset Blvd, Fresno, CA, 937960.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52122TPAArthur Harris1984-02-13——6027 Church St, Scottsdale, AZ, 852620.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-56118TPACarol Burton1984-02-02——5385 Broadway, Orlando, FL, 328070.78Name re-casedTwo-digit birth yearAddress re-casedWhitespace trimmed+1 more
TPA-53777TPASteven Holmes1938-02-13—60898632426670 Washington St, Tempe, AZ, 852450.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-62982TPAKyle Diaz1947-01-21——7281 Ridge Rd, Dallas, TX, 752740.78Name re-casedZIP+4 trimmedEmail lower-casedWhitespace trimmed+1 more
TPA-63003TPAEmma Reynolds1960-11-23——2833 Union St, San Diego, CA, 921910.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-54465TPAMateo X Austin1976-03-24——6217 Indian School Rd, Gilbert, AZ, 852820.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59400TPANoah Cook1966-08-22——7531 Oak St, Austin, TX, 787330.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53785TPAAlice X Ellis1994-07-19—47051695617963 Park Pl, Charlotte, NC, 282990.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64001TPANicholas Adams1953-12-23——8975 Grand Ave, Atlanta, GA, 303940.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53757TPALarry Payne1969-07-14—64834263012134 Pine Dr, Sacramento, CA, 958490.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58578TPAChristine Stevens——41594417399540 Broadway, San Antonio, TX, 782150.78Date of birth unreadablePhone reformattedAddress re-casedWhitespace trimmed+1 more
TPA-63429TPABetty Berry1990-10-16—40731152959242 Desert Sky Blvd, Scottsdale, AZ, 852960.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52767TPATyler Gutierrez1971-04-01—76190197462641 Lincoln Way, San Antonio, TX, 782990.78Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more
TPA-52575TPADavid Lewis1981-04-09——5645 Apache Blvd, Eden Prairie, MN, 553660.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61333TPAJudith Martinez1969-01-07——7901 Spring St, Scottsdale, AZ, 852130.78Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-50061TPAMichael Franklin1940-01-11——8021 Park Pl, Fresno, CA, 937530.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59865TPAJulia H Carter1993-12-09——7784 Apache Blvd, Columbus, OH, 432660.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57423TPAAnna Lee1960-02-06—9182969182911 Ocean Ave, Nashville, TN, 372870.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59612TPAPaul Welch1951-06-06—35547681501850 Park Pl, Phoenix, AZ, 850710.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63733TPABryan Ortega1959-02-07——6900 Union St, San Antonio, TX, 782260.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56964TPAJulia Collins1951-07-27——9208 Camelback Rd, Eden Prairie, MN, 553710.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50309TPAEvelyn Brooks1949-05-03——9160 Forest Ave, Scottsdale, AZ, 852390.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58939TPACralson Willie1985-10-01—92425640549215 Ocean Ave, Minneapolis, MN, 554270.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-57911TPAWei Young1952-07-19——3533 Church St, Minneapolis, MN, 554870.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-56072TPAVincent H Mills1977-06-11———0.78Name re-casedDate of birth reformattedPhone missing area codeWhitespace trimmed+1 more
TPA-58480TPAGerald Banks1998-10-17—65136651181424 Desert Sky Blvd, Mesa, AZ, 852580.78Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-51959TPAJonathan Cunningham1988-01-15——8972 Union St, Minneapolis, MN, 554700.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64378TPAEmily Hamilton1985-04-24——1869 Apache Blvd, San Antonio, TX, 782780.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56501TPAJuan Lopez1968-10-05UHC-13601-9327957631028639 Highland Ave, Columbus, OH, 432440.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-53780TPAAnn Murphy1974-11-17UHC-34533-93—4819 Church St, Charlotte, NC, 282660.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59269TPAElizabeth Dean1989-06-12——4310 Church St, Austin, TX, 787470.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 156 of 290PreviousNext