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

All ENR CLM TPA PRV

Junk onlyFlagName re-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-112456	ENR	Laura S Dunn	1976-02-22	UHC-44881-02	6166557095	8838 Park Pl # 999, Mesa, AZ, 85200	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-104778	ENR	Dylan D White	1939-01-15	—	8547426782	7746 Mountain View Dr, Houston, TX	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-122447	ENR	Andrea E Beell	1940-01-26	UHC-37247-96	5179991466	9349 Lake View Rd, Gilbert, AZ, 85250	0.64	Name re-cased Phone reformatted City re-cased State name converted to code+2 more
ENR-115082	ENR	Maria Foster	1953-10-06	UHC-88787-54	7788502812	5575 Central Ave, Fresno, CA, 93722	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-105406	ENR	Joseph C Boyd	1954-03-20	UHC-23225-22	—	1006 Park Pl, Houston, TX, 77056	0.64	Name re-cased Date of birth reformatted SSN last four extracted Street suffix standardised+2 more
ENR-105405	ENR	Joseph C Boyd	1954-03-20	UHC-23225-22	—	1006 Park Pl, Houston, TX, 77056	0.64	Name re-cased Date of birth reformatted SSN last four extracted Street suffix standardised+2 more
ENR-113529	ENR	Jesse Cox	1947-11-19	UHC-86746-72	9643631563	123 Valley View Dr, Phoenix, AZ, 85009	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-110966	ENR	Abigail L Marshall	1943-09-25	UHC-76851-39	6475203297	8253 Desert Sky Blvd Apt 3, Dallas, TX, 75264	0.64	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
ENR-138776	ENR	Russell Z Pierce	2001-08-21	UHC-03471-75	7157825007	5135 Oak St, Charlotte, NC	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-133716	ENR	Jessica C Lane	1954-11-05	UHC-34812-69	—	8291 Main St, Eden Prairie, MN, 55378	0.64	Name re-cased Phone missing area code Street suffix standardised Address re-cased+2 more
ENR-140696	ENR	Julie N Guerrero	1976-02-13	UHC-36502-86	9008893494	3375 Apache Blvd, Sacramento, CA, 95822	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-107314	ENR	Shirley V Burke	1998-05-25	UHC-99524-15	7857771577	4375 Washington St, San Diego, CA, 92123	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
ENR-110533	ENR	Carol A Chapman	1988-08-20	UHC-63066-66	6169666703	5400 Broadway # 712, San Diego, CA, 92153	0.64	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+2 more
ENR-129900	ENR	Cynthia Ortega	2002-07-08	UHC-54454-59	2574457724	3415 Canyon Rd, Nashville, TN, 37299	0.64	Name re-cased Street suffix standardised Address re-cased State name converted to code+2 more
ENR-137272	ENR	Lauran K Phillips	1966-01-01	UHC-19206-41	—	3689 Bayshore Dr, Los Angeles, CA, 90069	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-122497	ENR	Alice B Graham	2002-10-08	UHC-35055-31	4902038393	1877 Forest Ave, Seattle, WA, 98129	0.64	Name re-cased Street suffix standardised Address re-cased Email lower-cased+2 more
ENR-134935	ENR	Roy N Duncan	1974-12-12	UHC-19828-47	7528507158	6138 Grand Ave # 573, Sacramento, CA, 95879	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
ENR-130243	ENR	Raymond Collins	1971-03-26	UHC-04176-72	3534901244	6254 Forest Ave, Seattle, WA, 98140	0.64	Name re-cased Date of birth reformatted ZIP+4 trimmed Email lower-cased+2 more
ENR-109983	ENR	Barbara Rojas	1974-05-22	UHC-91769-61	3116896591	8037 Church St, Miami, FL, 33161	0.64	Name re-cased Date of birth reformatted Phone reformatted State name converted to code+2 more
ENR-127756	ENR	Arthur T Parker	1971-03-13	UHC-20503-28	9207608700	680 Park Pl, Chandler, AZ, 85241	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-126996	ENR	Bradley Foster	1992-10-12	UHC-61179-72	3692183356	8231 Grand Ave, Tempe, AZ, 85290	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-128868	ENR	Sean U Tucker	1942-02-27	UHC-15420-32	6769874210	4803 Canyon Rd, Minneapolis, MN, 55433	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-128869	ENR	Sean U Tucker	1942-02-27	UHC-15420-32	6769874210	4803 Canyon Rd, Minneapolis, MN, 55433	0.64	Name re-cased Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
ENR-132971	ENR	Jacqueline Hayes	1983-05-03	UHC-23251-29	7257805430	5066 Oak St, Charlotte, NC, 28269	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-133687	ENR	Abigail Morrison	1950-04-01	UHC-09145-97	3974204494	928 Bayshore Dr # 958, Minneapolis, MN, 55448	0.64	Name re-cased Two-digit birth year Phone reformatted Unit split from street+2 more
ENR-127719	ENR	Stephhen U Elliott	1993-12-09	UHC-16349-63	7068913399	209 Maple Ave, Columbus, OH, 43232	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-140152	ENR	Ahmed H Sullivan	1984-03-15	UHC-97738-74	—	8848 Desert Sky Blvd, Charlotte, NC, 28296	0.64	Name re-cased Date of birth reformatted Phone missing area code Street suffix standardised+2 more
ENR-140153	ENR	Ahmed H Sullivan	1984-03-15	UHC-97738-74	—	8848 Desert Sky Blvd, Charlotte, NC, 28296	0.64	Name re-cased Date of birth reformatted Phone missing area code Street suffix standardised+2 more
ENR-121670	ENR	Alice Larson	1979-03-07	UHC-47376-36	8753120016	5606 Palm Dr, Austin, TX	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-105092	ENR	Grace R Chavez	2000-08-04	UHC-47838-28	9876321302	2225 Hillcrest Rd, Tucson, AZ, 85774	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-117594	ENR	Jordan Alvarado	1984-03-12	UHC-21426-35	—	4827 Lake View Rd, Fresno, CA, 93725	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
ENR-137054	ENR	Mark Ferguson	2006-06-06	UHC-22617-37	8667991352	8257 Indian School Rd, Tampa, FL, 33606	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
ENR-113048	ENR	Cerol Espinoza	1962-03-19	UHC-61680-94	8758316544	5277 Mesa Dr, Mesa, AZ, 85205	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
ENR-101301	ENR	Arthur Greene	1989-09-25	UHC-22003-20	6736540329	34 Baseline Rd, Seattle, WA, 98180	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-120420	ENR	Sean Stephens	1940-03-05	UHC-47949-16	2133591012	6061 Grand Ave, Orlando, FL, 32881	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-141095	ENR	Kelly E Howard	—	UHC-06459-89	7066417702	9817 Church St, Glendale, AZ, 85319	0.64	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+2 more
ENR-135410	ENR	Cynthia E Sandoval	1945-04-07	UHC-16642-49	6766489341	5297 Elm St, San Antonio, TX, 78254	0.64	Name re-cased Street suffix standardised Address re-cased State name converted to code+2 more
ENR-106605	ENR	Lawrence Lynch	1962-08-16	UHC-89282-74	8245778964	3963 Washington St, Orlando, FL, 32870	0.64	Name re-cased Street suffix standardised Address re-cased City re-cased+2 more
ENR-134005	ENR	Peter S Diaz	1938-01-23	UHC-02885-51	3829544392	8776 Market St, Minneapolis, MN, 55468	0.64	Name re-cased Phone reformatted SSN last four extracted Street suffix standardised+2 more
ENR-101866	ENR	Rebecca Jacobs	1993-02-24	UHC-27599-54	9668486900	7259 Highland Ave, Jacksonville, FL, 32237	0.64	Name re-cased Member ID reformatted Street suffix standardised Address re-cased+2 more
ENR-112063	ENR	Bruce P Adams	1942-10-15	UHC-74963-28	—	6011 Main St, Sacramento, CA	0.64	Name re-cased Phone missing area code Member ID reformatted ZIP missing+2 more
ENR-105727	ENR	Santiago U Ferguson	1966-03-12	UHC-76518-54	7278331495	733 Spring St, Los Angeles, CA, 90089	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-125291	ENR	Sophia Butler	2005-04-12	UHC-88598-31	4106501981	3012 Market St, Glendale, AZ, 85320	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-141863	ENR	Jeffrey Z Moore	1938-11-12	UHC-86572-28	—	1943 Hillcrest Rd, Plano, TX, 75061	0.64	Name re-cased Phone missing area code Street suffix standardised Address re-cased+2 more
ENR-137658	ENR	Charlotte Alexander	1966-07-09	UHC-38582-59	8152173038	6304 Highland Ave, Atlanta, GA, 30363	0.64	Name re-cased Two-digit birth year Phone reformatted Street suffix standardised+2 more
ENR-125984	ENR	Steven F Franklin	1987-07-04	UHC-52669-83	9306940761	5874 Park Pl, Houston, TX, 77065	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-103397	ENR	Roy Payne	1987-01-20	UHC-52043-76	2617780795	5791 Baseline Rd, Columbus, OH, 43228	0.64	Name re-cased Two-digit birth year Street suffix standardised Address re-cased+2 more
ENR-137733	ENR	Kyle Delgado	1997-02-18	UHC-21688-31	6677743819	8719 Maple Ave, Columbus, OH	0.64	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+2 more
ENR-127470	ENR	Nicholas G Alexander	1955-02-23	UHC-81486-07	5466950028	6174 Central Ave, San Diego, CA, 92154	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more
ENR-130418	ENR	Philip R Robinson	1977-01-04	UHC-17592-55	2986254420	9046 Valley View Dr, Dallas, TX, 75249	0.64	Name re-cased Phone reformatted Street suffix standardised Address re-cased+2 more

17,310 rows, page 108 of 347Previous Next