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-55511TPAHenry Pierce2007-07-20—91791386926795 Park Pl, Plano, TX, 750070.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55687TPAHeather Chapman1981-12-02——7036 Park Pl, Minneapolis, MN, 554180.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51489TPACarlos Hanson1971-09-03—43448812174864 Indian School Rd, Houston, TX, 770370.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63680TPAJacqueline Rojas1950-04-05——4836 Main St, Sacramento, CA, 958240.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-63045TPAJames Mitchell1940-05-27——8842 Highland Ave, Sacramento, CA, 958950.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59611TPAMaria Mejia1995-03-27——5526 Spring St, Mesa, AZ, 852270.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54349TPAOmar Wong1952-11-11—23723757068933 Mesa Dr, Minneapolis, MN, 554580.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63233TPAJessica Scott1971-03-12——2188 Hillcrest Rd, Gilbert, AZ, 852740.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62034TPAAlex King1974-02-01UHC-17995-02—2968 Main St, Phoenix, AZ, 850710.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61577TPAWalter Reyes1992-04-13UHC-60664-75—3935 Lake View Rd, Seattle, WA, 981410.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60315TPANathan T Robinson1956-07-18—25332325306682 Ridge Rd, Glendale, AZ, 853840.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59880TPALori Porter1946-02-14UHC-02218-8826586489818225 Grand Ave, Plano, TX, 750620.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53877TPACharlotte Alexander1997-04-13——8547 Mountain View Dr, Nashville, TN, 372870.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51440TPAGerald Robertson1997-03-28UHC-86460-12—7199 Camelback Rd, San Diego, CA, 921270.78Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60819TPARoger S Nguyen1992-02-06—45673290414735 Central Ave Apt 19, Eden Prairie, MN, 553550.78Name re-casedDate of birth reformattedPhone reformattedUnit split from street+1 more
TPA-63654TPACharlotte Y Jacobs1945-06-27——4117 Ridge Rd, Gilbert, AZ, 852510.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50492TPA—Junk2001-05-09UHC-12085-61—5526 Central Ave, Los Angeles, CA, 900720.78Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared+1 more
TPA-54278TPARuth Cole1966-12-16——2598 Broadway, Jacksonville, FL, 322320.78Date of birth reformattedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-63877TPARobert Simpson1941-06-15——9634 Sage Ct, Mesa, AZ, 852560.78Date of birth reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-62698TPAJulie Henry2003-09-22UHC-63032-0573126801134006 Valley View Dr, Atlanta, GA, 303100.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60148TPAKaren Green1953-06-27—67261323241578 Camelback Rd, Dallas, TX, 752980.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57761TPACharles Wilson2006-01-02—86259415703100 Lincoln Way Apt 23, Los Angeles, CA, 900770.78Date of birth reformattedPhone reformattedUnit split from streetWhitespace trimmed+1 more
TPA-62057TPASantyago Gardner2002-05-23UHC-38477-5959746035651820 Spring St, Las Vegas, NV, 891130.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58450TPASamuel Salazar1980-09-13——8284 Harbor Blvd, Sacramento, CA, 958510.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52599TPASusn Matthews1960-06-04—40993105992622 Meadow Ln Apt 22, Austin, TX, 787420.78Date of birth reformattedPhone reformattedUnit split from streetWhitespace trimmed+1 more
TPA-62148TPAWayne Williamson1983-05-16——4055 Apache Blvd, Seattle, WA, 981840.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60497TPAJoyce Soto1969-09-28——3811 Church St, Atlanta, GA, 303430.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-62631TPAMeissa Valdez1958-04-10UHC-92566-61—1948 Lincoln Way # 128, Fresno, CA, 937400.78Member ID reformattedUnit split from streetPlan code upper-casedWhitespace trimmed+1 more
TPA-52701TPACamila Silva1938-04-14UHC-53560-35—489 Highland Ave, Austin, TX, 787780.78Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55588TPAJustin Wilson1974-03-27—95046258765123 Camelback Rd, Plano, TX, 750010.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53196TPAHiroshi Harper2008-03-06—77462665306123 Baseline Rd, Nashville, TN, 372030.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53374TPAEugene H Kelly1976-07-07——1751 Valley View Dr, Miami, FL, 331480.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-63546TPAOlivia Hawkins1955-07-12—55351519073492 Maple Ave, Columbus, OH, 432170.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61033TPAMei Baileey1966-11-09UHC-36377-3451655658881353 Desert Sky Blvd, Tampa, FL, 336320.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-56212TPAMaria Jordan1956-08-02—52451934199605 Cedar Ln, Austin, TX, 787450.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51822TPAGeorge Lewis2005-02-23—54175942272058 Sage Ct, Houston, TX, 770170.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51821TPAGeorge Lewis2005-02-23—54175942272058 Sage Ct, Houston, TX, 770170.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50601TPAMason Guzman1965-07-26——9687 Oak St, Miami, FL, 331660.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53347TPAAbiail Herrera2007-08-01—56252697746743 Central Ave, Las Vegas, NV, 891140.78Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-55051TPAEric Butler1965-07-03——8200 Maple Ave, San Antonio, TX, 782170.78Name split from “Last, First”Date of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-60428TPAGrace Williams1977-04-18—22323743359067 Highland Ave, Jacksonville, FL, 322330.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54088TPAJesse Hernandez2008-10-08UHC-40678-60—2780 Forest Ave, Chandler, AZ, 852470.78Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60992TPAStephanie Collins1974-08-04—27893219867857 Ridge Rd, San Antonio, TX, 782800.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52837TPALiz McDonald1992-08-18——8972 Broadway, Tucson, AZ, 857190.78Name re-casedTwo-digit birth yearAddress re-casedWhitespace trimmed+1 more
TPA-58353TPAMartha Boyd1977-06-20———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-54253TPAMei Johnson1978-02-23UHC-36165-0936376108234634 River Rd, Plano, TX, 750890.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59847TPALaura Jordan1944-05-14—35194498711051 Jefferson Ave, Scottsdale, AZ, 852180.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53076TPADeborah Bnks1964-01-22——8093 Oak St, Phoenix, AZ, 850220.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60956TPAMartha B Russell1986-09-26——8647 Desert Sky Blvd, Orlando, FL, 328960.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53440TPAElizabeth Stevens1993-01-09——3674 Maple Ave, Minneapolis, MN, 554090.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 138 of 290PreviousNext