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

Third-party administrator, flag “Street suffix standardised”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagStreet suffix standardisedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-56353	TPA	Brooks Valentina	1954-12-15	UHC-68658-61	8015204532	45 Hillcrest Rd, Minneapolis, MN, 55434	0.68	Street suffix standardised Address re-cased State name converted to code Placeholder values cleared
TPA-54090	TPA	Brandon Peena	1938-08-08	—	—	3328 Ridge Rd, Plano, TX	0.68	Street suffix standardised Address re-cased ZIP missing Placeholder values cleared
TPA-53353	TPA	Emma Graham	1978-09-13	—	—	6542 Central Ave, Glendale, AZ, 85306	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-56284	TPA	Bradley Arnold	1957-01-14	—	—	525 Lake View Rd, Gilbert, AZ, 85271	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
TPA-55482	TPA	Elizabeth Shaw	1951-01-16	—	3456900956	4539 Oak St, Gilbert, AZ, 85281	0.68	Street suffix standardised Address re-cased ZIP+4 trimmed Placeholder values cleared
TPA-55514	TPA	Amber Castro	1997-08-04	—	—	6391 Elm St, Atlanta, GA, 30358	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-57802	TPA	Andrea Patel	2008-04-01	—	—	9262 Hillcrest Rd, Columbus, OH, 43201	0.68	Street suffix standardised Address re-cased ZIP+4 trimmed Placeholder values cleared
TPA-62309	TPA	Jeffrey Y Guerrero	1971-02-16	UHC-34240-66	—	7245 Grand Ave, San Diego, CA, 92172	0.68	Two-digit birth year Street suffix standardised Address re-cased Placeholder values cleared
TPA-50468	TPA	David Contreras	1993-11-13	—	—	8288 Spring St, Glendale, AZ, 85345	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
TPA-63347	TPA	Lauren Barnes	—	—	—	9543 Union St, Denver, CO, 80206	0.68	Date of birth unreadable Street suffix standardised Address re-cased Placeholder values cleared
TPA-60008	TPA	Russell Gutierrez	1986-01-15	—	—	1669 Market St, Minneapolis, MN, 55454	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-61774	TPA	Fatima James	1959-08-22	—	—	751 Ridge Rd, Atlanta, GA, 30356	0.68	Two-digit birth year Street suffix standardised Address re-cased Placeholder values cleared
TPA-64324	TPA	Roger G Martinez	1990-03-15	—	—	6998 Cedar Ln, Phoenix, AZ, 85049	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-60868	TPA	Dorothhy C Fox	1960-10-15	—	—	6342 Willow Ct, Minneapolis, MN, 55430	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-55268	TPA	Abigail Taylor	1942-07-02	—	—	7514 Market St, Dallas, TX	0.68	Street suffix standardised Address re-cased ZIP missing Placeholder values cleared
TPA-58072	TPA	Lawrence Lane	2006-08-09	—	9502398303	2237 Camelback Rd, Los Angeles, CA, 90083	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-61982	TPA	Andrew B Henderson	1965-07-01	UHC-57798-24	—	5559 Maple Ave, Gilbert, AZ, 85226	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
TPA-60940	TPA	Benjamin Henry	—	—	—	6289 Desert Sky Blvd, Plano, TX, 75093	0.68	Date of birth unreadable Street suffix standardised Address re-cased Placeholder values cleared
TPA-60128	TPA	Joseph Young	1950-05-13	—	—	8157 Highland Ave, Scottsdale, AZ, 85245	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
TPA-63642	TPA	Dennis Brrown	1944-05-22	—	—	5143 Cedar Ln, Minneapolis, MN, 55447	0.68	Two-digit birth year Street suffix standardised Address re-cased Placeholder values cleared
TPA-56026	TPA	Alexis Stephens	1946-11-14	—	—	7276 Harbor Blvd, Denver, CO, 80295	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-59069	TPA	Elizabeth Daniels	1976-05-23	—	—	605 Lincoln Way, Austin, TX, 78751	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-52167	TPA	Rob Craford	2006-02-15	UHC-52692-57	—	4891 Meadow Ln, Sacramento, CA, 95837	0.68	Street suffix standardised Address re-cased State name converted to code Placeholder values cleared
TPA-50726	TPA	Ahmed K Hart	1960-03-01	—	—	4445 Jefferson Ave, Los Angeles, CA, 90039	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-61085	TPA	Sara Hoffman	1944-11-21	UHC-72647-57	—	4871 Forest Ave, Fresno, CA, 93792	0.68	Street suffix standardised Address re-cased ZIP+4 trimmed Placeholder values cleared
TPA-60946	TPA	Joe Weaver	1989-10-27	—	—	7990 Jefferson Ave, San Antonio, TX, 78245	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
TPA-53594	TPA	Ana Richards	2001-02-07	—	—	6758 Grand Ave # 689, Seattle, WA, 98131	0.68	Unit split from street Street suffix standardised Address re-cased Placeholder values cleared
TPA-56824	TPA	Olivia K Perez	1963-04-16	—	—	1737 Union St, Tampa, FL, 33689	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-59293	TPA	Amber Larson	—	UHC-72250-82	3707204126	9158 Washington St, Atlanta, GA, 30379	0.68	Date of birth unreadable Street suffix standardised Address re-cased Placeholder values cleared
TPA-53208	TPA	Ann Washngton	1963-12-28	UHC-77404-59	—	5383 Mountain View Dr, Gilbert, AZ, 85282	0.68	Street suffix standardised Address re-cased State name converted to code Placeholder values cleared
TPA-55309	TPA	Amy Dunn	1946-10-02	UHC-41815-99	—	2622 Camelback Rd, Chandler, AZ	0.68	Street suffix standardised Address re-cased ZIP missing Placeholder values cleared
TPA-60582	TPA	Mark Kelly	1978-10-13	—	2392338348	9319 Main St, San Diego, CA, 92127	0.68	Two-digit birth year Street suffix standardised Address re-cased Placeholder values cleared
TPA-50088	TPA	Roger X Ortiz	1970-12-19	—	—	7441 Bayshore Dr, Minneapolis, MN, 55411	0.68	Street suffix standardised Address re-cased State name converted to code Placeholder values cleared
TPA-51861	TPA	Virginia Lopez	1984-07-02	—	—	9805 Maple Ave, Charlotte, NC, 28277	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-51343	TPA	Fatima Jones	1965-05-13	—	—	8055 Harbor Blvd # 778, Seattle, WA, 98167	0.68	Unit split from street Street suffix standardised Address re-cased Placeholder values cleared
TPA-59373	TPA	Valentina Q Ellis	1949-10-14	—	—	3256 Market St, Tucson, AZ, 85710	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
TPA-57266	TPA	Martha Hawkins	2004-12-04	UHC-77244-10	—	3240 Baseline Rd, Houston, TX, 77021	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
TPA-51888	TPA	Catherine Richardson	1988-01-10	UHC-00641-21	4248223146	4471 Elm St, Seattle, WA, 98189	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
TPA-52653	TPA	Judy Wells	1938-01-11	—	—	9036 Valley View Dr, Tempe, AZ, 85211	0.68	Street suffix standardised Address re-cased State name converted to code Placeholder values cleared
TPA-57404	TPA	Daniel P Patel	1995-10-17	—	—	8966 Sunset Blvd, Las Vegas, NV, 89196	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-50516	TPA	Fatima Davis	1997-04-15	—	—	35 Cedar Ln, Chandler, AZ, 85259	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
TPA-62472	TPA	Roy Vargas	1985-08-04	—	5765607975	4832 Canyon Rd, Los Angeles, CA, 90037	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-50572	TPA	Amy Hayes	1953-06-10	—	—	8700 Maple Ave, Atlanta, GA, 30392	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-60047	TPA	Ruth K Aguilar	1995-07-04	—	6329985888	7008 Cedar Ln, Mesa, AZ, 85207	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared
TPA-55173	TPA	Kelly Martinez	1999-11-10	—	—	2305 Apache Blvd, Seattle, WA, 98160	0.68	Name split from “Last, First”Street suffix standardised Address re-cased Placeholder values cleared
TPA-53417	TPA	Paul P Ortega	1951-04-19	—	7929831343	7282 Cedar Ln, Los Angeles, CA	0.68	Street suffix standardised Address re-cased ZIP missing Placeholder values cleared
TPA-59668	TPA	Olivia Reed	—	—	—	9635 Forest Ave, San Antonio, TX, 78276	0.68	Date of birth unreadable Street suffix standardised Address re-cased Placeholder values cleared
TPA-58627	TPA	Christine Fuller	1976-04-25	UHC-04747-15	—	9726 Valley View Dr Apt 12, Glendale, AZ, 85323	0.68	Unit split from street Street suffix standardised Address re-cased Placeholder values cleared
TPA-51520	TPA	Michael Kelly	—	—	—	9662 Willow Ct, Dallas, TX, 75200	0.68	Date of birth unreadable Street suffix standardised Address re-cased Placeholder values cleared
TPA-61737	TPA	Arjun Wright	1982-09-07	—	—	8140 Washington St, Charlotte, NC, 28227	0.68	Street suffix standardised Address re-cased Gender normalised Placeholder values cleared

7,767 rows, page 81 of 156Previous Next