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

Enrollment, flag “Email lower-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagEmail lower-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-121354	ENR	Kyle Z Rogers	1941-02-15	UHC-43750-48	5772038067	628 Pine Dr, Seattle, WA	0.66	Street suffix standardised Address re-cased ZIP missing Email lower-cased+1 more
ENR-100023	ENR	Noah Y Estrada	1992-02-10	UHC-20005-72	5425061837	6313 Desert Sky Blvd, Eden Prairie, MN, 55315	0.66	Member ID reformatted Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-137152	ENR	Maarcus G Jenkins	1968-02-28	UHC-53827-50	7907852675	8251 Sunset Blvd, San Antonio, TX, 78266	0.66	Phone reformatted Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-112477	ENR	Sarah K Nunez	1972-09-21	UHC-98659-08	3636441853	3578 Apache Blvd, Eden Prairie, MN, 55370	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-112323	ENR	Mei Little	1998-09-16	UHC-10522-71	—	2961 Hillcrest Rd, Fresno, CA	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
ENR-136253	ENR	Russell E Young	1950-05-14	UHC-33983-89	3169084127	6989 Mountain View Dr, Tempe, AZ, 85272	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-101067	ENR	Lori Q Warren	1976-12-09	UHC-11712-58	3949103879	4758 Highland Ave Apt 7, Los Angeles, CA, 90065	0.66	Name re-cased Unit split from street Street suffix standardised Address re-cased+1 more
ENR-134160	ENR	Natalie Obrien	1969-07-27	UHC-10176-82	5435550647	5256 Apache Blvd, Plano, TX, 75024	0.66	Name re-cased Phone reformatted ZIP+4 trimmed Email lower-cased+1 more
ENR-112359	ENR	Abigail Holmes	—	UHC-14169-27	4083596951	6461 Main St, Denver, CO, 80200	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-126863	ENR	Geroge Scott	1985-11-20	UHC-33392-01	2944928389	5838 Sunset Blvd, Dallas, TX, 75229	0.66	Member ID reformatted ZIP+4 trimmed Email lower-cased Gender normalised+1 more
ENR-111268	ENR	Alice Thomas	1982-12-07	UHC-39620-83	6143389310	1048 Sunset Blvd, Charlotte, NC, 28299	0.66	Phone reformatted Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-116042	ENR	Mratha S Powell	1943-12-23	UHC-78239-03	9737120551	2961 Grand Ave, San Diego, CA, 92165	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-112691	ENR	Debra W Campbell	1941-04-21	UHC-20616-86	—	2817 Ridge Rd, Las Vegas, NV, 89175	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-142098	ENR	Paul D Gutierrez	1949-04-03	UHC-27165-57	—	1811 Mountain View Dr, Chandler, AZ	0.66	Street suffix standardised Address re-cased ZIP missing Email lower-cased+1 more
ENR-133793	ENR	Dorothy Wang	1974-07-20	UHC-82624-24	—	4129 Bayshore Dr, Columbus, OH, 43268	0.66	Date of birth reformatted Phone missing area code Street suffix standardised Address re-cased+1 more
ENR-119556	ENR	Nicole Banks	1949-11-11	UHC-40533-39	3984418821	2501 Apache Blvd, Tampa, FL	0.66	Phone reformatted State name converted to code ZIP missing Email lower-cased+1 more
ENR-118193	ENR	Eugene Gilbert	1990-03-02	UHC-96168-79	—	1104 Harbor Blvd, Miami, FL, 33136	0.66	Street suffix standardised Address re-cased Email lower-cased Gender normalised+1 more
ENR-120759	ENR	George F Salazar	1959-01-03	UHC-05285-32	7794058397	1928 Palm Dr Apt 9, San Antonio, TX, 78272	0.66	Phone reformatted Unit split from street Street suffix standardised Address re-cased+1 more
ENR-125957	ENR	Jordan B Weber	2008-09-04	UHC-02916-99	9639480532	8867 Grand Ave, Denver, CO, 80299	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
ENR-114926	ENR	Emily E Warren	2003-05-23	—	8107369388	5528 Pine Dr, Charlotte, NC, 28236	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-116313	ENR	Eric Jones	1944-01-24	UHC-34203-06	9265419559	5772 Valley View Dr, Sacramento, CA, 95852	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-112316	ENR	Pamela Dominguez	1957-08-13	UHC-15089-82	3599504426	6080 Valley View Dr, Plano, TX, 75024	0.66	Name re-cased Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-116450	ENR	Kimberly L Santiago	1984-11-27	UHC-16774-11	—	3655 Mountain View Dr, Denver, CO, 80211	0.66	Name re-cased Phone missing area code Street suffix standardised Address re-cased+1 more
ENR-127910	ENR	Lawrence N Johnston	1976-02-23	UHC-37929-30	7027196836	4994 Desert Sky Blvd, Tempe, AZ	0.66	Two-digit birth year Phone reformatted City re-cased ZIP missing+1 more
ENR-141624	ENR	Donald Willis	2004-02-13	UHC-08578-09	8689676514	3463 Lincoln Way, Tucson, AZ, 85714	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-101782	ENR	Andrea Russell	—	UHC-80771-28	3922041435	9061 Ocean Ave, Houston, TX, 77080	0.66	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-106346	ENR	John V Diaz	1973-02-15	UHC-09680-90	2097273612	1634 Willow Ct, Sacramento, CA, 95877	0.66	Name re-cased State name converted to code Email lower-cased Gender normalised+1 more
ENR-129438	ENR	Joshua R Brown	1941-01-13	UHC-44263-86	8452489238	5027 Mountain View Dr Apt 10, Tempe, AZ, 85246	0.66	Phone reformatted Unit split from street Street suffix standardised Address re-cased+1 more
ENR-139915	ENR	Christina N Evans	1944-12-04	UHC-35274-45	8647692006	6102 Camelback Rd, Jacksonville, FL, 32212	0.66	Street suffix standardised Address re-cased Email lower-cased Gender normalised+1 more
ENR-125206	ENR	Doris D Munoz	1997-04-16	UHC-02192-57	6333091902	7162 Pine Dr, Phoenix, AZ, 85059	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Email lower-cased+1 more
ENR-137446	ENR	John O Marshall	2000-04-14	UHC-46195-40	3772559193	2707 Grand Ave, Las Vegas, NV, 89170	0.66	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+1 more
ENR-112098	ENR	Denise Z Mrris	1992-06-21	UHC-14417-94	2076765350	5438 Mesa Dr, Sacramento, CA, 95818	0.66	Phone reformatted Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-100583	ENR	Russell U Rojas	1997-01-15	UHC-60967-93	8589423947	3909 Spring St, Sacramento, CA, 95899	0.66	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+1 more
ENR-116220	ENR	Amber S Adams	1973-09-14	UHC-14192-29	5052656345	4862 Ocean Ave # 731, Eden Prairie, MN, 55347	0.66	Phone reformatted Unit split from street Street suffix standardised Address re-cased+1 more
ENR-134557	ENR	Abigail Carr	2000-10-15	UHC-85206-38	—	2810 Baseline Rd, Orlando, FL, 32805	0.66	Street suffix standardised Address re-cased ZIP+4 trimmed Email lower-cased+1 more
ENR-134898	ENR	Victoria D Richards	—	UHC-93067-18	8257123118	2180 Central Ave, Plano, TX, 75048	0.66	Name re-cased Date of birth missing Phone reformatted ZIP+4 trimmed+1 more
ENR-128956	ENR	Frances G Hicks	1963-04-27	UHC-99257-33	8352650587	2571 Desert Sky Blvd, Chandler, AZ, 85225	0.66	Phone reformatted State name converted to code ZIP+4 trimmed Email lower-cased+1 more
ENR-117407	ENR	Susan Wong	1939-04-05	UHC-47628-83	4805225549	730 Desert Sky Blvd, Sacramento, CA	0.66	Name re-cased Two-digit birth year Phone reformatted ZIP missing+1 more
ENR-110947	ENR	Benjamin X Jensen	—	UHC-32488-62	4846740821	8817 Forest Ave, Glendale, AZ, 85328	0.66	Date of birth unreadable Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-108947	ENR	Carol Ross	1954-12-21	UHC-83134-19	8712557331	1098 Desert Sky Blvd, Tampa, FL, 33623	0.66	Name split from “Last, First”Phone reformatted State code upper-cased Email lower-cased+1 more
ENR-142534	ENR	Stephen Valdez	1975-03-18	UHC-30831-40	7747303736	3115 Park Pl, Denver, CO, 80251	0.66	Name split from “Last, First”Member ID reformatted Street suffix standardised Address re-cased+1 more
ENR-105042	ENR	Keith B Jordan	1963-03-15	UHC-94244-68	4197367580	7093 Apache Blvd, Nashville, TN, 37267	0.66	Name split from “Last, First”Date of birth reformatted Phone reformatted ZIP+4 trimmed+1 more
ENR-100079	ENR	Christian X Ruiz	1940-09-26	UHC-95544-56	7716475423	1131 Union St Apt 3, Columbus, OH, 43273	0.66	Phone reformatted Unit split from street Street suffix standardised Address re-cased+1 more
ENR-105218	ENR	Justin Knight	1998-02-03	UHC-81943-51	7134918314	2710 Cedar Ln, Charlotte, NC, 28272	0.66	Name split from “Last, First”Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-125430	ENR	Brittany D Fuller	1964-06-05	UHC-60596-72	3943958941	7598 Grand Ave # 554, Orlando, FL, 32817	0.66	Name re-cased Unit split from street Email lower-cased Gender normalised+1 more
ENR-132283	ENR	Dylan F Praker	1988-11-15	UHC-07807-62	—	539 Harbor Blvd, San Diego, CA, 92160	0.66	State name converted to code Email lower-cased Gender normalised Whitespace trimmed+1 more
ENR-102717	ENR	Emily D Kennedy	1991-01-01	UHC-34634-77	—	5058 Central Ave, Tucson, AZ, 85746	0.66	Date of birth reformatted Street suffix standardised Address re-cased Email lower-cased+1 more
ENR-104912	ENR	Heather T Walsh	1942-10-11	UHC-45163-98	—	6927 Oak St, Eden Prairie, MN	0.66	Name re-cased Date of birth reformatted State name converted to code ZIP missing+1 more
ENR-113832	ENR	Janet S Wood	1942-01-24	UHC-90445-01	4788274782	230 Ocean Ave # 800, Phoenix, AZ, 85070	0.66	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+1 more
ENR-103587	ENR	Wei Carlson	1949-12-04	UHC-58954-87	6729008203	3604 Hillcrest Rd, Glendale, AZ, 85302	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+1 more

8,934 rows, page 69 of 179Previous Next