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-64264TPAJudith Sanddoval1983-09-26——5058 Lake View Rd, Charlotte, NC, 282040.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-50868TPAKathleen Roberts1979-08-12——9030 Ocean Ave, Tampa, FL, 336360.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-50379TPAGrace Little1972-02-06——4309 Spring St, Scottsdale, AZ, 852290.66Date of birth reformattedSSN last four extractedGender normalisedWhitespace trimmed+1 more
TPA-60266TPAOmar Ortiz1956-02-23——2029 Ridge Rd, Nashville, TN, 372390.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-63729TPASharon Lewis1982-06-20—90352665117383 Central Ave, Houston, TX, 770180.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-54210TPAJustin Garza1950-05-24UHC-03693-68—3979 Park Pl, Columbus, OH, 432160.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52433TPAKelly Stevens1958-08-25——8166 Ocean Ave, Houston, TX, 770060.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-55308TPAMatthew Bennett2008-06-05——1050 Elm St, Nashville, TN, 372210.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-54856TPACarl Thompson1958-01-03——683 Spring St, Orlando, FL, 328030.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-53246TPAKatherine James2001-09-14——6636 Highland Ave, Miami, FL, 331800.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-63721TPAMarrk Gardner1966-02-12—3145760286607 Harbor Blvd, Charlotte, NC0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-55694TPARachel Diaz1999-12-10——9301 Highland Ave, Nashville, TN, 372320.66Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-55087TPAKathleen F Robertson1975-05-13——7407 Pine Dr, Tampa, FL, 336850.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-63059TPAPamela Kim1980-03-14UHC-79074-2076997531972856 Washington St, Minneapolis, MN, 554080.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-56806TPAArjun Martinez1938-06-17——210 Union St, Minneapolis, MN, 554360.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-50045TPAOmar McCoy1951-12-23—36354016261770 Indian School Rd, Seattle, WA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-58350TPAWillie Perez———5735 Park Pl, Sacramento, CA, 958100.66Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
TPA-62202TPAPaul Reynolds1967-03-18—40467049661055 Mesa Dr, Tempe, AZ, 852440.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
TPA-50787TPADiane A Lopez2008-02-15——4040 Highland Ave, Eden Prairie, MN0.66Name split from “Last, First”Date of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-60193TPAJose Arnold1973-03-20—77357593859748 Lake View Rd, Nashville, TN, 372470.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-53960TPAKathryn Morris1945-11-03——2221 Forest Ave, Jacksonville, FL, 322340.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-58112TPAOmar Evans1971-06-08——3145 Jefferson Ave, Charlotte, NC, 282420.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-61127TPASean Harper1966-04-26UHC-34117-81—3513 Indian School Rd, Nashville, TN, 372060.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-57273TPABilly Price1955-12-11——8964 Willow Ct, Denver, CO, 802850.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
TPA-63026TPAKyle Richardsun1976-01-01—9023234080—0.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
TPA-58064TPABarbara Ortiz1975-09-23——9244 Hillcrest Rd, Scottsdale, AZ, 852470.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-60317TPAAmber T Wells1953-04-11——3814 Palm Dr, Eden Prairie, MN, 553860.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-55379TPAKevin Vazquez1945-11-22——1448 Elm St, Mesa, AZ, 852250.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-56752TPASophia U Williamson———7952 Grand Ave, Plano, TX, 750770.66Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-62892TPALaura Franklin1946-02-10—46151556299639 Cedar Ln, Las Vegas, NV, 891100.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
TPA-61377TPAIsabella Vasquez2002-12-07——6491 Washington St, Tempe, AZ, 852450.66Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-53162TPAGloria Rogers1985-03-18——5350 Desert Sky Blvd, Atlanta, GA, 303470.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-56444TPAAdam Williamson1963-11-25UHC-76610-04—4862 Washington St, Scottsdale, AZ, 852440.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-53383TPAJulia Richardson1982-08-18—75447719398484 Lincoln Way # 697, Eden Prairie, MN, 553010.66Name split from “Last, First”Phone reformattedUnit split from streetWhitespace trimmed+1 more
TPA-50912TPADennis Williams1980-03-15——6382 Sage Ct, Gilbert, AZ, 852040.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60584TPAMariana Dixon1990-10-07—39325773036216 Camelback Rd, Scottsdale, AZ, 852240.66Two-digit birth yearPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-55409TPAThomas Richards1945-02-21——4221 Oak St, Las Vegas, NV, 891290.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
TPA-61182TPARaalph Shaw1951-11-25—2043527727416 Valley View Dr, San Antonio, TX0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-61668TPAJulie Rojas1950-04-23—33671266005396 Meadow Ln, San Diego, CA, 921390.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59432TPAArjun Williams1947-07-11—94044456988526 Bayshore Dr Apt 23, Miami, FL0.66Phone reformattedUnit split from streetZIP missingWhitespace trimmed+1 more
TPA-53340TPABurton Logan1945-08-04——9374 Canyon Rd, Houston, TX, 770170.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-55440TPAValentina Daniels1995-04-20——8688 Palm Dr, Seattle, WA, 981080.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-55439TPAValentina Daniels1995-04-20——8688 Palm Dr, Seattle, WA, 981080.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-61720TPABrenda Hughes1948-10-21——8393 Market St, Scottsdale, AZ, 852600.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50192TPACheryl Fernandez1964-05-13UHC-81604-3596674771005415 Lake View Rd, San Diego, CA0.66Two-digit birth yearPhone reformattedZIP missingWhitespace trimmed+1 more
TPA-62303TPAAmanda Ford1946-05-22——251 Baseline Rd, Tucson, AZ, 857260.66Name split from “Last, First”Street suffix standardisedAddress re-casedPlan code upper-cased+1 more
TPA-55933TPACynthia Sandoval2002-04-06——9753 Lake View Rd, Austin, TX, 787870.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-55174TPAChristopher Hoffman1946-05-04——6080 Baseline Rd, Houston, TX, 770220.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-56648TPAStephanie J Morgan———338 Valley View Dr, Tempe, AZ, 852520.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-56386TPAJordan Porter2001-04-17——2631 Highland Ave, Austin, TX, 787070.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
14,474 rows, page 70 of 290PreviousNext