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 “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
PRV-22698	PRV	Nicholas Patterson	1974-12-05	—	—	9852 Washington St Apt 34, Tempe, AZ, 85259	0.64	Unit split from street Street suffix standardised Address re-cased Plan code upper-cased+2 more
PRV-25986	PRV	Heather Freeman	1961-09-08	—	2063831906	2537 Grand Ave Apt 15, Orlando, FL, 32846	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-23523	PRV	Elizabeth Young	1979-01-13	UHC-34103-14	8986447921	6703 Sage Ct Apt 14, Miami, FL, 33133	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-26679	PRV	Dylan R Ramos	1961-07-22	UHC-33618-37	8185998585	1058 Sunset Blvd # 765, Atlanta, GA, 30336	0.64	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
PRV-26678	PRV	Dylan R Ramos	1961-07-22	UHC-33618-37	8185998585	1058 Sunset Blvd # 765, Atlanta, GA, 30336	0.64	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
PRV-26008	PRV	Billy Valdez	1968-12-02	UHC-52318-42	—	1459 Hillcrest Rd Apt 13, Glendale, AZ, 85310	0.64	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+2 more
PRV-24744	PRV	Priya Webb	1986-11-22	—	5973211335	5120 Main St Apt 24, Glendale, AZ, 85392	0.64	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-28215	PRV	Helen Garcia	1973-01-28	UHC-38530-83	9082605200	8801 Forest Ave # 953, Fresno, CA, 93720	0.64	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+2 more
PRV-26973	PRV	Dennis Morris	1956-08-01	UHC-52301-44	4529291801	1163 Willow Ct # 689, Minneapolis, MN, 55485	0.64	Date of birth reformatted Phone reformatted Unit split from street City re-cased+2 more
PRV-28278	PRV	Shirley Media	1939-03-28	UHC-90535-74	2946985847	902 Elm St Apt 24, Glendale, AZ, 85336	0.64	Two-digit birth year Phone reformatted Unit split from street City re-cased+2 more
PRV-25759	PRV	Carl L Castro	1997-08-13	—	7056109115	3675 Lake View Rd # 534, Plano, TX, 75019	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-20380	PRV	Donald Brown	2008-05-16	—	5009602474	5701 Spring St # 367, Jacksonville, FL, 32207	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-23256	PRV	Janice Park	2004-10-23	—	9408837778	3497 Mountain View Dr # 811, Scottsdale, AZ, 85260	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-20660	PRV	Linda Bowman	1978-04-25	UHC-84271-43	3676944980	1878 Indian School Rd # 201, Chandler, AZ, 85263	0.64	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
PRV-26405	PRV	Adam Espinoza	2002-01-22	UHC-31431-03	2726610944	344 Palm Dr # 785, Charlotte, NC, 28268	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-20292	PRV	Catherine Hoffman	1949-01-28	—	4744385613	5813 Indian School Rd # 831, San Diego, CA, 92113	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-23779	PRV	Michelle C Suto	1966-06-26	—	5334184049	5905 Maple Ave Apt 34, Dallas, TX, 75211	0.64	Date of birth reformatted Phone reformatted Unit split from street Gender normalised+2 more
PRV-23231	PRV	Juan Dixon	1982-04-10	—	4907374820	7198 Church St # 782, Atlanta, GA, 30367	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
PRV-20676	PRV	Olivia Hart	1976-10-26	—	—	9622 Highland Ave Apt 18, Houston, TX, 77017	0.64	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-25263	PRV	Wayne Castro	1950-09-06	—	—	2524 Baseline Rd Apt 22, Sacramento, CA, 95862	0.64	Name re-cased Date of birth reformatted Unit split from street Street suffix standardised+2 more
PRV-29582	PRV	Doris Meyer	1960-12-20	—	—	7944 Valley View Dr Apt 25, Plano, TX, 75036	0.64	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-24248	PRV	Judith Wod	2002-11-27	UHC-06905-95	2043851382	5083 Desert Sky Blvd # 551, Mesa, AZ, 85205	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Unit split from street+2 more
PRV-28846	PRV	Hannah Flores	1954-07-12	—	5977160199	7702 Main St # 610, Minneapolis, MN, 55432	0.64	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
PRV-27649	PRV	Deigo Turner	1988-02-28	—	9767302887	8225 Union St Apt 32, Tampa, FL, 33644	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-25414	PRV	Jonathan Ferguson	1982-06-09	—	—	4690 Forest Ave Apt 2, Gilbert, AZ, 85276	0.64	Name re-cased Date of birth reformatted Unit split from street ZIP+4 trimmed+2 more
PRV-20283	PRV	Mason N Reynolds	1978-09-19	—	4713890386	4261 Ocean Ave Apt 11, Dallas, TX, 75209	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
PRV-28232	PRV	Carolyn Henry	1941-09-17	—	9687957748	924 River Rd # 294, Dallas, TX, 75256	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
PRV-25113	PRV	Arjun U Holmes	1978-11-22	—	—	5851 Main St Apt 35, Glendale, AZ, 85333	0.64	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
PRV-29557	PRV	Janny King	1997-10-25	UHC-93242-21	7602706297	2291 Forest Ave # 402, San Antonio, TX, 78224	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more
PRV-22668	PRV	Doris Stewart	1968-03-04	—	6194511077	5776 Sage Ct # 203, Minneapolis, MN, 55480	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
PRV-23757	PRV	Heather Pierce	1975-03-11	—	8969681540	1540 Maple Ave Apt 11, San Antonio, TX, 78253	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-26341	PRV	Roger J Patterson	1985-04-25	UHC-93623-42	5027358264	6366 Washington St # 330, Atlanta, GA, 30326	0.64	Phone reformatted Unit split from street City re-cased ZIP+4 trimmed+2 more
PRV-27874	PRV	Rebecca D Meendoza	2006-03-10	—	—	9585 Baseline Rd # 463, Houston, TX, 77094	0.64	Date of birth reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-27266	PRV	Grace Owens	1972-01-25	UHC-29617-42	8243192196	685 Apache Blvd Apt 12, Dallas, TX, 75211	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-20434	PRV	Bryan Cruz	1941-08-23	—	5412833470	2664 Park Pl Apt 16, Eden Prairie, MN, 55330	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-26569	PRV	Gabriel H Bradley	1946-03-05	—	4684386833	1795 Church St Apt 24, Fresno, CA	0.64	Name re-cased Date of birth reformatted Unit split from street ZIP missing+2 more
PRV-25660	PRV	Walter Gilbert	1963-05-27	—	4285885393	2595 Maple Ave Apt 4, Chandler, AZ	0.64	Name re-cased Date of birth reformatted Unit split from street ZIP missing+2 more
PRV-20114	PRV	Robert C Hoffman	1980-04-20	UHC-41946-58	9377788548	8892 Spring St Apt 21, Dallas, TX, 75231	0.64	Middle initial moved out of first name Phone reformatted Member ID reformatted Unit split from street+2 more
PRV-27903	PRV	Melissa N Bennett	1966-01-21	UHC-74500-76	7775805824	9773 Indian School Rd Apt 39, Los Angeles, CA, 90071	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
PRV-27171	PRV	Evelyn Lawon	1997-12-10	—	4807609382	2187 Willow Ct # 675, Minneapolis, MN, 55402	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
PRV-25384	PRV	Christopheer Cunningham	1990-03-02	—	8775872086	9136 Apache Blvd # 867, Seattle, WA, 98120	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-20312	PRV	William Daniels	1941-08-01	—	5252377028	1798 Ridge Rd Apt 11, Austin, TX, 78778	0.64	Unit split from street Street suffix standardised Address re-cased City re-cased+2 more
PRV-20873	PRV	Denise Bennett	2003-06-18	—	3614947193	3143 Mountain View Dr Apt 33, Denver, CO, 80286	0.64	Unit split from street Street suffix standardised Address re-cased State code upper-cased+2 more
PRV-27285	PRV	Sam Elliott	1990-03-17	UHC-79245-67	3112686874	6721 Sunset Blvd Apt 34, Las Vegas, NV, 89105	0.64	Name split from “Last, First”Date of birth reformatted Phone reformatted Unit split from street+2 more
PRV-26344	PRV	Danielle Weaver	1975-04-25	—	2869432840	2761 Maple Ave Apt 38, Houston, TX, 77011	0.64	Date of birth reformatted Phone reformatted Unit split from street Street suffix standardised+2 more
PRV-23093	PRV	Charlotte Ruiz	1955-09-20	UHC-93692-65	8838923998	6948 Broadway Apt 19, Scottsdale, AZ, 85217	0.64	Date of birth reformatted Phone reformatted Unit split from street ZIP+4 trimmed+2 more
PRV-25452	PRV	Karen A Arnold	1955-08-18	UHC-28271-38	7296739082	3188 Washington St # 792, Phoenix, AZ, 85027	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-21070	PRV	Stephen Cook	2001-11-05	—	—	4900 Bayshore Dr Apt 33, Tempe, AZ, 85240	0.64	Name re-cased Unit split from street Street suffix standardised Address re-cased+2 more
PRV-28690	PRV	Arjun Martinez	1977-04-11	—	6263650166	5901 Central Ave # 438, Phoenix, AZ, 85091	0.64	Phone reformatted Unit split from street Street suffix standardised Address re-cased+2 more
PRV-22962	PRV	Elijah Gutierrez	1994-08-15	—	9659307377	2882 Spring St Apt 27, Los Angeles, CA, 90052	0.64	Name re-cased Phone reformatted Unit split from street Street suffix standardised+2 more

699 rows, page 9 of 14Previous Next