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 “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
TPA-51445	TPA	Bruce Schultz	1994-08-09	—	—	7122 Indian School Rd, San Diego, CA, 92113	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-50048	TPA	Wayne Vazquez	1982-02-20	—	4867805798	149 Lincoln Way, San Diego, CA, 92154	0.78	Two-digit birth year Phone reformatted City re-cased Whitespace trimmed+1 more
TPA-59255	TPA	Samuel Bennett	1946-07-10	UHC-99610-72	—	4248 Lincoln Way, Fresno, CA, 93754	0.78	Name re-cased Member ID reformatted City re-cased Gender normalised+1 more
TPA-50771	TPA	Katherine Russell	1954-11-01	—	—	2576 Hillcrest Rd, Houston, TX, 77017	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-60769	TPA	Lawrence Ortiz	1977-03-25	UHC-54477-49	—	3355 Highland Ave, Dallas, TX	0.78	Name re-cased Date of birth reformatted City re-cased ZIP missing+1 more
TPA-51172	TPA	Amber Graham	1969-10-14	—	—	1919 Park Pl, Scottsdale, AZ, 85253	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-61912	TPA	Donald Anderson	1955-05-15	—	—	860 Sage Ct, Scottsdale, AZ, 85291	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-54965	TPA	Maria Singh	1987-02-18	—	4212876631	3060 Lincoln Way, Austin, TX, 78790	0.78	Date of birth reformatted Phone reformatted City re-cased State name converted to code+1 more
TPA-63212	TPA	Michelle Oliver	1978-02-16	UHC-82552-09	—	8192 Indian School Rd, Sacramento, CA, 95899	0.78	Name re-cased City re-cased State name converted to code Whitespace trimmed+1 more
TPA-57691	TPA	Dylan Harvey	1976-03-10	—	—	5090 Ridge Rd, Phoenix, AZ, 85057	0.78	Name re-cased City re-cased ZIP+4 trimmed Whitespace trimmed+1 more
TPA-52956	TPA	Anna Adams	2003-09-24	—	6932030709	504 Ridge Rd, Minneapolis, MN, 55488	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-58368	TPA	Joe Webb	2008-01-15	UHC-44238-24	—	838 Washington St, Minneapolis, MN, 55477	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
TPA-57127	TPA	Christina Rodriguez	1942-05-15	—	—	6388 Cedar Ln, Austin, TX, 78770	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-55415	TPA	Natalie Reid	1974-05-23	—	—	8152 Meadow Ln, Orlando, FL, 32822	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
TPA-60564	TPA	Denise Jackson	1949-03-07	UHC-63308-42	—	3077 Valley View Dr, Tampa, FL	0.78	Name re-cased Date of birth reformatted City re-cased ZIP missing+1 more
TPA-62196	TPA	Nathan Wong	2001-08-11	—	—	7166 Sage Ct, Phoenix, AZ, 85084	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
TPA-57774	TPA	Frank Santos	1972-10-25	—	—	1611 Meadow Ln, Glendale, AZ, 85345	0.78	Name re-cased Date of birth reformatted City re-cased ZIP+4 trimmed+1 more
TPA-55126	TPA	Andrea A Espinoza	1995-10-20	—	—	4990 Church St, Eden Prairie, MN, 55312	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
TPA-55014	TPA	Billy H Alexander	1946-04-05	—	4814817040	1182 Central Ave, Tampa, FL, 33694	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-58197	TPA	Becky Jordan	1941-10-12	—	8646408446	277 Forest Ave, Chandler, AZ, 85278	0.78	Street suffix standardised Address re-cased City re-cased State code upper-cased+1 more
TPA-52799	TPA	Megan Santiago	1948-05-15	UHC-27734-09	8463227078	4521 Ridge Rd, Glendale, AZ, 85384	0.78	Phone reformatted City re-cased Gender normalised Whitespace trimmed+1 more
TPA-57214	TPA	Jaanice Ramos	1999-11-02	—	4708985083	7210 Ocean Ave, Atlanta, GA, 30381	0.78	Phone reformatted City re-cased State name converted to code Whitespace trimmed+1 more
TPA-61694	TPA	Michael Schmidt	2004-10-28	—	—	7258 Harbor Blvd, Dallas, TX, 75268	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
TPA-57569	TPA	Tyler Singh	2002-04-12	—	—	7305 Valley View Dr, Las Vegas, NV, 89124	0.78	Name re-cased City re-cased Email lower-cased Gender normalised+1 more
TPA-62374	TPA	Bruce Price	1966-11-23	—	—	1066 Sunset Blvd, Sacramento, CA, 95844	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-59460	TPA	Anna Greene	1986-02-14	—	9875217391	9359 Lake View Rd, Denver, CO, 80222	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-55450	TPA	Steven Mason	1965-11-06	—	—	6665 Pine Dr Apt 33, Miami, FL, 33184	0.78	Unit split from street City re-cased Plan code upper-cased Whitespace trimmed+1 more
TPA-57653	TPA	Keith G Ford	1947-04-21	—	—	6215 Central Ave, Orlando, FL, 32811	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
TPA-59900	TPA	Willie Myers	1941-07-13	—	—	283 Lake View Rd, Las Vegas, NV, 89189	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
TPA-51015	TPA	Mary Bennett	1943-09-13	—	—	7846 Main St, Scottsdale, AZ, 85214	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
TPA-59824	TPA	Marcus Yang	1959-05-24	—	—	4981 Lake View Rd, Columbus, OH, 43250	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
TPA-51531	TPA	Gary Richardson	1954-08-03	—	—	5154 Mountain View Dr, Eden Prairie, MN, 55336	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-60025	TPA	William O Kelly	2007-10-22	UHC-90416-44	—	1416 Jefferson Ave, Gilbert, AZ, 85216	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
TPA-52460	TPA	Jean Mills	1961-04-07	—	—	6528 Grand Ave, Columbus, OH, 43232	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
TPA-59047	TPA	Benjamin Weaver	1996-08-10	—	9635796913	3047 Willow Ct, Columbus, OH, 43204	0.78	Two-digit birth year Phone reformatted City re-cased Whitespace trimmed+1 more
TPA-61491	TPA	Camila Herrera	1946-01-08	—	—	6176 Park Pl, Glendale, AZ, 85380	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
TPA-60665	TPA	Brandon Guzman	1948-12-09	—	3708970317	3766 Sunset Blvd, Tempe, AZ, 85226	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
TPA-54401	TPA	Shirley George	1976-07-24	—	—	7203 Sunset Blvd, Charlotte, NC, 28231	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
TPA-62166	TPA	Mariana Owens	1998-06-24	—	5198981877	6172 Ocean Ave, Orlando, FL, 32836	0.78	Phone reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-58388	TPA	Hiroshi Espinoza	1997-12-09	—	9258495433	2482 Mesa Dr # 998, Tempe, AZ, 85226	0.78	Date of birth reformatted Phone reformatted Unit split from street City re-cased+1 more
TPA-61221	TPA	Dennis Daniels	1972-02-10	UHC-93018-85	—	3114 Elm St, Houston, TX, 77041	0.78	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+1 more
TPA-62200	TPA	Margaret Ryan	1961-09-12	—	2418857734	3627 Mountain View Dr, Nashville, TN, 37229	0.78	Phone reformatted City re-cased State name converted to code Whitespace trimmed+1 more
TPA-58365	TPA	Barbara Castillo	1940-11-11	—	—	2447 Mesa Dr, Columbus, OH, 43292	0.78	SSN last four extracted City re-cased Email lower-cased Whitespace trimmed+1 more
TPA-55119	TPA	Juan Jordan	2000-07-03	—	—	7107 Jefferson Ave, Plano, TX, 75064	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
TPA-60540	TPA	Roger Harrison	1981-01-09	—	—	778 Harbor Blvd, Glendale, AZ, 85345	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
TPA-54220	TPA	Samantha U Patterson	1973-10-20	—	—	1608 Sage Ct, Scottsdale, AZ, 85290	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more
TPA-58384	TPA	Kevin Wheeler	1946-04-21	—	—	6231 Broadway, Plano, TX, 75022	0.78	Name split from “Last, First”Date of birth reformatted Address re-cased City re-cased+1 more
TPA-60144	TPA	Olivia Cooper	1981-09-05	—	—	683 Bayshore Dr, Minneapolis, MN, 55492	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
TPA-64423	TPA	Kayla Chavez	1991-06-09	—	3655470683	117 Harbor Blvd, Fresno, CA, 93760	0.78	Phone reformatted City re-cased Gender normalised Whitespace trimmed+1 more
TPA-54731	TPA	Marilyn Reyes	1964-03-28	—	—	8962 Elm St, Houston, TX, 77055	0.78	Street suffix standardised Address re-cased City re-cased Whitespace trimmed+1 more

2,455 rows, page 32 of 50Previous Next