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 “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
ENR-104092	ENR	Luis Johnston	1953-02-17	UHC-78938-09	8338888123	5175 Washington St, Los Angeles, CA, 90092	0.64	Name split from “Last, First”Two-digit birth year Phone reformatted City re-cased+2 more
ENR-123541	ENR	Thomas Hamilton	1948-05-17	UHC-56407-31	8888782186	3220 Bayshore Dr, Eden Prairie, MN, 55323	0.64	Phone reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
PRV-26504	PRV	Daniel Kim	1958-09-25	—	5024941594	3734 Mesa Dr, Nashville, TN, 37231	0.64	Name split from “Last, First”Phone reformatted 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
ENR-141181	ENR	Kimberly Delgado	1961-12-14	UHC-27985-96	5075514343	5493 River Rd, Dallas, TX	0.64	Phone reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
ENR-100061	ENR	Brenda W Phillips	1942-09-21	UHC-53605-63	3483369303	2925 Bayshore Dr, Plano, TX, 75019	0.64	Name re-cased Two-digit birth year Phone reformatted State code upper-cased+2 more
TPA-57869	TPA	Nathan Parker	1951-06-24	—	—	2088 Desert Sky Blvd, Chandler, AZ, 85288	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-121502	ENR	Steven N Ramirez	1952-06-15	UHC-82095-13	—	5837 Indian School Rd, Columbus, OH, 43282	0.64	Phone missing area code Street suffix standardised Address re-cased State code upper-cased+2 more
ENR-108505	ENR	Beverly O Maldonado	1983-10-17	UHC-23486-18	9757829936	8868 Bayshore Dr, Dallas, TX, 75256	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-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
ENR-116363	ENR	Alexis V Yang	1997-10-17	UHC-66903-75	3073795334	5797 Elm St, Scottsdale, AZ, 85278	0.64	Phone reformatted Member ID reformatted SSN last four extracted Street suffix standardised+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
TPA-59862	TPA	Edward Z Sims	1993-02-01	—	—	1338 Hillcrest Rd, Houston, TX, 77051	0.64	Name re-cased Two-digit birth year State code upper-cased ZIP+4 trimmed+2 more
ENR-106605	ENR	Lawrence Lynch	1962-08-16	UHC-89282-74	8245778964	3963 Washington St, Orlando, FL, 32870	0.64	Name re-cased Street suffix standardised Address re-cased City 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
PRV-27809	PRV	Deborah S Burns	1980-01-12	—	2202424505	2696 Willow Ct, Fresno, CA, 93727	0.64	Date of birth reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
ENR-131192	ENR	Arjun X Austin	1960-03-04	UHC-84919-23	—	2454 Highland Ave, Tempe, AZ	0.64	Street suffix standardised Address re-cased State code upper-cased ZIP missing+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
ENR-110400	ENR	Ralph Bowman	—	UHC-64338-31	—	1164 Cedar Ln, Minneapolis, MN, 55402	0.64	Date of birth unreadable SSN last four extracted State code upper-cased Email lower-cased+2 more
ENR-136099	ENR	Stephanie S Perez	1965-08-25	UHC-82601-85	4752201274	2743 Elm St, Eden Prairie, MN, 55392	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-113934	ENR	Joe K Vargas	1953-12-19	UHC-78473-84	7454133124	7745 Ocean Ave, San Diego, CA, 92101	0.64	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-113935	ENR	Joe K Vargas	1953-12-19	UHC-78473-84	7454133124	7745 Ocean Ave, San Diego, CA, 92101	0.64	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-113667	ENR	Ana K Robinson	1955-02-02	UHC-45904-17	4879860691	3989 Indian School Rd, San Diego, CA, 92142	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
ENR-124935	ENR	Sharon S Maldonado	1938-10-27	UHC-77322-66	—	2247 Palm Dr, Jacksonville, FL, 32250	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
TPA-63978	TPA	Melissa Gray	1999-07-22	—	9107018468	720 Sunset Blvd, Eden Prairie, MN, 55319	0.64	Name split from “Last, First”Phone reformatted State code upper-cased Gender normalised+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
ENR-121810	ENR	Jerry Gibson	1981-09-03	UHC-57235-62	6438467313	7453 Bayshore Dr, Sacramento, CA	0.64	Street suffix standardised Address re-cased State code upper-cased ZIP missing+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
TPA-57102	TPA	Pamela Ruiz	1973-02-23	—	—	383 Meadow Ln, Charlotte, NC, 28235	0.66	City re-cased State code upper-cased ZIP+4 trimmed Gender normalised+1 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
TPA-55694	TPA	Rachel Diaz	1999-12-10	—	—	9301 Highland Ave, Nashville, TN, 37232	0.66	Name split from “Last, First”Street suffix standardised Address re-cased State code upper-cased+1 more
TPA-56752	TPA	Sophia U Williamson	—	—	—	7952 Grand Ave, Plano, TX, 75077	0.66	Date of birth unreadable Street suffix standardised Address re-cased 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
ENR-127963	ENR	Maria E Spencer	1977-03-27	UHC-16004-64	7254509368	973 Sage Ct, Eden Prairie, MN, 55349	0.66	Name split from “Last, First”Phone reformatted State code upper-cased ZIP+4 trimmed+1 more
ENR-101445	ENR	Timothy P Hernandez	1991-07-06	UHC-76166-29	3149376695	3939 Pine Dr, Dallas, TX	0.66	Phone reformatted Street suffix standardised Address re-cased State code upper-cased+1 more
ENR-134963	ENR	Natalie U Warren	2007-12-13	UHC-66564-15	9533352615	576 Spring St, Las Vegas, NV, 89136	0.66	Name split from “Last, First”Phone reformatted State code upper-cased Gender normalised+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
ENR-143048	ENR	Brian I Vazquez	1956-09-26	UHC-89900-10	3542605010	6606 Oak St, Austin, TX, 78766	0.66	Street suffix standardised Address re-cased State code upper-cased Gender normalised+1 more
ENR-138914	ENR	Kevin B Burton	1974-02-28	UHC-40231-03	8846081503	2103 Forest Ave, Tampa, FL	0.66	Street suffix standardised Address re-cased State code upper-cased ZIP missing+1 more
PRV-27425	PRV	Martha Watson	1976-12-23	UHC-66588-79	6966517927	6159 Union St, Eden Prairie, MN, 55365	0.66	Street suffix standardised Address re-cased State code upper-cased ZIP+4 trimmed+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
PRV-27587	PRV	Eugene Freeman	1961-12-23	—	8543837439	5162 Lincoln Way, Scottsdale, AZ, 85251	0.66	Name split from “Last, First”City re-cased State code upper-cased Gender normalised+1 more
ENR-108598	ENR	Diane F Ward	1997-09-08	UHC-11834-77	—	2021 Park Pl, Columbus, OH, 43292	0.66	Name split from “Last, First”Date of birth reformatted State code upper-cased Gender normalised+1 more
ENR-120210	ENR	Sara Y Carter	1968-05-03	UHC-10224-44	2378449565	8769 Cedar Ln, Gilbert, AZ, 85200	0.66	Name split from “Last, First”Phone reformatted State code upper-cased Gender normalised+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

4,010 rows, page 27 of 81Previous Next