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 “Date of birth unreadable”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagDate of birth unreadableClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-63603	TPA	Douglas Sanders	—	UHC-15375-20	—	7638 Bayshore Dr, Atlanta, GA, 30371	0.38	Name re-cased Date of birth unreadable Phone missing area code Street suffix standardised+3 more
TPA-56412	TPA	Patricia M Wang	—	—	—	8628 Maple Ave, Plano, TX, 75036	0.38	Name split from “Last, First”Middle initial moved out of first name Date of birth unreadable Street suffix standardised+3 more
ENR-121490	ENR	Albert R Park	—	UHC-34842-61	2209014479	4568 Bayshore Dr, Mesa, AZ	0.38	Middle initial moved out of first name Date of birth unreadable Phone reformatted Street suffix standardised+3 more
TPA-56818	TPA	Jack Wallace	—	—	—	3117 River Rd Apt 28, Plano, TX, 75045	0.38	Date of birth unreadable Unit split from street Street suffix standardised Address re-cased+3 more
ENR-102807	ENR	Julie Hansen	—	UHC-11629-44	4145977826	667 Oak St, Eden Prairie, MN, 55336	0.38	Date of birth unreadable Phone reformatted Member ID reformatted Street suffix standardised+3 more
ENR-142740	ENR	Camila L Kelly	—	UHC-54469-23	6054453867	7640 Cedar Ln, Sacramento, CA	0.38	Date of birth unreadable Phone reformatted SSN last four extracted City re-cased+3 more
CLM-431159	CLM	Shirley Lee	—	—	—	429 Camelback Rd Apt 24, Chandler, AZ	0.38	Date of birth unreadable Unit split from street Street suffix standardised Address re-cased+3 more
CLM-402079	CLM	Carlos Lawrence	—	UHC-66269-80	5612407521	6107 Mountain View Dr, Phoenix, AZ, 85015	0.38	Name split from “Last, First”Date of birth unreadable Member ID reformatted Street suffix standardised+3 more
CLM-402080	CLM	Carlos Lawrence	—	UHC-66269-80	5612407521	6107 Mountain View Dr, Phoenix, AZ, 85015	0.38	Name split from “Last, First”Date of birth unreadable Member ID reformatted Street suffix standardised+3 more
ENR-117735	ENR	George Gomeez	—	UHC-95429-87	5989142993	5861 Highland Ave, Glendale, AZ	0.38	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-414368	CLM	Henry Sullivan	—	UHC-26067-06	—	1538 Harbor Blvd Apt 37, Los Angeles, CA, 90076	0.38	Date of birth unreadable Unit split from street Street suffix standardised Address re-cased+3 more
ENR-134467	ENR	Marcus X Herrera	—	UHC-70801-84	4805717653	9213 Cedar Ln, Denver, CO	0.38	Name split from “Last, First”Date of birth unreadable Phone reformatted Street suffix standardised+3 more
TPA-59694	TPA	Kimberly Hoffman	—	—	—	3254 Jefferson Ave Apt 32, San Diego, CA, 92141	0.38	Date of birth reformatted Date of birth unreadable Unit split from street Street suffix standardised+3 more
ENR-122031	ENR	Cheryl Butler	—	UHC-37634-84	—	5797 Cedar Ln, Orlando, FL, 32848	0.38	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+3 more
ENR-117412	ENR	Walter F Bwoman	—	UHC-19722-01	5174906631	137 River Rd, Phoenix, AZ, 85037	0.38	Name split from “Last, First”Date of birth unreadable Phone reformatted Street suffix standardised+3 more
PRV-27240	PRV	Jose F Ford	—	—	8933759581	7094 Jefferson Ave, Mesa, AZ, 85212	0.38	Middle initial moved out of first name Date of birth unreadable Phone reformatted City re-cased+3 more
CLM-405049	CLM	Timothy Lopez	—	UHC-58975-81	5136726619	9308 Meadow Ln, Nashville, TN, 37271	0.38	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+3 more
CLM-431121	CLM	Bradley G Clark	—	—	4464295367	1924 Sage Ct Apt 17, Tampa, FL	0.38	Date of birth unreadable Phone reformatted Unit split from street State name converted to code+3 more
CLM-428321	CLM	Cheryl Reynolds	—	UHC-05597-29	—	2655 Market St, Minneapolis, MN, 55482	0.38	Name split from “Last, First”Date of birth unreadable Street suffix standardised Address re-cased+3 more
ENR-122851	ENR	Austin C Richards	—	UHC-80985-56	7923532976	9292 Forest Ave, Seattle, WA, 98168	0.38	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+3 more
CLM-410113	CLM	Gerald Chavez	—	UHC-99698-91	4268273256	6886 Central Ave, Seattle, WA, 98186	0.38	Name split from “Last, First”Date of birth unreadable Phone reformatted Street suffix standardised+3 more
CLM-408131	CLM	Isabella Stephens	—	UHC-87565-33	—	7416 Lincoln Way, Gilbert, AZ, 85296	0.38	Date of birth unreadable Member ID reformatted State name converted to code ZIP+4 trimmed+3 more
CLM-419389	CLM	Shirley Gutierrez	—	—	—	2473 Willow Ct, San Antonio, TX, 78276	0.38	Date of birth unreadable Street suffix standardised Address re-cased State name converted to code+3 more
ENR-110536	ENR	Evelyn Griffin	—	UHC-10238-52	9017996349	5030 Market St Apt 32, Columbus, OH, 43269	0.38	Name split from “Last, First”Date of birth unreadable Phone reformatted Member ID reformatted+3 more
CLM-412305	CLM	Sharon Davis	—	—	5394251076	5576 Highland Ave, Fresno, CA	0.38	Name split from “Last, First”Date of birth unreadable Phone reformatted Street suffix standardised+3 more
CLM-422061	CLM	George R Mason	—	—	—	4247 Desert Sky Blvd, Charlotte, NC	0.38	Date of birth unreadable Street suffix standardised Address re-cased State name converted to code+3 more
ENR-115585	ENR	Jason W Robinson	—	—	5295219982	3577 Lake View Rd Apt 37, Atlanta, GA, 30390	0.38	Name split from “Last, First”Date of birth unreadable Phone reformatted Unit split from street+3 more
ENR-106887	ENR	Frank F Padilla	—	UHC-18739-54	6403168158	3588 River Rd, Minneapolis, MN	0.38	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-131757	ENR	Emma G Santtos	—	UHC-89792-57	—	8719 Union St, Las Vegas, NV, 89134	0.38	Name split from “Last, First”Date of birth unreadable Phone missing area code Street suffix standardised+3 more
ENR-138635	ENR	Priya T Reyes	—	UHC-83218-83	—	3597 Meadow Ln, Sacramento, CA, 95847	0.38	Date of birth unreadable Phone missing area code Street suffix standardised Address re-cased+3 more
CLM-430456	CLM	Ralph Grcia	—	UHC-55034-74	—	2592 Forest Ave, Miami, FL, 33115	0.38	Name re-cased Date of birth unreadable SSN last four extracted Street suffix standardised+3 more
CLM-411028	CLM	Carollyn Chen	—	UHC-46103-72	—	2822 Sunset Blvd # 837, Glendale, AZ, 85314	0.38	Name split from “Last, First”Date of birth unreadable Unit split from street Street suffix standardised+3 more
TPA-64031	TPA	Linda Munoz	—	—	2278087960	5984 Harbor Blvd Apt 19, Columbus, OH, 43261	0.38	Name split from “Last, First”Date of birth unreadable Unit split from street Street suffix standardised+3 more
ENR-119843	ENR	Lori Cole	—	UHC-55402-62	6552756205	6098 Harbor Blvd, Seattle, WA, 98145	0.38	Name split from “Last, First”Date of birth unreadable Phone reformatted Street suffix standardised+3 more
CLM-432465	CLM	Michael Stewart	—	UHC-09021-38	2963423490	6202 Washington St Apt 34, San Diego, CA, 92163	0.38	Name split from “Last, First”Date of birth unreadable Phone reformatted Unit split from street+3 more
CLM-432464	CLM	Michael Stewart	—	UHC-09021-38	2963423490	6202 Washington St Apt 34, San Diego, CA, 92163	0.38	Name split from “Last, First”Date of birth unreadable Phone reformatted Unit split from street+3 more
PRV-25423	PRV	Jon Hughes	—	UHC-60893-02	4759415575	1879 Union St, Fresno, CA, 93779	0.38	Name split from “Last, First”Date of birth unreadable Phone reformatted Street suffix standardised+3 more
CLM-410929	CLM	Alice Armstrong	—	UHC-01835-54	—	7640 Forest Ave Apt 18, Columbus, OH, 43261	0.38	Date of birth unreadable Unit split from street Street suffix standardised Address re-cased+3 more
CLM-412229	CLM	Yuki O King	—	—	—	3840 Canyon Rd, Miami, FL, 33179	0.38	Name split from “Last, First”Date of birth unreadable Street suffix standardised Address re-cased+3 more
TPA-60092	TPA	Carol Pierce	—	UHC-80359-24	—	7677 Baseline Rd Apt 33, Fresno, CA, 93773	0.38	Name re-cased Date of birth unreadable Unit split from street Street suffix standardised+3 more
ENR-138481	ENR	Mason B Hill	—	UHC-48547-94	5939778967	4209 Elm St, San Diego, CA, 92141	0.38	Name split from “Last, First”Date of birth reformatted Date of birth unreadable Phone reformatted+3 more
TPA-51470	TPA	Margaret Daniels	—	—	—	6083 Canyon Rd Apt 32, Tucson, AZ, 85725	0.38	Date of birth unreadable Unit split from street Street suffix standardised Address re-cased+3 more
TPA-62063	TPA	Isabella George	—	UHC-68744-67	—	9793 Lake View Rd Apt 23, Austin, TX	0.38	Date of birth unreadable Unit split from street Street suffix standardised Address re-cased+3 more
PRV-22293	PRV	Luis Carlson	—	UHC-63765-77	—	8906 Meadow Ln, Tempe, AZ	0.38	Name re-cased Date of birth unreadable Street suffix standardised Address re-cased+3 more
CLM-423147	CLM	Bobby Admas	—	UHC-70130-54	—	8522 Spring St, Plano, TX	0.38	Name split from “Last, First”Date of birth unreadable Street suffix standardised Address re-cased+3 more
CLM-432206	CLM	Russell Andrews	—	—	—	672 Bayshore Dr # 481, Los Angeles, CA, 90038	0.38	Date of birth unreadable Phone missing area code Unit split from street Street suffix standardised+3 more
ENR-136338	ENR	Johnston Grace	—	UHC-06724-33	3084562016	5768 Jefferson Ave # 562, Fresno, CA	0.38	Name split from “Last, First”Date of birth unreadable Phone reformatted Unit split from street+3 more
CLM-427876	CLM	Maria Palmer	—	UHC-45838-69	—	9185 Highland Ave, Las Vegas, NV	0.38	Name re-cased Date of birth unreadable Phone missing area code Street suffix standardised+3 more
ENR-111766	ENR	Henry A Adams	—	UHC-21262-29	6504101200	1169 Elm St, Plano, TX, 75003	0.38	Date of birth unreadable Phone reformatted Street suffix standardised Address re-cased+3 more
ENR-138468	ENR	Carl C Milller	—	UHC-42305-55	9457385035	170 Willow Ct, Miami, FL	0.38	Name re-cased Date of birth unreadable Phone reformatted Street suffix standardised+3 more

2,274 rows, page 3 of 46Previous Next