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 “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
ENR-106498	ENR	Catherine X Garcia	1965-03-14	UHC-49707-14	6736093324	95 Baseline Rd, Chandler, AZ	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-115316	ENR	Terry K Coleman	1939-09-10	UHC-28889-03	7553533818	9252 Lake View Rd, Gilbert, AZ	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-138301	ENR	Sandra Barnes	1941-11-11	UHC-80935-12	8986438361	7153 Bayshore Dr, Houston, TX, 77031	0.48	Name split from “Last, First”Date of birth reformatted Member ID reformatted SSN last four extracted+4 more
ENR-127833	ENR	Alexis Payne	1960-09-09	UHC-05678-36	8432121327	309 Indian School Rd, Phoenix, AZ, 85062	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-129395	ENR	Amanda Brooks	1966-05-17	UHC-53265-89	3354943327	497 Canyon Rd, Nashville, TN	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-121607	ENR	Terry Nunez	1975-12-04	UHC-45934-01	3813945129	4095 Main St, Phoenix, AZ, 85099	0.48	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+4 more
ENR-129761	ENR	Edward L Jenkins	1970-06-11	UHC-81374-07	6214437611	7960 River Rd Apt 20, Minneapolis, MN, 55478	0.48	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+4 more
ENR-114854	ENR	Megan Brown	1999-05-07	UHC-23638-95	7673777536	6811 Grand Ave, Tempe, AZ	0.48	Phone reformatted Member ID reformatted SSN last four extracted Street suffix standardised+4 more
ENR-125501	ENR	Marilyn Ray	1980-11-13	UHC-54757-66	9055771398	6694 Sage Ct, Charlotte, NC, 28294	0.48	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+4 more
ENR-137803	ENR	Jonathan Z Ramirez	1962-03-14	UHC-25636-58	2168636861	995 Spring St, Columbus, OH, 43276	0.48	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+4 more
ENR-102177	ENR	Grace M Valdez	2002-08-14	UHC-35478-16	9686821189	2005 Elm St, Jacksonville, FL, 32298	0.48	Name re-cased Two-digit birth year Phone reformatted Member ID reformatted+4 more
ENR-119428	ENR	Barbara K Lynch	1961-05-26	UHC-36424-15	4008244818	6512 Sage Ct, Nashville, TN, 37258	0.48	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+4 more
ENR-117825	ENR	Fatima Espinoza	1944-08-11	UHC-02164-70	6835467499	7168 Church St, Denver, CO, 80221	0.48	Name split from “Last, First”Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-101466	ENR	Christopher U Montgomery	2002-04-21	UHC-85412-78	—	3292 Apache Blvd, Tampa, FL, 33623	0.48	Name re-cased Date of birth reformatted SSN last four extracted Street suffix standardised+4 more
ENR-133537	ENR	Jean Brooks	2004-02-06	UHC-50329-04	7979598087	9313 Meadow Ln, Tampa, FL, 33671	0.48	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+4 more
ENR-127977	ENR	Patricia Perry	1975-08-04	UHC-59294-16	3325561529	6200 Grand Ave, Las Vegas, NV, 89114	0.48	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-100070	ENR	Karen A Green	1978-04-13	UHC-50857-06	9763288295	6560 Ocean Ave, Chandler, AZ, 85253	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-127852	ENR	Virginia N Ray	1956-07-22	UHC-17642-30	9372571397	350 Union St, Phoenix, AZ, 85045	0.48	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-141129	ENR	Michelle A Lynch	1967-09-11	UHC-07856-55	6046847334	3435 Meadow Ln, Plano, TX, 75021	0.48	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+4 more
ENR-104833	ENR	Diego K George	2000-06-14	UHC-74759-55	2675091606	4258 Sage Ct, Minneapolis, MN, 55424	0.48	Name split from “Last, First”Date of birth reformatted Phone reformatted SSN last four extracted+4 more
ENR-100499	ENR	Bryan M Lucas	1993-06-22	UHC-39542-79	4226425082	487 Harbor Blvd, Los Angeles, CA, 90026	0.48	Two-digit birth year Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-130610	ENR	Johsua Moraes	1986-07-14	UHC-14391-17	5097041068	2252 Spring St, Seattle, WA	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-125788	ENR	Dylan O Robinson	2007-07-15	UHC-25806-40	5043219582	3396 Maple Ave Apt 14, Orlando, FL, 32819	0.48	Name re-cased Phone reformatted SSN last four extracted Unit split from street+4 more
ENR-106648	ENR	David Lynch	1973-03-08	UHC-33248-89	3677903060	8297 Forest Ave, Tampa, FL	0.48	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+4 more
ENR-116649	ENR	Maria F Perry	1979-04-28	UHC-32511-56	2539748266	6760 Willow Ct, Sacramento, CA, 95885	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-114444	ENR	Debra Fernandez	1977-09-23	UHC-61165-26	6043178586	3489 Ridge Rd, Jacksonville, FL, 32236	0.48	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+4 more
ENR-123608	ENR	Ryan P Rogers	1988-02-01	UHC-87700-61	7372214903	8822 Cedar Ln, Atlanta, GA	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-137569	ENR	Katherine Padila	1943-06-08	UHC-78445-75	9416774613	4199 Ridge Rd, Seattle, WA, 98116	0.48	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+4 more
ENR-109710	ENR	Gerald Bailey	1939-07-16	UHC-38263-55	3892274811	6098 Washington St, Plano, TX, 75064	0.48	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-107598	ENR	Daniiel D Roberts	2005-12-26	UHC-94741-83	7797070570	631 Sunset Blvd, Sacramento, CA, 95832	0.48	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted+4 more
ENR-100362	ENR	Alice R Hudson	1997-06-04	UHC-39004-68	8112174753	5423 Bayshore Dr, Fresno, CA, 93714	0.48	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-104451	ENR	Austin B Reid	1941-04-21	UHC-86036-53	4433651405	1361 Pine Dr, Tampa, FL, 33631	0.48	Name re-cased Two-digit birth year Phone reformatted SSN last four extracted+4 more
ENR-104450	ENR	Austin B Reid	1941-04-21	UHC-86036-53	4433651405	1361 Pine Dr, Tampa, FL, 33631	0.48	Name re-cased Two-digit birth year Phone reformatted SSN last four extracted+4 more
ENR-118655	ENR	Kayla Alvarez	1965-02-05	UHC-80479-03	2013970498	2707 Church St, Seattle, WA	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-122884	ENR	Shirley Griffin	2008-09-22	UHC-80810-02	—	3836 Oak St, Denver, CO, 80262	0.48	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased+4 more
ENR-110117	ENR	John D Bradley	1973-03-13	UHC-80398-48	5965673213	349 River Rd, Chandler, AZ, 85266	0.48	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-134164	ENR	Scott Gardner	—	UHC-41805-67	2747519604	7087 Ridge Rd, Glendale, AZ, 85312	0.48	Date of birth reformatted Date of birth unreadable Phone reformatted Member ID reformatted+4 more
ENR-138099	ENR	Keith P Clark	1960-05-21	UHC-71395-76	8818275243	5744 Apache Blvd, Seattle, WA, 98198	0.48	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+4 more
ENR-102861	ENR	Stephen Mason	1949-01-20	UHC-11372-10	—	5037 Ocean Ave, Columbus, OH, 43224	0.48	Name re-cased Phone missing area code SSN last four extracted Street suffix standardised+4 more
ENR-127700	ENR	Joyce S Perez	1958-08-13	UHC-34295-45	6864413846	8692 Hillcrest Rd, Miami, FL, 33106	0.48	Date of birth reformatted Member ID reformatted SSN last four extracted Street suffix standardised+4 more
ENR-129439	ENR	Elijah Cerr	1980-02-25	UHC-17312-61	5356770932	8995 Sunset Blvd, Miami, FL, 33157	0.48	Name split from “Last, First”Date of birth reformatted Phone reformatted SSN last four extracted+4 more
ENR-126821	ENR	Jesse Thomas	1968-01-15	UHC-48971-29	3866148478	1706 Valley View Dr, Miami, FL, 33168	0.48	Two-digit birth year Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-114765	ENR	Russell V Donald	1974-02-22	UHC-63213-46	7492927220	5913 Maple Ave, Houston, TX, 77046	0.48	Name re-cased SSN last four extracted Street suffix standardised Address re-cased+4 more
ENR-115085	ENR	Victoria O Cooper	1960-10-11	UHC-00539-49	3323998149	6043 Forest Ave, Charlotte, NC	0.48	Name re-cased SSN last four extracted City re-cased State name converted to code+4 more
ENR-117444	ENR	Dorothy James	1986-02-16	UHC-93469-77	4016111175	8094 Indian School Rd, Eden Prairie, MN, 55392	0.48	Date of birth reformatted Phone reformatted SSN last four extracted Street suffix standardised+4 more
ENR-127383	ENR	Thomas Lynch	1955-12-03	UHC-15368-92	4057663091	7119 Maple Ave, Atlanta, GA, 30364	0.48	Name split from “Last, First”Date of birth reformatted Phone reformatted SSN last four extracted+4 more
ENR-107536	ENR	Kyle Dominguez	1953-04-28	UHC-47896-19	2809134875	1431 Grand Ave Apt 7, Columbus, OH, 43217	0.48	Name re-cased Date of birth reformatted SSN last four extracted Unit split from street+4 more
ENR-135766	ENR	Alan Gray	2005-10-03	UHC-03446-34	3762867399	4622 Jefferson Ave, Atlanta, GA, 30320	0.48	Phone reformatted SSN last four extracted Street suffix standardised Address re-cased+4 more
ENR-141329	ENR	Becky Q Jones	1967-05-27	UHC-46908-53	7535833803	7642 Lincoln Way Apt 9, Seattle, WA, 98182	0.48	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
ENR-111680	ENR	Berb S Weaver	1958-06-24	UHC-62451-86	5819129100	4612 Cedar Ln, Phoenix, AZ, 85009	0.48	Middle initial moved out of first name SSN last four extracted Street suffix standardised Address re-cased+4 more

1,767 rows, page 6 of 36Previous Next