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-426193	CLM	Steve Meyar	1960-04-21	—	5296226259	9395 Sage Ct, Jacksonville, FL, 32285	0.80	Name re-cased Phone reformatted Street suffix standardised Address re-cased
CLM-407828	CLM	Abigail Mruphy	1975-04-26	UHC-18664-98	6034992873	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-410742	CLM	Gregory Q Hudson	1954-02-04	UHC-41204-86	5356368820	8058 Main St, Nashville, TN, 37262	0.80	Name split from “Last, First”Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-407752	CLM	Kayla N Wheeler	1938-11-09	UHC-62250-44	5673888538	5670 Valley View Dr, Las Vegas, NV, 89169	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-415869	CLM	Noah N Burton	1959-02-27	UHC-03787-87	3653046837	6852 Meadow Ln, Jacksonville, FL, 32259	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-410706	CLM	Jacob Johnston	1989-01-28	UHC-58876-62	6762152256	8303 Park Pl, Plano, TX, 75027	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-416666	CLM	Andrea Lawson	1979-08-19	—	6527227444	9607 Central Ave, Tempe, AZ, 85220	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Placeholder values cleared
CLM-422553	CLM	Frances Long	1959-08-23	—	5167277627	3267 Park Pl, Tucson, AZ, 85763	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-400502	CLM	Nathan A Murray	1983-07-25	UHC-21682-35	8185634976	5771 Church St, San Antonio, TX, 78224	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-409860	CLM	Christian Lynch	1948-12-03	UHC-37248-01	2349623799	—	0.80	Name split from “Last, First”Phone reformatted Plan code upper-cased Placeholder values cleared
CLM-420560	CLM	Doruthy Fowler	1990-02-06	UHC-10722-65	5363592077	2653 Lincoln Way, Phoenix, AZ, 85079	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-400714	CLM	Matt Hayyes	1993-02-07	—	4649219132	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-411591	CLM	Lawrence Mejia	1964-12-23	—	9603319548	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-415726	CLM	Ronald Herrera	1980-09-14	UHC-53971-30	6398054413	2219 Canyon Rd, Orlando, FL, 32868	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
CLM-415248	CLM	Abigail Q Reed	1986-07-19	UHC-99894-11	5374192280	8479 Spring St Apt 11, Tampa, FL, 33650	0.80	Phone reformatted Unit split from street Whitespace trimmed Placeholder values cleared
CLM-400782	CLM	Fatima Cook	1975-03-18	—	7284883863	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-423450	CLM	Lauren Sandoval	1955-08-17	UHC-88391-59	3288316191	3650 Willow Ct, Tucson, AZ, 85701	0.80	Phone reformatted State name converted to code Whitespace trimmed Placeholder values cleared
CLM-428481	CLM	Keith Graham	1954-04-20	—	6292899879	5193 Lincoln Way, Los Angeles, CA, 90080	0.80	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased
CLM-404214	CLM	Janice Clark	1988-06-25	—	5189904977	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-408350	CLM	Mariana Fields	1960-11-22	UHC-96749-28	6022285654	3511 Main St, Phoenix, AZ, 85023	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-425706	CLM	Ahmed Watkins	1943-02-12	—	8264652384	439 Apache Blvd, San Antonio, TX, 78285	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-402294	CLM	Julie Fernandez	1978-03-03	—	8627861161	1216 Desert Sky Blvd, Atlanta, GA, 30382	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
CLM-423636	CLM	Olivia Wang	1970-01-19	—	5708720991	5888 Lincoln Way # 449, Gilbert, AZ, 85259	0.80	Date of birth reformatted Phone reformatted Unit split from street Placeholder values cleared
CLM-421721	CLM	Brittany Ross	1983-07-11	UHC-32393-65	5598020393	458 River Rd, Dallas, TX, 75255	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-404740	CLM	Amanda P Ward	1970-02-23	UHC-44504-28	3816714921	177 Park Pl Apt 30, Columbus, OH, 43278	0.80	Phone reformatted Unit split from street Whitespace trimmed Placeholder values cleared
CLM-403723	CLM	Julie Simmons	1977-12-28	UHC-60087-69	8134699316	3742 Forest Ave, Tucson, AZ, 85783	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-402187	CLM	Theresa West	—	UHC-07177-15	4497337976	—	0.80	Date of birth unreadable Phone reformatted Member ID reformatted Placeholder values cleared
CLM-427195	CLM	William Rose	1964-03-08	—	8553123142	5030 Cedar Ln, Phoenix, AZ, 85035	0.80	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed
CLM-410339	CLM	Rebecca Harris	—	—	4057122716	7103 Market St, Atlanta, GA, 30388	0.80	Date of birth unreadable Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-410137	CLM	Roger Ray	1977-08-03	UHC-43599-50	7875008643	4127 Apache Blvd, Mesa, AZ, 85214	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-403379	CLM	Deburah Fox	1950-06-06	—	8696516692	1515 Hillcrest Rd, Orlando, FL, 32891	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-400037	CLM	Donna Hunter	1992-05-20	UHC-21504-45	9174840488	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-429794	CLM	Walter Carlon	1963-02-09	—	3907059886	8108 Ridge Rd, Los Angeles, CA	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
CLM-423762	CLM	Andrea White	1951-07-05	UHC-79988-26	5844274855	789 Canyon Rd, Orlando, FL, 32871	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-425946	CLM	Justin Bennett	1996-11-06	UHC-31433-79	5368336101	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-425538	CLM	Beverly Cunningham	1961-03-23	UHC-32494-13	4317146211	—	0.80	Phone reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
CLM-417891	CLM	Charles Mithcell	2008-12-26	UHC-47452-54	8942419102	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-414357	CLM	Terry Dominguez	1950-07-25	UHC-49400-42	8699841968	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-401458	CLM	Albert Castro	1982-05-10	—	3903443809	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-407190	CLM	Kimberly Robinson	—	—	7686883529	—	0.80	Date of birth missing Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-400282	CLM	Madison Harris	1945-01-13	UHC-00473-04	7516568559	1520 Ocean Ave, Austin, TX, 78754	0.80	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed
CLM-419450	CLM	Willie Garcia	1939-05-09	—	5952969080	2073 Church St, Sacramento, CA, 95855	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
CLM-429703	CLM	Joshua Park	1943-06-03	—	8369592846	5944 Church St, Austin, TX, 78727	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-419067	CLM	Emma Ortiz	1971-11-06	UHC-32667-67	5709607041	3185 Park Pl, Houston, TX, 77054	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
CLM-419066	CLM	Emma Ortiz	1971-11-06	UHC-32667-67	5709607041	3185 Park Pl, Houston, TX, 77054	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
CLM-422836	CLM	Jacqueline Willis	1998-05-09	UHC-10956-01	6387119546	1671 Market St, Denver, CO, 80290	0.80	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed
CLM-411903	CLM	Elizabeth Dominguez	1974-03-10	UHC-35965-93	6766274170	4119 Church St, Charlotte, NC, 28251	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-407257	CLM	Susan C Estrada	1958-05-10	UHC-65247-52	8356094075	1971 Highland Ave, Seattle, WA, 98119	0.80	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed
CLM-406635	CLM	Jeffrey Johnston	1959-01-26	UHC-07848-72	4646242219	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-425789	CLM	Amy Ruiz	2005-04-11	UHC-48579-10	2073820208	347 Indian School Rd, Gilbert, AZ, 85269	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared

11,960 rows, page 158 of 240Previous Next