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-51818TPAWilliam Garrett1993-12-01—6318431022368 Desert Sky Blvd, Tucson, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61129TPAJordan Mason1963-03-07——9391 Valley View Dr, Nashville, TN, 372910.50Name re-casedDate of birth reformattedState name converted to codeZIP+4 trimmed+3 more
TPA-52323TPARaymond Simmons1972-02-03—57040474185242 Desert Sky Blvd, Nashville, TN, 372040.50Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+3 more
TPA-55813TPANoah Hawkins1976-10-12—47037774603221 Union St, San Antonio, TX, 782860.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59057TPADanielle Vazquez1948-10-27——8681 Grand Ave Apt 37, Atlanta, GA, 303860.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-51609TPAKeith Vazquez1965-05-23——6164 Grand Ave, Scottsdale, AZ, 852990.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-50318TPADiego Holmes1965-05-21——5512 Sage Ct, Scottsdale, AZ, 852380.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-53799TPAVictoria Chen1947-02-23—6924259533925 Ridge Rd, Orlando, FL, 328080.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61175TPAGlooria King—UHC-54429-89—932 Ocean Ave Apt 5, Denver, CO, 802710.50Date of birth reformattedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
TPA-53969TPABilly Le1940-01-19——5795 Baseline Rd, Glendale, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-51486TPADylan Dominguez———3895 Palm Dr, Gilbert, AZ, 852790.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-57531TPAGary Carr1957-05-06UHC-25634-04—9019 Washington St, Scottsdale, AZ, 852090.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55829TPARonald J Snyder1957-07-20——1398 Harbor Blvd, Tampa, FL, 336050.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-60207TPAJose Cook1954-04-10——7755 Union St, Las Vegas, NV, 891040.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-62486TPASophia Morgan1989-01-15——504 River Rd, Houston, TX, 770480.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-54311TPARuth Owens1988-01-27UHC-38282-2124652257098039 Washington St, Houston, TX, 770150.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-64471TPAMargaret Patel1991-06-28—25955169686042 Hillcrest Rd, Austin, TX, 787910.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60209TPASarah Long1977-08-16——2128 Ocean Ave, Nashville, TN0.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-62157TPALinda Smith———6026 Indian School Rd, Tampa, FL, 336090.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-58571TPADoris Fernandez2003-02-04UHC-98369-55—5596 Bayshore Dr Apt 40, Jacksonville, FL, 322680.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-58570TPADoris Fernandez2003-02-04UHC-98369-55—5596 Bayshore Dr Apt 40, Jacksonville, FL, 322680.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-57863TPAAmy Ferguson1944-01-22UHC-39422-0220688950023896 Camelback Rd # 655, Tucson, AZ0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-57260TPARussell C Cunningham1965-09-03——4129 Valley View Dr, Miami, FL, 331910.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51893TPAStephen Y Hicks2003-03-01UHC-10555-56—2494 Oak St, Austin, TX0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-50470TPAGloria Stone1954-03-28——7547 Broadway, Seattle, WA, 981410.50Address re-casedCity re-casedState name converted to codeZIP+4 trimmed+3 more
TPA-60498TPAJoyce Soto1969-09-28——3811 Church St, Atlanta, GA, 303430.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-58242TPACarol Siingh——57526743345749 Canyon Rd, Las Vegas, NV, 891070.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
TPA-63569TPABrittny Banks1948-07-03—9155051099493 Camelback Rd, Orlando, FL, 328580.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50381TPASandra Medina——36783362412837 Willow Ct, Las Vegas, NV, 891580.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
TPA-62934TPAAllice Gibson1952-08-03—95695657043399 Palm Dr, Los Angeles, CA, 900620.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64274TPARussell Mitchell1992-05-13——5643 Washington St, Chandler, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-53328TPABeverly Harris2002-03-03—29197549791193 Apache Blvd, Scottsdale, AZ, 852110.50Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-58331TPAEthan Perry2007-06-27UHC-68803-96—124 Park Pl, Eden Prairie, MN, 553570.50Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
TPA-55115TPAAhmed Patel2005-02-09UHC-86063-13—7258 Apache Blvd Apt 7, Austin, TX, 787660.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-56270TPAWeber Danielle1961-11-12—46936340009546 Valley View Dr, Scottsdale, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-60295TPAHiroshi A Greene1999-03-25——2623 Maple Ave, Las Vegas, NV, 891760.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
TPA-50080TPAAlbert Mongomery1971-02-03——7534 Cedar Ln, Glendale, AZ0.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-55544TPASadra Nelson1965-05-01——699 Desert Sky Blvd, Fresno, CA, 937710.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-64095TPAJacqueline Sandoval1955-11-17UHC-05415-4870521892751902 Canyon Rd, Dallas, TX, 752370.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-53566TPACarlos M Thomas1983-01-24——1777 Highland Ave, Houston, TX, 770340.50Name re-casedDate of birth reformattedState name converted to codeZIP+4 trimmed+3 more
TPA-63089TPAHeather Rodriguez1942-02-16—3008083557460 Washington St, Mesa, AZ, 852760.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-52904TPANancy Andrews1983-12-26——627 Grand Ave, Glendale, AZ, 853550.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-57953TPARachel Q Jacobs1997-04-04——8448 Camelback Rd # 179, Gilbert, AZ, 852060.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
TPA-61080TPAPaul Price2001-03-20—80321902906131 Jefferson Ave, Glendale, AZ, 853250.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50914TPAJack Arnold1950-10-23——6818 Spring St, Columbus, OH, 432760.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58836TPAMark Lewis1995-06-14——1859 Indian School Rd Apt 6, Austin, TX, 787660.50Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-56013TPADavid Luna1939-04-12——6507 Sunset Blvd Apt 37, Orlando, FL0.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53337TPADiana I Oilver2002-03-10—90454526547663 Maple Ave # 921, Columbus, OH, 432220.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-59202TPAJessica Romero1959-11-02—60481155142273 Lincoln Way, Nashville, TN, 372640.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50243TPABryan Valdez1986-09-17——5624 Canyon Rd, Columbus, OH, 432730.50Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
14,474 rows, page 17 of 290PreviousNext