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 “Gender normalised”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagGender normalisedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-116849	ENR	Priya Marquez	1979-07-08	UHC-15525-70	4506653889	5769 Church St, Scottsdale, AZ, 85250	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-103483	ENR	Janet G Alvarado	1977-01-01	UHC-58974-74	4749805830	4558 Cedar Ln, Nashville, TN, 37284	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
ENR-129434	ENR	Scott W Thomas	1979-06-10	UHC-23637-74	7138305068	3750 Bayshore Dr, Chandler, AZ, 85239	0.68	Name re-cased Street suffix standardised Address re-cased Gender normalised
ENR-113567	ENR	Brittany Simpson	1992-05-18	UHC-61931-71	6359934670	3674 Church St, Las Vegas, NV, 89106	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
ENR-132711	ENR	Vincent Evans	1983-04-07	UHC-89082-94	7048783966	7835 Church St, Eden Prairie, MN, 55357	0.68	Street suffix standardised Address re-cased Email lower-cased Gender normalised
ENR-119831	ENR	Martha Rogers	1942-10-09	UHC-97687-25	7048212313	7733 Jefferson Ave, San Antonio, TX	0.68	Phone reformatted ZIP missing Gender normalised Whitespace trimmed
ENR-136100	ENR	Stephanie S Perez	1965-08-25	UHC-82601-85	4752201274	3980 Market St, Plano, TX, 75005	0.68	Two-digit birth year Phone reformatted City re-cased Gender normalised
ENR-132957	ENR	Andrea Q Hudson	1960-02-22	UHC-74064-92	—	2166 Lake View Rd, Los Angeles, CA, 90067	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-109904	ENR	Melissa Valdez	1954-02-10	UHC-81960-04	6816351928	962 Valley View Dr, Dallas, TX	0.68	City re-cased ZIP missing Gender normalised Whitespace trimmed
ENR-130156	ENR	Sarah N Foster	1962-11-03	UHC-39292-13	—	5075 Apache Blvd, Seattle, WA, 98161	0.68	Name re-cased State name converted to code Gender normalised Placeholder values cleared
ENR-112426	ENR	James Hunter	1991-12-20	UHC-23755-18	9708788232	1586 Grand Ave, Tucson, AZ, 85774	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-102935	ENR	Beverly H Price	1962-05-28	UHC-13639-59	2176874402	3799 Willow Ct, Seattle, WA, 98175	0.68	Name re-cased ZIP+4 trimmed Gender normalised Whitespace trimmed
ENR-117555	ENR	Luis O Peters	2000-12-01	UHC-99143-52	—	4568 Cedar Ln, Austin, TX, 78737	0.68	Date of birth reformatted Phone missing area code Email lower-cased Gender normalised
ENR-110069	ENR	Elizabeth Hill	2002-09-20	UHC-03957-05	9715702551	7340 Pine Dr, Plano, TX, 75015	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-130141	ENR	Sam Valdez	1950-02-09	UHC-09139-97	2996051262	6880 Park Pl, Glendale, AZ, 85362	0.68	Name re-cased Phone reformatted ZIP+4 trimmed Gender normalised
ENR-117517	ENR	Dennis Boyd	1990-02-09	UHC-62213-03	3976135821	614 Hillcrest Rd, Plano, TX	0.68	Phone reformatted ZIP missing Email lower-cased Gender normalised
ENR-117034	ENR	Brittany F Willis	1978-02-10	UHC-29342-44	—	6478 Pine Dr, Scottsdale, AZ, 85275	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-135740	ENR	Debra Campbel	1985-06-08	UHC-83937-54	7096823811	3827 Spring St, Los Angeles, CA, 90081	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-119502	ENR	Ronald X Reid	1978-09-11	UHC-15374-37	8807949813	3966 Mountain View Dr, Austin, TX, 78799	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
ENR-114557	ENR	Samuel R Gomez	1993-12-17	UHC-03152-04	4427451814	105 Grand Ave, Gilbert, AZ, 85206	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-136741	ENR	Raymond Stevens	1945-09-18	UHC-78535-14	8275860246	4183 Ocean Ave, Eden Prairie, MN, 55313	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-131847	ENR	Bobby U Torres	1951-01-21	UHC-79343-32	5898300089	2970 Grand Ave, Dallas, TX, 75267	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-135572	ENR	Paul Fowler	1957-02-27	UHC-17761-59	6209496513	1318 Hillcrest Rd, Jacksonville, FL, 32234	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
ENR-129788	ENR	Ronald I Meyer	1969-12-15	UHC-34548-71	5765375264	9051 Desert Sky Blvd # 227, Austin, TX, 78796	0.68	Name re-cased Unit split from street Gender normalised Whitespace trimmed
ENR-106565	ENR	Diego O Turner	1949-06-20	UHC-55844-12	5127468412	6968 Harbor Blvd, Dallas, TX, 75279	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
ENR-124633	ENR	John Henderson	1977-06-20	UHC-90386-33	4096066200	5437 Meadow Ln, Mesa, AZ, 85215	0.68	Street suffix standardised Address re-cased Gender normalised Plan code upper-cased
ENR-121968	ENR	Grace P Hernandez	1951-12-14	UHC-88884-27	2075289147	1280 Sunset Blvd, Chandler, AZ, 85229	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-104790	ENR	Amber X Tucker	1973-08-10	UHC-54636-28	7297232396	5701 Lake View Rd, Minneapolis, MN, 55470	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-120359	ENR	Madison T Padilla	1968-11-07	UHC-93662-76	4164693978	6184 Ridge Rd, Miami, FL, 33178	0.68	Name split from “Last, First”Phone reformatted Gender normalised Placeholder values cleared
ENR-128805	ENR	Paul G Perez	1954-11-15	UHC-31595-01	—	7031 Lincoln Way, Sacramento, CA, 95843	0.68	Name re-cased Phone missing area code Gender normalised Whitespace trimmed
ENR-107055	ENR	Sofia G Brown	2003-06-02	UHC-17194-60	—	8770 Lake View Rd, Scottsdale, AZ, 85247	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-134846	ENR	Ahmed Fisher	1970-04-26	UHC-88024-63	7932106193	3622 Church St, San Diego, CA, 92106	0.68	Street suffix standardised Address re-cased Email lower-cased Gender normalised
ENR-132307	ENR	Billy Lawrence	1942-02-09	UHC-31776-14	9477586116	187 Cedar Ln, Seattle, WA, 98191	0.68	Phone reformatted SSN last four extracted Gender normalised Placeholder values cleared
ENR-140532	ENR	Danielle A Wellch	1978-03-10	UHC-57613-39	7782453061	2220 Willow Ct, Tempe, AZ, 85215	0.68	Middle initial moved out of first name Name re-cased Phone reformatted Gender normalised
ENR-136492	ENR	Catherine K Jones	2003-04-07	UHC-34408-38	7004956362	311 Willow Ct, Jacksonville, FL, 32259	0.68	Name re-cased Street suffix standardised Address re-cased Gender normalised
ENR-122546	ENR	Arthur C Myers	1996-12-25	UHC-31883-53	—	2008 Highland Ave, Tampa, FL, 33634	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-134571	ENR	Hannah Nguyen	1939-07-28	UHC-93448-83	9458314352	8600 Lincoln Way, Los Angeles, CA, 90071	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
ENR-113233	ENR	Bruce Campbell	1972-08-02	UHC-19587-40	2915001758	—	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Whitespace trimmed
ENR-141178	ENR	Dylan P Morrison	1948-06-26	UHC-76007-54	6839591610	368 Apache Blvd, Columbus, OH, 43231	0.68	Date of birth reformatted State name converted to code Gender normalised Whitespace trimmed
ENR-107318	ENR	Mason Gomez	1962-04-19	UHC-14665-92	7955081423	—	0.68	Name split from “Last, First”Phone reformatted Gender normalised Whitespace trimmed
ENR-137583	ENR	Dennis Y Reed	1992-08-11	UHC-52472-31	4118886498	2870 Ridge Rd, Tucson, AZ, 85742	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-130604	ENR	Victoria V Wright	1982-10-28	UHC-88256-05	6724467499	1417 Camelback Rd, Las Vegas, NV, 89176	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
ENR-115151	ENR	Bowman F Katherine	1973-12-10	UHC-03977-71	5567070955	4963 Central Ave # 345, Mesa, AZ, 85286	0.68	Unit split from street City re-cased Gender normalised Whitespace trimmed
ENR-100120	ENR	Mateo B Webb	1945-09-15	UHC-66219-86	6244527145	8826 Grand Ave, Charlotte, NC, 28258	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-111894	ENR	Brittany O Hawknis	1982-05-12	UHC-09960-63	7515691385	2844 Meadow Ln, Los Angeles, CA, 90098	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-101799	ENR	Amy Graham	1942-10-28	UHC-93467-22	8128178278	3276 Oak St, Seattle, WA, 98148	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
ENR-106171	ENR	Karen Perez	2004-08-20	UHC-19309-60	7508465667	7831 Park Pl, Las Vegas, NV, 89130	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
ENR-138492	ENR	Bradley Dean	1982-08-19	UHC-57976-31	9303090691	2578 Washington St, Charlotte, NC, 28222	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
ENR-141717	ENR	Ronald Morales	1966-10-19	UHC-25860-33	3797617079	3264 Willow Ct, Plano, TX, 75010	0.68	Two-digit birth year Phone reformatted Member ID reformatted Gender normalised
ENR-109975	ENR	Brian S Patterrson	1992-09-23	UHC-33502-60	8368938815	6786 Pine Dr, Scottsdale, AZ, 85266	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised

7,326 rows, page 108 of 147Previous Next