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 “Phone reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagPhone reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-425166	CLM	Camila Hanson	2008-01-09	UHC-25006-69	9133989663	9600 Lincoln Way, Nashville, TN, 37256	0.80	Phone reformatted State name converted to code Plan code upper-cased Placeholder values cleared
CLM-413435	CLM	Andrew Bell	1964-08-20	UHC-15391-25	2772428230	5494 Union St, San Antonio, TX, 78287	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-415104	CLM	Ralph Oliver	1995-03-26	—	9882029621	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-412826	CLM	Thomas L Rsoe	1951-06-06	UHC-81794-28	9352359096	—	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
CLM-413671	CLM	Jean L Lucas	1978-04-09	—	5835111157	9228 Central Ave, Jacksonville, FL, 32284	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-412849	CLM	Kathleen Butler	1997-07-03	UHC-38547-86	5743413084	7271 Jefferson Ave, Jacksonville, FL, 32263	0.80	Phone reformatted Street suffix standardised Address re-cased Plan code upper-cased
CLM-401761	CLM	Bradley Gilbet	2001-03-25	UHC-44925-24	3855037959	5498 Church St, Jacksonville, FL, 32209	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-426725	CLM	Janice Duncan	2003-08-22	UHC-43398-21	2125714493	1469 Central Ave, Los Angeles, CA, 90099	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-418707	CLM	Michelle J Carpenter	2004-12-26	UHC-19794-40	4466247822	—	0.80	Name split from “Last, First”Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-427049	CLM	Beverly T Andrews	1967-12-18	UHC-52608-79	5166347246	2649 Canyon Rd, Nashville, TN, 37299	0.80	Phone reformatted State name converted to code Whitespace trimmed Placeholder values cleared
CLM-420823	CLM	Lugan I Ruiz	2006-12-13	—	4733805948	7672 Main St, Eden Prairie, MN, 55339	0.80	Date of birth reformatted Phone reformatted State name converted to code Placeholder values cleared
CLM-413938	CLM	Albert Marshall	1991-07-04	UHC-01330-32	2196705939	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-405451	CLM	Jacob U McDonald	1938-03-26	—	7167501791	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-420747	CLM	Susan Q Vazquez	2005-09-06	UHC-65517-83	7918100949	4082 Camelback Rd, Minneapolis, MN	0.80	Name re-cased Phone reformatted City re-cased ZIP missing
CLM-426326	CLM	Albert Wells	1985-11-02	—	3327159827	1734 Park Pl, Miami, FL, 33116	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-410944	CLM	Betsy Nguyen	1979-04-26	UHC-21227-68	4916010235	—	0.80	Phone reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
CLM-422734	CLM	Heather Hart	1960-06-27	UHC-02743-92	6385063717	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-419052	CLM	Brandon V Kennedy	—	—	5704183417	—	0.80	Date of birth unreadable Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-425201	CLM	Jean Gonzales	1941-09-26	—	3584757496	6416 Canyon Rd Apt 9, San Antonio, TX, 78277	0.80	Name re-cased Phone reformatted Unit split from street Placeholder values cleared
CLM-431031	CLM	Judith Estrada	1980-12-19	UHC-72475-82	9362264112	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-404090	CLM	Russell F Holmes	1943-10-14	UHC-47288-77	6575017298	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-404864	CLM	Mary Flores	1956-07-28	UHC-18073-20	5874512424	3083 Indian School Rd, Las Vegas, NV, 89140	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-415701	CLM	Austin Kennedy	1996-05-24	—	6596026380	919 Ocean Ave, Seattle, WA, 98175	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
CLM-421855	CLM	Richard Medina	2007-01-02	UHC-44455-93	3185851385	7077 Indian School Rd, San Diego, CA, 92102	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-407015	CLM	Jesse R Hudson	1973-08-21	UHC-83954-38	8006928238	—	0.80	Name re-cased Phone reformatted Gender normalised Whitespace trimmed
CLM-411169	CLM	Russell Andrews	1989-04-11	—	8896133226	2725 Pine Dr, Chandler, AZ, 85227	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-408444	CLM	Stephanie Sims	1996-06-24	—	7154270757	7563 Mountain View Dr, Tampa, FL, 33605	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
CLM-402047	CLM	Sean Henderson	1951-12-08	UHC-51649-70	3124933338	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-431240	CLM	Mariana Cook	1996-12-14	—	7259450677	7666 Sunset Blvd, Atlanta, GA, 30339	0.80	Name split from “Last, First”Phone reformatted State code upper-cased Whitespace trimmed
CLM-429493	CLM	Janet Crawford	1995-06-21	—	6722223274	4430 Mountain View Dr, Dallas, TX, 75242	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
CLM-430885	CLM	Priya Dunn	1959-05-05	—	7439582379	7821 Oak St, Las Vegas, NV, 89148	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-427498	CLM	Yuki Burton	2001-06-17	—	2465627101	—	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
CLM-404710	CLM	Charles F Rice	1968-08-21	—	8182184863	7601 Spring St, Tampa, FL, 33662	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-420645	CLM	Adam Campbell	1941-09-13	—	5944268146	9218 Sunset Blvd, Atlanta, GA, 30341	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-408375	CLM	Ashley J Garcia	1986-01-15	UHC-64842-69	5635859856	—	0.80	Middle initial moved out of first name Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-430963	CLM	Luis Butelr	1948-01-28	—	4235671000	7981 Harbor Blvd, Minneapolis, MN, 55440	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-429017	CLM	Brenda Green	1966-08-06	UHC-46437-60	2464619923	4014 Canyon Rd, Eden Prairie, MN, 55348	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
CLM-424703	CLM	Diane Morales	1958-05-02	UHC-58169-52	3276320176	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-426610	CLM	Barb Johnston	1973-12-10	UHC-24731-68	8266139748	7133 Apache Blvd, Tampa, FL, 33651	0.80	Two-digit birth year Phone reformatted Member ID reformatted Whitespace trimmed
CLM-429796	CLM	Sandra Hart	1957-12-16	—	9508397903	9810 Jefferson Ave, San Diego, CA, 92119	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-412870	CLM	Nancy L Tran	1967-05-04	—	9308262631	3686 Union St, Phoenix, AZ, 85010	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-427701	CLM	Katherine West	2001-01-25	—	6707918648	798 Central Ave, Dallas, TX, 75213	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-430606	CLM	John Maldonado	1943-04-02	UHC-04570-68	5012699231	3335 Park Pl, Austin, TX, 78770	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-427015	CLM	Andrew L Payne	1988-01-01	UHC-05998-67	5042290835	7750 Central Ave, Las Vegas, NV, 89194	0.80	Phone reformatted State name converted to code Whitespace trimmed Placeholder values cleared
CLM-405028	CLM	George Jensen	1941-11-06	UHC-11856-62	5812019278	5394 Forest Ave Apt 11, Plano, TX, 75074	0.80	Date of birth reformatted Phone reformatted Unit split from street Placeholder values cleared
CLM-407975	CLM	Alexander Welch	1966-08-18	UHC-73387-38	2236262604	5665 Lake View Rd, Fresno, CA, 93759	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
CLM-407220	CLM	Frank Carter	1990-09-19	—	6873963969	8971 Market St, Tempe, AZ	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
CLM-428064	CLM	Teresa L Snyder	1995-03-08	UHC-84031-93	3416900947	7579 Indian School Rd, Houston, TX, 77042	0.80	Name re-cased Phone reformatted State name converted to code Placeholder values cleared
CLM-424001	CLM	Amanda Y Hansen	1965-07-06	UHC-59930-97	4828507912	1518 Canyon Rd, Minneapolis, MN, 55415	0.80	Middle initial moved out of first name Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-422293	CLM	Jennifer George	1975-11-24	UHC-65417-44	3094392630	8643 Elm St, Denver, CO, 80234	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared

11,960 rows, page 161 of 240Previous Next