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-50676TPASamuel Z Mejia2003-07-13——8131 Broadway, Tucson, AZ, 857680.62Name re-casedDate of birth reformattedCity re-casedState name converted to code+3 more
TPA-62257TPARobert Bryant1972-12-14—95842373857085 Maple Ave, Orlando, FL, 328630.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55562TPADorothy Lawson1969-03-21——9381 Harbor Blvd, Scottsdale, AZ0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54152TPANicole Hayes1981-12-01——8810 Cedar Ln, Columbus, OH, 432090.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54882TPAAustin Park1987-07-24——8843 Forest Ave, Seattle, WA, 981310.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52216TPAMark Palmer——53083394971818 Main St Apt 10, Jacksonville, FL, 322080.62Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more
TPA-53066TPAAmanda Simmons1964-04-10——9164 Camelback Rd, Mesa, AZ, 852070.62Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-56649TPAStephanie Morgan1958-01-03UHC-25527-157282108827338 Valley View Dr, Tempe, AZ, 852520.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59678TPARyan Edwards2000-05-08——638 Church St # 701, Gilbert, AZ, 852600.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-61702TPATeresa Elliott1939-11-27——621 Grand Ave, Gilbert, AZ, 852590.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52730TPARandy McCoy1974-02-12—24362700359102 Hillcrest Rd, Denver, CO0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55849TPABrian Ford1998-09-28——3178 Harbor Blvd, Houston, TX, 770710.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-58474TPACheryl Woods1970-12-19——6217 Lake View Rd, Minneapolis, MN, 554480.62Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+3 more
TPA-54680TPACarolyn King1957-07-13—89362651862064 Park Pl, San Antonio, TX, 782710.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52639TPACheryl Fields2002-02-09——1426 Washington St, Nashville, TN, 372870.62Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-55899TPAAmber Alexander1960-05-26—23063840438353 Oak St, Jacksonville, FL0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53168TPAKyle E Lopez1956-05-05UHC-73389-1194420250835858 Sage Ct, Chandler, AZ, 852190.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63142TPABetty Burke1966-02-08—38428066564250 Mountain View Dr, Phoenix, AZ, 850860.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52570TPALori Lee——95591233833574 Mountain View Dr, Phoenix, AZ, 850340.62Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60320TPAJustin Shaw1942-04-02—89660406965769 Oak St, Las Vegas, NV, 891120.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63416TPABobby Jones1990-10-25——8156 Lake View Rd, Austin, TX, 787780.62Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
TPA-63066TPAOlivia Gutierrez1971-06-02——2108 Ocean Ave, Denver, CO, 802370.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-56895TPAMaria Perry1998-12-23UHC-43223-30—8434 Union St, San Diego, CA, 921510.62Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
TPA-61244TPAKelly A Stephens1994-10-12—70272172835799 Main St, Fresno, CA, 937330.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54880TPACynthia Chapman1998-12-22UHC-71505-9274339277675035 Camelback Rd, Glendale, AZ, 853410.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58327TPAFatima Meyer1962-11-01——8894 Main St, Tempe, AZ, 852970.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56095TPAJustin P Montgomery1981-06-01—96822281726366 Pine Dr, Seattle, WA, 981370.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54708TPAHenry Mejia1952-07-19—72223797462554 Union St, Jacksonville, FL, 322370.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54246TPAZachary Hill1958-01-15—25395707307404 Market St, Sacramento, CA, 958050.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-55508TPAEmily U Ford1944-05-25—77995068798358 Valley View Dr, Mesa, AZ, 852040.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-55668TPAKimberly Mitkhell1945-05-18—54694203963292 Indian School Rd, Minneapolis, MN, 554120.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50792TPAJanet Johnson1980-02-22—60885044844171 Lincoln Way, Los Angeles, CA, 900360.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52556TPAAisha Griffin2005-09-04—36678424515361 Elm St, Chandler, AZ, 852290.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-60119TPAChristine N Graham1955-05-24—65980308121820 Mesa Dr, Denver, CO, 802980.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56593TPAEugene Wallace1942-06-16—22073350968878 Baseline Rd, Jacksonville, FL, 322190.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-50796TPAVirginia Vazquez1995-03-27—49754591511472 Willow Ct # 869, Eden Prairie, MN, 553860.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-54272TPAMatthew Jones2002-04-11——9898 Valley View Dr, Los Angeles, CA, 900440.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62737TPAHenry Q Harrison1986-07-18UHC-33101-6835184852807019 Washington St, Chandler, AZ, 852340.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53831TPABryan Wheeler2000-01-22UHC-07444-9673075108359384 Mountain View Dr, Nashville, TN, 372090.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-63125TPADenny Burton—UHC-59639-2186159932469222 Maple Ave, Denver, CO, 802090.62Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55024TPADavid Vega2004-10-25—77421223218748 Grand Ave, Minneapolis, MN, 554590.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53332TPAWillie Robinson1992-04-01—50236899523045 Lake View Rd, Seattle, WA, 981850.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51604TPAChristina Burke1976-06-13—43774237525791 Cedar Ln, Glendale, AZ, 853140.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55797TPALisa Clark1977-03-13—97687688455429 Sunset Blvd, Atlanta, GA, 303360.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57918TPAJanice Greene1986-08-15——3408 Spring St Apt 5, Sacramento, CA, 958290.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-55252TPAEthan Armstrong1970-12-08—56249655768528 Cedar Ln, Seattle, WA, 981820.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63412TPAMichael Wilson1955-10-15——2200 Hillcrest Rd, Dallas, TX, 752480.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-64277TPACharles Nunez1953-05-25——1663 Mesa Dr, Seattle, WA, 981790.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59165TPASara Moore1996-03-26—49672109637068 Market St, Tucson, AZ0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51826TPAMatthew Day1949-03-08—38684583704162 Cedar Ln, Tempe, AZ, 852610.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
14,474 rows, page 46 of 290PreviousNext