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

All sources, 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
PRV-20003	PRV	Shirley Hernandez	—	—	4607738796	1513 Baseline Rd, Eden Prairie, MN, 55341	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-432806	CLM	Carlos K Payne	—	UHC-13103-96	8973881268	3843 Broadway, Houston, TX, 77040	0.66	Name re-cased Date of birth unreadable State name converted to code Whitespace trimmed+1 more
CLM-432807	CLM	Carlos K Payne	—	UHC-13103-96	8973881268	3843 Broadway, Houston, TX, 77040	0.66	Name re-cased Date of birth unreadable State name converted to code Whitespace trimmed+1 more
CLM-401170	CLM	Anna Lawrence	—	UHC-95417-06	—	9750 Sage Ct, Las Vegas, NV, 89112	0.66	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-23749	PRV	Jennifer E Wattson	—	—	8907140389	9725 Harbor Blvd, Tucson, AZ, 85783	0.66	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+1 more
CLM-426876	CLM	Philip Johnston	—	UHC-61230-27	—	9556 River Rd, Tucson, AZ, 85789	0.66	Date of birth unreadable Street suffix standardised Address re-cased City re-cased+1 more
ENR-104294	ENR	Hannah I Menoza	—	UHC-59675-28	2909254756	7245 Baseline Rd, Chandler, AZ, 85224	0.66	Name re-cased Date of birth unreadable Phone reformatted SSN last four extracted+1 more
TPA-52928	TPA	Terrry F Kelly	—	—	7678597949	2627 Highland Ave, Phoenix, AZ, 85077	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
TPA-63414	TPA	Margaret Jordan	—	—	6437042374	4851 Harbor Blvd, Denver, CO, 80295	0.66	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-417080	CLM	Camila P Hamilton	—	UHC-40053-43	—	1205 Washington St, Tempe, AZ, 85205	0.66	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+1 more
TPA-63331	TPA	Christian I Simmons	—	—	—	8494 Central Ave, Phoenix, AZ, 85092	0.66	Date of birth unreadable Street suffix standardised Address re-cased State code upper-cased+1 more
ENR-136780	ENR	Janet G Rivera	—	UHC-30333-71	5492166868	846 Bayshore Dr, Los Angeles, CA, 90017	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-406694	CLM	Arjun Hunt	—	—	—	3349 Spring St, Eden Prairie, MN, 55309	0.66	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-119943	ENR	Wei Carr	—	UHC-15206-89	2125299826	174 Mesa Dr, Jacksonville, FL, 32269	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-404797	CLM	Alice Perry	—	UHC-53984-35	2096714901	9138 Harbor Blvd, Denver, CO, 80219	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-137558	ENR	Jack Yang	—	UHC-59751-23	3408163035	2958 Camelback Rd, Las Vegas, NV, 89194	0.66	Date of birth unreadable Street suffix standardised Address re-cased City re-cased+1 more
CLM-426462	CLM	Martha Q Soto	—	—	—	1011 Lincoln Way, Glendale, AZ, 85337	0.66	Date of birth unreadable Street suffix standardised Address re-cased City re-cased+1 more
ENR-107957	ENR	Larry Y Barnes	—	UHC-76599-05	4312402230	6609 Market St, Houston, TX, 77037	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-120040	ENR	Judith H Howard	—	UHC-27142-46	3322736253	9141 Harbor Blvd, Glendale, AZ, 85361	0.66	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed+1 more
TPA-61044	TPA	Kyle Miller	—	—	—	436 Union St, Minneapolis, MN, 55458	0.66	Date of birth unreadable Street suffix standardised Address re-cased City re-cased+1 more
ENR-104925	ENR	Robert A Dixon	—	UHC-32829-26	5415952523	6241 Park Pl, Denver, CO, 80295	0.66	Date of birth reformatted Date of birth unreadable Street suffix standardised Address re-cased+1 more
CLM-414792	CLM	Scott Ward	—	UHC-40403-01	9702470172	468 Pine Dr, Jacksonville, FL, 32251	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
TPA-60654	TPA	Aisha Harvey	—	—	—	4208 Main St, Dallas, TX, 75211	0.66	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-111469	ENR	Gary S Stone	—	UHC-26978-96	7758827769	7116 Camelback Rd, Nashville, TN, 37294	0.66	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+1 more
ENR-116092	ENR	Melissa Yang	—	UHC-44188-65	5858799368	5216 Bayshore Dr, Orlando, FL, 32897	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-100744	ENR	Jeremy Castillo	—	UHC-13565-20	7838850213	2634 Pine Dr, Scottsdale, AZ, 85245	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
PRV-27317	PRV	Betty P Wang	—	—	3735019281	2663 Park Pl, Glendale, AZ, 85335	0.66	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed+1 more
TPA-55420	TPA	Jacob James	—	—	—	7327 Ridge Rd, Glendale, AZ, 85381	0.66	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-105605	ENR	Maria Z Ramos	—	UHC-48526-66	2557935878	3571 Sage Ct, Tempe, AZ, 85292	0.66	Date of birth unreadable Street suffix standardised Address re-cased City re-cased+1 more
ENR-115868	ENR	Sandra Vega	—	UHC-58367-35	2424704389	1516 Hillcrest Rd, Atlanta, GA, 30376	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
TPA-50566	TPA	Mei Long	—	—	—	3847 Forest Ave, Dallas, TX, 75236	0.66	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-132436	ENR	Sharon Davis	—	UHC-51717-75	3148206122	9100 Forest Ave, Los Angeles, CA, 90090	0.66	Name re-cased Date of birth reformatted Date of birth unreadable Phone reformatted+1 more
ENR-134457	ENR	Omar Daniels	—	UHC-38881-33	5609388474	7467 Elm St, Eden Prairie, MN, 55397	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-104242	ENR	Kenneth S Cooper	—	UHC-97521-32	4474774516	6394 Baseline Rd, Mesa, AZ, 85234	0.66	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+1 more
ENR-134066	ENR	Valentina C Welch	—	UHC-93033-26	8166164652	6400 Sunset Blvd, Denver, CO, 80289	0.66	Date of birth reformatted Date of birth unreadable Street suffix standardised Address re-cased+1 more
ENR-109922	ENR	Daniel P Wong	—	UHC-33833-96	9673669916	4430 Meadow Ln, Jacksonville, FL	0.66	Name re-cased Date of birth unreadable Phone reformatted ZIP missing+1 more
TPA-57408	TPA	Janet Cruz	—	—	—	6842 Oak St, Chandler, AZ, 85244	0.66	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+1 more
TPA-58812	TPA	Kimberly Ruiz	—	—	—	8217 Valley View Dr, Orlando, FL, 32817	0.66	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed+1 more
ENR-123540	ENR	Burns I Alice	—	UHC-66412-77	—	1416 Pine Dr, Scottsdale, AZ, 85252	0.66	Name re-cased Date of birth unreadable Member ID reformatted State name converted to code+1 more
PRV-23568	PRV	Harold U Rogers	—	UHC-54307-35	4666518737	955 Lake View Rd, Eden Prairie, MN, 55301	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-136700	ENR	Brandon J Ortiz	—	UHC-74873-72	7049033507	9862 Meadow Ln, San Antonio, TX, 78294	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-114027	ENR	Zachary Franklin	—	UHC-52223-19	6803819537	4538 Ocean Ave, Dallas, TX, 75289	0.66	Date of birth unreadable Phone reformatted ZIP+4 trimmed Whitespace trimmed+1 more
ENR-124386	ENR	Bruce Jones	—	UHC-24551-84	4538808599	6757 Church St, Gilbert, AZ, 85254	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-127870	ENR	Jack X Martinez	—	UHC-08920-87	8148301605	3591 Forest Ave, Tempe, AZ, 85214	0.66	Date of birth unreadable Phone reformatted State name converted to code Email lower-cased+1 more
PRV-21164	PRV	Ahmed Y Perez	—	—	9662242443	3435 Broadway, Sacramento, CA, 95811	0.66	Name split from “Last, First”Date of birth unreadable City re-cased Whitespace trimmed+1 more
PRV-24828	PRV	Jonathan Weaver	—	—	8689333157	7790 Park Pl, Nashville, TN, 37221	0.66	Name re-cased Date of birth unreadable Phone reformatted ZIP+4 trimmed+1 more
CLM-401556	CLM	Santiago H Rivera	—	UHC-93168-85	—	3442 Camelback Rd, Minneapolis, MN, 55443	0.66	Date of birth unreadable Street suffix standardised Address re-cased City re-cased+1 more
TPA-63762	TPA	Helen Munoz	—	—	6505700591	7417 Forest Ave Apt 27, San Diego, CA, 92146	0.68	Date of birth unreadable Phone reformatted Unit split from street Placeholder values cleared
CLM-421178	CLM	Willie K Le	—	UHC-73240-85	5725184926	—	0.68	Date of birth unreadable Phone reformatted Gender normalised Whitespace trimmed
CLM-422662	CLM	Carlos Nelson	—	UHC-50499-80	—	—	0.68	Date of birth unreadable Phone missing area code Member ID reformatted Placeholder values cleared

2,274 rows, page 31 of 46Previous Next