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-60415TPAArjun Jones1953-02-05—8045062354—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53651TPASusn Estrada1995-10-02——4654 Bayshore Dr, Gilbert, AZ, 852630.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61931TPAMadison Dean1972-12-12—3164987718—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-55897TPAAmber Alexander1960-05-26—2306384043—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-53768TPAJerry Lawson1992-06-03—5596205988—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55848TPAAmy Martin1982-07-04———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57879TPAJustin Turner1995-11-12—46861966343538 Indian School Rd, Miami, FL, 331600.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60267TPAGrifffin U Pamela1985-08-14—66886918628907 Camelback Rd, Tempe, AZ, 852100.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54285TPACarlos Gonzalez2004-10-12—3434173094—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62774TPASusan Z Barnes1999-01-17—28941371189887 Lincoln Way, Seattle, WA, 981490.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
TPA-61731TPAMatthew Spencer2002-08-26—5719070427—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50173TPARalph Elliott1993-06-26UHC-06749-672268174021—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61770TPANancy Richards1948-06-12UHC-93715-498129566702—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-63459TPADiane Le1952-09-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63018TPAJack Hoffman1949-11-27—7876653289—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61015TPARalph Wright1942-07-13—46348176009787 River Rd, Phoenix, AZ, 850640.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
TPA-58114TPAAaron Jones1992-10-01—5204402227—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58790TPAWayne Davis1956-05-25———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57801TPACynthia Ford1986-06-11—6936057795—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55338TPABenjamin Shaw1993-05-24—63591949244124 Bayshore Dr, San Antonio, TX, 782980.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60028TPATiimothy Carpenter1970-04-07UHC-24778-33—8987 Hillcrest Rd, Mesa, AZ, 852170.80Name split from “Last, First”Date of birth reformattedCity re-casedWhitespace trimmed
TPA-61373TPALius Kelley1998-05-21—80646473254043 Spring St, Las Vegas, NV, 891280.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-60225TPADenise Vargas1949-10-23—6146730135—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59601TPAPatricia Olson1953-11-07UHC-37185-653932248539941 Apache Blvd, Houston, TX, 770040.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63368TPAJanet Carpenter1945-03-16——3704 Canyon Rd, Austin, TX, 787100.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60691TPAScott Anderson1987-07-26—2314012079—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-56743TPAAlice Patterson2007-07-08—39762847929575 Washington St, Chandler, AZ, 852580.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63794TPAZachary Armmstrong1978-01-27——5977 Broadway, Phoenix, AZ, 850970.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-63262TPAVirginia Santiago1992-03-13—2234022365—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50755TPACamila James1990-08-22—91261685835779 Lincoln Way, Charlotte, NC, 282610.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-50754TPACamila James1990-08-22—91261685835779 Lincoln Way, Charlotte, NC, 282610.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-57970TPASofia Richards1987-11-21UHC-23021-94—2580 Desert Sky Blvd, Plano, TX, 750200.80Name split from “Last, First”Date of birth reformattedMember ID reformattedCity re-cased
TPA-56741TPANanyc Boyd1967-04-18—42953820347848 Grand Ave, Glendale, AZ, 853010.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-52809TPABrian Hawkins1978-08-10—65736120301350 Sage Ct, Tucson, AZ, 857830.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-57219TPAVirginia J Morgan1998-09-03——337 Elm St, Mesa, AZ, 852520.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55005TPAPamela Burns1944-05-11——6099 Mesa Dr, Miami, FL, 331400.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60136TPAAmanda Santos1939-03-09—2179055139—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52968TPAEugene Elliott1945-03-11UHC-77796-837748269784—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52969TPAEugene Elliott1945-03-11UHC-77796-837748269784—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52211TPAMichelle M Smith2003-05-10——5366 Main St, Fresno, CA, 937690.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59140TPANathan Salazar1956-08-11———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62050TPALogan R Vargas1965-06-07—8119287403—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-52325TPAKathryn Watson2004-11-20—62875122463234 Palm Dr, Charlotte, NC, 282110.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57143TPAGreg Valdez1940-07-20——5929 Oak St, Charlotte, NC, 282110.80Name split from “Last, First”Date of birth reformattedCity re-casedPlaceholder values cleared
TPA-62015TPACarol Murrray1967-04-06—8755683662—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54230TPAJeremy Kim1942-09-06———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder 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-62803TPARussell Lee1969-11-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61039TPAJoe Cox1997-10-04——9489 Mountain View Dr, Plano, TX, 750390.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57208TPAKimberly Ramirez1961-09-17——8356 Park Pl, Dallas, TX, 752630.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
1,488 rows, page 25 of 30PreviousNext