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 “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
PRV-20474	PRV	Maria P Peterson	1984-06-19	UHC-70195-31	8104349538	9048 Lake View Rd, Tempe, AZ, 85271	0.88	Name re-cased Phone reformatted State code upper-cased Email lower-cased+2 more
CLM-415771	CLM	William Carlson	1991-12-18	UHC-03108-32	2307520205	4889 Willow Ct, Seattle, WA, 98148	0.88	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-110383	ENR	Russell M Jenkins	1981-01-19	UHC-53169-39	3286834487	3948 Church St, Sacramento, CA, 95868	0.88	Phone reformatted City re-cased State code upper-cased Email lower-cased+2 more
CLM-432530	CLM	Robert Lewis	1938-06-12	UHC-97618-20	3827826549	1524 Oak St, Sacramento, CA, 95858	0.88	Name re-cased Phone reformatted State code upper-cased Email lower-cased+2 more
PRV-22766	PRV	Mariana J Jimenez	1965-07-21	—	9015991310	4008 Church St, Miami, FL, 33101	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
ENR-107218	ENR	Watson N Steven	1974-11-05	UHC-12782-69	2099274389	8584 Valley View Dr, Denver, CO, 80290	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
CLM-408105	CLM	Angela Wright	1957-10-18	UHC-17417-94	6426097904	706 Maple Ave, Denver, CO, 80229	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
CLM-415983	CLM	Christine Harvey	1997-03-09	UHC-40603-08	—	141 Apache Blvd, Tucson, AZ, 85753	0.88	Name re-cased Date of birth reformatted City re-cased State code upper-cased+2 more
ENR-116774	ENR	Ssuan X Cunningham	1972-05-03	UHC-54309-49	3028957021	1351 Baseline Rd, Gilbert, AZ, 85266	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-124356	ENR	Sarah T Bowman	1997-02-21	UHC-34402-83	8094501550	8490 Spring St, Scottsdale, AZ, 85206	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
CLM-411656	CLM	Ann Williamson	1963-04-10	UHC-19399-24	5353523822	402 Elm St, Miami, FL, 33107	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
CLM-417143	CLM	Santiago Edwards	2005-04-18	UHC-35700-34	6012477087	2556 Oak St, Sacramento, CA, 95847	0.88	Name re-cased Phone reformatted State code upper-cased Email lower-cased+2 more
CLM-408942	CLM	Susan Garrett	1939-08-02	UHC-86282-68	6795593135	4507 Ridge Rd, Denver, CO, 80256	0.90	Phone reformatted Member ID reformatted State code upper-cased Whitespace trimmed+1 more
ENR-108296	ENR	Nancy N Bishop	1989-02-21	UHC-38129-07	4047914035	1959 Ocean Ave, Orlando, FL, 32821	0.90	Date of birth reformatted Phone reformatted Member ID reformatted State code upper-cased+1 more
CLM-406090	CLM	Stephen W Maldonado	1941-06-16	UHC-08829-69	6146437845	5247 Hillcrest Rd, Sacramento, CA, 95839	0.90	Name re-cased Phone reformatted Member ID reformatted State code upper-cased+1 more
ENR-120265	ENR	Maggie Cooper	1987-08-27	UHC-09187-36	9794996030	2564 Lake View Rd, Phoenix, AZ, 85003	0.90	Name re-cased Phone reformatted City re-cased State code upper-cased+1 more
ENR-127032	ENR	Omar Lopez	1969-11-17	UHC-67709-81	8007005328	7192 Maple Ave, Columbus, OH, 43285	0.90	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+1 more
ENR-127033	ENR	Omar Lopez	1969-11-17	UHC-67709-81	8007005328	7192 Maple Ave, Columbus, OH, 43285	0.90	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+1 more
ENR-103917	ENR	Elizabeth Allen	1941-02-01	UHC-45019-87	9292695739	6838 Washington St, Miami, FL, 33105	0.90	Phone reformatted State code upper-cased Email lower-cased Whitespace trimmed+1 more
ENR-111407	ENR	Jim Ramirez	2000-11-27	UHC-84711-77	7298398022	6848 Valley View Dr, Chandler, AZ, 85290	0.90	Date of birth reformatted Phone reformatted State code upper-cased Whitespace trimmed+1 more
CLM-406528	CLM	Lauren Perry	1948-09-28	—	—	7404 Desert Sky Blvd, Eden Prairie, MN, 55338	0.90	Name re-cased Date of birth reformatted State code upper-cased Whitespace trimmed+1 more
PRV-25253	PRV	Cheryl Cunningham	1963-02-20	UHC-69862-58	8194278892	9223 Elm St, Seattle, WA, 98192	0.90	Date of birth reformatted Phone reformatted Member ID reformatted State code upper-cased+1 more
CLM-430378	CLM	Brenda Parker	1959-12-24	UHC-50412-36	—	6506 Elm St, Austin, TX, 78775	0.90	Name re-cased Date of birth reformatted State code upper-cased Whitespace trimmed+1 more
CLM-417208	CLM	Maria Ryan	1965-03-01	UHC-53814-07	2898118492	8437 Lake View Rd, Atlanta, GA, 30370	0.90	Name re-cased Phone reformatted State code upper-cased Whitespace trimmed+1 more
CLM-418383	CLM	Brenda Hernandez	1997-04-12	UHC-85229-30	—	1513 Bayshore Dr, Seattle, WA, 98146	0.90	Name re-cased Date of birth reformatted State code upper-cased Whitespace trimmed+1 more
CLM-419420	CLM	Evelyn Vargas	1969-01-18	UHC-34654-11	5484943332	9477 Forest Ave, Plano, TX, 75085	0.90	Date of birth reformatted Phone reformatted City re-cased State code upper-cased+1 more
CLM-429514	CLM	Sofia M Richards	1997-06-09	UHC-38846-21	5318896083	7080 Market St, Tampa, FL, 33690	0.90	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+1 more
TPA-63773	TPA	Adams K Zachary	1959-02-12	UHC-77933-88	8083152134	5796 Broadway, Orlando, FL, 32841	0.90	Name re-cased Phone reformatted Address re-cased State code upper-cased+1 more
PRV-24543	PRV	Philip E Marquez	1996-12-05	—	4993872619	875 Broadway, Seattle, WA, 98117	0.90	Name re-cased Phone reformatted Address re-cased State code upper-cased+1 more
ENR-131547	ENR	Noah Willis	1989-12-23	UHC-78154-98	6124975569	526 Sage Ct, Sacramento, CA, 95846	0.90	Phone reformatted State code upper-cased Email lower-cased Whitespace trimmed+1 more
ENR-107170	ENR	Jake U McDonald	1938-03-26	UHC-99272-28	7167501791	2266 Washington St, Nashville, TN, 37213	0.90	Name re-cased Date of birth reformatted State code upper-cased Email lower-cased+1 more
ENR-113191	ENR	Priya McDonald	2007-08-25	UHC-04817-13	7127730023	5470 Market St, Tucson, AZ, 85708	0.90	Phone reformatted Member ID reformatted State code upper-cased Whitespace trimmed+1 more
ENR-130491	ENR	Carol C Reed	1996-08-27	UHC-69430-37	6412893087	8397 River Rd, Charlotte, NC, 28205	0.90	Phone reformatted City re-cased State code upper-cased Whitespace trimmed+1 more
ENR-102173	ENR	Emma Q Cole	1979-10-18	UHC-27598-23	7923069816	8778 Pine Dr, Denver, CO, 80250	0.90	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+1 more
TPA-52865	TPA	Jordan V Garcia	1983-04-26	—	5989909297	8139 Harbor Blvd, Chandler, AZ, 85267	0.90	Date of birth reformatted Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-26210	PRV	Mason Ortiz	2008-02-08	UHC-43983-84	8272432942	9428 Lake View Rd, Tempe, AZ, 85262	0.90	Date of birth reformatted Member ID reformatted State code upper-cased Whitespace trimmed+1 more
CLM-416691	CLM	Brian Morales	1956-07-09	UHC-33115-57	9572511042	2056 Lincoln Way, Columbus, OH, 43288	0.90	Date of birth reformatted Phone reformatted State code upper-cased Whitespace trimmed+1 more
ENR-120203	ENR	Margaret Burke	1993-12-13	UHC-14555-90	8608464900	2687 Canyon Rd, Nashville, TN, 37222	0.90	Name re-cased Phone reformatted Member ID reformatted State code upper-cased+1 more
ENR-100007	ENR	Evelyn Watkins	1994-09-17	UHC-98409-62	3213493348	6607 Broadway, Chandler, AZ, 85248	0.90	Name re-cased Phone reformatted State code upper-cased Whitespace trimmed+1 more
PRV-25777	PRV	Rachel Freeman	1974-12-07	—	9563321775	7580 Central Ave, Nashville, TN, 37276	0.90	Name re-cased City re-cased State code upper-cased Whitespace trimmed+1 more
ENR-141170	ENR	Daniel A Fowler	1974-12-04	UHC-99397-30	3517585193	9441 Broadway, Atlanta, GA, 30300	0.90	Phone reformatted Address re-cased State code upper-cased Whitespace trimmed+1 more
ENR-136886	ENR	Barbara Howell	1968-03-16	UHC-00518-51	3899438546	6495 Mountain View Dr, Los Angeles, CA, 90062	0.90	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+1 more
PRV-23254	PRV	Adam A Weaver	1941-07-08	—	2108899697	4901 Spring St, Mesa, AZ, 85271	0.90	Phone reformatted City re-cased State code upper-cased Email lower-cased+1 more
ENR-117211	ENR	Kenneth S Perkins	2003-07-24	UHC-16787-95	—	4677 Valley View Dr, Scottsdale, AZ, 85266	0.90	Name re-cased State code upper-cased Email lower-cased Whitespace trimmed+1 more
ENR-134596	ENR	Albert Q Dominguez	1962-10-24	UHC-79602-45	2636157292	299 Bayshore Dr, Houston, TX, 77007	0.90	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+1 more
ENR-118237	ENR	Dors A Singh	1950-09-25	UHC-06680-50	4216081762	7706 Sage Ct, Las Vegas, NV, 89120	0.90	Name re-cased Phone reformatted City re-cased State code upper-cased+1 more
ENR-137026	ENR	Dorothy Ortega	1971-07-07	UHC-76525-44	5639145188	3937 Cedar Ln, Chandler, AZ, 85261	0.90	Date of birth reformatted Phone reformatted State code upper-cased Whitespace trimmed+1 more
ENR-129523	ENR	Sanders N Samantha	2005-09-08	UHC-81981-41	4678415451	6486 Elm St, Sacramento, CA, 95873	0.90	Phone reformatted State code upper-cased Email lower-cased Whitespace trimmed+1 more
ENR-116501	ENR	Karen E Wagner	1995-02-07	UHC-77548-67	5572330096	3199 Market St, Nashville, TN, 37213	0.90	Name re-cased Phone reformatted City re-cased State code upper-cased+1 more
ENR-112127	ENR	Steven Hunter	2008-08-07	UHC-69181-75	6282254818	8557 Valley View Dr, Charlotte, NC, 28270	0.90	Phone reformatted City re-cased State code upper-cased Whitespace trimmed+1 more

4,010 rows, page 68 of 81Previous Next