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 “ZIP missing”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP missingClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-20983	PRV	Barbara Webb	1981-06-13	—	7494320532	6837 Pine Dr, Tucson, AZ	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
ENR-107522	ENR	Kimberly Y Andrews	1985-05-15	UHC-51086-25	—	4231 Harbor Blvd, San Antonio, TX	0.80	State code upper-cased ZIP missing Whitespace trimmed Placeholder values cleared
PRV-24500	PRV	Betty Brooks	2002-03-14	—	—	8012 Baseline Rd, Denver, CO	0.80	Name re-cased City re-cased ZIP missing Placeholder values cleared
CLM-405546	CLM	Katehrine Ramos	1980-03-28	—	2018711929	6388 Union St, Tempe, AZ	0.80	Name re-cased Date of birth reformatted ZIP missing Placeholder values cleared
ENR-111603	ENR	Susan V Torres	1948-07-23	UHC-43424-68	4319310485	7638 Spring St, San Diego, CA	0.80	Date of birth reformatted Member ID reformatted City re-cased ZIP missing
ENR-106574	ENR	Charles Lane	1953-12-13	UHC-26831-50	—	2643 Washington St, Seattle, WA	0.80	City re-cased ZIP missing Email lower-cased Placeholder values cleared
CLM-420678	CLM	Mary Nunez	1967-06-23	UHC-30029-90	—	326 Willow Ct, Houston, TX	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
CLM-432051	CLM	Timothy Delgado	2007-01-02	—	—	5979 Broadway, Nashville, TN	0.80	Address re-cased ZIP missing Whitespace trimmed Placeholder values cleared
PRV-25004	PRV	Adam Jimenez	1978-02-17	—	—	263 Lincoln Way, Orlando, FL	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
CLM-425971	CLM	Natalie Johnston	1950-06-26	UHC-96613-08	5144223794	8028 Camelback Rd, Denver, CO	0.80	Date of birth reformatted Phone reformatted ZIP missing Placeholder values cleared
CLM-422868	CLM	Eugene Anderson	1963-08-20	UHC-70469-53	—	7952 Union St, Chandler, AZ	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
PRV-27747	PRV	Dorothy Smiht	2003-10-07	UHC-01581-36	—	624 Central Ave, Gilbert, AZ	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-131813	ENR	Willie M Rodriguez	1977-10-06	UHC-98614-26	8967325628	79 Market St, Plano, TX	0.80	Member ID reformatted City re-cased ZIP missing Whitespace trimmed
ENR-123736	ENR	Susan L Murphy	1969-07-25	UHC-30065-10	3835492958	6103 Meadow Ln, Eden Prairie, MN	0.80	Name re-cased City re-cased ZIP missing Whitespace trimmed
PRV-20332	PRV	Gloria Q Stone	1954-03-28	UHC-49958-85	—	7547 Broadway, Seattle, WA	0.80	Date of birth reformatted Address re-cased ZIP missing Placeholder values cleared
ENR-142731	ENR	Betty U Wang	1985-06-11	UHC-31162-20	2119771209	8453 Washington St, Minneapolis, MN	0.80	Phone reformatted Member ID reformatted ZIP missing Whitespace trimmed
CLM-402013	CLM	Natalie H Morgan	1939-06-07	UHC-30565-43	—	902 Broadway, Tucson, AZ	0.80	Name re-cased Date of birth reformatted Member ID reformatted ZIP missing
CLM-418914	CLM	Joe Sullivan	1976-08-10	UHC-21823-12	—	6632 Baseline Rd, Miami, FL	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-115633	ENR	Eugene Freeman	1940-02-19	UHC-45352-36	8984501490	8536 Oak St, Austin, TX	0.80	Date of birth reformatted Phone reformatted ZIP missing Whitespace trimmed
CLM-427110	CLM	Isabella Barnes	1995-09-02	—	2236578131	5646 Elm St, Fresno, CA	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
ENR-103071	ENR	Beth W Jimenez	1945-05-25	UHC-65211-83	4728965656	8362 Hillcrest Rd, Columbus, OH	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-100167	ENR	Bobby Silva	1966-06-25	UHC-38822-20	5197957190	2830 Main St, Glendale, AZ	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
TPA-54218	TPA	Lawrence Banks	1978-09-08	—	5354229068	8422 Jefferson Ave, Columbus, OH	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-136080	ENR	Valentina J Sanders	1978-10-26	UHC-31727-34	5092234847	8277 Indian School Rd, Scottsdale, AZ	0.80	Date of birth reformatted Phone reformatted ZIP missing Placeholder values cleared
CLM-409690	CLM	Kelly Flores	1971-04-25	—	—	4492 Park Pl, Scottsdale, AZ	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
TPA-52375	TPA	Randy Hill	1982-10-03	—	3512855122	234 Canyon Rd, Fresno, CA	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-121195	ENR	Bruce Stevens	2003-02-23	UHC-19250-74	8658387604	4915 Broadway, Tucson, AZ	0.80	Phone reformatted Member ID reformatted ZIP missing Placeholder values cleared
PRV-22877	PRV	Christina Stone	1992-04-11	UHC-37469-45	3259577841	100 Lake View Rd, Columbus, OH	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
TPA-62468	TPA	Jesse Y Baker	1985-01-05	—	3199329132	6412 Lincoln Way, Houston, TX	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-138320	ENR	Amber Rodriguez	1971-04-02	UHC-59530-84	2028869631	3020 Church St, Tampa, FL	0.80	Date of birth reformatted Phone reformatted ZIP missing Placeholder values cleared
CLM-425417	CLM	Samantha Palmer	2008-02-16	—	—	523 Lake View Rd, Los Angeles, CA	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-109271	ENR	Emma L Harrison	1966-03-10	UHC-63140-98	8904115652	344 Grand Ave, Tampa, FL	0.80	Name re-cased Date of birth reformatted Phone reformatted ZIP missing
ENR-133273	ENR	Donna Hicks	1952-04-13	UHC-61983-32	2439311212	2177 Highland Ave, Tempe, AZ	0.80	Name re-cased Phone reformatted City re-cased ZIP missing
ENR-133729	ENR	Sraah Medina	1971-12-14	UHC-08978-41	8102627525	6277 Elm St, Gilbert, AZ	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
ENR-142172	ENR	Christopher Hawkins	1939-10-19	UHC-20509-49	2455172144	3342 Harbor Blvd, Sacramento, CA	0.80	Date of birth reformatted Phone reformatted City re-cased ZIP missing
TPA-52118	TPA	Caarolyn Lane	1965-12-27	—	—	9646 Mesa Dr, Sacramento, CA	0.80	Name re-cased Date of birth reformatted ZIP missing Placeholder values cleared
CLM-415804	CLM	Mary Miller	1975-10-10	—	6649080750	3851 Cedar Ln, Houston, TX	0.80	Date of birth reformatted Phone reformatted ZIP missing Placeholder values cleared
ENR-129891	ENR	Randy Perry	1952-04-09	UHC-46301-79	5014890272	9687 Lincoln Way, Tucson, AZ	0.80	Name re-cased Phone reformatted ZIP missing Whitespace trimmed
TPA-62766	TPA	Daniel Ward	1941-04-15	—	—	2104 Palm Dr, Denver, CO	0.80	Date of birth reformatted City re-cased ZIP missing Placeholder values cleared
TPA-54542	TPA	Ana Robinson	1955-02-02	—	4879860691	3989 Indian School Rd, San Diego, CA	0.80	Phone reformatted City re-cased ZIP missing Placeholder values cleared
CLM-407795	CLM	Zachary Aguilar	1944-03-27	—	3964151017	6999 Palm Dr, Jacksonville, FL	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
CLM-431981	CLM	Priya Thmpson	1989-08-09	UHC-68026-77	—	7541 Palm Dr, Tempe, AZ	0.80	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared
ENR-140002	ENR	Kathryn D Welch	1940-12-08	UHC-25311-18	9099340100	5983 Indian School Rd, Denver, CO	0.80	Phone reformatted State code upper-cased ZIP missing Whitespace trimmed
ENR-117283	ENR	Samuel Q Lynch	1981-12-12	UHC-18157-27	7306344799	689 Market St, Plano, TX	0.80	Date of birth reformatted Phone reformatted ZIP missing Whitespace trimmed
CLM-411765	CLM	Jeffrey Vazquez	2007-06-12	—	5369495497	2458 Lincoln Way, Houston, TX	0.80	Name re-cased Date of birth reformatted ZIP missing Placeholder values cleared
ENR-122351	ENR	Diane R Maldonado	1965-07-17	UHC-17511-15	6149673335	3768 Cedar Ln, Gilbert, AZ	0.80	Name re-cased Date of birth reformatted ZIP missing Email lower-cased
ENR-140446	ENR	Reecca J Jacobs	1971-06-11	UHC-14819-53	9242309194	6100 Spring St, Glendale, AZ	0.80	Date of birth reformatted Phone reformatted City re-cased ZIP missing
ENR-117452	ENR	Diana W Perry	1986-06-07	UHC-40741-22	8472709172	4891 Valley View Dr, Plano, TX	0.80	Name re-cased Date of birth reformatted Phone reformatted ZIP missing
CLM-414592	CLM	Kevin George	1941-01-17	—	—	1143 Jefferson Ave, Houston, TX	0.80	Name re-cased Date of birth reformatted ZIP missing Placeholder values cleared
ENR-117410	ENR	Joan Hamilton	2005-09-16	UHC-96999-97	3224209838	9063 Central Ave, Columbus, OH	0.80	Name re-cased Phone reformatted ZIP missing Email lower-cased

7,146 rows, page 127 of 143Previous Next