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.

Placeholder values cleared71,257
Placeholder tokens such as NULL, N/A, UNKNOWN or "-" treated as empty
Whitespace trimmed57,061
Leading or trailing whitespace removed from one or more fields
Address re-cased56,490
Street line re-cased and punctuation removed
Street suffix standardised55,824
Street suffix standardised to USPS abbreviation (Street to St, Avenue to Ave, and so on)
Phone reformatted50,244
Phone reduced to ten digits, punctuation and leading country code removed
Name re-cased39,996
Name letter-case rewritten to Title Case and stray characters removed
Date of birth reformatted32,400
Date of birth rewritten to ISO 8601 from a source format (MM/DD/YYYY, YYYYMMDD, Mon D, YYYY)
City re-cased17,850
City re-cased to Title Case
Gender normalised16,828
Gender mapped to F or M from a longer or variant value
Email lower-cased11,635
Email lower-cased
Name split from “Last, First”9,980
First-name field held "LAST, FIRST"; the two parts were split into their own fields
State name converted to code9,084
Full state name replaced by its two-letter USPS code
ZIP+4 trimmed8,263
ZIP+4 trimmed to the five-digit ZIP
Member ID reformatted7,723
Member ID re-hyphenated and upper-cased to the UHC-#####-## pattern
ZIP missing7,146
Street address present but no ZIP supplied
Unit split from street6,994
Apartment, suite or unit designator split from street line and re-appended in standard form
Two-digit birth year6,661
Date of birth carried a two-digit year; century inferred by pivot
State code upper-cased4,010
Two-letter state code upper-cased
Plan code upper-cased3,278
Plan code upper-cased
SSN last four extracted2,817
Last four digits of SSN extracted from a longer or punctuated value
Date of birth unreadable2,274
Date of birth did not match any known format or was out of range; cleared
Phone missing area code2,021
Phone had only seven digits (no area code); cleared
Middle initial moved out of first name1,125
A single middle initial was embedded in the first-name field and moved to middle name
Date of birth missing990
Date of birth absent or a null token; left empty
No usable name (quarantined)505
No usable last name; record quarantined as junk and excluded from matching

Normalised records

