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-55963TPAStephen Miller1973-09-12——800 Central Ave, Sacramento, CA, 958110.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62042TPAOlivia Lynch1991-07-18——4811 Central Ave, Dallas, TX, 752430.78Name re-casedCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-50739TPAKenneth Woods1957-01-16——2537 Pine Dr, Los Angeles, CA, 900970.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-53084TPAJanet McDonald1982-06-05—39753371655152 Sunset Blvd, Tempe, AZ, 852970.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59268TPARebecca Carlson1983-06-12UHC-32126-56—3457 Bayshore Dr, Chandler, AZ, 852420.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-50718TPAArjun McCoy1954-05-11——3672 Camelback Rd, Orlando, FL, 328040.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-62706TPASharon Luna1957-12-02——9300 Maple Ave, Las Vegas, NV, 891380.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53948TPAAnthony Jackson1943-11-05—9219517579561 Main St, Los Angeles, CA, 900350.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50831TPASfoia P Jons1996-10-20—22741157178631 Spring St, Miami, FL, 331390.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63926TPARacehl Payne1938-01-01—46772734406669 Ocean Ave, Orlando, FL, 328380.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53399TPAEmma Walsh2000-09-24——1229 Park Pl, Glendale, AZ, 853790.78Date of birth reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more
TPA-60675TPAPhilip Warren1964-04-26—6237643552416 Meadow Ln, Nashville, TN, 372600.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55291TPALisa O Walker1960-01-24—49625485103284 Mesa Dr, Atlanta, GA, 303610.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61488TPALucia Alvarado2005-01-16——1364 Palm Dr, Jacksonville, FL, 322840.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55204TPATyler Ward1972-08-16——421 Church St, Miami, FL, 331530.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50385TPACrl Obrien1976-10-12———0.78Name split from “Last, First”Name re-casedDate of birth reformattedWhitespace trimmed+1 more
TPA-56908TPAChristina W Pierce1964-06-24——4130 Maple Ave, Los Angeles, CA, 900600.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57249TPABilly Jackson1951-06-13—82863261789686 Hillcrest Rd, Jacksonville, FL, 322580.78Name split from “Last, First”Date of birth reformattedPhone reformattedEmail lower-cased+1 more
TPA-50259TPADonald Morris1942-04-15——8022 Elm St, San Antonio, TX, 782680.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63036TPACarol Turner1988-06-04—8674376699834 Highland Ave, Eden Prairie, MN, 553250.78Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-64010TPACharlotte Jacobs1947-07-01——2840 Cedar Ln, Scottsdale, AZ, 852660.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56941TPAJeffrey Evans1997-04-07——9743 Sunset Blvd, Jacksonville, FL, 322210.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-52949TPATerry Hansen1942-07-22—32536857451582 Spring St, Seattle, WA, 981650.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60705TPALisa Torres1961-12-18—96028363695711 Union St, Glendale, AZ, 853940.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58729TPAJustin Y Elliott2007-08-16——797 Mountain View Dr, Phoenix, AZ, 850430.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50888TPAWayne Jimenez1962-12-03——6937 Grand Ave, Las Vegas, NV, 891610.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60856TPAAnn O Sims2003-11-13UHC-16272-6967266579574580 Lincoln Way, Scottsdale, AZ, 852430.78Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-59272TPAElizabeth M Dean1989-06-12—69350472844310 Church St, Austin, TX, 787470.78Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-52227TPANathan Jacobs1946-07-04——3405 Pine Dr, Seattle, WA, 981140.78Name split from “Last, First”Date of birth reformattedState code upper-casedWhitespace trimmed+1 more
TPA-52226TPANathan Jacobs1946-07-04——3405 Pine Dr, Seattle, WA, 981140.78Name split from “Last, First”Date of birth reformattedState code upper-casedWhitespace trimmed+1 more
TPA-55011TPAJulie T Ortega1964-09-26——1649 Mountain View Dr, Fresno, CA, 937640.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64242TPATeresa Reed1974-06-13UHC-91743-86—2181 Main St, Las Vegas, NV, 891440.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63068TPALuis Nichols1975-08-02——8547 Spring St, Tucson, AZ, 857210.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63558TPAKatherine Black1997-07-25——45 Palm Dr, Tucson, AZ, 857650.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53379TPAGrace Santiago2002-12-09—8919238749776 Forest Ave, Seattle, WA, 981180.78Name re-casedTwo-digit birth yearPhone reformattedEmail lower-cased+1 more
TPA-54939TPAHenry Rodriguez1959-05-24—6267414210—0.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-63284TPAAmy V Butler1959-06-20—41966338091003 Harbor Blvd, Tucson, AZ, 857530.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57974TPAJoseph Hunt1983-12-06——4149 Central Ave, Austin, TX, 787100.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51800TPAJean Welsh1949-10-02—44528544372051 Canyon Rd, Los Angeles, CA, 900590.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59641TPADiane W Collins1938-01-18—97842352051129 Lake View Rd, Scottsdale, AZ, 852630.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50042TPAKyle Carr1978-09-07——8327 Apache Blvd, Scottsdale, AZ, 852750.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53581TPAElijah Allen1943-12-01—6168902010425 Main St, Tucson, AZ, 857920.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60283TPAHannah Yang1960-11-12—86285638449744 Church St, Tucson, AZ, 857130.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-57718TPARachel Webb2001-04-13——5298 Maple Ave, Atlanta, GA, 303780.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50050TPADylaan Reed1950-04-23—54098189235538 Park Pl, Gilbert, AZ, 852090.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-51033TPAKaren Little1959-03-03——7996 Willow Ct, Orlando, FL, 328300.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-54911TPAJohn Gomez1958-03-19——5201 Park Pl, Orlando, FL, 328730.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54910TPAJohn Gomez1958-03-19——5201 Park Pl, Orlando, FL, 328730.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60354TPAJerry Moore1963-04-12——5838 Lincoln Way, Columbus, OH, 432490.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61665TPAChryl Alvarez1938-01-25——9105 Baseline Rd, Orlando, FL, 328750.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
14,474 rows, page 159 of 290PreviousNext