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-57332TPANoah W Hall1946-05-18UHC-25198-97—7972 Forest Ave, Seattle, WA, 981190.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-55082TPAKatherine Bowman———4963 Central Ave, Mesa, AZ0.54Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-53733TPAStephen Patel1961-07-20——8076 Highland Ave, Columbus, OH, 432900.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-53732TPAStephen Patel1961-07-20——8076 Highland Ave, Columbus, OH, 432900.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-62899TPAVirginia Ramos1989-04-27———0.54Name split from “Last, First”Two-digit birth yearGender normalisedWhitespace trimmed+1 more
TPA-54368TPANicole Hayes1939-04-16UHC-32516-68—695 Apache Blvd Apt 28, Plano, TX, 750900.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-52662TPABrian Perkins1971-11-22UHC-98944-17—2848 Sage Ct, Seattle, WA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
TPA-53891TPAFatima Vargas2006-12-02UHC-86574-22—4236 Sage Ct Apt 28, Tampa, FL0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-54449TPAAlxis Brooks1966-03-25——741 Ridge Rd, San Antonio, TX, 782840.54Name split from “Last, First”State name converted to codeEmail lower-casedGender normalised+1 more
TPA-57861TPAGregory Smith1980-08-27——9597 Sage Ct, Charlotte, NC, 282670.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
TPA-57709TPABrndon Shaw1960-11-07——7007 Oak St, Denver, CO0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-62758TPADiane George1994-09-26——6546 Spring St Apt 8, Houston, TX, 770770.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-53721TPABryan Palmer—UHC-88787-64—7401 Lincoln Way, Los Angeles, CA0.54Name re-casedDate of birth unreadableZIP missingGender normalised+1 more
TPA-59253TPAJoshua Williamson1987-07-19——2202 Apache Blvd, Jacksonville, FL0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
TPA-59315TPAWillie Le1969-09-17UHC-73240-85—6908 Oak St, Sacramento, CA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-58422TPAJoshua Hoffman1949-01-03——5706 Desert Sky Blvd, Denver, CO0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-53600TPAMark Park1959-03-08——8718 Church St, Gilbert, AZ0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-55265TPAHeather Graham1970-05-06——7236 Elm St Apt 7, Orlando, FL, 328350.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-61861TPACarl Dominguez—UHC-67933-51—1514 Baseline Rd # 279, Gilbert, AZ, 852240.56Date of birth unreadableUnit split from streetZIP+4 trimmedPlaceholder values cleared
TPA-52048TPAVincent Contreras1992-05-18——5174 Forest Ave, Tucson, AZ, 857320.56Two-digit birth yearZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-61204TPABryan Stevens1978-01-24——2714 Harbor Blvd, Scottsdale, AZ0.56Two-digit birth yearZIP missingGender normalisedPlaceholder values cleared
TPA-54436TPADylan Oliver1958-01-17———0.56Name split from “Last, First”Two-digit birth yearGender normalisedPlaceholder values cleared
TPA-52783TPADon W Walsh1951-05-07—85840136907131 Spring St, Denver, CO, 802430.56Name split from “Last, First”Middle initial moved out of first nameGender normalisedPlaceholder values cleared
TPA-57752TPAAlexanedr O Williams1964-05-18—34152497619121 Lincoln Way, Los Angeles, CA, 900580.56Phone reformattedSSN last four extractedZIP+4 trimmedGender normalised
TPA-53409TPARebecca X Clark1990-06-12—94036390489740 Oak St, Jacksonville, FL, 322080.56Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
TPA-56121TPAJulia Cunningham1954-05-28UHC-98772-34—3668 Spring St, Austin, TX0.56Name split from “Last, First”City re-casedZIP missingGender normalised
TPA-53665TPAMariana Fields1960-11-22——3511 Main St, Phoenix, AZ, 850230.56Name split from “Last, First”State name converted to codeZIP+4 trimmedPlaceholder values cleared
TPA-57624TPAAdam P Dunn———232 Lincoln Way, Atlanta, GA, 303660.56Date of birth unreadableZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-62294TPACarol G Baker1956-10-28——3917 Maple Ave, Houston, TX, 770060.56Two-digit birth yearZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-57131TPAElizabeth Li1954-02-01——3590 Willow Ct, Eden Prairie, MN, 553920.56Two-digit birth yearZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-50405TPAJoan Lane1949-03-16UHC-13637-61—573 Willow Ct # 618, Plano, TX, 750010.56Two-digit birth yearUnit split from streetState name converted to codePlaceholder values cleared
TPA-53171TPALori Williams1984-07-03UHC-29788-7320180010397301 Mountain View Dr, Tempe, AZ, 852130.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
TPA-56447TPARayomnd Nelson1955-03-01——8292 Sunset Blvd Apt 8, Houston, TX, 770580.56Name split from “Last, First”Unit split from streetZIP+4 trimmedPlaceholder values cleared
TPA-57821TPABrenda Santiago1995-01-10—56373279617882 Washington St, Glendale, AZ, 853770.56Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
TPA-55510TPAHenry Pierce2007-07-20——6795 Park Pl # 146, Plano, TX, 750070.56Two-digit birth yearUnit split from streetGender normalisedPlaceholder values cleared
TPA-60422TPASantiago Price1978-05-09UHC-98266-1826329835848949 Mesa Dr Apt 27, Houston, TX, 770590.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
TPA-56474TPAWei Dunn1946-05-02——6309 Lincoln Way # 257, Plano, TX, 750410.56Name split from “Last, First”Two-digit birth yearUnit split from streetPlaceholder values cleared
TPA-60423TPASharon Romero2008-11-02—4672269397633 Park Pl, Orlando, FL, 328970.56Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
TPA-60143TPAAmber Watkins1976-10-16——9383 Baseline Rd, Tempe, AZ0.56Name split from “Last, First”Two-digit birth yearZIP missingPlaceholder values cleared
TPA-55295TPAAdam I Howell————0.56Name split from “Last, First”Date of birth unreadableGender normalisedPlaceholder values cleared
TPA-57805TPAJanice Tucker2005-12-03——1178 Palm Dr, Sacramento, CA, 958250.56State name converted to codeZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-51584TPAEvelyn Ray1941-10-09—23132908121967 Camelback Rd, Eden Prairie, MN, 553300.56Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
TPA-53227TPAJean Edwards1991-12-01UHC-85008-34—4057 Sage Ct Apt 4, Sacramento, CA, 958680.56Name split from “Last, First”Unit split from streetGender normalisedWhitespace trimmed
TPA-57881TPAKelly Park2003-01-04UHC-31870-5421546628014154 Apache Blvd, Las Vegas, NV, 891320.56Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+6 more
TPA-59866TPAGeorge Riley1959-08-20——1602 Elm St # 416, San Antonio, TX0.56Two-digit birth yearUnit split from streetZIP missingPlaceholder values cleared
TPA-53568TPATylre S Alvarez—UHC-06222-1279763808689548 Mountain View Dr # 419, Mesa, AZ, 852420.56Date of birth missingUnit split from streetGender normalisedPlaceholder values cleared
TPA-50523TPAAmy Gonzalez2008-11-09——492 Bayshore Dr, Glendale, AZ, 853090.56Name split from “Last, First”Phone missing area codeZIP+4 trimmedPlaceholder values cleared
TPA-59016TPANicole George2006-06-12——5730 Sunset Blvd # 529, Austin, TX, 787500.56Name split from “Last, First”Unit split from streetGender normalisedPlaceholder values cleared
TPA-57507TPAGerald Hamilton1986-10-02——6006 Spring St Apt 21, San Antonio, TX, 782370.56Two-digit birth yearUnit split from streetZIP+4 trimmedPlaceholder values cleared
TPA-55639TPADanielle Jordan1998-12-05——5513 Market St Apt 18, Phoenix, AZ, 850870.56Name split from “Last, First”Phone missing area codeUnit split from streetPlaceholder values cleared
14,474 rows, page 29 of 290PreviousNext