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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-60090TPAWayne Y Watkins1997-09-27——2153 Ocean Ave, Seattle, WA, 981300.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64439TPAJuan Hall1938-04-27——3867 Hillcrest Rd, Houston, TX, 770200.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58891TPAWei B Miller1949-03-27——3062 Camelback Rd, Phoenix, AZ, 850100.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53893TPANoah Salazar1994-03-03—95397530185710 Maple Ave, Jacksonville, FL, 322700.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64105TPAYuki Freeman1980-05-09—94957091977721 Camelback Rd, Nashville, TN, 372920.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59065TPARalph Nichols1961-06-14UHC-69144-3443059896825689 Lincoln Way, Chandler, AZ, 852690.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-56517TPABilly Little2002-08-12—48740981975327 Canyon Rd, Columbus, OH, 432960.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52132TPAJulie Brooks2000-01-15—85042892092139 Park Pl, Scottsdale, AZ, 852690.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55139TPAPamela Webb1961-07-11—64122044595174 Lake View Rd, San Diego, CA, 921630.80Phone reformattedSSN last four extractedCity re-casedPlaceholder values cleared
TPA-54852TPAHannah Silva1987-12-06—56429766144027 Park Pl, Glendale, AZ, 853150.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57617TPANancy Hughes1997-02-05——7424 Cedar Ln, Las Vegas, NV, 891310.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59522TPASantiago Perkins1972-01-21UHC-86977-192417300455172 Jefferson Ave, Glendale, AZ, 853630.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59312TPACarollyn Walker1997-04-28——911 Mountain View Dr, Minneapolis, MN, 554710.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55776TPALucia Owens2008-07-17—71228889004476 Pine Dr, Charlotte, NC, 282680.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52211TPAMichelle M Smith2003-05-10——5366 Main St, Fresno, CA, 937690.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51966TPAJoey Lewis2005-04-10——1020 Cedar Ln, Scottsdale, AZ, 852270.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58614TPALogan Schmidt1940-05-01—24222402611699 Desert Sky Blvd, Mesa, AZ, 852370.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59140TPANathan Salazar1956-08-11———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60707TPAOmar Obrien1953-12-16UHC-62805-80—8422 Washington St, San Diego, CA, 921350.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59213TPAKayla Tucker1958-05-12UHC-60897-29—5351 Desert Sky Blvd, Las Vegas, NV, 891330.80Member ID reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-59212TPAKayla Tucker1958-05-12UHC-60897-29—5351 Desert Sky Blvd, Las Vegas, NV, 891330.80Member ID reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50750TPAChristian Robinson1950-02-06——4202 Grand Ave, Denver, CO, 802930.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55454TPAMei Lee1996-04-03——850 Pine Dr, Atlanta, GA, 303970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60234TPAKatherine Carpenter1977-08-22——2630 Harbor Blvd, Tampa, FL, 336590.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62050TPALogan R Vargas1965-06-07—8119287403—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-55573TPAKimberly Rooberts1944-04-27—66972203045474 Indian School Rd, Atlanta, GA, 303690.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50864TPAVincent Salazar1995-11-20——5492 Meadow Ln, Eden Prairie, MN, 553350.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55988TPATyler Medina1990-10-01——3212 Grand Ave, Mesa, AZ, 852820.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52325TPAKathryn Watson2004-11-20—62875122463234 Palm Dr, Charlotte, NC, 282110.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51078TPADuncan Alexis1974-05-28—89527103642572 Union St, San Diego, CA, 921700.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-62255TPAMadison Nichols1945-06-25——9777 Desert Sky Blvd, Jacksonville, FL, 322010.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-58093TPALawrence George1996-12-12——6604 Indian School Rd, Fresno, CA, 937210.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51472TPABrian Castillo1966-06-21—35078243715969 Willow Ct, Austin, TX, 787500.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58387TPAAustin Li1962-04-04——3597 Spring St, Plano, TX, 750290.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53112TPAAllen Gloria1992-09-12UHC-83991-66—6590 Lake View Rd, Austin, TX, 787190.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52500TPASharon Lynch1977-12-04——8452 Desert Sky Blvd, Miami, FL, 331570.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-57333TPAPamela Sanders1960-06-02——4856 Mountain View Dr, Chandler, AZ, 852720.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-52740TPAJean Kelly2007-01-26UHC-07294-32—1655 Cedar Ln, Chandler, AZ, 852710.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-51535TPAJoe Wang1976-04-25—81530472227202 River Rd, San Diego, CA, 921720.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60701TPAMichelle Wells1996-01-16UHC-10009-582925231652831 Desert Sky Blvd, Minneapolis, MN, 554310.80Name re-casedState code upper-casedGender normalisedPlaceholder values cleared
TPA-55307TPABeverly Thompson1943-05-13—7834378640260 Park Pl, Nashville, TN, 372800.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57143TPAGreg Valdez1940-07-20——5929 Oak St, Charlotte, NC, 282110.80Name split from “Last, First”Date of birth reformattedCity re-casedPlaceholder values cleared
TPA-63312TPARay Castillo1944-12-19——3054 Central Ave, Nashville, TN, 372890.80Date of birth reformattedPhone missing area codeState code upper-casedPlaceholder values cleared
TPA-53855TPABryan S Smith2003-10-02——8664 Ridge Rd, Nashville, TN0.80ZIP missingEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-55443TPAAnn Morales1982-03-06——3142 Park Pl, Austin, TX, 787730.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50587TPACatherine Ellis1939-12-19—7513768712—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53682TPAVinent Moreno1975-02-13——9606 Pine Dr, Jacksonville, FL, 322780.80Name re-casedPhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-62287TPACarol E Stevens1947-08-14——5527 Highland Ave, Eden Prairie, MN, 553210.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61107TPAWei Knight2003-01-13——5983 Harbor Blvd, Minneapolis, MN, 554400.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64153TPAPaul Gutierrez1949-04-03——1811 Mountain View Dr, Chandler, AZ, 852630.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 185 of 290PreviousNext