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 “Name re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagName re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-412926	CLM	Cooper Sharon	1985-01-14	—	8854771235	2375 Lincoln Way, Fresno, CA, 93771	0.80	Name re-cased State name converted to code Whitespace trimmed Placeholder values cleared
CLM-403248	CLM	Kenneth Martinez	1966-11-26	—	4136454750	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-407278	CLM	Kathryn Payne	2002-08-07	UHC-83541-95	—	156 Hillcrest Rd, Scottsdale, AZ, 85274	0.80	Name re-cased Street suffix standardised Address 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-427895	CLM	Aaron Knight	1983-07-13	UHC-95721-09	—	8293 Spring St, Nashville, TN, 37219	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-418307	CLM	Ethan Kennedy	1960-09-08	UHC-60111-50	6747520478	3654 Washington St, Tampa, FL, 33609	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-421123	CLM	Maria Tran	—	UHC-91217-99	7703936409	6940 Forest Ave, Sacramento, CA, 95826	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
CLM-429700	CLM	Douglas Banks	1982-01-06	UHC-51125-18	—	—	0.80	Name re-cased Gender normalised Whitespace trimmed 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-432321	CLM	Cheryl Orbien	1938-08-14	—	—	7836 Union St, Chandler, AZ, 85253	0.80	Name re-cased State name converted to code Whitespace trimmed Placeholder values cleared
CLM-407277	CLM	Heather Arnold	—	UHC-93459-97	5368191123	—	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
CLM-415290	CLM	Ryan White	1997-06-15	UHC-97161-39	—	1067 Oak St, Austin, TX	0.80	Name re-cased ZIP missing Whitespace 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-430301	CLM	Andrea Martinez	—	UHC-02997-04	—	—	0.80	Name re-cased Date of birth missing Whitespace trimmed Placeholder values cleared
CLM-413055	CLM	Virginia F Dominguez	1997-03-24	UHC-47834-81	—	9376 Elm St Apt 25, Orlando, FL, 32846	0.80	Name re-cased Unit split from street Whitespace trimmed Placeholder values cleared
CLM-424091	CLM	Katherine D Warren	1975-08-08	UHC-61644-88	—	8205 Willow Ct # 967, Mesa, AZ, 85201	0.80	Name re-cased Unit split from street Email lower-cased Placeholder values cleared
CLM-412320	CLM	Diana Porter	1960-02-01	—	—	—	0.80	Name re-cased Two-digit birth year Whitespace trimmed Placeholder values cleared
CLM-406160	CLM	Jennifer S Cook	1997-09-14	UHC-04591-39	—	4635 Camelback Rd Apt 39, Orlando, FL, 32860	0.80	Name re-cased Date of birth reformatted Unit split from street Placeholder values cleared
CLM-417981	CLM	Diego Gibson	1990-01-08	UHC-11359-80	—	8121 Valley View Dr, Mesa, AZ, 85233	0.80	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed
CLM-406289	CLM	Judy Alexander	1990-09-12	—	—	6007 Grand Ave, Dallas, TX, 75261	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-427018	CLM	Richard F James	1974-11-02	UHC-68219-53	6854676221	—	0.80	Middle initial moved out of first name Name re-cased Phone reformatted Placeholder values cleared
CLM-411563	CLM	Valentina Mejia	1985-06-21	UHC-96174-01	—	636 Highland Ave, Miami, FL, 33147	0.80	Name re-cased Two-digit birth year Whitespace trimmed Placeholder values cleared
CLM-424945	CLM	Kayla Simmons	2003-07-15	UHC-11502-95	—	6651 Jefferson Ave, Tampa, FL, 33686	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-427325	CLM	Lisa D Obrien	2004-10-24	UHC-77989-41	—	3140 Lake View Rd, Tucson, AZ, 85730	0.80	Name split from “Last, First”Name re-cased State code upper-cased Placeholder values cleared
CLM-403445	CLM	Kathleen Baker	1943-04-12	UHC-40436-49	7135346339	6532 Lincoln Way, Mesa, AZ, 85264	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
CLM-414118	CLM	Dennis Spencer	1979-01-01	—	8949703973	4568 Church St, Minneapolis, MN	0.80	Name re-cased Date of birth reformatted Phone reformatted ZIP missing
CLM-413474	CLM	Christopher Perry	1989-12-01	UHC-52638-72	6872967185	—	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
CLM-406898	CLM	Barbara Hanson	1953-04-02	UHC-41769-76	3685367118	4855 Willow Ct, Austin, TX	0.80	Name re-cased Phone reformatted ZIP missing Whitespace trimmed
CLM-407181	CLM	Diane Alvarez	1998-06-11	—	—	7578 Central Ave, Plano, TX, 75055	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-417955	CLM	Roegr F Arnold	2005-06-25	—	—	2065 Lake View Rd, Denver, CO, 80213	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-429802	CLM	Paul C Williams	1960-07-19	UHC-92291-18	8958002300	5880 Forest Ave, Fresno, CA, 93773	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-426445	CLM	Scott Garcia	1937-10-27	—	—	5651 Market St, Mesa, AZ, 85228	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-413074	CLM	Theresa Parkr	1990-10-11	—	—	7110 Maple Ave, Miami, FL, 33112	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-414970	CLM	Barbara Palmer	1974-10-15	—	3049451940	—	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
CLM-400015	CLM	Bell K Margaret	2007-07-25	UHC-39574-66	9864893045	4859 Elm St, Tampa, FL, 33618	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-423579	CLM	Paul Lawson	—	UHC-77158-43	8338077978	3409 Elm St, Tempe, AZ, 85233	0.80	Name re-cased Date of birth unreadable Phone reformatted Placeholder values cleared
CLM-431739	CLM	Arthur Valdez	—	—	4296674000	8255 Ocean Ave, Columbus, OH, 43201	0.80	Name re-cased Date of birth unreadable Phone reformatted Placeholder values cleared
CLM-417130	CLM	Diego Wood	1998-05-03	UHC-94499-61	—	7733 Mountain View Dr, Minneapolis, MN, 55444	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-415214	CLM	Douglas Hunt	1965-02-04	UHC-18462-40	6002316071	—	0.80	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted
CLM-411984	CLM	Emily V Tucker	1962-09-12	UHC-49253-29	—	—	0.80	Middle initial moved out of first name Name re-cased Whitespace trimmed Placeholder values cleared
CLM-426750	CLM	Bradley A Bishop	2001-09-22	—	3503625688	3761 Oak St, Chandler, AZ, 85221	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
CLM-414599	CLM	Luis Jenkins	1958-10-19	UHC-57726-75	—	7476 Ridge Rd, Phoenix, AZ, 85092	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-428706	CLM	Angela Chapman	2005-12-21	UHC-61148-24	—	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
CLM-428649	CLM	Maon Arnold	1955-06-19	—	—	5848 Sage Ct, Fresno, CA, 93716	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-401221	CLM	Brittany K Hawkins	1993-08-16	UHC-72035-60	—	4053 Pine Dr, Charlotte, NC	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
CLM-405751	CLM	Keeith Long	1947-10-25	—	6159738489	7989 Maple Ave, Miami, FL, 33196	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-424822	CLM	Ethan Ray	1990-08-08	UHC-45961-16	9137226741	—	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
CLM-413412	CLM	Jordan Alvarado	1984-03-12	UHC-21426-35	—	4827 Lake View Rd, Fresno, CA, 93725	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-400855	CLM	Crol Porter	—	—	5038348350	3041 Market St, Glendale, AZ, 85302	0.80	Name re-cased Date of birth unreadable Phone reformatted Placeholder values cleared
CLM-411365	CLM	Elizabeth Ray	1991-01-25	—	—	7416 Oak St, Las Vegas, NV, 89186	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared

13,120 rows, page 176 of 263Previous Next