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 “Middle initial moved out of first name”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagMiddle initial moved out of first nameClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
PRV-26692	PRV	David P Jenkins	2003-05-05	UHC-89133-69	3335485373	4240 Jefferson Ave, Minneapolis, MN, 55496	0.64	Middle initial moved out of first name Date of birth reformatted Phone reformatted ZIP+4 trimmed+2 more
PRV-25713	PRV	Walter Y Richards	1971-02-20	—	5676154464	1942 Highland Ave, Chandler, AZ, 85251	0.64	Middle initial moved out of first name Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-27114	PRV	Dot C Rivera	1958-07-18	—	2489463431	7881 Pine Dr, Nashville, TN, 37223	0.64	Middle initial moved out of first name Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-22645	PRV	Charlotte O Peterson	1963-07-15	UHC-11340-18	6588626908	833 Central Ave, Tempe, AZ, 85243	0.64	Middle initial moved out of first name Name re-cased Phone reformatted State name converted to code+2 more
PRV-23371	PRV	Cheryl S Lee	1957-11-25	—	7795654448	6438 Baseline Rd, Dallas, TX, 75245	0.64	Middle initial moved out of first name Two-digit birth year Phone reformatted Email lower-cased+2 more
PRV-20696	PRV	Carr P Fatima	1954-11-23	UHC-87958-42	2424617953	931 Cedar Ln, Charlotte, NC, 28226	0.64	Middle initial moved out of first name Name re-cased Phone reformatted State name converted to code+2 more
PRV-21037	PRV	Bradley L Burke	1938-12-02	—	7307930540	2646 Main St, Tucson, AZ, 85768	0.64	Name split from “Last, First”Middle initial moved out of first name Date of birth reformatted Phone reformatted+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-23705	PRV	George M Padilla	2005-01-20	UHC-53198-74	9417304308	7600 Valley View Dr, Charlotte, NC, 28274	0.64	Middle initial moved out of first name Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-26780	PRV	Isabella P Freeman	1965-09-13	—	8605143057	2072 Market St, Los Angeles, CA, 90059	0.64	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone reformatted+2 more
PRV-24459	PRV	Anthony U Hayes	1946-09-03	UHC-47136-42	9296420529	1648 Baseline Rd, Houston, TX, 77003	0.64	Middle initial moved out of first name Date of birth reformatted Phone reformatted ZIP+4 trimmed+2 more
PRV-21763	PRV	John V Richards	—	UHC-96441-75	9347378156	—	0.64	Middle initial moved out of first name Date of birth unreadable Phone reformatted Member ID reformatted+2 more
PRV-24462	PRV	Diego W Lawson	1966-10-07	UHC-46964-36	4479788753	8363 Cedar Ln, Mesa, AZ, 85237	0.64	Middle initial moved out of first name Street suffix standardised Address re-cased City re-cased+2 more
PRV-28067	PRV	Aisha N Martin	1972-02-24	UHC-24039-32	8456994850	6550 Union St, Seattle, WA, 98184	0.64	Middle initial moved out of first name Name re-cased Street suffix standardised Address re-cased+2 more
PRV-21935	PRV	Douglas F Garza	1946-09-15	UHC-82645-48	2734276134	1168 Cedar Ln, Phoenix, AZ, 85069	0.64	Middle initial moved out of first name Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-24847	PRV	Bettty B Soto	2008-12-20	—	4995925720	2184 Sage Ct, Jacksonville, FL, 32234	0.64	Middle initial moved out of first name Phone reformatted Street suffix standardised Address re-cased+2 more
PRV-23329	PRV	Jack N Crater	1997-04-23	—	6939400690	9198 Mountain View Dr, Tucson, AZ, 85754	0.64	Middle initial moved out of first name Name re-cased Phone reformatted Street suffix standardised+2 more
PRV-27825	PRV	Adam T Singh	1948-02-03	—	—	—	0.66	Middle initial moved out of first name Two-digit birth year Email lower-cased Whitespace trimmed+1 more
PRV-26730	PRV	Joe Z Obrien	1938-06-20	—	2615953563	832 Oak St, Jacksonville, FL, 32288	0.66	Middle initial moved out of first name Name re-cased Phone reformatted ZIP+4 trimmed+1 more
PRV-24207	PRV	Anna D Park	1983-12-27	UHC-82241-54	2906267195	68 Broadway, San Diego, CA	0.66	Middle initial moved out of first name Phone reformatted Member ID reformatted ZIP missing+1 more
PRV-21892	PRV	Albert Q Kennedy	1945-12-05	UHC-89191-01	2908392311	—	0.66	Middle initial moved out of first name Two-digit birth year Phone reformatted Whitespace trimmed+1 more
PRV-25204	PRV	Mariana G Gutierrez	1999-07-23	—	6016756473	8486 Central Ave, Mesa, AZ	0.66	Middle initial moved out of first name Name re-cased Date of birth reformatted ZIP missing+1 more
PRV-21481	PRV	Sophia M Wilson	1958-10-14	UHC-22018-02	9446933110	3631 Market St # 845, Nashville, TN, 37219	0.66	Middle initial moved out of first name Name re-cased Date of birth reformatted Unit split from street+1 more
PRV-28901	PRV	Christina V Mills	1968-09-02	—	7227301526	2856 Grand Ave, Fresno, CA, 93737	0.66	Middle initial moved out of first name Phone reformatted Gender normalised Whitespace trimmed+1 more
PRV-24823	PRV	Ronald Q Brown	1964-02-24	—	—	758 Elm St, Mesa, AZ, 85204	0.66	Middle initial moved out of first name Name re-cased Date of birth reformatted Phone missing area code+1 more
PRV-27939	PRV	Benjamin F Jones	2000-11-10	—	4176285515	3840 Palm Dr, Nashville, TN, 37240	0.66	Middle initial moved out of first name Phone reformatted City re-cased ZIP+4 trimmed+1 more
PRV-21820	PRV	Timothy O Flores	1980-10-14	—	—	2143 Apache Blvd, Glendale, AZ, 85350	0.66	Middle initial moved out of first name Street suffix standardised Address re-cased Whitespace trimmed+1 more
PRV-21831	PRV	Billy N Austin	1944-10-09	—	7098406444	386 Ocean Ave, San Diego, CA, 92171	0.68	Middle initial moved out of first name Phone reformatted Gender normalised Whitespace trimmed
PRV-28647	PRV	Rebecca E Cox	1997-02-09	UHC-65252-88	3582509037	8322 Sage Ct, Orlando, FL, 32858	0.68	Middle initial moved out of first name Street suffix standardised Address re-cased Placeholder values cleared
PRV-26118	PRV	Donald U Li	1938-05-07	UHC-27526-41	—	3587 Desert Sky Blvd, Phoenix, AZ, 85048	0.68	Name split from “Last, First”Middle initial moved out of first name Whitespace trimmed Placeholder values cleared
PRV-29469	PRV	Michelle Z Alvarez	—	—	9882735027	9370 Hillcrest Rd, Tempe, AZ, 85235	0.68	Middle initial moved out of first name Date of birth missing Phone reformatted Placeholder values cleared
PRV-23598	PRV	Ruth Z Contreras	1978-05-04	UHC-90999-03	—	—	0.68	Middle initial moved out of first name Phone missing area code Whitespace trimmed Placeholder values cleared
PRV-21215	PRV	Randy Q Snyder	1989-06-16	—	4318186468	398 Broadway, San Antonio, TX, 78213	0.68	Name split from “Last, First”Middle initial moved out of first name Phone reformatted Placeholder values cleared
PRV-27511	PRV	Nathan R Clark	1941-01-15	UHC-81651-12	2929846918	—	0.70	Middle initial moved out of first name Gender normalised Placeholder values cleared
PRV-23071	PRV	Lucia S Mendoza	1978-09-11	—	7059742980	—	0.70	Name split from “Last, First”Middle initial moved out of first name Placeholder values cleared
PRV-22413	PRV	Camila W Sandoval	1983-09-18	UHC-60824-59	4592179167	5221 Broadway Apt 16, Seattle, WA, 98142	0.70	Middle initial moved out of first name Phone reformatted Unit split from street
PRV-22312	PRV	Denise Q Lane	—	—	3863616140	8532 Sage Ct, Houston, TX, 77041	0.70	Middle initial moved out of first name Date of birth unreadable Placeholder values cleared
PRV-24301	PRV	Doris D Watson	1951-12-05	UHC-23249-96	5264765344	6258 Forest Ave, Charlotte, NC, 28267	0.72	Middle initial moved out of first name ZIP+4 trimmed
PRV-20295	PRV	Kathryn L Vasquez	1985-08-26	UHC-16182-62	8316704889	1861 Cedar Ln, Los Angeles, CA, 90060	0.76	Middle initial moved out of first name Phone reformatted Member ID reformatted Email lower-cased+2 more
PRV-20358	PRV	Rebecca Y Garza	1976-06-04	UHC-50074-12	—	—	0.76	Middle initial moved out of first name Name re-cased Date of birth reformatted Member ID reformatted+2 more
PRV-28844	PRV	Janet W Ford	1969-10-09	—	7717112234	3521 River Rd, San Antonio, TX, 78213	0.78	Middle initial moved out of first name Name re-cased Date of birth reformatted Whitespace trimmed+1 more
PRV-24184	PRV	Kathleen C Knight	1981-08-22	—	2336873624	3149 Park Pl, Dallas, TX, 75204	0.78	Middle initial moved out of first name Phone reformatted City re-cased Whitespace trimmed+1 more
PRV-25967	PRV	Hiroshi F Little	1951-07-08	UHC-78883-18	6557404130	7461 Sage Ct, Sacramento, CA, 95845	0.78	Middle initial moved out of first name Date of birth reformatted Phone reformatted Whitespace trimmed+1 more
PRV-20819	PRV	Diego A Valdez	1962-04-06	—	5768453658	—	0.78	Middle initial moved out of first name Name re-cased Phone reformatted Whitespace trimmed+1 more
PRV-23163	PRV	Maria A Vazquez	1980-02-04	—	2478364773	8005 Mountain View Dr, Plano, TX, 75021	0.80	Middle initial moved out of first name Phone reformatted Whitespace trimmed Placeholder values cleared
PRV-26976	PRV	Natalie H Duncan	1972-03-22	UHC-88287-19	6413717461	930 Meadow Ln, Las Vegas, NV, 89125	0.80	Middle initial moved out of first name Name re-cased Date of birth reformatted Placeholder values cleared
PRV-26977	PRV	Natalie H Duncan	1972-03-22	UHC-88287-19	6413717461	930 Meadow Ln, Las Vegas, NV, 89125	0.80	Middle initial moved out of first name Name re-cased Date of birth reformatted Placeholder values cleared
PRV-26821	PRV	Juna S Bradley	1951-04-10	—	2158354537	8530 Hillcrest Rd, Charlotte, NC, 28274	0.82	Middle initial moved out of first name Whitespace trimmed Placeholder values cleared
PRV-23832	PRV	Luis I Rodriguez	2003-04-28	UHC-22104-96	7622578773	2126 Main St, Fresno, CA, 93734	0.82	Middle initial moved out of first name Phone reformatted City re-cased
PRV-27355	PRV	Patrick H Jordan	1948-08-20	UHC-27638-29	—	—	0.84	Middle initial moved out of first name Placeholder values cleared

101 rows, page 2 of 3Previous Next