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-54928TPAKevin Mills1976-08-28UHC-48283-04—8930 Mesa Dr, Orlando, FL, 328990.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56009TPAAnthony L Palmer1953-06-21UHC-35596-296407435110867 Elm St, Fresno, CA, 937550.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
TPA-61695TPAMichael Schmidt2004-10-28—57995662397258 Harbor Blvd, Dallas, TX, 752680.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-51849TPAMaria D Estrada1977-08-07——4706 Indian School Rd, Jacksonville, FL, 322920.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54504TPAEdward Q Cole1994-09-24——9543 Forest Ave, Fresno, CA0.80Name re-casedDate of birth reformattedZIP missingPlaceholder values cleared
TPA-52705TPACatherine Taylor1965-12-12UHC-44781-53—7245 Hillcrest Rd Apt 11, Chandler, AZ, 852530.80Date of birth reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-50431TPABrandon Gonzales1966-05-07——1764 Ocean Ave, Plano, TX, 750600.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63981TPARoger Luna1960-10-11—83080530372436 Indian School Rd, Miami, FL, 331480.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64415TPATeresa Howell1959-10-07——6315 Oak St, Austin, TX, 787130.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54698TPAEvelyn M Williams2007-09-27——8149 Bayshore Dr, Tempe, AZ, 852700.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-52383TPAMaria M Ramirez1999-04-23—45192460381413 Ridge Rd, San Antonio, TX, 782960.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55792TPASteven Carlson1961-09-04——4558 Harbor Blvd, Houston, TX, 770650.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-64387TPACarolyn Wright1976-05-19——3585 Jefferson Ave, Dallas, TX, 752100.80SSN last four extractedCity re-casedEmail lower-casedPlaceholder values cleared
TPA-53835TPAGerald Rose1982-08-05——7637 Forest Ave, Mesa, AZ, 852830.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59719TPABruce Little1939-07-09—77950545979067 Harbor Blvd, Fresno, CA, 937970.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58745TPAKyel Garrett1972-02-20——1381 Apache Blvd, Jacksonville, FL, 322990.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57879TPAJustin Turner1995-11-12—46861966343538 Indian School Rd, Miami, FL, 331600.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52153TPASusan Contreras1995-09-03——4132 Baseline Rd, Tempe, AZ, 852030.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62990TPAEric Harper2002-10-26UHC-18855-1672939082338687 Ocean Ave, San Diego, CA, 921450.80Member ID reformattedZIP+4 trimmedEmail lower-casedWhitespace trimmed
TPA-57091TPARebecca Collins1972-06-13———0.80Email lower-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61050TPAAmy Simpson1969-02-17——8176 Bayshore Dr, Las Vegas, NV, 891440.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63914TPAKathryn Campbell1983-12-01—60577207413280 Valley View Dr, Los Angeles, CA, 900590.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54017TPAJuan Kim1965-09-28——8159 River Rd Apt 23, Nashville, TN, 372590.80Date of birth reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-58092TPAGary H Hart1984-01-04——5166 Ridge Rd, Mesa, AZ, 852720.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61192TPAIsabella Lynch1973-11-09—85974059227754 Valley View Dr, Gilbert, AZ, 852350.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61622TPACollins Ruth1938-02-06——4725 Harbor Blvd, Charlotte, NC, 282790.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56647TPADaniel Jackson1951-11-21——9136 Baseline Rd, Denver, CO, 802420.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-58063TPABrenda Thompson1986-01-18——7461 Lincoln Way, Seattle, WA, 981650.80Name re-casedDate of birth reformattedSSN last four extractedPlaceholder values cleared
TPA-51948TPAJesse Santos1981-06-19——8431 Palm Dr, Phoenix, AZ, 850860.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-56980TPATyler Padilla1974-03-25——7057 Mesa Dr, Tempe, AZ, 852970.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-52196TPAWillie Cole1985-09-21—5026621678—0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56236TPAKathleen Morris1962-10-27——4720 Apache Blvd, Tucson, AZ, 857500.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53870TPAMichael Alexander2003-08-01——9873 Indian School Rd, Glendale, AZ, 853180.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58136TPAGabriel F Cole1988-03-14——2533 Hillcrest Rd, Eden Prairie, MN, 553500.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58710TPAJuan Fowler2002-09-11——196 Cedar Ln, San Antonio, TX, 782730.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-56884TPAJose Green1998-10-12——6617 Ocean Ave, Los Angeles, CA, 900020.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58077TPAKeith Webb1995-10-16—4146552867—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62441TPAMei Clark1987-03-09——4102 Sunset Blvd, Glendale, AZ, 853290.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51946TPADan Carroll2008-09-22——4534 Highland Ave, Charlotte, NC, 282860.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-53695TPAKathryn Sandoval1956-09-11——2498 Meadow Ln, Fresno, CA, 937600.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61074TPAMarcus I Wallace1954-02-11——5894 Bayshore Dr, Miami, FL, 331620.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51949TPACynthia Rojas1979-06-02——5677 Mesa Dr, Charlotte, NC, 282640.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-50936TPAJimmy Marshall2006-09-03——2554 Willow Ct, San Antonio, TX, 782400.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54636TPAPriya Bailey1992-03-10———0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-57079TPAAlice Bailey1980-08-28——9752 Willow Ct, Glendale, AZ, 853220.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61020TPACarol C Meyer1979-07-21UHC-67181-84—3897 Camelback Rd, Nashville, TN, 372650.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59174TPAVincent Castro1995-11-17—69290275276652 Valley View Dr, Orlando, FL, 328520.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57120TPACharlotte Green1946-08-06—95022104144490 Valley View Dr, Minneapolis, MN, 554490.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62963TPAValentina Stevens1943-01-26——8592 Mountain View Dr, Houston, TX, 770110.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61417TPAAlbert Fisher1981-06-04——9784 Harbor Blvd, Gilbert, AZ, 852120.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 177 of 290PreviousNext