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-53503TPADonald Castro1984-06-20—59947724841823 Mountain View Dr, Tampa, FL, 336070.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51151TPAJuan Wheeler1984-09-25——1189 Ocean Ave, Scottsdale, AZ, 852740.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62238TPAPeter Y West1975-01-06UHC-81086-81—9360 Elm St, Los Angeles, CA, 900760.78Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-58104TPAJoshua X Contreras1959-04-17——8975 Ocean Ave, Denver, CO, 802710.78Name re-casedCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-55788TPATimothy Stnoe1970-03-26UHC-35791-7726272382031872 Ridge Rd, Chandler, AZ, 852370.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62237TPAIsabella West1941-02-13——6180 Highland Ave, Plano, TX, 750210.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53296TPADennis Santos1998-09-18——2748 Sage Ct, Tucson, AZ, 857430.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52458TPAMelissa Alexander2002-05-27——6643 Broadway, Scottsdale, AZ, 852330.78Name re-casedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-55330TPAMike T Mills1943-11-05——5667 Central Ave, Houston, TX, 770500.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57699TPAScott Murray1940-07-26——8246 Forest Ave, Los Angeles, CA, 900980.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55403TPADavid Hansen2003-02-20——8251 Apache Blvd, Jacksonville, FL, 322550.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54304TPABryan Williams2007-08-09——3380 Park Pl, Tempe, AZ, 852010.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64231TPABobby Simpson1961-07-27—5796655691133 River Rd, Dallas, TX, 752570.78Street suffix standardisedAddress re-casedState code upper-casedPlan code upper-cased+1 more
TPA-57304TPAKelley M Frank1942-02-28——4477 Sunset Blvd, Jacksonville, FL, 322040.78Middle initial moved out of first nameName re-casedDate of birth reformattedWhitespace trimmed+1 more
TPA-52939TPADeborah Reyes1972-12-05——139 Main St, Scottsdale, AZ, 852780.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51327TPAAlice Carroll1948-06-15——6738 Oak St, Mesa, AZ, 852720.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-60809TPAChristina D Fox1962-06-21——5274 Valley View Dr, Gilbert, AZ, 852350.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-59408TPASantiago L Green1998-04-02—81388245266800 Canyon Rd, Columbus, OH, 432160.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60211TPAJeremy Hanson1950-07-21——7782 Meadow Ln, Columbus, OH, 432780.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61526TPAMartha Snyder1990-05-08—79643285366526 Broadway, Plano, TX, 750740.78Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-62860TPABrenda Phillips1961-06-05—80435370231876 Central Ave, Miami, FL, 331100.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51585TPAEvelyn Ray1941-10-09—23132908121967 Camelback Rd, Eden Prairie, MN, 553300.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53913TPAKeith Washington1945-03-09——273 Harbor Blvd, Nashville, TN, 372750.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63321TPASamuel Oliver1955-11-01——6300 Mountain View Dr, San Antonio, TX, 782990.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63403TPAMariana Garrett2003-11-15—82973563536949 Sunset Blvd, Mesa, AZ, 852580.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-57265TPANoah Santiago1979-07-05——7426 Baseline Rd, Los Angeles, CA, 900370.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54196TPAAndrea Fuller1997-06-11—39367345615434 Maple Ave, Minneapolis, MN, 554270.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62048TPACheryl M Pena1992-06-08——2669 Pine Dr, Sacramento, CA, 958500.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56403TPAKimberly Z Cooper1983-09-12UHC-95289-30—9356 Central Ave, Sacramento, CA, 958650.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-58967TPAAisha B Cooper1962-03-06——7175 Broadway, Denver, CO, 802000.78Name re-casedDate of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-54190TPAAna Martin1951-02-28—68862284544551 Lake View Rd, Columbus, OH, 432130.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52588TPADylan Stone1980-08-01—47337862489835 Jefferson Ave, Tampa, FL, 336400.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-56924TPARyan Gordon2000-09-19—5988345854491 Main St, Fresno, CA, 937250.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-54974TPAStephen A Lawson1977-11-05——8901 Meadow Ln, Nashville, TN, 372000.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50422TPAKayla Harris1946-08-10——1704 Elm St, Seattle, WA, 981140.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54519TPARyan Howrd1982-12-13——6856 Oak St, Jacksonville, FL, 322620.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-54675TPAGloria Ray—UHC-03742-0781371014952459 Oak St, Columbus, OH, 432040.78Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more
TPA-55455TPAAmanda Powell1958-02-20UHC-15061-4632440325915353 Meadow Ln, Tempe, AZ, 852510.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53576TPARichard Silva2005-06-25UHC-51819-3024435068334024 Lake View Rd, Gilbert, AZ0.78Name re-casedPhone reformattedZIP missingWhitespace trimmed+1 more
TPA-58928TPATyler Mendez1984-07-19—34255922868168 Church St, Tampa, FL, 336040.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-63858TPARobert Miller1984-11-03——4044 Market St, Minneapolis, MN, 554030.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52024TPABilly Tucker1987-12-20—55087718511246 Hillcrest Rd, Tampa, FL, 336790.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60127TPAAmy Andrews1944-02-27—54368820753903 Bayshore Dr, Jacksonville, FL, 322650.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52869TPAMelissa Montgomery1985-02-11—39852848491611 Spring St, Plano, TX, 750870.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51230TPAMichael Fernandez2005-12-20——4113 Highland Ave, Mesa, AZ, 852820.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55404TPABenjamin Elliott1948-03-08——5730 Sunset Blvd, San Antonio, TX, 782080.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62929TPASofia Alvarez1970-01-10——3305 Mesa Dr, Orlando, FL, 328020.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62930TPASofia Alvarez1970-01-10——3305 Mesa Dr, Orlando, FL, 328020.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62970TPAJudith Woods1971-04-21—34849053798981 Mesa Dr, Austin, TX, 787980.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59024TPAGeorge Lopez1951-11-13——9472 Sunset Blvd, San Diego, CA, 921820.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
14,474 rows, page 137 of 290PreviousNext