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 “SSN last four extracted”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagSSN last four extractedClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-58111	TPA	Brian Ford	1997-05-10	—	8665321931	—	0.80	Phone reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
CLM-419091	CLM	Herrera Frances	1996-10-04	—	8146185668	4797 Market St, Las Vegas, NV, 89185	0.80	Phone reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
CLM-414569	CLM	Omar H Morales	1973-10-04	UHC-38951-87	5228854789	5572 Maple Ave, Miami, FL, 33133	0.80	Phone reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
CLM-407787	CLM	Sctt L Cooper	2008-02-08	—	6823677988	—	0.80	Phone reformatted SSN last four extracted Plan code upper-cased Placeholder values cleared
CLM-414321	CLM	Angela E Wodos	1977-08-26	—	—	3702 Central Ave, Los Angeles, CA, 90047	0.80	Date of birth reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
TPA-54422	TPA	Debra Bradley	1971-01-11	—	—	1134 Maple Ave, Scottsdale, AZ, 85254	0.80	Name re-cased SSN last four extracted Whitespace trimmed Placeholder values cleared
ENR-114896	ENR	Billy O Santiago	1995-07-25	UHC-59543-99	7029884005	6407 Church St, Gilbert, AZ, 85200	0.80	Name re-cased Phone reformatted SSN last four extracted Whitespace trimmed
ENR-137612	ENR	Robert A Stewart	1971-11-15	UHC-52370-30	3745900230	9068 Pine Dr, Tempe, AZ, 85286	0.80	Name re-cased SSN last four extracted Whitespace trimmed Placeholder values cleared
ENR-140373	ENR	Sharon Banks	1989-05-03	UHC-04129-68	9523485720	3155 Grand Ave, Charlotte, NC, 28226	0.80	Name re-cased Phone reformatted SSN last four extracted Whitespace trimmed
CLM-413474	CLM	Christopher Perry	1989-12-01	UHC-52638-72	6872967185	—	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
CLM-415214	CLM	Douglas Hunt	1965-02-04	UHC-18462-40	6002316071	—	0.80	Name re-cased Date of birth reformatted Phone reformatted SSN last four extracted
CLM-421245	CLM	Gary Peters	1945-08-17	—	—	355 Mesa Dr, Plano, TX, 75001	0.80	SSN last four extracted City re-cased Email lower-cased Placeholder values cleared
TPA-59581	TPA	Hiroshi Flores	1966-10-20	—	—	—	0.80	Name re-cased Date of birth reformatted SSN last four extracted Placeholder values cleared
ENR-129956	ENR	Brittany H Lawson	1963-02-23	UHC-05989-74	5148910295	1729 Jefferson Ave, Columbus, OH, 43284	0.80	Date of birth reformatted SSN last four extracted City re-cased Whitespace trimmed
TPA-59238	TPA	Tyler Reed	1950-11-15	—	—	7735 Meadow Ln, Eden Prairie, MN, 55380	0.80	SSN last four extracted City re-cased Whitespace trimmed Placeholder values cleared
ENR-108793	ENR	Carlos Garcia	2004-02-03	UHC-31745-98	6909602044	7288 River Rd, Phoenix, AZ, 85087	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
ENR-136126	ENR	Cynthia B Burke	1950-06-14	UHC-33647-68	9508055680	6222 Camelback Rd, Scottsdale, AZ, 85288	0.80	Name re-cased SSN last four extracted Email lower-cased Whitespace trimmed
ENR-120088	ENR	Fowler Donald	2005-03-25	UHC-20542-52	2264009481	8557 Central Ave, Eden Prairie, MN, 55369	0.80	Name re-cased Phone reformatted Member ID reformatted SSN last four extracted
ENR-115732	ENR	Chen Arthur	1946-09-05	UHC-64162-33	4968146384	2514 Apache Blvd, Dallas, TX, 75268	0.80	Name re-cased SSN last four extracted City re-cased Email lower-cased
ENR-108070	ENR	Samantha Crawford	1985-10-16	UHC-02931-55	7934725694	—	0.80	Phone reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
ENR-106107	ENR	Christina Harper	1979-01-10	UHC-69850-79	9218057425	6368 Valley View Dr, Sacramento, CA, 95899	0.80	Phone reformatted SSN last four extracted Email lower-cased Whitespace trimmed
ENR-118666	ENR	Jaanice Hunter	1982-03-04	UHC-06562-97	7312650051	4443 Jefferson Ave, Chandler, AZ, 85246	0.80	Date of birth reformatted SSN last four extracted Whitespace trimmed Placeholder values cleared
CLM-409480	CLM	Kyle Li	1946-05-20	—	—	1871 Ocean Ave, Charlotte, NC, 28217	0.80	Name re-cased SSN last four extracted Whitespace trimmed Placeholder values cleared
ENR-106595	ENR	Jerry Q Jimenez	1998-09-15	UHC-73060-74	5167002804	3727 Maple Ave, Gilbert, AZ, 85294	0.80	Name re-cased SSN last four extracted Email lower-cased Whitespace trimmed
CLM-432655	CLM	Stephen Watkins	1966-10-20	UHC-21594-17	3607863037	—	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Placeholder values cleared
ENR-130612	ENR	Jake A Padilla	1975-12-12	UHC-75060-56	8893703420	1497 Church St, Tucson, AZ, 85793	0.80	Date of birth reformatted Phone reformatted SSN last four extracted Whitespace trimmed
ENR-129002	ENR	Samuel D Martinez	1993-04-08	UHC-56424-34	4304654165	8593 Jefferson Ave, Eden Prairie, MN, 55338	0.80	Name re-cased Phone reformatted SSN last four extracted City re-cased
TPA-61580	TPA	Hannah Maartinez	1944-05-13	—	—	6560 Lincoln Way, San Diego, CA, 92159	0.80	SSN last four extracted Email lower-cased Whitespace trimmed Placeholder values cleared
TPA-54935	TPA	Joyce Q Spencer	1948-01-17	—	9712380933	5919 Broadway, Sacramento, CA, 95800	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
CLM-408863	CLM	Jerry Crawford	1980-07-03	UHC-60376-73	9117180729	—	0.80	Name re-cased Date of birth reformatted SSN last four extracted Whitespace trimmed
TPA-61116	TPA	Frances Hanson	1954-10-11	—	4215886375	3170 Valley View Dr, Glendale, AZ, 85368	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
CLM-414208	CLM	Natalie Nichols	2001-03-02	UHC-43855-55	—	—	0.80	Name re-cased Date of birth reformatted SSN last four extracted Placeholder values cleared
ENR-103813	ENR	Frances O Bailey	1996-09-28	UHC-91801-04	3732999548	8364 Park Pl, Nashville, TN, 37226	0.80	Name re-cased Phone reformatted Member ID reformatted SSN last four extracted
CLM-431393	CLM	Joan Ruiz	1955-05-01	UHC-01996-90	—	—	0.80	Name re-cased Date of birth reformatted SSN last four extracted Placeholder values cleared
ENR-108838	ENR	Terry C Austin	1962-09-03	UHC-75491-03	—	—	0.80	Date of birth reformatted Member ID reformatted SSN last four extracted Placeholder values cleared
ENR-136417	ENR	Madison I Nichols	1945-06-25	UHC-60294-10	6402278933	9777 Desert Sky Blvd, Jacksonville, FL, 32201	0.80	Phone reformatted Member ID reformatted SSN last four extracted Whitespace trimmed
ENR-129460	ENR	Jessica I Reed	1945-08-10	UHC-81057-51	—	3048 Cedar Ln, Minneapolis, MN, 55466	0.80	Name re-cased SSN last four extracted City re-cased Placeholder values cleared
ENR-138105	ENR	Lauren Silva	1946-07-01	UHC-22401-06	2487498456	7322 Ocean Ave, Phoenix, AZ, 85099	0.80	Name re-cased Phone reformatted SSN last four extracted Whitespace trimmed
ENR-134981	ENR	Dylan B Jensen	1941-11-28	UHC-72072-71	5702622896	1814 Broadway, Columbus, OH, 43256	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
ENR-141584	ENR	Camila J Price	1972-05-11	UHC-50192-84	—	6672 Canyon Rd, Nashville, TN, 37270	0.80	Name re-cased SSN last four extracted City re-cased Placeholder values cleared
CLM-406101	CLM	Bobby Rojas	1945-05-20	—	—	—	0.80	Name re-cased Date of birth reformatted SSN last four extracted Placeholder values cleared
ENR-139635	ENR	Alexander Nunez	1958-01-12	UHC-17804-40	7666554165	—	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
CLM-415077	CLM	Mariana Robertson	2004-08-20	—	8417085404	—	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
ENR-100059	ENR	Doris F Garza	1957-12-18	UHC-03918-71	5597495345	5194 Desert Sky Blvd, Los Angeles, CA, 90000	0.80	Phone reformatted SSN last four extracted Email lower-cased Whitespace trimmed
ENR-130176	ENR	Daniel P Ellis	1977-11-27	UHC-49609-99	3545564756	1259 Maple Ave, Nashville, TN, 37258	0.80	Phone reformatted Member ID reformatted SSN last four extracted Placeholder values cleared
TPA-64297	TPA	Jeremy Murphy	1938-01-10	—	6127206749	—	0.80	Name re-cased Phone reformatted SSN last four extracted Placeholder values cleared
PRV-26148	PRV	Julia Garza	1951-12-07	—	—	9030 Indian School Rd, Las Vegas, NV, 89162	0.80	Name re-cased SSN last four extracted Whitespace trimmed Placeholder values cleared
CLM-406438	CLM	Mason Little	1947-02-26	UHC-15343-10	—	—	0.82	Date of birth reformatted SSN last four extracted Placeholder values cleared
CLM-413894	CLM	Anna Ellis	1967-11-23	UHC-86115-09	—	4372 Lake View Rd, Sacramento, CA, 95841	0.82	Name re-cased SSN last four extracted Placeholder values cleared
ENR-129248	ENR	Camila Cox	1938-02-19	—	3228283937	2807 Grand Ave, Las Vegas, NV, 89111	0.82	Name re-cased SSN last four extracted Placeholder values cleared

2,817 rows, page 52 of 57Previous Next