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-404331	CLM	Randy Tucker	1982-03-15	UHC-72020-56	2363621547	9264 Mesa Dr, Orlando, FL, 32840	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-418329	CLM	Hannah Willis	1973-05-27	UHC-29058-11	9126050434	9616 Harbor Blvd, Phoenix, AZ, 85023	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
CLM-430518	CLM	Lori Garza	1957-07-24	UHC-77444-75	—	6528 River Rd, Los Angeles, CA, 90017	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-413007	CLM	Camila E Weaver	1976-10-02	—	5518171644	1120 Spring St, Tempe, AZ, 85298	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-415124	CLM	Omar Richardson	1973-05-16	UHC-04522-73	—	903 Broadway, Tampa, FL, 33633	0.76	Name re-cased Date of birth reformatted ZIP+4 trimmed Email lower-cased+2 more
CLM-425519	CLM	Eric Warren	1998-06-01	UHC-46478-91	2809585707	9407 Cedar Ln, Tampa, FL, 33631	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-430712	CLM	Brittany Banks	1948-07-03	UHC-86957-86	—	493 Camelback Rd, Orlando, FL, 32858	0.76	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+2 more
CLM-418399	CLM	Christian Singh	1982-01-01	—	3588723278	3214 Washington St, Austin, TX, 78763	0.76	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
CLM-429405	CLM	Edward Edwards	1964-11-24	—	—	1315 Apache Blvd, Charlotte, NC, 28241	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-414557	CLM	Ashley Alvarado	1992-05-17	UHC-25866-63	5858307848	—	0.76	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+2 more
CLM-431784	CLM	McHelle Le	1978-11-05	—	—	6244 Apache Blvd, Austin, TX, 78746	0.76	Name re-cased Date of birth reformatted Phone missing area code City re-cased+2 more
CLM-403266	CLM	Kenneth Cooper	1999-04-06	UHC-97521-32	4474774516	6394 Baseline Rd, Mesa, AZ, 85234	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
CLM-407141	CLM	Meteo Kelly	1947-07-10	—	—	9270 Elm St, San Diego, CA, 92165	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-405070	CLM	Alan Aguilar	1941-11-05	UHC-72077-72	5943606724	7777 Hillcrest Rd, Miami, FL, 33170	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-403795	CLM	Brittany Vargas	2002-05-22	UHC-94718-15	2644601163	2068 Union St, Plano, TX, 75088	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
CLM-427507	CLM	Brucce Q Peterson	1945-11-18	UHC-86369-01	—	6573 Harbor Blvd, Gilbert, AZ, 85294	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-413583	CLM	Jacqueline Padilla	1984-07-25	—	6917465292	8450 Cedar Ln, Fresno, CA, 93782	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
CLM-413824	CLM	Nathan Barnes	1986-05-06	—	4248245509	7470 Desert Sky Blvd, Minneapolis, MN, 55434	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
CLM-408826	CLM	Juan Ellis	1996-07-02	—	—	3402 River Rd, Eden Prairie, MN, 55362	0.76	Name re-cased Date of birth reformatted City re-cased Gender normalised+2 more
CLM-427275	CLM	Maria Stewart	2006-12-26	UHC-45508-52	—	9251 Pine Dr, Eden Prairie, MN, 55398	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-427639	CLM	Logan Brooks	1952-04-19	UHC-63454-26	2603003266	3578 Forest Ave, Eden Prairie, MN, 55389	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-415654	CLM	Christine O Valdez	1942-10-24	UHC-97505-59	4996053513	220 Pine Dr, Seattle, WA, 98107	0.76	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
CLM-411040	CLM	Martha Gomez	1944-05-11	UHC-87887-56	—	6080 Cedar Ln, Plano, TX, 75035	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-404156	CLM	Wayne Luna	1962-06-10	UHC-07761-24	5749302894	9398 Willow Ct, Chandler, AZ, 85235	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-431640	CLM	Sofia Scott	1969-07-19	UHC-21371-17	—	6149 Cedar Ln, Eden Prairie, MN, 55365	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-407834	CLM	Roger X Stephens	1991-01-11	UHC-94066-98	—	8151 Indian School Rd, Jacksonville, FL, 32282	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-405588	CLM	Omar Rchardson	1941-06-13	—	7725403106	8804 Baseline Rd, Chandler, AZ, 85250	0.76	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+2 more
CLM-420198	CLM	Heather Freeman	1961-09-08	UHC-82586-58	—	2537 Grand Ave, Orlando, FL, 32846	0.76	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
CLM-409602	CLM	Ryan Evans	1974-02-07	UHC-88185-60	—	1580 Sunset Blvd, San Diego, CA, 92191	0.76	Date of birth reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
CLM-429798	CLM	Sandra Hart	1957-12-16	—	9508397903	9810 Jefferson Ave, San Diego, CA, 92119	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-415902	CLM	Elijah Montgomery	1956-12-07	UHC-48585-51	7243062712	6026 Sage Ct, Denver, CO, 80230	0.76	Name re-cased Date of birth reformatted Phone reformatted Gender normalised+2 more
CLM-408251	CLM	Alan White	1942-05-22	UHC-81845-87	3539097086	353 Pine Dr, Houston, TX, 77089	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
CLM-427058	CLM	Jesse Wright	1964-05-28	UHC-52441-48	—	8687 Central Ave, Scottsdale, AZ, 85277	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-426239	CLM	David Day	1970-01-08	—	—	7470 Park Pl, Denver, CO, 80292	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-412553	CLM	Wayne Roas	1965-02-06	—	—	5328 Pine Dr, Fresno, CA, 93773	0.76	Date of birth reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
CLM-424477	CLM	Diana Turner	1970-11-06	UHC-55479-79	7939690217	3212 Lake View Rd, Gilbert, AZ, 85235	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
CLM-430234	CLM	Tony K Mrtinez	1940-08-19	UHC-87903-13	2506779810	9406 Ocean Ave, Miami, FL, 33166	0.76	Date of birth reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
CLM-411064	CLM	Sandra Y Morgn	1939-05-20	UHC-28897-69	5673191559	1706 Palm Dr, Denver, CO, 80287	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-421640	CLM	Janet W Myers	1974-03-13	—	—	2841 Sage Ct, Gilbert, AZ, 85247	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-407769	CLM	Santiago Q Olson	1948-08-18	UHC-28731-61	6347264569	9184 Camelback Rd, Austin, TX, 78736	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
CLM-402900	CLM	Elizabeth Mendez	1942-01-06	—	—	9808 Apache Blvd, Las Vegas, NV, 89144	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-418210	CLM	Diana Lopez	1990-12-20	UHC-00021-65	—	7282 Sunset Blvd, Tempe, AZ, 85203	0.76	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
CLM-425076	CLM	Elijah Williams	1959-10-23	UHC-93427-23	5933260049	6333 Harbor Blvd, Seattle, WA, 98178	0.76	Name split from “Last, First”Date of birth reformatted Phone reformatted Email lower-cased+2 more
CLM-429357	CLM	Janet Weaver	1995-02-05	UHC-30144-81	—	9551 Lake View Rd, Atlanta, GA, 30307	0.76	Date of birth reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
CLM-407624	CLM	Betty Perkins	1987-12-19	—	—	938 Central Ave, Denver, CO, 80257	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-413934	CLM	Scott Richards	1991-01-23	UHC-45156-18	8747946288	4546 Oak St, Nashville, TN, 37202	0.76	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
CLM-415913	CLM	Harold Little	2004-10-04	—	—	7239 Maple Ave, Tampa, FL, 33601	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-422149	CLM	Ashley Ortega	1954-02-15	UHC-05522-42	—	6300 Market St, Austin, TX, 78716	0.76	Date of birth reformatted Member ID reformatted City re-cased State name converted to code+2 more
CLM-429742	CLM	Jancie Nichols	1956-07-20	UHC-09999-74	—	6905 Hillcrest Rd, Charlotte, NC, 28226	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-416630	CLM	Denise Schmidt	1969-05-02	UHC-99733-49	8507626288	3988 Mesa Dr, Mesa, AZ, 85273	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more

10,559 rows, page 92 of 212Previous Next