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-64289TPAAmanda Yang1941-10-25—25752234607632 Pine Dr, Dallas, TX, 752550.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59443TPARoger Sullivan1941-01-21——9235 Hillcrest Rd, Glendale, AZ, 853850.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62823TPAPeter Garrett———1338 Bayshore Dr, Scottsdale, AZ, 852290.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-61931TPAMadison Dean1972-12-12—3164987718—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-59620TPAStephanie Campbell1952-03-26———0.80Date of birth reformattedEmail lower-casedGender normalisedPlaceholder values cleared
TPA-56148TPAMason Rios1950-09-14—22082205288770 Washington St, Glendale, AZ, 853400.80Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased
TPA-57231TPAOlyvia Maldonado1959-04-02———0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-63306TPALinda Watson2005-10-21—38089617333703 Park Pl, Minneapolis, MN, 554930.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55121TPAKimberly Webb2001-10-11——1437 Grand Ave, Nashville, TN, 372920.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51892TPARaymond Hanon1990-05-20——3321 Grand Ave, Atlanta, GA, 303880.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50421TPASantiago J Reid1991-05-21——8160 Willow Ct, Sacramento, CA, 958740.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-60555TPAKatherine Wilson1969-09-03——2813 Market St, Eden Prairie, MN, 553300.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-50760TPAAbigail W Snyder1970-01-20—4774688648565 Ocean Ave, Plano, TX, 750870.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59019TPACharlotte Y Murphy1944-06-28——5478 Main St, Phoenix, AZ, 850350.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53911TPAHelen Freeman2000-03-19——712 Main St, San Antonio, TX, 782990.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51261TPAAlbert Hunt1939-04-27——843 Church St, Plano, TX, 750620.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-59409TPASantiago Green1998-04-02——6800 Canyon Rd, Columbus, OH, 432160.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52444TPAMaria Nguyen2003-04-02——4081 Willow Ct, Phoenix, AZ, 850300.80Date of birth reformattedSSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-57605TPAMadison C Brooks1958-05-25——3536 Palm Dr, San Diego, CA, 921330.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51526TPADanielle Bradley1946-04-12———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-63188TPAElizabeth Robinson1969-10-07——6194 Bayshore Dr, Gilbert, AZ, 852370.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-64161TPAIsabella Dominguez2001-11-14——3224 Union St, Orlando, FL, 328500.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60714TPALucia Castro1956-03-02—56765915197981 Broadway, Scottsdale, AZ, 852510.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-60713TPALucia Castro1956-03-02—56765915197981 Broadway, Scottsdale, AZ, 852510.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-58297TPAAnthony Taylor2004-02-11——1177 Sage Ct, San Antonio, TX, 782080.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60799TPAKyle Li1941-10-02——1629 River Rd, Tucson, AZ, 857240.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55897TPAAmber Alexander1960-05-26—2306384043—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-56528TPAChristine Garcia1961-03-06——2995 Broadway, Minneapolis, MN, 554770.80Name re-casedDate of birth reformattedState name converted to codePlaceholder values cleared
TPA-54046TPARussell Johnson1965-07-17—48039643517387 Oak St, Los Angeles, CA, 900520.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-60857TPAJerry Perkins1960-02-18——1106 Mesa Dr, Nashville, TN, 372120.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60858TPAJerry Perkins1960-02-18——1106 Mesa Dr, Nashville, TN, 372120.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61626TPAAbigail Price—UHC-79699-27—2730 Desert Sky Blvd, Tempe, AZ, 852450.80Date of birth missingCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-60676TPASue Vazquez2007-09-06UHC-84134-2232069877617588 Apache Blvd, Eden Prairie, MN, 553780.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60175TPARandy Washington1980-02-03—36370718961243 Maple Ave, Seattle, WA, 981150.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50282TPAHarold McDonald2006-09-18UHC-00925-10—1397 Bayshore Dr, Orlando, FL, 328320.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54229TPADiane Perry1972-06-28UHC-44965-8920637607345899 Union St, Phoenix, AZ, 850950.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59504TPAAndrea Grant1989-02-09—62424160084241 Baseline Rd, Dallas, TX, 752700.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53587TPAPhilip Bleck1955-02-06UHC-68692-4781834310321873 Forest Ave, Houston, TX, 770150.80Phone reformattedMember ID reformattedCity re-casedGender normalised
TPA-54876TPABrian Powelll1972-03-11—65532986273245 Main St, Denver, CO, 802550.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55847TPAJudith Henry1968-07-02—94124182207256 Willow Ct, Fresno, CA, 937880.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
TPA-53768TPAJerry Lawson1992-06-03—5596205988—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51029TPAJames Chen1961-02-13——2201 River Rd, Tucson, AZ, 857040.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55848TPAAmy Martin1982-07-04———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57772TPAKaren Allen1986-09-15UHC-05227-85—3484 Cedar Ln, Los Angeles, CA, 900080.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52137TPASamantha Gonzalez1939-04-09——9765 Meadow Ln, San Antonio, TX, 782750.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53147TPAKeren Howard1980-09-03——9621 Broadway, San Antonio, TX, 782250.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55269TPAMargaret Mendooza2008-02-05—9565530815678 Broadway, Plano, TX0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-59642TPACooper Vincetn1990-12-24—90891371818425 Jefferson Ave, Nashville, TN, 372450.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-52914TPAKelly Ortiz1972-07-07——311 Ridge Rd, Plano, TX, 750650.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-52735TPAWillie Wood1968-02-12—23190694422996 Pine Dr, Fresno, CA, 937660.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 176 of 290PreviousNext