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 “Date of birth reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagDate of birth reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-412211	CLM	Olivia Burke	1984-09-26	UHC-83224-48	5498575606	—	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-405837	CLM	Ruth Stephens	1956-11-26	UHC-49733-39	—	—	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-432557	CLM	Mateo G Harvey	1961-06-08	UHC-46235-64	5604272492	4288 Broadway, Orlando, FL, 32876	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-407262	CLM	Aibgail Stone	2008-12-07	UHC-76973-20	—	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-429489	CLM	Peter Patterson	2005-03-14	UHC-20937-46	2505822327	6888 Oak St, Eden Prairie, MN, 55389	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-426581	CLM	Natalie I Reyes	1963-03-17	UHC-20278-68	—	—	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-405646	CLM	Jordan Wallace	1983-07-18	UHC-12381-44	9208615672	3887 Washington St, Austin, TX, 78764	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-404061	CLM	Lauren Wong	1955-10-13	—	—	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-403202	CLM	Joyce L Hunt	1983-08-26	UHC-86921-20	2477112906	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-408685	CLM	Evelyn Ramos	1970-12-02	UHC-77500-44	—	330 Baseline Rd, Orlando, FL, 32832	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-410624	CLM	Keith V Campbell	1962-05-19	UHC-28637-30	—	5441 Meadow Ln, Nashville, TN, 37234	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-407078	CLM	Danille N Pierce	1956-11-16	UHC-91432-68	7716846961	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-430437	CLM	Sara Alvarado	2004-01-03	UHC-48967-87	8239092793	—	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-416554	CLM	Keith Ortiz	1947-05-06	UHC-75701-22	9382690989	9658 Washington St, Tempe, AZ, 85276	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-429548	CLM	Zachary Stevens	1983-11-03	UHC-41271-59	—	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-424388	CLM	Sofia K Montgomery	1943-11-05	—	—	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-425569	CLM	Peter U Cunningham	1949-04-19	—	—	331 Church St, Nashville, TN, 37293	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-413071	CLM	Roy P Munoz	2006-12-15	—	4185228008	6002 Highland Ave, Phoenix, AZ, 85083	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-416617	CLM	Stephanie Bell	1940-04-27	UHC-76947-21	2126217158	3211 Oak St, Tempe, AZ, 85280	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-426201	CLM	Roy Wlson	1988-06-24	—	3968326745	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-421342	CLM	Priya Sancchez	1951-01-28	UHC-79621-92	3048878331	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-412215	CLM	Joan Montgomery	2006-06-07	—	7109015776	2668 Park Pl, Glendale, AZ, 85327	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-413473	CLM	Melissa Palmer	1959-06-18	UHC-34264-24	7266902587	—	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-415317	CLM	Sara K Scott	1958-06-18	UHC-06212-17	8893540383	9443 Broadway, Tempe, AZ, 85270	0.92	Date of birth reformatted Phone reformatted Member ID reformatted Placeholder values cleared
CLM-423529	CLM	Amber Maldonado	2007-04-11	—	4688044047	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-423530	CLM	Amber Maldonado	2007-04-11	—	4688044047	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-402269	CLM	Camila Martinez	1995-03-24	—	6546998141	—	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-418725	CLM	Ann Garrett	1977-01-19	—	4865700176	6583 Oak St, Houston, TX, 77084	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-401138	CLM	Natalie Williams	1960-03-13	UHC-27759-35	4678449886	—	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-422148	CLM	Kieth Jordan	1998-05-23	UHC-51305-30	—	2390 Ridge Rd, Mesa, AZ, 85264	0.92	Date of birth reformatted Member ID reformatted City re-cased Placeholder values cleared
CLM-424358	CLM	Julie Alexander	1996-01-22	—	—	—	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-411390	CLM	David Wheeler	2001-06-07	UHC-39132-78	3569123248	2668 Spring St, Houston, TX, 77017	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-421995	CLM	Paul G Perez	1954-11-15	UHC-31595-01	4728829130	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-407145	CLM	Brenda Mills	1991-04-18	UHC-64046-69	8463146999	8622 Oak St, Glendale, AZ, 85380	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-431500	CLM	Evelyn M Moore	1955-08-25	UHC-06739-36	4022847451	7193 Elm St, Atlanta, GA, 30339	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-423489	CLM	Dorothhy Howard	1963-06-08	UHC-03790-63	4855146828	8082 Willow Ct, Eden Prairie, MN, 55345	0.92	Name re-cased Date of birth reformatted Phone reformatted Whitespace trimmed
CLM-403497	CLM	Jacob Chavez	1959-07-11	UHC-04401-17	3894129678	—	0.92	Date of birth reformatted Member ID reformatted Whitespace trimmed Placeholder values cleared
CLM-401758	CLM	Tim T Hill	2009-11-08	UHC-07622-22	—	7501 Grand Ave, Minneapolis, MN, 55491	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-421044	CLM	Emily R Gonzalez	1984-06-09	UHC-18091-41	8459956614	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-431264	CLM	Thomas Luna	1997-10-20	UHC-95083-87	8886275690	4011 Main St, Orlando, FL, 32803	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-407165	CLM	Beverly Cruz	2004-12-13	UHC-12852-42	—	—	0.92	Name re-cased Date of birth reformatted Member ID reformatted Placeholder values cleared
CLM-408149	CLM	Luis Bod	1954-03-12	UHC-14517-04	7629069773	—	0.92	Name re-cased Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-412057	CLM	Hannah Sims	1985-11-24	—	—	9768 Sunset Blvd, Dallas, TX, 75256	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-419563	CLM	Emma V Ruzi	1990-04-02	—	—	4087 Broadway, Atlanta, GA, 30376	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-424884	CLM	Kelly Carpenter	2005-07-26	UHC-64131-81	—	9304 Mountain View Dr, Orlando, FL, 32878	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-414395	CLM	Vicnent Chen	1963-03-09	—	—	9867 Ridge Rd, Eden Prairie, MN, 55343	0.92	Name re-cased Date of birth reformatted Whitespace trimmed Placeholder values cleared
CLM-432283	CLM	Anna Taylor	1988-07-15	UHC-89479-07	3119953168	—	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-403357	CLM	Rachel Hart	1963-10-16	UHC-02912-42	5385025385	—	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-409763	CLM	Daniel E Flores	1959-12-17	UHC-10911-11	—	4711 Mesa Dr, Mesa, AZ, 85281	0.92	Name re-cased Date of birth reformatted City re-cased Placeholder values cleared
CLM-419404	CLM	Barbara Burton	1969-12-14	UHC-90454-50	4217133568	6083 Sage Ct, Glendale, AZ, 85320	0.92	Date of birth reformatted Phone reformatted Whitespace trimmed Placeholder values cleared

10,559 rows, page 180 of 212Previous Next