Third-party administrator, flag “City re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagCity re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-54211	TPA	Garzza Justin	1950-05-24	—	8267831888	3979 Park Pl, Columbus, OH, 43216	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
TPA-56174	TPA	Judith Foster	1972-07-03	—	—	6667 Elm St, Dallas, TX, 75243	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-51405	TPA	Kayla Ferguson	2005-06-19	—	6534957506	3533 Grand Ave, Las Vegas, NV, 89118	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
TPA-56298	TPA	Joey Nunez	1942-07-07	—	—	219 Broadway, San Antonio, TX, 78264	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-54819	TPA	Cook Laura	2002-07-27	—	4072963645	740 Harbor Blvd, Chandler, AZ, 85253	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
TPA-51320	TPA	Kimberly Parker	2002-12-14	—	8816768176	7164 Elm St, Chandler, AZ, 85227	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
TPA-52021	TPA	Linda Gomez	1994-04-14	UHC-48209-83	—	8638 River Rd, Jacksonville, FL, 32251	0.92	Date of birth reformatted Member ID reformatted City re-cased Placeholder values cleared
TPA-52033	TPA	Sandra Stone	1951-02-12	—	7706331421	8768 Church St, San Diego, CA, 92150	0.92	Phone reformatted City re-cased Plan code upper-cased Placeholder values cleared
TPA-60874	TPA	Carlos Kelley	1953-04-04	—	9643278543	3081 Pine Dr, Houston, TX, 77077	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
TPA-51994	TPA	Hiroshi Li	1965-02-27	—	3893686392	4513 Lincoln Way, Nashville, TN, 37208	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
TPA-51234	TPA	Gloria Flores	1949-06-18	UHC-00099-58	—	700 Willow Ct, Chandler, AZ, 85222	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-55239	TPA	Sofia Soto	1974-05-18	—	—	884 Sunset Blvd, Columbus, OH, 43239	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-50548	TPA	Danielle Wang	1982-04-12	—	—	5970 Elm St, Glendale, AZ, 85394	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-54678	TPA	Willie Gibson	1994-04-23	—	—	3603 Harbor Blvd, Tampa, FL, 33695	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-60529	TPA	Alice Meyer	1980-10-04	UHC-24459-46	—	7448 Mesa Dr, Chandler, AZ, 85272	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-57942	TPA	Gregry N Henry	1975-02-12	UHC-22017-61	4882764630	9087 Broadway, Houston, TX, 77062	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
TPA-53856	TPA	Randy Hernandez	1980-10-19	UHC-00866-60	—	8338 Lincoln Way, Atlanta, GA, 30392	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-57563	TPA	Santiago Ferguson	1970-12-15	UHC-71174-76	—	2728 Hillcrest Rd, Fresno, CA, 93741	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-63350	TPA	Gabriel Price	1985-07-23	—	5046017098	3420 Elm St, Las Vegas, NV, 89103	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-56102	TPA	Margaret Hunt	1941-10-25	—	—	7240 Union St, Gilbert, AZ, 85208	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-52357	TPA	Mery Ramirez	1961-03-28	—	6846205137	1794 Cedar Ln, Jacksonville, FL, 32277	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
TPA-59098	TPA	Carol Rogers	1973-06-14	—	—	6820 Hillcrest Rd, Minneapolis, MN, 55427	0.92	Date of birth reformatted City re-cased Plan code upper-cased Placeholder values cleared
TPA-56758	TPA	Douglas Mattheews	1946-05-26	—	—	3945 Broadway, Plano, TX, 75066	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
TPA-52240	TPA	Sophia Wilson	1958-10-14	—	—	962 Palm Dr, Jacksonville, FL, 32243	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-51655	TPA	Stephen Cook	2001-11-05	UHC-38054-36	—	433 Main St, San Antonio, TX, 78202	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-55571	TPA	Brenda Henry	2004-01-05	—	—	2034 Cedar Ln, Chandler, AZ, 85232	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-53569	TPA	Shirley Welch	1944-11-10	—	—	5380 Washington St, Miami, FL, 33147	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-59881	TPA	Billy Parry	1982-09-19	—	5114417958	1501 Lincoln Way, Los Angeles, CA, 90067	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
TPA-56038	TPA	Harold Obrien	1984-03-24	—	6383919662	259 Market St, Sacramento, CA, 95818	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
TPA-57829	TPA	Gracce Romero	1978-08-24	—	6328209186	6656 Lincoln Way, Nashville, TN, 37237	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-57476	TPA	Elijah Richardson	1951-04-02	—	—	3875 Park Pl, Orlando, FL, 32864	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared
TPA-51328	TPA	Paul Holmes	2003-04-23	—	8824594611	8385 Broadway, Columbus, OH, 43250	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-50679	TPA	Christine Jacobs	1969-02-18	UHC-30563-75	5256623509	6688 Hillcrest Rd, Jacksonville, FL, 32268	0.92	Phone reformatted City re-cased State code upper-cased Placeholder values cleared
TPA-63885	TPA	Dorothy W Ruiz	1984-01-14	UHC-15485-40	5642295859	3386 Lake View Rd, Denver, CO, 80290	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
TPA-61556	TPA	Joe Mills	1948-12-08	—	—	8341 Market St, Seattle, WA, 98142	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-57385	TPA	Brayn Stevens	1997-05-16	UHC-77358-20	6423989218	287 Lincoln Way, Eden Prairie, MN, 55367	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-62721	TPA	Rebecca G Fox	2000-12-04	UHC-05601-41	—	7732 Harbor Blvd, Eden Prairie, MN, 55371	0.92	Name re-cased Member ID reformatted City re-cased Placeholder values cleared
TPA-53519	TPA	Brian Schmidt	1958-10-15	UHC-76529-82	—	1569 Sunset Blvd, Tempe, AZ, 85296	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-61193	TPA	Nathan Patterson	1954-10-23	—	9054485241	5732 Harbor Blvd, Los Angeles, CA, 90066	0.92	Phone reformatted City re-cased Whitespace trimmed Placeholder values cleared
TPA-64047	TPA	Carol U Rogers	1947-04-05	—	—	5460 Bayshore Dr, Minneapolis, MN, 55495	0.92	Name re-cased City re-cased Whitespace trimmed Placeholder values cleared
TPA-54433	TPA	Gerald Chavez	1987-03-27	—	4268273256	6886 Central Ave, Seattle, WA, 98186	0.92	Date of birth reformatted Phone reformatted City re-cased Placeholder values cleared
TPA-61303	TPA	Raymond B Castro	1983-01-07	—	—	6579 Palm Dr, Charlotte, NC, 28275	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-57828	TPA	Grace Romero	1978-08-24	UHC-31170-76	6328209186	6656 Lincoln Way, Nashville, TN, 37237	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
TPA-53142	TPA	Diane Alvarez	1998-06-11	—	—	7578 Central Ave, Plano, TX, 75055	0.92	Date of birth reformatted City re-cased Email lower-cased Placeholder values cleared
TPA-53202	TPA	Paul Foster	1983-02-05	—	8163103032	4047 Washington St, San Antonio, TX, 78240	0.92	Name re-cased Phone reformatted City re-cased Placeholder values cleared
TPA-63626	TPA	Ronald Wheeler	2001-02-14	—	—	1587 Park Pl, Plano, TX, 75076	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-57414	TPA	Matthew Watkins	2009-03-02	—	—	3179 Baseline Rd, Jacksonville, FL, 32231	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
TPA-56600	TPA	Laura Watkins	1961-02-15	UHC-86062-54	—	2762 Willow Ct, Mesa, AZ, 85231	0.92	Name re-cased City re-cased State code upper-cased Placeholder values cleared
TPA-51420	TPA	Harrold Cox	1990-07-21	—	8966329013	7364 Lincoln Way, Las Vegas, NV, 89137	0.92	Date of birth reformatted Phone reformatted City re-cased Placeholder values cleared
TPA-60002	TPA	Michelle Burns	1938-06-03	—	—	4095 Park Pl, Dallas, TX, 75205	0.92	Date of birth reformatted City re-cased Whitespace trimmed Placeholder values cleared

2,455 rows, page 45 of 50Previous Next