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 “State code upper-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagState code upper-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-127786	ENR	Gary Guerrero	1985-12-10	UHC-18725-71	4105945149	5571 Jefferson Ave, Los Angeles, CA, 90070	0.56	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+6 more
ENR-109937	ENR	Alice I Murphy	1967-09-28	UHC-19582-46	3518854451	6768 Baseline Rd, Tampa, FL, 33640	0.56	Middle initial moved out of first name Date of birth reformatted Phone reformatted Street suffix standardised+6 more
ENR-109938	ENR	Alice I Murphy	1967-09-28	UHC-19582-46	3518854451	6768 Baseline Rd, Tampa, FL, 33640	0.56	Middle initial moved out of first name Date of birth reformatted Phone reformatted Street suffix standardised+6 more
ENR-112531	ENR	Valentina Rios	1989-10-21	UHC-36880-73	4517771817	2665 Harbor Blvd, Orlando, FL, 32887	0.56	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+6 more
ENR-112160	ENR	Abigail I Graham	1955-08-18	UHC-59485-94	8056929204	8863 Ocean Ave, Dallas, TX	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-103837	ENR	Rebecca S Warren	1997-04-06	UHC-69309-05	—	7385 Market St, San Diego, CA, 92189	0.58	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+5 more
ENR-133373	ENR	Ruth W Rsoe	1997-12-20	UHC-90723-35	9529317242	8340 Maple Ave, Dallas, TX, 75212	0.58	Middle initial moved out of first name Name re-cased Phone reformatted Street suffix standardised+5 more
ENR-104480	ENR	Martha V Sandoval	1971-07-21	UHC-24262-06	7379957354	2698 Cedar Ln, Gilbert, AZ	0.58	Name re-cased Phone reformatted Street suffix standardised Address re-cased+5 more
ENR-134018	ENR	Ethan Stone	1989-12-27	UHC-37228-60	4862281810	5814 Grand Ave, Fresno, CA, 93776	0.58	Name re-cased Phone reformatted Street suffix standardised Address re-cased+5 more
ENR-111952	ENR	Dnna Z Schmidt	1983-02-23	UHC-88832-04	2117605790	6092 Meadow Ln, San Antonio, TX, 78250	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-118208	ENR	Ykui M Bell	1965-12-01	UHC-62559-25	3646476692	6643 Oak St, Chandler, AZ, 85219	0.58	Middle initial moved out of first name Phone reformatted Member ID reformatted Street suffix standardised+5 more
ENR-117395	ENR	Benjamin Carpenter	1988-11-08	UHC-14500-07	5583911446	3338 Church St, Las Vegas, NV, 89164	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-117700	ENR	Larry Freemman	1973-10-19	UHC-74769-25	5942131143	8114 Sage Ct Apt 15, Tampa, FL, 33688	0.58	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+5 more
ENR-139863	ENR	Jacqueline R Gomez	1967-02-17	UHC-57063-16	9254703763	1869 Palm Dr, Charlotte, NC, 28246	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-139862	ENR	Jacqueline R Gomez	1967-02-17	UHC-57063-16	9254703763	1869 Palm Dr, Charlotte, NC, 28246	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-137037	ENR	Nancy M Tuckeer	1973-10-22	UHC-74469-73	3292128455	3950 Valley View Dr, Houston, TX, 77094	0.58	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
ENR-127075	ENR	Linda P Banks	1986-12-22	UHC-50474-51	2808182550	8760 Camelback Rd, Scottsdale, AZ, 85289	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-108664	ENR	William McDonald	1942-03-01	UHC-29786-39	3038461638	424 Church St, Fresno, CA, 93718	0.58	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+5 more
ENR-122373	ENR	Daniel X Jimenez	1959-01-18	UHC-38087-84	2503385724	5471 Sage Ct, Eden Prairie, MN, 55340	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-102832	ENR	Gary Munoz	1965-10-25	UHC-01867-73	7376018815	8538 Ocean Ave, Nashville, TN, 37225	0.58	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+5 more
ENR-118630	ENR	Priya A Ford	1955-04-27	UHC-64152-57	6548657026	3794 Hillcrest Rd, San Diego, CA	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-115658	ENR	Jerry Z Smith	1960-02-22	UHC-94989-34	5326750204	3768 Union St, Tempe, AZ, 85240	0.58	Phone reformatted Street suffix standardised Address re-cased City re-cased+5 more
ENR-141922	ENR	Digo Dominguez	1985-01-01	UHC-90646-41	6667232138	3937 Lake View Rd # 689, Austin, TX, 78784	0.58	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
ENR-134565	ENR	Heather K Pena	—	UHC-96232-44	9155561340	6554 Baseline Rd, Tucson, AZ, 85708	0.58	Name re-cased Date of birth unreadable Phone reformatted Member ID reformatted+5 more
ENR-122015	ENR	JaniceJunk	1981-01-11	UHC-29648-88	—	8146 Lincoln Way, Tucson, AZ, 85736	0.58	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+5 more
ENR-100413	ENR	Emma Z Hill	1974-02-09	UHC-72136-54	9835648155	5231 Central Ave, Tempe, AZ, 85242	0.58	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+5 more
ENR-127250	ENR	Cynthia Hill	2006-08-21	UHC-85055-61	2036047667	3680 Indian School Rd Apt 33, Tucson, AZ, 85754	0.58	Phone reformatted Member ID reformatted Unit split from street Street suffix standardised+5 more
ENR-142629	ENR	Emma H Maldonado	1997-11-02	UHC-45716-23	6478713199	2613 Central Ave # 489, San Diego, CA, 92148	0.58	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+5 more
ENR-134542	ENR	Marcus Taylor	1995-03-07	UHC-98273-96	9888005371	2498 Harbor Blvd, Austin, TX	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-119746	ENR	Eugene Y Kennedy	1955-02-04	UHC-35358-92	9085640173	4602 Grand Ave # 611, Fresno, CA, 93727	0.58	Name re-cased Phone reformatted Member ID reformatted Unit split from street+5 more
ENR-142677	ENR	Ronald F Hanson	1971-03-24	UHC-39935-64	8814029982	5452 Washington St, Atlanta, GA, 30338	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-135348	ENR	Justin D Welch	1980-03-05	UHC-40931-89	3755187151	6794 Market St, San Antonio, TX, 78289	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-136571	ENR	Benjamin J Luna	1966-06-07	UHC-82439-48	—	924 Desert Sky Blvd, Nashville, TN, 37249	0.58	Date of birth reformatted Street suffix standardised Address re-cased State code upper-cased+5 more
ENR-108311	ENR	Kayla P Dunn	1977-12-24	UHC-36255-45	8398823725	7551 Indian School Rd, Las Vegas, NV, 89101	0.58	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+5 more
ENR-116242	ENR	Andrew Jackson	1945-08-28	UHC-84703-99	—	8760 Harbor Blvd, Nashville, TN, 37216	0.58	Date of birth reformatted Phone missing area code Street suffix standardised Address re-cased+5 more
ENR-124761	ENR	Mei McDonald	1939-01-28	UHC-20880-78	4816081080	7772 Lincoln Way, Houston, TX, 77077	0.58	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-113759	ENR	Marilyn Hill	1991-04-08	UHC-35136-12	2786583127	8995 Desert Sky Blvd, Tucson, AZ, 85792	0.58	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+5 more
ENR-108395	ENR	Linda U Harvey	1965-12-27	UHC-26634-20	4903402913	8129 Central Ave, Denver, CO	0.58	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
ENR-141727	ENR	Nathan Day	2004-03-20	UHC-18540-15	6145625518	4425 Broadway Apt 22, Dallas, TX	0.58	Date of birth reformatted Phone reformatted Member ID reformatted Unit split from street+5 more
ENR-117477	ENR	Eugene Webb	1998-04-24	UHC-03845-70	3103051170	6304 Grand Ave # 574, Tampa, FL, 33686	0.58	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+5 more
ENR-132728	ENR	Brittany Alvaredo	1991-09-17	UHC-89357-17	5975826766	7794 Baseline Rd # 601, Phoenix, AZ, 85044	0.60	Name re-cased Date of birth reformatted Phone reformatted Unit split from street+4 more
ENR-134622	ENR	Noah Q Lee	2005-12-17	UHC-90337-32	3237919546	9849 Highland Ave, Fresno, CA, 93781	0.60	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+4 more
ENR-126553	ENR	Joyce Q Wallace	1979-09-26	UHC-34860-64	2512720963	2416 Cedar Ln, Houston, TX, 77008	0.60	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+4 more
ENR-120946	ENR	Margaret R Lane	1979-04-20	UHC-85163-67	—	2784 Spring St, Plano, TX, 75015	0.60	Name re-cased Street suffix standardised Address re-cased State code upper-cased+4 more
ENR-115135	ENR	Steven N Harrison	1963-10-16	UHC-95603-45	—	5754 Church St, Chandler, AZ, 85237	0.60	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+4 more
ENR-101059	ENR	Alice Knight	—	UHC-58125-21	4708262531	6465 Pine Dr, Orlando, FL, 32859	0.60	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+4 more
ENR-130945	ENR	Jonathan Castillo	1970-02-18	UHC-98958-75	9342811565	8032 Camelback Rd, Fresno, CA, 93730	0.60	Two-digit birth year Phone reformatted Street suffix standardised Address re-cased+4 more
ENR-130745	ENR	Rebecca S Butler	1972-12-26	UHC-82111-65	—	6189 Desert Sky Blvd, Gilbert, AZ	0.60	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+4 more
ENR-139889	ENR	Christina Mills	1968-09-02	UHC-64877-91	7227301526	2856 Grand Ave, Fresno, CA, 93737	0.60	Phone reformatted Street suffix standardised Address re-cased City re-cased+4 more
ENR-127354	ENR	Mariana U Jackson	1992-11-20	UHC-36939-96	4996310529	8346 Palm Dr, Austin, TX, 78738	0.60	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+4 more

1,918 rows, page 5 of 39Previous Next