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-401905	CLM	Christina Thoomas	1973-07-12	UHC-56224-08	7858492450	8740 Canyon Rd, San Antonio, TX, 78286	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-408431	CLM	Arjun Vega	2004-09-06	—	4303140799	8924 Maple Ave, Nashville, TN, 37267	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-408931	CLM	Kevin Powell	1944-02-06	—	4584483116	8193 Union St, Tucson, AZ, 85762	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-400141	CLM	Sofia Nunnez	1980-07-22	UHC-92875-98	2684198246	277 Lake View Rd, Nashville, TN, 37269	0.80	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed
CLM-418561	CLM	Stephen Cox	1997-04-01	—	9453304929	9136 Broadway, San Antonio, TX	0.80	Phone reformatted Address re-cased ZIP missing Placeholder values cleared
CLM-411956	CLM	Henry Alvarez	1956-09-16	—	9042388403	2832 Meadow Ln, Tampa, FL, 33643	0.80	Name re-cased Phone reformatted ZIP+4 trimmed Placeholder values cleared
CLM-402307	CLM	Steven Griffin	1964-06-03	UHC-31694-08	9233736481	7957 Spring St, Los Angeles, CA, 90041	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-430933	CLM	Jason Bennett	—	UHC-05560-64	3074850798	9140 Lake View Rd, Tempe, AZ, 85296	0.80	Date of birth missing Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-408838	CLM	Lawrence Gutierrez	1943-12-13	UHC-49649-11	8897713000	3482 Jefferson Ave, Columbus, OH, 43268	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-411275	CLM	Diego S George	1963-07-15	UHC-54806-04	9444057800	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-410228	CLM	Russell Hicks	1974-03-05	UHC-25635-11	3292866762	294 Central Ave, Charlotte, NC, 28284	0.80	Phone reformatted City re-cased Gender normalised Placeholder values cleared
CLM-428098	CLM	Kathleen Hudson	1949-01-18	—	7937086911	7360 Church St, Miami, FL	0.80	Phone reformatted ZIP missing Whitespace trimmed Placeholder values cleared
CLM-426576	CLM	Patrick Lopez	1976-03-28	UHC-03037-49	8934592087	1400 Palm Dr, Columbus, OH, 43297	0.80	Phone reformatted Street suffix standardised Address re-cased City re-cased
CLM-430599	CLM	Willie Smis	1959-05-14	—	3835495239	3094 Hillcrest Rd, Plano, TX, 75032	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-407748	CLM	Charlotte Reyes	1943-10-20	UHC-26687-68	6242936807	2567 Canyon Rd, Charlotte, NC, 28296	0.80	Phone reformatted State name converted to code Whitespace trimmed Placeholder values cleared
CLM-408901	CLM	Paul J Stevens	1973-01-21	UHC-50401-72	9467438869	9296 Harbor Blvd, Plano, TX, 75098	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-430012	CLM	Larry Garcia	1952-09-11	—	2833899872	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-428595	CLM	Mateo C Bryant	1943-05-28	UHC-25747-94	7932053496	9124 Sunset Blvd, Gilbert, AZ, 85212	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-410695	CLM	Emily Anderson	1953-02-16	—	5059545342	3066 Sage Ct, Mesa, AZ, 85249	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-423593	CLM	Becky T Rodrigueez	1996-06-08	—	4757714074	1058 Lake View Rd # 354, Denver, CO, 80214	0.80	Phone reformatted Unit split from street Whitespace trimmed Placeholder values cleared
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-424539	CLM	Deborah Fernandez	1954-02-16	UHC-57733-64	5749071306	—	0.80	Phone reformatted Gender normalised Whitespace trimmed Placeholder values cleared
CLM-407397	CLM	Arthur Lucas	1954-04-24	UHC-21109-17	6517413344	9504 River Rd, Atlanta, GA, 30300	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-416832	CLM	Priya Reynolds	1995-05-20	UHC-03653-51	3755415656	3380 Camelback Rd, Tucson, AZ, 85754	0.80	Two-digit birth year Phone reformatted City re-cased Whitespace trimmed
CLM-418621	CLM	Gregory Vasquez	1949-12-06	UHC-23843-06	3137640769	5697 Main St, Tampa, FL, 33636	0.80	Two-digit birth year Phone reformatted Whitespace trimmed 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-426972	CLM	Timothy Floores	—	—	5864231632	9101 Baseline Rd, San Antonio, TX, 78260	0.80	Date of birth missing Phone reformatted City re-cased Placeholder values cleared
CLM-415908	CLM	Alexis Reynolds	1988-03-04	UHC-91345-99	5844035824	5890 Harbor Blvd, Glendale, AZ, 85387	0.80	Phone reformatted Street suffix standardised Address re-cased Whitespace trimmed
CLM-432276	CLM	Virginia Armstrong	1961-07-18	UHC-99958-97	8458388168	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared
CLM-415203	CLM	Hannah Carroll	2003-03-06	UHC-95176-71	9098181731	3663 Ridge Rd, Houston, TX, 77069	0.80	Phone reformatted 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-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-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-400182	CLM	Larry Chapman	1972-12-11	—	6886345636	1882 Baseline Rd, Jacksonville, FL, 32200	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-421636	CLM	Willie Wang	1997-12-05	—	7644344853	—	0.80	Name split from “Last, First”Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-408520	CLM	Tyler Thomas	1948-08-01	UHC-19916-14	7237238977	6416 Pine Dr, San Antonio, TX, 78264	0.80	Phone reformatted Street suffix standardised Address re-cased 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-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-410941	CLM	Sarah Fernandez	1951-11-24	—	7394265314	3509 Willow Ct, Denver, CO, 80269	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-420366	CLM	Kayla Pena	1969-01-04	—	3687610808	6436 Ridge Rd, Atlanta, GA, 30308	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-421979	CLM	Grace Stephens	1956-03-05	—	7496648840	1151 Palm Dr, San Antonio, TX, 78266	0.80	Phone reformatted 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-400720	CLM	Mark Hicks	1942-08-10	UHC-78075-81	7555104467	9003 Grand Ave, Nashville, TN, 37240	0.80	Phone reformatted Street suffix standardised Address re-cased Placeholder values cleared
CLM-418573	CLM	Kelly G Bishop	1958-01-12	UHC-23217-24	9615919930	—	0.80	Name split from “Last, First”Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-404326	CLM	Danny S Fuller	1953-01-25	UHC-71153-24	8828932349	5148 Mesa Dr, Austin, TX, 78756	0.80	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased
CLM-422723	CLM	Terry West	1982-11-25	—	7538299365	4900 Church St, Los Angeles, CA, 90086	0.80	Date of birth reformatted Phone reformatted ZIP+4 trimmed Whitespace trimmed
CLM-400998	CLM	Mary Hughes	1973-01-12	—	4135029924	3133 Washington St, Orlando, FL, 32870	0.80	Phone reformatted State name converted to code Whitespace trimmed Placeholder values cleared
CLM-403062	CLM	Julie Cox	2008-04-06	—	4565150171	—	0.80	Name split from “Last, First”Date of birth reformatted Phone reformatted Placeholder values cleared
CLM-415752	CLM	Dennis Watkins	1994-06-21	UHC-26047-78	8268386135	—	0.80	Name split from “Last, First”Phone reformatted Whitespace trimmed Placeholder values cleared

11,960 rows, page 156 of 240Previous Next