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

Enrollment, flag “Placeholder values cleared”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagPlaceholder values clearedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-130958	ENR	Julia Walker	1973-07-13	UHC-38007-53	—	8617 Apache Blvd, Plano, TX	0.68	ZIP missing Gender normalised Whitespace trimmed Placeholder values cleared
ENR-121751	ENR	Shirley Diaz	1960-11-11	UHC-24783-79	7149270807	6942 Sage Ct Apt 15, Austin, TX, 78743	0.68	Unit split from street Street suffix standardised Address re-cased Placeholder values cleared
ENR-107222	ENR	Ashley J Roberts	—	UHC-42068-49	6529182634	—	0.68	Name split from “Last, First”Date of birth unreadable Email lower-cased Placeholder values cleared
ENR-112836	ENR	Cynthia Y Ford	1951-09-23	UHC-92645-67	5759134166	2718 Ridge Rd, Los Angeles, CA, 90098	0.68	Street suffix standardised Address re-cased ZIP+4 trimmed Placeholder values cleared
ENR-132469	ENR	Theresa A Padilla	1944-12-07	UHC-76628-92	—	5793 Hillcrest Rd Apt 3, Columbus, OH	0.68	Name re-cased Unit split from street ZIP missing Placeholder values cleared
ENR-134373	ENR	Debra E Ryan	1963-12-24	UHC-49221-41	—	1623 Mountain View Dr, Mesa, AZ, 85266	0.68	Street suffix standardised Address re-cased State name converted to code Placeholder values cleared
ENR-131474	ENR	Lawrence Hayes	2003-11-18	UHC-66712-26	—	1346 Mesa Dr, San Diego, CA, 92171	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-101218	ENR	Sofia T Carr	1950-08-08	UHC-88392-63	—	3946 Lincoln Way, San Antonio, TX, 78291	0.68	Name re-cased Two-digit birth year Gender normalised Placeholder values cleared
ENR-121015	ENR	Gerald M Nelson	1995-12-21	UHC-75926-86	—	2068 Elm St, Glendale, AZ, 85301	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-110396	ENR	Alice Hayes	2000-06-23	UHC-80765-96	3306052236	8618 Washington St, San Diego, CA, 92129	0.68	Name split from “Last, First”Phone reformatted Gender normalised Placeholder values cleared
ENR-110397	ENR	Alice Hayes	2000-06-23	UHC-80765-96	3306052236	8618 Washington St, San Diego, CA, 92129	0.68	Name split from “Last, First”Phone reformatted Gender normalised Placeholder values cleared
ENR-128833	ENR	Mason Sanchez	1944-03-26	UHC-88232-95	—	3167 Market St, Las Vegas, NV, 89174	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
ENR-105570	ENR	Helen A Reid	1977-12-18	UHC-20237-14	2815645615	1376 Mesa Dr Apt 10, Orlando, FL, 32851	0.68	Two-digit birth year Phone reformatted Unit split from street Placeholder values cleared
ENR-121659	ENR	Willie Walker	1978-11-27	UHC-08462-20	—	6371 Meadow Ln, Seattle, WA, 98110	0.68	Street suffix standardised Address re-cased ZIP+4 trimmed Placeholder values cleared
ENR-100024	ENR	Margaret Bell	2006-07-25	UHC-39574-66	9864893045	4859 Elm St, Tampa, FL, 33618	0.68	SSN last four extracted Street suffix standardised Address re-cased Placeholder values cleared
ENR-104729	ENR	Justin K Fox	1999-09-25	UHC-85137-13	—	5157 Cedar Ln, Nashville, TN, 37248	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
ENR-109048	ENR	Mark Kelley	1953-05-14	UHC-46449-29	—	3775 Camelback Rd, Mesa, AZ	0.68	Street suffix standardised Address re-cased ZIP missing Placeholder values cleared
ENR-141259	ENR	Frances R Bowman	1966-06-16	UHC-68468-73	—	3921 Camelback Rd, Orlando, FL, 32873	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-101602	ENR	Denise Young	—	UHC-41868-77	4146877186	3958 Sunset Blvd, Tampa, FL, 33655	0.68	Date of birth missing Street suffix standardised Address re-cased Placeholder values cleared
ENR-138802	ENR	Jacob Peters	1997-09-09	UHC-44382-28	—	—	0.68	Name re-cased Phone missing area code Gender normalised Placeholder values cleared
ENR-129105	ENR	Luis V Freeman	1999-10-21	UHC-92466-19	—	7776 Indian School Rd, Chandler, AZ	0.68	ZIP missing Email lower-cased Gender normalised Placeholder values cleared
ENR-120002	ENR	Daniel Reid	1970-11-26	UHC-30086-83	8324186922	9562 Forest Ave, Atlanta, GA, 30321	0.68	Two-digit birth year Street suffix standardised Address re-cased Placeholder values cleared
ENR-111303	ENR	Juhn Hudson	1999-01-25	UHC-10482-82	—	9203 Broadway, Miami, FL, 33199	0.68	Name split from “Last, First”Phone missing area code Whitespace trimmed Placeholder values cleared
ENR-107895	ENR	Greg H Garcia	1972-09-10	UHC-50973-02	5898231014	6288 Meadow Ln, Eden Prairie, MN, 55372	0.68	Two-digit birth year Phone reformatted Gender normalised Placeholder values cleared
ENR-121958	ENR	Jonathan M Dunnn	1942-10-25	UHC-19168-37	3582511527	7019 Union St, Jacksonville, FL, 32255	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
ENR-132313	ENR	Elizabeth M Jones	1996-02-25	UHC-45211-18	4076820738	9833 Oak St, Los Angeles, CA, 90087	0.68	Two-digit birth year Street suffix standardised Address re-cased Placeholder values cleared
ENR-131086	ENR	Ronald C Lee	1992-01-02	UHC-60511-78	4692263918	4093 Ocean Ave, San Antonio, TX, 78206	0.68	Name split from “Last, First”Phone reformatted State name converted to code Placeholder values cleared
ENR-112949	ENR	Ruth O Cole	1966-12-16	UHC-17849-48	6157496335	2598 Broadway, Jacksonville, FL, 32232	0.68	Name split from “Last, First”Two-digit birth year Phone reformatted Placeholder values cleared
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-108527	ENR	Mateo A Vazquez	1964-10-05	UHC-94454-99	5975894714	5141 Church St, Orlando, FL	0.68	Street suffix standardised Address re-cased ZIP missing Placeholder values cleared
ENR-130577	ENR	Sean I Guerrero	1950-04-09	UHC-78198-88	—	86 Market St, Tampa, FL, 33617	0.68	Phone missing area code Street suffix standardised Address re-cased Placeholder values cleared
ENR-126477	ENR	Marilyn T Matthews	1967-05-04	UHC-96493-55	—	9390 Lincoln Way, Chandler, AZ, 85241	0.68	Middle initial moved out of first name Two-digit birth year City re-cased Placeholder values cleared
ENR-138131	ENR	Thomas I Snyder	1999-07-18	UHC-50742-28	—	2100 Baseline Rd, Las Vegas, NV, 89116	0.68	Date of birth reformatted State name converted to code ZIP+4 trimmed Placeholder values cleared
ENR-116641	ENR	Joyce G Jensen	1963-09-14	UHC-85340-79	3107563519	2014 Lake View Rd, Austin, TX, 78751	0.68	Two-digit birth year Street suffix standardised Address re-cased Placeholder values cleared
ENR-111197	ENR	Philip U Carlson	1949-02-09	UHC-39625-55	4673875117	7382 Highland Ave, Tempe, AZ, 85258	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
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-125916	ENR	Valentina B Ramirez	1985-01-05	UHC-86890-39	—	6966 Market St Apt 12, Las Vegas, NV, 89196	0.68	Unit split from street Street suffix standardised Address re-cased Placeholder values cleared
ENR-116150	ENR	Ben Elliott	1948-03-08	—	—	5730 Sunset Blvd, San Antonio, TX, 78208	0.68	Phone missing area code Street suffix standardised Address re-cased Placeholder values cleared
ENR-138553	ENR	Logan P Sanders	1962-11-27	UHC-91805-80	—	5114 Forest Ave Apt 26, Fresno, CA, 93769	0.68	Unit split from street State code upper-cased ZIP+4 trimmed Placeholder values cleared
ENR-116257	ENR	Abby Wright	1993-07-15	—	8367543780	8897 Ocean Ave, Austin, TX, 78758	0.68	Street suffix standardised Address re-cased ZIP+4 trimmed Placeholder values cleared
ENR-138237	ENR	Joe L Armstrong	1965-12-08	UHC-91183-10	—	2153 Meadow Ln, Austin, TX, 78721	0.68	Street suffix standardised Address re-cased ZIP+4 trimmed Placeholder values cleared
ENR-121972	ENR	Juan T Richards	1968-07-12	UHC-31607-39	—	5895 Church St, Glendale, AZ, 85384	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
ENR-101733	ENR	Jake Buns	—	UHC-42614-37	—	971 Camelback Rd, Denver, CO, 80201	0.68	Date of birth missing Street suffix standardised Address re-cased Placeholder values cleared
ENR-127823	ENR	Jesse Knight	—	UHC-10453-53	—	5064 Desert Sky Blvd, Fresno, CA, 93716	0.68	Date of birth missing Street suffix standardised Address re-cased Placeholder values cleared
ENR-120047	ENR	Elijah Hansen	1966-06-28	UHC-64874-13	5639294848	6700 Jefferson Ave # 240, Phoenix, AZ, 85037	0.68	Two-digit birth year Phone reformatted Unit split from street Placeholder values cleared
ENR-141642	ENR	Henry N Rojas	1974-05-02	UHC-08771-38	—	7604 Hillcrest Rd, Tempe, AZ	0.68	Middle initial moved out of first name ZIP missing Whitespace trimmed Placeholder values cleared
ENR-121968	ENR	Grace P Hernandez	1951-12-14	UHC-88884-27	2075289147	1280 Sunset Blvd, Chandler, AZ, 85229	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
ENR-100820	ENR	Roger P Tran	1963-08-20	UHC-00583-18	7616571574	2965 Camelback Rd, San Antonio, TX, 78238	0.68	Two-digit birth year Street suffix standardised Address re-cased Placeholder values cleared
ENR-120359	ENR	Madison T Padilla	1968-11-07	UHC-93662-76	4164693978	6184 Ridge Rd, Miami, FL, 33178	0.68	Name split from “Last, First”Phone reformatted Gender normalised Placeholder values cleared
ENR-117345	ENR	Luis C Weaver	1970-06-07	UHC-64638-57	—	—	0.68	Name split from “Last, First”Phone missing area code Member ID reformatted Placeholder values cleared

16,916 rows, page 130 of 339Previous Next