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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-59686TPAAlexander E Snyder1992-07-21——9767 Union St, Atlanta, GA, 303130.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-51646TPAHeather Walsh1942-10-11———0.80Name split from “Last, First”Date of birth reformattedEmail lower-casedWhitespace trimmed
TPA-52795TPAMegan Bakar1994-01-06UHC-45792-2859647080075007 Bayshore Dr, Nashville, TN, 372610.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54157TPADonald Valdez1994-07-24—7849260706—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-63110TPAChristine Moore1954-06-10——8018 Maple Ave, Scottsdale, AZ, 852670.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-56052TPACatherine B Estrada1985-11-03UHC-58863-99—2694 Canyon Rd, Los Angeles, CA, 900630.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58838TPAEvelyn Delgado1961-10-05UHC-46372-433543686826495 Church St, Plano, TX, 750740.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-62692TPAGregory Pena1944-04-24—5237698601—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60576TPAKyle Cruz1947-05-02——2342 Church St, Jacksonville, FL, 322260.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-64063TPADanielle Wang1941-08-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52659TPABarbara Mejia1972-11-14UHC-89568-776926701904132 Canyon Rd, Glendale, AZ, 853850.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-63580TPAFatima Bowman1989-06-08———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57004TPAAlexander Johnston2006-02-24———0.80Name split from “Last, First”Plan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-54808TPAMelissa Sims1949-08-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54807TPAMelissa Sims1949-08-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62856TPAAmber Z Olson1965-06-20—6602446586—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-62898TPABrandon Fox1977-08-01——7835 Meadow Ln, Phoenix, AZ, 850920.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57733TPAJudy E Vega1996-03-15—9157390906—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53057TPANicholas Bradlley1954-07-23——9694 Broadway, Las Vegas, NV, 891120.80Name split from “Last, First”Date of birth reformattedAddress re-casedPlaceholder values cleared
TPA-55091TPAElizabeth Crawford2002-07-18—6113531127—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61104TPAColeman Steven1943-09-27———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63274TPABenjamin Taylor1965-12-19—90283459918247 Lake View Rd, Gilbert, AZ, 852170.80Name split from “Last, First”Phone reformattedState code upper-casedPlaceholder values cleared
TPA-59730TPAAmy Davis1987-11-28—6658721312—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-55726TPAKathleen Brooks1987-01-02—34433155948400 Broadway, Tempe, AZ, 852160.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-56055TPACatherine T Robertson1941-07-02——4634 Desert Sky Blvd, Fresno, CA, 937660.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51494TPARyan C Patel2008-04-15—5068686599—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58084TPALogan Morgan1975-11-03——5987 Ocean Ave, Glendale, AZ, 853590.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-50884TPACarlos Lawrence1957-09-19——6107 Mountain View Dr, Phoenix, AZ, 850150.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54489TPAMariana Snyder1999-01-24——5485 Mesa Dr, Dallas, TX, 752750.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60049TPADouglas Matthews1976-06-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63706TPAMadison Dunn2008-10-06—87882284831892 Market St, Seattle, WA, 981840.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55602TPAMateo Y Mitchell1983-09-13—2917080633—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-57427TPAJean Collins1971-03-07—3415528863—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
TPA-60980TPAIsabella L Harrt1975-03-17UHC-19333-94—4604 Jefferson Ave, Glendale, AZ, 853720.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62350TPAChristine I Young1978-10-04——8138 Spring St, Tampa, FL, 336180.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57014TPADorys Anderson1940-06-16—47646832275796 Broadway, Sacramento, CA, 958280.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-58194TPAGeorge Z Li1955-11-01———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-51577TPANicole Wood2002-05-07———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-50286TPABrian W Hughes1973-09-07UHC-74866-18—2261 Mesa Dr, Dallas, TX, 752870.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-51113TPAEmma A Perez1997-09-25———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-57887TPAAlexander Reid1978-02-16——4432 Lake View Rd, Austin, TX, 787120.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-51303TPAAaron Gilbert1981-09-11—5335187121—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-50915TPARachel Espinoza1955-09-10UHC-13174-25—4838 Hillcrest Rd, Los Angeles, CA, 900520.82Name split from “Last, First”City re-casedPlaceholder values cleared
TPA-60893TPAJerry Lawrence1950-12-23UHC-09319-18—1879 Lincoln Way, Houston, TX, 770850.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-59044TPAGregory Hudson1968-08-14———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-59043TPAGregory Hudson1968-08-14———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-52431TPADenise Dunn1945-05-11—37971970485263 Sunset Blvd, Tempe, AZ, 852390.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-62975TPAAngela Estrada1999-03-05—80851227485971 Camelback Rd, San Diego, CA, 921560.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-64185TPAMelissa Fox1979-10-28—3326363708—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-50170TPASean Rogers1972-01-26—2185938625—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
1,488 rows, page 26 of 30PreviousNext