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+4 trimmed”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP+4 trimmedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-124236	ENR	James Q Torres	1979-05-03	UHC-15723-81	6245721999	1992 Central Ave, Nashville, TN, 37225	0.64	Date of birth reformatted Phone reformatted ZIP+4 trimmed Gender normalised+2 more
ENR-136263	ENR	Aisha Burns	1974-10-07	UHC-01658-44	2809277236	4453 Forest Ave, Dallas, TX, 75244	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-107704	ENR	Bryan Z Mason	1955-02-28	UHC-53878-41	4834843548	7192 Sunset Blvd, Gilbert, AZ, 85289	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-102548	ENR	Bobby C Cooper	1940-02-01	UHC-01816-03	—	9529 Hillcrest Rd, Gilbert, AZ, 85286	0.64	Name re-cased Phone missing area code Member ID reformatted City re-cased+2 more
PRV-28296	PRV	Grace F Duncan	1999-06-14	UHC-41719-75	5905251892	6527 Harbor Blvd, Orlando, FL, 32879	0.64	Street suffix standardised Address re-cased City re-cased ZIP+4 trimmed+2 more
ENR-114921	ENR	Ann Matthews	1993-09-25	UHC-82258-75	8169260599	4310 Lake View Rd, Chandler, AZ, 85224	0.64	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-119339	ENR	Nicholas Ellis	1982-03-16	UHC-59410-03	—	7082 Willow Ct, Mesa, AZ, 85298	0.64	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
CLM-420866	CLM	Steephen Harrison	1955-03-22	UHC-14162-85	3752847338	9547 Indian School Rd, San Antonio, TX, 78226	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-111032	ENR	Sean Owens	1984-01-05	UHC-64788-47	6417043423	5632 Baseline Rd, San Diego, CA, 92137	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-127919	ENR	Amber C Palmer	1958-05-09	UHC-28566-35	5904203006	5064 Church St, Austin, TX, 78748	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
TPA-63956	TPA	Mary Hudson	1995-01-14	—	—	9385 Mesa Dr, San Diego, CA, 92171	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
TPA-62757	TPA	Donna Russell	1981-09-22	—	—	8815 Sunset Blvd, Seattle, WA, 98122	0.64	Name re-cased ZIP+4 trimmed Email lower-cased Gender normalised+2 more
CLM-404209	CLM	Katherine D Robinson	1975-05-01	UHC-61326-69	—	7828 Church St, Plano, TX, 75087	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-124835	ENR	Matthew U Nunez	1969-05-13	UHC-82540-20	4632897483	7656 Washington St, Houston, TX, 77030	0.64	Name re-cased Phone reformatted State name converted to code ZIP+4 trimmed+2 more
ENR-140056	ENR	Ronald L Guzman	2008-01-21	UHC-49979-38	3499943771	3336 Church St # 892, Tampa, FL, 33693	0.64	Phone reformatted Unit split from street ZIP+4 trimmed Plan code upper-cased+2 more
ENR-126966	ENR	Alan N Powell	1986-10-20	UHC-61794-36	7382050511	4543 Harbor Blvd, San Antonio, TX, 78203	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
TPA-57295	TPA	Zachary Baker	1988-07-16	—	—	6101 Desert Sky Blvd, Orlando, FL, 32814	0.64	Name re-cased Date of birth reformatted ZIP+4 trimmed Gender normalised+2 more
PRV-23586	PRV	Jeffrey K Simmons	1979-02-02	UHC-58774-62	3167035601	5421 Bayshore Dr, Chandler, AZ, 85295	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-109907	ENR	Jack Y Hernandez	1955-12-04	UHC-68349-56	7783483734	916 Indian School Rd, Columbus, OH, 43228	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-23984	PRV	Elizabeth Z Martinez	1998-12-22	—	9147412783	2780 Desert Sky Blvd, Atlanta, GA, 30343	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
TPA-50440	TPA	Christian Coleman	1973-07-06	—	2937157676	6836 Bayshore Dr, Tucson, AZ, 85715	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
PRV-28111	PRV	Grace Wong	2000-12-03	UHC-13056-47	7356676010	3571 Spring St, Sacramento, CA, 95834	0.64	Street suffix standardised Address re-cased City re-cased State code upper-cased+2 more
TPA-64090	TPA	Alexis Reed	1955-03-05	—	2516881975	5473 Canyon Rd, Minneapolis, MN, 55426	0.64	Date of birth reformatted Phone reformatted ZIP+4 trimmed Gender normalised+2 more
CLM-413310	CLM	Maria P Dean	2007-10-07	—	—	6450 Lincoln Way, Tempe, AZ, 85296	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-132057	ENR	Debra N Schmidt	1965-08-17	UHC-05894-70	—	900 Church St, Houston, TX, 77017	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-140097	ENR	Lauran X Ryan	—	UHC-80172-58	9672371450	4827 Hillcrest Rd, Mesa, AZ, 85239	0.64	Name re-cased Date of birth reformatted Date of birth unreadable Phone reformatted+2 more
CLM-427515	CLM	Catherine Chen	1914-03-06	UHC-58328-78	—	3233 Sunset Blvd, Plano, TX, 75041	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
CLM-402396	CLM	Brittany S Watkins	1940-07-23	UHC-36211-47	5227907510	642 Sage Ct, Chandler, AZ, 85280	0.64	Phone reformatted Member ID reformatted ZIP+4 trimmed Gender normalised+2 more
ENR-128415	ENR	Arjun L Hansen	2001-05-27	UHC-08942-86	7488549079	4213 Spring St, Minneapolis, MN, 55428	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
CLM-421759	CLM	Isabella Kennedy	1951-08-10	—	4052366527	2989 Ridge Rd, Chandler, AZ, 85217	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
TPA-52723	TPA	Maria Li	1995-03-11	—	7096851383	3122 Bayshore Dr, Eden Prairie, MN, 55339	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
PRV-26692	PRV	David P Jenkins	2003-05-05	UHC-89133-69	3335485373	4240 Jefferson Ave, Minneapolis, MN, 55496	0.64	Middle initial moved out of first name Date of birth reformatted Phone reformatted ZIP+4 trimmed+2 more
ENR-112825	ENR	Bryant O Donald	1938-05-08	UHC-55875-41	—	7574 Bayshore Dr, Jacksonville, FL, 32220	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-114340	ENR	Mariana T McDonald	1963-02-15	UHC-89548-26	3913192929	6528 Sunset Blvd Apt 24, Minneapolis, MN, 55459	0.64	Phone reformatted Unit split from street City re-cased ZIP+4 trimmed+2 more
ENR-126499	ENR	Gregory Hamilton	1969-12-02	UHC-54999-02	6265361954	4040 Ridge Rd, Nashville, TN, 37267	0.64	Name re-cased Two-digit birth year Member ID reformatted City re-cased+2 more
ENR-104549	ENR	Marilyn Z Weaver	1971-07-02	UHC-95376-47	3803692073	7242 Maple Ave, Tucson, AZ, 85719	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
TPA-50219	TPA	Jacob G Goez	1951-07-05	—	5034133742	3679 Union St, Sacramento, CA, 95811	0.64	Name re-cased Phone reformatted ZIP+4 trimmed Gender normalised+2 more
ENR-121938	ENR	Logan V Wilson	1998-01-09	UHC-97610-18	8814440387	6748 Mountain View Dr, Sacramento, CA, 95828	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-413144	CLM	Christina V Carter	1943-10-03	UHC-20494-29	—	6427 Pine Dr, Scottsdale, AZ, 85266	0.64	Name split from “Last, First”Date of birth reformatted City re-cased ZIP+4 trimmed+2 more
CLM-416549	CLM	Henry K Wlker	1949-05-17	UHC-07090-42	7967168117	9002 Oak St, Sacramento, CA, 95823	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
CLM-416878	CLM	Jake Little	1974-07-12	UHC-14867-13	—	2649 Indian School Rd, Houston, TX, 77023	0.64	Street suffix standardised Address re-cased City re-cased ZIP+4 trimmed+2 more
TPA-55820	TPA	Weyne Y Murray	—	—	4357999217	4458 Lincoln Way, Las Vegas, NV, 89181	0.64	Name re-cased Date of birth unreadable Phone reformatted ZIP+4 trimmed+2 more
ENR-135678	ENR	Carl M Duncan	2002-05-21	UHC-50959-59	4009045955	6668 Main St, Seattle, WA, 98184	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
CLM-425451	CLM	Ray Grant	1957-06-21	—	5254095899	9859 Elm St, Miami, FL, 33170	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-107730	ENR	Theresa Ray	1969-11-13	UHC-50362-61	9468395360	5206 Ridge Rd, Fresno, CA, 93720	0.64	Member ID reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-134021	ENR	Timothy W Lee	1977-03-21	UHC-55038-67	9606702460	2155 Central Ave, Chandler, AZ, 85273	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-406966	CLM	Laura Burke	1972-11-18	—	—	5085 Market St, Seattle, WA, 98185	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
CLM-431001	CLM	Judy D Oliver	1939-04-05	UHC-16714-15	6075564845	9763 Harbor Blvd, Plano, TX, 75089	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-100170	ENR	Nancy C Smith	1938-01-07	UHC-23880-95	6566631779	4037 Hillcrest Rd, San Diego, CA, 92118	0.64	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
PRV-26647	PRV	Nicole Q Thomas	1999-04-10	—	9309184924	5300 Maple Ave, Mesa, AZ, 85212	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more

8,263 rows, page 81 of 166Previous Next