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 “Plan code upper-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagPlan code upper-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-421952	CLM	Samuel Fisher	1970-06-03	UHC-59857-84	3586546233	2380 Highland Ave, Seattle, WA, 98111	0.48	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+4 more
ENR-114038	ENR	Valentina Nelson	1985-02-09	UHC-73808-52	4308895410	7819 Baseline Rd Apt 32, Columbus, OH, 43250	0.48	Name split from “Last, First”Phone reformatted Unit split from street Street suffix standardised+4 more
ENR-115085	ENR	Victoria O Cooper	1960-10-11	UHC-00539-49	3323998149	6043 Forest Ave, Charlotte, NC	0.48	Name re-cased SSN last four extracted City re-cased State name converted to code+4 more
ENR-118950	ENR	Jacqueline E Spencer	—	UHC-18603-59	—	1667 Camelback Rd, Tampa, FL, 33622	0.48	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+4 more
ENR-111553	ENR	Larry Murphy	—	UHC-56832-36	6239891647	5457 Harbor Blvd, Tempe, AZ, 85211	0.48	Date of birth unreadable Phone reformatted Member ID reformatted Street suffix standardised+4 more
ENR-136251	ENR	Philip Perkins	1944-08-04	UHC-20874-77	8628068729	6656 Union St # 806, Gilbert, AZ, 85221	0.48	Name re-cased Two-digit birth year Phone reformatted Unit split from street+4 more
ENR-142565	ENR	Alice L Adams	2003-11-05	UHC-37979-98	—	2201 Canyon Rd, Gilbert, AZ, 85214	0.48	Name re-cased Phone missing area code Street suffix standardised Address re-cased+4 more
ENR-115996	ENR	Joshua H Jensen	2002-08-16	UHC-44883-71	8132217562	5857 Cedar Ln, Dallas, TX, 75252	0.48	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+4 more
CLM-410438	CLM	Mertha Chapman	1938-04-06	—	—	1455 Mountain View Dr, Tempe, AZ, 85218	0.48	Name re-cased Street suffix standardised Address re-cased State name converted to code+4 more
ENR-111680	ENR	Berb S Weaver	1958-06-24	UHC-62451-86	5819129100	4612 Cedar Ln, Phoenix, AZ, 85009	0.48	Middle initial moved out of first name SSN last four extracted Street suffix standardised Address re-cased+4 more
PRV-25165	PRV	Maria Baker	1972-02-28	—	6509038382	5242 Hillcrest Rd, Nashville, TN, 37262	0.48	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+4 more
ENR-115903	ENR	Ana W Andrews	1952-07-20	UHC-89158-54	—	2817 Apache Blvd, Denver, CO	0.48	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+4 more
ENR-128085	ENR	Sofia Marin	1954-04-11	UHC-48966-84	9825973219	5715 Sunset Blvd Apt 33, Los Angeles, CA, 90024	0.48	Phone reformatted Unit split from street Street suffix standardised Address re-cased+4 more
ENR-127422	ENR	Scott Hall	2003-02-18	UHC-57013-81	7217117160	2441 Maple Ave # 466, Jacksonville, FL, 32208	0.48	Name re-cased SSN last four extracted Unit split from street Street suffix standardised+4 more
ENR-128570	ENR	Wei Lawrence	1949-01-10	UHC-49718-56	7589640200	4975 Central Ave # 604, Gilbert, AZ, 85201	0.48	Name re-cased Two-digit birth year Phone reformatted Unit split from street+4 more
ENR-110462	ENR	Cynthia I Lucas	1964-12-23	UHC-72108-02	4202361988	64 Indian School Rd, Minneapolis, MN, 55436	0.48	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+4 more
ENR-108023	ENR	Adam Contraras	1973-04-05	UHC-75072-26	2844825112	5706 Indian School Rd, Plano, TX, 75091	0.48	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+4 more
ENR-136215	ENR	Amber N Lee	2004-04-08	UHC-32742-91	5362651559	8105 Desert Sky Blvd, San Diego, CA, 92184	0.48	Phone reformatted Street suffix standardised Address re-cased City re-cased+4 more
CLM-422315	CLM	Lisa Ferguson	1965-10-13	—	5077289719	4972 Cedar Ln, Eden Prairie, MN, 55370	0.48	Name split from “Last, First”Two-digit birth year Street suffix standardised Address re-cased+4 more
ENR-109987	ENR	Mateo L Rivera	1958-11-09	UHC-49017-44	8138082222	3705 Spring St, Atlanta, GA, 30307	0.48	Two-digit birth year Phone reformatted Member ID reformatted Street suffix standardised+4 more
ENR-136912	ENR	Aisha Moreno	1979-05-12	UHC-22386-72	—	8472 Mesa Dr, Phoenix, AZ, 85040	0.48	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+4 more
ENR-112752	ENR	Kelly E Flores	1971-04-25	UHC-51326-64	3232449263	4492 Park Pl, Scottsdale, AZ, 85258	0.48	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
ENR-135749	ENR	Randy T Burton	1938-03-02	UHC-32006-03	3015630417	8838 Market St, Fresno, CA	0.48	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-141950	ENR	Olivia Morales	1966-11-08	UHC-35280-08	9059605359	2325 Forest Ave, San Diego, CA, 92148	0.48	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-411438	CLM	Brenda Tran	1994-10-17	UHC-06212-91	—	9506 Lake View Rd, Tucson, AZ, 85739	0.48	Name re-cased Street suffix standardised Address re-cased City re-cased+4 more
ENR-129855	ENR	Megan K Johnston	1999-09-12	UHC-38617-08	4864921881	6312 Ridge Rd, San Diego, CA	0.48	Street suffix standardised Address re-cased City re-cased State name converted to code+4 more
CLM-402761	CLM	Lidna Oliver	—	UHC-29977-44	2294438693	1038 Sunset Blvd, Eden Prairie, MN, 55375	0.48	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+4 more
TPA-54389	TPA	Fatima Simmons	—	—	—	388 Church St # 621, Columbus, OH, 43239	0.48	Name re-cased Date of birth missing Unit split from street Street suffix standardised+4 more
ENR-121709	ENR	Beverly Mendoza	2008-09-20	UHC-46120-86	4572721300	9052 Desert Sky Blvd, Tampa, FL	0.48	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-428260	CLM	Ryan Walker	1979-07-19	UHC-79552-94	—	9299 Hillcrest Rd, Las Vegas, NV	0.48	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+4 more
CLM-405876	CLM	Deborah Ramos	1996-05-03	UHC-13452-14	6499736227	2747 Baseline Rd, Los Angeles, CA, 90008	0.48	Two-digit birth year Member ID reformatted Street suffix standardised Address re-cased+4 more
ENR-132029	ENR	Angela U Henry	1969-08-26	UHC-34788-41	7765868352	8514 Desert Sky Blvd, San Antonio, TX, 78276	0.48	Middle initial moved out of first name Date of birth reformatted Phone reformatted Street suffix standardised+4 more
ENR-100233	ENR	Marcus Schmidt	2006-12-12	UHC-74913-88	6997328017	1781 Apache Blvd, Dallas, TX, 75246	0.50	Name re-cased Phone reformatted State name converted to code ZIP+4 trimmed+3 more
CLM-422276	CLM	Janet Morgan	1968-04-24	UHC-17766-52	—	2596 Sunset Blvd Apt 39, Chandler, AZ, 85228	0.50	Unit split from street Street suffix standardised Address re-cased Gender normalised+3 more
PRV-24303	PRV	Shirley Adams	1972-07-20	—	9159511274	8927 Ridge Rd # 823, Houston, TX	0.50	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+3 more
ENR-110922	ENR	Shirley Butler	1993-09-06	UHC-47514-26	—	218 Canyon Rd, Phoenix, AZ, 85006	0.50	Name re-cased Two-digit birth year Phone missing area code Member ID reformatted+3 more
CLM-416270	CLM	Emyly Brown	1943-12-10	UHC-53245-33	—	8526 Valley View Dr, Eden Prairie, MN, 55332	0.50	Name re-cased Street suffix standardised Address re-cased State name converted to code+3 more
ENR-125274	ENR	Judy Gutierrez	1944-10-11	UHC-68949-79	7269228240	893 Market St, Houston, TX, 77041	0.50	Name re-cased Street suffix standardised Address re-cased State name converted to code+3 more
ENR-129314	ENR	Paul U Arnold	2008-11-11	UHC-58490-28	3664719205	4396 Jefferson Ave, Miami, FL, 33145	0.50	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+3 more
ENR-103316	ENR	Eric W Wright	1939-06-11	UHC-72315-78	9046175509	5338 Main St Apt 14, Mesa, AZ, 85239	0.50	Unit split from street City re-cased State name converted to code Email lower-cased+3 more
ENR-138619	ENR	Jordan L Carr	1973-07-06	UHC-39558-60	—	205 Spring St, Gilbert, AZ, 85242	0.50	Date of birth reformatted Phone missing area code Street suffix standardised Address re-cased+3 more
ENR-140930	ENR	Elizabeth D Myers	1981-12-18	UHC-25672-92	3663642933	9332 Ridge Rd, Dallas, TX, 75292	0.50	Phone reformatted Street suffix standardised Address re-cased State name converted to code+3 more
ENR-100557	ENR	Joohn Gardner	1947-11-06	UHC-45824-49	7044809229	6299 Desert Sky Blvd Apt 3, Austin, TX, 78722	0.50	Name re-cased Unit split from street Street suffix standardised Address re-cased+3 more
ENR-140248	ENR	Bryan Wallace	—	UHC-43200-36	6908774170	399 Desert Sky Blvd, Nashville, TN, 37226	0.50	Date of birth unreadable Member ID reformatted Street suffix standardised Address re-cased+3 more
ENR-133769	ENR	Diego Snyder	—	UHC-57459-82	3989341877	2917 Washington St, Seattle, WA, 98101	0.50	Date of birth missing Phone reformatted SSN last four extracted Street suffix standardised+3 more
ENR-134290	ENR	Jeremy K Martin	1940-04-16	—	3054013311	2692 Canyon Rd, Los Angeles, CA, 90023	0.50	Street suffix standardised Address re-cased State name converted to code ZIP+4 trimmed+3 more
CLM-403972	CLM	Tyler Wagner	1951-07-18	—	—	8381 Main St, Gilbert, AZ, 85270	0.50	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code+3 more
CLM-410468	CLM	Sean Daniels	1986-05-18	—	—	6525 Sunset Blvd, Los Angeles, CA	0.50	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+3 more
ENR-112879	ENR	Ashley Lopez	1944-08-15	UHC-75234-83	6934061650	1743 Sage Ct Apt 5, Denver, CO, 80272	0.50	Name re-cased Two-digit birth year Phone reformatted Unit split from street+3 more
ENR-118573	ENR	Priyya Moore	1977-07-03	UHC-65655-63	4862887244	8579 Hillcrest Rd, Glendale, AZ, 85364	0.50	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+3 more

3,278 rows, page 5 of 66Previous Next