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

All sources, flag “Gender normalised”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagGender normalisedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-132957	ENR	Andrea Q Hudson	1960-02-22	UHC-74064-92	—	2166 Lake View Rd, Los Angeles, CA, 90067	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
CLM-400824	CLM	Adam Sone	1969-12-25	—	—	7730 Church St, Seattle, WA, 98104	0.68	Date of birth reformatted ZIP+4 trimmed Gender normalised Placeholder values cleared
CLM-410037	CLM	Joan Y Clark	1967-11-09	—	—	3163 Grand Ave, Atlanta, GA, 30308	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-109904	ENR	Melissa Valdez	1954-02-10	UHC-81960-04	6816351928	962 Valley View Dr, Dallas, TX	0.68	City re-cased ZIP missing Gender normalised Whitespace trimmed
ENR-130156	ENR	Sarah N Foster	1962-11-03	UHC-39292-13	—	5075 Apache Blvd, Seattle, WA, 98161	0.68	Name re-cased State name converted to code Gender normalised Placeholder values cleared
ENR-112426	ENR	James Hunter	1991-12-20	UHC-23755-18	9708788232	1586 Grand Ave, Tucson, AZ, 85774	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-102935	ENR	Beverly H Price	1962-05-28	UHC-13639-59	2176874402	3799 Willow Ct, Seattle, WA, 98175	0.68	Name re-cased ZIP+4 trimmed Gender normalised Whitespace trimmed
CLM-421365	CLM	Lori Santiago	1993-02-12	UHC-83318-54	4878488971	3583 Hillcrest Rd, Tempe, AZ, 85206	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
CLM-426285	CLM	Fances Morgan	1953-04-15	UHC-23380-81	7226005592	7262 Park Pl, Plano, TX, 75039	0.68	Two-digit birth year Phone reformatted Gender normalised Placeholder values cleared
TPA-56117	TPA	Carol Burton	1984-02-02	—	—	5385 Broadway, Orlando, FL, 32807	0.68	Name re-cased ZIP+4 trimmed Gender normalised Placeholder values cleared
CLM-404081	CLM	Ana Fuller	1978-10-18	UHC-64825-97	—	9872 Spring St, Phoenix, AZ, 85042	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
PRV-20403	PRV	Albert P Clrk	1977-05-15	—	—	—	0.68	Name re-cased Phone missing area code Gender normalised Placeholder values cleared
ENR-117555	ENR	Luis O Peters	2000-12-01	UHC-99143-52	—	4568 Cedar Ln, Austin, TX, 78737	0.68	Date of birth reformatted Phone missing area code Email lower-cased Gender normalised
ENR-110069	ENR	Elizabeth Hill	2002-09-20	UHC-03957-05	9715702551	7340 Pine Dr, Plano, TX, 75015	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
PRV-23702	PRV	Madison Richards	1946-11-09	—	4209473320	4785 Cedar Ln, Gilbert, AZ, 85276	0.68	Phone reformatted State name converted to code Gender normalised Placeholder values cleared
ENR-130141	ENR	Sam Valdez	1950-02-09	UHC-09139-97	2996051262	6880 Park Pl, Glendale, AZ, 85362	0.68	Name re-cased Phone reformatted ZIP+4 trimmed Gender normalised
CLM-420495	CLM	Nicole P George	2006-06-12	—	5387533506	5730 Sunset Blvd, Austin, TX, 78750	0.68	Phone reformatted SSN last four extracted Gender normalised Placeholder values cleared
TPA-50979	TPA	Christine R Andrews	1951-11-11	—	5593798758	5495 Willow Ct Apt 33, Mesa, AZ, 85224	0.68	Phone reformatted Unit split from street Gender normalised Placeholder values cleared
ENR-117517	ENR	Dennis Boyd	1990-02-09	UHC-62213-03	3976135821	614 Hillcrest Rd, Plano, TX	0.68	Phone reformatted ZIP missing Email lower-cased Gender normalised
ENR-117034	ENR	Brittany F Willis	1978-02-10	UHC-29342-44	—	6478 Pine Dr, Scottsdale, AZ, 85275	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-135740	ENR	Debra Campbel	1985-06-08	UHC-83937-54	7096823811	3827 Spring St, Los Angeles, CA, 90081	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-119502	ENR	Ronald X Reid	1978-09-11	UHC-15374-37	8807949813	3966 Mountain View Dr, Austin, TX, 78799	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
CLM-428097	CLM	Melisas Hawkins	1975-06-26	UHC-87638-87	4386689792	9255 Harbor Blvd, Chandler, AZ, 85225	0.68	City re-cased ZIP+4 trimmed Gender normalised Placeholder values cleared
TPA-58825	TPA	Priya McDonald	—	—	6966363485	5136 Apache Blvd, Tempe, AZ, 85277	0.68	Date of birth missing Phone reformatted Gender normalised Placeholder values cleared
CLM-421244	CLM	Martha Sullivan	2007-02-09	—	—	175 Main St, Eden Prairie, MN, 55343	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-114557	ENR	Samuel R Gomez	1993-12-17	UHC-03152-04	4427451814	105 Grand Ave, Gilbert, AZ, 85206	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
TPA-59373	TPA	Valentina Q Ellis	1949-10-14	—	—	3256 Market St, Tucson, AZ, 85710	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-420588	CLM	Emma Sanders	1948-08-06	UHC-54455-12	—	6865 Sage Ct, Nashville, TN, 37297	0.68	Date of birth reformatted ZIP+4 trimmed Gender normalised Placeholder values cleared
CLM-420587	CLM	Emma Sanders	1948-08-06	UHC-54455-12	—	6865 Sage Ct, Nashville, TN, 37297	0.68	Date of birth reformatted ZIP+4 trimmed Gender normalised Placeholder values cleared
CLM-401849	CLM	Jacob Holmes	1993-04-12	—	—	9299 Apache Blvd, Austin, TX, 78764	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-401850	CLM	Jacob Holmes	1993-04-12	—	—	9299 Apache Blvd, Austin, TX, 78764	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-415914	CLM	Julie Rios	1994-08-06	UHC-27625-41	8954299276	5635 Lincoln Way, Los Angeles, CA, 90002	0.68	Name split from “Last, First”Phone reformatted Gender normalised Whitespace trimmed
CLM-408743	CLM	Randy Thompson	1994-11-20	UHC-81534-47	—	4277 Elm St, Houston, TX, 77081	0.68	Phone missing area code Gender normalised Whitespace trimmed Placeholder values cleared
ENR-136741	ENR	Raymond Stevens	1945-09-18	UHC-78535-14	8275860246	4183 Ocean Ave, Eden Prairie, MN, 55313	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
TPA-57266	TPA	Martha Hawkins	2004-12-04	UHC-77244-10	—	3240 Baseline Rd, Houston, TX, 77021	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-401354	CLM	Jean Lucas	1940-03-20	UHC-13467-31	2322739061	4579 Union St, Scottsdale, AZ, 85253	0.68	Name split from “Last, First”Phone reformatted Gender normalised Placeholder values cleared
TPA-51888	TPA	Catherine Richardson	1988-01-10	UHC-00641-21	4248223146	4471 Elm St, Seattle, WA, 98189	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-413316	CLM	Jon Ellis	1979-09-23	UHC-80469-45	—	5849 Palm Dr, Tampa, FL, 33609	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-403595	CLM	Isabella Griffin	1958-12-20	UHC-44529-74	—	8641 Main St, Houston, TX, 77018	0.68	Name split from “Last, First”Gender normalised Whitespace trimmed Placeholder values cleared
CLM-410872	CLM	Thomas Luna	1986-04-10	UHC-64102-71	—	3916 Bayshore Dr, Houston, TX, 77025	0.68	Name re-cased Street suffix standardised Address re-cased Gender normalised
ENR-131847	ENR	Bobby U Torres	1951-01-21	UHC-79343-32	5898300089	2970 Grand Ave, Dallas, TX, 75267	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-135572	ENR	Paul Fowler	1957-02-27	UHC-17761-59	6209496513	1318 Hillcrest Rd, Jacksonville, FL, 32234	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
TPA-50516	TPA	Fatima Davis	1997-04-15	—	—	35 Cedar Ln, Chandler, AZ, 85259	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
TPA-50454	TPA	Maria Harrison	1998-01-02	—	—	2840 Oak St, Columbus, OH, 43297	0.68	ZIP+4 trimmed Gender normalised Whitespace trimmed Placeholder values cleared
ENR-129788	ENR	Ronald I Meyer	1969-12-15	UHC-34548-71	5765375264	9051 Desert Sky Blvd # 227, Austin, TX, 78796	0.68	Name re-cased Unit split from street Gender normalised Whitespace trimmed
PRV-23691	PRV	Emily Murray	1992-02-20	UHC-96474-99	6767586829	—	0.68	Two-digit birth year Phone reformatted Gender normalised Placeholder values cleared
CLM-413605	CLM	Kevin S Price	1988-06-23	—	5727758697	8595 Broadway, Austin, TX, 78786	0.68	Name split from “Last, First”Gender normalised Whitespace trimmed Placeholder values cleared
ENR-106565	ENR	Diego O Turner	1949-06-20	UHC-55844-12	5127468412	6968 Harbor Blvd, Dallas, TX, 75279	0.68	Name split from “Last, First”Date of birth reformatted Phone reformatted Gender normalised
CLM-427700	CLM	Kathy West	2001-01-25	—	—	798 Central Ave, Dallas, TX, 75213	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-427699	CLM	Kathy West	2001-01-25	—	—	798 Central Ave, Dallas, TX, 75213	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared

16,828 rows, page 230 of 337Previous Next