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-63434TPADiane V Castillo1968-06-08——8444 Camelback Rd, Miami, FL, 331410.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50563TPAKelly James1949-07-15——1768 Maple Ave, Eden Prairie, MN, 553160.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58945TPAHelen D Wright1968-04-24—6238775433—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-59665TPAValentinna Howard1987-04-16——9834 Valley View Dr, San Diego, CA, 921550.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-53662TPASarah P Greene2001-06-16———0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63016TPAJack Smith1974-06-11—8054337199—0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-63015TPAJack Smith1974-06-11—8054337199—0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-57886TPAHirohsi Wheeler1997-03-16———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-61623TPAMark Dean2008-02-14UHC-46621-13——0.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-57255TPAYuki Chapman2002-02-19———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-62365TPADiana Butler1971-10-24———0.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-63611TPAMartha Ruiz1948-04-01UHC-79278-09—5670 Main St, Eden Prairie, MN, 553720.94Name re-casedMember ID reformattedPlaceholder values cleared
TPA-58634TPAAshley Obrien1950-02-12—53967702528933 Ocean Ave, Sacramento, CA, 958660.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-63477TPABrenda Little1942-01-25———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-54829TPALuis Clark1983-08-07——8275 Church St, Columbus, OH, 432640.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-57040TPAArjun Harris1953-10-27———0.94Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-50382TPANoha Yang1974-12-27UHC-48251-04—5747 Jefferson Ave, Scottsdale, AZ, 852310.94Date of birth reformattedState code upper-casedPlaceholder values cleared
TPA-60170TPACynthia Riley1980-06-01——7249 Pine Dr, Seattle, WA, 981540.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-52282TPAKathy Lucas2000-07-16———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-56926TPABradley J Schultz1947-07-05UHC-33435-24——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56050TPANathan L Smith1967-01-13—6572394061—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60904TPANathan Yang1957-05-21———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-57161TPASandra Ortega1980-12-26———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-55584TPAFrank Bennett2007-04-06UHC-90848-74—8560 Park Pl, Miami, FL, 331250.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-50058TPAVincent Ruiz2005-09-28—71937923343625 Church St, Orlando, FL, 328030.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52736TPARachel Scott1967-02-08——3334 Grand Ave, Glendale, AZ, 853940.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53300TPAEmily Aguilar1985-08-05———0.94Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-50297TPAChriistine Cook1958-02-12——2663 Union St, Columbus, OH, 432980.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-59902TPASteve Watkins1956-06-02—5079940693—0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-54560TPAEmma Garza1958-10-10UHC-80361-3564053170549103 Jefferson Ave, Seattle, WA, 981410.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-57254TPANicholas Armstrong1968-08-14——3483 Willow Ct, Tucson, AZ, 857190.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-57319TPADouglas Jones1993-04-21—7159927250—0.94Name re-casedPhone reformattedPlaceholder values cleared
TPA-53490TPADonald Aguilar1950-07-15UHC-95936-49—3963 Mesa Dr, Austin, TX, 787260.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53489TPADonald Aguilar1950-07-15UHC-95936-49—3963 Mesa Dr, Austin, TX, 787260.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61814TPAHenry Moore1968-05-04UHC-30985-928269026935—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-61863TPAHannah Martin1965-05-19——483 Central Ave, Plano, TX, 750190.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-63857TPARobert Miller1984-11-03——4044 Market St, Minneapolis, MN, 554030.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-60042TPAStephanie Payne1974-07-04———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-60620TPASharon Richards1951-01-26—8032546192—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63727TPAYuki S Rios1995-09-05——16 Lake View Rd, Tampa, FL, 336450.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54512TPADylan Bailey1962-07-08——8382 Jefferson Ave, Las Vegas, NV, 891440.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-51039TPAElizabeth Freeman1945-09-03——3288 Valley View Dr, Denver, CO, 802000.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-64314TPAPaul Nguyen1989-02-24——5530 Indian School Rd, Phoenix, AZ, 850280.94State code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-58113TPAOmar Y Evans1971-06-08——3145 Jefferson Ave, Charlotte, NC, 282420.94City re-casedWhitespace trimmedPlaceholder values cleared
TPA-51930TPAFrank Armstrong2001-11-08UHC-20722-59—2103 Forest Ave, Houston, TX, 770160.94Name re-casedWhitespace trimmedPlaceholder values cleared
TPA-50462TPALuis Fernandez2003-04-11UHC-36488-55—604 Lake View Rd, Scottsdale, AZ, 852510.94City re-casedWhitespace trimmedPlaceholder values cleared
TPA-57159TPAJudith Marquez1981-11-21UHC-17399-42—4571 Oak St, Nashville, TN, 372450.94Name re-casedDate of birth reformattedPlaceholder values cleared
TPA-62292TPADylan Cole2004-07-01UHC-93588-472582930050—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59453TPADanielle Yang1982-07-16——9457 Cedar Ln, Gilbert, AZ, 852560.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61259TPABryan Lawrence1938-04-12—87839336576144 Apache Blvd, Atlanta, GA, 303650.94Phone reformattedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 243 of 290PreviousNext