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 “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
TPA-53841	TPA	Willie Rivera	1960-07-07	—	—	9797 Lake View Rd, Los Angeles, CA, 90018	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-60670	TPA	Jacqueline Bennett	1965-08-13	—	9808476254	—	0.82	Phone reformatted Gender normalised Placeholder values cleared
TPA-57019	TPA	Eugene Hlal	1955-04-03	—	—	8430 Palm Dr, Orlando, FL, 32868	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-56241	TPA	Jessica J Barnes	1985-08-04	—	—	—	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-60416	TPA	Scott Smith	1976-11-03	UHC-03157-35	6786618333	—	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-54655	TPA	Logan Peters	2005-10-27	—	3756373343	6343 Bayshore Dr, Tampa, FL, 33605	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-55907	TPA	Abigail Walker	1944-08-21	—	—	9062 Ridge Rd, Sacramento, CA, 95815	0.82	City re-cased Gender normalised Placeholder values cleared
TPA-56333	TPA	Kayla Knight	1945-02-22	—	—	3353 Highland Ave, Mesa, AZ, 85246	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-60948	TPA	Christopher Contreras	1951-12-19	—	—	—	0.82	Date of birth reformatted Gender normalised Placeholder values cleared
TPA-57556	TPA	Cynthia Carpenter	1962-10-22	UHC-16958-67	—	3013 River Rd, Los Angeles, CA, 90060	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-56408	TPA	Michael Young	1954-12-19	—	6003447974	2952 Palm Dr, Mesa, AZ, 85236	0.82	Phone reformatted Gender normalised Placeholder values cleared
TPA-64420	TPA	Amy Graham	2004-10-25	—	—	—	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-56857	TPA	Charles Matthews	1952-05-12	—	—	8323 Market St, Los Angeles, CA, 90080	0.82	Date of birth reformatted Gender normalised Placeholder values cleared
TPA-54226	TPA	Logan Lewis	1969-06-02	UHC-66714-96	5757926798	5160 Church St, Dallas, TX, 75205	0.82	Phone reformatted Gender normalised Whitespace trimmed
TPA-57670	TPA	Megan Hoffman	1961-11-17	—	—	7890 Maple Ave, Denver, CO, 80229	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-57029	TPA	Judith Mills	1943-05-28	—	—	7674 Pine Dr, Denver, CO, 80205	0.82	City re-cased Gender normalised Placeholder values cleared
TPA-64203	TPA	Kelly Gutierrez	1990-10-16	—	—	6693 Maple Ave, Las Vegas, NV, 89123	0.82	Date of birth reformatted Gender normalised Placeholder values cleared
TPA-50062	TPA	Jen H Cole	1962-10-12	—	—	—	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-55610	TPA	Debra Fields	1973-06-12	—	—	1358 Pine Dr, Phoenix, AZ, 85093	0.82	City re-cased Gender normalised Placeholder values cleared
TPA-50266	TPA	Daniel U Cox	1941-11-23	—	—	7426 River Rd, Dallas, TX, 75215	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-50391	TPA	Albert Henderson	2008-10-03	—	7557969806	—	0.82	Phone reformatted Gender normalised Placeholder values cleared
TPA-57813	TPA	Denise Watkins	1947-11-14	—	—	7757 Apache Blvd, Fresno, CA, 93758	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-60527	TPA	Evelyn Contreras	1977-01-11	—	8072724415	8517 Sunset Blvd, Jacksonville, FL, 32240	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-60870	TPA	Bradley Russell	1976-02-07	—	—	3277 Bayshore Dr, Sacramento, CA, 95833	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-59303	TPA	Dorothy Riley	1986-06-13	—	—	—	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-61926	TPA	Sarah Carroll	1969-05-06	—	—	—	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-57473	TPA	Diane Rogers	2003-10-08	UHC-26032-76	—	—	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-60231	TPA	Michelle Mendez	1967-12-20	—	—	1553 Hillcrest Rd, Sacramento, CA, 95820	0.82	Date of birth reformatted Gender normalised Placeholder values cleared
TPA-61115	TPA	Karen Owens	2002-09-07	—	—	4662 Harbor Blvd, Minneapolis, MN, 55481	0.82	City re-cased Gender normalised Placeholder values cleared
TPA-56345	TPA	Sara Harper	1994-03-15	—	—	—	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-57948	TPA	Lisa Lee	1970-07-14	—	5949070880	589 Elm St, Nashville, TN, 37227	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-56126	TPA	Hiroshi Green	1992-07-05	—	—	—	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-50575	TPA	Andrew Fields	1995-03-23	UHC-34165-43	—	—	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-62575	TPA	Megan Edwards	2006-06-04	—	—	—	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-63021	TPA	Brenda Nelson	1990-11-03	—	5139646923	2173 Indian School Rd, Tampa, FL, 33643	0.82	Phone reformatted Gender normalised Placeholder values cleared
TPA-53597	TPA	Alan E Harrison	1954-01-20	—	—	3847 Grand Ave, Nashville, TN, 37253	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-52926	TPA	Isabella Flores	2000-06-04	—	—	3163 Forest Ave, Plano, TX, 75000	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-52991	TPA	Pat Hart	1974-05-14	—	—	—	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-50154	TPA	Grace Burton	1981-01-26	—	—	8064 Maple Ave, Columbus, OH, 43279	0.82	Date of birth reformatted Gender normalised Placeholder values cleared
TPA-55001	TPA	Elizabeth Ray	1992-01-25	—	—	7416 Oak St, Las Vegas, NV, 89186	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-60186	TPA	Kelly Lucas	1947-12-15	UHC-15635-05	—	—	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-60185	TPA	Kelly Lucas	1947-12-15	UHC-15635-05	—	—	0.82	Name re-cased Gender normalised Placeholder values cleared
TPA-52384	TPA	Mari Ramireez	1999-04-23	UHC-45453-34	—	1102 Market St, Los Angeles, CA, 90037	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-62879	TPA	Mei Griffin	1994-03-17	—	—	9170 Union St, Tucson, AZ, 85775	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-54206	TPA	James Aguilar	1996-05-17	—	—	6531 Meadow Ln, Glendale, AZ, 85395	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-63889	TPA	Nathan Shaw	2003-08-10	—	—	9411 Willow Ct, Miami, FL, 33164	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-56723	TPA	Danielle Sims	1961-10-28	—	—	3165 Willow Ct, Tampa, FL, 33607	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-61704	TPA	Ahmed Hoffman	1978-02-08	—	—	7858 Spring St, Gilbert, AZ, 85296	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-56173	TPA	Philip Gonzalez	1948-06-04	—	—	—	0.82	Gender normalised Whitespace trimmed Placeholder values cleared
TPA-55212	TPA	Juan Singh	1968-07-02	—	—	—	0.82	Date of birth reformatted Gender normalised Placeholder values cleared

2,435 rows, page 47 of 49Previous Next