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-57057TPAMarcus Jenkins2000-09-05——1360 Hillcrest Rd, Tampa, FL, 336230.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55956TPAJesse Pierce1947-07-27—91442288484125 Canyon Rd, Tucson, AZ, 857030.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63459TPADiane Le1952-09-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50966TPAOlivia Hart1976-10-26——9622 Highland Ave, Houston, TX, 770170.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62021TPARachel C Flores2006-02-05UHC-97143-2786435665995831 Sunset Blvd, Plano, TX, 750800.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50141TPAJessica Meyer2008-11-21UHC-28846-42——0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63313TPAWillie Chavez1952-10-12——2780 Desert Sky Blvd, Plano, TX, 750960.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-58603TPAGabriel T Perkins1945-04-18——1327 Valley View Dr, Scottsdale, AZ, 852880.80Name re-casedState name converted to codeEmail lower-casedPlaceholder values cleared
TPA-50043TPASofia Lawson1963-09-07——1830 Lake View Rd, Nashville, TN, 372310.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63018TPAJack Hoffman1949-11-27—7876653289—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63968TPADouglas Alexander2006-09-15——2798 Harbor Blvd, Eden Prairie, MN, 553880.80Date of birth reformattedSSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-50720TPAHenry K Powell2008-12-15——9155 Mountain View Dr, Minneapolis, MN, 554420.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57411TPANancy J Contreras1988-02-04——8194 Jefferson Ave, Denver, CO, 802640.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63365TPACrl Sandoval1972-05-01——4525 Ridge Rd, Tucson, AZ, 857600.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61742TPARoy Powell1980-11-27UHC-17581-405032571479482 Broadway, Plano, TX, 750100.80Address re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52124TPAKyle Cruz1970-07-28—74273260304360 Broadway, Glendale, AZ, 853540.80Phone reformattedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-53751TPABilly Rice1949-02-24—3768710180—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51652TPABrittany J Vargas2002-05-22——2068 Union St, Plano, TX, 750880.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-55464TPACatherine Z Long2007-09-16—93465284462761 Jefferson Ave, Mesa, AZ, 852540.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51177TPAWayne Larwence1941-10-10——6617 Hillcrest Rd, Chandler, AZ, 852280.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61015TPARalph Wright1942-07-13—46348176009787 River Rd, Phoenix, AZ, 850640.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
TPA-58114TPAAaron Jones1992-10-01—5204402227—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63698TPAJudy Oliver——60755648459763 Harbor Blvd, Plano, TX, 750890.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54884TPAJoyce N Pierce1945-02-01—91497617603413 Spring St, Scottsdale, AZ, 852620.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63568TPALauren V Peterson2006-01-26——3468 Church St, Fresno, CA, 937840.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54725TPAArthur Santos1960-11-09—37557214816008 Main St, Gilbert, AZ, 852740.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56086TPACarl N Cooper1961-11-02——7817 Maple Ave, Denver, CO, 802940.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58790TPAWayne Davis1956-05-25———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57868TPAVirginia Hart1980-05-04——2284 Central Ave, Glendale, AZ, 853150.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57562TPADorothy Sanders1947-07-13—87843194015954 Bayshore Dr, Orlando, FL0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
TPA-51725TPADorothy Daen1995-03-25UHC-71188-1994765696531245 Broadway, Minneapolis, MN, 554950.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54676TPAKathryn Porter1976-03-17——1943 Broadway, Tucson, AZ, 857740.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-54975TPACheryl Andrews1971-11-24UHC-98602-23—8184 Mountain View Dr, Chandler, AZ, 852630.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53770TPAJanet V Carroll1980-01-11——4277 Elm St, Tucson, AZ0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-55795TPADoothy Valdez1990-02-06UHC-33215-14——0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-59709TPAGlria Brooks1946-03-27——9448 Cedar Ln, Orlando, FL, 328130.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59287TPAEric Castillo1941-01-03——3675 Broadway, Austin, TX0.80Date of birth reformattedAddress re-casedZIP missingPlaceholder values cleared
TPA-51435TPAGreg Romero1958-11-23———0.80Name re-casedDate of birth reformattedPhone missing area codePlaceholder values cleared
TPA-51846TPAJudith Cruz1945-12-27——2981 Highland Ave, Miami, FL, 331730.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63946TPAAndrea Silva1968-07-26———0.80Date of birth reformattedPhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-52160TPAAisha Berry1976-03-07——2814 Oak St, Columbus, OH, 432260.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-59482TPAMadison Moore2001-01-14——6393 Grand Ave, Tempe, AZ, 852600.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57568TPAHarold C Simmons1948-07-21UHC-09892-81—1157 Desert Sky Blvd, Gilbert, AZ, 852270.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63456TPANick Oliver1967-01-18——7570 Lake View Rd, Houston, TX, 770500.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-51670TPAYuki Chavez1950-05-21UHC-73006-24—4998 Camelback Rd, Columbus, OH, 432330.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61362TPAYuki Perez1986-01-19——5798 Elm St, Sacramento, CA, 958460.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51775TPAGary Rice1961-06-26——5578 Pine Dr, Columbus, OH, 432710.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61679TPARandy Clark1989-05-14——4099 Camelback Rd, Miami, FL0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-59423TPAMari Delgado1996-06-14UHC-95248-22—9693 Highland Ave, Nashville, TN, 372850.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55791TPAAlice O Fishher1970-09-28UHC-66476-36—8729 Park Pl, Houston, TX, 770780.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 180 of 290PreviousNext