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 “Name re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagName re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-414615	CLM	Alexander Vasquez	1951-09-23	UHC-55510-39	7973625493	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-417723	CLM	Diane Meyer	1984-01-08	UHC-37316-71	—	6924 Apache Blvd Apt 37, Las Vegas, NV, 89182	0.80	Name re-cased Unit split from street Whitespace trimmed Placeholder values cleared
CLM-413493	CLM	Richard Greene	1997-02-19	—	—	1273 Spring St, Miami, FL, 33191	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-414964	CLM	Lucia Vega	2006-09-16	UHC-56461-21	—	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
CLM-425642	CLM	Bradley Flores	1978-11-17	UHC-20706-40	—	3417 Indian School Rd, Gilbert, AZ, 85296	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-416277	CLM	Carlos C Kennedy	1976-02-05	UHC-61491-38	—	4777 Palm Dr, Orlando, FL, 32867	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
CLM-432290	CLM	Amber Ruiz	1947-11-07	UHC-70601-68	8288418858	9109 Union St, Scottsdale, AZ, 85281	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-413419	CLM	Tyler Dominguez	1982-11-27	UHC-61632-38	—	7545 Canyon Rd, Nashville, TN, 37239	0.80	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed
CLM-405358	CLM	Albert Li	—	UHC-19977-98	—	—	0.80	Name re-cased Date of birth unreadable Member ID reformatted Placeholder values cleared
CLM-400314	CLM	Cynthia Harris	1979-04-10	UHC-79984-33	—	2821 Canyon Rd, Tucson, AZ, 85723	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-420963	CLM	Gerald Tran	1980-06-22	UHC-49638-03	—	—	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
CLM-423907	CLM	Maria Jenkins	2006-04-01	—	7118276384	2486 Mountain View Dr, Jacksonville, FL, 32232	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-412138	CLM	Camila Morgan	1992-07-21	UHC-73268-26	7844103472	2671 Lake View Rd, Orlando, FL, 32899	0.80	Name re-cased Date of birth reformatted State name converted to code Placeholder values cleared
CLM-417988	CLM	Larry Black	2002-04-26	UHC-35995-09	—	5147 Union St, San Diego, CA, 92173	0.80	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed
CLM-429300	CLM	Ronald Jimenez	1942-10-25	UHC-03548-71	6127797056	3830 Mountain View Dr, Atlanta, GA, 30359	0.80	Name re-cased City re-cased State name converted to code Placeholder values cleared
CLM-413109	CLM	Kenneth Perkins	2003-07-24	UHC-16787-95	3046370785	4677 Valley View Dr, Scottsdale, AZ, 85266	0.80	Name re-cased Phone reformatted Street suffix standardised Address re-cased
CLM-407117	CLM	Sharon Rogers	1971-03-15	—	—	—	0.80	Name re-cased SSN last four extracted Whitespace trimmed Placeholder values cleared
CLM-427197	CLM	Randy D Owens	2005-12-13	UHC-66110-46	—	5875 Church St, Fresno, CA, 93795	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-413149	CLM	Austin Y Morgan	1982-12-01	—	—	6776 Sunset Blvd, Chandler, AZ, 85258	0.80	Name re-cased State name converted to code Whitespace trimmed Placeholder values cleared
CLM-411840	CLM	Theresa Richards	1968-04-08	—	4569637577	5657 Ridge Rd, Las Vegas, NV, 89140	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-417028	CLM	Cheryl D Thmoas	1997-04-20	—	7528030642	8372 Cedar Ln, Eden Prairie, MN, 55387	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-429679	CLM	Julie Patel	1978-02-18	—	7727632573	2174 Highland Ave, Tucson, AZ, 85760	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
CLM-428282	CLM	Edward Jenkins	1963-01-15	UHC-64529-19	5799065259	—	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
CLM-406422	CLM	Stephanie X Burns	—	—	—	2406 Indian School Rd, Charlotte, NC, 28231	0.80	Name re-cased Date of birth missing Whitespace trimmed Placeholder values cleared
CLM-401077	CLM	Angela I Mills	1973-10-09	—	—	3753 Harbor Blvd, Tucson, AZ, 85789	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-430435	CLM	Kathleen S Moore	1989-12-27	UHC-75963-29	4339976390	6354 Sage Ct, San Diego, CA, 92109	0.80	Middle initial moved out of first name Name re-cased Phone reformatted Placeholder values cleared
CLM-422634	CLM	Kathryn Valdez	2002-01-12	UHC-66093-72	—	2666 Union St, Glendale, AZ, 85349	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-414417	CLM	Ronald X Murray	1953-02-23	—	2799224710	1842 Meadow Ln, Gilbert, AZ	0.80	Name re-cased Phone reformatted ZIP missing Placeholder values cleared
CLM-400702	CLM	Etthan Vargas	1950-02-18	UHC-32789-06	—	6425 Highland Ave, Phoenix, AZ, 85005	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
CLM-428618	CLM	Jack Yang	1943-06-04	—	3408163035	2958 Camelback Rd, Las Vegas, NV, 89194	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-416082	CLM	Priya Howarrd	1977-10-20	UHC-63338-41	—	269 Desert Sky Blvd, Chandler, AZ	0.80	Name re-cased ZIP missing Whitespace trimmed Placeholder values cleared
CLM-411663	CLM	Julia Y Weber	1966-11-25	UHC-09690-48	2484848500	8937 Palm Dr, Seattle, WA, 98139	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-428636	CLM	Lisa Burton	1945-11-17	UHC-23382-54	—	913 Lake View Rd, San Diego, CA, 92145	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-403998	CLM	Amber Richards	1978-07-21	UHC-43880-34	—	—	0.80	Name re-cased Two-digit birth year Whitespace trimmed Placeholder values cleared
CLM-417852	CLM	Jeffrey Lee	1941-04-28	UHC-70346-40	2108602156	—	0.80	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed
CLM-424412	CLM	Michael Vargas	1970-12-16	UHC-17895-09	—	2345 Maple Ave, Miami, FL, 33124	0.80	Name re-cased ZIP+4 trimmed Whitespace trimmed Placeholder values cleared
CLM-407445	CLM	Joseph King	1982-12-04	UHC-46651-11	7038362946	9130 Broadway, Jacksonville, FL, 32290	0.80	Name re-cased Two-digit birth year Whitespace trimmed Placeholder values cleared
CLM-401613	CLM	Ana Roberts	1973-01-18	UHC-57213-03	7572678141	9756 Lincoln Way, Mesa, AZ, 85221	0.80	Name re-cased Phone reformatted State name converted to code Placeholder values cleared
CLM-413240	CLM	Lisa Mendez	1953-09-05	UHC-19854-24	—	9253 Jefferson Ave, San Diego, CA, 92186	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-414007	CLM	Mariana G Dixon	1975-06-01	UHC-58745-51	6062608105	9177 Main St, Scottsdale, AZ, 85289	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-419791	CLM	Ronald Q Fowler	—	UHC-11532-40	8608026760	6612 Park Pl, San Diego, CA, 92110	0.80	Name re-cased Date of birth unreadable State code upper-cased Placeholder values cleared
CLM-423126	CLM	Arthur V Anderson	1982-06-09	UHC-92354-94	—	—	0.80	Middle initial moved out of first name Name re-cased Whitespace trimmed Placeholder values cleared
CLM-430956	CLM	Kelly Chapman	1970-01-12	—	—	5381 Grand Ave, Las Vegas, NV, 89156	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-416463	CLM	Fatima Sanders	1958-04-02	—	3886008236	—	0.80	Name re-cased Phone reformatted Gender normalised Placeholder values cleared
CLM-430380	CLM	Kyle Ray	—	—	—	1541 Broadway, Seattle, WA, 98121	0.80	Name re-cased Date of birth unreadable Address re-cased Placeholder values cleared
CLM-409975	CLM	Emma Ortiz	1944-08-13	UHC-56096-77	—	1424 Main St, Houston, TX, 77075	0.80	Name re-cased Street suffix standardised Address re-cased Placeholder values cleared
CLM-420905	CLM	Andrea Peters	1962-05-26	UHC-05108-52	9254279059	5022 Lake View Rd, Tampa, FL, 33675	0.80	Name re-cased Two-digit birth year Whitespace trimmed Placeholder values cleared
CLM-411747	CLM	Arjun Herrera	—	UHC-43441-49	9526841399	—	0.80	Name re-cased Date of birth unreadable Whitespace trimmed Placeholder values cleared
CLM-403685	CLM	Willie Medina	2006-07-04	—	—	1180 Broadway, Fresno, CA, 93749	0.80	Name re-cased Gender normalised Whitespace trimmed Placeholder values cleared
CLM-404850	CLM	Heather McDonald	1947-01-09	—	7114969185	634 Apache Blvd Apt 18, Austin, TX, 78773	0.80	Name re-cased Unit split from street Whitespace trimmed Placeholder values cleared

13,120 rows, page 167 of 263Previous Next