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 “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
ENR-132800	ENR	Judy Espinoza	1940-07-03	UHC-18199-45	6108541427	4889 Cedar Ln, Los Angeles, CA, 90056	0.80	Name re-cased Street suffix standardised Address re-cased City re-cased
ENR-128153	ENR	Bill L Kim	2003-05-19	UHC-42424-16	4588729795	9073 Cedar Ln, Mesa, AZ, 85227	0.80	Phone reformatted City re-cased ZIP+4 trimmed Whitespace trimmed
ENR-113883	ENR	Mariana J Robinson	1972-02-23	UHC-97299-17	—	7237 Ridge Rd, Orlando, FL, 32810	0.80	Date of birth reformatted City re-cased ZIP+4 trimmed Whitespace trimmed
ENR-132107	ENR	Joyce R Bradley	1952-04-01	UHC-64440-61	9035654587	6419 Mesa Dr, Denver, CO, 80298	0.80	Street suffix standardised Address re-cased City re-cased Whitespace trimmed
ENR-103635	ENR	Stephanie L Mitcehll	1968-02-16	UHC-04952-68	7758470485	1081 Broadway, Tempe, AZ, 85283	0.80	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed
ENR-116718	ENR	Karen Sullivan	1953-01-28	UHC-01122-97	7436642753	5350 Main St, Gilbert, AZ, 85272	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-135476	ENR	ChristinaJunk	1942-03-08	UHC-75863-44	5424481134	8964 Maple Ave, Charlotte, NC, 28230	0.80	Phone reformatted City re-cased Whitespace trimmed No usable name (quarantined)
ENR-122003	ENR	Omar E Thompson	1960-06-03	UHC-24165-49	4862228757	2925 Bayshore Dr, Chandler, AZ, 85290	0.80	City re-cased State name converted to code Email lower-cased Whitespace trimmed
ENR-106415	ENR	Virginia J Munoz	1964-08-23	UHC-21025-48	6556513146	4537 Oak St, Los Angeles, CA, 90018	0.80	Name re-cased Date of birth reformatted City re-cased Gender normalised
ENR-140504	ENR	Ronald Wheeler	2001-02-14	UHC-40273-72	2594435268	1587 Park Pl Apt 17, Plano, TX, 75076	0.80	Date of birth reformatted Unit split from street City re-cased Whitespace trimmed
ENR-128327	ENR	Aisha Silva	1999-03-11	UHC-68482-80	9004801730	7275 Lincoln Way, Houston, TX, 77071	0.80	Phone reformatted City re-cased Gender normalised Whitespace trimmed
ENR-111769	ENR	Adma Schmidt	1993-07-24	UHC-60017-86	—	7560 Baseline Rd, Charlotte, NC, 28216	0.80	Name re-cased Date of birth reformatted Phone missing area code City re-cased
ENR-133368	ENR	Bobby Wang	1956-11-16	UHC-68489-94	9377526731	6420 Camelback Rd, Austin, TX, 78778	0.80	Street suffix standardised Address re-cased City re-cased Whitespace trimmed
ENR-122452	ENR	Yuki Rios	1979-11-21	UHC-04431-12	5425797223	2827 Central Ave, Orlando, FL, 32883	0.80	Name re-cased Phone reformatted City re-cased Gender normalised
ENR-128372	ENR	Emma Barnes	1960-10-15	UHC-43601-62	4779654838	3633 Desert Sky Blvd, Tucson, AZ, 85724	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
ENR-103870	ENR	Carl Morgan	1992-08-12	UHC-90910-90	2293914072	459 Indian School Rd # 951, Los Angeles, CA, 90048	0.80	Phone reformatted Unit split from street City re-cased Whitespace trimmed
ENR-103219	ENR	Lawson H Richard	1947-05-12	UHC-60766-62	3156498280	560 Maple Ave, Dallas, TX, 75294	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-108704	ENR	Pamela Q Black	1969-01-06	UHC-33930-18	3672552354	8059 Park Pl, Denver, CO, 80257	0.80	Name re-cased Street suffix standardised Address re-cased City re-cased
ENR-142322	ENR	Aisha Gardner	1969-09-06	UHC-26182-08	8297864618	8538 Hillcrest Rd # 796, Sacramento, CA, 95884	0.80	Phone reformatted Unit split from street City re-cased Placeholder values cleared
ENR-131057	ENR	Mariana Q Gardner	2001-01-24	UHC-13906-61	3017992114	7580 Willow Ct, Miami, FL, 33169	0.80	Date of birth reformatted Street suffix standardised Address re-cased City re-cased
ENR-122636	ENR	Luis Johnson	1965-07-02	UHC-05639-79	4345598784	6988 Valley View Dr, Jacksonville, FL, 32282	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-121435	ENR	Carlos C Kennedy	1976-02-05	UHC-61491-38	9014896388	6234 Highland Ave, Phoenix, AZ	0.80	Name re-cased City re-cased ZIP missing Whitespace trimmed
ENR-103490	ENR	Henry Clark	2002-08-01	UHC-24589-21	—	7748 Central Ave, Tempe, AZ, 85216	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
ENR-140540	ENR	Dennis Brown	1944-05-22	UHC-22981-87	5062915317	5143 Cedar Ln, Minneapolis, MN, 55447	0.80	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed
ENR-129999	ENR	Mariana Walsh	1999-03-09	UHC-09302-71	3435206070	4472 Park Pl, Los Angeles, CA, 90060	0.80	Two-digit birth year City re-cased Whitespace trimmed Placeholder values cleared
ENR-136408	ENR	Karen Y Bailey	1973-09-26	UHC-48498-11	5242457966	2674 Desert Sky Blvd, Plano, TX, 75086	0.80	Street suffix standardised Address re-cased City re-cased Whitespace trimmed
ENR-136409	ENR	Karen Y Bailey	1973-09-26	UHC-48498-11	5242457966	2674 Desert Sky Blvd, Plano, TX, 75086	0.80	Street suffix standardised Address re-cased City re-cased Whitespace trimmed
ENR-124982	ENR	Keith Robinson	1981-11-05	UHC-40022-20	9504651193	7321 Baseline Rd, Los Angeles, CA, 90066	0.80	Name split from “Last, First”Date of birth reformatted Phone reformatted City re-cased
ENR-113932	ENR	Stephen H Smith	1942-12-05	UHC-26563-91	7103129215	2624 Mountain View Dr, San Diego, CA, 92113	0.80	Phone reformatted City re-cased ZIP+4 trimmed Placeholder values cleared
ENR-105161	ENR	Joyce O Duncan	1982-09-14	UHC-07860-94	9555856598	3519 Ridge Rd, Dallas, TX	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
ENR-105162	ENR	Joyce O Duncan	1982-09-14	UHC-07860-94	9555856598	3519 Ridge Rd, Dallas, TX	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
ENR-136246	ENR	Kimberly P Medina	2008-12-06	UHC-73287-27	4423149022	9266 Valley View Dr, Tucson, AZ, 85728	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-125837	ENR	Lauren L Jenkins	1993-01-23	UHC-90622-75	4202581056	6021 Mountain View Dr Apt 9, Austin, TX, 78732	0.80	Phone reformatted Unit split from street City re-cased Whitespace trimmed
ENR-121205	ENR	Carl E Schmidt	1963-05-09	UHC-97348-98	7774573348	1359 Pine Dr, Mesa, AZ, 85254	0.80	Date of birth reformatted City re-cased State name converted to code Placeholder values cleared
ENR-110979	ENR	Judith Dominguez	1957-12-14	UHC-66421-81	—	2538 Church St, Tucson, AZ, 85705	0.80	Street suffix standardised Address re-cased City re-cased Whitespace trimmed
ENR-109294	ENR	Jesse Spencer	1943-11-24	UHC-33209-09	5777704546	5080 Harbor Blvd, Seattle, WA, 98107	0.80	Name split from “Last, First”Date of birth reformatted Phone reformatted City re-cased
ENR-106850	ENR	Jeremy Meyer	1963-04-07	UHC-94721-53	5479913525	8223 Spring St, Chandler, AZ, 85277	0.80	Name split from “Last, First”Phone reformatted City re-cased Placeholder values cleared
ENR-126740	ENR	Christian Armstrong	1980-05-16	UHC-92644-64	3238546969	1291 Jefferson Ave, Tampa, FL, 33668	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-132826	ENR	Timothy D Stephens	1964-12-22	UHC-43932-39	5273593640	7303 Forest Ave, Plano, TX, 75095	0.80	Date of birth reformatted Street suffix standardised Address re-cased City re-cased
ENR-134522	ENR	Aaron O Moore	1995-06-17	UHC-40687-94	7935208211	7264 Indian School Rd, San Diego, CA, 92174	0.80	Date of birth reformatted Street suffix standardised Address re-cased City re-cased
ENR-125579	ENR	Joshua L Wood	1938-06-09	UHC-58223-62	8318293311	9593 Mountain View Dr, Columbus, OH, 43236	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-101896	ENR	Gerald Andrews	1957-01-24	UHC-92735-21	5137568274	7825 Meadow Ln, Atlanta, GA, 30381	0.80	City re-cased Email lower-cased Gender normalised Whitespace trimmed
ENR-108708	ENR	Danielle Collins	1983-10-27	UHC-40425-91	4824884280	2407 Park Pl, Tampa, FL, 33610	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
ENR-135650	ENR	Carol Murray	—	UHC-75188-27	8755683662	91 Spring St, Eden Prairie, MN, 55327	0.80	Name re-cased Date of birth unreadable City re-cased Whitespace trimmed
ENR-131170	ENR	Marcus Lucas	1977-07-02	UHC-60609-80	2404217979	9776 Valley View Dr, Glendale, AZ, 85315	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-113472	ENR	Sharon Bryant	1996-06-03	UHC-82381-52	4346497131	316 Mountain View Dr, Miami, FL, 33131	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-123190	ENR	Raymond Reyes	1972-11-14	UHC-12708-34	4285472035	5870 Lincoln Way, Denver, CO, 80290	0.80	Date of birth reformatted Member ID reformatted City re-cased State name converted to code
ENR-111981	ENR	Logan T Daniels	1942-01-23	UHC-42295-25	9429674440	1651 Desert Sky Blvd, Houston, TX	0.80	Phone reformatted City re-cased ZIP missing Whitespace trimmed
ENR-116442	ENR	Mateo A Turner	1939-03-07	UHC-46506-14	3758201513	8032 Mesa Dr, Scottsdale, AZ, 85224	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-100610	ENR	Joseph A Silva	1979-05-07	UHC-84565-25	7105982586	2092 Spring St # 620, Mesa, AZ, 85285	0.80	Name re-cased Date of birth reformatted Unit split from street City re-cased

8,423 rows, page 134 of 169Previous Next