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-137437	ENR	Mei H Torres	1961-08-22	UHC-13007-34	2879328570	7477 Oak St, Fresno, CA, 93730	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-118713	ENR	Ahmed Y Marshall	1985-05-08	UHC-22732-24	4986064229	4444 Canyon Rd, Sacramento, CA, 95839	0.78	Name split from “Last, First”Date of birth reformatted Phone reformatted City re-cased+1 more
ENR-114805	ENR	Gloria M Fernandez	1947-02-01	UHC-56741-53	9162939277	4132 Ocean Ave, Dallas, TX, 75207	0.78	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-124987	ENR	Elizabeth Simmons	1985-06-17	UHC-07694-89	9257653754	9041 Baseline Rd, Fresno, CA, 93797	0.78	Street suffix standardised Address re-cased City re-cased Email lower-cased+1 more
ENR-127151	ENR	Daniel G Carroll	1969-06-20	UHC-02920-79	9338103677	6778 Elm St, Charlotte, NC, 28218	0.78	Phone reformatted City re-cased Gender normalised Whitespace trimmed+1 more
ENR-113756	ENR	Heather Q Crawford	1966-01-27	UHC-40219-93	9885618634	5137 Ridge Rd, Chandler, AZ, 85286	0.78	Name re-cased Phone reformatted City re-cased State name converted to code+1 more
ENR-122413	ENR	Jeffrey N Smith	1979-05-28	UHC-31864-23	2968655721	1670 Main St, Tucson, AZ, 85731	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-102211	ENR	Kyle Q Wang	1939-09-22	UHC-43409-27	2606172007	824 Sage Ct, Columbus, OH, 43210	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-124075	ENR	Emma K Tran	1967-11-12	UHC-03345-98	4499601696	3327 Apache Blvd, Chandler, AZ, 85276	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-117206	ENR	Sean W Berry	1969-09-12	UHC-17584-75	4473950926	8863 Harbor Blvd, Dallas, TX, 75213	0.78	Phone reformatted City re-cased State name converted to code Whitespace trimmed+1 more
ENR-121906	ENR	Kayla Murray	1988-09-07	UHC-48642-30	9564426103	6435 Palm Dr, Mesa, AZ, 85295	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
ENR-135706	ENR	Kimberly Lucas	1954-06-01	UHC-15972-91	2512450596	3323 Bayshore Dr, Tucson, AZ, 85737	0.78	Name split from “Last, First”Phone reformatted City re-cased Email lower-cased+1 more
ENR-120787	ENR	Mason Ray	1985-06-15	UHC-38900-72	3274210497	5370 Harbor Blvd, Scottsdale, AZ, 85231	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-130997	ENR	Kathryn Schmidt	1992-04-13	UHC-54467-52	8232869894	6379 Main St, Phoenix, AZ, 85000	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-106419	ENR	Marcus L Burns	1940-03-08	UHC-70611-63	2463181523	8487 Union St, Fresno, CA, 93718	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-101324	ENR	Logan King	2005-04-02	UHC-76698-04	4549009013	8129 Lake View Rd Apt 4, Glendale, AZ, 85367	0.78	Name re-cased Phone reformatted Unit split from street City re-cased+1 more
ENR-115393	ENR	Frank P Cook	1975-10-03	UHC-59565-50	7918801915	3893 Canyon Rd, Scottsdale, AZ, 85234	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-125092	ENR	Doglas O Watkins	1967-08-01	UHC-70402-53	4949360526	672 Central Ave, San Diego, CA, 92170	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-126601	ENR	Cynthia Santiago	2001-03-01	UHC-79695-95	2547929815	234 Park Pl, Austin, TX, 78779	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-123528	ENR	Virginia S Harris	1943-04-23	UHC-58262-17	8694609340	1341 Harbor Blvd, Seattle, WA, 98144	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-120301	ENR	Bill J Reynolds	1951-06-25	UHC-07356-49	5255036693	6551 Main St, Nashville, TN, 37247	0.78	Name re-cased Member ID reformatted City re-cased State name converted to code+1 more
ENR-135780	ENR	Logan R Vargas	1965-06-07	UHC-17983-86	8119287403	2581 River Rd, Las Vegas, NV, 89139	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-121966	ENR	Brittany L Flores	1952-04-15	UHC-97409-85	5477103532	795 Broadway, Jacksonville, FL, 32204	0.78	Name re-cased Date of birth reformatted City re-cased Gender normalised+1 more
ENR-106952	ENR	Sophia Schultz	1979-05-28	UHC-23034-25	2338750924	2062 Jefferson Ave, Phoenix, AZ, 85019	0.78	Date of birth reformatted Phone reformatted City re-cased Email lower-cased+1 more
ENR-124900	ENR	Gabriel J Wong	—	UHC-32961-30	—	3548 Harbor Blvd, Tampa, FL, 33636	0.78	Date of birth missing City re-cased Email lower-cased Whitespace trimmed+1 more
ENR-127739	ENR	Maria I Tran	1962-01-03	UHC-91217-99	7703936409	6940 Forest Ave, Sacramento, CA, 95826	0.78	Street suffix standardised Address re-cased City re-cased Email lower-cased+1 more
ENR-103084	ENR	Mei X Robinson	1985-01-21	UHC-52909-05	9764485448	197 Hillcrest Rd, Gilbert, AZ, 85216	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-138286	ENR	Jennifer A Williamson	1973-12-03	UHC-38196-25	6977925414	1510 Forest Ave, Seattle, WA, 98147	0.78	Name re-cased Phone reformatted City re-cased Email lower-cased+1 more
ENR-115976	ENR	Kayla R Espinoza	1954-03-25	UHC-30148-79	7047464785	6834 Sage Ct, Atlanta, GA, 30351	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-122235	ENR	Carol F Wheeler	1943-02-08	UHC-34595-03	2182566087	6835 Maple Ave, Denver, CO, 80242	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
ENR-118055	ENR	Jerry I Vasquez	1939-08-13	UHC-41128-37	6389572398	6965 Camelback Rd, Tampa, FL, 33681	0.78	Name split from “Last, First”Phone reformatted City re-cased State code upper-cased+1 more
ENR-122865	ENR	Dorothy E Nguyen	2001-11-04	UHC-17968-70	7729904806	1106 Valley View Dr, Las Vegas, NV	0.78	Phone reformatted City re-cased ZIP missing Whitespace trimmed+1 more
ENR-113372	ENR	Luis V Hall	1973-09-26	UHC-09047-55	7395664678	136 Ocean Ave, Columbus, OH, 43201	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-109520	ENR	Brian Y Williamson	2004-04-10	UHC-05421-47	6092037570	9500 Pine Dr, Jacksonville, FL, 32234	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-107769	ENR	Bryan L Rose	2000-06-21	UHC-43770-82	9227729481	4892 Baseline Rd # 432, Nashville, TN, 37235	0.78	Date of birth reformatted Phone reformatted Member ID reformatted Unit split from street+1 more
ENR-109251	ENR	Rachel Williamson	1969-11-07	UHC-78929-36	5647789067	7141 Valley View Dr, Tempe, AZ, 85240	0.78	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-118673	ENR	Patricia E Silva	1953-01-22	UHC-60266-54	2823677128	9668 Harbor Blvd, San Antonio, TX, 78218	0.78	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
ENR-104550	ENR	Marilyn Z Weaver	1971-07-02	UHC-95376-47	3803692073	7242 Maple Ave, Tucson, AZ, 85719	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-108082	ENR	Pat Diaz	1988-12-12	UHC-24304-39	2249143798	1160 Washington St, Minneapolis, MN, 55427	0.78	Street suffix standardised Address re-cased City re-cased State code upper-cased+1 more
ENR-136993	ENR	George V Fields	1987-06-17	UHC-90809-67	4092769378	6763 Elm St, Nashville, TN, 37254	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-141470	ENR	Debra Clark	1938-08-24	UHC-65851-76	—	7964 River Rd, Mesa, AZ, 85221	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-133305	ENR	Andrew Harper	1981-05-08	UHC-99041-25	9468199420	5722 Lincoln Way, Tempe, AZ, 85274	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
ENR-138586	ENR	Raymond J Day	1984-07-02	UHC-13009-12	8372569229	227 Elm St, Tucson, AZ, 85757	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
ENR-141390	ENR	Lus C Sanders	1972-12-14	UHC-37937-73	—	7051 Canyon Rd, Glendale, AZ, 85301	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
ENR-104369	ENR	Albert Y Diaz	1958-10-18	UHC-79011-24	2417094758	4675 Mountain View Dr, San Diego, CA, 92173	0.78	Phone reformatted City re-cased Gender normalised Whitespace trimmed+1 more
ENR-133254	ENR	Jeffrey Cook	1986-04-06	UHC-48436-17	9203834811	7290 Highland Ave, Minneapolis, MN, 55405	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
ENR-116645	ENR	Diane Bell	1949-11-19	UHC-25158-87	—	2074 River Rd, Sacramento, CA, 95847	0.78	Date of birth reformatted City re-cased ZIP+4 trimmed Email lower-cased+1 more
ENR-120633	ENR	Jack Gaza	1965-12-27	UHC-07484-53	5225966203	5373 Apache Blvd, Tempe, AZ, 85203	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-125408	ENR	Walter D Lucas	1938-06-22	UHC-43102-86	9584905029	6999 Indian School Rd, Denver, CO, 80270	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
ENR-105344	ENR	Susan Hunter	1985-02-18	UHC-60558-30	5532740818	7514 Indian School Rd, Scottsdale, AZ, 85214	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more

8,423 rows, page 113 of 169Previous Next