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-402566	CLM	Janice Rose	1987-12-14	—	—	6492 Palm Dr, Denver, CO, 80290	0.80	Name split from “Last, First”City re-cased Whitespace trimmed Placeholder values cleared
CLM-432763	CLM	Brenda G Elliott	1954-10-24	UHC-48551-68	—	4133 Apache Blvd, Miami, FL, 33129	0.80	Name re-cased Two-digit birth year City re-cased Placeholder values cleared
CLM-418526	CLM	Hiroshi Powell	1951-07-05	UHC-87923-96	—	7769 Camelback Rd, Tucson, AZ, 85759	0.80	Name re-cased Two-digit birth year City re-cased Placeholder values cleared
CLM-405704	CLM	Abigail Little	1976-10-18	—	—	7922 Apache Blvd, Fresno, CA, 93788	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-405703	CLM	Abigail Little	1976-10-18	—	—	7922 Apache Blvd, Fresno, CA, 93788	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-405522	CLM	Cheryl Munoz	1946-05-05	UHC-39247-46	8498714888	9140 Lake View Rd, Tempe, AZ, 85297	0.80	Date of birth reformatted Phone reformatted City re-cased State name converted to code
CLM-417730	CLM	Joyce M Webb	1940-07-21	UHC-86059-45	4087064188	4877 Grand Ave, Seattle, WA, 98187	0.80	Date of birth reformatted City re-cased State name converted to code Placeholder values cleared
CLM-429336	CLM	Laura O Berry	1961-02-18	—	—	5033 Main St, Miami, FL, 33184	0.80	City re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-403463	CLM	Anna Arnold	1993-05-22	UHC-72656-83	—	9675 Maple Ave, Tucson, AZ, 85730	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-428803	CLM	Billy Beiley	1981-04-17	UHC-36394-37	—	7337 Camelback Rd, Orlando, FL, 32834	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-403162	CLM	Marcus Fields	1996-03-30	UHC-58975-56	6133079537	8621 Oak St, Nashville, TN, 37241	0.80	Phone reformatted City re-cased Gender normalised Placeholder values cleared
CLM-431752	CLM	Denise Robertson	1947-09-05	UHC-42523-92	8068744904	6834 Market St, Tucson, AZ, 85763	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-413951	CLM	Abigail Romero	1978-01-03	—	—	4879 Desert Sky Blvd, San Antonio, TX	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
CLM-428791	CLM	Christina Gonzalez	1968-01-23	UHC-26758-34	—	87 Sage Ct, Jacksonville, FL, 32218	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-412962	CLM	Bryan Alvarez	1955-06-09	UHC-34162-31	9589694496	5263 Canyon Rd, Eden Prairie, MN	0.80	Name re-cased City re-cased ZIP missing Placeholder values cleared
CLM-412654	CLM	Dorothy Lawson	1969-03-21	—	—	9381 Harbor Blvd, Scottsdale, AZ, 85215	0.80	City re-cased Gender normalised Whitespace trimmed Placeholder values cleared
CLM-421758	CLM	Shirley Lee	2007-05-12	UHC-25265-26	—	9437 Camelback Rd, Columbus, OH, 43205	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-400397	CLM	Douglas Reyes	1968-09-09	—	—	7814 Central Ave, Scottsdale, AZ, 85284	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-431079	CLM	Mei Vega	2008-01-22	UHC-96916-94	—	641 Highland Ave, Gilbert, AZ, 85208	0.80	City re-cased State name converted to code Whitespace trimmed Placeholder values cleared
CLM-408756	CLM	Timothy Long	1946-08-28	UHC-23521-87	—	518 Pine Dr # 585, Minneapolis, MN, 55474	0.80	Name re-cased Unit split from street City re-cased Placeholder values cleared
CLM-402640	CLM	Anthony Hoffman	1977-01-02	—	—	5486 Highland Ave, Atlanta, GA, 30394	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-406340	CLM	Frank Guzman	2006-10-09	UHC-66444-28	4383180685	1500 Spring St, Fresno, CA, 93723	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
CLM-401855	CLM	Edward Dnun	1967-07-08	—	—	442 Broadway, Scottsdale, AZ, 85299	0.80	Address re-cased City re-cased Gender normalised Placeholder values cleared
CLM-401854	CLM	Edward Dnun	1967-07-08	—	—	442 Broadway, Scottsdale, AZ, 85299	0.80	Address re-cased City re-cased Gender normalised Placeholder values cleared
CLM-404449	CLM	Justin Crawford	1982-10-08	—	—	3216 Park Pl, Houston, TX, 77003	0.80	Two-digit birth year City re-cased Whitespace trimmed Placeholder values cleared
CLM-429117	CLM	Brian Dixon	1985-07-13	—	—	8209 Maple Ave, Gilbert, AZ, 85204	0.80	City re-cased State code upper-cased ZIP+4 trimmed Placeholder values cleared
CLM-408366	CLM	Sean V Owens	1984-01-05	UHC-64788-47	—	5632 Baseline Rd, San Diego, CA, 92137	0.80	Two-digit birth year City re-cased Whitespace trimmed Placeholder values cleared
CLM-408021	CLM	Carlos Stone	1982-01-01	—	—	3927 Lincoln Way, Atlanta, GA	0.80	Name re-cased City re-cased ZIP missing Placeholder values cleared
CLM-417724	CLM	Sophia Kelley	1951-11-13	—	3668810763	6604 Park Pl, Charlotte, NC, 28280	0.80	Name split from “Last, First”City re-cased Whitespace trimmed Placeholder values cleared
CLM-430871	CLM	Cheryl G Chavez	1952-01-05	—	—	988 Camelback Rd, Sacramento, CA, 95889	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-412140	CLM	Ronnald Alexander	1990-01-09	—	5356360269	4525 Union St # 360, Jacksonville, FL, 32229	0.80	Date of birth reformatted Unit split from street City re-cased Whitespace trimmed
CLM-423040	CLM	Randy Reid	1997-10-25	UHC-02401-36	—	6483 Highland Ave, Austin, TX, 78720	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-418333	CLM	Tyler Hoffamn	1948-08-22	UHC-34418-94	—	1994 Bayshore Dr, Charlotte, NC, 28206	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-408188	CLM	Heather R Freeman	2004-06-07	UHC-21700-64	—	9524 Baseline Rd, Sacramento, CA, 95881	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-408303	CLM	Kayla G Webb	1975-12-06	—	—	8894 Broadway, Gilbert, AZ, 85280	0.80	Name split from “Last, First”Address re-cased City re-cased Placeholder values cleared
CLM-420920	CLM	Elijah Phillips	1995-11-21	—	—	2832 Baseline Rd, Sacramento, CA, 95820	0.80	City re-cased Gender normalised Whitespace trimmed Placeholder values cleared
CLM-410228	CLM	Russell Hicks	1974-03-05	UHC-25635-11	3292866762	294 Central Ave, Charlotte, NC, 28284	0.80	Phone reformatted City re-cased Gender normalised Placeholder values cleared
CLM-413716	CLM	Denise Hayes	2007-04-27	UHC-92115-37	—	4768 Mountain View Dr, San Antonio, TX, 78254	0.80	Name re-cased Two-digit birth year City re-cased Whitespace trimmed
CLM-405269	CLM	Russell F Gibson	1954-06-21	—	—	8245 Ocean Ave, San Antonio, TX, 78208	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-426576	CLM	Patrick Lopez	1976-03-28	UHC-03037-49	8934592087	1400 Palm Dr, Columbus, OH, 43297	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
CLM-411038	CLM	Heather Lynch	1996-05-02	UHC-37423-63	—	695 Highland Ave, Plano, TX, 75038	0.80	Two-digit birth year City re-cased Whitespace trimmed Placeholder values cleared
CLM-401970	CLM	David Davis	1939-12-06	UHC-96149-83	3983167721	9365 Elm St, Denver, CO, 80273	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-417550	CLM	Janice Johnson	1997-04-24	—	—	7828 Highland Ave, Eden Prairie, MN, 55363	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-420561	CLM	Dot Fowler	1990-02-06	UHC-10722-65	—	2653 Lincoln Way, Phoenix, AZ, 85079	0.80	Date of birth reformatted City re-cased State name converted to code Whitespace trimmed
CLM-429300	CLM	Ronald Jimenez	1942-10-25	UHC-03548-71	6127797056	3830 Mountain View Dr, Atlanta, GA, 30359	0.80	Name re-cased City re-cased State name converted to code Placeholder values cleared
CLM-419327	CLM	Ann Hduson	1947-09-06	—	—	2748 Palm Dr, Eden Prairie, MN	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
CLM-416832	CLM	Priya Reynolds	1995-05-20	UHC-03653-51	3755415656	3380 Camelback Rd, Tucson, AZ, 85754	0.80	Two-digit birth year Phone reformatted City re-cased Whitespace trimmed
CLM-426972	CLM	Timothy Floores	—	—	5864231632	9101 Baseline Rd, San Antonio, TX, 78260	0.80	Date of birth missing Phone reformatted City re-cased Placeholder values cleared
CLM-412034	CLM	Yuuki Hunter	1998-10-08	—	—	730 Forest Ave, Fresno, CA, 93780	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-432275	CLM	Alexander W Adams	1944-06-04	UHC-12301-91	3475076915	3714 Church St, Tempe, AZ, 85295	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared

5,235 rows, page 82 of 105Previous Next