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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
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-64055TPADonna Mason2002-04-14—96782611861781 Forest Ave, San Antonio, TX, 782450.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder 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-59100TPAYuki Gilbert1979-05-10——4855 Broadway, Atlanta, GA, 303890.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54171TPARussell Dean1981-07-23—7348393066—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-52947TPADouglas Schultz1954-10-05———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55367TPASean L Fuller1986-08-24——1395 Grand Ave, Chandler, AZ, 852010.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-53217TPAJason Fowler1940-08-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52071TPAAnna I Mason1972-01-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58234TPAElizabeth Hansun1981-10-23——1726 Elm St, San Antonio, TX, 782470.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-63115TPAChristine Snyder1993-04-25——5818 River Rd, Gilbert, AZ, 852990.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58975TPAChristian Cruz1992-06-03—3976202117—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-63495TPALiz Riley1963-05-28——2183 Bayshore Dr, Denver, CO, 802250.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53375TPAArthur Espinoza2003-07-16——9292 Indian School Rd, Tampa, FL, 336900.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-61301TPAAnn Harrison1944-09-10—26671806414159 Market St, Sacramento, CA, 958660.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-57646TPALori Obrien1983-05-16—6914429605232 Indian School Rd, San Diego, CA, 921910.80Name split from “Last, First”Name re-casedPhone reformattedPlaceholder values cleared
TPA-61617TPAAaron Daavis1968-09-21—7727838164—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54511TPADebbie Z Morrison1975-03-18——8651 Central Ave, Tempe, AZ, 852980.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57959TPAJanet Dixon2002-09-08—3676740820—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63702TPACamila Schmidt1963-11-21—76454232837202 Market St, Las Vegas, NV, 891150.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54115TPAMargaret Stone1979-11-12—5038517790—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61121TPAJeryr Hamilton1954-08-31—2096707176—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55862TPAJerry Le1965-05-13—9118037455—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57075TPAJonathan Burke1984-10-02——4277 Washington St, Denver, CO, 802090.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62106TPAGloria Ward1968-09-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63752TPASandra Patel1950-08-26—5909219151—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62205TPAAmber Lee2004-04-08—53626515595091 Church St, Sacramento, CA, 958830.80Name split from “Last, First”City re-casedPlan code upper-casedPlaceholder values cleared
TPA-53494TPAKevin Lucas1946-07-04——7668 Indian School Rd, Mesa, AZ, 852880.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-63616TPAAndrea M Harrison1956-06-22——1180 Meadow Ln, Phoenix, AZ, 850540.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
TPA-52093TPABradley Schmidt1954-04-16——7492 Camelback Rd, Eden Prairie, MN, 553950.80Name split from “Last, First”Date of birth reformattedState code upper-casedPlaceholder values cleared
TPA-60756TPAJacob N Gonzales2003-01-01———0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-60757TPAJacob N Gonzales2003-01-01———0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-52105TPALauren James1965-04-05—38975902179798 Main St, Tucson, AZ, 857320.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-63697TPASofia S Web1960-12-02——265 Ridge Rd, Tampa, FL, 336450.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-63819TPATeresa Munoz1949-05-17UHC-73954-80—4514 Broadway, Orlando, FL, 328680.80Name split from “Last, First”Member ID reformattedAddress re-casedPlaceholder values cleared
TPA-51533TPAJoseph Wang1976-04-25———0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-60255TPAJanet Dixon2007-10-04——2945 Lincoln Way, Houston, TX, 770780.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58019TPAHarold K Mejia1969-10-17—51633202942037 Desert Sky Blvd, Las Vegas, NV, 891090.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59458TPAMegan Berry1943-10-26—70576943096422 Highland Ave, Sacramento, CA, 958880.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-50752TPASamantha N Hughes2003-06-15—60999897923646 Meadow Ln, Gilbert, AZ, 852930.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-58394TPAAmber Fernandez1970-08-14——3495 Hillcrest Rd, San Diego, CA, 921290.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59436TPARonald Guerrero1953-09-22UHC-63884-9681499493208347 Market St, Scottsdale, AZ, 852620.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61460TPARuth Z Ross1970-04-21—53925676513071 Canyon Rd, Phoenix, AZ, 850960.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51579TPATony Wells1940-09-03—88278429296559 Mesa Dr, Gilbert, AZ, 852720.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57111TPALisa Mills1942-08-12UHC-79129-20—4582 Pine Dr, Las Vegas, NV, 891070.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53672TPAGloria Ferguson1941-07-02UHC-59505-65——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54038TPACynthia B Elliott2007-09-02——9248 Sage Ct, San Antonio, TX, 782000.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-61690TPARoy Lawrence1993-06-09———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50710TPAJerry Walsh1994-09-24——6984 Union St, Tampa, FL, 336210.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58599TPABradley Santos2004-03-03—36240431388363 Sage Ct, Phoenix, AZ, 850790.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
1,488 rows, page 24 of 30PreviousNext