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

Third-party administrator, flag “Date of birth unreadable”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagDate of birth unreadableClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-58578	TPA	Christine Stevens	—	—	4159441739	9540 Broadway, San Antonio, TX, 78215	0.78	Date of birth unreadable Phone reformatted Address re-cased Whitespace trimmed+1 more
TPA-60823	TPA	Deborah Ferrnandez	—	—	—	5013 Broadway, Miami, FL, 33157	0.78	Name re-cased Date of birth unreadable Address re-cased Whitespace trimmed+1 more
TPA-60364	TPA	Sara Marshall	—	—	—	4451 Pine Dr, Fresno, CA, 93743	0.80	Name re-cased Date of birth unreadable State code upper-cased Placeholder values cleared
TPA-53901	TPA	Kevin Rice	—	—	—	8670 Main St, Chandler, AZ, 85265	0.80	Date of birth reformatted Date of birth unreadable City re-cased Placeholder values cleared
TPA-63970	TPA	Terry Hansen	—	—	8696771414	—	0.80	Date of birth reformatted Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-53878	TPA	Christian Ray	—	—	7582319477	5974 Grand Ave, Tampa, FL, 33646	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-50472	TPA	Kenneth Parker	—	—	—	—	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-62095	TPA	Paul Hudson	—	—	—	—	0.80	Date of birth unreadable Email lower-cased Whitespace trimmed Placeholder values cleared
TPA-63696	TPA	Amanda Andrews	—	UHC-57948-95	—	7758 Central Ave, Chandler, AZ, 85275	0.80	Date of birth unreadable City re-cased Whitespace trimmed Placeholder values cleared
TPA-52253	TPA	Martha Jones	—	—	—	4291 Market St, San Diego, CA, 92187	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-54517	TPA	Agela Moreno	—	—	9135859151	5944 Park Pl, Houston, TX, 77001	0.80	Date of birth unreadable Phone reformatted Whitespace trimmed Placeholder values cleared
TPA-62823	TPA	Peter Garrett	—	—	—	1338 Bayshore Dr, Scottsdale, AZ, 85229	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-60066	TPA	Joe Rivera	—	—	—	8364 Camelback Rd, Gilbert, AZ, 85259	0.80	Date of birth unreadable City re-cased Whitespace trimmed Placeholder values cleared
TPA-50095	TPA	Alice Le	—	—	—	4656 Hillcrest Rd, Glendale, AZ, 85382	0.80	Date of birth unreadable State code upper-cased Whitespace trimmed Placeholder values cleared
TPA-63698	TPA	Judy Oliver	—	—	6075564845	9763 Harbor Blvd, Plano, TX, 75089	0.80	Date of birth unreadable Phone reformatted Whitespace trimmed Placeholder values cleared
TPA-55835	TPA	Katherine Gomez	—	—	—	—	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-59636	TPA	Bevrely Vasquez	—	UHC-14586-30	—	—	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-51285	TPA	Yuki White	—	—	—	—	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-63009	TPA	Austin Rogers	—	—	—	7743 Sage Ct, San Antonio, TX, 78273	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-51233	TPA	Santiago Schmidt	—	—	4674756185	5291 Forest Ave, Jacksonville, FL, 32271	0.80	Name re-cased Date of birth unreadable Phone reformatted Placeholder values cleared
TPA-56852	TPA	Martha Campbell	—	—	—	2352 Broadway, Mesa, AZ, 85287	0.80	Date of birth unreadable Address re-cased Whitespace trimmed Placeholder values cleared
TPA-57836	TPA	Gerald T Sandoval	—	UHC-41043-56	—	1877 Mesa Dr, Mesa, AZ, 85212	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-56040	TPA	Kayla Perkins	—	—	8953654751	9256 Sunset Blvd, Seattle, WA, 98168	0.80	Date of birth unreadable Phone reformatted Whitespace trimmed Placeholder values cleared
TPA-64074	TPA	Mariana M Little	—	—	—	4453 Market St, Chandler, AZ, 85286	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-59882	TPA	Grace Carter	—	—	2522785572	1028 Church St, Denver, CO, 80236	0.82	Date of birth unreadable Phone reformatted Placeholder values cleared
TPA-63749	TPA	Joe Vargas	—	—	—	—	0.82	Name re-cased Date of birth unreadable Placeholder values cleared
TPA-62284	TPA	Tony Myers	—	—	—	4764 Sunset Blvd, Eden Prairie, MN, 55334	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-56693	TPA	Hannah Carroll	—	—	9098181731	—	0.82	Date of birth unreadable Phone reformatted Placeholder values cleared
TPA-56604	TPA	Kelly Tucker	—	—	—	—	0.82	Name re-cased Date of birth unreadable Placeholder values cleared
TPA-59493	TPA	Austin Bishop	—	—	—	3168 Central Ave, Phoenix, AZ, 85014	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-55522	TPA	Charlotte F Bryent	—	UHC-22651-59	—	—	0.82	Name re-cased Date of birth unreadable Placeholder values cleared
TPA-63062	TPA	Jeffrey Phillips	—	—	2955335291	—	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-60525	TPA	Maria Jenkins	—	—	—	2486 Mountain View Dr, Jacksonville, FL, 32232	0.82	Name re-cased Date of birth unreadable Placeholder values cleared
TPA-61275	TPA	Denise Adams	—	—	8638571973	—	0.82	Date of birth unreadable Phone reformatted Placeholder values cleared
TPA-60952	TPA	Elizabeth Meyre	—	—	—	—	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-50804	TPA	Betty T Peters	—	—	—	7521 Camelback Rd, Sacramento, CA, 95881	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-51021	TPA	Diana A Hudson	—	—	—	—	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-50195	TPA	Nicole Chen	—	—	—	—	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-53078	TPA	Jesse Hudson	—	—	8006928238	7065 Lincoln Way, Los Angeles, CA, 90025	0.82	Date of birth unreadable Phone reformatted Placeholder values cleared
TPA-58766	TPA	Ronald Burton	—	—	—	8308 Washington St, Denver, CO, 80243	0.82	Date of birth reformatted Date of birth unreadable Placeholder values cleared
TPA-63242	TPA	Jack Pierce	—	—	—	—	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-60951	TPA	Andrew Hunt	—	—	—	—	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-53287	TPA	Teresa Hansen	—	—	—	5250 Jefferson Ave, Minneapolis, MN, 55462	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-60556	TPA	Chuck Cook	—	—	8907572188	7669 Hillcrest Rd, Orlando, FL, 32812	0.82	Name re-cased Date of birth unreadable Placeholder values cleared
TPA-64334	TPA	Isabella Gordon	—	—	—	752 Mountain View Dr, Los Angeles, CA, 90062	0.82	Name re-cased Date of birth unreadable Placeholder values cleared
TPA-55658	TPA	Kathryn Lawrence	—	—	4057660111	6151 Broadway, Columbus, OH, 43227	0.82	Date of birth unreadable Phone reformatted Placeholder values cleared
TPA-62628	TPA	Mariana K Hanry	—	—	—	—	0.82	Name re-cased Date of birth unreadable Placeholder values cleared
TPA-59284	TPA	Artthur Chavez	—	—	4288386557	—	0.82	Date of birth unreadable Phone reformatted Placeholder values cleared
TPA-62440	TPA	Jerry Willimason	—	UHC-31382-25	—	4925 Jefferson Ave, Chandler, AZ, 85233	0.82	Date of birth unreadable Whitespace trimmed Placeholder values cleared
TPA-55248	TPA	Barbara Marshall	—	—	—	4996 Central Ave, Jacksonville, FL, 32201	0.82	Date of birth unreadable City re-cased Placeholder values cleared

317 rows, page 6 of 7Previous Next