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
CLM-416381	CLM	Joshua Gibson	1945-05-01	UHC-44042-29	9446388631	5857 Oak St, Nashville, TN	0.48	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-126606	ENR	Beverly I Baker	1997-08-08	UHC-69779-08	—	5700 Maple Ave # 597, Atlanta, GA	0.48	Name re-cased Date of birth reformatted Unit split from street City re-cased+4 more
ENR-129395	ENR	Amanda Brooks	1966-05-17	UHC-53265-89	3354943327	497 Canyon Rd, Nashville, TN	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
TPA-52179	TPA	Charles Lane	1953-12-13	—	8327244393	2643 Washington St, Seattle, WA	0.48	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
CLM-408489	CLM	Madison X Patel	2000-01-10	—	8457345964	4495 Union St, Glendale, AZ	0.48	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+4 more
ENR-142111	ENR	William U Wells	1996-06-27	UHC-43805-72	9375878321	4905 Lake View Rd Apt 24, Phoenix, AZ	0.48	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+4 more
TPA-53153	TPA	Pamela Lucas	1963-10-05	UHC-08267-93	—	6958 Highland Ave Apt 37, San Antonio, TX	0.48	Date of birth reformatted Member ID reformatted Unit split from street Street suffix standardised+4 more
ENR-133012	ENR	Scott R Griffin	1945-02-21	UHC-41956-45	—	7211 Main St, Tempe, AZ	0.48	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+4 more
ENR-114854	ENR	Megan Brown	1999-05-07	UHC-23638-95	7673777536	6811 Grand Ave, Tempe, AZ	0.48	Phone reformatted Member ID reformatted SSN last four extracted Street suffix standardised+4 more
CLM-402206	CLM	Julie Hansen	1973-09-25	UHC-11629-44	—	667 Oak St, Eden Prairie, MN	0.48	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+4 more
CLM-407766	CLM	Kimberly Robinson	2008-05-16	UHC-32138-49	8852559584	1348 Mountain View Dr, Minneapolis, MN	0.48	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+4 more
TPA-60479	TPA	Andrea Guzman	1992-05-15	—	—	4778 Sage Ct # 158, Tucson, AZ	0.48	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+4 more
ENR-120111	ENR	Keith J Scott	1999-07-09	UHC-99761-49	9847610668	9133 Canyon Rd, San Antonio, TX	0.48	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-124811	ENR	Donna C Kelley	1998-05-24	UHC-99118-77	7537095343	719 Highland Ave Apt 28, Fresno, CA	0.48	Name re-cased Phone reformatted Unit split from street Street suffix standardised+4 more
ENR-103580	ENR	Ashley Morrison	1978-09-28	UHC-52293-35	4759023644	3220 River Rd Apt 19, Columbus, OH	0.48	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+4 more
ENR-118189	ENR	Kathryn X Sims	1967-11-06	UHC-39197-67	9753018836	9716 River Rd Apt 17, Minneapolis, MN	0.48	Name re-cased Phone reformatted Unit split from street Street suffix standardised+4 more
PRV-23720	PRV	Justin Lawrence	1945-06-12	UHC-56970-09	—	1593 Spring St, Miami, FL	0.48	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+4 more
CLM-424766	CLM	Camila Washington	—	UHC-17485-33	—	456 Market St, Las Vegas, NV	0.48	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+4 more
TPA-50284	TPA	Sarah Howell	1966-05-27	—	2373550725	320 Main St, Austin, TX	0.48	Date of birth reformatted Phone reformatted City re-cased State name converted to code+4 more
CLM-429014	CLM	Charlotte Perry	1983-12-12	UHC-56932-15	—	6577 Spring St, Scottsdale, AZ	0.48	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+4 more
ENR-136634	ENR	Isabella Robertson	1988-01-02	UHC-25638-63	3447784951	4127 Lake View Rd # 279, San Diego, CA	0.48	Name re-cased Phone reformatted Unit split from street ZIP missing+4 more
ENR-125851	ENR	Nicole D Carlson	1941-10-20	UHC-64211-07	3498869262	8802 Pine Dr, Tampa, FL	0.48	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+4 more
ENR-113895	ENR	Randy Daniels	1944-06-11	UHC-90910-84	3882163376	4653 Highland Ave, Austin, TX	0.48	Name re-cased Two-digit birth year Phone reformatted City re-cased+4 more
CLM-409486	CLM	Margaret Stone	1979-11-12	—	5038517790	5524 Pine Dr, Plano, TX	0.48	Name re-cased SSN last four extracted Street suffix standardised Address re-cased+4 more
TPA-53582	TPA	Kathryn Cook	1991-07-01	—	3009147958	2631 Park Pl Apt 22, Plano, TX	0.48	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+4 more
TPA-50478	TPA	Hiroshi Hernandez	1961-11-21	—	—	1528 Central Ave, Chandler, AZ	0.48	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+4 more
PRV-20566	PRV	Katherine Montgomery	1996-08-07	UHC-26954-37	9325545090	6855 Sunset Blvd, Tempe, AZ	0.48	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+4 more
TPA-55871	TPA	Paul Patel	1942-11-22	—	6717233707	8622 Bayshore Dr, Tucson, AZ	0.48	Phone reformatted Street suffix standardised Address re-cased City re-cased+4 more
ENR-116613	ENR	Omar Bakr	1982-12-17	UHC-82232-61	7946955898	5030 Desert Sky Blvd, Orlando, FL	0.48	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+4 more
TPA-55033	TPA	Jennifer Le	1970-11-26	—	—	5766 Park Pl, Orlando, FL	0.48	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+4 more
ENR-111234	ENR	Tyler Thomas	1948-08-01	UHC-19916-14	7237238977	6416 Pine Dr, San Antonio, TX	0.48	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-116126	ENR	Ralph Bowman	1941-08-25	UHC-50182-69	5895560311	8891 Camelback Rd, Dallas, TX	0.48	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
TPA-63621	TPA	Ethan Gilbert	1974-06-16	—	4593999877	5664 Washington St, Houston, TX	0.48	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
TPA-60385	TPA	Aaron Rojas	1938-03-27	—	—	7749 Mesa Dr, Gilbert, AZ	0.48	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+4 more
ENR-139588	ENR	Catherine Riley	1999-11-09	UHC-20404-24	5239039881	7227 Canyon Rd, Mesa, AZ	0.48	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+4 more
TPA-62413	TPA	William Hughes	1978-01-02	—	8224563791	9230 Canyon Rd, Minneapolis, MN	0.48	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+4 more
ENR-124461	ENR	Debra Y Ortega	1998-11-09	UHC-53202-94	2993726462	3452 Meadow Ln, Orlando, FL	0.48	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+4 more
PRV-21243	PRV	Marilyn Wyllis	1997-06-15	UHC-30752-12	8272927043	8924 Grand Ave, Atlanta, GA	0.48	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-106646	ENR	Diana O Harrison	1966-08-06	UHC-09874-03	4013185529	7744 Central Ave, Gilbert, AZ	0.48	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-126954	ENR	Dot Hall	—	UHC-15763-54	8307841334	6357 Highland Ave, Las Vegas, NV	0.48	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+4 more
ENR-103739	ENR	Elizabeth Mendez	1941-01-06	UHC-68235-58	8786261987	6053 Church St, Tampa, FL	0.48	Name re-cased Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-107203	ENR	Emily R Lopez	1943-12-14	UHC-00216-34	6468353919	6843 Camelback Rd Apt 4, Chandler, AZ	0.48	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+4 more
ENR-138872	ENR	Richard Carpenter	1973-01-14	UHC-63811-16	7212280784	1751 Elm St, Fresno, CA	0.48	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+4 more
PRV-27837	PRV	Ralph Kelley	1975-09-22	UHC-28952-82	8395879904	1320 Pine Dr, Tempe, AZ	0.48	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+4 more
TPA-52083	TPA	Helen Cruz	1988-11-02	—	2427366336	756 Central Ave, Orlando, FL	0.48	Name split from “Last, First”Street suffix standardised Address re-cased City re-cased+4 more
CLM-404879	CLM	Gary P Burton	1988-01-22	UHC-41264-81	—	4869 Church St, Gilbert, AZ	0.48	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+4 more
ENR-122741	ENR	Jerry E Contreras	1983-12-09	UHC-90619-60	9344280533	1086 Lincoln Way, Houston, TX	0.48	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+4 more
PRV-25996	PRV	Melissa I Gibson	1965-07-09	—	2982110885	9252 Mesa Dr, Mesa, AZ	0.48	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+4 more
CLM-408820	CLM	Zachary Hudson	1945-08-22	—	2367128579	4326 Palm Dr, Houston, TX	0.48	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more
ENR-129487	ENR	Judy Z Foster	2002-03-24	UHC-43426-86	3396578993	638 Harbor Blvd, Minneapolis, MN	0.48	Phone reformatted Street suffix standardised Address re-cased ZIP missing+4 more

7,146 rows, page 17 of 143Previous Next