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

All sources, 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
PRV-24230	PRV	Aisha Ryan	2006-03-11	—	9812238695	7550 Spring St, Gilbert, AZ, 85220	0.62	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+3 more
ENR-110001	ENR	Edward T Jones	1980-01-23	UHC-95903-88	9737996391	2430 Canyon Rd, Gilbert, AZ, 85235	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
TPA-51305	TPA	Katherine Castillo	1953-04-28	—	5018561956	782 Highland Ave, Houston, TX, 77092	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-137172	ENR	Fatima G Pena	2003-02-23	UHC-87570-72	6183729935	6951 Washington St, Charlotte, NC, 28285	0.62	Middle initial moved out of first name Name re-cased Date of birth reformatted Street suffix standardised+3 more
TPA-50298	TPA	Frances Dominguez	1956-08-15	—	—	7201 Mountain View Dr, Minneapolis, MN, 55484	0.62	Name re-cased Street suffix standardised Address re-cased City re-cased+3 more
ENR-138355	ENR	Grace Y Perry	1939-10-05	—	4417174547	5055 Washington St, Dallas, TX	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-423277	CLM	Maria Clark	1949-12-07	—	6947598833	8006 Apache Blvd, Columbus, OH, 43289	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
PRV-29027	PRV	Christopher Ross	1990-02-16	UHC-51132-99	7698326458	5213 Spring St, Seattle, WA, 98152	0.62	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+3 more
ENR-127462	ENR	Ana Ortiz	1959-05-28	UHC-28766-26	6247425118	1779 Central Ave, Atlanta, GA, 30336	0.62	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+3 more
CLM-401130	CLM	Gabriel Lane	1997-11-04	UHC-54367-09	5345232506	8839 Lincoln Way, Columbus, OH, 43268	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-130198	ENR	Brenda Fisher	2003-09-15	UHC-76248-86	6777054262	2415 Main St, Jacksonville, FL, 32258	0.62	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+3 more
CLM-420078	CLM	Maidson Flores	—	UHC-58663-08	—	4481 Mountain View Dr, Gilbert, AZ, 85252	0.62	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+3 more
TPA-51171	TPA	Frances Berrry	1944-11-28	—	5878188656	1982 Desert Sky Blvd Apt 8, Dallas, TX, 75231	0.62	Name re-cased Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-418667	CLM	Christian James	1977-10-08	UHC-82723-91	4429167211	9378 Oak St, Tempe, AZ, 85242	0.62	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+3 more
PRV-27553	PRV	Heather Meyer	1985-05-19	UHC-17486-97	6239850085	9200 Harbor Blvd, Charlotte, NC, 28252	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-134570	ENR	Andrea Elliott	1976-07-09	UHC-77603-42	7937286264	5558 Baseline Rd, Las Vegas, NV, 89192	0.62	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+3 more
TPA-50765	TPA	Anna King	1941-01-11	—	—	251 Main St, Eden Prairie, MN, 55323	0.62	Name re-cased Street suffix standardised Address re-cased City re-cased+3 more
CLM-415457	CLM	Noah Bryant	1949-03-15	UHC-89912-12	6768815208	8174 Pine Dr, Jacksonville, FL, 32262	0.62	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+3 more
CLM-408376	CLM	Ronald Dunn	1949-01-14	—	7947678863	1118 Desert Sky Blvd # 897, Fresno, CA, 93772	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
TPA-51387	TPA	Priya West	—	—	2154121453	7070 Oak St, Charlotte, NC, 28252	0.62	Name re-cased Date of birth missing Phone reformatted Street suffix standardised+3 more
CLM-404345	CLM	Amy Hanson	1938-10-03	UHC-42412-56	4793566270	8796 Bayshore Dr, Columbus, OH, 43240	0.62	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+3 more
TPA-54417	TPA	Priya Aguilar	2000-10-24	—	6652304159	6298 Pine Dr, San Diego, CA, 92143	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
PRV-25390	PRV	Sean Yang	1966-01-27	—	8445415132	9465 Palm Dr, San Diego, CA, 92191	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-129699	ENR	Kathryn Wheeler	1982-04-19	UHC-21918-10	5834311421	1776 Baseline Rd # 456, Las Vegas, NV, 89146	0.62	Name re-cased Phone reformatted Unit split from street Street suffix standardised+3 more
TPA-60882	TPA	Joyce Coleman	1971-05-08	—	7355471842	5607 Meadow Ln # 325, Los Angeles, CA, 90068	0.62	Name re-cased Phone reformatted Unit split from street Street suffix standardised+3 more
CLM-431085	CLM	Natalie R Thompson	1999-02-26	UHC-21601-34	3444885569	3722 Lincoln Way, Denver, CO, 80204	0.62	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+3 more
ENR-133019	ENR	Catherine V Day	1943-07-04	UHC-08875-72	6987277846	5538 Grand Ave, Plano, TX, 75047	0.62	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+3 more
CLM-420583	CLM	Gregory Hudson	1968-08-14	UHC-14069-21	—	7983 Hillcrest Rd # 180, Plano, TX	0.62	Name re-cased Date of birth reformatted Member ID reformatted Unit split from street+3 more
CLM-428767	CLM	Kyle Delgado	1997-02-18	UHC-21688-31	—	8719 Maple Ave, Columbus, OH, 43297	0.62	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+3 more
CLM-425141	CLM	Piya Taylor	1960-10-18	—	9334440369	2303 Hillcrest Rd, Atlanta, GA, 30347	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-123171	ENR	Charles C Wilson	2006-01-02	UHC-64551-55	8625941570	3100 Lincoln Way, Los Angeles, CA, 90077	0.62	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+3 more
ENR-118808	ENR	Grace Mitchell	1976-12-07	UHC-70804-87	—	2330 Valley View Dr, Columbus, OH, 43206	0.62	Name re-cased Two-digit birth year Member ID reformatted Street suffix standardised+3 more
TPA-57645	TPA	Raymond E Howell	1980-05-23	—	—	9124 Highland Ave, Denver, CO, 80242	0.62	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+3 more
ENR-131445	ENR	Kimberly Gibson	2004-07-23	UHC-59029-58	8095436886	3019 Mesa Dr, Houston, TX	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
TPA-59811	TPA	Samantha Peters	1997-12-01	—	—	4730 Mountain View Dr, Miami, FL, 33142	0.62	Name re-cased Street suffix standardised Address re-cased City re-cased+3 more
ENR-122406	ENR	Frank D Knight	1986-12-16	UHC-31257-06	9645119229	4119 Mesa Dr, Gilbert, AZ, 85201	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-135694	ENR	Joe H Rose	1951-06-22	UHC-91305-46	9475084966	9445 Hillcrest Rd, Plano, TX, 75063	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-140102	ENR	Janet Hawkins	1947-06-21	UHC-01906-34	7834554394	2446 Indian School Rd Apt 5, Seattle, WA, 98147	0.62	Name re-cased Unit split from street Street suffix standardised Address re-cased+3 more
ENR-123149	ENR	Christopher G Powell	1982-01-17	UHC-31697-64	8213956408	1288 Park Pl, Plano, TX, 75035	0.62	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-124674	ENR	Saamuel U Chavez	1956-10-25	UHC-02927-16	8055948700	2916 Apache Blvd, Glendale, AZ, 85381	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-124313	ENR	Mari O Harper	1941-06-14	UHC-43044-73	8067183814	48 Grand Ave Apt 12, Seattle, WA, 98157	0.62	Name re-cased Two-digit birth year Phone reformatted Unit split from street+3 more
ENR-140317	ENR	Teresa Gerza	1971-06-14	UHC-37981-33	4239666146	5421 Lincoln Way, Austin, TX, 78736	0.62	Name re-cased Street suffix standardised Address re-cased City re-cased+3 more
TPA-55240	TPA	Nicholas Morgan	1977-02-06	—	—	4559 Union St, Sacramento, CA, 95839	0.62	Name re-cased Street suffix standardised Address re-cased City re-cased+3 more
CLM-417540	CLM	Russell Moreno	2005-07-27	UHC-08496-11	—	8906 Broadway, Plano, TX, 75023	0.62	Name re-cased Date of birth reformatted SSN last four extracted State code upper-cased+3 more
ENR-119414	ENR	Gonzales A Jessica	2001-12-06	UHC-80195-34	6082602906	4876 Camelback Rd, Austin, TX, 78705	0.62	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+3 more
PRV-26560	PRV	Jacob Wallace	1969-05-04	UHC-66285-29	8632623231	9419 Sage Ct, Minneapolis, MN, 55451	0.62	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+3 more
ENR-136156	ENR	Valentina Kelly	1949-08-01	UHC-36802-31	2294031985	4990 Church St, Atlanta, GA, 30324	0.62	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+3 more
CLM-430111	CLM	Frank Yang	1954-06-13	—	6147452696	4140 Jefferson Ave # 261, Nashville, TN, 37272	0.62	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+3 more
ENR-137120	ENR	Zachary I Banks	1983-07-03	UHC-61243-13	9259075168	2526 Union St, Orlando, FL, 32802	0.62	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+3 more
ENR-124377	ENR	Wayne G Bishop	1999-10-26	UHC-11867-64	7338562727	4665 Palm Dr, Denver, CO, 80255	0.62	Name re-cased Phone reformatted Street suffix standardised Address re-cased+3 more

39,996 rows, page 127 of 800Previous Next