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

Claims, 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
CLM-420667	CLM	Logan West	1958-12-16	UHC-35846-32	—	9527 Broadway, Orlando, FL, 32882	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-426406	CLM	Elizabeth Turner	1995-08-17	UHC-28525-34	—	5112 Ridge Rd, Minneapolis, MN, 55461	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-418804	CLM	Melissa Moreno	1988-04-02	—	—	5025 Oak St, Chandler, AZ, 85295	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-410007	CLM	Ronald Perez	1992-01-17	UHC-32632-12	—	8671 Pine Dr, Austin, TX, 78765	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-423770	CLM	Jen Garza	1980-06-02	UHC-27370-28	8419460041	9241 Ridge Rd, Gilbert, AZ, 85249	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-415016	CLM	Victoria Maldonado	1966-01-02	UHC-88689-50	7917734873	9385 Sage Ct, Atlanta, GA, 30348	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-410836	CLM	Albert Lucas	1979-10-06	UHC-51902-38	—	8067 Lincoln Way, Eden Prairie, MN, 55337	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-407057	CLM	Santiago Lewis	1973-11-02	UHC-28296-11	—	1083 Sage Ct, Fresno, CA, 93776	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-414910	CLM	Maria Warren	1939-08-17	—	—	7583 Market St, Plano, TX, 75028	0.94	City re-cased State code upper-cased Placeholder values cleared
CLM-425093	CLM	Paul G Luna	1974-05-11	UHC-71549-96	—	9143 Union St, Glendale, AZ, 85333	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-432131	CLM	George N Berry	2006-06-25	UHC-53417-41	—	2479 Broadway, San Diego, CA, 92135	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-427827	CLM	Santiago Hawkins	1965-05-25	UHC-55074-11	6226261917	682 Washington St, Tampa, FL, 33657	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-425428	CLM	Sharon B Watson	1967-08-23	—	—	6446 Main St, Dallas, TX, 75297	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-409292	CLM	Benjamin Moreno	2000-08-10	UHC-43144-61	—	9459 Highland Ave, Glendale, AZ, 85364	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-406071	CLM	Amy Morris	1950-01-21	UHC-22208-49	3172801482	9661 Broadway, Minneapolis, MN, 55498	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-406477	CLM	Carlos Walsh	1986-04-23	UHC-10139-71	5678805850	1398 River Rd, Fresno, CA, 93741	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-400792	CLM	Roy Fisher	1967-07-02	UHC-91505-50	—	323 Baseline Rd, Tampa, FL, 33699	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-403141	CLM	Margaret Bailey	1998-10-13	UHC-09162-99	—	9793 Elm St, Orlando, FL, 32804	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-428199	CLM	Jesse Baker	1985-01-05	UHC-05897-89	—	6412 Lincoln Way, Houston, TX, 77033	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-416857	CLM	Terry I Richardson	1984-07-04	UHC-96410-44	—	921 Main St, Chandler, AZ, 85220	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-427604	CLM	Joey C Day	1948-02-19	UHC-72292-79	—	6135 Apache Blvd, Miami, FL, 33133	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-419927	CLM	Stephen Howell	1954-12-27	UHC-45967-81	—	6861 Baseline Rd, Denver, CO, 80269	0.94	City re-cased State code upper-cased Placeholder values cleared
CLM-409895	CLM	Christine George	2006-08-21	—	—	2631 Highland Ave, Austin, TX, 78729	0.94	City re-cased Plan code upper-cased Placeholder values cleared
CLM-411024	CLM	Olivia Ramirez	2002-09-06	—	—	3487 Oak St, Austin, TX, 78763	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-404700	CLM	Juseph Obrien	1978-10-10	—	6749279236	464 Forest Ave, Jacksonville, FL, 32266	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-403784	CLM	Heather Walsh	1942-10-11	UHC-45163-98	9213022278	6927 Oak St, Eden Prairie, MN, 55365	0.94	Date of birth reformatted Phone reformatted City re-cased
CLM-409443	CLM	Aaron Hunt	2002-12-12	UHC-82591-72	—	1069 Lincoln Way, Nashville, TN, 37204	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-429221	CLM	Aisah Larson	1949-09-22	—	—	3250 Broadway, Eden Prairie, MN, 55381	0.94	Address re-cased City re-cased Placeholder values cleared
CLM-406414	CLM	Anthony Barnes	1974-08-04	—	—	4823 Highland Ave, Phoenix, AZ, 85069	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-419267	CLM	Cheryl A Brown	2005-07-19	—	—	872 Willow Ct, Las Vegas, NV, 89105	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-416157	CLM	Megan Diaz	1959-07-04	—	—	6636 Market St, Plano, TX, 75098	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-427236	CLM	Joseph Turner	1957-06-14	UHC-12535-13	—	4916 Camelback Rd, Tampa, FL, 33682	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-417325	CLM	Dennis U Carroll	1943-02-20	UHC-89739-33	—	7211 Broadway, Glendale, AZ, 85375	0.94	Address re-cased City re-cased Placeholder values cleared
CLM-414663	CLM	Gary W Bryant	2003-09-22	UHC-95416-52	—	8554 Meadow Ln, Tucson, AZ, 85761	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-414664	CLM	Gary W Bryant	2003-09-22	UHC-95416-52	—	8554 Meadow Ln, Tucson, AZ, 85761	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-427074	CLM	Deborah Obrien	1991-02-05	—	—	6867 Main St, Los Angeles, CA, 90099	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-430520	CLM	Ronald Guzman	2008-01-21	UHC-49979-38	—	3336 Church St, Tampa, FL, 33693	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-404382	CLM	Arthur Meyer	1985-07-06	UHC-06599-74	—	1047 Mountain View Dr, Houston, TX, 77050	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-407249	CLM	Bobby Turner	1938-02-19	UHC-59366-90	—	7255 Church St, Houston, TX, 77053	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-412932	CLM	Nicholas Price	1942-09-03	—	8266868530	5158 Baseline Rd, Fresno, CA, 93794	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-412626	CLM	Eric Bradley	2003-07-12	UHC-27162-40	—	3766 Main St, Orlando, FL, 32810	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-404202	CLM	George Lewis	2005-02-23	UHC-96111-39	—	2743 Sunset Blvd, Chandler, AZ, 85244	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-425719	CLM	Nancy Peterson	1982-02-14	UHC-74186-80	—	4126 Highland Ave, Los Angeles, CA, 90052	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-410421	CLM	Andrew Ward	1990-04-28	—	—	9830 Maple Ave, Atlanta, GA, 30352	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-407879	CLM	Scott I Santos	1961-03-20	UHC-17213-41	5182202106	7425 Jefferson Ave, Eden Prairie, MN, 55304	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-412839	CLM	Ryan Grant	1989-09-27	—	7404363040	6174 Valley View Dr, Tucson, AZ, 85708	0.94	Phone reformatted City re-cased Placeholder values cleared
CLM-431997	CLM	Ralph Mejia	1955-01-02	UHC-24782-47	3845363782	9551 Willow Ct, Dallas, TX, 75228	0.94	City re-cased Whitespace trimmed Placeholder values cleared
CLM-402264	CLM	Gregory X McCoy	1942-05-15	UHC-38818-96	—	8994 Lake View Rd, Nashville, TN, 37293	0.94	Date of birth reformatted City re-cased Placeholder values cleared
CLM-427798	CLM	Thomas Fox	1957-08-02	—	—	8606 Pine Dr, Nashville, TN, 37293	0.94	Name re-cased City re-cased Placeholder values cleared
CLM-406891	CLM	Albert V Miller	1942-04-13	—	—	9252 Lincoln Way, Tampa, FL, 33629	0.94	City re-cased Whitespace trimmed Placeholder values cleared

5,235 rows, page 100 of 105Previous Next