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 “Unit split from street”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagUnit split from streetClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
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
PRV-22820	PRV	Jonathan M Patel	1961-12-21	—	2478348380	4336 Desert Sky Blvd Apt 33, Glendale, AZ, 85381	0.38	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+3 more
ENR-123428	ENR	Ralph Gibson	1987-03-21	UHC-51268-55	5698447571	2194 Baseline Rd # 791, Miami, FL, 33143	0.38	Name re-cased SSN last four extracted Unit split from street Street suffix standardised+3 more
CLM-422865	CLM	Sharon Q Reyes	—	UHC-18188-08	—	8929 Forest Ave # 477, San Antonio, TX, 78231	0.38	Name re-cased Date of birth missing SSN last four extracted Unit split from street+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-418227	CLM	Terry Medina	1965-02-08	UHC-89474-97	5184330047	9633 Sage Ct Apt 4, Eden Prairie, MN, 55316	0.38	Name split from “Last, First”Phone reformatted Unit split from street Street suffix standardised+3 more
PRV-20080	PRV	Carolyn Fernandez	1976-01-27	—	7646313760	6529 Central Ave Apt 16, Houston, TX, 77055	0.38	Two-digit birth year Unit split from street 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
CLM-406858	CLM	Becky Yang	—	—	—	8845 Harbor Blvd Apt 8, Los Angeles, CA	0.38	Date of birth missing Unit split from street Street suffix standardised Address re-cased+3 more
ENR-106398	ENR	Priya V Burton	1971-02-22	UHC-88178-11	7963211040	5714 Park Pl Apt 24, Columbus, OH, 43229	0.38	Phone reformatted SSN last four extracted Unit split from street Street suffix standardised+3 more
CLM-425447	CLM	Sarah Bailey	1971-09-27	UHC-07917-53	—	5551 Washington St # 479, Dallas, TX, 75228	0.38	Unit split from street Street suffix standardised Address re-cased City re-cased+3 more
ENR-131291	ENR	Lisa Wong	1966-09-13	UHC-10089-20	5915578825	6788 Oak St Apt 39, Tucson, AZ	0.38	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+3 more
ENR-112268	ENR	Ryan Reynolds	1936-06-06	UHC-66475-43	2264958632	7232 Palm Dr # 489, Plano, TX, 75088	0.38	Phone reformatted SSN last four extracted Unit split from street Street suffix standardised+3 more
ENR-127556	ENR	Angela Q Williamson	1947-10-26	UHC-83917-22	3385373086	6565 Baseline Rd Apt 16, Phoenix, AZ, 85072	0.38	Name re-cased Two-digit birth year Phone reformatted Unit split from street+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-114058	ENR	Harold U Nelson	1971-09-18	UHC-43965-26	3195965425	918 Elm St # 112, Austin, TX, 78796	0.38	Name split from “Last, First”Date of birth reformatted Phone reformatted Unit split from street+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
ENR-117957	ENR	Karen Luna	1909-04-10	UHC-61000-68	2092799432	4710 Sage Ct # 101, Los Angeles, CA, 90031	0.38	Unit split from street Street suffix standardised Address re-cased State name converted to code+3 more
PRV-21317	PRV	Amber Mejia	1953-02-17	UHC-13136-66	—	5149 Mesa Dr Apt 11, Gilbert, AZ	0.38	Name re-cased Unit split from street Street suffix standardised Address re-cased+3 more
CLM-409866	CLM	Catherine Harper	2000-10-15	UHC-66620-68	—	5487 Ridge Rd Apt 35, Charlotte, NC, 28223	0.38	Name split from “Last, First”Unit split from street Street suffix standardised Address re-cased+3 more
CLM-428210	CLM	Beverrly Gonzalez	—	—	—	6102 Camelback Rd # 289, Seattle, WA, 98122	0.38	Name split from “Last, First”Date of birth missing Unit split from street Street suffix standardised+3 more
PRV-26787	PRV	Wayne Watkins	1997-09-27	UHC-85364-47	3693959993	2153 Ocean Ave # 670, Seattle, WA, 98130	0.38	Phone reformatted Member ID reformatted Unit split from street Street suffix standardised+3 more
ENR-130345	ENR	Wayne Munoz	1967-01-14	UHC-01248-01	7696764295	4772 Church St # 691, Las Vegas, NV, 89109	0.38	Two-digit birth year Phone reformatted Unit split from street Street suffix standardised+3 more
TPA-60741	TPA	Omar Perez	1976-02-05	—	2689089198	5497 Canyon Rd Apt 34, Las Vegas, NV, 89146	0.38	Two-digit birth year Phone reformatted Unit split from street Street suffix standardised+3 more
ENR-115478	ENR	Pena R Douglas	1965-08-05	UHC-46619-09	—	9100 Bayshore Dr Apt 30, Eden Prairie, MN, 55379	0.38	Name split from “Last, First”Date of birth reformatted Unit split from street Street suffix standardised+3 more
TPA-53004	TPA	Nick Freeman	1983-04-22	—	3909305256	3594 Baseline Rd # 651, Scottsdale, AZ, 85294	0.38	Name split from “Last, First”Two-digit birth year Phone reformatted Unit split from street+3 more
CLM-408222	CLM	Sarah Spencer	2001-06-11	—	7296822004	1763 Ridge Rd Apt 17, Eden Prairie, MN, 55316	0.38	Name split from “Last, First”Phone reformatted SSN last four extracted Unit split from street+3 more
CLM-403019	CLM	Nancy S Vazquez	1967-08-27	UHC-61543-39	—	4030 Maple Ave Apt 21, Scottsdale, AZ, 85207	0.38	Unit split from street Street suffix standardised Address re-cased State name converted to code+3 more
CLM-416908	CLM	Mariana Montgomery	1976-07-26	UHC-28635-58	—	2287 Main St # 803, Las Vegas, NV, 89188	0.38	Member ID reformatted Unit split from street Street suffix standardised Address re-cased+3 more
ENR-123306	ENR	Sophia B Martinez	1950-04-27	UHC-22861-85	—	9261 Lake View Rd # 553, Mesa, AZ, 85258	0.38	Name split from “Last, First”Unit split from street Street suffix standardised Address re-cased+3 more
ENR-127902	ENR	Elizabeth L Santiago	1974-02-24	UHC-79914-44	4634165665	1713 Ridge Rd Apt 35, Mesa, AZ, 85274	0.38	Phone reformatted Unit split from street Street suffix standardised Address re-cased+3 more
TPA-54255	TPA	Christian Weber	2008-09-04	—	—	9393 Cedar Ln # 333, Plano, TX	0.38	Two-digit birth year Unit split from street Street suffix standardised Address re-cased+3 more
ENR-142863	ENR	Robert T Ray	1986-11-19	UHC-38009-75	7018501011	9442 Pine Dr # 634, Seattle, WA, 98128	0.38	Name split from “Last, First”Phone reformatted Unit split from street Street suffix standardised+3 more
ENR-103027	ENR	Sofia Chapman	1999-03-14	UHC-10483-07	4604858090	7739 Spring St Apt 30, Sacramento, CA, 95803	0.38	Two-digit birth year Unit split from street Street suffix standardised Address re-cased+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
ENR-101689	ENR	Kelly K James	1949-07-15	UHC-76653-03	4899169112	1768 Maple Ave # 797, Eden Prairie, MN	0.38	Name split from “Last, First”Phone reformatted Unit split from street Street suffix standardised+3 more
ENR-121000	ENR	Daniel K Ramirez	1992-09-15	UHC-57427-66	6727715403	815 Sunset Blvd Apt 19, Miami, FL, 33128	0.38	Middle initial moved out of first name Date of birth reformatted Phone reformatted SSN last four extracted+3 more
ENR-116426	ENR	Jessica Le	2001-02-20	UHC-95382-27	3967132055	2209 Hillcrest Rd # 758, Glendale, AZ	0.38	Two-digit birth year Phone reformatted Member ID reformatted Unit split from street+3 more
ENR-101503	ENR	Henry V Mills	1966-08-19	UHC-95628-44	4897836199	5038 Hillcrest Rd Apt 11, Mesa, AZ, 85261	0.38	Middle initial moved out of first name Two-digit birth year Phone reformatted Unit split from street+3 more
PRV-28987	PRV	Ahmed Freeman	1940-09-12	—	—	1848 Pine Dr Apt 28, Las Vegas, NV, 89180	0.38	Name split from “Last, First”Unit split from street Street suffix standardised Address re-cased+3 more
ENR-105123	ENR	Sofia H Oliver	1982-08-21	UHC-82300-20	—	3300 Meadow Ln Apt 23, Las Vegas, NV, 89149	0.38	Name re-cased Phone missing area code Unit split from street Street suffix standardised+3 more
ENR-111892	ENR	Anna J Allen	1977-07-07	UHC-01802-26	—	4429 Mesa Dr Apt 26, Tempe, AZ, 85289	0.38	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+3 more
TPA-51116	TPA	Mateo Day	1993-12-23	UHC-73777-46	—	9132 Main St Apt 24, Las Vegas, NV	0.38	Name re-cased Two-digit birth year Unit split from street ZIP missing+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
TPA-53407	TPA	Gabriel Washington	1964-10-07	—	—	7013 Spring St Apt 7, Mesa, AZ, 85252	0.38	Name split from “Last, First”Unit split from street Street suffix standardised Address re-cased+3 more
ENR-120496	ENR	Emma Perkins	1946-06-15	UHC-34856-35	—	683 Union St Apt 26, Austin, TX, 78728	0.38	SSN last four extracted Unit split from street Street suffix standardised Address re-cased+3 more
TPA-51073	TPA	Bruce Myers	1997-07-10	—	—	162 Ridge Rd Apt 4, San Antonio, TX, 78202	0.38	Phone missing area code Unit split from street Street suffix standardised Address re-cased+3 more
PRV-20214	PRV	Dieo Holmes	1965-05-21	—	5844510758	5512 Sage Ct # 596, Scottsdale, AZ, 85238	0.38	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+3 more
ENR-101971	ENR	Anna M Sanchez	1964-01-06	UHC-55023-31	4823316465	879 Palm Dr Apt 5, Austin, TX, 78728	0.38	Name split from “Last, First”Date of birth reformatted Unit split from street Street suffix standardised+3 more
CLM-400767	CLM	Judith Bradley	1951-09-25	UHC-02771-26	4184222161	6045 Lake View Rd # 177, Las Vegas, NV	0.38	Name split from “Last, First”Phone reformatted Unit split from street Street suffix standardised+3 more

6,994 rows, page 10 of 140Previous Next