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-62438TPAVirginia Scott2005-05-02—94723936569105 Hillcrest Rd, Seattle, WA, 981940.80Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased
TPA-63031TPAMason R Hawkins1943-07-07———0.80Two-digit birth yearPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-51868TPARoss Virginia1944-06-04——8604 Maple Ave, Tempe, AZ, 852970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59752TPABarbara Rogers1993-12-17—93249831283065 Valley View Dr, Mesa, AZ, 852920.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63256TPASharon B Diaz1957-07-25——4651 Sage Ct, Nashville, TN, 372660.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54901TPACharles Maldonado1949-05-15—38577328324005 Grand Ave, Minneapolis, MN, 554890.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-64141TPAJackie Mitchell1952-08-19—90251084434556 Grand Ave, Atlanta, GA, 303840.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-52284TPAScott U Gomez1994-12-27—30485285754489 Union St, Las Vegas, NV, 891550.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56716TPAJesse J Murray1963-12-17UHC-00502-6389484222682900 Lincoln Way, Jacksonville, FL, 322530.80Phone reformattedCity re-casedGender normalisedPlaceholder values cleared
TPA-58439TPAKatherine Hudson1983-12-15——1002 Indian School Rd, Tucson, AZ, 857530.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
TPA-54464TPAMateo X Austin1976-03-24———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60937TPAJustin Gordon1988-03-01—37839136762293 Union St, Denver, CO, 802840.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-50105TPASofia Woods1961-10-28——6262 Forest Ave, Chandler, AZ, 852380.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58412TPAElizabeth Simmons1985-06-17——9041 Baseline Rd, Fresno, CA, 937970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55249TPANathan Robertson1995-01-26——1798 Desert Sky Blvd, Fresno, CA, 937440.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60352TPADeborah A Hoffman1955-12-20——551 Spring St, Chandler, AZ, 852020.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59510TPAMelissa Roberts2003-02-12——4456 Sage Ct, Fresno, CA, 937910.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51721TPABryan Moreno1978-07-28——212 Washington St, San Diego, CA, 921150.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62219TPAPat Cole1969-11-13——6828 Meadow Ln, Minneapolis, MN, 554260.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55734TPAMarcus Gutierrez1951-08-07—36836335701976 Church St, Plano, TX, 750330.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64055TPADonna Mason2002-04-14—96782611861781 Forest Ave, San Antonio, TX, 782450.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-54143TPARebecca Ferguson1939-04-11—2436302509429 Harbor Blvd Apt 7, Tampa, FL, 336580.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-55393TPADoris Mills——8485147047—0.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
TPA-53243TPAJeremy Nichols1978-04-27UHC-36703-86——0.80Member ID reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53944TPAFrances Schmidt1966-09-23——1285 Bayshore Dr, Miami, FL, 331130.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53607TPAMaria Valdez1942-10-01——7473 Central Ave, Gilbert, AZ, 852360.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58819TPAPhilip Williamson1938-07-04—7783601032—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59100TPAYuki Gilbert1979-05-10——4855 Broadway, Atlanta, GA, 303890.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57002TPASamantha Morgan1966-11-17——767 Sunset Blvd, Chandler, AZ, 852690.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-50302TPAAshley N Jones1969-09-11——1608 Desert Sky Blvd, Tucson, AZ, 857440.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50472TPAKenneth Parker————0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-62960TPACarl Miller1965-01-16—9457385035170 Willow Ct, Miami, FL, 331510.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-52861TPACyynthia Price1941-10-01—86988683272275 Mountain View Dr, Los Angeles, CA, 900630.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63635TPAMichael A Padilla1982-03-20——8386 Pine Dr, Miami, FL, 331360.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52101TPANicole K Ortega2005-09-13—8135244011376 Baseline Rd, Chandler, AZ, 852830.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63980TPARoger Luna1960-10-11UHC-68542-23——0.80Date of birth reformattedPhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-51084TPARussell Walkre1991-03-18——3949 Main St, Orlando, FL, 328350.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59020TPAJose N Wells1968-06-15—4147465634409 Baseline Rd, Chandler, AZ, 852380.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50596TPAJose Lane1969-10-15—91270566043821 Broadway, San Antonio, TX, 782010.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51481TPAMariana Webb1959-07-07UHC-20825-98—9040 Canyon Rd, Houston, TX, 770260.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63629TPAVictoria Santos1943-12-21——3593 Main St, Scottsdale, AZ, 852860.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51996TPAArthur Freeman1957-12-26——4412 Forest Ave, Tucson, AZ, 857890.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50140TPAEugene Campbell1951-03-21—49083894109531 Central Ave, Atlanta, GA, 303700.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57124TPAKeith Henry1976-10-20——1963 Canyon Rd, Glendale, AZ0.80Name re-casedState code upper-casedZIP missingPlaceholder values cleared
TPA-53378TPAMary M Weaver1981-06-07—29838484125061 Maple Ave, San Antonio, TX, 782810.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-57690TPAJulie Carr1985-04-06——6342 Spring St, San Antonio, TX, 782040.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51972TPARichard Campbell1995-06-22——9162 Valley View Dr, Miami, FL, 331590.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63054TPACarol Shaw2002-10-06——1968 Willow Ct, Orlando, FL, 328260.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-63055TPACarol Shaw2002-10-06——1968 Willow Ct, Orlando, FL, 328260.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-61255TPAAaron Watkins1967-12-08——7721 Maple Ave, Sacramento, CA, 958360.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 164 of 290PreviousNext