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-63470TPATerry Medina1993-05-16—45961433859507 Camelback Rd, Columbus, OH, 432780.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61051TPAAmy Simpson1969-02-17——8176 Bayshore Dr, Las Vegas, NV, 891440.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52999TPAKeith Valdez1972-04-23—59345255859071 Desert Sky Blvd, Austin, TX, 787430.76Name re-casedDate of birth reformattedPhone reformattedState code upper-cased+2 more
TPA-50361TPASamuel Price1987-11-25—67323720793203 Central Ave, Atlanta, GA, 303650.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57237TPAJudith Obrien1942-09-19UHC-60232-99—3631 Highland Ave, Tempe, AZ, 852330.76Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60429TPAMason Alvarez1977-06-14——3381 Sunset Blvd, San Diego, CA, 921730.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60408TPAVirginia Buton1994-09-10—20674107849443 Maple Ave, Miami, FL, 331440.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-55635TPAGeorge Padilla2005-01-20——7600 Valley View Dr, Charlotte, NC, 282740.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56860TPAJoyce Hanzon1953-05-26——7759 Market St, Tempe, AZ, 852550.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62391TPARachel Yang1945-11-12—38173674962921 Palm Dr, Denver, CO, 802430.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57744TPADebra Obrien2006-10-26—61775056866594 Forest Ave, Fresno, CA, 937750.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58421TPAKelly Gonzales1965-12-21—87052621864772 Forest Ave, Plano, TX, 750140.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55184TPASofia Weaver1995-10-15——7535 Mesa Dr, Orlando, FL, 328140.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54565TPADenise Hanson1967-10-24——5749 Willow Ct, Sacramento, CA, 958670.76Date of birth reformattedState code upper-casedGender normalisedPlan code upper-cased+2 more
TPA-57636TPAJacob Russell1961-03-27——2233 Broadway, Dallas, TX, 752840.76Date of birth reformattedPhone missing area codeAddress re-casedState code upper-cased+2 more
TPA-60790TPATyler Wagner1977-08-17——8116 Willow Ct, San Antonio, TX, 782390.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63542TPARandy Peterson1959-11-26—38793579821573 Pine Dr, Plano, TX, 750010.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56110TPAEugene Evans1975-09-28—51130293999216 Main St, Eden Prairie, MN, 553380.76Date of birth reformattedPhone reformattedCity re-casedZIP+4 trimmed+2 more
TPA-59944TPAIsabella Hanson1969-02-15—90028971826627 Apache Blvd, Eden Prairie, MN, 553260.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57565TPAMaria Lawrence1981-06-26—24667700942940 River Rd, Mesa, AZ, 852640.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60553TPAJennifer Medina2000-06-27——1107 Valley View Dr, Eden Prairie, MN, 553250.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59523TPAPamela Grant1949-06-15UHC-93251-47—6343 Maple Ave, Denver, CO, 802350.76Name split from “Last, First”Date of birth reformattedCity re-casedEmail lower-cased+2 more
TPA-62919TPAKen McDonald2003-12-23—23423563371501 River Rd, Tampa, FL, 336100.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-64246TPAVirginia Armstrong1961-07-18—84583881682450 Valley View Dr, Mesa, AZ, 852040.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53868TPAAlice Fox1956-01-28—75569182674968 Mountain View Dr, Charlotte, NC, 282910.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63868TPAJerry Roberts2005-11-21UHC-19892-5951988628698059 Valley View Dr, Scottsdale, AZ, 852720.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57745TPAKayla Evans1943-01-06—49278991523165 Broadway, Austin, TX, 787120.76Phone reformattedAddress re-casedCity re-casedGender normalised+2 more
TPA-56112TPACarol Crawford1980-09-14UHC-16231-67—9283 Indian School Rd, Scottsdale, AZ, 852470.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58867TPAJackie Ferguson1974-09-25—76051134321854 Ocean Ave, Orlando, FL, 328060.76Date of birth reformattedPhone reformattedCity re-casedState name converted to code+2 more
TPA-62523TPAJonathan Brooks1999-03-02——4731 Sunset Blvd, Los Angeles, CA, 900890.76Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-56940TPAPeter Evans1964-08-09—5842754486105 Mountain View Dr, Plano, TX, 750830.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64392TPAMark Walsh1980-06-15——9283 Bayshore Dr, Atlanta, GA, 303200.76Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+2 more
TPA-60875TPAHelen Welch1953-04-03——2008 Jefferson Ave, Tucson, AZ0.76Name re-casedDate of birth reformattedCity re-casedZIP missing+2 more
TPA-62691TPAKimberly U Spencer1982-12-11——7814 Mesa Dr, Orlando, FL, 328240.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56129TPAKathryn Sims1967-11-06——9716 River Rd, Minneapolis, MN, 554780.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55540TPAEmily Black1949-02-19——8359 Desert Sky Blvd, Jacksonville, FL, 322870.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52875TPADouglas Watosn1969-10-16—21737263114292 Highland Ave, Gilbert, AZ, 852280.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-51026TPAGloria Bradley2003-07-17——2984 Indian School Rd, Scottsdale, AZ, 852960.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53426TPAWebb Benjamin1967-03-24—41847092719584 Hillcrest Rd, San Diego, CA, 921730.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54119TPAOmar Bell1998-05-17——9649 Camelback Rd, Seattle, WA, 981070.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61960TPAKimberly Hernandez1945-12-13—36938905434884 Pine Dr, Phoenix, AZ, 850230.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61996TPACheryl Gordon1988-07-20—31859686911913 Elm St, Eden Prairie, MN, 553350.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-54775TPAWayne Bennett1949-04-19——4620 Baseline Rd, Columbus, OH, 432250.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59928TPABrittany Sandoval1963-09-13—30888958119865 Desert Sky Blvd, Eden Prairie, MN, 553390.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55593TPASarah Salazar1955-02-17—56146435704834 Baseline Rd, Charlotte, NC, 282430.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-60642TPABrian N Rogers1954-09-25——2114 Maple Ave, Glendale, AZ, 853670.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61609TPAVincent Willis2004-10-01UHC-89971-4057690515991003 Bayshore Dr, Plano, TX, 750060.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63660TPABenjamin Williams1947-06-24—26539561426053 Broadway, Tucson, AZ, 857390.76Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+2 more
TPA-61604TPAChris Robinson1990-04-22——2661 Valley View Dr, Los Angeles, CA, 900060.76Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more
TPA-61603TPAChris Robinson1990-04-22——2661 Valley View Dr, Los Angeles, CA, 900060.76Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more
14,474 rows, page 121 of 290PreviousNext