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

Provider network, flag “Date of birth reformatted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagDate of birth reformattedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-21288	PRV	Thomas Espinoza	1975-04-25	—	2457435717	2938 Maple Ave, Atlanta, GA, 30397	0.64	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised+2 more
PRV-24778	PRV	Austin A Le	1972-03-20	UHC-07743-05	5135147533	8887 Sage Ct, Mesa, AZ, 85247	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+2 more
PRV-25404	PRV	Kayla Reid	1950-11-06	—	9527451399	1181 Sage Ct, Plano, TX, 75014	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
PRV-26460	PRV	Melissa E Kennedy	1998-11-03	—	4643405080	7833 Park Pl, Fresno, CA, 93785	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+2 more
PRV-22342	PRV	Brian Ortiz	1959-11-08	—	5194910191	6054 Cedar Ln, Tampa, FL, 33660	0.64	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised+2 more
PRV-26196	PRV	Nicole Snyder	1988-07-06	—	3302417673	6336 Spring St, San Antonio, TX	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-24010	PRV	Dennis Elliott	1975-04-06	—	4146987519	3313 Maple Ave, Gilbert, AZ, 85265	0.64	Name re-cased Date of birth reformatted ZIP+4 trimmed Gender normalised+2 more
PRV-26487	PRV	Gary V Hill	—	UHC-08265-40	4896713363	1930 Apache Blvd, Seattle, WA, 98148	0.64	Date of birth reformatted Date of birth unreadable Phone reformatted Street suffix standardised+2 more
PRV-21157	PRV	Roy Morales	1969-09-21	—	5738175102	3291 Sunset Blvd, Glendale, AZ, 85350	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-27078	PRV	Mark Kelly	1978-10-13	UHC-20486-09	2392338348	9319 Main St, San Diego, CA, 92127	0.64	Date of birth reformatted Member ID reformatted Street suffix standardised Address re-cased+2 more
PRV-24332	PRV	Eugene Crawford	1980-09-21	—	8894951061	2129 Indian School Rd # 429, Scottsdale, AZ, 85202	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
PRV-27041	PRV	Judy Montgomery	1962-02-14	UHC-91198-73	7003875748	6221 Central Ave, Eden Prairie, MN, 55388	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+2 more
PRV-27074	PRV	Denise Z Jackson	1949-03-07	—	6568391082	3077 Valley View Dr, Tampa, FL, 33626	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
PRV-24532	PRV	Jason Nelson	1940-05-07	—	2235692840	563 Church St, Sacramento, CA, 95840	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
PRV-22378	PRV	Logan Walsh	1984-05-12	UHC-23715-26	—	1129 Lake View Rd, Tucson, AZ	0.64	Name re-cased Date of birth reformatted ZIP missing Gender normalised+2 more
PRV-21989	PRV	Maria Robinson	1962-12-03	UHC-39058-94	2829200240	717 Grand Ave, Columbus, OH	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-23844	PRV	Frank Q Bailey	1949-06-25	UHC-20314-33	—	7687 Indian School Rd Apt 20, Las Vegas, NV, 89150	0.64	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-27605	PRV	Donna Silva	1989-10-06	UHC-90917-79	—	9374 Sage Ct # 789, Las Vegas, NV, 89168	0.64	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-29309	PRV	Roy James	2008-11-12	—	5557193929	6635 Park Pl, Las Vegas, NV, 89178	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted City re-cased+2 more
PRV-22396	PRV	Helen Austin	2003-09-10	UHC-03615-98	5828197153	9204 Ridge Rd, Glendale, AZ	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP missing+2 more
PRV-23899	PRV	Debra Andrews	1954-06-12	UHC-65044-44	9074490704	6835 Jefferson Ave, Tempe, AZ, 85246	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-27663	PRV	Charlotte H Harrison	1984-07-09	UHC-95450-37	6477884467	6728 Elm St, Seattle, WA, 98198	0.64	Name re-cased Date of birth reformatted Street suffix standardised Address re-cased+2 more
PRV-26907	PRV	Betty Gray	1982-10-01	UHC-11992-16	2689551181	1627 Mesa Dr, Miami, FL, 33186	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+2 more
PRV-23259	PRV	Patricia Kennedy	1991-09-17	—	—	6142 Harbor Blvd, Los Angeles, CA, 90015	0.64	Name split from “Last, First”Date of birth reformatted Street suffix standardised Address re-cased+2 more
PRV-24839	PRV	Samantha Graham	1950-02-18	—	3842804243	6339 Mountain View Dr, Glendale, AZ	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-21982	PRV	Gloria Stone	1965-04-03	UHC-46016-18	4863376974	2107 Park Pl, Charlotte, NC, 28202	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-27809	PRV	Deborah S Burns	1980-01-12	—	2202424505	2696 Willow Ct, Fresno, CA, 93727	0.64	Date of birth reformatted Street suffix standardised Address re-cased State code upper-cased+2 more
PRV-28297	PRV	—Junk	1985-02-21	UHC-13034-08	5565850121	2552 Maple Ave, Jacksonville, FL, 32230	0.64	Date of birth reformatted Street suffix standardised Address re-cased Whitespace trimmed+2 more
PRV-25238	PRV	Wei G Harris	1954-03-16	UHC-52056-94	5394748760	5028 Ridge Rd, Columbus, OH, 43212	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Street suffix standardised+2 more
PRV-28692	PRV	Charles McDonald	1943-08-24	—	6962489850	841 Spring St, Orlando, FL, 32851	0.64	Date of birth reformatted Street suffix standardised Address re-cased City re-cased+2 more
PRV-24341	PRV	Denise Stephens	1988-01-26	UHC-00197-62	—	538 Bayshore Dr, Atlanta, GA, 30320	0.64	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code+2 more
PRV-25535	PRV	Gary Brown	1950-01-24	—	4588476731	5247 Jefferson Ave, Tucson, AZ	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-20755	PRV	Albart Myers	1959-03-01	—	—	2650 Mountain View Dr, Denver, CO, 80224	0.64	Date of birth reformatted SSN last four extracted Street suffix standardised Address re-cased+2 more
PRV-21106	PRV	Mark Fox	1993-04-05	—	7479183905	1877 Indian School Rd, Atlanta, GA, 30302	0.64	Date of birth reformatted Phone reformatted State name converted to code Gender normalised+2 more
PRV-23771	PRV	Kayla Reid	2003-09-12	—	9277256579	2115 Market St, Sacramento, CA, 95845	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted ZIP+4 trimmed+2 more
PRV-21401	PRV	Marcus Hart	1983-11-13	—	—	3873 Lincoln Way, Gilbert, AZ, 85279	0.64	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised+2 more
PRV-28127	PRV	David D Griffin	1958-07-13	UHC-59486-30	—	9704 Forest Ave, Scottsdale, AZ, 85264	0.64	Date of birth reformatted Street suffix standardised Address re-cased ZIP+4 trimmed+2 more
PRV-23608	PRV	Gloria Meyer	1997-04-17	—	7262763795	1137 Pine Dr, Houston, TX, 77008	0.64	Date of birth reformatted Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-23734	PRV	Robert Bradlay	1977-07-08	—	—	—	0.64	Name split from “Last, First”Date of birth reformatted Email lower-cased Gender normalised+2 more
PRV-27971	PRV	Lauren V Hoffman	1940-07-25	UHC-16769-64	—	1201 Meadow Ln, Jacksonville, FL, 32203	0.64	Name re-cased Date of birth reformatted Phone missing area code ZIP+4 trimmed+2 more
PRV-20575	PRV	Heather M Fisher	1961-01-07	—	5242070320	3767 Market St Apt 25, Los Angeles, CA, 90043	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Unit split from street+2 more
PRV-28751	PRV	Kyle Contreras	1962-06-10	UHC-17396-44	—	—	0.66	Name split from “Last, First”Date of birth reformatted Gender normalised Whitespace trimmed+1 more
PRV-20634	PRV	Sara Hamilton	1977-01-11	UHC-62889-75	5066014372	1559 Broadway, Seattle, WA, 98113	0.66	Name split from “Last, First”Date of birth reformatted Address re-cased ZIP+4 trimmed+1 more
PRV-25669	PRV	Karen S Rivera	1984-05-22	—	6439595537	9144 Ridge Rd Apt 34, Fresno, CA	0.66	Date of birth reformatted Phone reformatted Unit split from street ZIP missing+1 more
PRV-27397	PRV	Larry Duncan	1989-04-28	—	—	9313 Baseline Rd Apt 31, Eden Prairie, MN, 55346	0.66	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+1 more
PRV-27398	PRV	Larry Duncan	1989-04-28	—	—	9313 Baseline Rd Apt 31, Eden Prairie, MN, 55346	0.66	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+1 more
PRV-27133	PRV	Micahel Porter	2003-09-12	UHC-50791-32	4312582237	5538 Elm St, Houston, TX, 77079	0.66	Date of birth reformatted Street suffix standardised Address re-cased State name converted to code+1 more
PRV-27967	PRV	Marilyn Sullivn	1952-05-20	—	2748519508	5246 Desert Sky Blvd, Miami, FL	0.66	Name split from “Last, First”Date of birth reformatted ZIP missing Whitespace trimmed+1 more
PRV-21477	PRV	Jonathan Bell	1988-02-22	UHC-75396-89	—	4740 Forest Ave, Sacramento, CA, 95896	0.66	Date of birth reformatted Street suffix standardised Address re-cased Gender normalised+1 more
PRV-29043	PRV	Valentina Reid	1965-04-06	UHC-92970-85	—	6406 Camelback Rd, Nashville, TN, 37267	0.66	Date of birth reformatted Phone missing area code Street suffix standardised Address re-cased+1 more

3,124 rows, page 20 of 63Previous Next