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 “Two-digit birth year”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagTwo-digit birth yearClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-29092	PRV	Stephanie Lopez	1943-10-18	UHC-95228-95	6445980421	1921 Washington St, Gilbert, AZ, 85201	0.62	Two-digit birth year Phone reformatted Member ID reformatted Street suffix standardised+3 more
CLM-404129	CLM	Cheryl Simmons	2002-12-17	UHC-92867-01	—	3156 Baseline Rd, Sacramento, CA, 95896	0.62	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+3 more
ENR-105408	ENR	Maria Dunn	1964-08-17	UHC-04782-32	—	3948 Hillcrest Rd, Fresno, CA, 93772	0.62	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+3 more
TPA-50719	TPA	Lauren Parker	1986-10-21	—	8495108221	4890 Ocean Ave, San Antonio, TX, 78243	0.62	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+3 more
ENR-133380	ENR	Daniel G Wallace	1940-04-15	UHC-64775-97	9793286812	8459 Lake View Rd, Orlando, FL, 32853	0.62	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-427896	CLM	Aaron Knight	1983-07-13	UHC-95721-09	5246227655	8293 Spring St, Nashville, TN, 37219	0.62	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+3 more
TPA-51309	TPA	Jose Howell	1979-11-01	UHC-12973-72	—	6267 Camelback Rd, Nashville, TN, 37265	0.62	Name re-cased Two-digit birth year Member ID reformatted Street suffix standardised+3 more
CLM-401977	CLM	Charles R Jackson	1947-09-05	—	3633231835	—	0.62	Middle initial moved out of first name Name re-cased Two-digit birth year Phone reformatted+3 more
ENR-111778	ENR	Jsaon Z Cruz	1978-12-25	UHC-52777-98	9426643947	3700 Baseline Rd, Nashville, TN, 37278	0.62	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+3 more
ENR-129183	ENR	Omar C Obrien	1976-06-22	UHC-15358-31	5864108616	3990 Meadow Ln, Chandler, AZ, 85245	0.62	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+3 more
ENR-106996	ENR	Mateo Armstrong	1990-09-02	UHC-08356-33	2332896184	6290 Grand Ave, Columbus, OH, 43257	0.62	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+3 more
ENR-117708	ENR	Cynthia Ellis	1976-04-02	UHC-95330-90	—	2224 Church St, Plano, TX, 75078	0.62	Name re-cased Two-digit birth year Member ID reformatted Street suffix standardised+3 more
ENR-115971	ENR	Mateo Johnston	1998-10-11	UHC-73042-62	7908124245	5560 Elm St, Mesa, AZ, 85294	0.62	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+3 more
TPA-60361	TPA	Mary J Watkins	1994-02-25	—	5853388926	6724 Baseline Rd, Jacksonville, FL, 32288	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-116087	ENR	Vincent X Vazquez	1970-12-02	UHC-50969-35	6068241208	532 Church St, Minneapolis, MN, 55426	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
CLM-417243	CLM	Joyce Santiago	2000-08-25	—	—	832 Highland Ave, Los Angeles, CA, 90008	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-119779	ENR	Sue H Ortega	1994-06-13	UHC-23079-17	6839264413	2222 Camelback Rd, Scottsdale, AZ, 85260	0.64	Two-digit birth year Street suffix standardised Address re-cased City re-cased+2 more
ENR-109273	ENR	Omar Oliver	2008-10-01	UHC-32622-59	8862881687	7149 Market St, San Diego, CA, 92147	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-101484	ENR	George W Gonzalez	1958-11-04	UHC-26433-79	2434187124	7130 Ridge Rd, Miami, FL, 33130	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-104849	ENR	William Patterson	1967-10-21	UHC-98995-42	5604859942	4238 Church St Apt 35, Los Angeles, CA, 90042	0.64	Name re-cased Two-digit birth year Phone reformatted Unit split from street+2 more
ENR-114692	ENR	Charles H Maldonado	1949-05-15	UHC-76931-42	3857732832	4005 Grand Ave, Minneapolis, MN, 55489	0.64	Two-digit birth year Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-131589	ENR	Mary T Burke	1966-08-04	UHC-56530-83	7907371041	4620 Washington St, Plano, TX, 75066	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-122356	ENR	Willie Ray	1962-02-03	UHC-57120-48	3673968182	4022 Grand Ave, Denver, CO, 80234	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-27231	PRV	Bruce Burke	1979-08-05	UHC-27034-47	—	8889 Canyon Rd, Tucson, AZ, 85730	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
CLM-423409	CLM	Nicole Arnold	1979-05-10	UHC-18919-15	5623336184	3165 Mesa Dr, Chandler, AZ, 85231	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
TPA-59773	TPA	Albert Sanders	1976-05-06	—	—	5471 Camelback Rd, Las Vegas, NV, 89161	0.64	Two-digit birth year Street suffix standardised Address re-cased City re-cased+2 more
PRV-24781	PRV	Ryan Elliott	1962-07-01	—	8323083910	5526 Sunset Blvd, San Antonio, TX, 78260	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-117669	ENR	Megan E Rice	1941-01-01	UHC-35388-29	7018598950	4054 Willow Ct, Los Angeles, CA, 90067	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
ENR-140043	ENR	Nicole W Chne	1949-03-15	UHC-87075-85	9316873774	9865 Forest Ave, Jacksonville, FL, 32246	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
PRV-27916	PRV	Catherine S Johnson	1947-05-23	UHC-09489-58	6359917157	9299 Palm Dr, Seattle, WA, 98170	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
TPA-60711	TPA	Alexis Castro	1991-01-10	—	—	4926 Union St, Glendale, AZ, 85328	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
CLM-411928	CLM	Dorothy W Williamson	1958-10-05	—	6962228594	6047 Lincoln Way, Dallas, TX, 75210	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-124985	ENR	Logan Luna	1942-09-06	UHC-90592-70	8793092186	8848 Cedar Ln, Scottsdale, AZ, 85297	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-107907	ENR	Cheryl Snyder	1988-09-06	UHC-01160-94	9772723844	6293 Palm Dr, Houston, TX, 77097	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
PRV-21032	PRV	Dylan D White	1939-01-15	—	8547426782	7746 Mountain View Dr, Houston, TX, 77050	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-414369	CLM	Charles N Evans	1943-08-02	—	8625377154	1969 Church St, Jacksonville, FL, 32257	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-133700	ENR	Eric Sanders	1959-08-27	UHC-95424-50	9545579690	2321 Grand Ave, Orlando, FL, 32817	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
ENR-131456	ENR	Patricia Q Ross	1949-05-22	UHC-68744-18	7758511395	52 Desert Sky Blvd, Glendale, AZ, 85394	0.64	Name re-cased Two-digit birth year Member ID reformatted Street suffix standardised+2 more
CLM-400036	CLM	Omar Williams	1994-03-17	—	7577838343	6733 Grand Ave, Miami, FL, 33178	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-109917	ENR	Jess Riley	1947-03-12	UHC-00691-96	6322465722	3593 Sunset Blvd, Jacksonville, FL, 32216	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
CLM-428545	CLM	Megan Morgan	1997-09-07	UHC-81877-49	—	9294 Lake View Rd, Tempe, AZ, 85252	0.64	Two-digit birth year Street suffix standardised Address re-cased City re-cased+2 more
CLM-401364	CLM	Donald Johnston	1945-11-27	UHC-99698-01	5666986636	942 Harbor Blvd, Glendale, AZ, 85356	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-122215	ENR	Camila Daniels	1945-06-13	UHC-20797-65	5426017294	2438 Sage Ct, Phoenix, AZ, 85053	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-426488	CLM	Sean Jones	1947-05-03	—	3207778085	8932 Hillcrest Rd, Mesa, AZ, 85286	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-412361	CLM	Bobby Schultz	1958-07-18	—	—	1371 Maple Ave, Seattle, WA, 98198	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
PRV-26508	PRV	Kimberly G Hoffman	1949-03-15	—	—	1843 Mountain View Dr, Houston, TX, 77025	0.64	Two-digit birth year Street suffix standardised Address re-cased Email lower-cased+2 more
PRV-29483	PRV	Luis Jones	1948-05-16	UHC-28777-79	9778047251	2298 Sage Ct, Phoenix, AZ, 85096	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-141165	ENR	Beth N Duncan	1977-10-24	UHC-69532-26	8268116452	328 Hillcrest Rd, Glendale, AZ, 85342	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-142937	ENR	Mateo R King	1955-09-19	UHC-54751-80	7319332566	6607 Mesa Dr, Scottsdale, AZ, 85264	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-26395	PRV	Arjun Hansen	2001-05-27	—	7488549079	4213 Spring St, Minneapolis, MN, 55428	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more

6,661 rows, page 55 of 134Previous Next