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 “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
CLM-428115	CLM	Priya Lopez	1947-04-09	UHC-53383-79	—	6000 Harbor Blvd, Chandler, AZ, 85296	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-424370	CLM	Peter F Alvarez	1972-06-19	—	—	1142 Church St Apt 34, Tempe, AZ, 85263	0.68	Unit split from street Gender normalised Whitespace trimmed Placeholder values cleared
CLM-418211	CLM	Cynthia Rogers	1951-07-01	UHC-45664-99	2566525435	6059 Broadway, Charlotte, NC, 28223	0.68	ZIP+4 trimmed Gender normalised Whitespace trimmed Placeholder values cleared
CLM-428577	CLM	Harold Sandoval	2006-12-28	UHC-13759-35	—	3094 Mountain View Dr Apt 8, Jacksonville, FL, 32288	0.68	Name re-cased Unit split from street Gender normalised Placeholder values cleared
CLM-425873	CLM	Judy Rogers	1984-01-17	—	—	1643 Bayshore Dr, Plano, TX, 75048	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-417225	CLM	Sean Nguyen	2004-05-04	UHC-10988-10	—	3327 Mesa Dr, Miami, FL, 33166	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-413016	CLM	Gabriel Dominguez	1961-06-01	UHC-64727-36	2566251482	3778 Spring St # 849, Scottsdale, AZ, 85282	0.68	Unit split from street City re-cased Gender normalised Placeholder values cleared
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
CLM-401175	CLM	Emma Vasquez	1986-08-05	—	—	1098 Market St, Dallas, TX, 75249	0.68	Name split from “Last, First”Gender normalised Whitespace trimmed 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
TPA-53183	TPA	Bruce Vega	1989-04-11	—	9093221346	3482 Maple Ave, Denver, CO, 80277	0.68	Name re-cased Two-digit birth year Gender normalised Placeholder values cleared
CLM-404502	CLM	Kathy Sandoval	1962-05-14	UHC-84252-16	—	5904 Central Ave, Tempe, AZ, 85242	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
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
TPA-55388	TPA	Jennifer Le	1952-03-04	—	—	—	0.68	SSN last four extracted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-421381	CLM	Bekky Murray	2002-09-21	—	5055545687	6746 Lake View Rd, San Antonio, TX, 78273	0.68	Name re-cased Street suffix standardised Address re-cased Gender normalised
TPA-60047	TPA	Ruth K Aguilar	1995-07-04	—	6329985888	7008 Cedar Ln, Mesa, AZ, 85207	0.68	Street suffix standardised Address re-cased 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
CLM-416811	CLM	Anthony Jackson	1996-11-11	UHC-47435-53	—	7175 Mesa Dr, Dallas, TX, 75263	0.68	Phone missing area code Gender normalised Whitespace trimmed Placeholder values cleared
TPA-50763	TPA	Julia Hudson	1973-04-10	—	5103754706	—	0.68	Two-digit birth year Phone reformatted Gender normalised Placeholder values cleared
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
CLM-429296	CLM	Adam Murray	1965-11-04	UHC-44804-05	7455147526	474 Pine Dr, Columbus, OH, 43242	0.68	Name split from “Last, First”Phone reformatted Gender normalised Placeholder values cleared
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
CLM-405710	CLM	Zachary D Thompson	1973-11-22	UHC-15871-31	—	1881 Ridge Rd, Scottsdale, AZ, 85213	0.68	Name re-cased Two-digit birth year 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
PRV-24970	PRV	Janice Medina	1981-01-11	—	6104517207	8146 Lincoln Way, Tucson, AZ, 85736	0.68	Phone reformatted ZIP+4 trimmed Gender normalised Placeholder values cleared
PRV-28183	PRV	Kye L Weber	1987-08-09	UHC-48005-03	9683645938	9279 Forest Ave, San Diego, CA	0.68	City re-cased ZIP missing Gender normalised Placeholder values cleared
CLM-417838	CLM	Autsin Henry	2004-05-03	UHC-64407-01	—	—	0.68	Name split from “Last, First”Gender normalised Whitespace trimmed Placeholder values cleared
PRV-21331	PRV	Christopher Mendez	1967-07-10	UHC-51704-12	7709234423	2371 Union St, Gilbert, AZ, 85281	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
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
CLM-427727	CLM	Alexander Q Smth	1958-09-25	UHC-06478-92	5583827401	—	0.68	Two-digit birth year Phone reformatted Gender normalised Placeholder values cleared
TPA-62087	TPA	Laura Simpson	1948-01-26	—	—	7788 Sunset Blvd, Chandler, AZ, 85271	0.68	Name re-cased State name converted to code Gender normalised Placeholder values cleared
TPA-57928	TPA	Judy Hart	2006-05-28	UHC-11656-07	—	2376 Meadow Ln, Scottsdale, AZ, 85263	0.68	City re-cased ZIP+4 trimmed Gender normalised Placeholder values cleared
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
TPA-61737	TPA	Arjun Wright	1982-09-07	—	—	8140 Washington St, Charlotte, NC, 28227	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-403406	CLM	Mariana Webb	1960-07-07	—	9562358950	9040 Canyon Rd, Houston, TX, 77026	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
CLM-405171	CLM	Janice Robertson	2007-08-28	UHC-69570-52	—	8290 Broadway, Charlotte, NC, 28224	0.68	Name split from “Last, First”Gender normalised Whitespace trimmed Placeholder values cleared
CLM-425755	CLM	Douglas Q Murphy	1972-01-12	UHC-39901-92	—	1082 Pine Dr, Orlando, FL, 32896	0.68	State name converted to code Gender normalised Whitespace trimmed Placeholder values cleared
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
TPA-61064	TPA	Martha Y Dixno	2007-02-09	—	—	—	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
PRV-26793	PRV	Jefffrey Payne	1966-11-15	—	—	—	0.68	Two-digit birth year Gender normalised Whitespace trimmed Placeholder values cleared
CLM-416789	CLM	Fatima Bryant	2001-06-19	UHC-81628-53	—	4766 Main St, Minneapolis, MN	0.68	ZIP missing Gender normalised Whitespace trimmed Placeholder values cleared

16,828 rows, page 231 of 337Previous Next