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-419709	CLM	Marilyn James	1969-10-05	UHC-34608-53	—	4451 Forest Ave, Scottsdale, AZ, 85265	0.78	Street suffix standardised Address re-cased City re-cased Email lower-cased+1 more
CLM-422434	CLM	Frank Fernandez	1960-04-04	UHC-46561-13	8743006582	6763 Mesa Dr, Glendale, AZ, 85323	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-424630	CLM	Cynthia Ortiz	1955-08-07	UHC-34269-99	—	572 Church St, Austin, TX, 78767	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-421546	CLM	Nathan M Martinez	1944-04-01	UHC-89061-19	—	2561 Bayshore Dr, Nashville, TN, 37207	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-405572	CLM	Lawrence Sullivan	2001-12-01	UHC-85120-50	—	4478 Canyon Rd, Eden Prairie, MN, 55351	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-408059	CLM	Gabriel Burns	1949-04-05	UHC-23008-39	—	5336 Apache Blvd, Jacksonville, FL, 32297	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
CLM-416916	CLM	Emma Tucker	1964-05-09	UHC-70803-55	8126770647	8985 Hillcrest Rd, Fresno, CA, 93774	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-405605	CLM	Adam Vasquez	1978-12-15	UHC-91157-09	3974287745	9625 Hillcrest Rd, Charlotte, NC, 28263	0.78	Name re-cased Phone reformatted City re-cased Gender normalised+1 more
CLM-431875	CLM	Patricia Rice	1951-11-26	—	9116215964	8745 Mesa Dr, Los Angeles, CA, 90086	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-413168	CLM	Bryan Silva	1955-11-05	UHC-56626-27	3916061515	7703 Central Ave, Seattle, WA, 98112	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-430493	CLM	Jordan Kelley	1953-06-05	—	5794220608	4822 Pine Dr, Eden Prairie, MN, 55352	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-423196	CLM	Christine Cunningham	1980-12-13	—	3464128711	9251 Ridge Rd, Dallas, TX, 75296	0.78	Name split from “Last, First”Date of birth reformatted Phone reformatted City re-cased+1 more
CLM-423572	CLM	Megan Larson	1966-04-12	—	—	6605 Park Pl, Minneapolis, MN, 55481	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-427391	CLM	Donna Renolds	1941-10-22	UHC-84859-74	9634313099	6169 Elm St, Chandler, AZ, 85251	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-430545	CLM	Jim W Rodriguez	1966-11-02	UHC-72572-86	—	7312 Harbor Blvd, Tucson, AZ, 85739	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-409117	CLM	Mary Lee	1950-04-12	—	—	9630 Elm St, Glendale, AZ, 85390	0.78	Name re-cased City re-cased Gender normalised Whitespace trimmed+1 more
CLM-409400	CLM	Arjun R Sullivan	1967-11-02	—	7098308941	5726 Broadway, Jacksonville, FL, 32202	0.78	Two-digit birth year Phone reformatted City re-cased Whitespace trimmed+1 more
CLM-409377	CLM	Lori Graham	1968-06-02	UHC-89319-70	8098483852	4806 Palm Dr, Jacksonville, FL, 32211	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-422263	CLM	Paul D Freeman	1979-12-01	UHC-28021-38	—	2670 Sage Ct, Charlotte, NC, 28238	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-414714	CLM	Jack Schmidt	1991-03-04	—	6667473273	9893 Lincoln Way, Los Angeles, CA, 90017	0.78	Two-digit birth year Phone reformatted City re-cased Whitespace trimmed+1 more
CLM-421590	CLM	Bradley Rogers	1987-12-20	UHC-01551-77	—	8042 Pine Dr, Seattle, WA, 98169	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-428237	CLM	Bruce G Evans	1965-11-07	—	4592710513	6479 River Rd, Denver, CO, 80250	0.78	Phone reformatted SSN last four extracted City re-cased Whitespace trimmed+1 more
CLM-406076	CLM	Lisa Foter	1995-08-24	UHC-72634-68	—	1012 Broadway, Houston, TX, 77058	0.78	Name re-cased City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-427861	CLM	Mariana Perez	1994-09-22	—	6747055863	4020 Meadow Ln, San Diego, CA	0.78	Name re-cased Phone reformatted City re-cased ZIP missing+1 more
CLM-424360	CLM	Pamela Haayes	1967-07-20	UHC-15386-32	—	3336 Valley View Dr, Atlanta, GA, 30325	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
CLM-412226	CLM	Megan Rios	2008-01-21	—	—	9253 Hillcrest Rd, Charlotte, NC, 28237	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-422134	CLM	Samuel Mendoza	1979-01-02	UHC-48138-76	—	808 Park Pl, San Diego, CA, 92164	0.78	Name re-cased Two-digit birth year City re-cased Whitespace trimmed+1 more
CLM-427856	CLM	Kyle Cunningham	1988-01-05	UHC-72150-81	—	1580 Highland Ave, Nashville, TN, 37245	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-412801	CLM	Anna Wells	1951-09-16	UHC-60237-17	—	1368 Indian School Rd, San Antonio, TX, 78204	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
CLM-405069	CLM	Alan Aguilar	1941-11-05	—	5943606724	7777 Hillcrest Rd, Miami, FL, 33170	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-421407	CLM	Aisha Hughes	2000-08-26	UHC-26837-69	—	5338 Cedar Ln, Denver, CO, 80284	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
CLM-411590	CLM	Teresa Nguyen	1975-04-20	UHC-74299-44	8392549670	5453 Lincoln Way, Houston, TX, 77059	0.78	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-421553	CLM	Kevin King	1980-12-17	UHC-00010-37	3157976272	7344 Indian School Rd, Sacramento, CA, 95823	0.78	Phone reformatted City re-cased Gender normalised Whitespace trimmed+1 more
CLM-421788	CLM	James Rice	1971-06-19	—	—	4780 Mountain View Dr, Charlotte, NC, 28209	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-402758	CLM	James Ortiz	1965-01-02	—	—	78 Willow Ct, Houston, TX, 77043	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-419929	CLM	Valentina Matthews	1997-01-27	UHC-48680-26	—	7998 Camelback Rd, Denver, CO, 80255	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-428316	CLM	Bryan Wheeler	1958-07-14	UHC-77912-63	—	6051 Broadway, Atlanta, GA, 30338	0.78	Name re-cased Date of birth reformatted City re-cased Gender normalised+1 more
CLM-428716	CLM	Jonathan Harrison	1979-05-07	UHC-92177-58	8552796314	4160 Sage Ct, Atlanta, GA, 30320	0.78	Name re-cased Phone reformatted City re-cased State name converted to code+1 more
CLM-420894	CLM	Benjamin Collins	2004-03-16	UHC-34115-12	7277170303	1636 Apache Blvd, Tucson, AZ, 85757	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
CLM-428423	CLM	Martha Estrada	1990-04-12	—	5293748078	4612 Park Pl, Miami, FL, 33164	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-413150	CLM	Austin Morgan	1982-12-01	UHC-70663-96	—	6776 Sunset Blvd, Chandler, AZ, 85258	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
CLM-414809	CLM	John Henry	1944-01-19	UHC-67530-07	8532614998	9524 Desert Sky Blvd, Atlanta, GA, 30391	0.78	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed+1 more
CLM-405880	CLM	Camila Perkins	1961-05-20	UHC-07700-45	—	6104 Spring St, Scottsdale, AZ, 85222	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-407360	CLM	Robert Patel	—	—	—	7450 Lake View Rd, Seattle, WA, 98146	0.78	Date of birth unreadable City re-cased State code upper-cased Whitespace trimmed+1 more
CLM-424009	CLM	Steven Carter	1995-08-08	UHC-39264-85	—	3793 Bayshore Dr, San Antonio, TX, 78250	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
CLM-409090	CLM	Jose Espinoza	1997-08-14	—	—	8225 Market St, Seattle, WA, 98129	0.78	Date of birth reformatted City re-cased State name converted to code Whitespace trimmed+1 more
CLM-412116	CLM	Willie E Gutierrez	1947-12-01	UHC-12049-96	—	2585 Union St, Orlando, FL, 32827	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
CLM-414995	CLM	Cheryl Castro	1950-02-04	UHC-39022-48	—	570 Broadway, Phoenix, AZ, 85002	0.78	Address re-cased City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
CLM-402464	CLM	Pamela I Yang	1973-10-23	UHC-97495-29	3757099923	6217 Baseline Rd, Scottsdale, AZ, 85232	0.78	Name re-cased Date of birth reformatted City re-cased Gender normalised+1 more
CLM-427534	CLM	Christian Meyer	2007-04-25	—	—	2940 Indian School Rd, Dallas, TX, 75216	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more

5,235 rows, page 72 of 105Previous Next