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-63149TPAArthur Watkins1939-08-05—7128919772—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60267TPAGrifffin U Pamela1985-08-14—66886918628907 Camelback Rd, Tempe, AZ, 852100.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54285TPACarlos Gonzalez2004-10-12—3434173094—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58629TPABradley Patterson1990-01-05——859 Valley View Dr, Scottsdale, AZ, 852410.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60854TPAJanice Jordan1966-03-24——774 Washington St, Nashville, TN, 372750.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-64462TPAEugene Graham1950-06-16——7226 Oak St, Atlanta, GA, 303430.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54037TPACynthia Elliott2007-09-02——9248 Sage Ct, San Antonio, TX, 782000.80Name re-casedTwo-digit birth yearCity re-casedPlaceholder values cleared
TPA-51201TPAJustin Ramos1962-01-11——4154 Valley View Dr, Glendale, AZ, 853270.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58911TPAJean Carroll1993-10-12—85959806521545 Canyon Rd, Minneapolis, MN, 554330.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61911TPAJack Henry2007-09-06—2535758250—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-62774TPASusan Z Barnes1999-01-17—28941371189887 Lincoln Way, Seattle, WA, 981490.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
TPA-55974TPAJacqueline Padilla1984-07-25——8450 Cedar Ln, Fresno, CA, 937820.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62977TPADeborah Ward1989-10-07—6374497703—0.80Phone reformattedSSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-60066TPAJoe Rivera———8364 Camelback Rd, Gilbert, AZ, 852590.80Date of birth unreadableCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-51716TPAAhmed V Bowman1944-07-28UHC-82494-64——0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63053TPACarol Shaw2002-10-06—54471739921968 Willow Ct, Orlando, FL, 328260.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58304TPACamila Tran1958-03-13——1343 Forest Ave, Phoenix, AZ, 850320.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-55186TPAJessica Valdez1954-05-06—84647086954450 Park Pl, Mesa, AZ, 852970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63757TPAKenneth Ryan1938-12-17——5284 Washington St, Atlanta, GA, 303390.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57649TPAJudith Castro1946-06-18——9281 Baseline Rd, San Diego, CA, 921800.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54955TPADiego S George1962-07-15——251 Apache Blvd, Tucson, AZ, 857920.80Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-62469TPATim Walker1987-09-04—5833028834—0.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
TPA-52086TPAMaria Ray1984-02-16——6515 Market St, Glendale, AZ, 853090.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59405TPACharles V Evans1976-10-02—74020855912088 Broadway, Glendale, AZ, 853750.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-58655TPAChristine Clark1968-02-23——4908 Elm St, Los Angeles, CA, 900110.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-63517TPAKimberly P Vega1961-03-18——9577 Spring St, Nashville, TN, 372170.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53557TPARyan E Robinson1946-08-04—54483388111897 Ocean Ave, Houston, TX, 770810.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52324TPARonald H Campbell2006-09-20——4839 Valley View Dr, Orlando, FL, 328280.80Name re-casedDate of birth reformattedState name converted to codePlaceholder values cleared
TPA-50095TPAAlice Le———4656 Hillcrest Rd, Glendale, AZ, 853820.80Date of birth unreadableState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-61983TPAFatima Y Fisher——57630133318668 Oak St, San Diego, CA, 921210.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
TPA-62008TPAJennifer Lee1984-05-11—24168926422678 Palm Dr, Nashville, TN, 372560.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50260TPAKatherine Sanders1987-01-25UHC-96221-61—7744 Sage Ct, Los Angeles, CA, 900440.80Member ID reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51754TPANicholas Cox1943-10-01——3321 Spring St, Sacramento, CA, 958830.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-55745TPAWillie Moore1998-03-23——6226 Ocean Ave, Eden Prairie, MN, 553360.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55852TPAKevin Thompson1948-01-11—39945314562487 Maple Ave, Charlotte, NC, 282600.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62430TPARuth Meyer2004-06-19——8704 Central Ave, Glendale, AZ, 853410.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52123TPARonald Sims1980-04-26——6616 Jefferson Ave, Eden Prairie, MN, 553720.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57025TPABrenda Harper1940-05-15——7291 Ocean Ave, Mesa, AZ, 852540.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57633TPAMarilyn Holmes1944-08-12——7708 River Rd, San Diego, CA, 921640.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58105TPAJoshua Contreras1959-04-17——8975 Ocean Ave, Denver, CO, 802710.80Date of birth reformattedPhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-63665TPARoger Santiago1988-10-20—31245288016341 Market St, Columbus, OH, 432150.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50853TPABrrittany Warren2008-09-09UHC-22159-07—4501 Park Pl, Austin, TX, 787210.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62494TPABeverly Ross1960-07-26—33968993588373 Hillcrest Rd, Eden Prairie, MN, 553700.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52685TPAGregory Boyd1959-04-06——9511 Harbor Blvd, Scottsdale, AZ, 852030.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61731TPAMatthew Spencer2002-08-26—5719070427—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60717TPARalph Santiago1964-01-11—2875128451—0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53636TPAElizabeth Ramirez2003-01-11——2787 Indian School Rd, Austin, TX, 787410.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-58290TPAAlice Herrera1980-06-25—75175546934802 Camelback Rd, Tucson, AZ, 857830.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-54995TPASndra Clark1967-09-06——9762 Apache Blvd, Gilbert, AZ, 852600.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63771TPAAndrew Obrien1947-01-13—73330749388424 Lincoln Way, Columbus, OH, 432650.80Name re-casedSSN last four extractedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 178 of 290PreviousNext