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-59237TPATyler Reed1950-11-15———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58707TPAAmanda Thompson1959-01-02——929 Maple Ave, Austin, TX, 787750.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53486TPAMichelle Lee1952-02-03—246888320188 Highland Ave, Charlotte, NC, 282110.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62072TPABrian Jacobs2001-11-04—4245745244—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52498TPAEmma Lawson1955-05-21——3954 Central Ave, Jacksonville, FL, 322480.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-64182TPAJerry Day1966-12-18—7677674930—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62336TPAStephanie Snyder1975-08-13—55650027878214 Sage Ct, Atlanta, GA, 303310.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-57455TPAMichelle Anderws1994-08-24——6315 Highland Ave, Orlando, FL, 328740.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-58922TPADan Soto1985-08-17—57481524571606 Broadway, Seattle, WA, 981750.92Name re-casedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61826TPAVirginia Green1963-10-26—22920474998700 Sunset Blvd, San Diego, CA, 921260.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-51004TPAMatthew Allen1989-07-11—2306515265—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56166TPAKelly E Duncan1978-09-20—68647644609867 Oak St, Tampa, FL, 336880.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63767TPAPatrick Moales1966-05-01—89536736111729 Central Ave, Sacramento, CA, 958030.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61188TPABetty V Watkins1994-07-17———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57031TPALinda Robinson2002-05-22—5796164499—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61518TPALauren U Peters1984-07-16——1420 Oak St, Glendale, AZ, 853920.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-60585TPAMegan Kim2008-03-28—8206878393—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54779TPADina Chapman2000-02-08—6322272810—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57901TPAMariana C Ray1981-12-14—44350632905557 Hillcrest Rd, Minneapolis, MN, 554170.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61465TPARalph Andrews1953-09-20—2122278055—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60899TPAMarilyn Garrett2001-04-05—50591057279623 Hillcrest Rd, Charlotte, NC, 282670.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57593TPAMaria Ryan1965-03-01——8437 Lake View Rd, Atlanta, GA, 303700.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-54332TPAMaria Bailey1989-05-28UHC-08893-224909490878—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-57178TPAGabriel Estrada1989-03-12—4444313872—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63543TPATommy Hoffman1955-07-25—27830794327394 Hillcrest Rd, San Antonio, TX, 782700.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56259TPASaarh Q Bennett1976-11-09—9735663116—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50002TPAJames Hunter1960-03-14———0.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-54032TPAStephanie Hamilton1963-09-04—4293329333—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-59857TPAEmma Silva1977-06-11—36132587236272 Church St, Plano, TX, 750380.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60649TPATeresa Murphy1967-10-09—31822362184268 Broadway, Mesa, AZ, 852690.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51650TPAJohn Howad1966-05-09UHC-29863-3047294710986539 Sage Ct, San Antonio, TX, 782220.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-51318TPAKimberly Parker2002-12-14—8816768176—0.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-55259TPASophia D Montgomery1947-01-08—72228113802573 Oak St, Austin, TX, 787080.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-51263TPAWei Gardner2002-11-12—84886403209666 Canyon Rd, Mesa, AZ, 852120.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52573TPAEthan Lee1995-05-01——999 Church St, Mesa, AZ, 852190.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59851TPAElijah Harper1947-09-17——4099 Ridge Rd, Tempe, AZ, 852290.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62300TPAMartha Harvey1949-05-15———0.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-61454TPAJulie Moore2003-01-20UHC-75274-212067241656—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61739TPAJoyce Wells1988-11-18UHC-37536-8173574105793694 Sage Ct, Dallas, TX, 752150.92Date of birth reformattedPhone reformattedCity re-casedPlaceholder values cleared
TPA-58050TPAEdward Peterson1965-05-18UHC-86064-9025478802281428 Maple Ave, Orlando, FL, 328890.92Date of birth reformattedPhone reformattedEmail lower-casedPlaceholder values cleared
TPA-59163TPANoah Hall1967-05-02——8762 Desert Sky Blvd, Tampa, FL, 336440.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-59164TPANoah Hall1967-05-02——8762 Desert Sky Blvd, Tampa, FL, 336440.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-56297TPAAmber Wright1939-02-25—92569357305715 Palm Dr, Tucson, AZ, 857180.92Name re-casedState code upper-casedEmail lower-casedPlaceholder values cleared
TPA-51692TPASteve Q Scott1943-08-22UHC-90161-547923482814—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54932TPAZachary Thmpson1959-02-24—8112505484320 Washington St, Tampa, FL, 336950.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55058TPAMadison White1993-09-10——6260 Church St, Atlanta, GA, 303600.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-62838TPARussell Morrison1952-07-14——6556 Spring St, Houston, TX, 770890.92Name re-casedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-58420TPACollins Jecob1975-08-04———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58252TPAPamela Sims2003-07-07—64174521596354 Bayshore Dr, Los Angeles, CA, 900640.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-54354TPAKle Taylor2006-05-28—70395137588390 Market St, Tampa, FL, 336710.92Name re-casedDate of birth reformattedPlan code upper-casedPlaceholder values cleared
14,474 rows, page 231 of 290PreviousNext