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

Enrollment, flag “Gender normalised”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagGender normalisedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-125296	ENR	Hiroshi Harris	1992-03-24	UHC-10926-62	—	8613 Harbor Blvd, San Antonio, TX, 78204	0.82	State code upper-cased Gender normalised Whitespace trimmed
ENR-130039	ENR	Mei Scott	1958-03-16	UHC-55509-56	6875327152	3062 Forest Ave, Fresno, CA, 93708	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-130040	ENR	Mei Scott	1958-03-16	UHC-55509-56	6875327152	3062 Forest Ave, Fresno, CA, 93708	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-121240	ENR	Lauren Mills	2000-08-18	UHC-36346-77	2845734604	1484 Broadway, Atlanta, GA, 30362	0.82	Name re-cased Date of birth reformatted Gender normalised
ENR-118992	ENR	Brian Warren	1997-05-09	UHC-45028-86	8218403552	—	0.82	Name re-cased Gender normalised Placeholder values cleared
ENR-135890	ENR	Cynthia Gardner	2006-05-19	UHC-87765-08	5389188668	2372 Bayshore Dr, Scottsdale, AZ, 85235	0.82	Date of birth reformatted Phone reformatted Gender normalised
ENR-134990	ENR	Nicole U Lee	1974-01-26	UHC-13335-65	3955471006	7184 Hillcrest Rd, Dallas, TX, 75269	0.82	Name re-cased Phone reformatted Gender normalised
ENR-117506	ENR	Samantha Fowler	1956-09-06	UHC-87948-44	2933095486	—	0.82	Name re-cased Phone reformatted Gender normalised
ENR-110013	ENR	Zacchary Lawrence	1987-10-06	UHC-79800-73	2597862178	1690 Church St, Denver, CO, 80246	0.82	Name re-cased Date of birth reformatted Gender normalised
ENR-131687	ENR	Juan H Guerrero	1979-09-07	UHC-56019-66	—	3010 Hillcrest Rd, San Antonio, TX, 78242	0.82	City re-cased Gender normalised Whitespace trimmed
ENR-113315	ENR	Rebecca Schultz	1951-02-20	UHC-71809-10	3428799932	765 Sunset Blvd, Plano, TX, 75033	0.82	Name re-cased Gender normalised Placeholder values cleared
ENR-113013	ENR	Jason Guerreo	1949-07-19	UHC-14738-35	9383936989	1164 Indian School Rd, Seattle, WA, 98130	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-126504	ENR	Diane T Hughes	2002-11-27	UHC-73105-62	—	5255 River Rd, Seattle, WA, 98134	0.82	Date of birth reformatted Gender normalised Whitespace trimmed
ENR-134306	ENR	Rebecca Hoffman	1965-07-25	UHC-89652-89	6915617525	218 Apache Blvd, Las Vegas, NV, 89176	0.82	Name re-cased Date of birth reformatted Gender normalised
ENR-122474	ENR	Albert Taylor	1981-05-23	UHC-90201-19	6068672365	8003 Central Ave, Orlando, FL, 32814	0.82	Date of birth reformatted Phone reformatted Gender normalised
ENR-133655	ENR	Brenda H Wells	1961-07-12	UHC-70706-56	6507345717	5623 Maple Ave, Mesa, AZ, 85251	0.82	Name re-cased Gender normalised Whitespace trimmed
ENR-105078	ENR	Ralph Martin	1998-03-07	UHC-12107-12	8033433261	3214 Valley View Dr, Los Angeles, CA, 90098	0.82	Name re-cased Date of birth reformatted Gender normalised
ENR-109481	ENR	Jonathan F Coleman	1983-08-19	UHC-64736-32	6116831471	1446 Spring St, Denver, CO, 80248	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-114990	ENR	Jack X Robertson	2003-01-07	UHC-44315-39	2124434122	1939 Bayshore Dr, Denver, CO, 80243	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
ENR-116992	ENR	Douglas H Price	1953-12-11	UHC-87429-52	5284532774	6609 Cedar Ln, Mesa, AZ, 85203	0.82	Date of birth reformatted Phone reformatted Gender normalised
ENR-130427	ENR	Brittany O Sandoval	1970-02-25	UHC-22787-33	9126413441	9784 Jefferson Ave, Charlotte, NC, 28253	0.82	Phone reformatted City re-cased Gender normalised
ENR-140444	ENR	Zachary Z Riley	2000-09-17	UHC-04990-86	5183528692	428 Park Pl, Columbus, OH, 43285	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-127897	ENR	Scott Berry	1940-06-15	UHC-62872-22	—	—	0.82	Name re-cased Gender normalised Placeholder values cleared
ENR-139727	ENR	Marcus F Dunn	1990-11-17	UHC-23226-74	—	8841 Jefferson Ave, Orlando, FL, 32890	0.82	Name re-cased Gender normalised Placeholder values cleared
ENR-104876	ENR	Lawrence U Reyes	1964-06-27	UHC-27380-50	5842917291	—	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-110309	ENR	Jonathan Rogers	1950-07-05	UHC-35897-93	2189325429	5750 Broadway, Tampa, FL, 33660	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-113416	ENR	Kevin Wilson	1995-09-15	UHC-12259-79	7835702670	2944 Valley View Dr, Minneapolis, MN, 55410	0.82	City re-cased Gender normalised Whitespace trimmed
ENR-123259	ENR	Ray Richards	2004-02-17	UHC-22358-38	6152665615	1592 Lincoln Way, Houston, TX, 77035	0.82	Name re-cased Email lower-cased Gender normalised
ENR-135459	ENR	Brian Rice	1964-09-26	UHC-93672-68	9133722957	—	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
ENR-129103	ENR	Henry N Salazar	2006-05-10	UHC-44361-63	8067857829	3077 Park Pl, Las Vegas, NV, 89163	0.82	Date of birth reformatted Phone reformatted Gender normalised
ENR-103547	ENR	James A Ortiz	1965-01-02	UHC-45402-41	2544061010	78 Willow Ct, Houston, TX, 77043	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-108845	ENR	Gabriel M Dixon	1943-10-08	UHC-98981-43	7322140298	5028 Mesa Dr, Minneapolis, MN, 55455	0.82	Phone reformatted Gender normalised Placeholder values cleared
ENR-124917	ENR	Natalie Yang	1988-10-24	UHC-04083-81	7062754345	5985 Forest Ave, Atlanta, GA, 30320	0.82	Name re-cased Email lower-cased Gender normalised
ENR-140590	ENR	Martha Tran	1979-12-14	UHC-27532-54	7582279291	9876 Broadway, Seattle, WA, 98147	0.82	Email lower-cased Gender normalised Whitespace trimmed
ENR-134085	ENR	Ralph V Gray	1963-08-13	UHC-69832-35	6462844070	3970 Spring St, Minneapolis, MN, 55475	0.82	Phone reformatted Member ID reformatted Gender normalised
ENR-100715	ENR	George I Nichols	1992-08-10	UHC-59529-24	5595960203	—	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-105441	ENR	Eric L Lewis	1984-04-18	UHC-33199-78	—	277 Grand Ave, Tampa, FL, 33697	0.82	Name re-cased Gender normalised Placeholder values cleared
ENR-133820	ENR	Bobby U Schultz	1941-02-26	UHC-04795-68	4404742418	2048 River Rd, Chandler, AZ, 85289	0.82	Date of birth reformatted Email lower-cased Gender normalised
ENR-140505	ENR	Matthew Y Cox	1952-01-15	UHC-62478-86	8509834923	6971 Park Pl, Atlanta, GA, 30377	0.82	Name re-cased Phone reformatted Gender normalised
ENR-136339	ENR	Michelle J Hanson	2003-04-01	UHC-84431-88	6934215584	5391 Maple Ave, Minneapolis, MN, 55406	0.82	Phone reformatted Gender normalised Placeholder values cleared
ENR-121936	ENR	Lisa I Yang	1963-12-18	UHC-78240-55	2722567161	6761 Oak St, Scottsdale, AZ, 85229	0.82	Date of birth reformatted Phone reformatted Gender normalised
ENR-113392	ENR	Henry N McDonald	2007-05-19	UHC-49111-77	7007795185	2866 Grand Ave, Orlando, FL, 32829	0.82	Date of birth reformatted Phone reformatted Gender normalised
ENR-100516	ENR	Rebecca G Reed	1958-06-08	UHC-81612-39	7932157291	2410 Canyon Rd, Atlanta, GA, 30360	0.82	Name re-cased Gender normalised Whitespace trimmed
ENR-114445	ENR	Lucia R Howell	1985-04-07	UHC-54508-07	2567041228	8793 Highland Ave, Nashville, TN, 37294	0.82	Phone reformatted Gender normalised Plan code upper-cased
ENR-106769	ENR	Susan Wagner	2007-07-17	UHC-34302-68	3227586885	5752 Apache Blvd, Glendale, AZ, 85300	0.82	Date of birth reformatted Gender normalised Whitespace trimmed
ENR-137137	ENR	Kayla A Rose	1996-12-24	UHC-21029-04	9204430871	2286 Lake View Rd, Nashville, TN, 37272	0.82	Phone reformatted Gender normalised Whitespace trimmed
ENR-131960	ENR	Wayne Z Aguilar	1976-01-05	UHC-37755-10	9115171603	9383 Spring St, Phoenix, AZ, 85057	0.82	Phone reformatted City re-cased Gender normalised
ENR-117252	ENR	Christopher S Hamilton	1984-10-03	UHC-25934-24	4644242615	—	0.82	Phone reformatted Gender normalised Placeholder values cleared
ENR-110892	ENR	Sean F Hoffman	1973-09-11	UHC-22263-86	7302776931	6889 Park Pl, Tempe, AZ, 85208	0.82	Phone reformatted Gender normalised Placeholder values cleared
ENR-123527	ENR	Virginia S Harris	1944-04-23	UHC-58262-17	8694609340	1341 Harbor Blvd, Seattle, WA, 98144	0.82	Date of birth reformatted Phone reformatted Gender normalised

7,326 rows, page 141 of 147Previous Next