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-116211	ENR	Anna Fields	2002-09-25	UHC-54466-35	8406807203	8361 Main St, Houston, TX, 77038	0.80	Phone reformatted City re-cased State name converted to code Whitespace trimmed
ENR-109581	ENR	Jean D Black	2006-07-24	UHC-16293-86	7765838904	7087 Lincoln Way, Nashville, TN, 37274	0.80	Date of birth reformatted City re-cased ZIP+4 trimmed Whitespace trimmed
ENR-128321	ENR	Brian O Watkins	1956-08-02	UHC-63851-69	3882993960	3908 Forest Ave, Chandler, AZ, 85200	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-131595	ENR	Denny Roberts	1947-07-16	UHC-29365-01	5094860652	5055 Maple Ave, Tempe, AZ, 85266	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-140510	ENR	Ronald Silva	1946-07-18	UHC-17595-95	8405450144	1710 Harbor Blvd, Glendale, AZ, 85399	0.80	Name split from “Last, First”Phone reformatted City re-cased Whitespace trimmed
ENR-138164	ENR	Terry Yung	2003-12-26	UHC-16318-17	3786551017	116 Baseline Rd, Houston, TX, 77015	0.80	Street suffix standardised Address re-cased City re-cased Email lower-cased
ENR-117647	ENR	Peter Weaver	1988-01-21	UHC-91738-96	6709798253	6620 Main St, Glendale, AZ, 85357	0.80	Phone reformatted City re-cased Gender normalised Whitespace trimmed
ENR-139820	ENR	Jeffrey E Miller	2004-07-18	UHC-33912-09	4306541115	466 Ocean Ave, Mesa, AZ, 85245	0.80	Phone reformatted Member ID reformatted City re-cased State name converted to code
ENR-109536	ENR	Lopez Q Adam	1969-12-08	UHC-12761-70	8645994886	684 Oak St, Columbus, OH, 43238	0.80	Name re-cased City re-cased State name converted to code Whitespace trimmed
ENR-134219	ENR	Kathleen Bryant	2008-10-21	UHC-81435-34	6342023959	3526 Elm St, Fresno, CA, 93711	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-139966	ENR	Andrew S Vega	1962-12-13	UHC-45507-37	3397085029	5060 Church St, Phoenix, AZ, 85052	0.80	Name re-cased Two-digit birth year City re-cased Whitespace trimmed
ENR-112566	ENR	Andrew O Vargas	2000-03-18	UHC-80697-36	—	1220 Baseline Rd, Los Angeles, CA, 90065	0.80	Street suffix standardised Address re-cased City re-cased Whitespace trimmed
ENR-125103	ENR	Timothy Weaver	1963-06-05	UHC-19209-26	5476905622	5192 Park Pl, Plano, TX, 75064	0.80	Name split from “Last, First”Date of birth reformatted Phone reformatted City re-cased
ENR-118236	ENR	William Tran	1974-06-12	UHC-33437-18	4553916789	2839 Grand Ave, Plano, TX, 75032	0.80	Name re-cased Phone reformatted City re-cased Gender normalised
ENR-130079	ENR	Omar Schultz	1966-11-10	UHC-58276-63	7174056945	6554 Park Pl, Austin, TX, 78727	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-138537	ENR	Kenneth S Ray	—	UHC-87282-25	6774813526	9330 Cedar Ln, Orlando, FL, 32826	0.80	Date of birth unreadable Phone reformatted City re-cased Placeholder values cleared
ENR-111547	ENR	Joshua K Estrada	2006-05-19	UHC-87588-36	—	474 Washington St, San Diego, CA, 92126	0.80	Two-digit birth year City re-cased Email lower-cased Placeholder values cleared
ENR-110679	ENR	Harold Hunt	1943-12-24	UHC-87704-14	8373328788	6737 Lincoln Way, Austin, TX, 78743	0.80	Name re-cased Phone reformatted City re-cased Gender normalised
ENR-128764	ENR	Keith U Long	1985-12-28	UHC-61870-19	3656913767	8925 Highland Ave, Jacksonville, FL, 32227	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-108827	ENR	Christian L Morrison	1969-06-28	UHC-39410-53	5332752929	556 Apache Blvd Apt 34, Fresno, CA, 93731	0.80	Phone reformatted Unit split from street City re-cased Whitespace trimmed
ENR-140365	ENR	Jason Mejia	1996-10-19	UHC-94749-48	5869352046	211 Market St, Seattle, WA, 98168	0.80	Name re-cased Two-digit birth year Phone reformatted City re-cased
ENR-129732	ENR	Russell Spencer	1983-09-17	UHC-70361-34	2429725257	7801 Bayshore Dr, Austin, TX, 78766	0.80	Name split from “Last, First”Phone reformatted City re-cased Whitespace trimmed
ENR-132727	ENR	Barbara R Tran	1968-10-22	UHC-40168-78	3062620856	7626 Sunset Blvd, Tampa, FL	0.80	Date of birth reformatted Phone reformatted City re-cased ZIP missing
ENR-101682	ENR	Santiago Howell	1972-04-14	UHC-67277-92	6365021524	8827 Grand Ave # 355, Austin, TX, 78775	0.80	Date of birth reformatted Phone reformatted Unit split from street City re-cased
ENR-115415	ENR	Elizabeth Grant	1992-06-01	UHC-04739-79	6785805174	3021 Apache Blvd, Eden Prairie, MN, 55386	0.80	Name re-cased Date of birth reformatted City re-cased State name converted to code
ENR-100883	ENR	Juditth Clark	2005-08-21	UHC-45844-31	—	1289 Elm St, Jacksonville, FL, 32201	0.80	Name re-cased Phone missing area code City re-cased Placeholder values cleared
ENR-119158	ENR	Russell P Fields	1978-10-06	UHC-70631-52	2939630406	1174 Lake View Rd, Tempe, AZ, 85260	0.80	Street suffix standardised Address re-cased City re-cased Whitespace trimmed
ENR-116229	ENR	Edward Coleman	—	UHC-77392-61	6329700454	7471 Washington St, Denver, CO, 80222	0.80	Date of birth unreadable Phone reformatted City re-cased Whitespace trimmed
ENR-112778	ENR	Diana Little	1993-06-27	UHC-18143-49	4779766365	9851 Mountain View Dr, Los Angeles, CA, 90083	0.80	Street suffix standardised Address re-cased City re-cased Whitespace trimmed
ENR-118976	ENR	Sophia Hart	1959-04-24	UHC-37456-10	3665537154	8220 Ocean Ave, Denver, CO, 80243	0.80	Date of birth reformatted Street suffix standardised Address re-cased City re-cased
ENR-127399	ENR	Joseph Ortiz	1947-03-02	UHC-93470-79	5564832055	9438 Oak St, Austin, TX, 78729	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-132530	ENR	Gerald Carroll	1969-08-11	UHC-87192-04	2765170952	7456 Ridge Rd # 312, Sacramento, CA, 95891	0.80	Name re-cased Phone reformatted Unit split from street City re-cased
ENR-112861	ENR	Patricia Bryant	1958-04-20	UHC-32560-43	4779234236	5637 Hillcrest Rd, Chandler, AZ, 85294	0.80	Street suffix standardised Address re-cased City re-cased Whitespace trimmed
ENR-110582	ENR	Beverly L Rios	1945-10-15	UHC-66895-93	8228619627	5655 Park Pl, Columbus, OH, 43210	0.80	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed
ENR-118597	ENR	Sarah Q Bennett	1976-11-09	UHC-16639-21	9735663116	9583 Market St, San Antonio, TX, 78239	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-132367	ENR	Benjamin Gonzales	1994-05-26	UHC-95616-82	9439625006	7144 Harbor Blvd, Tempe, AZ, 85234	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
ENR-120225	ENR	Christina W Singh	1981-06-11	UHC-69052-70	—	9085 Baseline Rd, Eden Prairie, MN, 55394	0.80	City re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
ENR-121940	ENR	Camila Romero	1941-04-20	UHC-45685-14	3968047708	6264 Forest Ave, Tampa, FL, 33674	0.80	Name split from “Last, First”Phone reformatted City re-cased Whitespace trimmed
ENR-131221	ENR	Jerry Hunter	1998-11-13	UHC-02293-76	2276623767	3193 Park Pl, Columbus, OH, 43280	0.80	Name re-cased Street suffix standardised Address re-cased City re-cased
ENR-117067	ENR	Bryan C Soto	1986-10-28	UHC-66405-44	—	1605 Lincoln Way, San Antonio, TX, 78221	0.80	Two-digit birth year City re-cased Whitespace trimmed Placeholder values cleared
ENR-114952	ENR	Elizabeth V Ray	1992-01-25	UHC-56495-72	6232037637	7416 Oak St, Las Vegas, NV, 89186	0.80	Name re-cased Date of birth reformatted City re-cased ZIP+4 trimmed
ENR-126023	ENR	Philip Jensen	1956-01-22	UHC-22462-56	6348124308	3876 Bayshore Dr, Chandler, AZ, 85266	0.80	Date of birth reformatted Phone reformatted City re-cased ZIP+4 trimmed
ENR-137507	ENR	Laura Z Jacubs	1985-03-21	UHC-87411-82	7919226255	2503 Lincoln Way, Atlanta, GA, 30384	0.80	Name split from “Last, First”Date of birth reformatted City re-cased Whitespace trimmed
ENR-133250	ENR	Kelly Ross	1945-11-25	UHC-13220-97	5655189190	4065 Palm Dr, San Antonio, TX, 78223	0.80	Name re-cased City re-cased State name converted to code Whitespace trimmed
ENR-118955	ENR	Joshua I Young	1976-07-01	UHC-12060-06	2962464303	228 Meadow Ln, Houston, TX, 77055	0.80	Two-digit birth year Phone reformatted City re-cased Email lower-cased
ENR-109559	ENR	Sara Mitchell	2007-05-01	UHC-43055-25	—	9648 Oak St, Tampa, FL, 33636	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
ENR-131406	ENR	Carol Montgomery	1967-12-22	UHC-63807-77	4278898043	793 Washington St, Austin, TX, 78703	0.80	Street suffix standardised Address re-cased City re-cased Placeholder values cleared
ENR-129448	ENR	Stvee O Tran	1996-01-12	UHC-69565-81	3633447175	7193 Ridge Rd, Las Vegas, NV, 89142	0.80	City re-cased Email lower-cased Gender normalised Whitespace trimmed
ENR-126928	ENR	Janet Mendoza	1998-11-26	UHC-13188-27	4483651439	5780 Mountain View Dr, San Diego, CA, 92101	0.80	Two-digit birth year Phone reformatted City re-cased Whitespace trimmed
ENR-129062	ENR	Sandra Q Robertson	1970-03-20	UHC-96193-90	4235522352	8779 Baseline Rd, Mesa, AZ, 85275	0.80	Phone reformatted City re-cased Gender normalised Whitespace trimmed

8,423 rows, page 135 of 169Previous Next