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 “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
CLM-413110	CLM	Omar McCoy	1958-05-01	UHC-12103-40	7309520254	5792 Sage Ct # 204, Minneapolis, MN, 55492	0.84	Unit split from street Placeholder values cleared
ENR-115839	ENR	Rebeccca Greene	2006-05-05	UHC-66153-41	9829880967	3070 Palm Dr # 726, Tampa, FL, 33694	0.84	Phone reformatted Unit split from street
ENR-133604	ENR	Scott Moreno	1943-03-17	UHC-34145-47	9416264149	2645 Park Pl Apt 21, Sacramento, CA, 95841	0.84	Name re-cased Unit split from street
ENR-119153	ENR	Omar Le	1980-03-23	UHC-94958-54	2222558840	2377 Elm St # 704, Minneapolis, MN, 55442	0.84	Phone reformatted Unit split from street
PRV-21067	PRV	Christina A Rice	1951-10-22	UHC-34431-50	5904631125	3889 Mountain View Dr # 667, Gilbert, AZ, 85286	0.84	Unit split from street Placeholder values cleared
TPA-55347	TPA	Jeffrey Shaw	1971-09-20	—	—	403 River Rd # 561, Los Angeles, CA, 90098	0.84	Unit split from street Whitespace trimmed
ENR-133185	ENR	Arthur H Washington	2000-07-27	UHC-09983-59	7256802731	7566 Willow Ct # 300, Gilbert, AZ, 85294	0.84	Phone reformatted Unit split from street
ENR-124233	ENR	Aaron Jones	1992-10-01	UHC-48188-28	—	4341 Indian School Rd # 420, Sacramento, CA, 95848	0.84	Unit split from street Whitespace trimmed
ENR-102934	ENR	Michael W Reyes	1945-11-25	UHC-84549-13	3483849828	6699 Spring St # 441, Las Vegas, NV, 89179	0.84	Name re-cased Unit split from street
CLM-420370	CLM	Albert T Moreno	1998-07-11	—	—	3753 Palm Dr # 175, Plano, TX, 75025	0.84	Unit split from street Placeholder values cleared
ENR-111116	ENR	Patricia Banks	2007-05-19	UHC-67902-87	5594210595	4827 Willow Ct # 283, San Antonio, TX, 78218	0.84	Phone reformatted Unit split from street
ENR-111115	ENR	Patricia Banks	2007-05-19	UHC-67902-87	5594210595	4827 Willow Ct # 283, San Antonio, TX, 78218	0.84	Phone reformatted Unit split from street
ENR-142703	ENR	Janet Hernandez	1973-05-06	UHC-29418-37	—	37 Oak St Apt 25, Orlando, FL, 32823	0.84	Member ID reformatted Unit split from street
ENR-106909	ENR	Alexander N Crawford	1994-02-06	UHC-69787-09	—	1954 Ocean Ave # 791, Los Angeles, CA, 90087	0.84	Unit split from street Email lower-cased
CLM-413756	CLM	Cheryl Peterson	1992-11-27	—	4675534640	8299 Ridge Rd Apt 38, Orlando, FL, 32811	0.84	Unit split from street Placeholder values cleared
ENR-111631	ENR	Lawrence Y Roberts	1956-11-01	UHC-06365-07	7295057933	8764 Ocean Ave # 600, Tucson, AZ, 85760	0.84	Name re-cased Unit split from street
CLM-407315	CLM	Emily Specer	2002-01-14	UHC-55914-20	—	7951 Bayshore Dr Apt 15, Los Angeles, CA, 90029	0.84	Unit split from street Placeholder values cleared
CLM-411802	CLM	Mary Guerrero	1980-09-18	—	—	6697 Valley View Dr # 693, Tucson, AZ, 85789	0.84	Unit split from street Placeholder values cleared
ENR-103803	ENR	Kimberly Jacobs	1969-01-28	UHC-81813-82	8653011418	184 Jefferson Ave # 209, Tempe, AZ, 85241	0.84	Date of birth reformatted Unit split from street
TPA-51205	TPA	Jack Reed	1963-04-03	—	—	9195 River Rd # 142, Charlotte, NC, 28255	0.84	Unit split from street Placeholder values cleared
ENR-122411	ENR	Emma L Clark	1986-08-05	UHC-33936-99	—	1050 Sunset Blvd Apt 5, Fresno, CA, 93726	0.84	Unit split from street Placeholder values cleared
ENR-117398	ENR	Lisa J Mendez	1949-07-05	UHC-55575-93	7866453113	105 Cedar Ln Apt 11, Tucson, AZ, 85702	0.84	Unit split from street Placeholder values cleared
ENR-136989	ENR	Scott U Phillips	1981-08-18	UHC-23989-56	8883190206	4082 River Rd Apt 11, Sacramento, CA, 95847	0.84	Unit split from street Email lower-cased
TPA-58665	TPA	Arthur Sanders	1946-01-06	—	—	8522 Main St Apt 22, Orlando, FL, 32809	0.84	Unit split from street Placeholder values cleared
ENR-108778	ENR	Brenda D Day	1975-08-25	UHC-90446-52	9707146699	32 Grand Ave Apt 38, Denver, CO, 80246	0.84	Unit split from street Placeholder values cleared
ENR-127142	ENR	Kathleen Q Grififn	1972-06-12	UHC-05268-94	9342671648	451 Ridge Rd Apt 30, Fresno, CA, 93761	0.84	Phone reformatted Unit split from street
ENR-111812	ENR	Justin Anderson	1986-12-28	UHC-49088-69	8695267790	3886 Church St # 737, Glendale, AZ, 85373	0.84	Unit split from street Whitespace trimmed
ENR-113824	ENR	Sussan N Harper	1944-07-23	UHC-75355-65	8794202110	4040 Spring St Apt 17, San Antonio, TX, 78204	0.84	Unit split from street Placeholder values cleared
CLM-431284	CLM	John Reyes	1977-05-18	UHC-60362-37	—	1849 Union St # 654, Miami, FL, 33196	0.84	Unit split from street Placeholder values cleared
ENR-122285	ENR	Lori White	2008-09-19	UHC-43792-16	4026308874	5964 Washington St Apt 22, Columbus, OH, 43233	0.84	Unit split from street Placeholder values cleared
CLM-416512	CLM	Anthony Cox	1949-08-20	—	—	7541 Maple Ave # 100, San Antonio, TX, 78272	0.84	Unit split from street Placeholder values cleared
CLM-413768	CLM	Judy Green	1954-03-23	—	—	278 Elm St # 213, Glendale, AZ, 85377	0.84	Unit split from street Placeholder values cleared
TPA-55536	TPA	Lori Varags	1997-12-18	—	—	7352 River Rd Apt 20, Houston, TX, 77015	0.84	Date of birth reformatted Unit split from street
ENR-127166	ENR	Ethan Long	1964-07-04	UHC-18400-16	6485607405	1980 Grand Ave Apt 33, Minneapolis, MN, 55433	0.84	Unit split from street Placeholder values cleared
ENR-113683	ENR	Judy Y Matthews	1986-08-25	UHC-80695-58	5897106768	3336 Mountain View Dr Apt 10, San Diego, CA, 92198	0.84	Unit split from street Whitespace trimmed
ENR-109521	ENR	Dylan M Harrison	1972-06-11	UHC-96408-51	8378406476	7916 Park Pl # 692, Orlando, FL, 32820	0.84	Phone reformatted Unit split from street
ENR-111191	ENR	Justin Dean	2006-03-28	UHC-95839-67	6638926850	4096 Maple Ave # 755, Houston, TX, 77065	0.84	Unit split from street Placeholder values cleared
TPA-57016	TPA	Melissa Rodriguez	1943-03-11	—	6044501001	2585 Ocean Ave # 320, Charlotte, NC, 28287	0.84	Unit split from street Placeholder values cleared
ENR-100131	ENR	Diana Y Ramos	1979-07-02	UHC-92145-59	6418418084	4025 Elm St Apt 27, Plano, TX, 75050	0.84	Name re-cased Unit split from street
CLM-413475	CLM	Stephen Schmidt	1948-08-13	—	—	4988 Pine Dr Apt 9, Glendale, AZ, 85340	0.84	Unit split from street Placeholder values cleared
ENR-105108	ENR	Ashley Thompson	1961-04-11	UHC-89605-33	8898004941	5781 Broadway # 423, Miami, FL, 33102	0.84	Phone reformatted Unit split from street
ENR-106116	ENR	Sean C Torrs	1939-04-18	UHC-30998-65	6906765655	1225 Park Pl # 724, Las Vegas, NV, 89121	0.84	Unit split from street Placeholder values cleared
TPA-59219	TPA	Gerald Tran	1980-06-22	—	—	4623 Church St Apt 9, Mesa, AZ, 85287	0.84	Unit split from street Placeholder values cleared
ENR-109143	ENR	Ken Reid	1962-07-28	UHC-67257-32	5182441665	5688 Pine Dr Apt 2, Mesa, AZ, 85260	0.84	Name re-cased Unit split from street
CLM-430710	CLM	Diane Henry	1996-07-18	UHC-02475-58	—	5928 Spring St Apt 39, Sacramento, CA, 95811	0.84	Unit split from street Placeholder values cleared
ENR-138167	ENR	Scott E Gordon	1943-04-02	UHC-21060-59	8032161750	643 Desert Sky Blvd # 608, Scottsdale, AZ, 85200	0.84	Unit split from street Email lower-cased
CLM-431389	CLM	Wayne Howard	1957-01-13	UHC-15907-37	—	3649 Ridge Rd Apt 22, Fresno, CA, 93718	0.84	Unit split from street Placeholder values cleared
CLM-420543	CLM	Kevin Chen	1994-04-03	—	—	1044 Elm St # 207, San Diego, CA, 92147	0.84	Unit split from street Placeholder values cleared
CLM-407222	CLM	Gloria Y Rogers	1984-03-18	UHC-45329-47	—	5350 Desert Sky Blvd Apt 17, Atlanta, GA, 30347	0.84	Unit split from street Placeholder values cleared
ENR-129558	ENR	Willie Wright	1994-12-25	UHC-80839-61	4484756216	9070 Park Pl Apt 13, Scottsdale, AZ, 85262	0.84	Unit split from street Whitespace trimmed

6,994 rows, page 139 of 140Previous Next