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

Provider network, flag “Phone reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagPhone reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-27854	PRV	Kayla P Gumez	2007-10-28	—	9705218394	5853 Church St, Scottsdale, AZ, 85259	0.96	Phone reformatted Placeholder values cleared
PRV-23438	PRV	Austin Bryant	2006-12-17	UHC-63037-48	2946316629	6850 Spring St, Orlando, FL, 32899	0.96	Phone reformatted Placeholder values cleared
PRV-28240	PRV	Diana Brooks	1970-11-24	UHC-64888-77	6696603198	—	0.96	Phone reformatted Placeholder values cleared
PRV-22516	PRV	Vincent Stvens	1975-10-05	UHC-60712-59	4723952432	1528 Baseline Rd, Sacramento, CA, 95845	0.96	Phone reformatted Placeholder values cleared
PRV-29395	PRV	Asiha Warren	1954-02-24	UHC-69267-08	8815888540	—	0.96	Phone reformatted Placeholder values cleared
PRV-26828	PRV	Jon Santiago	1966-04-23	UHC-29521-60	4828510911	3230 Market St, San Diego, CA, 92185	0.96	Phone reformatted Placeholder values cleared
PRV-20883	PRV	Deborah L Ortaga	1967-01-13	—	7462136419	4916 Market St, Dallas, TX, 75219	0.96	Phone reformatted Placeholder values cleared
PRV-25975	PRV	Chritine Jimenez	2000-08-25	UHC-90658-11	4772797465	7936 Mountain View Dr, Eden Prairie, MN, 55324	0.96	Phone reformatted Whitespace trimmed
PRV-25080	PRV	Kayla L Gibson	1942-11-11	UHC-77064-16	6126257015	522 Washington St, Eden Prairie, MN, 55391	0.96	Phone reformatted Placeholder values cleared
PRV-21707	PRV	Hiroshi Y Price	1975-01-23	UHC-21169-37	4393906066	—	0.96	Phone reformatted Placeholder values cleared
PRV-24229	PRV	Mary Weever	1944-05-01	—	2884220512	2173 Main St, Gilbert, AZ, 85268	0.96	Phone reformatted Placeholder values cleared
PRV-20945	PRV	Dylan Stone	1961-03-05	UHC-00232-43	4332721170	1977 Market St, Denver, CO, 80248	0.96	Phone reformatted Placeholder values cleared
PRV-21384	PRV	Melissa Larson	1941-03-18	UHC-49577-53	5585245210	8354 Lake View Rd, San Diego, CA, 92139	0.96	Phone reformatted Placeholder values cleared
PRV-22469	PRV	Pamela Gardner	1964-03-03	—	3028214106	—	0.96	Phone reformatted Placeholder values cleared
PRV-21077	PRV	Omar Knight	1954-03-18	UHC-76996-54	7195293740	6084 Grand Ave, Phoenix, AZ, 85090	0.96	Phone reformatted Placeholder values cleared
PRV-25385	PRV	Henry D Oliver	1983-04-09	—	8469976841	—	0.96	Phone reformatted Placeholder values cleared
PRV-20451	PRV	Aisha Allen	1938-10-20	—	6799529957	6490 Baseline Rd, Minneapolis, MN, 55470	0.96	Phone reformatted Placeholder values cleared
PRV-20356	PRV	Natalie H Williams	1960-03-13	—	4678449886	—	0.96	Phone reformatted Placeholder values cleared
PRV-23433	PRV	Julia Adams	1962-04-13	UHC-29398-05	6208274753	—	0.96	Phone reformatted Placeholder values cleared
PRV-27850	PRV	Eric L Lucas	1942-07-13	UHC-03105-72	8038369163	—	0.96	Phone reformatted Placeholder values cleared
PRV-23589	PRV	Harold Smith	1964-12-25	UHC-54412-91	4263676235	6838 Camelback Rd, Denver, CO, 80214	0.96	Phone reformatted Member ID reformatted
PRV-29401	PRV	Richard T Burns	1955-09-02	—	5407299760	—	0.96	Phone reformatted Placeholder values cleared
PRV-28672	PRV	Linda Russell	1985-11-06	—	8348100444	—	0.96	Phone reformatted Placeholder values cleared
PRV-26626	PRV	Amanda Alexander	1938-02-27	UHC-10695-82	9336832337	879 Sunset Blvd, Houston, TX, 77027	0.96	Phone reformatted Placeholder values cleared
PRV-28587	PRV	Kayla B Dominguez	2005-12-04	UHC-24025-42	7923689334	3204 Bayshore Dr, Plano, TX, 75051	0.96	Phone reformatted Placeholder values cleared
PRV-25521	PRV	Alexander Ray	1986-05-02	UHC-84597-48	5994177794	8891 Lincoln Way, Denver, CO, 80277	0.96	Phone reformatted Placeholder values cleared
PRV-29280	PRV	Mari Tran	1982-06-18	UHC-00957-09	6316433919	5726 Park Pl, Phoenix, AZ, 85061	0.96	Phone reformatted Placeholder values cleared
PRV-21233	PRV	Emma Jensen	1953-11-01	—	5953407948	—	0.96	Phone reformatted Placeholder values cleared
PRV-22422	PRV	Sarah Spencer	2001-06-11	UHC-56619-38	7296822004	1763 Ridge Rd, Eden Prairie, MN, 55316	0.96	Phone reformatted Placeholder values cleared
PRV-21686	PRV	Emily Bradley	2005-11-03	UHC-18201-75	2312056743	1546 Bayshore Dr, Chandler, AZ, 85239	0.96	Phone reformatted Placeholder values cleared
PRV-20530	PRV	Priya Bryant	1995-09-20	—	9698744362	2965 Lake View Rd, Chandler, AZ, 85288	0.96	Phone reformatted Placeholder values cleared
PRV-26289	PRV	Jonathan Msaon	1979-10-23	—	7702168246	—	0.96	Phone reformatted Placeholder values cleared
PRV-28367	PRV	Harold Li	1984-09-24	UHC-16200-68	9835038749	—	0.96	Phone reformatted Placeholder values cleared
PRV-20430	PRV	Anna X Anderson	1992-10-03	UHC-58405-22	6048405401	7973 Ocean Ave, Phoenix, AZ, 85094	0.96	Phone reformatted Placeholder values cleared
PRV-28684	PRV	Betty Peters	1971-02-24	—	2523820369	6038 Market St, Scottsdale, AZ, 85229	0.96	Date of birth reformatted Phone reformatted
PRV-25415	PRV	Kathleen Owens	1956-02-10	—	7637022018	—	0.96	Phone reformatted Placeholder values cleared
PRV-21471	PRV	Alan Rios	2002-11-20	UHC-32796-59	3025516496	—	0.96	Phone reformatted Placeholder values cleared
PRV-26112	PRV	Melissa Hansen	1996-03-18	—	7109650472	5176 Lincoln Way, Las Vegas, NV, 89109	0.96	Phone reformatted Placeholder values cleared
PRV-28108	PRV	Kevin Scott	1951-12-01	UHC-71708-68	7119938218	—	0.96	Phone reformatted Placeholder values cleared
PRV-29445	PRV	Jonathan Schultz	1945-06-08	—	9373785066	—	0.96	Phone reformatted Placeholder values cleared
PRV-26249	PRV	Nathan I Nelson	1980-02-19	—	7148570254	2023 Park Pl, Tampa, FL, 33608	0.96	Phone reformatted Placeholder values cleared
PRV-26945	PRV	Danielle F Lopez	1962-01-20	UHC-62752-94	6589631962	497 Union St, Atlanta, GA, 30354	0.96	Phone reformatted Placeholder values cleared
PRV-22476	PRV	Sara Greene	1987-04-04	UHC-84724-26	2129192051	—	0.96	Phone reformatted Placeholder values cleared
PRV-23610	PRV	Angela Kennedy	1978-03-17	UHC-27371-43	6667745792	7826 Elm St, Austin, TX, 78725	0.96	Phone reformatted Placeholder values cleared
PRV-20232	PRV	Joshua Vasquaz	1940-01-03	UHC-79855-18	8276372355	8275 Washington St, Austin, TX, 78773	0.96	Phone reformatted Placeholder values cleared
PRV-23657	PRV	Bverly Perkins	1945-06-28	UHC-07200-69	2227650168	4683 Main St, Plano, TX, 75021	0.96	Phone reformatted Placeholder values cleared
PRV-27213	PRV	Kenneth Diaz	2000-11-09	—	8524546088	5393 Mountain View Dr, Orlando, FL, 32874	0.96	Phone reformatted Placeholder values cleared
PRV-25900	PRV	Randy Foster	2006-08-09	UHC-60554-67	4145874994	—	0.96	Phone reformatted Placeholder values cleared
PRV-25237	PRV	Sophia Harrison	1964-02-25	—	8814825729	—	0.96	Phone reformatted Placeholder values cleared
PRV-24885	PRV	Denny Porter	1950-05-26	—	5407620023	4248 Baseline Rd, Eden Prairie, MN, 55341	0.96	Phone reformatted Placeholder values cleared

5,906 rows, page 118 of 119Previous Next