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 “Phone missing area code”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagPhone missing area codeClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-56531	TPA	Dnise Harrison	1977-01-12	—	—	—	0.80	Name re-cased Date of birth reformatted Phone missing area code Placeholder values cleared
TPA-54626	TPA	Sean Silva	1959-05-03	UHC-15160-88	—	7819 Church St, Chandler, AZ, 85221	0.80	Date of birth reformatted Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-55626	TPA	Brittany Hernandez	1972-01-22	—	—	—	0.80	Name re-cased Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-57013	TPA	Brenda Nelson	1946-06-04	—	—	1315 Market St, Gilbert, AZ, 85222	0.80	Name re-cased Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-61078	TPA	Madison Black	1995-03-09	—	—	5866 Sunset Blvd, Tucson, AZ, 85747	0.80	Name re-cased Date of birth reformatted Phone missing area code Placeholder values cleared
TPA-58105	TPA	Joshua Contreras	1959-04-17	—	—	8975 Ocean Ave, Denver, CO, 80271	0.80	Date of birth reformatted Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-51435	TPA	Greg Romero	1958-11-23	—	—	—	0.80	Name re-cased Date of birth reformatted Phone missing area code Placeholder values cleared
TPA-63946	TPA	Andrea Silva	1968-07-26	—	—	—	0.80	Date of birth reformatted Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-56875	TPA	Aizha Patel	1941-10-21	—	—	—	0.80	Name re-cased Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-56470	TPA	Mariana Z Luna	1951-12-20	—	—	—	0.80	Name re-cased Date of birth reformatted Phone missing area code Placeholder values cleared
TPA-60430	TPA	Jerry White	1996-12-23	—	—	2285 Sage Ct, Seattle, WA, 98181	0.80	Date of birth reformatted Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-61337	TPA	Scott B Moreno	1943-03-17	—	—	2645 Park Pl, Sacramento, CA, 95841	0.80	Phone missing area code City re-cased Whitespace trimmed Placeholder values cleared
TPA-63312	TPA	Ray Castillo	1944-12-19	—	—	3054 Central Ave, Nashville, TN, 37289	0.80	Date of birth reformatted Phone missing area code State code upper-cased Placeholder values cleared
TPA-53682	TPA	Vinent Moreno	1975-02-13	—	—	9606 Pine Dr, Jacksonville, FL, 32278	0.80	Name re-cased Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-59803	TPA	Edward Reed	1957-05-20	—	—	1422 Lincoln Way, San Antonio, TX, 78207	0.80	Date of birth reformatted Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-60993	TPA	Stephanie Collins	1974-08-04	UHC-85615-89	—	7122 Mesa Dr, Atlanta, GA, 30315	0.82	Name re-cased Phone missing area code Whitespace trimmed
TPA-55575	TPA	Patricia Howard	1946-03-17	—	—	8106 Camelback Rd, Sacramento, CA, 95811	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
TPA-58620	TPA	Nick Bailey	1999-12-18	—	—	—	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-62064	TPA	Isabella George	1988-11-27	—	—	9793 Lake View Rd, Austin, TX, 78766	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
TPA-50707	TPA	Cynthia Perkins	1964-04-13	—	—	—	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-54833	TPA	Fatima Collins	1999-12-24	—	—	9073 Lincoln Way, Denver, CO, 80205	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
TPA-58224	TPA	Edward Russell	1991-02-21	—	—	7133 Meadow Ln, Tucson, AZ, 85795	0.82	Name re-cased Phone missing area code Placeholder values cleared
TPA-62544	TPA	Arthur Rivera	1966-04-15	UHC-43347-56	—	8948 Apache Blvd, Houston, TX, 77054	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
TPA-58270	TPA	Martha R Bennett	1948-03-18	—	—	—	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
TPA-62497	TPA	Ana Adams	1944-07-09	—	—	9369 Ocean Ave, Phoenix, AZ, 85085	0.82	Name re-cased Phone missing area code Placeholder values cleared
TPA-50448	TPA	Arjun McCoy	1954-10-07	—	—	2077 Spring St, Dallas, TX, 75247	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
TPA-54261	TPA	Linda Matthews	2000-05-27	—	—	5828 Baseline Rd, Tampa, FL, 33693	0.82	Date of birth reformatted Phone missing area code Placeholder values cleared
TPA-52046	TPA	Julia Pena	1937-11-13	—	—	8514 Indian School Rd, Phoenix, AZ, 85074	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-63536	TPA	Lisa Y Larson	1984-07-02	—	—	6402 Sage Ct, Orlando, FL, 32890	0.82	Phone missing area code Whitespace trimmed Placeholder values cleared
TPA-53726	TPA	Donald Fields	1981-05-24	—	—	7784 Broadway, Houston, TX, 77076	0.82	Phone missing area code City re-cased Placeholder values cleared
TPA-56803	TPA	Paul Lewis	1972-03-11	—	—	8134 Harbor Blvd, Houston, TX, 77003	0.82	Name re-cased Phone missing area code Placeholder values cleared
TPA-54619	TPA	Frank Stephens	1983-04-08	—	—	8890 Lincoln Way, Chandler, AZ, 85223	0.84	Phone missing area code Placeholder values cleared
TPA-53351	TPA	Russell Marshall	1998-01-25	—	—	—	0.84	Phone missing area code Placeholder values cleared
TPA-62349	TPA	Katherine Santiago	1963-12-21	UHC-57983-34	—	2026 Sunset Blvd, Denver, CO, 80221	0.84	Phone missing area code Placeholder values cleared
TPA-62174	TPA	Brian Patel	1955-12-13	—	—	—	0.84	Phone missing area code Placeholder values cleared
TPA-60213	TPA	Logan Greene	1965-08-04	UHC-51467-56	—	—	0.84	Phone missing area code Placeholder values cleared
TPA-52231	TPA	Valentina Alvarado	1953-06-20	—	—	—	0.84	Phone missing area code Placeholder values cleared

187 rows, page 4 of 4Previous Next