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 “ZIP missing”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP missingClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-420158	CLM	—Junk	1946-11-05	UHC-87019-89	—	3708 Apache Blvd, Scottsdale, AZ	0.66	Date of birth reformatted ZIP missing Whitespace trimmed Placeholder values cleared+1 more
ENR-111096	ENR	Randy T Fisher	1946-10-27	UHC-12537-46	—	4312 Sage Ct, Minneapolis, MN	0.66	ZIP missing Email lower-cased Gender normalised Whitespace trimmed+1 more
CLM-420748	CLM	Walter Hernandez	2001-11-13	—	—	2225 Ridge Rd, Nashville, TN	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+1 more
ENR-140224	ENR	Cynthia Z Stone	1942-04-06	UHC-70398-69	2654255337	3601 Canyon Rd, Fresno, CA	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
ENR-106181	ENR	Abigail Dean	1998-09-02	UHC-16177-59	6079501508	6212 Forest Ave, Las Vegas, NV	0.66	Date of birth reformatted Phone reformatted ZIP missing Gender normalised+1 more
TPA-62078	TPA	Diana Z Long	2007-11-05	—	—	7104 Sage Ct, Houston, TX	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+1 more
PRV-29594	PRV	Eugene V Daniels	1994-02-05	—	6908189684	9891 Oak St, Mesa, AZ	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
ENR-104394	ENR	Benjamin Stewart	1945-06-25	UHC-28478-43	3314713960	2391 Willow Ct, Tempe, AZ	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
ENR-115019	ENR	Madison Moreno	1946-08-02	UHC-53709-86	5533956010	4686 Ocean Ave, Eden Prairie, MN	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
ENR-128201	ENR	Mateo Q Oliver	1973-09-12	UHC-31496-33	4647906533	3573 Grand Ave, Scottsdale, AZ	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
ENR-132788	ENR	Elijah D Sullivan	1966-08-01	UHC-92796-98	7953509691	92 Market St, Denver, CO	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
TPA-61167	TPA	Keith Collins	1980-12-13	—	8028729234	7882 Lincoln Way Apt 14, Plano, TX	0.66	Date of birth reformatted Phone reformatted Unit split from street ZIP missing+1 more
PRV-29570	PRV	Linda Bishop	1942-05-16	UHC-76949-11	4547007895	1478 Maple Ave # 884, Jacksonville, FL	0.66	Name re-cased Date of birth reformatted Unit split from street ZIP missing+1 more
CLM-408558	CLM	Nathan Guerrero	1992-10-27	—	7887717478	8022 Sunset Blvd, Minneapolis, MN	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
PRV-23142	PRV	Jacqueline F Flores	1939-12-16	UHC-03070-53	4285278069	4401 Union St, Las Vegas, NV	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+1 more
PRV-24202	PRV	Tyler M Woods	1982-04-20	UHC-14817-37	—	7877 Ridge Rd, Houston, TX	0.66	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+1 more
ENR-121561	ENR	Theresa Gutierrez	1996-02-01	UHC-87765-01	8984441622	2725 Palm Dr, Miami, FL	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
ENR-107975	ENR	Carol H Rose	1947-08-13	UHC-20656-15	8334854430	2218 Apache Blvd, Orlando, FL	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
ENR-107976	ENR	Carol H Rose	1947-08-13	UHC-20656-15	8334854430	2218 Apache Blvd, Orlando, FL	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
ENR-128899	ENR	Fatima Y Thoams	—	UHC-12199-64	4776529298	9534 Sage Ct, Scottsdale, AZ	0.66	Date of birth missing Phone reformatted ZIP missing Whitespace trimmed+1 more
ENR-111000	ENR	Sarah P Greene	2001-06-16	—	9029335743	8369 Canyon Rd, Los Angeles, CA	0.66	Two-digit birth year Phone reformatted ZIP missing Email lower-cased+1 more
ENR-139630	ENR	Christian Simmons	1996-09-04	UHC-30204-74	4008592499	8494 Central Ave, Phoenix, AZ	0.66	Phone reformatted State name converted to code ZIP missing Whitespace trimmed+1 more
ENR-122040	ENR	Vincent P Santiago	1945-10-20	UHC-71651-40	5918694351	7380 Ocean Ave, Atlanta, GA	0.66	Date of birth reformatted Street suffix standardised Address re-cased State code upper-cased+1 more
ENR-126694	ENR	Gregory X Rivera	1956-02-21	UHC-01682-52	9426628580	40 Park Pl, Orlando, FL	0.66	Name re-cased Phone reformatted Street suffix standardised Address re-cased+1 more
TPA-60697	TPA	Jacck Barnes	1940-07-25	UHC-58851-08	—	5734 Washington St, Atlanta, GA	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
TPA-60698	TPA	Jacck Barnes	1940-07-25	UHC-58851-08	—	5734 Washington St, Atlanta, GA	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
ENR-102112	ENR	Rachel W Carter	1979-05-22	UHC-92091-45	3437880068	5352 Ridge Rd, Houston, TX	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
CLM-416585	CLM	Stephen Meyer	1994-05-10	UHC-06552-81	—	3258 Ridge Rd, San Diego, CA	0.66	State code upper-cased ZIP missing Gender normalised Whitespace trimmed+1 more
CLM-412159	CLM	Benjamin Rice	2001-11-22	—	8745265526	5390 Baseline Rd, Los Angeles, CA	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
ENR-129625	ENR	Jonathan Garrett	1961-02-22	UHC-48138-96	9173091687	5631 Church St, Denver, CO	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
TPA-50931	TPA	Gloria Hamilton	2008-01-22	—	—	4463 Lake View Rd, Tampa, FL	0.66	Name split from “Last, First”Date of birth reformatted ZIP missing Whitespace trimmed+1 more
CLM-431187	CLM	Jason Kelley	1949-01-20	UHC-48760-69	—	3706 Valley View Dr, Houston, TX	0.66	Name re-cased Date of birth reformatted ZIP missing Gender normalised+1 more
CLM-412357	CLM	Marcus Cooper	1952-08-23	UHC-91372-60	—	1213 Indian School Rd, Glendale, AZ	0.66	Name split from “Last, First”City re-cased ZIP missing Whitespace trimmed+1 more
ENR-117814	ENR	Natalie Q Bell	2005-03-27	UHC-15700-52	—	2327 Highland Ave, Sacramento, CA	0.66	Street suffix standardised Address re-cased State code upper-cased ZIP missing+1 more
PRV-25342	PRV	Lisa Q Lee	1970-07-14	—	5949070880	589 Elm St, Nashville, TN	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
TPA-55808	TPA	Bruce Hcks	1978-02-20	—	—	632 Sunset Blvd, Charlotte, NC	0.66	Name re-cased ZIP missing Gender normalised Whitespace trimmed+1 more
ENR-120334	ENR	Samuel U Castro	1975-05-08	UHC-99010-79	9047985083	216 Indian School Rd, Dallas, TX	0.66	Name re-cased Two-digit birth year Phone reformatted ZIP missing+1 more
ENR-129007	ENR	Austin McDonald	1968-01-21	UHC-07017-18	3145343927	7465 River Rd, San Antonio, TX	0.66	Date of birth reformatted Phone reformatted State name converted to code ZIP missing+1 more
ENR-100873	ENR	Heenry Ramos	1958-10-28	UHC-39504-77	7957983532	2976 Camelback Rd, Houston, TX	0.66	Member ID reformatted Street suffix standardised Address re-cased ZIP missing+1 more
TPA-58117	TPA	Diego T Snyder	1949-08-27	—	—	8410 Valley View Dr, Columbus, OH	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
TPA-58118	TPA	Diego T Snyder	1949-08-27	—	—	8410 Valley View Dr, Columbus, OH	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
ENR-125065	ENR	Victoria Yang	1998-08-24	UHC-66165-90	8715532764	4664 Forest Ave, Gilbert, AZ	0.66	Street suffix standardised Address re-cased City re-cased ZIP missing+1 more
CLM-420851	CLM	Julia McDonald	1990-11-24	UHC-03252-20	3606643257	7526 Hillcrest Rd, Plano, TX	0.66	Name re-cased Street suffix standardised Address re-cased ZIP missing+1 more
ENR-116908	ENR	Sean T Weber	2003-08-02	UHC-37854-75	8442143874	503 Park Pl, Nashville, TN	0.66	Name re-cased Street suffix standardised Address re-cased City re-cased+1 more
TPA-52780	TPA	Frances Mason	1979-03-07	—	—	7506 Highland Ave, Scottsdale, AZ	0.66	Name re-cased Date of birth reformatted State name converted to code ZIP missing+1 more
PRV-20278	PRV	Helen Holmes	1978-08-01	UHC-13051-27	2347574996	2988 Elm St, Austin, TX	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more
PRV-21319	PRV	Russell R Elliott	2002-09-26	UHC-72403-52	7635165615	8498 Camelback Rd, San Diego, CA	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
PRV-27332	PRV	Marilyn James	1952-06-17	UHC-01639-27	8354061542	1285 Palm Dr, Glendale, AZ	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
CLM-428119	CLM	Shirely Ellis	1975-01-21	UHC-40576-59	—	7905 Church St, Phoenix, AZ	0.66	Street suffix standardised Address re-cased ZIP missing Whitespace trimmed+1 more
PRV-25704	PRV	Marilyn Barnes	1957-12-23	—	6253821548	4785 Apache Blvd, San Diego, CA	0.66	Phone reformatted Street suffix standardised Address re-cased ZIP missing+1 more

7,146 rows, page 102 of 143Previous Next