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
TPA-61482	TPA	Madison Coopre	2001-05-26	—	—	300 Church St, Las Vegas, NV	0.68	Name re-cased ZIP missing Gender normalised Placeholder values cleared
ENR-133613	ENR	Rebecca Foster	1989-11-23	UHC-93811-43	4458915584	5863 Mountain View Dr, Mesa, AZ, 85236	0.68	Street suffix standardised Address re-cased Email lower-cased Gender normalised
CLM-430300	CLM	Andrea Martinez	1941-05-17	UHC-02997-04	5389124249	—	0.68	Name split from “Last, First”Phone reformatted Gender normalised Placeholder values cleared
ENR-112206	ENR	George C Weber	1998-02-22	UHC-63413-58	5162565619	530 Church St, Sacramento, CA, 95881	0.68	Two-digit birth year Phone reformatted Gender normalised Placeholder values cleared
TPA-53133	TPA	Nicholas Gibson	—	—	—	6030 Camelback Rd, Minneapolis, MN, 55489	0.68	Date of birth missing Gender normalised Whitespace trimmed Placeholder values cleared
ENR-135507	ENR	Deborah H Obrien	1991-02-05	UHC-77787-12	4948477432	6867 Main St, Los Angeles, CA	0.68	Name re-cased Phone reformatted ZIP missing Gender normalised
TPA-58429	TPA	Walter Gilbert	1963-05-27	—	—	2595 Maple Ave, Chandler, AZ, 85266	0.68	State name converted to code Gender normalised Whitespace trimmed Placeholder values cleared
PRV-25532	PRV	Brandon J White	1984-09-10	—	5795481981	8193 Cedar Ln, Gilbert, AZ, 85217	0.68	Street suffix standardised Address re-cased Email lower-cased Gender normalised
TPA-51774	TPA	Alexander F Berry	1967-05-21	—	—	806 Apache Blvd, Los Angeles, CA, 90048	0.68	Two-digit birth year Gender normalised Whitespace trimmed Placeholder values cleared
ENR-111396	ENR	Arjun Garza	1948-01-28	UHC-77274-12	3129587510	6737 Ocean Ave Apt 9, Jacksonville, FL, 32208	0.68	Phone reformatted Unit split from street Gender normalised Whitespace trimmed
CLM-427442	CLM	Phiip Valdez	2002-07-04	UHC-98601-37	6855070551	2007 Mountain View Dr Apt 38, Eden Prairie, MN, 55320	0.68	Date of birth reformatted Unit split from street City re-cased Gender normalised
ENR-112058	ENR	Steve H Miller	1998-05-04	UHC-10946-99	—	7418 Mountain View Dr, Tempe, AZ, 85204	0.68	Name re-cased Street suffix standardised Address re-cased Gender normalised
PRV-20200	PRV	Shirley A Woods	1959-10-18	UHC-25499-05	6592621873	9434 Washington St, Eden Prairie, MN, 55379	0.68	Name split from “Last, First”Gender normalised Whitespace trimmed Placeholder values cleared
TPA-54516	TPA	Anela Moreno	1984-07-14	—	—	5944 Park Pl, Houston, TX, 77001	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
CLM-411909	CLM	Randy Webb	1957-12-03	—	—	—	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
PRV-27182	PRV	Valentina King	1989-03-28	—	—	8497 Palm Dr, Orlando, FL, 32882	0.68	Name split from “Last, First”City re-cased Gender normalised Placeholder values cleared
ENR-113852	ENR	Santiago Perkins	1977-11-25	UHC-04230-33	5446044503	6183 Apache Blvd, Scottsdale, AZ, 85285	0.68	Two-digit birth year Phone reformatted Gender normalised Whitespace trimmed
ENR-122348	ENR	Ken Henry	—	UHC-27427-73	5245542623	4427 Forest Ave, Dallas, TX, 75208	0.68	Date of birth unreadable Phone reformatted Gender normalised Placeholder values cleared
ENR-132386	ENR	Mary K Walsh	1948-07-18	UHC-38062-69	8892365221	2055 Washington St, Las Vegas, NV	0.68	Date of birth reformatted Phone reformatted ZIP missing Gender normalised
ENR-117101	ENR	Teresa Richardson	1963-10-21	UHC-92136-25	9434253605	4238 Highland Ave, Fresno, CA, 93770	0.68	Member ID reformatted Street suffix standardised Address re-cased Gender normalised
ENR-105326	ENR	Austin I Rodriguez	1994-10-26	UHC-11337-61	9074348731	9749 Mesa Dr, Mesa, AZ	0.68	Date of birth reformatted ZIP missing Gender normalised Placeholder values cleared
ENR-129560	ENR	Andrea Woods	1955-06-21	UHC-37440-63	—	7509 Desert Sky Blvd, Austin, TX, 78757	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-114787	ENR	Henry Rodriguez	1959-05-24	UHC-67679-87	6267414210	8981 Bayshore Dr, Atlanta, GA, 30313	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
PRV-20785	PRV	Kayla Wells	1985-07-02	—	2699514602	16 Forest Ave, Glendale, AZ, 85362	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-116790	ENR	Laura Cruz	1945-07-02	UHC-16221-79	9555967754	4987 Valley View Dr, Orlando, FL, 32876	0.68	Name re-cased Phone reformatted ZIP+4 trimmed Gender normalised
CLM-410771	CLM	Abigail Johnston	—	UHC-13519-75	—	—	0.68	Date of birth unreadable Gender normalised Whitespace trimmed Placeholder values cleared
ENR-123709	ENR	Alexis F Howell	2005-09-05	UHC-00431-38	5859599109	128 Cedar Ln, Fresno, CA, 93746	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
PRV-28330	PRV	Jeremy Mason	1962-12-28	—	8153981570	4853 Apache Blvd, Jacksonville, FL, 32253	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-138511	ENR	Ronald Z Allen	2007-12-18	UHC-61529-91	8238184725	7166 Meadow Ln, Mesa, AZ, 85200	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-137983	ENR	Debbie Ortega	1966-09-17	UHC-05686-65	5073373848	5164 Lincoln Way, Atlanta, GA, 30370	0.68	Phone reformatted ZIP+4 trimmed Gender normalised Whitespace trimmed
ENR-116793	ENR	Christina M Herrera	1954-09-19	—	4422218009	6995 Pine Dr, Plano, TX, 75052	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
TPA-63046	TPA	Russell Torres	1984-12-02	UHC-27828-45	—	4623 Lake View Rd # 404, Nashville, TN, 37205	0.68	Unit split from street Gender normalised Whitespace trimmed Placeholder values cleared
CLM-409160	CLM	Evelyn Austin	1953-04-15	—	6654045053	6261 Church St, Gilbert, AZ, 85299	0.68	Phone reformatted State name converted to code Gender normalised Placeholder values cleared
TPA-56309	TPA	Camila Ortiz	2008-06-21	—	—	8674 Cedar Ln, Houston, TX, 77047	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-114651	ENR	Catherine K Jensen	1947-10-25	UHC-06420-48	5464331855	4835 Grand Ave, Tucson, AZ, 85735	0.68	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised
ENR-103864	ENR	Carolyn S Ward	2004-03-16	UHC-59025-32	5162297629	9472 Desert Sky Blvd, Chandler, AZ	0.68	Phone reformatted Member ID reformatted ZIP missing Gender normalised
CLM-402630	CLM	Gregory Hudson	1972-10-10	UHC-64213-60	6077518762	4533 Camelback Rd, Eden Prairie, MN, 55353	0.68	Name re-cased ZIP+4 trimmed Gender normalised Whitespace trimmed
CLM-418014	CLM	Bruce Cole	1952-03-11	UHC-76142-82	—	7356 Harbor Blvd, Los Angeles, CA, 90000	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-123610	ENR	Benjamin Chen	2006-10-09	UHC-03850-87	6885730437	6943 Apache Blvd, Gilbert, AZ, 85214	0.68	Member ID reformatted Street suffix standardised Address re-cased Gender normalised
ENR-115880	ENR	Joseph X Washington	1992-03-12	UHC-01161-96	—	3388 Bayshore Dr, San Diego, CA, 92148	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Whitespace trimmed
ENR-137059	ENR	Patrick B Jacoobs	1971-01-09	UHC-46572-14	9213298293	2987 Elm St, Eden Prairie, MN, 55389	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-137060	ENR	Patrick B Jacoobs	1971-01-09	UHC-46572-14	9213298293	2987 Elm St, Eden Prairie, MN, 55389	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
ENR-133100	ENR	Gloria Clark	1976-08-27	UHC-28114-30	7976787660	5774 Indian School Rd, Sacramento, CA, 95882	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
CLM-407737	CLM	Betty E Boyd	2001-09-14	—	5054181973	1692 Sage Ct, Mesa, AZ, 85280	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
CLM-407757	CLM	Doris Brown	1963-07-09	UHC-03661-81	—	5032 Lake View Rd, Tempe, AZ	0.68	ZIP missing Gender normalised Whitespace trimmed Placeholder values cleared
ENR-130521	ENR	Nick C Bradley	2006-03-27	UHC-85987-71	4087121957	4519 Palm Dr, Eden Prairie, MN, 55331	0.68	Street suffix standardised Address re-cased Gender normalised Whitespace trimmed
ENR-133830	ENR	Austin V Evans	1974-06-26	UHC-08309-61	4894475520	6408 Camelback Rd, Houston, TX, 77068	0.68	Phone reformatted Street suffix standardised Address re-cased Gender normalised
TPA-61352	TPA	Kimberly Bell	1938-02-18	—	5787019905	9241 Elm St, Mesa, AZ, 85270	0.68	Two-digit birth year State code upper-cased Gender normalised Placeholder values cleared
ENR-135550	ENR	Isabella Barnes	1995-09-02	UHC-98826-91	2236578131	5646 Elm St, Fresno, CA, 93724	0.68	Name split from “Last, First”Date of birth reformatted Gender normalised Placeholder values cleared
ENR-141161	ENR	Richard Medina	1972-05-09	UHC-46415-43	—	3811 Mesa Dr, Chandler, AZ, 85214	0.68	City re-cased State name converted to code Gender normalised Placeholder values cleared

16,828 rows, page 245 of 337Previous Next