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

All ENR CLM TPA PRV

Junk onlyFlagPhone reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-424461	CLM	Sara Oiver	1957-09-03	UHC-31128-24	7055870807	9299 Highland Ave, Scottsdale, AZ, 85268	0.80	Two-digit birth year Phone reformatted Email lower-cased Placeholder values cleared
CLM-429025	CLM	Carol Henry	1999-11-03	UHC-64577-07	4805727690	2837 Broadway, Orlando, FL, 32847	0.80	Phone reformatted Email lower-cased Gender normalised Whitespace trimmed
CLM-406974	CLM	Nikk Bradley	1954-07-23	UHC-38925-57	9808934958	9694 Broadway, Las Vegas, NV, 89112	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-406973	CLM	Nikk Bradley	1954-07-23	UHC-38925-57	9808934958	9694 Broadway, Las Vegas, NV, 89112	0.80	Phone reformatted ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-405834	CLM	Hiroshi Y Price	1975-01-23	UHC-21169-37	4393906066	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-413385	CLM	Elijah Boyd	2000-09-03	UHC-80648-57	6663958132	—	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
CLM-419196	CLM	Maria Campbell	1986-11-08	UHC-54075-92	2086846093	3520 Lincoln Way, Charlotte, NC, 28219	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
CLM-402290	CLM	Anna G Young	1988-03-28	—	2089919527	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-413906	CLM	Hiroshi Green	1992-07-05	UHC-29732-52	5326008943	367 Harbor Blvd, Tempe, AZ, 85249	0.80	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed
CLM-400948	CLM	Heather Lopez	1941-12-08	—	5406316183	2352 Ridge Rd, Seattle, WA, 98122	0.80	Date of birth reformatted Phone reformatted State name converted to code Placeholder values cleared
CLM-408973	CLM	Nicole Sullivan	1960-08-09	—	4922062641	6031 River Rd, Phoenix, AZ, 85079	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-432655	CLM	Stephen Watkins	1966-10-20	UHC-21594-17	3607863037	—	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Placeholder values cleared
CLM-403699	CLM	Billy Weber	1989-01-02	UHC-14482-44	5696639713	3418 Indian School Rd, Los Angeles, CA, 90086	0.80	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed
CLM-423744	CLM	Jordn Rice	1965-09-13	—	8926828107	8671 Forest Ave, Sacramento, CA, 95866	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
CLM-424150	CLM	Laura Patterson	2006-10-22	—	9648179466	8239 Meadow Ln, Fresno, CA, 93744	0.80	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased
CLM-412510	CLM	Angela Dominguez	1939-12-28	UHC-11094-55	5953928235	3165 Sage Ct, Miami, FL, 33199	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-402766	CLM	Lori Santos	1944-01-14	—	6449584027	5363 Union St, San Antonio, TX, 78287	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-408785	CLM	Santiago Moore	—	—	5066140555	7197 Indian School Rd, Glendale, AZ, 85371	0.80	Name re-cased Date of birth unreadable Phone reformatted Placeholder values cleared
CLM-421456	CLM	Bruce Jensen	1965-06-05	UHC-93320-87	4064206829	9140 Oak St, San Diego, CA	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
CLM-429620	CLM	Robert Jacobs	1971-01-14	—	5938408570	7254 Central Ave Apt 6, Atlanta, GA, 30335	0.80	Phone reformatted Unit split from street Whitespace trimmed Placeholder values cleared
CLM-401549	CLM	Nicolle Maldonado	1960-07-08	UHC-16949-67	7926618076	88 Meadow Ln, Tucson, AZ, 85788	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-425019	CLM	Alan Ferguson	1942-03-01	UHC-70793-11	7162426654	—	0.80	Phone reformatted Member ID reformatted Gender normalised Placeholder values cleared
CLM-404882	CLM	Kayla Williamson	2008-07-14	—	4432446373	—	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
CLM-404881	CLM	Kayla Williamson	2008-07-14	—	4432446373	—	0.80	Date of birth reformatted Phone reformatted Gender normalised Placeholder values cleared
CLM-408632	CLM	Ruth Robertsson	1944-11-19	UHC-18376-75	9714784272	9595 Ridge Rd, Phoenix, AZ, 85049	0.80	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed
CLM-412949	CLM	Amy Armstrong	1999-05-08	UHC-05634-31	6942393198	4161 Apache Blvd, Phoenix, AZ, 85069	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-413516	CLM	Elizabeth Perez	1978-05-21	UHC-65690-96	7936434049	7103 Pine Dr, Dallas, TX, 75278	0.80	Date of birth reformatted Phone reformatted Gender normalised Whitespace trimmed
CLM-414311	CLM	Andrew Dean	1943-03-23	UHC-47206-76	3585817310	5529 Church St, Houston, TX, 77018	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-404510	CLM	Daniel Allen	1944-11-27	UHC-80230-70	2332238726	9804 Camelback Rd, Houston, TX, 77018	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-431129	CLM	Sarah J Hamilton	—	UHC-22904-19	9303641898	4998 Sage Ct, Scottsdale, AZ, 85252	0.80	Name re-cased Date of birth unreadable Phone reformatted Placeholder values cleared
CLM-408335	CLM	Mateo Gonzalees	1978-04-10	UHC-83490-21	4712284517	—	0.80	Name split from “Last, First”Phone reformatted Member ID reformatted Placeholder values cleared
CLM-401396	CLM	Andrea Russell	1985-03-04	UHC-80771-28	3922041435	9061 Ocean Ave, Houston, TX, 77080	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-424877	CLM	Elizabeth Washington	1959-09-22	UHC-87962-74	3519798216	7320 Maple Ave, Columbus, OH, 43239	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-415895	CLM	Virginiia Mejia	1986-09-13	UHC-32892-06	2128717470	6665 Lake View Rd, Austin, TX, 78706	0.80	Name re-cased Phone reformatted Street suffix standardised Address re-cased
CLM-426637	CLM	Jesse P Moreno	—	UHC-10876-97	7536730803	—	0.80	Name re-cased Date of birth missing Phone reformatted Placeholder values cleared
CLM-420647	CLM	Ralph Nichols	1962-06-14	—	4305989682	5689 Lincoln Way, Chandler, AZ, 85269	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-419423	CLM	Joshua L Wood	1938-06-09	—	8318293311	9593 Mountain View Dr, Columbus, OH, 43236	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-423343	CLM	Amy Castro	1989-03-26	—	2084621583	3536 Lake View Rd, Nashville, TN, 37254	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-423342	CLM	Amy Castro	1989-03-26	—	2084621583	3536 Lake View Rd, Nashville, TN, 37254	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-410315	CLM	Donna Hoffman	1998-08-07	—	4402656997	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-425068	CLM	Eric K Walkre	1939-07-14	—	9173522588	59 Willow Ct, Phoenix, AZ, 85086	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-428480	CLM	Jack J James	1957-03-03	—	8956886950	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-403130	CLM	Aisha A Dixon	1945-08-08	UHC-81067-89	5978343199	4596 Ridge Rd, Sacramento, CA, 95802	0.80	Name re-cased Phone reformatted State name converted to code Placeholder values cleared
CLM-418496	CLM	Chris Chen	1941-04-02	UHC-07924-36	8994079258	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-412657	CLM	Justin Rodriguez	1981-01-25	UHC-14976-96	2034768363	5750 Desert Sky Blvd, Dallas, TX, 75286	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-405473	CLM	Albert Olson	1947-11-08	UHC-39661-50	8178794171	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-420295	CLM	Susan Jackson	1985-02-10	—	5748993895	1342 Mountain View Dr # 681, Mesa, AZ, 85280	0.80	Name re-cased Phone reformatted Unit split from street Placeholder values cleared
CLM-414083	CLM	Joseph Porter	1960-06-27	UHC-81468-86	2375510773	6037 Sage Ct, Gilbert, AZ, 85238	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-413360	CLM	Ronald Padilla	2001-08-28	—	4709867841	6044 Broadway, Eden Prairie, MN, 55370	0.80	Name split from “Last, First”Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-428339	CLM	Arjun W Rios	1946-05-07	UHC-87030-13	6252517938	5830 Desert Sky Blvd, Phoenix, AZ, 85019	0.80	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased

11,960 rows, page 166 of 240Previous Next