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 “City re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagCity re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-110005	ENR	Gregory Wagner	1987-12-28	UHC-51627-22	9418383423	6925 Broadway, Miami, FL, 33105	0.82	Phone reformatted City re-cased State name converted to code
ENR-119359	ENR	Jack Schmidt	1991-03-04	UHC-82922-67	6667473273	9893 Lincoln Way, Los Angeles, CA, 90017	0.82	Name split from “Last, First”City re-cased Whitespace trimmed
ENR-141471	ENR	Sarah Cook	2000-11-01	UHC-38179-85	5643981115	103 Grand Ave, Dallas, TX, 75219	0.82	Name re-cased Two-digit birth year City re-cased
ENR-134063	ENR	Pamela Medina	1945-06-06	UHC-50999-12	3906878493	9511 Sunset Blvd, Sacramento, CA, 95850	0.82	Name re-cased City re-cased ZIP+4 trimmed
ENR-104368	ENR	Jose Dixon	1981-03-27	UHC-56158-59	4527783899	8241 Sage Ct, Tampa, FL	0.82	City re-cased ZIP missing Whitespace trimmed
ENR-112931	ENR	Cheryl Reynolds	1953-08-14	UHC-88997-77	7705957579	6593 Valley View Dr, Dallas, TX, 75283	0.82	Phone reformatted SSN last four extracted City re-cased
ENR-136787	ENR	Charles Lynch	1942-12-21	UHC-82241-22	5698153582	9784 Park Pl, Tempe, AZ, 85202	0.82	Name re-cased City re-cased Gender normalised
ENR-123896	ENR	Jessica M Boyd	1977-11-15	UHC-79586-37	5289719406	602 Cedar Ln, Denver, CO, 80297	0.82	Phone reformatted City re-cased Gender normalised
ENR-117710	ENR	Bradley Johnson	1940-08-14	UHC-61999-90	—	5772 Ocean Ave, Mesa, AZ, 85292	0.82	Name split from “Last, First”City re-cased Placeholder values cleared
ENR-103436	ENR	Charlotte R Shaw	1941-11-28	UHC-98731-47	9884248881	9013 Canyon Rd, Chandler, AZ, 85211	0.82	Street suffix standardised Address re-cased City re-cased
ENR-123953	ENR	Judith G Cunningham	1986-06-05	UHC-73518-90	7135194974	244 Broadway, Sacramento, CA, 95828	0.82	Middle initial moved out of first name Phone reformatted City re-cased
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-104675	ENR	Ed Edwards	1947-11-16	UHC-80143-15	7967009305	3370 Baseline Rd Apt 31, Jacksonville, FL, 32231	0.82	Name re-cased Unit split from street City re-cased
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-126592	ENR	Raymond R Elliott	1956-04-25	UHC-34636-62	8403759083	8816 Forest Ave, Denver, CO, 80284	0.82	Name split from “Last, First”Date of birth reformatted City re-cased
ENR-103383	ENR	Julie Wilson	1938-03-07	UHC-09434-86	5757547761	5092 Park Pl, Tempe, AZ, 85291	0.82	Street suffix standardised Address re-cased City re-cased
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-117794	ENR	Mark C Arnold	2004-12-05	UHC-13835-02	4423672499	3979 Camelback Rd, Los Angeles, CA, 90020	0.82	Phone reformatted City re-cased State name converted to code
ENR-137750	ENR	Jacob W Grant	1969-10-22	UHC-57440-22	3084346185	3053 Harbor Blvd, Tucson, AZ, 85724	0.82	City re-cased ZIP+4 trimmed Whitespace trimmed
ENR-142261	ENR	Betty B Carter	1951-10-06	UHC-07539-83	—	8161 Sunset Blvd, Atlanta, GA, 30355	0.82	Two-digit birth year City re-cased Placeholder values cleared
ENR-131751	ENR	Julia Ryan	1955-06-12	UHC-35022-68	—	5279 Canyon Rd, Mesa, AZ, 85202	0.82	Two-digit birth year City re-cased Placeholder values cleared
ENR-103521	ENR	Steven Ortiz	1954-08-10	UHC-99424-41	7704076115	4945 Elm St, Charlotte, NC, 28244	0.82	Street suffix standardised Address re-cased City re-cased
ENR-122727	ENR	Kimberly A Flores	1976-05-10	UHC-66093-90	—	4412 Desert Sky Blvd, Columbus, OH, 43259	0.82	Phone missing area code City re-cased Whitespace trimmed
ENR-102560	ENR	Maria N James	2001-11-10	UHC-61253-13	—	9109 Broadway, Orlando, FL, 32841	0.82	SSN last four extracted City re-cased Whitespace trimmed
ENR-133183	ENR	Jnaet Davis	1974-06-07	UHC-23902-55	9444432708	7899 Bayshore Dr, Charlotte, NC, 28256	0.82	City re-cased State name converted to code Whitespace trimmed
ENR-133184	ENR	Jnaet Davis	1974-06-07	UHC-23902-55	9444432708	7899 Bayshore Dr, Charlotte, NC, 28256	0.82	City re-cased State name converted to code Whitespace trimmed
ENR-109485	ENR	Dorothy V Lopez	1990-06-05	UHC-66840-49	8266358852	4255 Sage Ct, Dallas, TX, 75208	0.82	Middle initial moved out of first name City re-cased Email lower-cased
ENR-142451	ENR	Austin C Marshall	1990-12-19	UHC-66555-53	8664714051	7141 Willow Ct, Houston, TX, 77086	0.82	Street suffix standardised Address re-cased City re-cased
ENR-142356	ENR	Julie N Knight	1989-05-17	UHC-71373-79	7629966026	9298 Lake View Rd, Tucson, AZ	0.82	Phone reformatted City re-cased ZIP missing
ENR-124364	ENR	Megan T Washington	1972-11-17	UHC-86025-95	3808779671	2946 Maple Ave # 106, Nashville, TN, 37276	0.82	Phone reformatted Unit split from street City re-cased
ENR-119727	ENR	Cheryl Castro	1950-02-04	UHC-39022-48	4342305814	570 Broadway, Phoenix, AZ, 85002	0.82	City re-cased State name converted to code Placeholder values cleared
ENR-107364	ENR	Mason P Herrera	1943-02-05	UHC-90677-97	5424196196	182 Willow Ct, Charlotte, NC	0.82	Phone reformatted City re-cased ZIP missing
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-127974	ENR	GloriaJunk	1959-09-01	UHC-12879-76	8025233117	840 Central Ave, Las Vegas, NV, 89162	0.82	City re-cased Whitespace trimmed No usable name (quarantined)
ENR-139373	ENR	Roger D Kelley	1969-01-26	UHC-99844-35	6528001976	8484 Canyon Rd, Mesa, AZ, 85248	0.82	Street suffix standardised Address re-cased City re-cased
ENR-113272	ENR	Virginia Mason	—	UHC-15433-81	5815439419	8824 Indian School Rd, Atlanta, GA, 30306	0.82	Date of birth missing Phone reformatted City re-cased
ENR-142767	ENR	Zachary W Mitchell	1987-08-27	UHC-77378-20	4269049941	5449 Jefferson Ave, Charlotte, NC, 28278	0.82	Two-digit birth year Phone reformatted City re-cased
ENR-100989	ENR	Carolyn Hanson	2008-08-09	UHC-95340-58	5937236006	300 Indian School Rd, Houston, TX, 77016	0.82	Name re-cased City re-cased Gender normalised
ENR-103234	ENR	Michael Y Andrews	1960-12-07	UHC-55407-23	7437476530	561 Lake View Rd Apt 27, Tucson, AZ, 85734	0.82	Phone reformatted Unit split from street City re-cased
ENR-129628	ENR	Thomas Day	1944-02-21	UHC-61347-18	7829125892	1025 Mesa Dr, Miami, FL, 33171	0.82	Street suffix standardised Address re-cased City re-cased
ENR-117629	ENR	Luis Hunter	1997-11-24	UHC-49762-13	2293013474	189 Ocean Ave, Plano, TX, 75022	0.82	City re-cased State name converted to code Whitespace trimmed
ENR-124305	ENR	Tyler P Perez	2008-08-23	UHC-99222-11	6839772929	5578 Bayshore Dr, Atlanta, GA, 30305	0.82	Phone reformatted City re-cased Gender normalised
ENR-123958	ENR	Walter H Castillo	—	UHC-76016-86	2759980106	9338 Sage Ct, Columbus, OH, 43227	0.82	Date of birth missing Phone reformatted City re-cased
ENR-130011	ENR	Isabella P Freeman	1965-09-13	UHC-53754-47	8605143057	2072 Market St Apt 4, Los Angeles, CA, 90059	0.82	Unit split from street City re-cased Whitespace trimmed
ENR-120875	ENR	Victoria F Nelson	1941-06-07	UHC-05862-84	6445060431	9289 Sage Ct, Eden Prairie, MN, 55387	0.82	Two-digit birth year City re-cased Whitespace trimmed
ENR-103704	ENR	Luis Payne	1986-12-14	UHC-63005-41	7828538699	8681 Park Pl, Fresno, CA, 93788	0.82	City re-cased ZIP+4 trimmed Whitespace trimmed
ENR-124700	ENR	Joe Fox	1969-04-05	UHC-72012-65	5587681049	62 Broadway, Mesa, AZ, 85295	0.82	City re-cased Email lower-cased Gender normalised
ENR-132213	ENR	Ethan Anderson	1999-09-18	UHC-46586-90	—	3769 Grand Ave, Tempe, AZ, 85285	0.82	Street suffix standardised Address re-cased City re-cased
ENR-137637	ENR	Francs A Fowler	1938-07-07	UHC-89235-68	2659490434	7935 Pine Dr, Plano, TX, 75095	0.82	Name re-cased City re-cased Gender normalised
ENR-124212	ENR	Laura X Fowler	1995-10-11	UHC-12216-11	—	2359 Maple Ave, Minneapolis, MN, 55440	0.82	Two-digit birth year City re-cased Whitespace trimmed

8,423 rows, page 141 of 169Previous Next