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 “Middle initial moved out of first name”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagMiddle initial moved out of first nameClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-111102	ENR	Eric S Dixon	1982-03-03	UHC-84372-72	3529264768	8307 Lake View Rd, Sacramento, CA, 95848	0.78	Middle initial moved out of first name Date of birth reformatted Phone reformatted Member ID reformatted+1 more
ENR-107399	ENR	Timothy U Garza	1945-08-01	—	8274818046	2981 Union St, Columbus, OH, 43274	0.78	Middle initial moved out of first name Date of birth reformatted Phone reformatted Whitespace trimmed+1 more
CLM-414273	CLM	Fatima I Armstrong	1995-10-03	—	7906008312	790 Bayshore Dr, Austin, TX, 78706	0.78	Middle initial moved out of first name Date of birth reformatted Phone reformatted Whitespace trimmed+1 more
ENR-114875	ENR	Alan Z Perry	1964-05-05	UHC-32955-34	7476040363	2477 Lake View Rd, Scottsdale, AZ, 85238	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
ENR-123806	ENR	Lawrence O Roberts	1982-07-10	UHC-89575-55	2407025915	8451 Jefferson Ave, Nashville, TN, 37239	0.78	Middle initial moved out of first name Date of birth reformatted Phone reformatted Email lower-cased+1 more
CLM-427902	CLM	Chuck F Sims	1988-03-08	UHC-42845-48	4295756670	1382 Sunset Blvd, Tampa, FL, 33692	0.78	Middle initial moved out of first name Date of birth reformatted Phone reformatted Whitespace trimmed+1 more
ENR-107334	ENR	Steven V Silva	1976-05-11	UHC-27793-12	6584081788	636 Maple Ave, Austin, TX, 78765	0.78	Middle initial moved out of first name Phone reformatted Member ID reformatted Whitespace trimmed+1 more
ENR-103105	ENR	Zachary K Ryan	1986-02-13	UHC-70445-91	—	9018 Forest Ave, Sacramento, CA, 95803	0.78	Middle initial moved out of first name Name re-cased City re-cased State code upper-cased+1 more
CLM-400823	CLM	Charles C Nelson	1977-04-20	UHC-36461-88	4995412528	1217 Church St, Orlando, FL, 32845	0.78	Middle initial moved out of first name Phone reformatted State code upper-cased Whitespace trimmed+1 more
ENR-103250	ENR	Fracnes C Sanders	1995-12-19	UHC-30460-10	5564345258	9272 Meadow Ln, Miami, FL, 33150	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
ENR-102456	ENR	Terry B Ruiz	1973-02-25	UHC-41911-95	7406985487	1220 Camelback Rd, Los Angeles, CA, 90053	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
ENR-141918	ENR	Helen R Martin	1996-04-09	UHC-66521-88	7377639489	8841 Market St, Minneapolis, MN, 55498	0.78	Middle initial moved out of first name Name re-cased Phone reformatted City re-cased+1 more
ENR-115796	ENR	Jason G Webb	2003-03-03	UHC-63348-73	8732769099	7904 Maple Ave, Houston, TX, 77000	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Member ID reformatted+1 more
ENR-132140	ENR	Ann O Sims	2003-11-13	UHC-16272-69	6726657957	4580 Lincoln Way, Scottsdale, AZ, 85243	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
PRV-28844	PRV	Janet W Ford	1969-10-09	—	7717112234	3521 River Rd, San Antonio, TX, 78213	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Whitespace trimmed+1 more
PRV-24184	PRV	Kathleen C Knight	1981-08-22	—	2336873624	3149 Park Pl, Dallas, TX, 75204	0.78	Middle initial moved out of first name Phone reformatted City re-cased Whitespace trimmed+1 more
ENR-142150	ENR	Ana V Hall	1956-08-16	UHC-72084-69	6015819177	7725 Elm St, Gilbert, AZ, 85203	0.78	Middle initial moved out of first name Name re-cased Phone reformatted State code upper-cased+1 more
ENR-116429	ENR	Samuel C Kelley	1955-07-10	UHC-55006-25	7046110385	5846 Mountain View Dr, Phoenix, AZ, 85012	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
PRV-25967	PRV	Hiroshi F Little	1951-07-08	UHC-78883-18	6557404130	7461 Sage Ct, Sacramento, CA, 95845	0.78	Middle initial moved out of first name Date of birth reformatted Phone reformatted Whitespace trimmed+1 more
ENR-117470	ENR	Lori X Montgomery	1976-03-03	UHC-68087-17	3637335680	—	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
CLM-421627	CLM	Arjun G Morris	1999-02-21	UHC-36733-02	8436328177	3815 Cedar Ln, Scottsdale, AZ, 85290	0.78	Middle initial moved out of first name Date of birth reformatted City re-cased Whitespace trimmed+1 more
ENR-130001	ENR	Linda O Nelson	1995-02-14	UHC-41466-73	3775554084	1516 Mountain View Dr, Los Angeles, CA, 90028	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
ENR-100780	ENR	Ralph J Lych	2004-10-24	UHC-06478-38	6814901654	4819 Valley View Dr, Las Vegas, NV, 89131	0.78	Middle initial moved out of first name Name re-cased Phone reformatted State code upper-cased+1 more
TPA-52839	TPA	Kathleen I Moore	1977-02-10	UHC-73695-03	4555666896	4834 Forest Ave, Los Angeles, CA, 90038	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
ENR-116244	ENR	Vlentina O Daniels	1994-04-20	UHC-13186-78	4535849433	8688 Palm Dr, Seattle, WA, 98108	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
TPA-56080	TPA	Kathryn Y Hart	1950-12-28	—	7066007087	—	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
ENR-138624	ENR	Jerry E Morrison	1988-09-22	UHC-74169-30	6067495667	95 Harbor Blvd, Gilbert, AZ, 85262	0.78	Middle initial moved out of first name Date of birth reformatted Phone reformatted Email lower-cased+1 more
ENR-129184	ENR	Becky D Miller	1939-04-16	UHC-49419-41	8552958875	5542 Harbor Blvd, Miami, FL, 33192	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Email lower-cased+1 more
ENR-137911	ENR	Frank K Woods	1986-01-20	UHC-50088-36	9313555987	8774 Mountain View Dr, Gilbert, AZ, 85208	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
PRV-20819	PRV	Diego A Valdez	1962-04-06	—	5768453658	—	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
ENR-135226	ENR	Nancy F Castillo	1966-04-13	UHC-74758-26	9096105832	2712 Jefferson Ave, Tucson, AZ, 85759	0.78	Middle initial moved out of first name Phone reformatted Email lower-cased Whitespace trimmed+1 more
ENR-135225	ENR	Nancy F Castillo	1966-04-13	UHC-74758-26	9096105832	2712 Jefferson Ave, Tucson, AZ, 85759	0.78	Middle initial moved out of first name Phone reformatted Email lower-cased Whitespace trimmed+1 more
ENR-106269	ENR	Robert B Perkins	1968-11-24	UHC-38217-24	6955273693	7520 Ocean Ave, Jacksonville, FL, 32240	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
ENR-135120	ENR	Ahmed D Russell	1951-03-24	UHC-99350-68	2914949633	9679 Hillcrest Rd, Los Angeles, CA, 90087	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
CLM-421511	CLM	Jeffrey Y Elliott	1948-03-01	UHC-79071-32	—	—	0.78	Middle initial moved out of first name Name re-cased Member ID reformatted Whitespace trimmed+1 more
CLM-427962	CLM	Ralph F Harper	2008-03-13	UHC-54586-42	6028804067	—	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+1 more
CLM-422467	CLM	Jeremy C Jacobs	1953-11-08	UHC-82894-81	—	—	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Whitespace trimmed+1 more
ENR-142038	ENR	William L Edwards	1941-01-11	UHC-20643-74	5536383529	4598 Church St, Scottsdale, AZ, 85291	0.80	Middle initial moved out of first name Phone reformatted Plan code upper-cased Whitespace trimmed
ENR-101812	ENR	Bryan H Hunter	1966-01-25	UHC-75918-34	4079295859	4283 Mesa Dr, Denver, CO, 80253	0.80	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed
ENR-115905	ENR	Elizbeth H Munoz	1946-03-11	UHC-50406-95	3638607662	4796 Spring St, Columbus, OH, 43205	0.80	Middle initial moved out of first name Date of birth reformatted Phone reformatted Whitespace trimmed
ENR-125790	ENR	David S Wilson	1975-04-10	UHC-64729-88	4184249732	9608 Highland Ave, Miami, FL, 33190	0.80	Middle initial moved out of first name Date of birth reformatted Phone reformatted Email lower-cased
ENR-128525	ENR	Chris E Ortega	1942-02-14	UHC-20181-23	8234727392	2376 Jefferson Ave, Tampa, FL, 33697	0.80	Middle initial moved out of first name Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-412126	CLM	Fatima Y Roertson	1941-11-02	—	—	—	0.80	Middle initial moved out of first name Date of birth reformatted Whitespace trimmed Placeholder values cleared
ENR-127283	ENR	Cheryl A Owens	1976-10-12	UHC-97448-63	4679141075	9579 Lincoln Way, Phoenix, AZ, 85022	0.80	Middle initial moved out of first name Date of birth reformatted Phone reformatted City re-cased
CLM-406998	CLM	Carol R Clark	1989-01-03	UHC-30064-04	8272257839	6078 Lincoln Way, Columbus, OH, 43226	0.80	Middle initial moved out of first name Name re-cased Phone reformatted Placeholder values cleared
CLM-423490	CLM	Ralph R Bailey	1968-01-10	—	—	—	0.80	Middle initial moved out of first name Date of birth reformatted Whitespace trimmed Placeholder values cleared
ENR-123316	ENR	Caimla N Andrews	1983-02-08	UHC-90086-43	7636097465	6518 Mesa Dr, Houston, TX, 77024	0.80	Middle initial moved out of first name City re-cased Whitespace trimmed Placeholder values cleared
ENR-136848	ENR	Rcihard H Walker	1985-12-18	UHC-48206-84	7058402548	8826 Jefferson Ave, Tucson, AZ, 85704	0.80	Middle initial moved out of first name Date of birth reformatted Phone reformatted Whitespace trimmed
ENR-102021	ENR	Santiago X Ford	1994-12-11	UHC-19531-20	8246440751	179 Apache Blvd, Tucson, AZ, 85720	0.80	Middle initial moved out of first name Name re-cased Email lower-cased Whitespace trimmed
ENR-142711	ENR	Omar K Brown	1955-11-02	UHC-34550-71	6379314123	1789 Highland Ave, Sacramento, CA, 95819	0.80	Middle initial moved out of first name Name re-cased Date of birth reformatted Email lower-cased

1,125 rows, page 20 of 23Previous Next