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-56198TPAChristine Bryant1964-01-02—31391130308446 Union St, Jacksonville, FL, 322340.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-54350TPAHeather Cox1991-04-26——5992 Apache Blvd, Las Vegas, NV, 891430.92City re-casedState code upper-casedPlan code upper-casedPlaceholder values cleared
TPA-60398TPAFrances Simpson2005-11-27UHC-84117-1068855952622348 Sunset Blvd, Seattle, WA, 981850.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-50773TPAMariana Shaw1991-10-19—5577106620—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62423TPAChristopher Wells1953-04-09———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63162TPAJessica Hunt1981-04-27UHC-73352-6577641915393711 Valley View Dr, Miami, FL, 331710.92Date of birth reformattedPhone reformattedEmail lower-casedPlaceholder values cleared
TPA-50956TPAJeremy Chen1984-02-25——8578 Union St, Columbus, OH, 432380.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-52170TPAKimberly Willis1954-04-24——5805 Park Pl, San Diego, CA, 921060.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-59934TPAJonathan Garrett1961-02-22—9173091687—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63904TPADeborah Sullivan1976-10-27—93936373066154 Sage Ct, Orlando, FL, 328710.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-53531TPAThomas I Sullivan1982-02-28—76597271373863 River Rd, Tampa, FL, 336720.92Name re-casedPhone reformattedState code upper-casedPlaceholder values cleared
TPA-53219TPAJean Black2006-07-24UHC-16293-86—7087 Lincoln Way, Nashville, TN, 372740.92City re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-59190TPAMichelle R Carpenter1960-07-18—65451111328637 Ocean Ave, Chandler, AZ, 852780.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-52107TPALaura Tucker1991-02-16——7137 Lincoln Way, Minneapolis, MN, 554120.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-58057TPAAnna W Mjia1953-01-17UHC-23558-66—8238 Broadway, Tucson, AZ, 857820.92Name re-casedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53850TPABradley Pierce1994-09-12—9447976638—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56705TPAGerald Howell1948-12-14—4362734873—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-57684TPAMelissa Edwards1984-06-22———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50517TPACarolyn Bell1969-03-05UHC-32776-84——0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56455TPADenise B Sanchez1994-11-02—37693882568771 Market St, Scottsdale, AZ, 852930.92Date of birth reformattedPhone reformattedCity re-casedPlaceholder values cleared
TPA-50887TPALarry Butler1935-04-19—58245194723941 Palm Dr, San Antonio, TX, 782010.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58504TPAHannah Roberts2003-04-13——780 Meadow Ln, Tempe, AZ, 852510.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-63167TPANncy Porter1940-07-15—87378102526331 Ocean Ave, Dallas, TX, 752910.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-62022TPAOlivia Medina1968-07-12——9683 Canyon Rd, Orlando, FL, 328020.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58158TPAIssabella McDonald1967-08-02—4816262445—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-53022TPABrandon Coleman1945-02-20—28594623463945 Lake View Rd, Mesa, AZ, 852610.92Date of birth reformattedPhone reformattedEmail lower-casedPlaceholder values cleared
TPA-60656TPAValentina Harvey1943-03-28——7433 Broadway, Scottsdale, AZ, 852610.92Date of birth reformattedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57284TPADeborah Price1940-11-15———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55012TPAEmma Harrison1939-12-13——1925 Mountain View Dr, Miami, FL, 331230.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-61368TPAAbigail Grant1953-02-13——7908 Hillcrest Rd, Tempe, AZ, 852530.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-54673TPAKayla Adams1960-09-19—8122304566—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51295TPAJustin Satos2004-04-04——8482 Apache Blvd, Orlando, FL, 328310.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-60850TPALuis M Hamilton1969-07-08——7639 Broadway, Glendale, AZ, 853400.92Name re-casedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60908TPABetty Kennedy1966-12-18—9128253165—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58423TPANicole Peterson1940-03-25—4045405548—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51713TPADeb Olson1938-09-02—2346743406—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53798TPARuth I Fisher1968-10-20——5096 Broadway, Los Angeles, CA, 900910.92Name re-casedDate of birth reformattedAddress re-casedPlaceholder values cleared
TPA-57006TPABryan Evans2007-08-25—50997025314502 Canyon Rd, Los Angeles, CA, 900940.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55419TPASusan Rojas1975-10-28UHC-53235-16—5079 Main St, Dallas, TX, 752240.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54851TPASofia King1959-10-18UHC-08034-3045460295071813 Valley View Dr, Scottsdale, AZ, 852480.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63013TPAJustin Y Jackson1995-01-02—37129036684662 Apache Blvd, Denver, CO, 802540.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-53221TPADaiel Garcia1961-06-10——7755 Washington St, Mesa, AZ, 852700.92Name re-casedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-53313TPAGregory Y Franklin2004-11-05—93792298014284 Bayshore Dr, Fresno, CA, 937610.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-63894TPAIsabella Sims1954-11-28—23864066176026 Baseline Rd, Dallas, TX, 752600.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52596TPAYuki Hamilton1993-09-01—58666820289778 Broadway, Las Vegas, NV, 891280.92Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed
TPA-61213TPAPaul Cole1987-03-25UHC-19182-68—5765 Indian School Rd, Tempe, AZ, 852460.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-61065TPAValentina Alexander1951-07-19——2332 Lincoln Way, Miami, FL, 331310.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-61185TPASamantha Valdez1973-04-02UHC-63204-9385983169337008 Washington St, Denver, CO, 802730.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-52510TPALynch Jerry1978-12-27——5218 Broadway, Miami, FL, 331120.92Name re-casedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-55561TPATerry Alvarado2003-01-24—40663877031239 Broadway, Dallas, TX, 752580.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
14,474 rows, page 229 of 290PreviousNext