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

All sources, flag “State code upper-cased”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagState code upper-casedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
CLM-420570	CLM	Linda McDonald	1980-04-09	UHC-70228-56	6556550558	6056 Highland Ave, Atlanta, GA, 30385	0.86	Name re-cased Date of birth reformatted Phone reformatted City re-cased+3 more
ENR-117216	ENR	Carol G Fowler	1995-04-09	UHC-12538-47	2275168933	7684 Lincoln Way, Sacramento, CA, 95821	0.86	Phone reformatted Member ID reformatted City re-cased State code upper-cased+3 more
ENR-100701	ENR	Brittany X Barnes	1961-02-04	UHC-96092-68	7916893914	9283 Pine Dr, Mesa, AZ, 85263	0.88	Date of birth reformatted Phone reformatted Member ID reformatted State code upper-cased+2 more
PRV-26922	PRV	Amber L Roberts	1973-04-15	UHC-83489-16	—	9583 Broadway, Tempe, AZ, 85295	0.88	Name re-cased Address re-cased City re-cased State code upper-cased+2 more
ENR-130161	ENR	Melissa L Gerdner	1994-09-15	UHC-43537-54	6847990244	8347 Lincoln Way, Tucson, AZ, 85794	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
TPA-51480	TPA	Vicky Hughes	1949-09-21	UHC-95800-59	—	267 Willow Ct, Minneapolis, MN, 55444	0.88	Date of birth reformatted City re-cased State code upper-cased Email lower-cased+2 more
ENR-127408	ENR	Christian B Elliott	1971-07-07	UHC-57110-89	4363933583	3066 Apache Blvd, Tucson, AZ, 85724	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
ENR-110916	ENR	Sara T Wang	1996-06-14	UHC-49048-08	3935639094	2997 Lincoln Way, Tucson, AZ, 85769	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
ENR-116279	ENR	Mateo P Obrien	1969-03-09	UHC-64674-51	2659976777	3686 Bayshore Dr, San Diego, CA, 92174	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
ENR-122135	ENR	John Contreras	1945-12-13	UHC-24452-67	4568026616	3814 Union St, Tucson, AZ, 85718	0.88	Name re-cased Phone reformatted Member ID reformatted State code upper-cased+2 more
ENR-119526	ENR	Sara Jimenez	1986-08-07	—	9514705189	7674 Spring St, Nashville, TN, 37252	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
ENR-122801	ENR	Alexander B Fernandez	1965-08-05	UHC-63336-68	3977123312	3851 Spring St, Plano, TX, 75031	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
ENR-108078	ENR	Austin P Robertson	1968-04-21	UHC-38894-44	2078587613	8721 Palm Dr, Las Vegas, NV, 89127	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-111602	ENR	Bobbby L Robinson	1943-11-27	UHC-17176-34	3865667626	9401 Highland Ave, Atlanta, GA, 30309	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
CLM-407852	CLM	Gerald Martinez	1955-10-03	UHC-27156-84	5984567185	4734 Grand Ave, Dallas, TX, 75298	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
TPA-59748	TPA	Luis P Freeman	1990-03-27	—	—	3146 Canyon Rd, Gilbert, AZ, 85274	0.88	Name re-cased Date of birth reformatted City re-cased State code upper-cased+2 more
PRV-27797	PRV	Evelyn P Palmer	1997-04-03	—	6092390924	8011 Church St, Tucson, AZ, 85758	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
ENR-115201	ENR	Susan Ramos	1987-11-22	UHC-03814-03	6359946811	9212 Church St, Tempe, AZ, 85288	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
CLM-411855	CLM	Christian Henderson	1964-08-16	—	6639945607	145 Mountain View Dr, Charlotte, NC, 28227	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
PRV-22876	PRV	Jeremy James	1956-12-08	UHC-33338-98	3452840548	4486 Union St, Eden Prairie, MN, 55334	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-141793	ENR	Dorothy Henry	1948-05-26	UHC-42030-56	6643720282	5730 Pine Dr, Glendale, AZ, 85332	0.88	Name re-cased Phone reformatted Member ID reformatted City re-cased+2 more
CLM-404172	CLM	Joseph Wright	1976-04-20	UHC-09052-51	—	2096 Willow Ct, Tampa, FL, 33660	0.88	Name re-cased Date of birth reformatted State code upper-cased Email lower-cased+2 more
ENR-134967	ENR	Sandra Ward	1997-05-25	UHC-87100-26	6085460242	7221 Park Pl, Gilbert, AZ, 85275	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
CLM-430486	CLM	Sarah Sanchez	1943-03-13	UHC-82518-76	—	7645 Sage Ct, Fresno, CA, 93724	0.88	Date of birth reformatted Member ID reformatted City re-cased State code upper-cased+2 more
ENR-105197	ENR	Dorothy H Dena	1995-03-25	UHC-71188-19	9476569653	1245 Broadway, Minneapolis, MN, 55495	0.88	Phone reformatted Address re-cased State code upper-cased Plan code upper-cased+2 more
ENR-101348	ENR	Sofa Walker	1945-03-20	UHC-03102-14	4214520773	4802 Oak St, Austin, TX, 78761	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
CLM-418081	CLM	Charles Ross	1992-12-15	UHC-90074-48	3622687021	8583 Elm St, Fresno, CA, 93771	0.88	Name re-cased Phone reformatted State code upper-cased Plan code upper-cased+2 more
ENR-112790	ENR	Grace A Ortega	1965-11-15	UHC-65945-55	8504233760	6367 Elm St, Los Angeles, CA, 90082	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-123792	ENR	Mark J Miller	1956-10-03	UHC-79114-24	4323905934	1832 Mesa Dr, Las Vegas, NV, 89156	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-116763	ENR	Randy Hunt	2003-10-26	UHC-14907-14	2173461487	3340 Main St, San Diego, CA, 92198	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
PRV-25187	PRV	Richard E Kelley	1963-12-07	—	2502272678	68 Desert Sky Blvd, Tucson, AZ, 85719	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-134674	ENR	Kayla D Padilla	1955-05-11	UHC-31182-83	8838824499	8441 Church St, Dallas, TX, 75258	0.88	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+2 more
ENR-114820	ENR	Adam A Weaver	1941-07-08	UHC-75387-09	2108899697	4901 Spring St, Mesa, AZ, 85271	0.88	Name re-cased Date of birth reformatted Member ID reformatted City re-cased+2 more
TPA-57217	TPA	Ruth Peterson	1959-09-25	—	—	2019 River Rd, Denver, CO, 80270	0.88	Name re-cased Date of birth reformatted City re-cased State code upper-cased+2 more
ENR-135759	ENR	Ronald R Hicks	1976-02-20	UHC-23486-91	3463455568	8513 Union St, Tampa, FL, 33671	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
CLM-402615	CLM	Joseph Mitchell	1991-08-04	UHC-11166-10	—	9484 Highland Ave, Tucson, AZ, 85796	0.88	Name re-cased Date of birth reformatted State code upper-cased Email lower-cased+2 more
CLM-419305	CLM	Willie Harrison	1984-07-13	UHC-17637-88	5139515823	7270 Harbor Blvd, Dallas, TX, 75203	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
ENR-128025	ENR	Priya Shaw	1962-02-02	UHC-12156-22	7433023535	5944 Park Pl, San Diego, CA, 92149	0.88	Name re-cased Date of birth reformatted State code upper-cased Email lower-cased+2 more
PRV-22770	PRV	Mariana O Johnson	1997-03-21	UHC-60276-16	4404821064	1867 Mountain View Dr, Dallas, TX, 75206	0.88	Name re-cased Phone reformatted State code upper-cased Email lower-cased+2 more
CLM-409538	CLM	Maria Park	1979-04-01	UHC-74024-31	3945588640	1510 Grand Ave, Phoenix, AZ, 85034	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
TPA-52054	TPA	Jesse Walker	1941-05-04	—	—	5667 Camelback Rd, Columbus, OH, 43286	0.88	Name re-cased Date of birth reformatted State code upper-cased Email lower-cased+2 more
PRV-22471	PRV	Ronald Dunn	1949-01-14	UHC-38783-47	7947678863	1118 Desert Sky Blvd, Fresno, CA, 93772	0.88	Phone reformatted Member ID reformatted State code upper-cased Email lower-cased+2 more
ENR-131340	ENR	Jenniefr Medina	2000-06-27	UHC-07728-57	7192372482	1107 Valley View Dr, Eden Prairie, MN, 55325	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
ENR-111889	ENR	Wallace V Betty	1938-07-14	UHC-94593-87	9595695101	4159 Harbor Blvd, Houston, TX, 77041	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
ENR-141188	ENR	Cynthia P Martinez	1996-09-25	UHC-73516-61	5378608979	7315 Broadway, Gilbert, AZ, 85227	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
ENR-109394	ENR	Diego A Fields	1938-09-14	UHC-40320-52	9518469554	8047 Harbor Blvd, San Diego, CA, 92152	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
ENR-137849	ENR	Adam L Barnes	1951-06-08	UHC-43073-68	8113653084	7258 Union St, Seattle, WA, 98140	0.88	Phone reformatted Member ID reformatted City re-cased State code upper-cased+2 more
ENR-132991	ENR	Bradley R Cole	1966-12-02	UHC-02912-63	3476095712	8014 Central Ave, San Diego, CA, 92159	0.88	Date of birth reformatted Phone reformatted City re-cased State code upper-cased+2 more
ENR-137046	ENR	Mark Y Hicks	1991-04-12	UHC-61038-68	3108023624	2633 Hillcrest Rd, Austin, TX, 78718	0.88	Name re-cased Phone reformatted City re-cased State code upper-cased+2 more
CLM-426533	CLM	Catherine Medina	1970-09-07	UHC-50377-75	3318657151	4377 Park Pl, Houston, TX, 77001	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more

4,010 rows, page 67 of 81Previous Next