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-118596	ENR	Alice Walsh	1996-07-06	UHC-38676-90	—	7143 Elm St, Atlanta, GA, 30389	0.80	Name re-cased Member ID reformatted SSN last four extracted Placeholder values cleared
ENR-141149	ENR	Adam G Schultz	1975-10-28	UHC-81014-14	2764553652	—	0.80	Name re-cased Phone reformatted SSN last four extracted Whitespace trimmed
ENR-111859	ENR	Joe Y Wells	2005-12-07	UHC-71925-02	5809803239	4949 Spring St, Eden Prairie, MN, 55300	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Placeholder values cleared
ENR-111546	ENR	Timothy Long	1946-08-28	UHC-23521-87	—	9529 Broadway, Miami, FL, 33160	0.80	Name re-cased SSN last four extracted Whitespace trimmed Placeholder values cleared
ENR-114280	ENR	Amanda Ortiz	2003-09-19	UHC-69544-44	—	7344 Baseline Rd, Seattle, WA, 98125	0.80	Date of birth reformatted SSN last four extracted State code upper-cased Placeholder values cleared
ENR-130960	ENR	Albert Santos	1975-05-16	UHC-93883-15	7459294057	2445 Church St, Jacksonville, FL, 32229	0.80	Member ID reformatted SSN last four extracted State code upper-cased Whitespace trimmed
ENR-130781	ENR	Jerry Q Moore	1963-04-12	UHC-01331-32	8214662649	5838 Lincoln Way, Columbus, OH, 43249	0.80	Date of birth reformatted SSN last four extracted City re-cased Email lower-cased
ENR-105573	ENR	Randy Weaver	1958-01-23	UHC-09967-04	4906481293	—	0.80	Date of birth reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
ENR-111867	ENR	Charles L Dean	1989-07-25	UHC-96619-42	4833798808	2719 Spring St, Miami, FL, 33192	0.80	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted
ENR-102156	ENR	Gabriel Patterson	2008-11-22	UHC-11770-13	7347127985	8907 Main St, Charlotte, NC, 28202	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Email lower-cased
ENR-134461	ENR	Gerald M Pierce	1971-05-06	UHC-42939-55	8239381658	7921 Canyon Rd, Nashville, TN, 37254	0.80	Phone reformatted SSN last four extracted City re-cased Whitespace trimmed
ENR-130382	ENR	Jeremy C Hanson	1950-07-21	UHC-08296-83	9878231090	7782 Meadow Ln, Columbus, OH, 43278	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Whitespace trimmed
ENR-108979	ENR	Amanda Hicks	1972-10-09	UHC-66518-56	5958864136	5918 Forest Ave, Minneapolis, MN, 55439	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Email lower-cased
ENR-104959	ENR	Christian A Ferguson	1994-02-24	UHC-92838-07	5538259105	4461 Willow Ct, Houston, TX, 77007	0.80	Name re-cased SSN last four extracted Plan code upper-cased Whitespace trimmed
ENR-139182	ENR	Abigail Cunningham	1940-07-17	UHC-38115-43	5028177506	3547 Ridge Rd, Gilbert, AZ, 85298	0.80	Phone reformatted SSN last four extracted Email lower-cased Whitespace trimmed
ENR-141486	ENR	Jeffrey F Howard	2003-07-19	UHC-61119-21	—	7209 Market St, Gilbert, AZ, 85246	0.80	Name re-cased SSN last four extracted City re-cased Email lower-cased
ENR-142135	ENR	Jesse Coeman	1983-02-04	UHC-37560-46	3459386945	—	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
ENR-139000	ENR	Ralph Reyes	2001-05-26	UHC-57646-71	7286496804	—	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Placeholder values cleared
ENR-129596	ENR	Jeses Ortega	2008-08-18	UHC-92424-45	2283914020	2245 Palm Dr, Atlanta, GA, 30323	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Whitespace trimmed
ENR-121671	ENR	Alice Larson	1979-03-07	UHC-47376-36	8753120016	5606 Palm Dr, Austin, TX, 78736	0.80	Phone reformatted SSN last four extracted Email lower-cased Whitespace trimmed
ENR-132124	ENR	Aisha Dixon	1970-05-02	UHC-18503-41	8528157086	81 Park Pl, Tucson, AZ, 85764	0.80	Phone reformatted SSN last four extracted Email lower-cased Placeholder values cleared
ENR-129265	ENR	Ryan J Henry	1999-10-05	UHC-84515-49	6389556282	1659 River Rd, Tampa, FL, 33680	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Whitespace trimmed
ENR-107823	ENR	Sharon C Aguylar	1990-09-19	UHC-98678-80	6279627998	4558 Pine Dr, Atlanta, GA, 30358	0.80	Name re-cased Phone reformatted SSN last four extracted Whitespace trimmed
ENR-105763	ENR	Kimberly Murphy	1992-01-22	UHC-37472-12	4873062774	3584 Pine Dr, Sacramento, CA, 95871	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Whitespace trimmed
ENR-140436	ENR	Carol Cook	1949-05-06	UHC-10883-60	6604689244	7138 Indian School Rd, Jacksonville, FL, 32224	0.80	Phone reformatted SSN last four extracted State code upper-cased Placeholder values cleared
ENR-105967	ENR	Owens Alice	1976-01-06	UHC-31723-72	5833281428	—	0.80	Phone reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
ENR-128854	ENR	Joe Hanson	1954-07-06	UHC-36428-78	9898291402	7322 River Rd, Tempe, AZ, 85264	0.80	Name re-cased Phone reformatted SSN last four extracted Email lower-cased
ENR-116283	ENR	Lauren Lynch	1993-07-24	UHC-13897-33	3547497929	1657 Ocean Ave, San Antonio, TX, 78237	0.80	Phone reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
ENR-114896	ENR	Billy O Santiago	1995-07-25	UHC-59543-99	7029884005	6407 Church St, Gilbert, AZ, 85200	0.80	Name re-cased Phone reformatted SSN last four extracted Whitespace trimmed
ENR-137612	ENR	Robert A Stewart	1971-11-15	UHC-52370-30	3745900230	9068 Pine Dr, Tempe, AZ, 85286	0.80	Name re-cased SSN last four extracted Whitespace trimmed Placeholder values cleared
ENR-140373	ENR	Sharon Banks	1989-05-03	UHC-04129-68	9523485720	3155 Grand Ave, Charlotte, NC, 28226	0.80	Name re-cased Phone reformatted SSN last four extracted Whitespace trimmed
ENR-129956	ENR	Brittany H Lawson	1963-02-23	UHC-05989-74	5148910295	1729 Jefferson Ave, Columbus, OH, 43284	0.80	Date of birth reformatted SSN last four extracted City re-cased Whitespace trimmed
ENR-108793	ENR	Carlos Garcia	2004-02-03	UHC-31745-98	6909602044	7288 River Rd, Phoenix, AZ, 85087	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
ENR-136126	ENR	Cynthia B Burke	1950-06-14	UHC-33647-68	9508055680	6222 Camelback Rd, Scottsdale, AZ, 85288	0.80	Name re-cased SSN last four extracted Email lower-cased Whitespace trimmed
ENR-120088	ENR	Fowler Donald	2005-03-25	UHC-20542-52	2264009481	8557 Central Ave, Eden Prairie, MN, 55369	0.80	Name re-cased Phone reformatted Member ID reformatted SSN last four extracted
ENR-115732	ENR	Chen Arthur	1946-09-05	UHC-64162-33	4968146384	2514 Apache Blvd, Dallas, TX, 75268	0.80	Name re-cased SSN last four extracted City re-cased Email lower-cased
ENR-108070	ENR	Samantha Crawford	1985-10-16	UHC-02931-55	7934725694	—	0.80	Phone reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
ENR-106107	ENR	Christina Harper	1979-01-10	UHC-69850-79	9218057425	6368 Valley View Dr, Sacramento, CA, 95899	0.80	Phone reformatted SSN last four extracted Email lower-cased Whitespace trimmed
ENR-118666	ENR	Jaanice Hunter	1982-03-04	UHC-06562-97	7312650051	4443 Jefferson Ave, Chandler, AZ, 85246	0.80	Date of birth reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
ENR-106595	ENR	Jerry Q Jimenez	1998-09-15	UHC-73060-74	5167002804	3727 Maple Ave, Gilbert, AZ, 85294	0.80	Name re-cased SSN last four extracted Email lower-cased Whitespace trimmed
ENR-130612	ENR	Jake A Padilla	1975-12-12	UHC-75060-56	8893703420	1497 Church St, Tucson, AZ, 85793	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Whitespace trimmed
ENR-129002	ENR	Samuel D Martinez	1993-04-08	UHC-56424-34	4304654165	8593 Jefferson Ave, Eden Prairie, MN, 55338	0.80	Name re-cased Phone reformatted SSN last four extracted City re-cased
ENR-103813	ENR	Frances O Bailey	1996-09-28	UHC-91801-04	3732999548	8364 Park Pl, Nashville, TN, 37226	0.80	Name re-cased Phone reformatted Member ID reformatted SSN last four extracted
ENR-108838	ENR	Terry C Austin	1962-09-03	UHC-75491-03	—	—	0.80	Date of birth reformatted Member ID reformatted SSN last four extracted Placeholder values cleared
ENR-136417	ENR	Madison I Nichols	1945-06-25	UHC-60294-10	6402278933	9777 Desert Sky Blvd, Jacksonville, FL, 32201	0.80	Phone reformatted Member ID reformatted SSN last four extracted Whitespace trimmed
ENR-129460	ENR	Jessica I Reed	1945-08-10	UHC-81057-51	—	3048 Cedar Ln, Minneapolis, MN, 55466	0.80	Name re-cased SSN last four extracted City re-cased Placeholder values cleared
ENR-138105	ENR	Lauren Silva	1946-07-01	UHC-22401-06	2487498456	7322 Ocean Ave, Phoenix, AZ, 85099	0.80	Name re-cased Phone reformatted SSN last four extracted Whitespace trimmed
ENR-134981	ENR	Dylan B Jensen	1941-11-28	UHC-72072-71	5702622896	1814 Broadway, Columbus, OH, 43256	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
ENR-141584	ENR	Camila J Price	1972-05-11	UHC-50192-84	—	6672 Canyon Rd, Nashville, TN, 37270	0.80	Name re-cased SSN last four extracted City re-cased Placeholder values cleared
ENR-139635	ENR	Alexander Nunez	1958-01-12	UHC-17804-40	7666554165	—	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared

1,767 rows, page 33 of 36Previous Next