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-53203TPALisa Bryant1997-02-06———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-55858TPADiego Guerrero1943-03-05——4725 Willow Ct, San Diego, CA, 921830.82Two-digit birth yearCity re-casedPlaceholder values cleared
TPA-55542TPALisa Myers1975-08-10———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-59839TPAIsabella Lopez1960-01-05———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-50892TPACharlotte Oliver1995-04-07——951 Jefferson Ave Apt 21, Sacramento, CA, 958870.82Name re-casedUnit split from streetPlaceholder values cleared
TPA-50032TPAMei Arnold1977-07-03——4985 Church St, Miami, FL0.82Date of birth reformattedZIP missingPlaceholder values cleared
TPA-51851TPAJeremy Garrett1978-01-24——2339 Park Pl, San Diego, CA, 921810.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64165TPABrittany Garrett1970-01-05———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-64433TPAWilliam Thomas1966-01-16——6199 Cedar Ln, Seattle, WA, 981730.82City re-casedGender normalisedPlaceholder values cleared
TPA-52271TPAVirginia Ortiz2008-03-22——8997 Broadway, Denver, CO, 802280.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-53262TPACamila Herrera1970-12-22——4528 Union St, San Diego, CA, 921200.82Street suffix standardisedAddress re-casedPlaceholder 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-63602TPADouglas Sanders1958-07-23—46994002517638 Bayshore Dr, Atlanta, GA, 303710.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-52294TPARobert Ross1997-08-18——6404 Central Ave, Gilbert, AZ, 852240.82State name converted to codeWhitespace 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-64050TPAPeter Alexander1961-05-20UHC-95104-5939876972386695 Market St, Orlando, FL, 328210.82Member ID reformattedGender normalisedWhitespace trimmed
TPA-54241TPACnythia Ford1951-09-23UHC-92645-67—2718 Ridge Rd, Los Angeles, CA, 900980.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60566TPACynthia Medina1950-05-20——3801 Grand Ave, Las Vegas, NV, 891180.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63377TPADanielle Armstrong1950-05-04——821 Central Ave, Scottsdale, AZ, 852270.82Name re-casedGender normalisedPlaceholder values cleared
TPA-52431TPADenise Dunn1945-05-11—37971970485263 Sunset Blvd, Tempe, AZ, 852390.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-53903TPABrandon G Jacobs1955-08-05UHC-10592-72——0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-59829TPAHiroshiJunk1986-06-12—29362172651483 Canyon Rd, Houston, TX, 770020.82Phone reformattedPlaceholder values clearedNo usable name (quarantined)
TPA-62975TPAAngela Estrada1999-03-05—80851227485971 Camelback Rd, San Diego, CA, 921560.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-52590TPASara Kyng1996-12-15UHC-68504-05——0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-60298TPAKathy Edwards1955-08-04—96482594616159 Lake View Rd Apt 14, Nashville, TN, 372030.82Phone reformattedUnit split from streetPlaceholder values cleared
TPA-57431TPATerrry Richardson1984-07-04——921 Main St # 693, Chandler, AZ, 852200.82Date of birth reformattedUnit split from streetPlaceholder values cleared
TPA-57830TPAAnn Wagner2000-06-10—57993852922748 Harbor Blvd, Las Vegas, NV, 891600.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-57796TPADanielle Ferguson1945-04-19——3567 Elm St, San Antonio, TX, 782090.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54180TPARalph Chavez1988-12-07——8378 Ridge Rd, Denver, CO, 802580.82Name re-casedGender normalisedPlaceholder values cleared
TPA-64185TPAMelissa Fox1979-10-28—3326363708—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-63585TPARandy Woods1949-10-25——8616 Camelback Rd, Jacksonville, FL, 322350.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-50535TPAJordan Cruz2008-01-23——4114 Spring St, Plano, TX, 750470.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-53024TPALaura Aguilar1943-08-17——3684 Baseline Rd, Denver, CO, 802830.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50424TPAPeter Carter1999-02-24——8215 Market St, Fresno, CA, 937550.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60888TPAJoey Murray1957-08-06—36688015073641 Union St, Eden Prairie, MN, 553500.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53719TPAJudy Payne1950-01-20——1141 Indian School Rd, Minneapolis, MN, 554020.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57272TPAShirley Diaz1960-11-11——6942 Sage Ct, Austin, TX, 787430.82Name re-casedGender normalisedPlaceholder values cleared
TPA-52856TPALuis Reed1944-04-24—24230774893980 Meadow Ln, Orlando, FL, 328210.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-56074TPATimothy Gonzalez1941-09-16——9092 Willow Ct, Minneapolis, MN, 554940.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54962TPACamila Perins1986-01-14——3532 Canyon Rd, Scottsdale, AZ, 852480.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50170TPASean Rogers1972-01-26—2185938625—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-59918TPAVictoria Robertson1946-04-04UHC-63552-877348976315—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-58919TPATyller Li1940-02-08——3573 Grand Ave, Las Vegas, NV, 891110.82City re-casedGender normalisedPlaceholder values cleared
TPA-56100TPAOmar Mason1987-04-02—58554532908246 Union St, Minneapolis, MN0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-61654TPAShirley Soto1948-09-15—32742110756577 Baseline Rd Apt 20, Nashville, TN, 372170.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-52177TPAMartha Willis1966-07-20——3212 Bayshore Dr, Glendale, AZ, 853510.82Two-digit birth yearCity re-casedPlaceholder values cleared
TPA-64243TPAJohn Luna1982-01-25——2837 Jefferson Ave, Mesa, AZ, 852940.82Name re-casedGender normalisedPlaceholder values cleared
TPA-58785TPARalph Fernandez1943-07-07———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
14,474 rows, page 198 of 290PreviousNext