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 “State code upper-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagState code upper-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-22876	PRV	Jeremy James	1956-12-08	UHC-33338-98	3452840548	4486 Union St, Eden Prairie, MN, 55334	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
PRV-25187	PRV	Richard E Kelley	1963-12-07	—	2502272678	68 Desert Sky Blvd, Tucson, AZ, 85719	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
PRV-22770	PRV	Mariana O Johnson	1997-03-21	UHC-60276-16	4404821064	1867 Mountain View Dr, Dallas, TX, 75206	0.88	Name re-cased Phone reformatted State code upper-cased Email lower-cased+2 more
PRV-22471	PRV	Ronald Dunn	1949-01-14	UHC-38783-47	7947678863	1118 Desert Sky Blvd, Fresno, CA, 93772	0.88	Phone reformatted Member ID reformatted State code upper-cased Email lower-cased+2 more
PRV-20474	PRV	Maria P Peterson	1984-06-19	UHC-70195-31	8104349538	9048 Lake View Rd, Tempe, AZ, 85271	0.88	Name re-cased Phone reformatted State code upper-cased Email lower-cased+2 more
PRV-22766	PRV	Mariana J Jimenez	1965-07-21	—	9015991310	4008 Church St, Miami, FL, 33101	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
PRV-25253	PRV	Cheryl Cunningham	1963-02-20	UHC-69862-58	8194278892	9223 Elm St, Seattle, WA, 98192	0.90	Date of birth reformatted Phone reformatted Member ID reformatted State code upper-cased+1 more
PRV-24543	PRV	Philip E Marquez	1996-12-05	—	4993872619	875 Broadway, Seattle, WA, 98117	0.90	Name re-cased Phone reformatted Address re-cased State code upper-cased+1 more
PRV-26210	PRV	Mason Ortiz	2008-02-08	UHC-43983-84	8272432942	9428 Lake View Rd, Tempe, AZ, 85262	0.90	Date of birth reformatted Member ID reformatted State code upper-cased Whitespace trimmed+1 more
PRV-25777	PRV	Rachel Freeman	1974-12-07	—	9563321775	7580 Central Ave, Nashville, TN, 37276	0.90	Name re-cased City re-cased State code upper-cased Whitespace trimmed+1 more
PRV-23254	PRV	Adam A Weaver	1941-07-08	—	2108899697	4901 Spring St, Mesa, AZ, 85271	0.90	Phone reformatted City re-cased State code upper-cased Email lower-cased+1 more
PRV-27267	PRV	Frances D Jackson	1961-02-19	—	2867510402	809 Apache Blvd, Minneapolis, MN, 55415	0.90	Date of birth reformatted Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-22029	PRV	Brian J Taylor	1941-09-09	UHC-39486-76	2872784657	3111 Mesa Dr, Columbus, OH, 43207	0.90	Name re-cased Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-23540	PRV	Diego Fox	1994-05-06	—	7789553363	51 Washington St, San Diego, CA, 92115	0.90	Name re-cased Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-27555	PRV	Benjamin Turner	1986-11-22	UHC-15001-22	8614303476	8717 Desert Sky Blvd, San Antonio, TX, 78209	0.90	Name re-cased Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-23505	PRV	Ana Bradley	1999-03-06	—	7198603873	1725 Spring St, Las Vegas, NV, 89173	0.90	Name re-cased Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-29249	PRV	Douglas Cruz	1961-04-01	—	2817939656	9571 Baseline Rd, Columbus, OH, 43278	0.90	Phone reformatted City re-cased State code upper-cased Whitespace trimmed+1 more
PRV-21103	PRV	Sean Carter	1949-03-08	—	7396785895	7966 Grand Ave, Tucson, AZ, 85719	0.90	Name re-cased Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-28538	PRV	Peter I Carlson	1949-05-26	—	2592701194	206 Maple Ave, Tempe, AZ, 85230	0.90	Date of birth reformatted Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-29418	PRV	Alen S Lyynch	1959-07-02	UHC-97250-45	3839226600	7020 Elm St, Orlando, FL, 32886	0.90	Phone reformatted City re-cased State code upper-cased Whitespace trimmed+1 more
PRV-25929	PRV	Peter Reyes	1944-10-12	UHC-30205-67	9456969470	6145 Broadway, Denver, CO, 80228	0.90	Phone reformatted Address re-cased State code upper-cased Whitespace trimmed+1 more
PRV-24143	PRV	Michelle Rivera	1989-06-02	UHC-89576-64	3225737826	6134 Hillcrest Rd, Tampa, FL, 33667	0.90	Name re-cased Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-24144	PRV	Michelle Rivera	1989-06-02	UHC-89576-64	3225737826	6134 Hillcrest Rd, Tampa, FL, 33667	0.90	Name re-cased Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-28997	PRV	Brenda Grant	1974-07-20	UHC-59470-91	3353922803	6156 Washington St, Chandler, AZ, 85211	0.90	Date of birth reformatted Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-24856	PRV	Sean W Estrada	1976-12-02	—	6758554042	6902 Washington St, Atlanta, GA, 30360	0.90	Phone reformatted State code upper-cased Email lower-cased Whitespace trimmed+1 more
PRV-23808	PRV	Mariana P West	2004-11-18	UHC-69843-37	2752352705	597 Valley View Dr, Atlanta, GA, 30397	0.90	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+1 more
PRV-26549	PRV	Shraon Rose	2004-02-27	UHC-55095-57	2703965719	99 Lake View Rd, Orlando, FL, 32839	0.90	Name re-cased Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-20675	PRV	Nicole I Torres	1982-01-12	—	6313922199	6945 Market St, San Diego, CA, 92103	0.90	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+1 more
PRV-22452	PRV	Julia Jensen	1958-06-21	—	3894618707	6824 Broadway, Phoenix, AZ, 85014	0.90	Phone reformatted City re-cased State code upper-cased Whitespace trimmed+1 more
PRV-25987	PRV	Alexis Armstrong	1996-08-18	UHC-63561-95	6015868888	1658 Canyon Rd, Austin, TX, 78733	0.92	Phone reformatted Member ID reformatted State code upper-cased Placeholder values cleared
PRV-23135	PRV	Ann Ryos	2003-07-20	—	9004213373	4831 Lincoln Way, Nashville, TN, 37227	0.92	Phone reformatted State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-20851	PRV	Joshua Andrews	1958-05-24	—	8866862802	2045 Market St, Los Angeles, CA, 90098	0.92	Phone reformatted City re-cased State code upper-cased Placeholder values cleared
PRV-27549	PRV	Ahmed I Li	1952-05-11	—	8079369613	9424 Park Pl, Eden Prairie, MN, 55361	0.92	Phone reformatted State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-21618	PRV	Sofia Sims	1954-06-06	UHC-52577-70	5522203187	7390 Washington St, Fresno, CA, 93796	0.92	Phone reformatted State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-27476	PRV	Arthur Washington	2000-07-27	UHC-09983-59	—	7566 Willow Ct, Gilbert, AZ, 85294	0.92	Name re-cased State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-27988	PRV	Billy Hansen	1974-02-21	UHC-24086-77	6437986171	201 River Rd, Jacksonville, FL, 32247	0.92	Date of birth reformatted City re-cased State code upper-cased Placeholder values cleared
PRV-28160	PRV	Mei Watkins	2004-04-13	—	3914853162	7539 Elm St, San Diego, CA, 92183	0.92	Date of birth reformatted Phone reformatted State code upper-cased Placeholder values cleared
PRV-26848	PRV	Jean Lawrence	1974-03-03	UHC-43612-23	6409951893	3662 Lincoln Way, Gilbert, AZ, 85292	0.92	Date of birth reformatted City re-cased State code upper-cased Placeholder values cleared
PRV-22266	PRV	Dylan J Guerrero	1944-04-17	UHC-70949-33	5693645022	9202 Spring St, Las Vegas, NV, 89119	0.92	Name re-cased Phone reformatted State code upper-cased Placeholder values cleared
PRV-20567	PRV	Sara R Holmes	1941-12-28	—	4394379229	31 Cedar Ln, Fresno, CA, 93736	0.92	Phone reformatted State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-23593	PRV	Steven G Simmons	1956-04-13	UHC-50809-84	7293810193	763 Valley View Dr, Tempe, AZ, 85292	0.92	Date of birth reformatted Phone reformatted State code upper-cased Placeholder values cleared
PRV-23632	PRV	Anthony Harrison	1983-09-08	—	3208394348	5047 Canyon Rd, Las Vegas, NV, 89172	0.92	Phone reformatted City re-cased State code upper-cased Whitespace trimmed
PRV-21692	PRV	Ahmed Turner	1971-09-27	UHC-43070-49	6868242048	7916 Bayshore Dr, Mesa, AZ, 85211	0.92	Phone reformatted State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-21693	PRV	Ahmed Turner	1971-09-27	UHC-43070-49	6868242048	7916 Bayshore Dr, Mesa, AZ, 85211	0.92	Phone reformatted State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-27362	PRV	Ashley Moore	1966-04-16	—	2739035923	5502 River Rd, Nashville, TN, 37268	0.92	Name re-cased Phone reformatted State code upper-cased Placeholder values cleared
PRV-20761	PRV	Dona G Torres	1981-10-11	UHC-70484-11	4119959668	8447 Willow Ct, Orlando, FL, 32879	0.92	Phone reformatted State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-26433	PRV	Matthew Marquez	1963-03-11	—	3106503184	3974 Harbor Blvd, Sacramento, CA, 95824	0.92	Phone reformatted State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-23871	PRV	Martha B Campbell	1939-01-15	UHC-30282-20	4762731071	4725 Highland Ave, Plano, TX, 75075	0.92	Member ID reformatted State code upper-cased Whitespace trimmed Placeholder values cleared
PRV-27892	PRV	Matthew Warren	1958-10-03	UHC-53986-45	—	6845 Lake View Rd, San Diego, CA, 92154	0.92	Date of birth reformatted Member ID reformatted State code upper-cased Placeholder values cleared
PRV-28918	PRV	Ahmed James	1988-02-08	—	8457303632	818 Jefferson Ave, Austin, TX, 78754	0.92	Phone reformatted State code upper-cased Whitespace trimmed Placeholder values cleared

377 rows, page 7 of 8Previous Next