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-54055TPAMatthew R Romero1972-07-08—7653375419138 Market St, Tempe, AZ, 852260.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59635TPASharon W Gerge1959-01-13—60691066601079 Grand Ave, Columbus, OH, 432360.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64397TPARoy Collins1948-11-26——9360 Ocean Ave, Plano, TX, 750070.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-58305TPAHelen Green1928-02-24—40254576133097 Maple Ave, Seattle, WA, 981860.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-62624TPAAngela Burns1959-02-14—49094473038684 Ridge Rd, Eden Prairie, MN, 553500.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62001TPAHarold Murphy1948-08-24——7183 River Rd, Los Angeles, CA, 900040.64Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-52053TPAMatthew J Reid1952-03-09——6808 Highland Ave, Seattle, WA, 981280.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-53875TPAAlan Cole1977-06-25——4335 Ocean Ave, Mesa, AZ, 852950.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-51497TPARoy Baker1990-07-17UHC-57070-14—3701 Washington St, Tampa, FL, 336070.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56552TPARandy Meyer1984-07-26UHC-39293-88—2773 Mountain View Dr, Tucson, AZ, 857530.64Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+2 more
TPA-51620TPACharles Bryaant1941-02-14—38365395955600 Baseline Rd, San Antonio, TX, 782370.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-62101TPAJustin Ruiz1980-04-22—28671714416445 Jefferson Ave, Austin, TX, 787150.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52402TPAJessica Alexander1973-06-17——5403 Jefferson Ave, Phoenix, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52061TPACarol Henderson1948-10-16UHC-17723-27—2661 Cedar Ln Apt 1, Los Angeles, CA, 900440.64Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61600TPARuth Dixon———4358 Park Pl, Glendale, AZ, 853490.64Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63405TPAKaren Mitchell1949-09-02——5453 Spring St # 400, Los Angeles, CA, 900750.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-62444TPAScott Li2004-10-06——5197 Ocean Ave, Phoenix, AZ, 850860.64SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53327TPABetty Tucker1958-07-15——3595 Central Ave, Tucson, AZ, 857890.64Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-50288TPAMattheew Vega1998-08-17—48343045514884 Desert Sky Blvd, Tucson, AZ, 857220.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59050TPAMelissa Reed1984-05-20—36949198653282 Church St # 660, Los Angeles, CA, 900470.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56575TPADonald Hamilton1965-03-16——4473 Canyon Rd, Columbus, OH, 432910.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-57354TPAJason Ray1940-09-10——6764 Valley View Dr, Phoenix, AZ, 850280.64Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more
TPA-59534TPAPhilip Schmidt2000-12-08—40066561625704 Bayshore Dr, Jacksonville, FL, 322800.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59863TPACharles Q Medina1965-05-16——8165 Sunset Blvd # 325, Houston, TX, 770910.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
TPA-63373TPAPatrick Robinson1971-12-01——1715 Ridge Rd, Denver, CO, 802310.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57851TPAJacob Schmidt1969-03-25—54139232897946 Oak St, Columbus, OH, 432110.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-56936TPAGabriel Hawkins1949-12-22—86434193263579 Desert Sky Blvd, San Antonio, TX, 782170.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59182TPASarah Morris——44965002734576 Harbor Blvd, Mesa, AZ, 852640.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55563TPADorothy Lawson1996-03-21—47262173709381 Harbor Blvd, Scottsdale, AZ, 852150.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60843TPAEugene Nichols1980-03-11—20442014081911 Palm Dr, Phoenix, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62137TPAJacqueline Bennett1977-07-05—31596261585967 Washington St, Tempe, AZ, 852710.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50093TPAJessica Armstrong1962-09-14—67354789801123 Bayshore Dr, Plano, TX, 750250.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63978TPAMelissa Gray1999-07-22—9107018468720 Sunset Blvd, Eden Prairie, MN, 553190.64Name split from “Last, First”Phone reformattedState code upper-casedGender normalised+2 more
TPA-58544TPARichard Boyd1957-09-01—88059239777982 Central Ave, Glendale, AZ, 853370.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62474TPAAbby Murray1972-02-02—54975660643973 Union St, Jacksonville, FL, 322000.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62307TPANancy Johnson1982-09-21——5070 Mountain View Dr, Atlanta, GA, 303750.64Name re-casedDate of birth reformattedState name converted to codeEmail lower-cased+2 more
TPA-52892TPAJoyce Hicks1968-07-04——5364 Union St, Miami, FL, 331920.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-58656TPAThomas F Smith1987-09-18UHC-95598-56—8313 Hillcrest Rd, Los Angeles, CA, 900310.66State name converted to codeEmail lower-casedGender normalisedWhitespace trimmed+1 more
TPA-58964TPARuth Wagner1979-05-09——4140 Baseline Rd Apt 18, Sacramento, CA, 958910.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-61390TPALucia Weaver2000-08-24——4920 Lake View Rd, Columbus, OH, 432960.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-63481TPAPaul Chapman1993-01-24——9135 Cedar Ln, Las Vegas, NV, 891410.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57987TPAEdward Fowler2006-03-17——630 Lincoln Way, Glendale, AZ, 853560.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-54936TPALawrence Ray——37031019598789 Sunset Blvd, Miami, FL, 331590.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-51037TPATerry Z Johnston1948-11-09UHC-45521-7376233541945215 Highland Ave, Orlando, FL, 328870.66Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+1 more
TPA-63079TPAMarcus Russell1975-05-12—70846286883158 Jefferson Ave, Tampa, FL0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-53038TPABetty Stewart1963-09-14——468 Highland Ave, Columbus, OH, 432080.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-53422TPASteven Jones1987-01-21——8824 Main St, Tempe, AZ, 852610.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-57102TPAPamela Ruiz1973-02-23——383 Meadow Ln, Charlotte, NC, 282350.66City re-casedState code upper-casedZIP+4 trimmedGender normalised+1 more
TPA-63963TPACarolyn Flores1964-05-16——2384 Apache Blvd, Los Angeles, CA, 900370.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56419TPAOmar Le1980-03-23——9880 Canyon Rd, Charlotte, NC, 282060.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 69 of 290PreviousNext