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-140316	ENR	Alan B Bradley	2008-03-04	UHC-95978-86	—	286 Jefferson Ave, Charlotte, NC, 28277	0.64	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised+2 more
ENR-136483	ENR	Logan V Patterson	1962-09-14	UHC-77830-85	5196254018	9384 Lincoln Way, Minneapolis, MN, 55467	0.64	Name split from “Last, First”Phone reformatted Member ID reformatted SSN last four extracted+2 more
ENR-112263	ENR	Mark B Davis	1962-06-10	UHC-18118-85	—	1403 Pine Dr, Mesa, AZ, 85248	0.64	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised+2 more
ENR-125847	ENR	Timothy Pery	2008-05-20	UHC-32260-32	—	7814 Highland Ave, Miami, FL	0.64	Name re-cased Street suffix standardised Address re-cased ZIP missing+2 more
ENR-141392	ENR	Lisa Castro	1991-01-19	UHC-96067-72	7119064904	11 Elm St, Sacramento, CA	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-115692	ENR	Alexis P Sandoval	1985-08-01	UHC-93415-14	4394565375	5926 Valley View Dr, Tucson, AZ, 85745	0.64	Phone reformatted Street suffix standardised Address re-cased State name converted to code+2 more
ENR-119557	ENR	Harold Ryan	1988-11-28	UHC-44392-49	4394191715	8369 Oak St, Gilbert, AZ, 85222	0.64	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-119423	ENR	Carlos U Ramos	—	UHC-80608-77	6347624987	2238 Indian School Rd, Tempe, AZ, 85255	0.64	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+2 more
ENR-131928	ENR	Theresa O Henry	1985-10-10	UHC-29850-73	8904373090	1219 Hillcrest Rd, Eden Prairie, MN	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP missing+2 more
ENR-123414	ENR	Debra V Oliver	2005-11-05	UHC-96451-85	7474998161	676 Washington St, Columbus, OH, 43236	0.64	Name re-cased Two-digit birth year Phone reformatted State name converted to code+2 more
ENR-131859	ENR	Linda G Scott	1987-10-28	UHC-16616-27	9024578990	1462 Main St, Scottsdale, AZ, 85223	0.64	Name split from “Last, First”Middle initial moved out of first name Date of birth reformatted Phone reformatted+2 more
ENR-133387	ENR	Jean L Kennedy	1943-08-20	UHC-41234-29	9806639181	3458 Maple Ave, Phoenix, AZ	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-133514	ENR	Philip Whtie	1992-10-23	UHC-56598-37	8284020102	208 Washington St, Gilbert, AZ, 85280	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-115112	ENR	Lucia O Bailey	1938-08-26	UHC-99380-89	6599635095	5146 Meadow Ln, Plano, TX, 75054	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-128824	ENR	Olivia Reed	1955-05-19	UHC-00376-74	8227165532	9635 Forest Ave, San Antonio, TX, 78276	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-105383	ENR	Nancy Palmer	1975-12-11	UHC-18015-69	8348821792	4573 Elm St, Dallas, TX, 75273	0.64	Member ID reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-121798	ENR	Robert E Ramirez	1995-04-20	UHC-10947-38	8244246056	7520 Meadow Ln, Nashville, TN, 37292	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
ENR-131910	ENR	Michael S Vargas	—	UHC-17895-09	5154559343	2345 Maple Ave, Miami, FL, 33124	0.64	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-105049	ENR	Gabriel Fisher	1962-02-02	UHC-15892-86	—	3157 Baseline Rd, Chandler, AZ, 85283	0.64	Date of birth reformatted Phone missing area code Member ID reformatted Street suffix standardised+2 more
ENR-115331	ENR	Roy S Willis	1956-08-05	UHC-14627-45	7265705906	4226 Willow Ct, Orlando, FL, 32839	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-105231	ENR	Mary D Romero	1943-04-13	UHC-71438-17	5879700560	1277 River Rd, Denver, CO, 80265	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-122263	ENR	Amber Vasquez	1950-05-03	UHC-16493-18	2847358059	3362 Pine Dr, San Antonio, TX, 78252	0.64	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-142053	ENR	Burton B Santiago	1998-05-26	UHC-39291-32	4428302308	3029 Willow Ct # 718, Orlando, FL, 32897	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
ENR-110153	ENR	Luis X Oliver	1999-04-15	UHC-83023-09	6433737907	6924 Oak St, Tucson, AZ, 85772	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-131049	ENR	Billy Dean	1979-11-24	—	5519135207	3731 Bayshore Dr, Miami, FL, 33194	0.64	Date of birth reformatted Phone reformatted State name converted to code Email lower-cased+2 more
ENR-126090	ENR	Brian Y Hart	1972-08-20	UHC-91803-27	6385126569	1729 Highland Ave, San Antonio, TX, 78258	0.64	Middle initial moved out of first name Date of birth reformatted Phone reformatted Gender normalised+2 more
ENR-123078	ENR	Gloria J Simpson	1956-08-27	UHC-36962-36	7096947847	4897 Oak St, Atlanta, GA, 30301	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-110400	ENR	Ralph Bowman	—	UHC-64338-31	—	1164 Cedar Ln, Minneapolis, MN, 55402	0.64	Date of birth unreadable SSN last four extracted State code upper-cased Email lower-cased+2 more
ENR-103461	ENR	Carl M George	1959-08-09	UHC-98825-70	—	2222 Oak St, Tucson, AZ, 85739	0.64	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
ENR-119974	ENR	Anthony K Moreno	1940-10-18	UHC-93745-83	6639937052	3602 Baseline Rd Apt 34, Scottsdale, AZ, 85252	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-136771	ENR	Amber Cruz	1943-10-18	UHC-42078-47	8548477408	7339 Oak St, Austin, TX, 78707	0.64	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-100864	ENR	Amanda D Wheeler	1938-07-07	—	7297087633	9600 Maple Ave # 118, Phoenix, AZ, 85055	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-108959	ENR	Patricia Ross	1974-04-27	—	2336634295	6260 Market St, Eden Prairie, MN, 55398	0.64	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-136099	ENR	Stephanie S Perez	1965-08-25	UHC-82601-85	4752201274	2743 Elm St, Eden Prairie, MN, 55392	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-133054	ENR	Donna Scott	1986-12-11	UHC-62612-35	—	1923 Ocean Ave, Nashville, TN, 37221	0.64	Name re-cased Date of birth reformatted ZIP+4 trimmed Gender normalised+2 more
ENR-123688	ENR	Madison E Walsh	1939-05-02	UHC-80205-20	—	7858 Desert Sky Blvd, Gilbert, AZ, 85218	0.64	Street suffix standardised Address re-cased ZIP+4 trimmed Email lower-cased+2 more
ENR-137885	ENR	Brittany T Griffin	1967-12-24	UHC-33334-49	5369864995	8300 Mountain View Dr # 683, San Antonio, TX, 78229	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-133924	ENR	Santiago Shaw	1950-05-04	UHC-52385-99	7428256905	6613 Harbor Blvd, Phoenix, AZ, 85084	0.64	Phone reformatted Street suffix standardised Address re-cased City re-cased+2 more
ENR-119614	ENR	Dennis Hamilton	1938-08-11	UHC-89766-39	—	3844 Forest Ave, Los Angeles, CA, 90079	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-112163	ENR	Marcus Edwards	1950-04-19	UHC-56679-42	7275149764	1077 Park Pl, Las Vegas, NV, 89138	0.64	Name split from “Last, First”Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-129096	ENR	Elijah P Weaver	1989-01-15	UHC-03082-61	6506189732	9037 Indian School Rd, Las Vegas, NV	0.64	Phone reformatted Street suffix standardised Address re-cased ZIP missing+2 more
ENR-121473	ENR	Ortiz T Stephanie	—	UHC-92874-74	5712873717	5481 Washington St, Miami, FL, 33191	0.64	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-101747	ENR	Donald T Johnston	—	UHC-99698-01	—	942 Harbor Blvd, Glendale, AZ, 85356	0.64	Date of birth unreadable Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-110263	ENR	Amy W Park	1981-06-17	UHC-81057-31	3426406071	7336 Camelback Rd Apt 11, Fresno, CA, 93761	0.64	Two-digit birth year Phone reformatted Member ID reformatted Unit split from street+2 more
ENR-111968	ENR	Danielle Ward	2003-09-25	UHC-81974-47	8778395229	8315 Central Ave, Scottsdale, AZ, 85262	0.64	Name re-cased Phone reformatted SSN last four extracted City re-cased+2 more
ENR-123584	ENR	Kevin F Medina	1956-06-26	UHC-95181-03	4146825677	9682 Bayshore Dr, Las Vegas, NV, 89131	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-114617	ENR	Jacob V Phillips	1996-11-10	UHC-62923-91	5396455044	629 Camelback Rd, Sacramento, CA, 95887	0.64	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-104623	ENR	Bruce Knight	1950-07-18	UHC-76608-48	2636033400	9441 Church St, Phoenix, AZ, 85092	0.64	Phone reformatted SSN last four extracted City re-cased ZIP+4 trimmed+2 more
ENR-113815	ENR	Joan Wheler	1996-12-21	—	4117643757	1955 Park Pl, Fresno, CA, 93729	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-132917	ENR	Austin X Hansen	1989-01-04	UHC-38354-03	4367850509	1402 Sunset Blvd, Houston, TX, 77032	0.64	Middle initial moved out of first name Date of birth reformatted Phone reformatted Street suffix standardised+2 more

16,916 rows, page 107 of 339Previous Next