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-59671TPAMary Guzman2000-03-27UHC-44249-22—1636 Pine Dr, Las Vegas, NV, 891110.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62015TPACarol Murrray1967-04-06—8755683662—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56356TPABryan Flores1958-05-09——8892 River Rd, Mesa, AZ, 852220.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57895TPADiane Contreras1963-08-17——7134 Sage Ct, Fresno, CA, 937040.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59564TPAAhmed Lynch1988-04-21———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-61338TPAAlexander Mason1941-06-17—84959985621686 Oak St, Mesa, AZ0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-51233TPASantiago Schmidt——46747561855291 Forest Ave, Jacksonville, FL, 322710.80Name re-casedDate of birth unreadablePhone reformattedPlaceholder values cleared
TPA-52275TPAJoe Cook1938-06-26——8840 Elm St, Dallas, TX, 752060.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56368TPANicole Banks1996-12-26——2517 Mountain View Dr, Mesa, AZ, 852000.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53478TPARandy Jckson1947-02-11——8583 Central Ave, Miami, FL, 331330.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55756TPAAissha N Perez1985-06-02——9553 Elm St, Tampa, FL, 336220.80Name re-casedEmail lower-casedGender normalisedPlaceholder values cleared
TPA-63100TPAEugene Mason1940-07-01——7057 Market St, Los Angeles, CA0.80City re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-60725TPAEvelyn X Lawson1997-12-10——2187 Willow Ct, Minneapolis, MN, 554020.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-54182TPAMarcus Jacobs2004-09-07—37874054303489 Church St, Phoenix, AZ, 850720.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58492TPAJason Herrera1956-10-03—60326292246182 Baseline Rd, Gilbert, AZ, 852520.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50365TPACharlotte Pierce1954-07-02—47338688108633 Ridge Rd, Eden Prairie, MN, 553580.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54230TPAJeremy Kim1942-09-06———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58443TPADavid Yang1991-09-02——1276 Baseline Rd, Atlanta, GA, 303370.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59258TPABrittany King1947-10-03——5343 Indian School Rd, Houston, TX, 770940.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61907TPAAhmed Vega1953-09-25—97736008605743 Bayshore Dr, Scottsdale, AZ, 852450.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52215TPAAlan Aguilar1941-11-05UHC-72077-72—7777 Hillcrest Rd, Miami, FL, 331700.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53215TPAEmily V Spencer2002-01-14UHC-55914-20—7951 Bayshore Dr, Los Angeles, CA, 900290.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-53365TPAAndrea Rivera1976-05-09—38795391877221 Valley View Dr, Denver, CO, 802590.80Two-digit birth yearPhone reformattedEmail lower-casedPlaceholder values cleared
TPA-57777TPASam Watson1993-05-12—93057783317942 Pine Dr, San Antonio, TX, 782600.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50358TPADavid Taylor1956-08-27UHC-80641-10—4578 Baseline Rd, Jacksonville, FL, 322210.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57844TPAJordan Mitchell1999-01-13——882 Lake View Rd, Dallas, TX, 752810.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63545TPALogan Silva1957-07-14UHC-62864-84—8826 Church St, Seattle, WA, 981830.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54264TPAKimberly Hernandez1979-10-17—72880668341697 Desert Sky Blvd, Chandler, AZ, 852540.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63161TPAAshley Fowler1962-02-21——827 Washington St, Fresno, CA, 937890.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59236TPANicoe Snyder1988-07-06——6336 Spring St, San Antonio, TX, 782370.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
TPA-58212TPACatherine Coleman2004-08-12—55082842244690 Camelback Rd, San Antonio, TX, 782920.80Phone reformattedCity re-casedState name converted to codePlaceholder values cleared
TPA-52387TPASophia Rios1975-04-07—6338984923—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-60531TPAKevn McDonald1940-02-20——2674 Highland Ave, Minneapolis, MN, 554460.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55825TPADavid Lynch1959-02-27——4340 River Rd, Tempe, AZ, 852320.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
TPA-56197TPASamuel W Garcia1939-05-05——8620 Meadow Ln, Seattle, WA, 981370.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52961TPAPatricia Mendez2004-07-01——7575 Union St, Minneapolis, MN, 554040.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62235TPAJohn Lynch1973-03-02—9537713252—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-53743TPABobby Dominguez2005-12-21——1263 Canyon Rd, Dallas, TX, 752650.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51548TPAJudith Mitchell1989-05-03—3678072816—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56690TPAMaria Roodriguez1941-01-04——773 Indian School Rd, Gilbert, AZ, 852350.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52567TPAEmily Bredley2005-11-03——1546 Bayshore Dr, Chandler, AZ0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-62566TPAKelly Pierce1975-11-01——7028 Mesa Dr, Plano, TX, 750020.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60204TPAGrace Montgomery—UHC-74716-175928770083592 Mountain View Dr, Fresno, CA, 937790.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
TPA-58942TPAMelissa Ramos2002-06-10—87637691087751 Bayshore Dr, Chandler, AZ, 852330.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54633TPAMargaret Spencer1955-02-23——4242 Baseline Rd # 886, Plano, TX, 750470.80Date of birth reformattedUnit split from streetEmail lower-casedPlaceholder values cleared
TPA-55187TPABarbara Yang2003-08-06UHC-42370-8783535255652610 Palm Dr # 461, Sacramento, CA, 958090.80Name re-casedPhone reformattedUnit split from streetPlaceholder values cleared
TPA-62319TPABenjamin Luna1966-06-07——924 Desert Sky Blvd, Nashville, TN, 372490.80Name re-casedGender normalisedPlan code upper-casedPlaceholder values cleared
TPA-61088TPANoah Campbell1956-06-22——3116 Canyon Rd, Seattle, WA, 981270.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52989TPAJacob King1970-03-14——7963 Lake View Rd, Tempe, AZ0.80Name re-casedZIP missingEmail lower-casedPlaceholder values cleared
TPA-62258TPARobert J Bryant1972-12-14——7085 Maple Ave, Orlando, FL0.80Name re-casedDate of birth reformattedZIP missingPlaceholder values cleared
14,474 rows, page 186 of 290PreviousNext