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

Enrollment, 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
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
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
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
ENR-142363	ENR	Dbera Duncan	—	UHC-31605-54	4827216842	5984 Canyon Rd, Atlanta, GA, 30368	0.68	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased
ENR-128315	ENR	Oilvia M Gonzales	—	UHC-00411-18	9682994643	8846 Apache Blvd, Seattle, WA, 98151	0.68	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed
ENR-115362	ENR	Margaret Gilbert	—	UHC-60344-23	3955705572	6590 Canyon Rd, Minneapolis, MN, 55486	0.68	Name split from “Last, First”Date of birth unreadable Phone reformatted Whitespace trimmed
ENR-111037	ENR	Aisha E Austin	—	UHC-24449-23	6565757573	871 Mesa Dr, San Diego, CA, 92192	0.68	Date of birth unreadable Phone reformatted Gender normalised Placeholder values cleared
ENR-123381	ENR	Susan X Burns	—	UHC-68235-49	—	4393 Ridge Rd, Denver, CO, 80253	0.68	Date of birth unreadable Street suffix standardised Address re-cased Placeholder values cleared
ENR-121388	ENR	Keith Henry	—	UHC-86871-50	—	—	0.68	Name re-cased Date of birth unreadable Gender normalised Placeholder values cleared
ENR-137711	ENR	Elizabeth Chapman	—	UHC-53911-66	—	3446 Elm St, Gilbert, AZ	0.68	Name re-cased Date of birth unreadable ZIP missing Placeholder values cleared
ENR-110012	ENR	Bruce Q Sanchez	—	UHC-82303-65	4242703589	990 Palm Dr, San Diego, CA, 92179	0.68	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed
ENR-118833	ENR	Gloria L Williamson	—	UHC-69885-71	8067920482	1445 Broadway, Austin, TX, 78727	0.68	Middle initial moved out of first name Date of birth unreadable Phone reformatted Placeholder values cleared
ENR-107222	ENR	Ashley J Roberts	—	UHC-42068-49	6529182634	—	0.68	Name split from “Last, First”Date of birth unreadable Email lower-cased Placeholder values cleared
ENR-142003	ENR	Virginia T Gordon	—	UHC-62470-62	—	3974 Willow Ct, Gilbert, AZ, 85245	0.68	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased
ENR-138118	ENR	Maria Duncan	—	UHC-64325-03	5056364548	9791 Canyon Rd, Las Vegas, NV, 89186	0.68	Name re-cased Date of birth unreadable Email lower-cased Gender normalised
ENR-109463	ENR	Deborah Jackson	—	UHC-89997-70	—	8786 Jefferson Ave, Las Vegas, NV, 89108	0.68	Name re-cased Date of birth unreadable State code upper-cased ZIP+4 trimmed
ENR-108684	ENR	Joyce V Robertson	—	UHC-29622-20	7529408338	561 Ocean Ave, San Antonio, TX, 78228	0.68	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased
ENR-103286	ENR	Diana Bennett	—	UHC-02217-16	6489880225	7866 Sunset Blvd, Minneapolis, MN, 55487	0.68	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed
ENR-136821	ENR	Arthur Kelley	—	UHC-28863-81	4378213411	4444 Spring St, Tempe, AZ, 85216	0.68	Date of birth unreadable State code upper-cased ZIP+4 trimmed Whitespace trimmed
ENR-140141	ENR	Kelly K Miller	—	UHC-14354-74	5884851834	4486 Palm Dr, Gilbert, AZ, 85205	0.68	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased
ENR-124041	ENR	Roger Wright	—	UHC-73325-10	3656015148	3969 Desert Sky Blvd, Columbus, OH, 43258	0.68	Date of birth unreadable Street suffix standardised Address re-cased Whitespace trimmed
ENR-118043	ENR	Sarah I Oliver	—	UHC-32902-31	2285136446	4779 Union St, Minneapolis, MN, 55405	0.68	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased
ENR-129071	ENR	Evelyn X Graham	—	UHC-18366-77	5897556703	551 Washington St, Sacramento, CA, 95807	0.68	Name re-cased Date of birth unreadable ZIP+4 trimmed Whitespace trimmed
ENR-115358	ENR	Alexander Cruz	—	UHC-39381-75	—	1838 Sunset Blvd, Houston, TX, 77078	0.68	Date of birth unreadable Street suffix standardised Address re-cased Placeholder values cleared
ENR-118023	ENR	Jen Smith	—	UHC-75273-23	—	1879 Bayshore Dr, Jacksonville, FL, 32298	0.68	Date of birth unreadable Street suffix standardised Address re-cased Placeholder values cleared
ENR-100952	ENR	Kyle Nelson	—	UHC-49038-08	2295679104	9867 Ridge Rd, Columbus, OH, 43227	0.68	Name split from “Last, First”Date of birth unreadable Phone reformatted Whitespace trimmed
ENR-119914	ENR	Justin Delgado	—	UHC-04114-56	6744949509	1540 Valley View Dr, Jacksonville, FL, 32247	0.68	Name re-cased Date of birth unreadable ZIP+4 trimmed Placeholder values cleared
ENR-139550	ENR	Barb Rodriguez	—	UHC-75032-93	—	1117 Ridge Rd, Phoenix, AZ, 85068	0.68	Date of birth unreadable Street suffix standardised Address re-cased Placeholder values cleared
ENR-106506	ENR	Harold B Wilson	—	UHC-79831-18	5393133057	184 Indian School Rd, Miami, FL, 33137	0.68	Date of birth unreadable Street suffix standardised Address re-cased Email lower-cased
ENR-127346	ENR	Eric O Johnston	—	UHC-30772-05	2586446699	8379 Church St, Atlanta, GA, 30388	0.68	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased
ENR-116122	ENR	Julie I Lewis	—	UHC-04157-39	—	7632 Church St, Seattle, WA, 98167	0.68	Name re-cased Date of birth unreadable SSN last four extracted Whitespace trimmed
ENR-141933	ENR	Douglas D Castillo	—	UHC-86309-17	—	81 Mesa Dr, Phoenix, AZ, 85050	0.68	Name re-cased Date of birth unreadable Phone missing area code Email lower-cased
ENR-110764	ENR	Owens O Donna	—	UHC-85375-59	4068516946	8046 Oak St, Glendale, AZ, 85349	0.68	Date of birth unreadable Street suffix standardised Address re-cased Email lower-cased
ENR-120362	ENR	Joyce M Grza	—	UHC-98079-58	7889027235	—	0.68	Name split from “Last, First”Date of birth unreadable Phone reformatted Whitespace trimmed
ENR-130210	ENR	Mark W Day	—	UHC-40883-26	8694762010	9298 Bayshore Dr, Charlotte, NC, 28276	0.68	Middle initial moved out of first name Date of birth unreadable Whitespace trimmed Placeholder values cleared
ENR-119522	ENR	Lawrence T Owens	—	UHC-66059-99	5245311349	2445 Grand Ave, Scottsdale, AZ, 85205	0.68	Name split from “Last, First”Date of birth unreadable Phone reformatted Whitespace trimmed
ENR-106717	ENR	Joseph F Rojas	—	UHC-50449-34	6147685977	3168 Willow Ct, Gilbert, AZ, 85284	0.68	Date of birth unreadable City re-cased ZIP+4 trimmed Placeholder values cleared
ENR-119825	ENR	Katherine Jacobs	—	UHC-26509-84	3998865637	9842 Indian School Rd, Phoenix, AZ, 85091	0.68	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased
ENR-119430	ENR	Douglas J Guerrero	—	UHC-01929-44	6167295315	9814 Pine Dr, Miami, FL, 33130	0.68	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased
ENR-101973	ENR	Douglas U Hill	—	UHC-33322-25	5324308942	7413 Hillcrest Rd, Denver, CO, 80215	0.68	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased
ENR-101972	ENR	Douglas U Hill	—	UHC-33322-25	5324308942	7413 Hillcrest Rd, Denver, CO, 80215	0.68	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased
ENR-104243	ENR	Jess G Carroll	—	UHC-03251-98	3618668303	7789 Spring St, Scottsdale, AZ, 85265	0.68	Date of birth unreadable State name converted to code Email lower-cased Whitespace trimmed
ENR-132886	ENR	Kayla E Edwards	—	UHC-75544-45	6002520497	8770 Lake View Rd # 676, Mesa, AZ, 85288	0.68	Name re-cased Date of birth unreadable Unit split from street Placeholder values cleared
ENR-118653	ENR	Kethryn Mendez	—	UHC-34100-98	5669214260	8345 Meadow Ln, San Antonio, TX, 78210	0.68	Date of birth unreadable City re-cased Gender normalised Placeholder values cleared

991 rows, page 15 of 20Previous Next