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 “Name re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagName re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-56235	TPA	Kathleen Morris	1962-10-27	—	—	4720 Apache Blvd, Tucson, AZ, 85750	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-59637	TPA	Beverly Vasquez	1980-01-13	—	2784063649	3211 Meadow Ln, Denver, CO, 80216	0.94	Name re-cased Date of birth reformatted City re-cased
TPA-56506	TPA	Kevin Wallace	1981-03-11	UHC-64153-44	—	8690 Harbor Blvd, San Diego, CA, 92155	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-58597	TPA	Matthew K Kelley	1954-01-02	—	2295604446	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-62562	TPA	Olivia Gilbert	1972-07-07	—	2306390465	—	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-51703	TPA	Thomas Welch	2004-12-10	—	—	7503 Broadway, Plano, TX, 75050	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-52345	TPA	Luis W Hill	1942-10-27	UHC-27600-40	—	7828 Meadow Ln, Gilbert, AZ, 85271	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-53669	TPA	Mason Maldonado	1982-10-08	—	—	—	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-58088	TPA	Kelly H Richardson	1959-01-18	—	—	1166 Sunset Blvd, Atlanta, GA, 30394	0.94	Name re-cased City re-cased Placeholder values cleared
TPA-60194	TPA	Sara P Wallace	1970-10-27	UHC-48359-67	—	298 Ridge Rd, Minneapolis, MN, 55471	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-58494	TPA	Hannah K Lane	1981-02-02	—	—	4374 Grand Ave, Jacksonville, FL, 32203	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-52389	TPA	Ryan Carroll	1964-06-12	—	—	—	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-51738	TPA	Ethan Rios	1992-05-13	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-52367	TPA	Nichloas Williams	1952-10-11	—	—	4596 Valley View Dr, Orlando, FL, 32877	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-55246	TPA	Emily Ryan	1955-12-20	—	5599225285	7230 Central Ave, Austin, TX, 78750	0.94	Name re-cased Phone reformatted Placeholder values cleared
TPA-60628	TPA	Noah Willis	1989-12-23	—	6124975569	526 Sage Ct, Sacramento, CA, 95846	0.94	Name re-cased City re-cased Placeholder values cleared
TPA-53941	TPA	Brittany Hawkins	1982-05-12	UHC-09960-63	—	2844 Meadow Ln, Los Angeles, CA, 90098	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-52758	TPA	Pamela Hill	1943-02-01	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-52267	TPA	Janice Robertson	2007-08-28	—	—	8290 Broadway, Charlotte, NC, 28224	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-57289	TPA	Debra Wagner	1967-06-21	—	7785471930	—	0.94	Name re-cased Phone reformatted Placeholder values cleared
TPA-50176	TPA	Sara Castillo	1978-01-28	—	2196321798	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-56559	TPA	Nicole Banks	1949-11-11	—	—	2501 Apache Blvd, Tampa, FL, 33664	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-57759	TPA	Emma Reid	1993-07-11	—	—	5948 Palm Dr, Mesa, AZ, 85238	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-64442	TPA	Eugene N Obrien	2006-10-05	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-59508	TPA	Mark Bryant	1993-06-04	—	—	—	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-50722	TPA	Martha Harrison	1980-03-26	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-57464	TPA	Anthony Garcia	2008-06-19	—	—	1099 Baseline Rd, Denver, CO, 80282	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-62889	TPA	Elizabeth Olson	1946-11-20	—	5755586667	—	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-58868	TPA	Julia Rice	1993-04-10	—	—	2155 Valley View Dr, Fresno, CA, 93782	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-53670	TPA	Nicholas Phillips	1985-06-03	—	8929835817	804 Cedar Ln, Mesa, AZ, 85271	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-51054	TPA	Karen Simpson	1987-05-19	—	—	7760 Apache Blvd, San Antonio, TX, 78249	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-56949	TPA	Lauren Davis	1980-12-09	—	—	3712 Main St, Columbus, OH, 43293	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-54777	TPA	Evelyn Garrett	1942-11-19	—	5257687724	—	0.94	Name re-cased Phone reformatted Placeholder values cleared
TPA-59074	TPA	Amanda West	1947-03-04	—	8689155554	2156 Apache Blvd, Las Vegas, NV, 89197	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-63600	TPA	Marilyn U Spencer	1979-04-01	—	—	1867 Market St, Miami, FL, 33155	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-63042	TPA	Patricia Wilson	1962-09-25	—	2682941704	7558 Mesa Dr, Columbus, OH, 43220	0.94	Name re-cased City re-cased Placeholder values cleared
TPA-59321	TPA	Sofia Thompson	1987-07-21	—	—	—	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-63920	TPA	Sara Z Spencer	2000-07-13	UHC-62855-10	—	9551 Harbor Blvd, Mesa, AZ, 85240	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-63083	TPA	Tony Cunningham	1940-06-28	—	3313958903	—	0.94	Name re-cased Phone reformatted Placeholder values cleared
TPA-64053	TPA	Lawrence Scott	1993-10-27	—	—	9111 Pine Dr, Chandler, AZ, 85293	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-53973	TPA	Ana Cook	1938-07-28	—	4469554109	—	0.94	Name re-cased Phone reformatted Placeholder values cleared
TPA-54295	TPA	Denise Montgomery	1954-08-07	—	7246969723	9421 Pine Dr, Houston, TX, 77069	0.94	Name re-cased City re-cased Placeholder values cleared
TPA-58761	TPA	Zachary Mendoza	1960-10-22	—	7292330664	1872 Oak St, Houston, TX, 77089	0.94	Name re-cased Phone reformatted Placeholder values cleared
TPA-56683	TPA	Joshua V Gordon	1958-12-25	—	—	4104 Union St, Jacksonville, FL, 32286	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-50026	TPA	Natalie Salazar	1957-02-22	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-64110	TPA	Evelyn Simmons	1938-11-26	—	—	—	0.94	Name re-cased Date of birth reformatted Placeholder values cleared
TPA-52867	TPA	Jesze Pierce	1960-02-11	—	—	8153 Broadway, Las Vegas, NV, 89190	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-62634	TPA	Ana Carr	1981-08-17	—	—	—	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-61294	TPA	Rachel Griffin	1958-07-06	UHC-00904-38	—	3033 Camelback Rd, Tampa, FL, 33643	0.94	Name re-cased Whitespace trimmed Placeholder values cleared
TPA-57274	TPA	Margaret Tucker	1992-08-05	—	—	3606 Mesa Dr, San Diego, CA, 92146	0.94	Name re-cased Whitespace trimmed Placeholder values cleared

5,750 rows, page 103 of 115Previous Next