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 “Two-digit birth year”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagTwo-digit birth yearClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-27259	PRV	Danielle Grahaam	1985-10-18	UHC-01900-59	3775011977	—	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-26537	PRV	Russell P Nunez	1987-06-15	—	2273469995	—	0.78	Two-digit birth year Phone reformatted Email lower-cased Whitespace trimmed+1 more
PRV-25594	PRV	Mei McDonald	1939-01-28	UHC-20880-78	4816081080	7772 Lincoln Way, Houston, TX, 77077	0.78	Two-digit birth year Phone reformatted City re-cased Whitespace trimmed+1 more
PRV-21685	PRV	Christina K Washington	1957-03-02	—	4935563798	6381 Palm Dr, Las Vegas, NV, 89126	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-22015	PRV	Jerry Fowler	1948-09-15	UHC-15169-15	2374041501	—	0.78	Name re-cased Two-digit birth year Email lower-cased Whitespace trimmed+1 more
PRV-24124	PRV	Angela Espinoza	2005-12-14	UHC-85864-70	4256206749	—	0.78	Name re-cased Two-digit birth year Member ID reformatted Whitespace trimmed+1 more
PRV-20285	PRV	Donna H Sanchez	1979-09-22	UHC-51598-69	5599370001	2472 Harbor Blvd, Scottsdale, AZ, 85225	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-23923	PRV	Tyler Allen	1971-09-22	—	6758426337	6556 Apache Blvd, Plano, TX, 75082	0.78	Name re-cased Two-digit birth year Phone reformatted City re-cased+1 more
PRV-26410	PRV	Randy I Lynch	1996-09-27	UHC-19138-60	8787679973	269 Canyon Rd, Eden Prairie, MN, 55336	0.78	Two-digit birth year Phone reformatted Plan code upper-cased Whitespace trimmed+1 more
PRV-28004	PRV	Randy Burton	1938-03-02	—	3015630417	—	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-22141	PRV	Carlos L Montgomery	1956-05-18	—	3434117803	9412 Broadway, Austin, TX, 78724	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-25698	PRV	Angela Gilbert	1953-10-11	UHC-84008-87	—	—	0.78	Name re-cased Two-digit birth year Plan code upper-cased Whitespace trimmed+1 more
PRV-20091	PRV	Kenneth Rivera	1965-01-14	—	2203600906	6922 Park Pl, Fresno, CA, 93706	0.78	Two-digit birth year Phone reformatted Email lower-cased Whitespace trimmed+1 more
PRV-21425	PRV	Gabriel Owens	1992-12-11	—	3666654353	5073 Desert Sky Blvd, Houston, TX, 77041	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-25007	PRV	Charles L Webb	1990-08-11	UHC-53654-01	4444079877	2023 Desert Sky Blvd, Las Vegas, NV, 89154	0.78	Two-digit birth year Phone reformatted City re-cased Whitespace trimmed+1 more
PRV-20196	PRV	David Medina	2006-04-26	UHC-31366-75	5305152628	—	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-22306	PRV	Sandra Yang	1961-10-20	UHC-18320-22	3794997151	4320 Ridge Rd, Tampa, FL, 33693	0.78	Name re-cased Two-digit birth year Phone reformatted City re-cased+1 more
PRV-29450	PRV	Arjn Kennedy	1955-04-24	UHC-46594-12	5762675777	—	0.78	Name re-cased Two-digit birth year Member ID reformatted Whitespace trimmed+1 more
PRV-25075	PRV	Diego Wood	1998-05-03	—	7676343463	—	0.78	Two-digit birth year Phone reformatted Email lower-cased Whitespace trimmed+1 more
PRV-25861	PRV	Judy Schmidt	2002-02-05	—	6373923645	4339 Park Pl, Tempe, AZ, 85233	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-27528	PRV	Marilyn Rice	1941-09-13	UHC-69910-24	4712389955	1406 Ocean Ave, Nashville, TN, 37235	0.78	Name re-cased Two-digit birth year City re-cased Whitespace trimmed+1 more
PRV-27882	PRV	Steven Foster	1976-12-16	—	9228164470	2034 Broadway, Jacksonville, FL, 32297	0.78	Two-digit birth year Phone reformatted Address re-cased Email lower-cased+1 more
PRV-24509	PRV	Fatima Myers	1948-02-05	—	9485978728	—	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-28869	PRV	Deborah Gordon	1995-09-18	—	—	5176 Mesa Dr, San Diego, CA, 92158	0.78	Two-digit birth year City re-cased State code upper-cased Whitespace trimmed+1 more
PRV-26845	PRV	Wong A Fraces	1997-11-20	—	7178921720	6245 Broadway, Denver, CO, 80235	0.78	Two-digit birth year Phone reformatted Address re-cased Whitespace trimmed+1 more
PRV-21548	PRV	Robert Hoffman	1985-03-22	—	5276517126	17 Palm Dr, Mesa, AZ, 85243	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-29246	PRV	Jack Gray	1966-11-25	UHC-88547-19	9105895781	6736 Church St, Sacramento, CA, 95837	0.78	Name re-cased Two-digit birth year City re-cased Whitespace trimmed+1 more
PRV-25540	PRV	Yuki Hanson	1981-03-04	UHC-02203-04	5829358898	—	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-20860	PRV	Noah M Morales	1958-04-26	UHC-68816-49	3374582516	8322 Maple Ave, San Antonio, TX, 78212	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-23375	PRV	Anthony Carr	1972-04-27	UHC-16569-19	5814629705	8920 Sage Ct, Mesa, AZ, 85273	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-21096	PRV	Dot Clark	1989-03-13	—	8518803134	9671 Sunset Blvd, San Antonio, TX, 78258	0.78	Two-digit birth year Phone reformatted City re-cased Whitespace trimmed+1 more
PRV-24302	PRV	Frank Walker	1952-01-25	—	7333134220	9876 Spring St, Mesa, AZ, 85228	0.78	Name re-cased Two-digit birth year City re-cased Whitespace trimmed+1 more
PRV-26705	PRV	Arthur V Lawson	1980-01-04	—	2375944552	—	0.78	Name re-cased Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-28826	PRV	Adam X Vega	1974-12-27	—	5372467498	3130 Cedar Ln, San Diego, CA, 92181	0.80	Name re-cased Two-digit birth year Plan code upper-cased Placeholder values cleared
PRV-22658	PRV	Bradley Belll	1989-10-15	—	6273622857	8241 Meadow Ln, Jacksonville, FL, 32268	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-24759	PRV	Brenda O Wong	1952-02-16	UHC-83913-18	2307310131	2021 Willow Ct, Miami, FL, 33163	0.80	Name re-cased Two-digit birth year Whitespace trimmed Placeholder values cleared
PRV-28002	PRV	Mary Coleman	1995-06-14	UHC-92494-52	5556313855	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-27815	PRV	Gary G Collins	1978-09-17	—	3428991081	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-29471	PRV	Jacob K Rojas	1988-12-24	—	7539003351	4083 Elm St, Plano, TX, 75028	0.80	Two-digit birth year Phone reformatted City re-cased Placeholder values cleared
PRV-24844	PRV	Arthur Wagner	1954-06-18	UHC-89496-41	5802720480	6277 Spring St, Tempe, AZ, 85224	0.80	Two-digit birth year Phone reformatted State code upper-cased Placeholder values cleared
PRV-25520	PRV	Douglas Day	1946-08-13	—	5553947248	3209 Washington St, Orlando, FL, 32814	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
PRV-25090	PRV	Eugene Parker	1988-06-25	—	7575722235	2035 Ocean Ave, Minneapolis, MN, 55413	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-27451	PRV	Gloria Clark	1976-08-27	—	7976787660	—	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
PRV-23351	PRV	Roger J Chavez	1990-11-09	UHC-74003-19	3275114423	148 Jefferson Ave, Los Angeles, CA, 90077	0.80	Name re-cased Two-digit birth year Whitespace trimmed Placeholder values cleared
PRV-23849	PRV	Walter F Bowmna	1954-11-01	—	5174906631	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-24265	PRV	Judith Howell	1993-05-02	UHC-20985-03	5544783967	5164 Park Pl, Houston, TX, 77081	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-22684	PRV	Kyle Ross	1970-08-03	—	2449000918	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-29439	PRV	Samantha Williamson	1992-05-21	—	7719194035	—	0.80	Two-digit birth year Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-25285	PRV	Mike S Lynch	1940-03-05	UHC-82219-84	8325494410	4883 Park Pl, Tempe, AZ, 85202	0.80	Name re-cased Two-digit birth year Phone reformatted Placeholder values cleared
PRV-22656	PRV	Alan Henry	1984-04-13	UHC-13004-16	6118710311	1586 Maple Ave, Jacksonville, FL, 32243	0.80	Name re-cased Two-digit birth year Whitespace trimmed Placeholder values cleared

690 rows, page 12 of 14Previous Next