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 “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
ENR-131621	ENR	Anthony F Gutierrez	1986-06-16	UHC-85172-66	2296409013	7152 Sage Ct, Chandler, AZ, 85267	0.66	Middle initial moved out of first name Name re-cased Phone reformatted Gender normalised+1 more
ENR-126466	ENR	Hiroshi K Espinoza	1942-03-09	UHC-19295-48	9634076340	5158 River Rd # 196, Tucson, AZ, 85782	0.66	Name re-cased Phone reformatted Unit split from street ZIP+4 trimmed+1 more
ENR-135184	ENR	Rebecca Castillo	1951-09-27	UHC-84696-29	3837443559	5565 Grand Ave, Los Angeles, CA, 90011	0.66	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+1 more
ENR-122465	ENR	Kayla D Kelly	1939-10-19	UHC-96340-54	8818797443	1673 Harbor Blvd, Fresno, CA, 93741	0.66	Name re-cased Two-digit birth year Phone reformatted State name converted to code+1 more
ENR-104242	ENR	Kenneth S Cooper	—	UHC-97521-32	4474774516	6394 Baseline Rd, Mesa, AZ, 85234	0.66	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+1 more
ENR-121625	ENR	Fatima P Sanders	1958-04-02	UHC-05917-75	3886008236	283 Meadow Ln, Austin, TX, 78770	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-100540	ENR	Bradley Bailey	1977-08-14	UHC-33731-47	5098816964	5384 Mountain View Dr, Atlanta, GA	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
ENR-104608	ENR	Anna Grant	2008-03-24	UHC-40421-16	7807735515	982 Canyon Rd, Mesa, AZ, 85249	0.66	Name re-cased Two-digit birth year Phone reformatted ZIP+4 trimmed+1 more
ENR-103247	ENR	Debra Nguyen	1948-10-05	UHC-07786-72	2652205441	2389 Mesa Dr, Austin, TX, 78736	0.66	Name re-cased Street suffix standardised Address re-cased State name converted to code+1 more
ENR-115530	ENR	Julie J Hunt	1965-05-21	UHC-98129-61	—	4126 Maple Ave, Chandler, AZ, 85283	0.66	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
ENR-140301	ENR	Noah Bailey	1959-02-12	UHC-08608-06	4395992610	2558 Mesa Dr, Denver, CO, 80261	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-121130	ENR	Grace Burns	1977-04-13	UHC-16324-01	9536253769	6686 Mountain View Dr, Seattle, WA, 98190	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-131821	ENR	Jsaon Hoffman	1969-12-19	—	3258669488	7137 Hillcrest Rd, San Diego, CA, 92176	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-122660	ENR	Anna Romero	1956-07-16	UHC-31853-94	2327911188	2560 Lake View Rd, Miami, FL, 33188	0.66	Name re-cased City re-cased State name converted to code Gender normalised+1 more
ENR-101956	ENR	Brian Q Hansen	1985-12-21	UHC-10706-35	8674125308	2266 Ridge Rd, Glendale, AZ, 85316	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
ENR-115965	ENR	Theresa Webb	2008-09-05	UHC-57113-58	5269963685	9271 Hillcrest Rd, Austin, TX, 78735	0.66	Name re-cased SSN last four extracted Street suffix standardised Address re-cased+1 more
ENR-118266	ENR	Amber Miller	1953-10-09	UHC-91685-21	9112124742	5844 Baseline Rd Apt 13, Columbus, OH, 43292	0.66	Name re-cased Phone reformatted Unit split from street Gender normalised+1 more
ENR-111342	ENR	Jonathan Ward	2003-10-01	UHC-26295-65	7866840720	5264 Mesa Dr, San Antonio, TX, 78280	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-121902	ENR	Kyle Olson	1947-03-01	UHC-95004-65	5787238091	5525 Apache Blvd, Mesa, AZ, 85210	0.66	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+1 more
ENR-142786	ENR	Emily B Hamilton	1958-04-24	UHC-45306-29	7927784735	1869 Apache Blvd # 850, San Antonio, TX, 78278	0.66	Name re-cased Phone reformatted Unit split from street City re-cased+1 more
ENR-118514	ENR	Joe J Medina	1974-12-09	UHC-20462-95	2054182823	4669 Maple Ave, Charlotte, NC, 28233	0.66	Name re-cased Phone reformatted State name converted to code Gender normalised+1 more
ENR-136337	ENR	Grace Johnston	2008-02-14	UHC-06724-33	3084562016	5768 Jefferson Ave, Fresno, CA, 93759	0.66	Name re-cased Two-digit birth year Phone reformatted State name converted to code+1 more
ENR-126587	ENR	Ruth M Pierce	2002-09-13	UHC-19964-20	—	640 Pine Dr, Nashville, TN, 37252	0.66	Name re-cased Street suffix standardised Address re-cased State name converted to code+1 more
ENR-142510	ENR	Kelly King	1960-09-10	UHC-20472-86	—	2448 Broadway Apt 25, Nashville, TN, 37233	0.66	Name re-cased Date of birth reformatted Phone missing area code Member ID reformatted+1 more
ENR-133084	ENR	Victoria F Gaham	1970-12-07	UHC-64777-70	4406610192	2255 Cedar Ln, Las Vegas, NV, 89185	0.66	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+1 more
ENR-124741	ENR	Jon G George	1950-03-11	UHC-60964-19	2903031049	3565 Jefferson Ave, Jacksonville, FL, 32270	0.66	Name re-cased Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-101111	ENR	Samantha H Warren	1970-03-28	UHC-79304-68	4366140054	3641 Sage Ct, Scottsdale, AZ, 85208	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-109922	ENR	Daniel P Wong	—	UHC-33833-96	9673669916	4430 Meadow Ln, Jacksonville, FL	0.66	Name re-cased Date of birth unreadable Phone reformatted ZIP missing+1 more
ENR-138959	ENR	Gabriel R Howell	1943-02-05	UHC-87332-44	5866676679	2866 Harbor Blvd, Seattle, WA, 98157	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-119883	ENR	Ralph XJunk	1995-03-26	UHC-98397-43	—	1949 Spring St, Los Angeles, CA, 90061	0.66	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-131384	ENR	Arthur Wagner	1969-04-12	—	2669049018	2554 Main St, Houston, TX, 77023	0.66	Name re-cased Street suffix standardised Address re-cased Gender normalised+1 more
ENR-124547	ENR	Sam G Graham	1999-05-06	UHC-97254-51	6787984350	2511 Valley View Dr, Phoenix, AZ, 85045	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-125011	ENR	Joshua Andrews	1992-08-20	UHC-23044-84	8587926864	9339 Ocean Ave # 137, Dallas, TX, 75284	0.66	Name re-cased Phone reformatted Unit split from street Gender normalised+1 more
ENR-132521	ENR	Dennis Hernandez	1969-10-08	UHC-11310-74	5826675719	7549 Harbor Blvd, Dallas, TX, 75229	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-141861	ENR	Diego Evans	1964-06-28	UHC-07580-34	4486606449	5946 Mountain View Dr # 677, Eden Prairie, MN, 55392	0.66	Name re-cased Date of birth reformatted Unit split from street Email lower-cased+1 more
ENR-120966	ENR	Alexis Reynolds	1988-03-04	UHC-91345-99	—	5890 Harbor Blvd Apt 32, Glendale, AZ, 85387	0.66	Name re-cased Unit split from street Street suffix standardised Address re-cased+1 more
ENR-126064	ENR	Sean C Vargas	1948-02-26	UHC-82052-28	5224060065	2813 Church St, Phoenix, AZ, 85082	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-120823	ENR	Joshua X Simmons	1974-12-28	UHC-19558-30	5789115047	1213 Main St, Seattle, WA, 98148	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-108290	ENR	Santiago Oliver	2001-09-27	UHC-67432-85	7523633157	2408 Church St, Orlando, FL, 32861	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
ENR-115772	ENR	Gabriel Reynolds	1939-04-23	—	8529219991	3079 Valley View Dr, Las Vegas, NV, 89138	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-100361	ENR	Ronald A Estrada	1972-07-19	UHC-61133-79	2736186183	8013 Market St, Mesa, AZ, 85296	0.66	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
ENR-130705	ENR	Gabriel X Bell	1976-12-08	UHC-59530-27	4772846941	7713 Market St, Tampa, FL, 33634	0.66	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+1 more
ENR-136085	ENR	Margaret U Butler	1944-11-25	UHC-48996-47	4912028951	741 Canyon Rd, Minneapolis, MN, 55427	0.66	Name re-cased Phone reformatted State name converted to code Gender normalised+1 more
ENR-137679	ENR	Victoria Peters	1974-07-28	—	6819061533	2121 Sage Ct, Miami, FL	0.66	Name re-cased Phone reformatted State name converted to code ZIP missing+1 more
ENR-120437	ENR	Aisha Y Willliams	1988-06-12	UHC-18589-90	3819747385	1440 Washington St, Austin, TX, 78739	0.66	Name re-cased Street suffix standardised Address re-cased Gender normalised+1 more
ENR-109275	ENR	Eugene J Payne	—	UHC-90395-97	2367729599	9042 Ridge Rd, Denver, CO, 80225	0.66	Name re-cased Date of birth missing ZIP+4 trimmed Email lower-cased+1 more
ENR-119466	ENR	Eric X Santos	1978-03-04	UHC-22547-48	6436106217	3962 Church St, Tempe, AZ, 85223	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-119879	ENR	Teresa V Harrison	2007-01-27	UHC-56572-05	9753049752	1781 Harbor Blvd, San Antonio, TX, 78294	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-127200	ENR	Billy N Ramirez	1964-04-15	UHC-43295-81	9705343969	773 Union St, Charlotte, NC, 28213	0.66	Name re-cased Date of birth reformatted State name converted to code ZIP+4 trimmed+1 more
ENR-104643	ENR	Joe Richardson	1943-10-04	UHC-53594-59	6906491344	5386 Apache Blvd, Nashville, TN, 37204	0.66	Name re-cased Phone reformatted ZIP+4 trimmed Gender normalised+1 more

17,310 rows, page 126 of 347Previous Next