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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-57193TPAKeith Hart1964-11-11———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59598TPAOlivia Duncan1978-10-22—37233055995226 Baseline Rd, Tampa, FL, 336460.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-54211TPAGarzza Justin1950-05-24—82678318883979 Park Pl, Columbus, OH, 432160.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-52700TPAWillie Harrison1989-05-04—75529473119217 Bayshore Dr, Las Vegas, NV, 891050.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56174TPAJudith Foster1972-07-03——6667 Elm St, Dallas, TX, 752430.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-51796TPAZechary Luna1949-03-04———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56243TPAKyle Wood2004-12-11—3376941410—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53642TPALisa Morris1996-08-12—2968291428—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51405TPAKayla Ferguson2005-06-19—65349575063533 Grand Ave, Las Vegas, NV, 891180.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-56637TPAMarthha Rogers1942-10-09UHC-97687-2570482123137733 Jefferson Ave, San Antonio, TX, 782130.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-53149TPAAna Price1949-12-07—5512031933605 Broadway, Jacksonville, FL, 322570.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-59090TPAKelly F Johnston1938-07-09———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62421TPAJames V Hunt1968-06-25——9300 Broadway, Eden Prairie, MN, 553940.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62422TPAJames V Hunt1968-06-25——9300 Broadway, Eden Prairie, MN, 553940.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50690TPALuis Mejia1977-02-19——3420 Ridge Rd, Phoenix, AZ, 850290.92Date of birth reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-51388TPAAlice T Black1953-05-07—3579543916—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-56225TPAEstrada Walter1990-03-23———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56298TPAJoey Nunez1942-07-07——219 Broadway, San Antonio, TX, 782640.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-59112TPACaarlos Dean1907-08-04—21145327301314 Grand Ave, Minneapolis, MN, 554060.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52757TPAWilliam Stewart1976-08-11———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59476TPADonald Stewart2000-07-06—2256334194—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-63974TPAChristian D Wells1946-07-26—3745466544—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62283TPAMichelle Harper1952-04-17——3693 Union St, Plano, TX, 750800.92Name re-casedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-62519TPAFrances Berry1968-02-08UHC-64195-372047033326384 Highland Ave, Minneapolis, MN, 554060.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54819TPACook Laura2002-07-27—4072963645740 Harbor Blvd, Chandler, AZ, 852530.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-55233TPAValentina Carr1981-10-14—22934091921326 Elm St, Chandler, AZ, 852980.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-54419TPAAisha Chen1944-10-03——5831 Sage Ct, Sacramento, CA, 958080.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-64137TPAJoshua A Griffin1945-12-20——473 Valley View Dr, Orlando, FL, 328510.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50637TPAKayla Sims1987-05-14——7655 Washington St, Atlanta, GA, 303710.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61332TPAKenneth Y Delgado1956-05-01—8342968675254 Palm Dr, Dallas, TX, 752680.92Phone reformattedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-51320TPAKimberly Parker2002-12-14—88167681767164 Elm St, Chandler, AZ, 852270.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-55141TPAAdam Alvarado1941-02-23—5938996010—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53776TPAAisha Garza2000-11-19——6081 Sunset Blvd, Gilbert, AZ, 852550.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54562TPAAnna C Dunn1979-05-15—2574782374—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-57550TPALisa Hernandez1992-11-25—98555473604517 Grand Ave, San Antonio, TX, 782070.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58032TPAWilliam Weaver1971-07-06——2512 Church St, Houston, TX, 770150.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52021TPALinda Gomez1994-04-14UHC-48209-83—8638 River Rd, Jacksonville, FL, 322510.92Date of birth reformattedMember ID reformattedCity re-casedPlaceholder values cleared
TPA-56947TPACamila A Marshall1956-12-09—33470205236341 Baseline Rd, Phoenix, AZ, 850660.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50610TPAScott Evans1939-08-08UHC-99603-387517417209—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59552TPAAlan Bradley1971-09-10—44951704825458 Oak St, Tampa, FL, 336330.92Phone reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-58076TPATeresa Yang2006-01-17UHC-39400-12——0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50733TPACarl King1958-02-06UHC-56378-01—6441 Mesa Dr, Houston, TX, 770500.92Name re-casedMember ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-51035TPAGerald Gray2004-02-11—7447936070—0.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-53114TPAValentina Wheeler1944-03-26—4327964908—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58832TPAMargaret Bailey1954-01-26———0.92Name re-casedDate of birth reformattedEmail lower-casedPlaceholder values cleared
TPA-50256TPALauren Simmons1949-09-13—9387382916—0.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-51173TPALucia L Gonzales1955-04-17—3995271271—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61919TPABarb O Pierce1952-03-18——9542 River Rd, Houston, TX, 770510.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52033TPASandra Stone1951-02-12—77063314218768 Church St, San Diego, CA, 921500.92Phone reformattedCity re-casedPlan code upper-casedPlaceholder values cleared
TPA-62549TPAJuan Wright1992-08-07———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 232 of 290PreviousNext