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-62979TPAAna Vargas1979-02-26——6532 Harbor Blvd, Austin, TX0.82Date of birth reformattedZIP missingPlaceholder values cleared
TPA-56179TPANancy Mills——47063893237380 Oak St, Charlotte, NC, 282440.82Date of birth missingPhone reformattedPlaceholder values cleared
TPA-56828TPAHarold Murray1982-06-10——188 Baseline Rd, Austin, TX, 787530.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54739TPATeresa Hudson1994-02-16—33783040767336 Mountain View Dr, Nashville, TN, 372590.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-59064TPAJJunk1984-10-05——9633 Pine Dr, Los Angeles, CA, 900830.82Whitespace trimmedPlaceholder values clearedNo usable name (quarantined)
TPA-50534TPAJulia Hall1968-12-07——4168 Oak St, Denver, CO, 802150.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62813TPAAlbert Wallace1972-07-12UHC-61755-91—553 Park Pl, Chandler, AZ, 852090.82Name re-casedDate of birth reformattedZIP+4 trimmed
TPA-50816TPAValentina Obrien1965-06-13—85784121435035 Oak St, Los Angeles, CA, 900860.82Name re-casedPhone reformattedGender normalised
TPA-57110TPAFatima Mendez1945-07-18——4395 Union St, Orlando, FL, 328090.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62259TPAVasquez Shirley————0.82Name re-casedDate of birth missingPlaceholder values cleared
TPA-57352TPACamila Romero1941-04-20——6264 Forest Ave, Tampa, FL, 336740.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-51355TPACarolyn A Hawkins1955-08-14——2163 Camelback Rd, Orlando, FL, 328610.82Date of birth reformattedCity re-casedGender normalised
TPA-53413TPARebecca Cstillo2003-08-20UHC-65227-5439072924739475 Harbor Blvd, Miami, FL, 331400.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53641TPADeborah Alvarado———5707 Oak St, Nashville, TN, 372450.82Date of birth missingCity re-casedPlaceholder 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-61233TPAMatthew Cook1984-12-20——7819 Main St, Columbus, OH, 432780.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58021TPARaymond X Patel1983-07-14UHC-58315-2473178532365018 Broadway, Dallas, TX, 752010.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51572TPAAnna Ford2007-09-16———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-64430TPAJeremy Sims1980-06-18——3402 Washington St, Chandler, AZ, 852380.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50247TPAAnthony Riley1961-09-02—34084489244452 Harbor Blvd, San Diego, CA, 921510.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64233TPADanielle Simpson1995-03-09——5969 Church St, Chandler, AZ, 852170.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57077TPARay U Dixon1967-09-10——803 Apache Blvd, Gilbert, AZ, 852430.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61248TPAGregory Tuckr———5215 Mountain View Dr, Columbus, OH, 432940.82Name re-casedDate of birth missingPlaceholder values cleared
TPA-55757TPASarah Tucker1943-09-21———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54642TPAVictoria Simmons1960-11-19——9567 Highland Ave, Los Angeles, CA, 900890.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64352TPAAndrew Barnes1971-12-07——2579 Baseline Rd, Los Angeles, CA, 900030.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60802TPAMelissa White1978-10-14——7238 Canyon Rd, Nashville, TN, 372340.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53085TPAHeathher Wagner1991-12-14—44734708164720 Canyon Rd, Miami, FL, 331740.82Date of birth reformattedStreet suffix standardisedAddress re-cased
TPA-54085TPALuis Richards1969-08-21—9204617339—0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-62463TPARebecca O Campell1938-06-11—5877750928—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-62284TPATony Myers———4764 Sunset Blvd, Eden Prairie, MN, 553340.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-56693TPAHannah Carroll——9098181731—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-50128TPADennis Moore1951-10-02UHC-79281-29—75 Main St, Tempe, AZ, 852760.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56604TPAKelly Tucker————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-59592TPAWei Lawrence1949-01-10——2144 Main St, Atlanta, GA, 303430.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64143TPATimothyJunk2007-01-02———0.82Whitespace trimmedPlaceholder values clearedNo usable name (quarantined)
TPA-61980TPAHelen Gray1997-02-18—34180712056062 Canyon Rd, Tucson, AZ, 857920.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55841TPAJonathan Wang1939-08-09——4103 Mountain View Dr, Orlando, FL, 328570.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-55220TPAKevin Armstrong2002-04-16———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-62267TPAJessica Martin1999-01-11—64829368081720 Willow Ct, Nashville, TN, 372420.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-56728TPABrandon Rivera1991-04-07——5041 Jefferson Ave, Glendale, AZ, 853280.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61730TPAAdam T Singh1948-02-03——1814 Broadway, Tucson, AZ, 857610.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-50621TPASophia Watkins1974-02-03———0.82SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-63366TPASara Hudson1957-02-10——3436 Valley View Dr, Austin, TX, 787790.82Name re-casedState name converted to codePlaceholder values cleared
TPA-51303TPAAaron Gilbert1981-09-11—5335187121—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-53012TPAAdam Adams1969-07-05——87 Ridge Rd, Las Vegas, NV, 891910.82Name re-casedGender normalisedPlaceholder values cleared
TPA-54762TPADonald McDonald1996-06-01——9776 Market St, Austin, TX, 787840.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52427TPATony Mason1959-08-27UHC-71486-08—2698 Jefferson Ave, Gilbert, AZ, 852660.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-53175TPAFrank Snchez1941-11-17UHC-19954-35—2748 Sage Ct, Seattle, WA0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-53176TPAFrank Snchez1941-11-17UHC-19954-35—2748 Sage Ct, Seattle, WA0.82ZIP missingWhitespace trimmedPlaceholder values cleared
14,474 rows, page 197 of 290PreviousNext