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-51841TPAMarcus Little2001-03-28——9687 Ridge Rd, Gilbert, AZ, 852660.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-56583TPAJose P Padilla1955-01-14—5785331507—0.90Name re-casedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-53104TPAJoseph Wheeler1971-03-15——8613 Canyon Rd, Chandler, AZ, 852280.90Name re-casedCity re-casedState code upper-casedWhitespace trimmed+1 more
TPA-57392TPACheryl Butler1997-02-05—23637803355797 Cedar Ln, Orlando, FL, 328480.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-51130TPAWei Kelley1963-05-01—23286677321395 Desert Sky Blvd, Mesa, AZ, 852380.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-56869TPABradnon Cook1969-06-02—80665663651367 Mountain View Dr, Glendale, AZ, 853400.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-60759TPAJustin Watkins2004-02-19———0.90Name re-casedDate of birth reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-51041TPAAiisha E Snyder1988-10-25—6887720113652 Desert Sky Blvd, Miami, FL, 331370.90Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-59463TPAMaria Garcia1981-09-10UHC-26872-4362877142383787 Mountain View Dr, Houston, TX, 770480.90Name re-casedPhone reformattedMember ID reformattedWhitespace trimmed+1 more
TPA-58329TPAKyle Dominguez1991-07-17UHC-67063-3771593924778407 Broadway, San Diego, CA, 921890.90Name re-casedPhone reformattedAddress re-casedWhitespace trimmed+1 more
TPA-58778TPALisa Dunn1940-11-09—6915743293999 River Rd, Austin, TX, 787300.90Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-61868TPALarry Singh2004-07-15UHC-55360-9722865579413589 Main St, Los Angeles, CA, 900360.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-58334TPAJulia Snyder1951-02-06—55250741192609 Sunset Blvd, Glendale, AZ, 853790.90Name re-casedDate of birth reformattedPhone reformattedCity re-cased+1 more
TPA-55084TPAYuki Hays1978-11-25—77428476032971 Grand Ave, Orlando, FL, 328900.90Date of birth reformattedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-56467TPASteven Robinson2004-09-15—32722079899561 Mountain View Dr, Jacksonville, FL, 322660.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-61893TPASean Howell1979-03-20UHC-66065-5062274962101203 Sage Ct, Sacramento, CA, 958890.90Name re-casedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-51107TPAAlbert Myers1959-03-01UHC-39005-1475288891102650 Mountain View Dr, Denver, CO, 802240.90Date of birth reformattedPhone reformattedPlan code upper-casedWhitespace trimmed+1 more
TPA-62768TPABarbara Weber1948-01-25—3499060415—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-61467TPAJustin Bennett1996-11-06——7156 Broadway, Tampa, FL, 336670.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-51465TPABarbara Stewart1963-04-19UHC-53231-7948724831832292 Camelback Rd, Columbus, OH, 432040.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55068TPATeresa Lewis2000-06-26——7045 Meadow Ln, Dallas, TX, 752820.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58373TPACarl Marshall1963-07-22—6894527111—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-61077TPAArthur Rios1971-01-03——1393 Meadow Ln, Orlando, FL, 328670.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-58650TPAVirginia Weaver1955-09-24——5687 Sage Ct, Glendale, AZ, 853510.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51421TPAMei Vazquez1999-12-10—7283897926—0.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-55163TPAAlexander Bradley1945-09-17—93987790064988 Mountain View Dr, Denver, CO, 802880.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-64158TPAEmily Shaw1992-02-13—42621506521137 Washington St, Gilbert, AZ, 852580.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-62338TPAChriistian Bradley1979-08-23—98342987981535 Washington St, Houston, TX, 770680.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-61845TPAGarcia Priya1967-07-19——2276 Broadway, Dallas, TX, 752160.92Name re-casedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61111TPABryan Morgan1998-03-16—39522268849619 Maple Ave, Los Angeles, CA, 900720.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58970TPAGloria Tran1945-05-04—5176778499—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57442TPASofia Myers1992-03-21—8426458625—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62700TPAMaria Hayes1977-08-17———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53223TPACarolyn Morales1953-04-20——395 Church St, Austin, TX, 787950.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53601TPAAnthony Torres1940-10-14—84531675356430 Palm Dr, Sacramento, CA, 958120.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-61894TPAJack Castro1967-08-03—9175743970—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-62053TPAMichelle S Hart1972-04-06——2271 Lake View Rd, Houston, TX, 770960.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-59477TPABilly Williams1950-04-07——6354 Baseline Rd, Houston, TX, 770450.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-56200TPADavid Hernandez1987-06-28———0.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-60972TPAWillie Jensen1943-06-26——3180 Market St, San Antonio, TX, 782830.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-53106TPAMaria Collins1938-11-13———0.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-55616TPAJoshua I Moreno1994-08-02—4525236822—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56354TPAAaron Harris1968-02-17UHC-65969-21—422 Park Pl, Scottsdale, AZ, 852110.92Name re-casedMember ID reformattedEmail lower-casedPlaceholder values cleared
TPA-52293TPARyan Green1995-12-03—59934199361735 Sunset Blvd, Phoenix, AZ, 850350.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60130TPARalph Washington1977-07-06—4508913008—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61496TPAPatricia Davis1983-10-12—7568288565—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-50324TPAWei Hughes1987-07-27——9840 Maple Ave, Austin, TX, 787850.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58090TPALaura Graham1959-12-13—78668512628342 Apache Blvd, San Diego, CA, 921130.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-64270TPALarry Fields1966-04-23——7205 Broadway, Miami, FL, 331000.92City re-casedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-57571TPADon Harper1975-11-02—6775338231—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 227 of 290PreviousNext