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-53250TPABobby Alexander2003-03-28——711 Mountain View Dr, Tempe, AZ, 852420.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-62962TPAValentina Stevens1943-01-26——5643 Meadow Ln, Eden Prairie, MN, 553580.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60947TPAAmy Oliver1964-04-19—74255859216412 Meadow Ln, Columbus, OH, 432780.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52542TPADennis Harris1939-08-08——5864 Main St, San Antonio, TX, 782620.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54319TPAElijah Hanson2003-03-04—2764045252119 Indian School Rd, Jacksonville, FL, 322000.80Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed
TPA-54320TPAElijah Hanson2003-03-04—2764045252119 Indian School Rd, Jacksonville, FL, 322000.80Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed
TPA-60616TPARussell Barnes2003-02-11——2745 Sunset Blvd, Tempe, AZ, 852980.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52876TPAEvelyn Kenndy2008-02-27——2565 Willow Ct, Chandler, AZ, 852870.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60945TPAJose T Patterson1982-09-22UHC-60006-41—9395 Sunset Blvd, Houston, TX, 770660.80Member ID reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53901TPAKevin Rice———8670 Main St, Chandler, AZ, 852650.80Date of birth reformattedDate of birth unreadableCity re-casedPlaceholder values cleared
TPA-58820TPAMartha Castro1946-08-12—51380289638370 Mountain View Dr, Houston, TX, 770970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51149TPAAlan Jacbs——3645787610—0.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
TPA-56902TPAPamela Lucas1941-05-22——1250 Church St, Mesa, AZ, 852750.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62601TPAVictoria Hart1977-07-08—8102738134660 Union St, San Antonio, TX, 782720.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52079TPAKatherine Knight2001-03-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55786TPASamuel Lynch1981-12-12——689 Market St, Plano, TX, 750950.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-55094TPAAlice Harrison1996-04-08———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62352TPARuth X Jacobs2004-07-10—5176505849—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-60310TPAHannah Vazquez2008-07-21—46857756225714 River Rd, Dallas, TX, 752950.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60311TPAHannah Vazquez2008-07-21—46857756225714 River Rd, Dallas, TX, 752950.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62342TPAZachary Hudson1945-10-16UHC-02373-58—7794 Valley View Dr, Las Vegas, NV, 891670.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55486TPAGloria Meyer1998-04-17——1137 Pine Dr, Houston, TX0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-63116TPARachel U Baker2006-10-24——4703 Ocean Ave, Tucson, AZ, 857070.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61308TPAAhmed Li1952-05-11—80793696139424 Park Pl, Eden Prairie, MN, 553610.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62910TPALisa Taylor1983-09-14UHC-20686-86—1069 Baseline Rd, Eden Prairie, MN, 553890.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53180TPAWei Day1964-04-22——3556 Baseline Rd, Seattle, WA0.80City re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-50768TPASamantha Contreras1946-02-09——9591 Broadway, Glendale, AZ0.80Address re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-56887TPAJoan Thompson1941-10-28——9680 Hillcrest Rd, Scottsdale, AZ, 852250.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61634TPAEugene Grant1972-01-10—27481872263969 Palm Dr, Eden Prairie, MN, 553950.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-57788TPANancy Williams1983-09-13——4029 Harbor Blvd Apt 32, Dallas, TX, 752250.80Unit split from streetCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-62669TPAJacqueline Reid2004-11-04UHC-57895-2377193435178207 Cedar Ln, Sacramento, CA, 958800.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61019TPACarol C Meyer1979-07-21——3897 Camelback Rd, Nashville, TN, 372650.80Phone missing area codeCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-60595TPACarl U Bennett1968-11-07——9430 Sage Ct, San Antonio, TX, 782670.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53906TPABrittany Shaw1945-07-24——3694 Church St, Las Vegas, NV, 891270.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63965TPAKathleen Duncan1977-11-23——8069 Union St, Tempe, AZ, 852370.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63282TPAFrances Ward1952-09-13—94844470295381 Lincoln Way, Fresno, CA, 937020.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60964TPAMaria Weaver1980-05-17—4365975469—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55365TPAEvelyn Gonzales1962-02-20——942 Valley View Dr, San Antonio, TX, 782740.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55366TPAEvelyn Gonzales1962-02-20——942 Valley View Dr, San Antonio, TX, 782740.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54134TPAJennifer Larson1989-06-21—26553301944725 Elm St, Phoenix, AZ, 850480.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-56420TPAGloria X Bailey1959-02-20——8919 Indian School Rd, Los Angeles, CA, 900300.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60200TPAAna Nunez2003-12-07——183 Main St, Orlando, FL, 328400.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52464TPADennis Lawson1939-01-09——7739 Desert Sky Blvd, Glendale, AZ, 853110.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53919TPASamuel Jymenez1953-04-02UHC-67719-04——0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64140TPADina Harris1992-03-11——6494 Mesa Dr, Miami, FL, 331540.80Name re-casedTwo-digit birth yearCity re-casedPlaceholder values cleared
TPA-50961TPAChristina Bradley1958-08-26——934 Apache Blvd, Plano, TX0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-53297TPAJeffrey Jensen1965-08-17——6869 Willow Ct, Tempe, AZ, 852870.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-60737TPALucia Peters1947-02-01——8035 Canyon Rd, Houston, TX, 770320.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57225TPALori Lee1943-09-07——7843 Sunset Blvd, Scottsdale, AZ, 852610.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-58657TPADavid Hoffman1974-11-01—76861785139643 Camelback Rd, Nashville, TN, 372980.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 161 of 290PreviousNext