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 “City re-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagCity re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-113050	ENR	Martha G Gonzales	1941-04-22	UHC-09453-25	4919825842	1995 Church St, Atlanta, GA	0.76	Name re-cased City re-cased ZIP missing Plan code upper-cased+2 more
ENR-141464	ENR	Natalie P Ryan	2004-06-05	UHC-86274-64	3095522514	8410 Central Ave, Austin, TX, 78731	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-134116	ENR	Wei D Arnold	1976-05-23	UHC-93430-91	5936496455	9213 Pine Dr, Glendale, AZ, 85331	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-130633	ENR	Marina Campbell	1992-06-07	UHC-52447-06	4639530818	3807 Hillcrest Rd, Seattle, WA, 98193	0.76	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-137763	ENR	Billy Z Vargas	1955-10-23	UHC-55865-83	—	4649 Sage Ct, San Antonio, TX, 78278	0.76	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-104854	ENR	Gabriel Gonzalez	1997-11-09	UHC-78358-58	6343952193	7576 Valley View Dr, Jacksonville, FL, 32236	0.76	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-109236	ENR	Kayla G Hunter	1957-08-22	UHC-85413-02	4474031013	8984 Cedar Ln, Scottsdale, AZ, 85239	0.76	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-134623	ENR	Anna F Murray	1999-08-04	UHC-80172-35	5719060986	7304 Highland Ave, Atlanta, GA, 30376	0.76	Date of birth reformatted Phone reformatted City re-cased State name converted to code+2 more
ENR-129918	ENR	Charlotte N Hanson	1963-05-10	UHC-64461-42	7994257241	1822 Mountain View Dr, Charlotte, NC, 28272	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-122480	ENR	Sara T Wagner	1987-08-20	UHC-73875-97	—	841 Broadway, Orlando, FL	0.76	Member ID reformatted Address re-cased City re-cased ZIP missing+2 more
ENR-122524	ENR	Valentina Valdez	1957-12-13	UHC-40345-86	4057536555	1921 Broadway, Glendale, AZ, 85399	0.76	Name split from “Last, First”Phone reformatted Member ID reformatted City re-cased+2 more
ENR-139519	ENR	Mariana C Nelson	1967-03-19	UHC-30205-72	8625517740	3855 Cedar Ln, Charlotte, NC, 28228	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-140960	ENR	Terry Williams	1939-10-17	UHC-02175-32	8036281479	2679 Ocean Ave, Glendale, AZ, 85377	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-124422	ENR	Sophiia Snyder	1943-04-09	UHC-97828-62	6444799872	9603 Jefferson Ave, Fresno, CA, 93747	0.76	Name re-cased Phone reformatted SSN last four extracted City re-cased+2 more
ENR-135200	ENR	Deborah Martin	1956-07-01	UHC-52139-04	5992625532	8438 Ridge Rd, Houston, TX, 77077	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-118452	ENR	Keith T Hamilton	1946-08-08	UHC-65870-45	2859189973	8584 River Rd, Nashville, TN, 37260	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-134480	ENR	Jacob G King	1993-03-27	UHC-51250-43	2788117964	8330 Indian School Rd Apt 11, Jacksonville, FL, 32272	0.76	Date of birth reformatted Phone reformatted Unit split from street City re-cased+2 more
ENR-127617	ENR	Bradley M Laane	1938-01-06	UHC-88564-99	9752565349	9269 Valley View Dr, Sacramento, CA, 95818	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-133458	ENR	Angela Vargas	1950-08-24	UHC-08809-52	8589951572	1565 Ridge Rd, Seattle, WA, 98121	0.76	Date of birth reformatted Phone reformatted SSN last four extracted City re-cased+2 more
ENR-132298	ENR	Betty Kennedy	1966-12-18	UHC-07970-67	9128253165	1089 Indian School Rd, Sacramento, CA, 95859	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-124702	ENR	Wei Jenkins	2000-12-28	UHC-93230-96	8294059908	4632 Jefferson Ave, Mesa, AZ, 85233	0.76	Name re-cased Phone reformatted City re-cased ZIP+4 trimmed+2 more
ENR-118965	ENR	Hiroshi G Kelly	1968-10-16	UHC-15600-78	5298318905	1816 Jefferson Ave, Mesa, AZ, 85206	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-141394	ENR	Jennifer M Schmidt	2003-07-05	UHC-29055-65	6064750635	3969 Camelback Rd, Los Angeles, CA, 90096	0.76	Phone reformatted City re-cased State code upper-cased Gender normalised+2 more
ENR-141510	ENR	Seean Hamilton	1939-06-15	UHC-23119-97	5802818482	4965 Palm Dr, Seattle, WA, 98113	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-142670	ENR	Thomas M Marshall	—	UHC-57129-71	5044031070	5207 Central Ave, Houston, TX, 77057	0.76	Date of birth unreadable Phone reformatted Member ID reformatted City re-cased+2 more
ENR-138605	ENR	Omar X Ford	2003-08-01	UHC-27228-51	9675232713	2289 Ridge Rd, San Antonio, TX, 78299	0.76	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-121554	ENR	Harold Rojas	1996-10-25	UHC-16881-88	7497236364	4310 Ridge Rd, Fresno, CA, 93794	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-102055	ENR	Vincent M Dixon	1965-12-09	—	3987935563	2436 Maple Ave, Austin, TX, 78700	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-134620	ENR	Jack A Sullivan	1988-07-24	UHC-56237-02	2826020159	4947 Pine Dr, Orlando, FL, 32825	0.76	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+2 more
ENR-133374	ENR	Bveerly Sandoval	1987-01-04	UHC-71693-15	6098224981	2141 Meadow Ln, Glendale, AZ, 85312	0.76	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-106200	ENR	Yuki Espinoza	1951-06-16	UHC-32418-96	2243679502	387 Harbor Blvd, Charlotte, NC, 28206	0.76	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-116880	ENR	Jerry Romero	1964-03-24	UHC-98312-99	2679081891	855 Lake View Rd, Tucson, AZ, 85786	0.76	Name split from “Last, First”Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-101658	ENR	Sofia Boyd	1999-11-10	UHC-60032-56	8718868419	3819 Forest Ave, Seattle, WA, 98176	0.76	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-113411	ENR	Denise Q Guerrero	1997-11-18	UHC-92483-29	5847113510	4184 Highland Ave, Tucson, AZ, 85734	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-105468	ENR	Ryan Mendez	1969-06-26	UHC-96450-94	8965994565	2216 Lake View Rd, Fresno, CA, 93714	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-135132	ENR	Samantha C Marshall	2002-11-04	UHC-35254-25	5387852236	1627 Broadway, Minneapolis, MN, 55490	0.76	Date of birth reformatted Address re-cased City re-cased State name converted to code+2 more
ENR-135131	ENR	Samantha C Marshall	2002-11-04	UHC-35254-25	5387852236	1627 Broadway, Minneapolis, MN, 55490	0.76	Date of birth reformatted Address re-cased City re-cased State name converted to code+2 more
ENR-135211	ENR	Charlotte U Dixon	1981-07-20	UHC-64837-59	6177349728	8587 Camelback Rd, Columbus, OH, 43276	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-114071	ENR	Camila Knight	1975-02-01	UHC-56856-16	9185685593	531 Baseline Rd, Charlotte, NC, 28297	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-104165	ENR	Adam J Campell	2007-07-14	UHC-00506-50	8265384459	3378 Palm Dr, Houston, TX, 77025	0.76	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-118235	ENR	Albert Marshall	1991-07-04	UHC-01330-32	2196705939	8011 Maple Ave, Plano, TX, 75058	0.76	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-102780	ENR	Tyler P Austin	1973-02-19	UHC-63014-58	5016668944	1955 Desert Sky Blvd, Mesa, AZ, 85284	0.76	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-132224	ENR	Dennis W Reyes	1995-09-03	UHC-66329-75	8566069704	4946 Mesa Dr, Charlotte, NC, 28254	0.76	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-102270	ENR	Abigail W Snyder	1970-01-20	UHC-21758-85	4774688648	565 Ocean Ave, Plano, TX, 75087	0.76	Name re-cased Phone reformatted City re-cased State name converted to code+2 more
ENR-139572	ENR	Logan I Richardson	1973-03-13	UHC-24032-64	2955933247	1361 Baseline Rd, Fresno, CA	0.76	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-126500	ENR	Gregory Hamilton	1969-12-02	UHC-54999-02	6265361954	4040 Ridge Rd, Nashville, TN, 37267	0.76	Name re-cased Date of birth reformatted City re-cased Gender normalised+2 more
ENR-128389	ENR	Sofia E Bowman	1964-12-24	UHC-96791-92	6267192674	5205 Oak St, San Antonio, TX, 78236	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-132928	ENR	Tyler R Hicks	1946-02-24	UHC-11731-86	7384852807	7491 Harbor Blvd, Atlanta, GA, 30388	0.76	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-103125	ENR	Anna Dixon	1967-09-20	UHC-96020-28	5837544786	4785 Maple Ave, Tampa, FL, 33684	0.76	Name re-cased Phone reformatted SSN last four extracted City re-cased+2 more
ENR-122940	ENR	Terry C Le	1982-05-18	UHC-29632-13	4119554078	6133 Willow Ct, Plano, TX, 75035	0.76	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more

8,423 rows, page 99 of 169Previous Next