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

All sources, flag “Member ID reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagMember ID reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
ENR-141233	ENR	Gabriel Y Arnold	1960-03-04	UHC-31163-02	—	1148 Canyon Rd, San Antonio, TX, 78263	0.70	Name split from “Last, First”Member ID reformatted ZIP+4 trimmed
ENR-118544	ENR	Maria N Little	1995-08-17	UHC-65630-58	7919203011	8543 Ridge Rd, Charlotte, NC, 28284	0.70	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
CLM-415720	CLM	Richard Riley	1989-01-11	UHC-00852-67	7702920735	4315 Pine Dr, Columbus, OH, 43292	0.70	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
PRV-20310	PRV	Mason H Sanchez	2001-03-12	UHC-57803-79	4423346851	9677 Camelback Rd, Tempe, AZ, 85240	0.70	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
ENR-123815	ENR	Steven Henry	2005-04-14	UHC-49734-04	9624875932	2583 Elm St, Tempe, AZ, 85209	0.70	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
ENR-104453	ENR	Joe Carroll	1986-08-05	UHC-17125-04	7885598772	769 Willow Ct, Sacramento, CA, 95813	0.70	Name split from “Last, First”Member ID reformatted Gender normalised
ENR-100880	ENR	Gabriel Rose	1969-05-26	UHC-79218-68	5062196266	1777 Indian School Rd, Plano, TX, 75072	0.70	Member ID reformatted SSN last four extracted ZIP+4 trimmed
ENR-129063	ENR	Lori Robinson	1955-05-14	UHC-28139-43	9885457599	1793 Mountain View Dr, Tampa, FL, 33627	0.70	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+5 more
ENR-115896	ENR	Kevin Z Mejia	1989-03-13	UHC-05080-57	8749023962	6452 Ridge Rd, Minneapolis, MN, 55486	0.70	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+5 more
ENR-130931	ENR	Kathleen Z Sanchez	1970-02-17	UHC-39770-60	9827322068	2706 Bayshore Dr, Seattle, WA, 98162	0.70	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
CLM-432690	CLM	Susan U Hart	1938-10-02	UHC-24309-19	3556006318	3896 Baseline Rd, Charlotte, NC, 28296	0.70	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
ENR-130867	ENR	Rebecca T Rodriguez	1996-06-08	UHC-72123-01	4757714074	1058 Lake View Rd # 652, Denver, CO, 80214	0.70	Member ID reformatted Unit split from street Gender normalised
ENR-116417	ENR	Jake J Tran	1948-02-01	UHC-65412-57	7828222632	6797 Highland Ave, Seattle, WA, 98133	0.70	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
CLM-415885	CLM	Christopher Nguyen	1994-01-27	UHC-96313-19	8878175500	1738 Meadow Ln, Tempe, AZ, 85265	0.70	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
CLM-426628	CLM	Abigail X Kelly	1976-04-18	UHC-81706-77	7883660688	9621 Park Pl, Mesa, AZ, 85242	0.70	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
ENR-130539	ENR	Jordan Lucas	1941-06-17	UHC-43274-14	8999350181	3269 Apache Blvd, Phoenix, AZ, 85068	0.70	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
ENR-142591	ENR	Kayla Y James	1961-06-15	UHC-27390-20	6164409509	3880 Park Pl, Minneapolis, MN, 55421	0.70	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+5 more
ENR-132084	ENR	Keith Vargas	1955-03-05	UHC-17529-71	6193209775	720 Meadow Ln, Seattle, WA, 98111	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
ENR-124034	ENR	Jacob Vaazquez	1972-07-14	UHC-80829-54	5598648846	2247 Park Pl, Glendale, AZ, 85351	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
CLM-428742	CLM	Gregory V Luna	1966-07-21	UHC-06652-38	5112491982	1761 Canyon Rd, Phoenix, AZ, 85020	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
ENR-110385	ENR	Nicole Patterson	1985-06-03	UHC-44497-65	8118784914	9814 Baseline Rd, Miami, FL, 33147	0.72	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+4 more
CLM-410568	CLM	Marilyn I Patterson	1997-01-05	UHC-43471-66	5688744256	9305 Meadow Ln, Orlando, FL, 32888	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
ENR-117820	ENR	Arthur P Bailey	1980-11-16	UHC-24286-79	3424371609	4547 Elm St, Charlotte, NC, 28290	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
ENR-106114	ENR	Linda L Gomez	1994-04-14	UHC-48209-83	5269504569	8638 River Rd, Jacksonville, FL, 32251	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
ENR-133315	ENR	Edward Hraris	2005-01-07	UHC-50295-72	7633704448	2501 Palm Dr, Las Vegas, NV, 89161	0.72	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+4 more
ENR-111545	ENR	Adam Gonzales	1988-09-08	UHC-53714-65	3055210341	1141 Pine Dr, Plano, TX, 75049	0.72	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+4 more
CLM-431467	CLM	Heather Kim	2006-01-04	UHC-33481-45	6318587406	4203 Harbor Blvd, Tempe, AZ, 85255	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
TPA-56520	TPA	Nancy Espinoza	2008-09-01	UHC-65433-82	7777289344	3498 Apache Blvd, Phoenix, AZ, 85038	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
PRV-26144	PRV	Yuki Simpson	1971-08-19	UHC-94703-77	2358992090	5732 Maple Ave, Austin, TX, 78756	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
CLM-400060	CLM	Joyce A Contreras	1966-07-03	UHC-09400-72	6224547008	2980 Park Pl, Mesa, AZ, 85212	0.72	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+4 more
ENR-110511	ENR	Wayne E Graham	1971-12-25	UHC-66260-17	2518722302	9446 Central Ave, Orlando, FL, 32802	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
CLM-412739	CLM	Harold Patterzon	1940-03-26	UHC-04603-36	3754075325	226 Harbor Blvd, San Antonio, TX, 78260	0.72	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+4 more
ENR-120984	ENR	Madison Jensen	2001-08-22	UHC-93265-26	9664872071	7460 Baseline Rd, Scottsdale, AZ, 85212	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
ENR-100400	ENR	Scoott Foster	1956-09-03	UHC-91525-62	3455571609	4415 Baseline Rd, Scottsdale, AZ, 85273	0.72	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+4 more
ENR-130797	ENR	Ann Lawrence	1993-12-14	UHC-40605-61	3565609550	8405 Apache Blvd, Miami, FL, 33125	0.72	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+4 more
CLM-419982	CLM	Joseph S Carroll	1970-10-05	UHC-92686-44	3109269965	56 River Rd, Scottsdale, AZ, 85218	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
ENR-116599	ENR	Kimberly Marquez	1989-05-26	UHC-05060-66	9037650878	2170 Lake View Rd, Gilbert, AZ, 85232	0.72	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+4 more
CLM-402417	CLM	Kayla Hart	1950-06-27	UHC-56881-49	—	7021 Highland Ave, Mesa, AZ, 85211	0.72	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+4 more
CLM-420353	CLM	Ralph Harrison	1982-05-22	UHC-94145-62	7274481723	7695 Union St, Austin, TX, 78783	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
ENR-119754	ENR	Alexander D Welch	1986-01-05	UHC-67317-69	7666300088	2046 Palm Dr, Fresno, CA, 93727	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
ENR-107994	ENR	Michelle M Matthews	1958-12-03	UHC-85785-52	7125860459	4707 Central Ave, Eden Prairie, MN, 55391	0.72	Date of birth reformatted Phone reformatted Member ID reformatted Street suffix standardised+4 more
ENR-118025	ENR	Jennifer N Anderson	1955-02-02	UHC-59630-32	8372941329	9633 Mountain View Dr, Orlando, FL, 32803	0.72	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+4 more
ENR-140242	ENR	Betty Hansen	1955-09-13	UHC-18050-08	3798603313	3269 Sunset Blvd, San Diego, CA, 92174	0.72	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+4 more
ENR-116120	ENR	Yuki D Booyd	1993-05-18	UHC-66893-48	6436026611	8451 Oak St, Scottsdale, AZ, 85262	0.72	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+4 more
ENR-141008	ENR	Roger Q Rice	1952-04-07	UHC-26333-36	7835099873	5283 Spring St, Gilbert, AZ, 85210	0.72	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+4 more
PRV-24378	PRV	Kathryn Gonzalez	1988-08-13	UHC-91606-76	6019982729	4472 Main St, Minneapolis, MN, 55483	0.72	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+4 more
ENR-111966	ENR	Betty Fields	1990-09-12	UHC-71045-07	8672511619	4666 Broadway, Charlotte, NC, 28275	0.72	Phone reformatted Member ID reformatted Address re-cased City re-cased+4 more
ENR-109856	ENR	Omar E Miller	1959-06-22	UHC-04745-42	—	1055 Grand Ave, Mesa, AZ, 85212	0.72	Name re-cased Date of birth reformatted Member ID reformatted Street suffix standardised+4 more
CLM-431786	CLM	Philip F Castro	1977-04-13	UHC-67143-84	4479213897	6768 Bayshore Dr, Columbus, OH, 43217	0.72	Name re-cased Phone reformatted Member ID reformatted Street suffix standardised+4 more
ENR-120719	ENR	Charlotte Chavez	2001-08-05	UHC-16131-08	4802429702	8087 Park Pl, Tucson, AZ, 85743	0.72	Phone reformatted Member ID reformatted Street suffix standardised Address re-cased+4 more

7,723 rows, page 63 of 155Previous Next