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-52928TPATerrry F Kelly——76785979492627 Highland Ave, Phoenix, AZ, 850770.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50815TPAGabriel Hanson1981-07-24—8286453056—0.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
TPA-63414TPAMargaret Jordan——64370423744851 Harbor Blvd, Denver, CO, 802950.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56592TPAEugene Wallace1942-06-16UHC-99190-1422073350968878 Baseline Rd, Jacksonville, FL, 322190.66Name split from “Last, First”Date of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-62770TPAKaren Morales1943-05-21——6903 Willow Ct, Los Angeles, CA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-52629TPACarroll Alice1942-01-23——7653 Bayshore Dr, Scottsdale, AZ, 852050.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-63374TPAPat Robinson1971-12-01——1715 Ridge Rd, Denver, CO, 802310.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50483TPANicole Chapman1981-08-15UHC-66699-97—7843 Meadow Ln, Jacksonville, FL, 322630.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63331TPAChristian I Simmons———8494 Central Ave, Phoenix, AZ, 850920.66Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-58328TPAJonathan George1950-03-11—29030310493565 Jefferson Ave, Jacksonville, FL, 322700.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-59442TPAJun Kelly1946-10-24——2386 Central Ave Apt 34, Phoenix, AZ, 850570.66Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-51799TPAEmily Rojas1973-08-11—45470158863655 Market St, Las Vegas, NV0.66Date of birth reformattedZIP missingGender normalisedWhitespace trimmed+1 more
TPA-61649TPAJeremy Fields1941-08-04——806 Jefferson Ave, San Antonio, TX, 782640.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-57882TPASean N Hicks1971-01-22——7299 Baseline Rd, Atlanta, GA, 303970.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63159TPASandra G Hart1957-12-16—95083979039810 Jefferson Ave, San Diego, CA, 921190.66Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+1 more
TPA-50729TPAJoe Lynch1939-05-17——3000 Lake View Rd, Fresno, CA, 937190.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54798TPAWilile V Dunn1968-09-07——7513 Jefferson Ave, Minneapolis, MN, 554760.66Name split from “Last, First”City re-casedGender normalisedWhitespace trimmed+1 more
TPA-53737TPAJoe Matthews1945-05-09——1238 Willow Ct, Las Vegas, NV, 891830.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-62381TPAAnthony Guerrero1953-12-24UHC-05111-0235677856811641 Central Ave # 871, Los Angeles, CA, 900810.66Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+1 more
TPA-60927TPAHeather Carr1940-09-28——7272 Spring St, San Antonio, TX, 782840.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-53021TPAKeith Dixon2004-09-02—77576264399147 Hillcrest Rd, Fresno, CA, 937540.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-58548TPAGloria Stone1945-12-08——2470 Indian School Rd, Fresno, CA, 937240.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-56128TPAPriya Gonzales1946-02-20—64467229018243 Hillcrest Rd, Nashville, TN, 372810.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-64260TPAJerry Weber2007-02-02——1357 Union St, Eden Prairie, MN0.66Two-digit birth yearCity re-casedZIP missingWhitespace trimmed+1 more
TPA-56611TPADenise Wells1998-09-06——8604 Lincoln Way Apt 27, Columbus, OH0.66Name re-casedUnit split from streetCity re-casedZIP missing+1 more
TPA-58425TPAKatherine Perry1973-08-28——9316 Sage Ct, Tampa, FL, 336680.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-54396TPAJoan Clark1967-11-09——3163 Grand Ave Apt 38, Atlanta, GA, 303080.66Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-51659TPALuis Hguhes1987-03-13——8374 Sunset Blvd, Seattle, WA, 981190.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-55003TPAShirley Harrison———1543 Sunset Blvd, Fresno, CA, 937430.66Name re-casedDate of birth missingCity re-casedState name converted to code+1 more
TPA-58498TPAJoseph Moore1990-05-26UHC-14260-60—5602 Mesa Dr, Tucson, AZ, 857400.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-52264TPARichard Hudson1974-01-08—70174000067415 Sage Ct, Seattle, WA, 981830.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-64068TPACynthia Le1945-09-14——3532 Pine Dr, Chandler, AZ, 852750.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-52018TPAPhilip O Carpenter1952-03-23———0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-52829TPAJessica Andraws1975-11-03——8940 Meadow Ln Apt 11, Las Vegas, NV, 891070.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60456TPA—Junk2000-09-03UHC-97938-47—7552 Sunset Blvd, Scottsdale, AZ, 852630.66Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared+1 more
TPA-53974TPAGloria UJunk1978-12-18——9333 Hillcrest Rd, Minneapolis, MN, 554930.66Middle initial moved out of first nameName re-casedCity re-casedPlaceholder values cleared+1 more
TPA-58535TPAPat Valdez2004-08-20—59632464164711 Pine Dr, Columbus, OH, 432100.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-63227TPAJesse Jones1967-07-15——9066 Union St, Tampa, FL, 336270.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-64102TPAFrances Williamson1960-12-08—96293966173123 Mountain View Dr, Nashville, TN, 372780.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51859TPANick Fuller1983-02-08UHC-17681-49—4462 Sage Ct, Las Vegas, NV, 891440.66Name split from “Last, First”Date of birth reformattedCity re-casedGender normalised+1 more
TPA-55469TPAFoster Andrew1955-10-12—63942653306503 Cedar Ln, Las Vegas, NV, 891730.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-56627TPAAmanda Carter2008-02-14——4036 Valley View Dr, Chandler, AZ, 852740.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
TPA-63290TPAAlexis Weber1980-03-26——5247 Market St, Columbus, OH, 432080.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-53432TPACarol Garrett1971-02-27——5161 Valley View Dr, Fresno, CA, 937850.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-58000TPAArthur Oliver1995-04-22——8600 Union St, Houston, TX, 770510.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-63086TPAHelen Diaz2000-05-28—62689034195905 Camelback Rd # 739, Columbus, OH, 432020.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59973TPALuis S Hoffman1975-12-13UHC-08461-37—1769 Main St, Nashville, TN, 372580.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61169TPARoy Spencer1981-07-16——7299 Main St, Fresno, CA, 937580.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-57677TPAElijah Burke1994-03-26UHC-30110-62—6133 Washington St, Gilbert, AZ0.66Date of birth reformattedCity re-casedZIP missingGender normalised+1 more
TPA-61028TPAJeremy Henderson1994-12-07—4864125425887 Desert Sky Blvd, Miami, FL, 331640.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
14,474 rows, page 87 of 290PreviousNext