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

Third-party administrator, flag “Member ID reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagMember ID reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-60111	TPA	Rndy Cruz	1939-06-22	UHC-45387-96	8934782097	790 Willow Ct # 472, Scottsdale, AZ, 85256	0.62	Date of birth reformatted Member ID reformatted Unit split from street Street suffix standardised+3 more
TPA-50702	TPA	Cynthia Ryan	1992-07-22	UHC-40295-56	—	4288 Union St, Minneapolis, MN, 55457	0.62	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
TPA-54369	TPA	Nicoole Hayse	1939-04-16	UHC-32516-68	7178720107	695 Apache Blvd, Plano, TX, 75090	0.62	Two-digit birth year Phone reformatted Member ID reformatted Street suffix standardised+3 more
TPA-51678	TPA	Scott Soto	1974-04-19	UHC-72076-66	—	9872 Hillcrest Rd, Plano, TX, 75085	0.62	Name split from “Last, First”Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
TPA-64202	TPA	Gabrriel Z Estrada	1993-02-15	UHC-77015-81	—	2383 Palm Dr, Eden Prairie, MN, 55312	0.62	Name split from “Last, First”Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
TPA-58370	TPA	Lius Murphy	1981-02-20	UHC-01298-90	—	299 Sage Ct, Jacksonville, FL, 32278	0.62	Date of birth reformatted Phone missing area code Member ID reformatted State name converted to code+3 more
TPA-59838	TPA	Jack F Garza	1966-10-12	UHC-71666-67	5512424663	363 Bayshore Dr Apt 18, Las Vegas, NV, 89178	0.62	Date of birth reformatted Phone reformatted Member ID reformatted Unit split from street+3 more
TPA-53831	TPA	Bryan Wheeler	2000-01-22	UHC-07444-96	7307510835	9384 Mountain View Dr, Nashville, TN, 37209	0.62	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+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
TPA-62340	TPA	Jack J Taylor	1971-03-07	UHC-47608-49	5294633874	3243 Main St, Tampa, FL	0.62	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
TPA-63939	TPA	Christian Hnry	1946-10-11	UHC-60838-89	—	1252 Jefferson Ave, Scottsdale, AZ, 85203	0.64	Member ID reformatted Street suffix standardised Address re-cased Gender normalised+2 more
TPA-52479	TPA	Helen Hasen	1959-09-19	UHC-38525-44	6343361127	—	0.64	Name split from “Last, First”Phone reformatted Member ID reformatted Gender normalised+2 more
TPA-51251	TPA	Dylan Ferguson	1993-06-26	UHC-34747-74	—	9126 Maple Ave, Tempe, AZ, 85200	0.64	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
TPA-61932	TPA	Thomas Phillips	1991-03-10	UHC-55322-89	—	175 Apache Blvd, Denver, CO, 80267	0.64	Member ID reformatted Street suffix standardised Address re-cased City re-cased+2 more
TPA-59002	TPA	Shirley B Washington	2008-04-16	UHC-05301-16	—	5417 Valley View Dr, San Diego, CA, 92163	0.64	Name split from “Last, First”Member ID reformatted Street suffix standardised Address re-cased+2 more
TPA-60327	TPA	Thomas Ana	1983-07-19	UHC-79194-93	3284916761	8738 Camelback Rd, Scottsdale, AZ, 85228	0.64	Two-digit birth year Phone reformatted Member ID reformatted Street suffix standardised+2 more
TPA-54414	TPA	Henry Shaaw	—	UHC-75336-68	3648379296	6601 Indian School Rd, Tucson, AZ, 85703	0.64	Date of birth unreadable Phone reformatted Member ID reformatted Street suffix standardised+2 more
TPA-54413	TPA	Henry Shaaw	—	UHC-75336-68	3648379296	6601 Indian School Rd, Tucson, AZ, 85703	0.64	Date of birth unreadable Phone reformatted Member ID reformatted Street suffix standardised+2 more
TPA-60941	TPA	Ethan Wlch	1941-06-23	UHC-61196-41	—	9226 Lake View Rd # 443, Minneapolis, MN, 55409	0.64	Member ID reformatted Unit split from street Street suffix standardised Address re-cased+2 more
TPA-59440	TPA	Gloria Stewart	—	UHC-97704-17	4772561517	7869 Indian School Rd, Jacksonville, FL, 32200	0.64	Date of birth unreadable Phone reformatted Member ID reformatted ZIP+4 trimmed+2 more
TPA-59261	TPA	Ana Hamilton	2001-04-27	UHC-11133-36	2183834671	176 Baseline Rd, Las Vegas, NV, 89121	0.64	Two-digit birth year Member ID reformatted Street suffix standardised Address re-cased+2 more
TPA-52096	TPA	Alice G Perry	1943-04-24	UHC-53984-35	2096714901	9138 Harbor Blvd, Denver, CO, 80219	0.64	Name split from “Last, First”Phone reformatted Member ID reformatted Street suffix standardised+2 more
TPA-50094	TPA	Sarah Sanders	—	UHC-10031-33	—	9257 Willow Ct, Phoenix, AZ, 85097	0.64	Name re-cased Date of birth unreadable Member ID reformatted Street suffix standardised+2 more
TPA-50360	TPA	Billy Medina	1989-09-14	UHC-16597-76	—	810 Washington St, Sacramento, CA, 95868	0.64	Phone missing area code Member ID reformatted Street suffix standardised Address re-cased+2 more
TPA-54754	TPA	Amy Martin	1950-07-24	UHC-11699-14	2844651645	5564 Apache Blvd # 266, Mesa, AZ, 85212	0.64	Name re-cased Member ID reformatted Unit split from street State name converted to code+2 more
TPA-55305	TPA	Margaret Harris	1971-03-16	UHC-77132-48	—	471 River Rd, Nashville, TN, 37288	0.64	Two-digit birth year Member ID reformatted Street suffix standardised Address re-cased+2 more
TPA-54844	TPA	Luri Cruz	—	UHC-43223-03	—	3912 Main St, Austin, TX	0.64	Name re-cased Date of birth unreadable Member ID reformatted City re-cased+2 more
TPA-53886	TPA	Beth Soto	1942-07-20	UHC-24398-25	—	4815 Valley View Dr, Tampa, FL, 33658	0.64	Two-digit birth year Member ID reformatted Street suffix standardised Address re-cased+2 more
TPA-52061	TPA	Carol Henderson	1948-10-16	UHC-17723-27	—	2661 Cedar Ln Apt 1, Los Angeles, CA, 90044	0.64	Member ID reformatted Unit split from street Street suffix standardised Address re-cased+2 more
TPA-59289	TPA	Heather Riso	1943-01-24	UHC-25713-90	—	—	0.66	Name split from “Last, First”Date of birth reformatted Member ID reformatted Gender normalised+1 more
TPA-63844	TPA	Elizabeth Matthews	1994-08-26	UHC-83163-59	—	8220 Bayshore Dr, Orlando, FL, 32855	0.66	Member ID reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
TPA-61804	TPA	Janice Duncan	2003-08-22	UHC-43398-21	—	1469 Central Ave, Los Angeles, CA, 90099	0.66	Member ID reformatted Street suffix standardised Address re-cased State name converted to code+1 more
TPA-63893	TPA	Isabella Sims	1954-11-28	UHC-25234-77	2386406617	6026 Baseline Rd, Dallas, TX, 75260	0.66	Member ID reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
TPA-60349	TPA	Alan Simmons	1995-04-25	UHC-07767-31	—	4788 Indian School Rd, Gilbert, AZ, 85260	0.66	Member ID reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
TPA-51546	TPA	Teresa Wilson	1977-09-18	UHC-45385-63	—	456 Canyon Rd, Tucson, AZ, 85775	0.68	Name split from “Last, First”Member ID reformatted State name converted to code Placeholder values cleared
TPA-57724	TPA	Joyce Snyder	1961-01-07	UHC-38342-05	—	7991 Meadow Ln, Glendale, AZ, 85350	0.68	Member ID reformatted Street suffix standardised Address re-cased State name converted to code
TPA-53312	TPA	Bruce Sanchez	1966-12-13	UHC-67947-39	—	9891 Highland Ave # 771, Tempe, AZ, 85216	0.68	Member ID reformatted Unit split from street Gender normalised Placeholder values cleared
TPA-56520	TPA	Nancy Espinoza	2008-09-01	UHC-65433-82	7777289344	3498 Apache Blvd, Phoenix, AZ, 85038	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
TPA-52513	TPA	Ruth Hanson	1985-06-06	UHC-73022-03	8265345553	3317 Church St, Tempe, AZ, 85236	0.72	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+4 more
TPA-59216	TPA	Danielle Ellis	1941-03-12	UHC-67285-47	—	7010 Grand Ave, Denver, CO, 80233	0.72	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+4 more
TPA-56609	TPA	Victoria Maldonado	1966-01-02	UHC-88689-50	7917734873	9385 Sage Ct, Atlanta, GA, 30348	0.72	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+4 more
TPA-62906	TPA	Reed Mateo	1987-07-21	UHC-56867-30	3566885085	543 Forest Ave, Orlando, FL, 32804	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
TPA-62905	TPA	Reed Mateo	1987-07-21	UHC-56867-30	3566885085	543 Forest Ave, Orlando, FL, 32804	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
TPA-61841	TPA	Ryan Henry	1997-02-08	UHC-30848-72	—	5813 Grand Ave, Dallas, TX, 75225	0.74	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
TPA-53498	TPA	Kathryn Sims	1958-10-08	UHC-18011-85	4456834980	8523 Sage Ct, Charlotte, NC, 28271	0.74	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+3 more
TPA-56453	TPA	Grace Sandoval	1994-07-17	UHC-09986-75	—	3704 Canyon Rd, Glendale, AZ, 85331	0.74	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+3 more
TPA-59464	TPA	Christopher I Jackson	1959-04-13	UHC-69793-47	—	4347 Meadow Ln, Austin, TX, 78768	0.74	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+3 more
TPA-53462	TPA	Bobby L Dxion	1958-01-25	UHC-60044-90	6504333180	2777 Washington St, Dallas, TX, 75278	0.74	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
TPA-57679	TPA	Jesse V Herrera	1960-04-12	UHC-67077-73	—	2224 Union St, Seattle, WA, 98197	0.74	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+3 more
TPA-52729	TPA	Patricia Diaz	1988-12-12	UHC-24304-39	2249143798	1160 Washington St, Minneapolis, MN, 55427	0.74	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+3 more

245 rows, page 2 of 5Previous Next