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-431921	CLM	Bryan Grant	1971-03-07	UHC-71352-96	—	7460 Mountain View Dr, Chandler, AZ, 85254	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-406117	CLM	Jacqueline Ryan	1973-08-14	UHC-97443-27	—	5196 Mesa Dr, Houston, TX, 77024	0.78	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+1 more
CLM-413496	CLM	Lgan Scott	1966-09-13	—	6964658702	3265 Jefferson Ave Apt 8, Las Vegas, NV, 89182	0.78	Name re-cased Phone reformatted Unit split from street Whitespace trimmed+1 more
CLM-403116	CLM	Jesse Webb	1952-05-09	UHC-06711-16	—	—	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
CLM-413051	CLM	Carolyn Lee	2002-01-17	—	—	8949 Willow Ct, Seattle, WA, 98119	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-428782	CLM	Diego Willis	1945-11-19	UHC-55353-42	—	7121 Elm St, Tucson, AZ, 85707	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-403668	CLM	Keenneth Schultz	1944-12-20	—	—	455 Washington St, Nashville, TN, 37280	0.78	Name re-cased City re-cased Gender normalised Whitespace trimmed+1 more
CLM-418736	CLM	Denise Soto	1966-06-11	UHC-64839-09	7777088400	6039 Elm St, Los Angeles, CA, 90076	0.78	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+1 more
CLM-431861	CLM	Lawrence U Sccott	1993-10-27	UHC-71983-42	3176523314	9111 Pine Dr, Chandler, AZ, 85293	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-403465	CLM	Ethan Arnold	2005-02-01	—	6176874926	1015 Oak St, Gilbert, AZ, 85286	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-411096	CLM	Brittany Stephens	1945-01-14	—	9795777865	3384 Oak St, Columbus, OH, 43201	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-423437	CLM	Stephen Weber	1966-02-18	—	4659502162	4771 Grand Ave, Eden Prairie, MN, 55376	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-400072	CLM	Camila P Wagner	1988-01-08	—	6062572796	9707 Pine Dr, San Diego, CA, 92174	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-424110	CLM	Doris Y Thomas	—	UHC-73006-67	5944511673	—	0.78	Name re-cased Date of birth missing Phone reformatted Whitespace trimmed+1 more
CLM-416649	CLM	Christine Simpson	1943-05-14	—	7388710568	5125 Hillcrest Rd, Phoenix, AZ, 85092	0.78	Name re-cased Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-432264	CLM	Bryan Vargas	1991-01-19	—	—	6311 Sunset Blvd, Las Vegas, NV, 89101	0.78	Name re-cased Two-digit birth year State code upper-cased Whitespace trimmed+1 more
CLM-416775	CLM	Bryan Stevens	1997-05-16	UHC-77358-20	6423989218	—	0.78	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+1 more
CLM-402817	CLM	Vicky Weber	1939-05-02	—	—	6370 Mountain View Dr, Mesa, AZ, 85271	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-423757	CLM	Bradley N Hughes	1996-05-25	UHC-90029-18	—	6130 Lincoln Way, San Antonio, TX, 78234	0.78	Name re-cased Gender normalised Plan code upper-cased Whitespace trimmed+1 more
CLM-403504	CLM	Amber Alexanedr	1972-12-15	UHC-39257-43	3264648987	—	0.78	Name re-cased Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-405930	CLM	Michael Wells	1953-10-18	—	—	4425 Mesa Dr, Charlotte, NC, 28254	0.78	Name re-cased Date of birth reformatted ZIP+4 trimmed Whitespace trimmed+1 more
CLM-419479	CLM	Albert Park	2006-06-08	—	—	7915 Sunset Blvd, Seattle, WA, 98128	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-425074	CLM	Ashley J Oliver	1973-04-06	UHC-27439-19	5064834373	229 Bayshore Dr, Gilbert, AZ, 85201	0.78	Name re-cased Date of birth reformatted Gender normalised Whitespace trimmed+1 more
CLM-420027	CLM	Austin Hernandez	1991-02-06	—	—	4004 Baseline Rd, Denver, CO, 80210	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-421046	CLM	Joshua Williamson	1987-07-19	UHC-99344-22	8406078508	2202 Apache Blvd, Jacksonville, FL, 32286	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
CLM-406165	CLM	Christina J Harrison	1983-12-03	UHC-49614-16	—	1526 Union St, Fresno, CA, 93724	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-414343	CLM	Kathryn Nunez	1984-11-27	UHC-98186-22	—	3733 Meadow Ln Apt 11, Los Angeles, CA, 90025	0.78	Name re-cased Date of birth reformatted Unit split from street Whitespace trimmed+1 more
CLM-422123	CLM	Sara Estrada	1946-01-01	—	7713627179	2636 Forest Ave, Jacksonville, FL, 32276	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-423509	CLM	Betty Coleman	1949-07-22	UHC-56879-88	—	7996 Lake View Rd, Austin, TX, 78721	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
CLM-411498	CLM	Jack Clark	1957-06-05	UHC-74308-55	—	6822 Harbor Blvd, Atlanta, GA, 30388	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-407336	CLM	Virginia Weber	1973-04-04	UHC-10635-06	—	2954 Oak St, Columbus, OH, 43204	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-417951	CLM	Laura Weber	1944-09-22	—	—	5370 Sage Ct, Sacramento, CA, 95842	0.78	Name re-cased City re-cased Gender normalised Whitespace trimmed+1 more
CLM-424674	CLM	Sandra F Obrien	1975-12-18	UHC-04569-93	4458089307	6992 Jefferson Ave, Fresno, CA, 93777	0.78	Name re-cased Phone reformatted SSN last four extracted Whitespace trimmed+1 more
CLM-427147	CLM	Michael Castillo	1993-10-10	UHC-96541-82	—	3184 Bayshore Dr, Dallas, TX, 75234	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-431396	CLM	Michelle Bryant	1945-12-02	—	8424310690	8020 Jefferson Ave, Seattle, WA, 98190	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-430857	CLM	Karen Young	1971-06-26	UHC-94385-95	2348243929	2949 Hillcrest Rd, San Diego, CA, 92164	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-432266	CLM	David Garrett	2002-11-27	UHC-37765-78	—	—	0.78	Name re-cased Date of birth reformatted Phone missing area code Whitespace trimmed+1 more
CLM-404677	CLM	Bruce Jensen	1946-11-15	UHC-46172-17	—	2311 Lincoln Way, Chandler, AZ, 85210	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-417319	CLM	Alexis E Walker	1962-07-15	UHC-81179-53	3715679556	2604 Highland Ave, Phoenix, AZ, 85013	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-404948	CLM	Nicole X Rice	—	—	2789631747	8696 Canyon Rd, Fresno, CA, 93785	0.78	Name re-cased Date of birth missing Phone reformatted Whitespace trimmed+1 more
CLM-428385	CLM	Stephen Collins	1943-03-19	—	—	3224 Mountain View Dr, Sacramento, CA, 95871	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-415650	CLM	Charles I Fowler	1963-05-20	—	9655437918	3451 Mountain View Dr, Mesa, AZ, 85269	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-429836	CLM	Teresa G James	1987-06-15	UHC-36227-89	6208458818	5550 Jefferson Ave, Plano, TX, 75084	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-422454	CLM	Brittany Vasquez	1953-09-23	—	5602418709	8014 Baseline Rd, Tampa, FL, 33684	0.78	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
CLM-416722	CLM	Brittany Flors	1952-04-15	—	—	795 Broadway, Jacksonville, FL, 32204	0.78	Name re-cased Date of birth reformatted Address re-cased State name converted to code+1 more
CLM-408059	CLM	Gabriel Burns	1949-04-05	UHC-23008-39	—	5336 Apache Blvd, Jacksonville, FL, 32297	0.78	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
CLM-400612	CLM	Carol Hunt	1967-11-23	UHC-09781-20	5533760788	3809 Apache Blvd, Columbus, OH, 43215	0.78	Name re-cased Phone reformatted Gender normalised Whitespace trimmed+1 more
CLM-415329	CLM	Jeffrey Bryant	1965-05-05	—	—	3711 Camelback Rd, Orlando, FL, 32899	0.78	Name re-cased Street suffix standardised Address re-cased Whitespace trimmed+1 more
CLM-423948	CLM	Victoria Smith	1974-10-14	UHC-70339-33	—	9563 River Rd, Los Angeles, CA, 90017	0.78	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+1 more
CLM-405711	CLM	Luis Richardson	1990-06-10	—	—	—	0.78	Name re-cased Date of birth reformatted SSN last four extracted Whitespace trimmed+1 more

13,120 rows, page 137 of 263Previous Next