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-56938TPAJacob George1957-06-02—42238899381133 Lincoln Way, Eden Prairie, MN, 553830.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60580TPASilva Jerry1958-10-15—9442196523—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59557TPALinda T Johnson1994-09-18—87872457193980 Baseline Rd, Columbus, OH, 432150.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62285TPAJack Moore1967-07-22—2639490973—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-50578TPAVirginia Ruiz2002-06-11—2748714431—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56861TPAAnna Romero1962-01-16—3078068355—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63209TPAWillie Harper1980-12-06——426 Desert Sky Blvd, Houston, TX, 770190.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-56287TPABrian Olson1998-12-23—5364276399—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63199TPAKyle Contreras1962-06-10——5877 Church St, Scottsdale, AZ, 852280.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-62079TPARyan Nichols1978-02-25—27054793374417 Camelback Rd, San Diego, CA, 921720.92Name re-casedPhone reformattedState code upper-casedPlaceholder values cleared
TPA-63099TPAJennifer Shaw1998-12-17—7753629460—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50636TPAKeith M Payne1997-02-13—83746879385572 Broadway, Phoenix, AZ, 850380.92Date of birth reformattedPhone reformattedState code upper-casedPlaceholder values cleared
TPA-58899TPAMaria Wells1945-03-19——7304 Mountain View Dr, Phoenix, AZ, 850990.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58765TPACheryl Ramos2000-01-03—92389692506590 Willow Ct, Columbus, OH, 432210.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54549TPAAdam Griffin1999-11-11—2746329625—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52677TPAJohn Richards1960-01-18—93473781569467 Valley View Dr, San Antonio, TX, 782290.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61871TPAStephanie Cunningham1953-03-16UHC-09872-7540246767995452 Lincoln Way, Glendale, AZ, 853170.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59446TPARalph Armstrong1981-07-21—6455889547—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56033TPAEthan Morgan1939-03-26—83787157816874 Baseline Rd, Fresno, CA, 937150.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61444TPASusan Perry2003-07-18UHC-84096-554237405827—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57401TPAMarcus McDonald2001-09-22—68980901796411 Broadway, Houston, TX, 770850.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60332TPADavid Woods1938-05-26——1578 Union St, Nashville, TN, 372110.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-61858TPAVincent King1948-08-14UHC-03496-997135329965—0.92Name re-casedPhone reformattedEmail lower-casedPlaceholder values cleared
TPA-62748TPARoger Fernanndez1963-11-20—36694349087593 Main St, Sacramento, CA, 958020.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58736TPALinda Martin2006-09-27—46672399041063 Union St, Dallas, TX, 752620.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55223TPABryan Rodriguez1946-08-25UHC-05002-09—6943 Camelback Rd, Seattle, WA, 981030.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59991TPARaymond Moore1977-10-27—78534947334565 Sunset Blvd, San Diego, CA, 921480.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53036TPALuica Welch1954-12-01—9469803168—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56900TPAKatherine Le2004-05-21——9865 Market St, Tempe, AZ, 852240.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53258TPACarolyn Jimenez1947-10-28—53243225813589 Pine Dr, Columbus, OH, 432420.92Date of birth reformattedPhone reformattedCity re-casedPlaceholder values cleared
TPA-59861TPAShirley Baker1984-05-13———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51525TPADanielle Bradley1946-04-12—23547822403413 Broadway, Tampa, FL, 336270.92Name re-casedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-63526TPASophia Soto1949-02-25—5622436561—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62184TPAMarcus Richardson1995-01-28—92065729382714 Broadway, Glendale, AZ, 853780.92Phone reformattedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55162TPADanielle K Romero1957-12-04—6017669330—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-54982TPACerol Lewis1949-07-22—2803486927—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50955TPAKeith Mejia1980-04-06—36771009854800 Bayshore Dr, Phoenix, AZ, 850310.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51462TPAChristine Ruzi1967-08-16—25578440553332 Willow Ct, Las Vegas, NV, 891040.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-59712TPAEric Hdson2008-12-03——8745 Church St, Minneapolis, MN, 554220.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55045TPAEthan Vasquez1973-06-11——9113 Washington St, Las Vegas, NV, 891220.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-50351TPAMatthew Brown1973-10-21—46446242674028 Mesa Dr, Austin, TX, 787730.92Phone reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-58172TPAMark W Lynch1997-12-19———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57702TPALarry Graham1989-07-18—68740616037319 Spring St, Scottsdale, AZ, 852530.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57701TPALarry Graham1989-07-18—68740616037319 Spring St, Scottsdale, AZ, 852530.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51279TPAStephanie Robertson1980-01-10—8045810159—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58534TPAPatrick Valdez2004-08-20UHC-24291-9459632464164711 Pine Dr, Columbus, OH, 432100.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-56037TPAMarcus Burke1950-03-16—8654517550—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51586TPADorothy Meejia1939-07-16——347 Lincoln Way, Glendale, AZ, 853540.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-58253TPAPatrikia Silva2005-12-22—3979607109—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50234TPAFatima Perkins2002-08-13—56334152642090 Park Pl, Las Vegas, NV, 891400.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 238 of 290PreviousNext