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 “SSN last four extracted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagSSN last four extractedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-55698	TPA	Ruth W Payne	1977-11-16	—	6968055688	6794 Church St, Jacksonville, FL, 32290	0.52	SSN last four extracted Street suffix standardised Address re-cased City re-cased+2 more
PRV-22006	PRV	Cheryl Rivera	1963-09-14	—	—	7489 Apache Blvd, Phoenix, AZ, 85039	0.52	Two-digit birth year SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-139405	ENR	Gary Chapman	1981-02-12	UHC-89611-35	6247951058	8674 Lake View Rd, San Diego, CA, 92145	0.52	Name re-cased Two-digit birth year SSN last four extracted Street suffix standardised+2 more
ENR-124996	ENR	Thomas Salazar	1993-07-25	UHC-08590-37	6516619342	7441 Valley View Dr, Austin, TX, 78755	0.52	SSN last four extracted Street suffix standardised Address re-cased City re-cased+2 more
ENR-100928	ENR	Charlotte Bryant	1993-09-22	UHC-51096-97	8588200512	4266 Union St, Denver, CO, 80230	0.52	Name re-cased SSN last four extracted Street suffix standardised Address re-cased+2 more
CLM-414513	CLM	Jonathan Sullivan	1969-06-09	UHC-02849-76	6668885855	2307 Forest Ave, Charlotte, NC, 28259	0.52	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-136558	ENR	Maria Cole	1946-12-12	UHC-57827-95	6113525955	7219 Apache Blvd, Phoenix, AZ, 85014	0.52	Name split from “Last, First”Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-111579	ENR	Bryan S Smith	2003-10-02	UHC-11693-40	7415637435	8664 Ridge Rd, Nashville, TN, 37207	0.52	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
TPA-58244	TPA	Maia B Gonzales	—	—	4833381608	6725 Bayshore Dr, Glendale, AZ, 85330	0.52	Date of birth unreadable Phone reformatted SSN last four extracted Street suffix standardised+2 more
CLM-425164	CLM	Kayla W Le	2002-03-09	UHC-50548-50	—	2921 Market St, Miami, FL, 33180	0.52	Name split from “Last, First”SSN last four extracted Street suffix standardised Address re-cased+2 more
CLM-426413	CLM	Rachel Kennedy	1975-07-09	UHC-76272-44	9426240881	8703 Park Pl, Phoenix, AZ, 85029	0.52	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-115281	ENR	Alexis M Hunt	1978-10-09	UHC-21311-85	3026347580	6601 Maple Ave, Tempe, AZ, 85245	0.52	Date of birth reformatted Phone reformatted SSN last four extracted ZIP+4 trimmed+2 more
CLM-432484	CLM	Wei Marshall	1979-11-21	UHC-81522-17	—	9172 Sunset Blvd, Tempe, AZ	0.52	SSN last four extracted Street suffix standardised Address re-cased ZIP missing+2 more
CLM-403593	CLM	Marilyn Hart	1953-09-01	—	7133791846	689 Spring St, Denver, CO, 80212	0.52	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-121655	ENR	Andrew W Cooper	1983-06-12	—	8329935777	805 Desert Sky Blvd, Charlotte, NC, 28211	0.52	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-135819	ENR	Harold Herrera	1958-11-09	—	3753762737	6162 Canyon Rd, Plano, TX, 75085	0.52	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-126144	ENR	Mason R Morales	1999-10-26	UHC-64421-02	3927661155	7153 Washington St, Plano, TX, 75091	0.52	SSN last four extracted Street suffix standardised Address re-cased City re-cased+2 more
ENR-113394	ENR	Dylan P Simpsoon	1996-12-09	UHC-44034-72	4672681835	4745 Lake View Rd, Minneapolis, MN, 55475	0.52	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-130990	ENR	Priya Fernandez	1961-09-06	UHC-54311-92	2232494186	9179 Spring St, Tucson, AZ, 85785	0.52	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-135614	ENR	Laura U Jackson	1987-12-28	UHC-55292-33	—	4088 Highland Ave, Chandler, AZ, 85270	0.52	Name re-cased SSN last four extracted Street suffix standardised Address re-cased+2 more
CLM-426161	CLM	Roy Watson	1981-02-16	UHC-53548-27	5969610633	7291 Hillcrest Rd, Glendale, AZ, 85303	0.52	Name split from “Last, First”Phone reformatted SSN last four extracted Street suffix standardised+2 more
CLM-427915	CLM	Sarah Perkins	1949-06-25	—	—	2882 Indian School Rd, Sacramento, CA, 95822	0.52	Name split from “Last, First”SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-129562	ENR	Theresa U Hicks	1969-02-09	UHC-01574-14	—	1799 Highland Ave, Jacksonville, FL, 32208	0.52	Name re-cased Date of birth reformatted Phone missing area code SSN last four extracted+2 more
ENR-126441	ENR	Keith I Bailey	1986-02-12	UHC-91055-84	4839432401	1902 Park Pl, Seattle, WA	0.52	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-139557	ENR	Jesse D Wang	1951-05-04	UHC-64399-80	5627903791	4970 Grand Ave # 581, Chandler, AZ, 85245	0.52	Middle initial moved out of first name Phone reformatted SSN last four extracted Unit split from street+2 more
ENR-135374	ENR	Thomas M Anderson	1965-04-13	UHC-56943-80	5392978987	4269 Oak St, Tucson, AZ	0.52	Name re-cased Phone reformatted SSN last four extracted State name converted to code+2 more
ENR-107274	ENR	Nathan Tucker	1982-07-18	UHC-69609-12	5058955843	573 Union St, Houston, TX, 77009	0.52	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-110065	ENR	Kathy Bowman	1973-10-03	UHC-43848-68	9483084611	3619 Elm St, Eden Prairie, MN	0.52	SSN last four extracted Street suffix standardised Address re-cased ZIP missing+2 more
ENR-101422	ENR	Sean Carter	1989-03-09	UHC-33480-82	6943474294	8727 Union St, Phoenix, AZ, 85067	0.52	Name split from “Last, First”SSN last four extracted Street suffix standardised Address re-cased+2 more
TPA-54566	TPA	Michelle Cunningham	2007-07-25	—	—	1038 Main St # 290, Gilbert, AZ, 85250	0.52	SSN last four extracted Unit split from street City re-cased ZIP+4 trimmed+2 more
CLM-431805	CLM	Christine Cooper	1963-04-27	UHC-90180-01	—	4649 Camelback Rd, Tampa, FL, 33646	0.52	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-126093	ENR	Vicky Harper	1955-09-05	UHC-33397-25	6304272018	3308 Baseline Rd, Phoenix, AZ, 85089	0.52	Phone reformatted Member ID reformatted SSN last four extracted Street suffix standardised+2 more
CLM-432289	CLM	Cheryl X Johnson	1973-02-07	UHC-75959-53	—	101 Palm Dr, Sacramento, CA, 95821	0.54	SSN last four extracted Street suffix standardised Address re-cased State name converted to code+1 more
TPA-53716	TPA	Brenda Garrett	1984-09-28	—	—	—	0.54	Name re-cased Phone missing area code SSN last four extracted Gender normalised+1 more
CLM-426256	CLM	Marc K Matthews	1990-03-08	UHC-28870-27	—	4840 Market St, Austin, TX, 78755	0.54	SSN last four extracted Street suffix standardised Address re-cased State name converted to code+1 more
TPA-58438	TPA	Rebecca Williams	1980-04-20	—	—	1967 Union St, Charlotte, NC, 28278	0.54	Name re-cased SSN last four extracted State name converted to code ZIP+4 trimmed+1 more
ENR-115904	ENR	Rusesll Williamson	1947-11-06	UHC-57475-82	8947451321	1151 Maple Ave Apt 16, Miami, FL	0.54	Name re-cased Phone reformatted SSN last four extracted Unit split from street+1 more
ENR-105721	ENR	Judy B Rose	1960-02-14	UHC-80661-85	6613165160	1226 Highland Ave # 942, Sacramento, CA, 95865	0.54	SSN last four extracted Unit split from street City re-cased Gender normalised+1 more
ENR-139623	ENR	Sophia Lynch	1950-05-02	UHC-90674-61	—	8743 Baseline Rd, Eden Prairie, MN, 55315	0.54	Name split from “Last, First”SSN last four extracted Street suffix standardised Address re-cased+1 more
ENR-102722	ENR	Evelyn A Fields	1942-02-14	UHC-07087-25	2473025562	7549 Indian School Rd, Phoenix, AZ	0.54	Name re-cased Date of birth reformatted SSN last four extracted State name converted to code+1 more
CLM-409622	CLM	Larry Moore	1979-07-17	—	—	399 Sage Ct, Sacramento, CA, 95808	0.54	SSN last four extracted Street suffix standardised Address re-cased State name converted to code+1 more
ENR-125701	ENR	Angela Flores	1985-04-07	UHC-81159-03	—	9795 Washington St Apt 26, Los Angeles, CA, 90021	0.54	Date of birth reformatted SSN last four extracted Unit split from street Email lower-cased+1 more
ENR-113090	ENR	Jason Cole	2007-07-06	UHC-46743-18	6412113722	1897 Washington St # 701, Phoenix, AZ, 85006	0.54	Two-digit birth year Phone reformatted SSN last four extracted Unit split from street+1 more
CLM-403238	CLM	Richard Luna	1986-01-18	UHC-69234-20	—	2149 Mesa Dr, Jacksonville, FL, 32267	0.54	SSN last four extracted Street suffix standardised Address re-cased Gender normalised+1 more
ENR-138699	ENR	Cheryl Little	1992-09-28	UHC-89021-43	5216093799	4835 Hillcrest Rd Apt 33, Eden Prairie, MN, 55390	0.54	Name split from “Last, First”Phone reformatted SSN last four extracted Unit split from street+1 more
ENR-120741	ENR	Emily T Fuller	1975-06-24	UHC-91168-07	8832622974	5073 Sunset Blvd, Miami, FL, 33196	0.54	Name split from “Last, First”SSN last four extracted Street suffix standardised Address re-cased+1 more
ENR-103313	ENR	Nicholas C Dominguez	1943-05-08	UHC-92617-68	9727333142	6743 Baseline Rd Apt 12, Houston, TX, 77071	0.54	Phone reformatted SSN last four extracted Unit split from street Street suffix standardised+1 more
ENR-138055	ENR	John T Salazar	1982-02-06	UHC-74782-26	8209265605	5809 Palm Dr, Gilbert, AZ, 85232	0.54	Phone reformatted SSN last four extracted State name converted to code Email lower-cased+1 more
CLM-429511	CLM	Jula Lucas	1981-07-20	—	—	504 Sunset Blvd, Minneapolis, MN, 55447	0.54	Two-digit birth year SSN last four extracted Street suffix standardised Address re-cased+1 more
ENR-110633	ENR	Kelly Evans	1967-07-23	UHC-44014-05	3234903918	4597 Sunset Blvd, Houston, TX, 77093	0.54	Name split from “Last, First”Phone reformatted SSN last four extracted State name converted to code+1 more

2,817 rows, page 19 of 57Previous Next