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-63813TPAKimberly Hill1945-12-18——6792 Ocean Ave, Mesa, AZ, 852340.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51857TPABruce Nihols1943-10-11——7296 Indian School Rd, San Antonio, TX, 782340.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55245TPASarah Dean1997-09-15UHC-11137-949206799707510 Ocean Ave, Fresno, CA, 937300.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53271TPANicole Perez1957-11-16UHC-65117-46—4434 Indian School Rd, San Diego, CA, 921690.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52593TPAJames Barnes1989-12-07——7584 Indian School Rd, Tampa, FL, 336410.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61715TPABryan Pena1961-08-26UHC-12094-4548598015556885 Market St, Houston, TX, 770410.76Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
TPA-60596TPANicholas Robertson1948-05-21—48476392158153 Jefferson Ave, Glendale, AZ, 853110.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55894TPASamuel Obrien2000-10-08—60037059178778 Oak St, Tampa, FL, 336930.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-56977TPABetty Hunt1970-08-20—58762798052562 Indian School Rd, Tucson, AZ, 857430.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62185TPAJanet S Vasquez1993-06-15—6954664670154 Desert Sky Blvd, Dallas, TX, 752020.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60203TPAGrace Montgomery1984-02-21——592 Mountain View Dr, Fresno, CA, 937790.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63236TPATerry Henderson1940-10-05—44331820874042 Desert Sky Blvd, Los Angeles, CA, 900910.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58631TPAHannah Morales2008-03-17—63631609433620 Main St, Atlanta, GA, 303160.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62828TPABrenda Green1966-08-06UHC-46437-6024646199234014 Canyon Rd, Eden Prairie, MN, 553480.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62673TPARebcca Chavez1950-01-16—72632545875053 Pine Dr, Houston, TX, 770450.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57902TPAValentina Hayes1952-04-28——6380 Washington St, Scottsdale, AZ, 852290.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-55433TPAShirley Harris1994-07-02—51578815963593 Grand Ave, Plano, TX, 750060.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57258TPAYuki Ward1948-12-23——4400 Central Ave, Miami, FL, 331320.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55587TPAJustin Wilon1974-03-27——5123 Camelback Rd, Plano, TX, 750010.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50593TPAJacob Rivera1983-11-28—60326771571216 Lincoln Way, Mesa, AZ, 852380.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63967TPAKathleen Duncan1977-11-23——8069 Union St, Tempe, AZ, 852370.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55470TPAAustin Robertson1968-11-08——169 Valley View Dr, Gilbert, AZ, 852840.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63285TPAValenitna Owens1974-11-25—94032061018420 Jefferson Ave, Nashville, TN, 372320.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61559TPAAlexander C Chavez1961-04-07—69036608172654 Oak St, Orlando, FL, 328750.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51971TPAHeather O Griffin1987-08-11—82482290928521 Palm Dr, Jacksonville, FL, 322780.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52680TPADouglas Sandoval2006-06-15—30894982366971 Ocean Ave, Las Vegas, NV, 891220.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57052TPABruce Steves2003-02-23UHC-19250-7486583876044915 Broadway, Tucson, AZ, 857780.76Date of birth reformattedPhone reformattedCity re-casedZIP+4 trimmed+2 more
TPA-52635TPALawrence W Jymenez2008-09-25—92932181248191 Valley View Dr, San Antonio, TX, 782800.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60379TPAEthan K Phillips1996-03-07UHC-99113-4755399811868497 Oak St, Gilbert, AZ, 852820.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58225TPACynthia Allen1997-05-24—63021110769695 Sunset Blvd, Eden Prairie, MN, 553970.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58226TPACynthia Allen1997-05-24—63021110769695 Sunset Blvd, Eden Prairie, MN, 553970.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59359TPADiego Holmes1973-12-01—77727564591427 Palm Dr, Tempe, AZ, 852410.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52665TPAHelen Olivver1953-06-11——7373 Hillcrest Rd, San Antonio, TX, 782680.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57412TPAMarilyn Elliott1984-12-08—98429088165553 Lake View Rd, Gilbert, AZ, 852530.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-54651TPAJudy Jimenez1997-08-13——8620 River Rd, Phoenix, AZ, 850700.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55497TPAMateo Turrner1939-03-07UHC-46506-1437582015138032 Mesa Dr, Scottsdale, AZ, 852240.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62937TPAAustin U Jensen1945-08-06——6006 Church St, San Diego, CA, 921790.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51346TPAMelissa Thompson1990-08-26—92935557099669 Valley View Dr, Orlando, FL, 328890.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62798TPAMark Miiller1999-06-21——1632 Union St, Austin, TX, 787410.76Date of birth reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
TPA-59092TPAKelly Johnston1938-07-09—73965763772944 Union St, Nashville, TN, 372640.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62851TPAStephanie Ruiz1960-09-07——7665 Mesa Dr, Los Angeles, CA, 900930.76Name re-casedDate of birth reformattedZIP+4 trimmedPlan code upper-cased+2 more
TPA-56901TPAMason Castro1957-09-28——4926 Main St, Austin, TX, 787680.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59210TPAMariana W Herrera1990-03-11UHC-32984-29—5692 Maple Ave, Plano, TX, 750140.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57137TPAMaria Chen2006-10-09——5649 Elm St, Eden Prairie, MN, 553450.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51697TPAAshley Thompson1961-04-11——5781 Broadway, Miami, FL0.76Name re-casedDate of birth reformattedAddress re-casedZIP missing+2 more
TPA-62969TPAJustin Mason1995-11-28—29483133312849 Grand Ave, Denver, CO, 802320.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54747TPASamuel Marshall2008-01-11—9107025386185 Union St, Columbus, OH, 432420.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54148TPAAndrew O Vargas2000-03-18——1220 Baseline Rd, Los Angeles, CA, 900650.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60615TPARussell Barnes2003-02-11—47178325753123 Forest Ave, Seattle, WA, 981600.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60930TPAMarcus Griffin1955-02-22—48258790456506 Spring St, Phoenix, AZ, 850000.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 112 of 290PreviousNext