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-56822TPARyan Pena2001-06-09—73085698724274 Washington St, Los Angeles, CA, 900570.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56311TPASarah Tucker1998-03-06UHC-97286-2983695506093680 Central Ave, Phoenix, AZ, 850360.78Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-64361TPARussell Jacobs1986-02-10——3278 Spring St, Denver, CO, 802250.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-60886TPAAlna Dminguez1990-07-24UHC-26620-072643157691690 Valley View Dr, Houston, TX, 770060.78Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+1 more
TPA-64326TPARacehl Q Carter1953-11-18UHC-82771-6492882648796729 Grand Ave, San Diego, CA, 921640.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55693TPARachel Diaz1999-12-10——9301 Highland Ave, Nashville, TN, 372320.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56882TPAJennifer Carlson1959-12-01—8979898499—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-56786TPALawrence Kennedy1940-07-23—95921392562893 Baseline Rd, Dallas, TX, 752170.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50313TPAPamela Bradley1994-12-07——4004 Baseline Rd, Jacksonville, FL, 322660.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51194TPAJudith Ramirez1964-11-02——1023 Canyon Rd, Mesa, AZ, 852830.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62747TPAAndrea Espinoza1975-04-26——3610 Highland Ave, Chandler, AZ, 852350.78Date of birth reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more
TPA-61349TPAGerald Mendez1963-01-11——4300 Mountain View Dr, Nashville, TN, 372100.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52852TPAJames Gilbert1965-01-02—88431261206028 Apache Blvd, Orlando, FL, 328360.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52765TPAAshley C Kim1975-12-28—84260900294485 Forest Ave, Tempe, AZ, 852630.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53044TPAPriya Edwards1998-12-12UHC-24743-58—9801 Willow Ct, Atlanta, GA, 303930.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53402TPABetty Boyd2001-09-14——1692 Sage Ct, Mesa, AZ, 852800.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-51077TPAAlexis Duncan1974-05-28—89527103647653 Park Pl, Scottsdale, AZ, 852840.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56760TPAKathleen Watkins1971-05-26——630 Desert Sky Blvd, Charlotte, NC, 282970.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57610TPAKtherine Mason1991-06-25——2654 Canyon Rd, Nashville, TN, 372730.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-63265TPASophia Long1941-02-07——4154 Mesa Dr, Eden Prairie, MN, 553240.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59380TPAJudy Hansen1968-08-13——5674 Church St, Gilbert, AZ, 852640.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55383TPAJacqueline V Jones1955-05-13UHC-92030-8941564090371278 Lake View Rd, Denver, CO, 802860.78Date of birth reformattedCity re-casedState name converted to codeEmail lower-cased+1 more
TPA-55088TPAKathleen Robertson1975-05-13—35228146937407 Pine Dr, Tampa, FL, 336850.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60154TPAJudy Welch1968-06-08——4253 Lake View Rd, Gilbert, AZ, 852550.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63339TPANicholas Contreras1994-10-03——9465 Meadow Ln, Plano, TX, 750420.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54076TPABrenda Phillips1945-10-26——5189 Grand Ave, Orlando, FL, 328840.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50413TPALogan Sims1969-01-26——9148 Bayshore Dr, Phoenix, AZ, 850360.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58993TPAJanet Morales1992-01-17——1780 Spring St, Chandler, AZ, 852400.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-53063TPARussell Grant1961-10-09—27452166122049 Church St, Glendale, AZ, 853060.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59874TPABobby Wilson1980-12-08UHC-65025-01—2048 Lake View Rd, San Antonio, TX0.78Date of birth reformattedCity re-casedZIP missingWhitespace trimmed+1 more
TPA-51852TPARusseell Warren1989-02-01——1252 Market St, Gilbert, AZ, 852650.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-61537TPAJoseph Hayes1968-08-14——4112 Hillcrest Rd, San Antonio, TX, 782180.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62080TPAEvelyn Walsh1945-11-12——472 Apache Blvd, San Antonio, TX, 782240.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53892TPALogan Patterson1994-07-22——9605 Canyon Rd, Mesa, AZ, 852030.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57949TPAJordan Mitchell1970-03-02——9358 Jefferson Ave, Denver, CO, 802040.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-59966TPAKathryn T Berry1945-05-22UHC-89770-54—6986 Washington St, Houston, TX, 770520.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57480TPASantiago Lnych1998-06-15UHC-94650-08—2281 River Rd, Las Vegas, NV, 891170.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58724TPAAna Grant1985-06-28——9801 Jefferson Ave, Columbus, OH, 432140.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57947TPADouglas Gonzales1991-07-21UHC-51488-52—3021 Main St, Plano, TX, 750260.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59028TPAJack Hill1984-01-05——4035 Ocean Ave, Denver, CO, 802380.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52919TPAWilliam P Howard1946-05-27——9694 Bayshore Dr, Nashville, TN, 372770.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-55676TPAAnna Torres2005-04-23UHC-62997-94—5265 Canyon Rd, Charlotte, NC, 282160.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-56281TPAHenry Wells1994-05-08——7167 Highland Ave, Scottsdale, AZ, 852160.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54874TPAVincent Larson1988-05-15UHC-73026-62—2120 Church St, Dallas, TX, 752400.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-63592TPARichard Rodriguez1946-12-14——9317 Bayshore Dr, Chandler, AZ, 852330.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56950TPABryan Ramos1942-01-24——9069 Ridge Rd, Gilbert, AZ, 852160.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-63207TPABarrbara Peters1951-04-10—62239284104436 Maple Ave, Tampa, FL0.78City re-casedZIP missingEmail lower-casedWhitespace trimmed+1 more
TPA-55286TPAMariana G Riley1959-06-25—27870189585620 Valley View Dr, Gilbert, AZ, 852630.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52115TPAJoyce Wright1966-01-14—3668917778—0.78Name re-casedPhone reformattedEmail lower-casedGender normalised+1 more
TPA-52116TPAJoyce Wright1966-01-14—3668917778—0.78Name re-casedPhone reformattedEmail lower-casedGender normalised+1 more
14,474 rows, page 129 of 290PreviousNext