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-431919	CLM	Ann Perez	1993-08-11	UHC-58834-40	—	2559 Baseline Rd # 496, Phoenix, AZ, 85046	0.80	Date of birth reformatted Unit split from street City re-cased Placeholder values cleared
CLM-413543	CLM	Jaanet Valdez	1943-04-01	UHC-35323-58	—	7016 Ridge Rd, Chandler, AZ, 85226	0.80	Phone missing area code City re-cased Whitespace trimmed Placeholder values cleared
CLM-400407	CLM	Aaron Harper	2008-11-02	UHC-06862-81	—	3658 Market St, Scottsdale, AZ, 85237	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-404329	CLM	Ana R Banks	1968-01-12	UHC-34703-52	5547536159	5264 Elm St, Minneapolis, MN, 55474	0.80	Member ID reformatted Street suffix standardised Address re-cased City re-cased
CLM-412423	CLM	Kenneth George	1945-10-13	UHC-44938-15	—	8887 Pine Dr, Tucson, AZ, 85749	0.80	City re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-401250	CLM	Thomas J Griffin	1986-12-03	UHC-79604-64	8249420572	3794 Mountain View Dr, Charlotte, NC, 28247	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
CLM-420159	CLM	Petr Morgan	1959-03-05	—	—	8901 Broadway, Jacksonville, FL, 32264	0.80	Name re-cased City re-cased State name converted to code Placeholder values cleared
CLM-401562	CLM	Omar Obrien	—	—	—	9372 Mountain View Dr, Tampa, FL, 33613	0.80	Name re-cased Date of birth missing City re-cased Placeholder values cleared
CLM-409614	CLM	Mason Muore	1976-10-05	—	—	1307 Oak St, Dallas, TX, 75218	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-423723	CLM	Jacqueline Daniels	1999-10-28	UHC-36475-82	—	5622 Valley View Dr, Miami, FL, 33129	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-417842	CLM	Angela Wagner	1963-08-06	UHC-33234-79	—	7213 Highland Ave, Minneapolis, MN	0.80	Name re-cased City re-cased ZIP missing Placeholder values cleared
CLM-413009	CLM	Camila E Weaver	1976-10-02	UHC-76555-39	—	1120 Spring St, Tempe, AZ, 85298	0.80	Name re-cased City re-cased Gender normalised Placeholder values cleared
CLM-425579	CLM	Maria Stone	1995-09-12	UHC-60339-87	—	459 Main St, Phoenix, AZ, 85028	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-415988	CLM	Teresa Reyes	1999-06-10	—	—	1268 Hillcrest Rd, Las Vegas, NV, 89101	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-404613	CLM	Wei Y Schmidt	—	UHC-72575-73	3189483940	1246 Apache Blvd, Houston, TX, 77022	0.80	Date of birth missing City re-cased Whitespace trimmed Placeholder values cleared
CLM-429449	CLM	Christina Garcia	1969-02-11	—	—	9827 Canyon Rd, Fresno, CA, 93762	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-431569	CLM	Juna Obriien	2008-07-20	UHC-63527-62	—	1923 Elm St, Los Angeles, CA, 90045	0.80	Name split from “Last, First”Name re-cased City re-cased Placeholder values cleared
CLM-427489	CLM	Lauren E Howell	1955-11-11	UHC-02859-87	—	5487 Meadow Ln, Sacramento, CA, 95899	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-421111	CLM	Douglas U Warren	1944-09-25	UHC-53814-57	—	9292 Broadway, Orlando, FL, 32808	0.80	Name split from “Last, First”City re-cased Whitespace trimmed Placeholder values cleared
CLM-422041	CLM	Patrick Nichhols	1945-08-01	UHC-30949-43	—	6749 Hillcrest Rd, Sacramento, CA, 95837	0.80	Phone missing area code City re-cased Whitespace trimmed Placeholder values cleared
CLM-425099	CLM	Jacob Riley	1943-04-26	UHC-23169-11	—	1862 Hillcrest Rd, Seattle, WA, 98179	0.80	Two-digit birth year City re-cased Whitespace trimmed Placeholder values cleared
CLM-401681	CLM	Abigail Coleman	1951-01-12	—	—	6206 Ridge Rd, Denver, CO, 80291	0.80	Name re-cased Two-digit birth year City re-cased Placeholder values cleared
CLM-409322	CLM	Jason K Gordon	1952-06-05	UHC-52450-28	—	8596 Desert Sky Blvd, Plano, TX, 75052	0.80	City re-cased State name converted to code Whitespace trimmed Placeholder values cleared
CLM-425664	CLM	Jose Hamilton	1980-12-03	UHC-48681-98	—	77 Baseline Rd, Austin, TX, 78756	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-406263	CLM	Dylan P Reid	—	UHC-31001-11	—	6707 Meadow Ln, Atlanta, GA, 30345	0.80	Date of birth missing City re-cased Email lower-cased Placeholder values cleared
CLM-421062	CLM	Jordan Murphy	1986-12-16	UHC-04857-22	—	621 Indian School Rd Apt 22, Gilbert, AZ, 85230	0.80	Unit split from street City re-cased Whitespace trimmed Placeholder values cleared
CLM-426670	CLM	Ralph Jacubs	1999-04-07	UHC-82994-18	3398960338	1278 River Rd, Phoenix, AZ, 85090	0.80	City re-cased State name converted to code Whitespace trimmed Placeholder values cleared
CLM-403216	CLM	Priya V West	2006-07-03	UHC-15513-78	—	7070 Oak St, Charlotte, NC	0.80	City re-cased ZIP missing Plan code upper-cased Placeholder values cleared
CLM-430052	CLM	Julia Coleman	1958-12-01	—	—	5276 Meadow Ln, Austin, TX, 78780	0.80	Name re-cased City re-cased ZIP+4 trimmed Placeholder values cleared
CLM-428373	CLM	Ronald Cole	—	—	3823767927	1549 Union St, Miami, FL, 33108	0.80	Date of birth unreadable Phone reformatted City re-cased Placeholder values cleared
CLM-429810	CLM	Sofia G Wang	1966-06-02	UHC-63739-70	—	6898 Indian School Rd, Seattle, WA, 98188	0.80	Name re-cased City re-cased State name converted to code Placeholder values cleared
CLM-404980	CLM	Linda Sanchez	1970-03-22	UHC-89911-60	—	1796 Baseline Rd, Fresno, CA, 93732	0.80	Name re-cased City re-cased ZIP+4 trimmed Placeholder values cleared
CLM-432619	CLM	Carolyn Wright	1976-05-19	UHC-94808-34	8584728544	242 Park Pl # 972, Orlando, FL, 32850	0.80	Name re-cased Phone reformatted Unit split from street City re-cased
CLM-404569	CLM	Arthur Freeman	1957-12-26	—	—	4412 Forest Ave, Tucson, AZ, 85789	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-402803	CLM	Kimberly Rios	1997-05-23	—	—	5559 Harbor Blvd, Mesa, AZ	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
CLM-428865	CLM	Chrristopher Thomas	1967-09-07	—	7079332783	4173 Spring St, Tucson, AZ, 85772	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-408551	CLM	Mariana D Anderson	2000-10-14	—	—	340 Ocean Ave, Columbus, OH, 43274	0.80	Name split from “Last, First”Date of birth reformatted City re-cased Placeholder values cleared
CLM-421245	CLM	Gary Peters	1945-08-17	—	—	355 Mesa Dr, Plano, TX, 75001	0.80	SSN last four extracted City re-cased Email lower-cased Placeholder values cleared
CLM-406448	CLM	Heather O Estrada	1964-12-10	—	—	7177 River Rd, Tucson, AZ, 85755	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-425615	CLM	Andra McDonald	1964-07-03	UHC-21538-62	5134624801	323 Mountain View Dr # 112, Columbus, OH, 43281	0.80	Name re-cased Unit split from street City re-cased Placeholder values cleared
CLM-422601	CLM	Laura Morgan	1970-02-28	—	5042788356	6176 Pine Dr, Tampa, FL, 33650	0.80	Phone reformatted City re-cased State name converted to code Placeholder values cleared
CLM-404631	CLM	Victoria Howell	1975-03-19	—	—	6828 Spring St, Las Vegas, NV, 89112	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-419981	CLM	Joseph Carroll	1970-10-05	UHC-92686-44	—	319 Jefferson Ave, Fresno, CA, 93789	0.80	Member ID reformatted Street suffix standardised Address re-cased City re-cased
CLM-432794	CLM	Stephen Murray	1962-05-26	UHC-92761-01	—	4148 Main St, Seattle, WA	0.80	City re-cased ZIP missing Whitespace trimmed Placeholder values cleared
CLM-428558	CLM	Natalie Phillips	1986-10-11	—	—	1429 Cedar Ln, Gilbert, AZ	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
CLM-415789	CLM	Walter Davis	1950-11-05	—	8969590017	5197 Cedar Ln, Las Vegas, NV, 89109	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-423076	CLM	Roger Powell	1993-07-07	—	7747432929	7669 Lincoln Way, Eden Prairie, MN	0.80	Phone reformatted City re-cased ZIP missing Placeholder values cleared
CLM-409654	CLM	Ann Le	1945-12-25	UHC-83217-03	—	8145 Market St, Seattle, WA, 98147	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-431876	CLM	Patrick Padilla	1968-02-15	—	—	4783 Oak St, Mesa, AZ, 85264	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
CLM-409591	CLM	Olivia Thomas	1966-01-14	UHC-31622-35	—	9328 Sage Ct, Plano, TX, 75006	0.80	Name re-cased City re-cased ZIP+4 trimmed Placeholder values cleared

5,235 rows, page 85 of 105Previous Next