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 “State code upper-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagState code upper-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-428075	CLM	Christian King	1952-07-18	UHC-48234-46	—	5526 Sunset Blvd, Tempe, AZ, 85215	0.64	Name split from “Last, First”Street suffix standardised Address re-cased State code upper-cased+2 more
CLM-408872	CLM	Maria Ortiz	1961-08-02	—	—	1527 Park Pl, Nashville, TN, 37222	0.64	Name split from “Last, First”Street suffix standardised Address re-cased State code upper-cased+2 more
CLM-429391	CLM	Emily Roberts	1955-07-11	—	9565286935	6341 Meadow Ln, Tucson, AZ, 85745	0.64	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
CLM-408325	CLM	Lary R Jones	—	UHC-94064-39	—	6613 Jefferson Ave, Plano, TX, 75089	0.64	Name re-cased Date of birth missing Street suffix standardised Address re-cased+2 more
CLM-404157	CLM	Raymnd Castro	1997-10-20	UHC-84200-38	—	6647 Harbor Blvd, Eden Prairie, MN, 55386	0.64	Street suffix standardised Address re-cased State code upper-cased ZIP+4 trimmed+2 more
CLM-409624	CLM	Bruce Adams	1943-08-25	—	—	1940 Grand Ave, Austin, TX, 78733	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
CLM-417491	CLM	Richard Q Hawkins	1963-06-14	UHC-05462-25	—	8626 Indian School Rd, Minneapolis, MN	0.64	Street suffix standardised Address re-cased State code upper-cased ZIP missing+2 more
CLM-401565	CLM	Vincent George	—	—	—	2954 Lincoln Way, Phoenix, AZ, 85029	0.64	Date of birth unreadable Street suffix standardised Address re-cased State code upper-cased+2 more
CLM-405495	CLM	Lori Fowler	1972-10-21	UHC-41558-85	3782491059	194 Church St Apt 5, Tampa, FL, 33640	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
CLM-427165	CLM	Nicholas H Le	1977-05-15	UHC-49251-67	8577396860	4494 Spring St, Orlando, FL	0.64	Two-digit birth year Phone reformatted Member ID reformatted State code upper-cased+2 more
CLM-400451	CLM	Margaret K Chavez	1951-03-19	UHC-92419-11	8756610430	5663 Spring St, Minneapolis, MN, 55457	0.64	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-404186	CLM	Alexis Daivs	1952-08-28	UHC-98113-37	—	3470 Bayshore Dr, Los Angeles, CA, 90016	0.64	Two-digit birth year Street suffix standardised Address re-cased City re-cased+2 more
CLM-420860	CLM	Diego Matthews	1938-12-01	UHC-11271-69	—	4858 Mountain View Dr, Tucson, AZ, 85708	0.64	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+2 more
CLM-404237	CLM	Evelyn Gomez	1964-11-10	UHC-57767-40	—	9527 Broadway Apt 25, Orlando, FL, 32876	0.64	Name re-cased Unit split from street State code upper-cased Gender normalised+2 more
CLM-406892	CLM	Laura G Aguilar	1943-08-17	UHC-46548-44	2802655691	3684 Baseline Rd, Denver, CO, 80283	0.64	Phone reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
CLM-431465	CLM	Mary Munoz	1956-02-24	UHC-13183-92	—	6326 Hillcrest Rd, Fresno, CA	0.64	Name re-cased Street suffix standardised Address re-cased State code upper-cased+2 more
CLM-413117	CLM	Anthony Johnston	1976-01-26	UHC-39804-89	2375899084	6353 Cedar Ln # 964, Tampa, FL, 33619	0.64	Name split from “Last, First”Member ID reformatted Unit split from street State code upper-cased+2 more
CLM-413414	CLM	Pamela Tran	2004-09-25	—	—	8893 Grand Ave Apt 36, Glendale, AZ, 85332	0.64	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
CLM-401962	CLM	Mateo Stewart	1957-12-19	UHC-20020-02	—	6550 Jefferson Ave, Denver, CO, 80261	0.66	Name split from “Last, First”Two-digit birth year Member ID reformatted State code upper-cased+1 more
CLM-425918	CLM	Lisa Payne	1977-09-12	—	—	6546 Pine Dr, Tucson, AZ	0.66	Street suffix standardised Address re-cased State code upper-cased ZIP missing+1 more
CLM-424350	CLM	Emma X Chapman	1990-12-02	UHC-69747-90	—	2569 Hillcrest Rd, Scottsdale, AZ, 85272	0.66	Name split from “Last, First”Street suffix standardised Address re-cased State code upper-cased+1 more
CLM-410843	CLM	Albert Santos	1985-08-12	UHC-10621-50	6659790940	2953 Union St, Chandler, AZ, 85221	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-427202	CLM	William Hansen	1974-02-21	UHC-24086-77	—	201 River Rd, Jacksonville, FL, 32247	0.66	Phone missing area code Member ID reformatted State code upper-cased Gender normalised+1 more
CLM-417818	CLM	Ralph Gibson	1987-03-21	—	5698447571	2194 Baseline Rd Apt 31, Miami, FL, 33143	0.66	Two-digit birth year Unit split from street City re-cased State code upper-cased+1 more
CLM-428709	CLM	Hiroshi Herrera	1979-01-23	—	4822735360	4577 Union St, Plano, TX, 75018	0.66	Street suffix standardised Address re-cased State code upper-cased Gender normalised+1 more
CLM-406162	CLM	Jordna Harvey	1943-08-22	UHC-83802-55	6152207830	8555 Jefferson Ave, Las Vegas, NV, 89183	0.66	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-429619	CLM	Patrcia Murray	1950-05-27	UHC-35124-01	8066114608	9786 Ridge Rd, San Diego, CA, 92152	0.66	Two-digit birth year Phone reformatted State code upper-cased Gender normalised+1 more
CLM-429618	CLM	Patrcia Murray	1950-05-27	UHC-35124-01	8066114608	9786 Ridge Rd, San Diego, CA, 92152	0.66	Two-digit birth year Phone reformatted State code upper-cased Gender normalised+1 more
CLM-401341	CLM	Catherine Ellis	1939-12-19	—	—	3991 Park Pl Apt 38, Chandler, AZ, 85202	0.66	Name re-cased Unit split from street State code upper-cased Gender normalised+1 more
CLM-416354	CLM	Bruce K Philllips	1989-05-28	—	—	5407 Hillcrest Rd, Las Vegas, NV	0.66	Name split from “Last, First”State code upper-cased ZIP missing Whitespace trimmed+1 more
CLM-407537	CLM	Virginia Yang	1988-08-28	UHC-41415-62	6856039563	200 Jefferson Ave Apt 37, Mesa, AZ, 85287	0.66	Phone reformatted Unit split from street State code upper-cased ZIP+4 trimmed+1 more
CLM-411336	CLM	Jacqueline Burke	1969-12-10	—	—	9478 Harbor Blvd, San Diego, CA, 92122	0.66	Name re-cased Two-digit birth year State code upper-cased Gender normalised+1 more
CLM-413116	CLM	Barbara Snyder	1975-07-12	UHC-34905-16	5285628009	1746 Bayshore Dr, Charlotte, NC, 28217	0.66	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-410926	CLM	Rachel Willis	1975-12-03	UHC-19492-19	—	12 Ocean Ave, Charlotte, NC, 28279	0.66	Date of birth reformatted State code upper-cased ZIP+4 trimmed Gender normalised+1 more
CLM-416024	CLM	Brnda Nelson	1946-06-04	UHC-04067-06	—	1315 Market St, Gilbert, AZ	0.66	Name re-cased Street suffix standardised Address re-cased State code upper-cased+1 more
CLM-416023	CLM	Brnda Nelson	1946-06-04	UHC-04067-06	—	1315 Market St, Gilbert, AZ	0.66	Name re-cased Street suffix standardised Address re-cased State code upper-cased+1 more
CLM-422794	CLM	Vincent Russell	1998-07-01	UHC-99059-22	—	1656 Maple Ave, Eden Prairie, MN, 55319	0.66	Street suffix standardised Address re-cased State code upper-cased ZIP+4 trimmed+1 more
CLM-428047	CLM	Roger R Arnold	1998-06-21	UHC-95060-50	—	1890 Meadow Ln, Fresno, CA, 93709	0.66	Two-digit birth year State code upper-cased Gender normalised Whitespace trimmed+1 more
CLM-419654	CLM	Lisa Vargas	1939-02-28	—	—	3295 Meadow Ln, Atlanta, GA, 30367	0.66	Street suffix standardised Address re-cased State code upper-cased ZIP+4 trimmed+1 more
CLM-410466	CLM	Roy M Crawford	2004-06-04	UHC-12133-87	—	1696 Park Pl, Mesa, AZ, 85297	0.66	Name split from “Last, First”Member ID reformatted SSN last four extracted State code upper-cased+1 more
CLM-426076	CLM	Dorothy Peterson	1947-10-04	UHC-20813-41	7307123177	1631 Camelback Rd, Phoenix, AZ, 85062	0.66	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+1 more
CLM-422535	CLM	Steven Watkins	1956-06-02	UHC-18796-43	—	5142 Broadway # 231, Mesa, AZ, 85224	0.66	Name split from “Last, First”Unit split from street State code upper-cased Whitespace trimmed+1 more
CLM-421385	CLM	Nguyen G Diane	1961-03-10	—	—	3744 Ocean Ave, Orlando, FL, 32813	0.66	Name split from “Last, First”Street suffix standardised Address re-cased State code upper-cased+1 more
CLM-424006	CLM	Jordan Stewart	1958-08-17	UHC-47141-73	4626014149	8097 Main St, Glendale, AZ, 85316	0.66	Name split from “Last, First”Two-digit birth year State code upper-cased Whitespace trimmed+1 more
CLM-423175	CLM	Nathan Watkins	1974-08-06	UHC-86219-04	—	2794 Market St, Minneapolis, MN, 55461	0.66	Street suffix standardised Address re-cased State code upper-cased Gender normalised+1 more
CLM-421072	CLM	Mason K Ortiz	2008-02-08	—	8272432942	9428 Lake View Rd, Tempe, AZ, 85262	0.66	Street suffix standardised Address re-cased State code upper-cased Gender normalised+1 more
CLM-419607	CLM	Isabella Wood	1988-12-17	UHC-09077-92	—	7613 Willow Ct Apt 5, Denver, CO, 80218	0.66	Unit split from street State code upper-cased Gender normalised Whitespace trimmed+1 more
CLM-431361	CLM	Kimberly Delgado	1961-12-14	—	—	5493 River Rd, Dallas, TX, 75247	0.66	Street suffix standardised Address re-cased State code upper-cased ZIP+4 trimmed+1 more
CLM-421151	CLM	Scott Rogers	—	—	—	1722 Canyon Rd, Fresno, CA, 93769	0.66	Date of birth missing Street suffix standardised Address re-cased State code upper-cased+1 more
CLM-415829	CLM	Heather Jones	1988-04-22	UHC-15154-41	—	7379 Broadway, Dallas, TX, 75291	0.66	State code upper-cased ZIP+4 trimmed Gender normalised Whitespace trimmed+1 more

1,156 rows, page 9 of 24Previous Next