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

Claims, flag “Two-digit birth year”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagTwo-digit birth yearClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-409225	CLM	Valentina Moore	1979-09-23	UHC-89782-29	—	6292 Meadow Ln, Austin, TX, 78711	0.66	Two-digit birth year Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-416054	CLM	Brenda Harpre	1940-05-15	—	—	7291 Ocean Ave, Mesa, AZ, 85254	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-428845	CLM	Henry Q Harrisno	1986-07-18	UHC-33101-68	—	7019 Washington St, Chandler, AZ, 85234	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
CLM-418563	CLM	Sean Adams	1968-12-24	—	8357626925	6127 Indian School Rd, Los Angeles, CA, 90001	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-420085	CLM	Betty Vega	1946-04-04	—	—	1690 Bayshore Dr, Columbus, OH, 43248	0.66	Name re-cased Two-digit birth year ZIP+4 trimmed Whitespace trimmed+1 more
CLM-411297	CLM	Santiago Gray	1979-02-26	UHC-93351-32	—	4158 Spring St, Dallas, TX, 75241	0.66	Two-digit birth year Member ID reformatted City re-cased Gender normalised+1 more
CLM-424640	CLM	Mary Reed	1955-06-18	UHC-36246-28	—	4582 Mesa Dr, Phoenix, AZ, 85066	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
CLM-406669	CLM	Jean I Bron	1938-02-24	—	—	9596 Lake View Rd, Glendale, AZ, 85354	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-416550	CLM	Daniel Fields	1944-06-14	UHC-38023-03	—	5374 Church St, Fresno, CA, 93777	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-408138	CLM	Joseph Scott	1975-08-21	—	—	7502 Desert Sky Blvd, Austin, TX, 78761	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
CLM-424524	CLM	Roger Nguyen	1992-02-06	—	4567329041	4735 Central Ave, Eden Prairie, MN, 55355	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-403090	CLM	Patricia Miller	1943-02-16	—	—	1760 Pine Dr, Denver, CO, 80257	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
CLM-406233	CLM	Victoria Schmidt	1988-06-12	UHC-00189-24	—	7090 Harbor Blvd, Tempe, AZ, 85278	0.66	Name split from “Last, First”Two-digit birth year State code upper-cased Email lower-cased+1 more
CLM-411537	CLM	Noah H Miller	1962-11-10	UHC-78031-25	—	5151 Pine Dr, Glendale, AZ	0.66	Name re-cased Two-digit birth year ZIP missing Whitespace trimmed+1 more
CLM-405318	CLM	Dannielle Q Jackson	1954-10-11	—	—	—	0.66	Middle initial moved out of first name Name re-cased Two-digit birth year Whitespace trimmed+1 more
CLM-428646	CLM	Madisoon J Johnston	1967-12-21	—	—	5120 Palm Dr, Phoenix, AZ, 85010	0.66	Name re-cased Two-digit birth year Gender normalised Whitespace trimmed+1 more
CLM-432188	CLM	Stephen Gibson	1995-11-22	UHC-07734-29	7075574177	—	0.66	Name split from “Last, First”Two-digit birth year Phone reformatted Whitespace trimmed+1 more
CLM-410901	CLM	Evelyn Garrett	1942-11-19	UHC-93545-01	—	2256 River Rd, Jacksonville, FL, 32270	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
CLM-420677	CLM	Roger Carr	1985-11-04	UHC-61108-95	—	5490 Sunset Blvd, Mesa, AZ, 85209	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-416298	CLM	Stevne Guzman	1960-11-07	UHC-93254-06	—	1507 Central Ave, Houston, TX, 77023	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
CLM-412478	CLM	Dorothy Padilla	2002-12-01	UHC-67215-44	—	412 River Rd, Tucson, AZ, 85751	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-428625	CLM	Douglas Kelly	1995-05-25	UHC-63043-26	9644424332	9857 Washington St, Charlotte, NC, 28231	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-402871	CLM	Wang E Lisa	1986-12-04	—	2178295665	4350 Elm St, San Diego, CA, 92102	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-429222	CLM	Aisha Laron	1949-09-22	UHC-69901-39	—	3250 Broadway, Eden Prairie, MN, 55381	0.66	Name re-cased Two-digit birth year Gender normalised Whitespace trimmed+1 more
CLM-404595	CLM	Amber W Mejia	1953-02-17	—	—	5149 Mesa Dr, Gilbert, AZ, 85265	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
CLM-430946	CLM	Sara Brown	1977-11-21	UHC-51882-45	7182971671	3994 Broadway, Los Angeles, CA, 90068	0.66	Two-digit birth year Phone reformatted State name converted to code Whitespace trimmed+1 more
CLM-410187	CLM	Kyle Dominguez	1954-02-12	—	—	2026 Elm St, Minneapolis, MN, 55438	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-405359	CLM	Keith P Guzman	1998-01-10	UHC-44567-20	6027198695	6289 Main St, Phoenix, AZ, 85062	0.66	Name split from “Last, First”Two-digit birth year Phone reformatted Whitespace trimmed+1 more
CLM-421701	CLM	Albert K Gonzalez	1968-09-15	UHC-36932-95	—	9216 Indian School Rd, Mesa, AZ, 85200	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-428330	CLM	Gary Schultz	1974-05-01	UHC-32024-80	—	2035 Jefferson Ave, Tucson, AZ, 85747	0.66	Name re-cased Two-digit birth year Member ID reformatted Street suffix standardised+1 more
CLM-412859	CLM	Michael Harrison	1963-07-09	UHC-04868-24	—	7551 Lake View Rd, Los Angeles, CA, 90095	0.66	Two-digit birth year Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-417920	CLM	Patrick Meyer	1952-03-22	UHC-05803-05	6454029937	6386 Sage Ct, Dallas, TX, 75260	0.66	Name re-cased Two-digit birth year Phone reformatted Gender normalised+1 more
CLM-405817	CLM	David Lewis	1981-04-09	UHC-05353-85	—	5645 Apache Blvd, Eden Prairie, MN, 55366	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-416498	CLM	Alice Larson	1979-03-07	UHC-47376-36	8753120016	5606 Palm Dr, Austin, TX, 78736	0.66	Name split from “Last, First”Two-digit birth year Phone reformatted Whitespace trimmed+1 more
CLM-425609	CLM	Nicle Evans	1960-04-28	—	4706640162	2462 Maple Ave, Tucson, AZ, 85720	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-425608	CLM	Nicle Evans	1960-04-28	—	4706640162	2462 Maple Ave, Tucson, AZ, 85720	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-412574	CLM	Nunez N Douglas	1959-01-02	UHC-04096-41	8067198149	4598 Spring St Apt 13, Dallas, TX, 75262	0.66	Two-digit birth year Phone reformatted Unit split from street Whitespace trimmed+1 more
CLM-426794	CLM	George Ford	1991-12-01	—	4648132727	8138 Spring St, Scottsdale, AZ, 85280	0.66	Two-digit birth year Phone reformatted City re-cased State name converted to code+1 more
CLM-428593	CLM	Sara Adams	1958-07-08	—	—	7110 Central Ave, Phoenix, AZ, 85060	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
CLM-415296	CLM	Brandon Watson	1999-08-03	UHC-65481-98	—	3953 River Rd, Fresno, CA, 93756	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-417343	CLM	Kimberly Austin	1999-02-22	—	9814286798	1735 Church St, Charlotte, NC, 28268	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
CLM-401464	CLM	Lawrence Tucker	1983-12-11	—	—	1664 Valley View Dr Apt 37, Plano, TX, 75024	0.66	Name re-cased Two-digit birth year Unit split from street Whitespace trimmed+1 more
CLM-431289	CLM	Roy U Ortiz	1995-04-07	UHC-61154-15	7566682215	6507 Bayshore Dr, Austin, TX, 78737	0.66	Two-digit birth year Street suffix standardised Address re-cased Email lower-cased+1 more
CLM-414470	CLM	Cynthia Perkins	1972-09-09	UHC-19178-80	—	6645 Highland Ave, Denver, CO, 80202	0.66	Two-digit birth year Street suffix standardised Address re-cased City re-cased+1 more
CLM-424380	CLM	Nicole Bryant	1973-03-24	UHC-87960-16	4186686351	8509 Valley View Dr, Dallas, TX, 75208	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-401326	CLM	Keith Brooks	1986-03-26	UHC-63341-37	—	5724 Pine Dr, Denver, CO, 80299	0.66	Name split from “Last, First”Two-digit birth year City re-cased Whitespace trimmed+1 more
CLM-418447	CLM	Maria Castillo	1955-10-06	UHC-23443-73	—	3511 Ocean Ave, Seattle, WA, 98161	0.66	Two-digit birth year Phone missing area code City re-cased Whitespace trimmed+1 more
CLM-408698	CLM	Shirley Hunt	1958-09-01	UHC-53979-10	5092460501	1390 Indian School Rd, Fresno, CA, 93789	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-424037	CLM	Jerry Martin	1994-11-16	UHC-95865-44	3293310200	9420 Baseline Rd, Houston, TX, 77025	0.66	Two-digit birth year Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-413963	CLM	Janet Stone	1994-05-27	—	2176928382	5916 Sage Ct, Sacramento, CA, 95888	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more

2,168 rows, page 25 of 44Previous Next