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 “ZIP missing”, lowest dq score first

All ENR CLM TPA PRV

Junk onlyFlagZIP missingClear

Record	Source	Name	DOB	Member ID	Phone	Address	Quality score	Flags
TPA-52662	TPA	Brian Perkins	1971-11-22	UHC-98944-17	—	2848 Sage Ct, Seattle, WA	0.54	Street suffix standardised Address re-cased ZIP missing Gender normalised+1 more
ENR-117681	ENR	Noah Bryant	1960-02-06	UHC-04206-02	9829284265	7257 Camelback Rd, Tempe, AZ	0.54	Phone reformatted Street suffix standardised Address re-cased State name converted to code+1 more
CLM-405352	CLM	Santiago Gardner	1988-07-05	—	—	628 Oak St, San Antonio, TX	0.54	Street suffix standardised Address re-cased State name converted to code ZIP missing+1 more
TPA-53891	TPA	Fatima Vargas	2006-12-02	UHC-86574-22	—	4236 Sage Ct Apt 28, Tampa, FL	0.54	Unit split from street Street suffix standardised Address re-cased ZIP missing+1 more
CLM-420917	CLM	Sam Ward	1988-04-23	UHC-59135-15	—	2150 Church St, Gilbert, AZ	0.54	Street suffix standardised Address re-cased State name converted to code ZIP missing+1 more
ENR-115214	ENR	Hannah Andrews	1987-09-21	UHC-15893-43	2962932989	9390 Palm Dr, Sacramento, CA	0.54	Name split from “Last, First”State code upper-cased ZIP missing Gender normalised+1 more
ENR-101849	ENR	Stephen Murphy	1992-11-09	UHC-54490-83	2345384671	2604 River Rd, Eden Prairie, MN	0.54	Name split from “Last, First”Two-digit birth year Phone reformatted ZIP missing+1 more
TPA-57709	TPA	Brndon Shaw	1960-11-07	—	—	7007 Oak St, Denver, CO	0.54	Two-digit birth year Street suffix standardised Address re-cased ZIP missing+1 more
ENR-120819	ENR	Karen L Woods	1944-07-03	UHC-39950-19	7016126988	9357 Indian School Rd, Plano, TX	0.54	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing+1 more
TPA-53721	TPA	Bryan Palmer	—	UHC-88787-64	—	7401 Lincoln Way, Los Angeles, CA	0.54	Name re-cased Date of birth unreadable ZIP missing Gender normalised+1 more
TPA-59253	TPA	Joshua Williamson	1987-07-19	—	—	2202 Apache Blvd, Jacksonville, FL	0.54	Street suffix standardised Address re-cased ZIP missing Gender normalised+1 more
TPA-59315	TPA	Willie Le	1969-09-17	UHC-73240-85	—	6908 Oak St, Sacramento, CA	0.54	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing+1 more
CLM-419592	CLM	Jess Lane	1971-09-20	UHC-38571-56	7589210613	7112 Grand Ave # 411, Phoenix, AZ	0.54	Unit split from street Street suffix standardised Address re-cased ZIP missing+1 more
TPA-58422	TPA	Joshua Hoffman	1949-01-03	—	—	5706 Desert Sky Blvd, Denver, CO	0.54	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing+1 more
TPA-53600	TPA	Mark Park	1959-03-08	—	—	8718 Church St, Gilbert, AZ	0.54	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing+1 more
PRV-26829	PRV	Alice L Marquez	1997-08-26	—	7535676148	2926 Jefferson Ave # 615, Denver, CO	0.56	Unit split from street ZIP missing Gender normalised Placeholder values cleared
CLM-416950	CLM	Denise X Padilla	—	UHC-97647-24	—	1651 Hillcrest Rd, Denver, CO	0.56	Date of birth unreadable State name converted to code ZIP missing Placeholder values cleared
ENR-137282	ENR	Shilrey Day	1939-05-17	UHC-72696-71	3902685656	8550 Cedar Ln, Plano, TX	0.56	Name split from “Last, First”Phone reformatted State name converted to code ZIP missing
CLM-409242	CLM	Hannah Oliver	1951-07-08	UHC-60027-75	—	926 Oak St, Scottsdale, AZ	0.56	Two-digit birth year Street suffix standardised Address re-cased ZIP missing
TPA-61204	TPA	Bryan Stevens	1978-01-24	—	—	2714 Harbor Blvd, Scottsdale, AZ	0.56	Two-digit birth year ZIP missing Gender normalised Placeholder values cleared
ENR-121262	ENR	Jeremy Ray	1995-12-15	UHC-72912-98	8119407369	2100 Sunset Blvd, Charlotte, NC	0.56	Two-digit birth year Street suffix standardised Address re-cased ZIP missing
ENR-106414	ENR	Arthur H Harris	1984-02-13	UHC-20418-29	8566058465	6027 Church St, Scottsdale, AZ	0.56	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+6 more
CLM-403649	CLM	Becky Q Williams	1972-11-15	UHC-01047-48	—	5115 Elm St, Dallas, TX	0.56	Name split from “Last, First”Phone missing area code ZIP missing Placeholder values cleared
ENR-110733	ENR	Paul R Kelley	1970-01-07	UHC-52485-37	8606716045	3925 Hillcrest Rd # 518, Jacksonville, FL	0.56	Two-digit birth year Phone reformatted Unit split from street ZIP missing
ENR-102820	ENR	Gloria K Romero	1963-12-16	UHC-06754-11	—	6990 Sunset Blvd Apt 29, Dallas, TX	0.56	Unit split from street State name converted to code ZIP missing Placeholder values cleared
ENR-119003	ENR	Sophia Peterson	1949-12-06	UHC-37400-94	9365541357	2121 Grand Ave, Houston, TX	0.56	Two-digit birth year Street suffix standardised Address re-cased ZIP missing
TPA-56121	TPA	Julia Cunningham	1954-05-28	UHC-98772-34	—	3668 Spring St, Austin, TX	0.56	Name split from “Last, First”City re-cased ZIP missing Gender normalised
PRV-28848	PRV	Omar Jacobs	1943-10-14	UHC-10426-17	—	1000 Washington St, Dallas, TX	0.56	Name split from “Last, First”State name converted to code ZIP missing Placeholder values cleared
PRV-26657	PRV	Theresa Hicks	1969-02-09	UHC-01574-14	—	1799 Highland Ave, Jacksonville, FL	0.56	SSN last four extracted ZIP missing Gender normalised Placeholder values cleared
PRV-26555	PRV	Luis V Freeman	1999-10-21	UHC-92466-19	7084742253	7776 Indian School Rd, Chandler, AZ	0.56	Name re-cased Date of birth reformatted Phone reformatted Street suffix standardised+6 more
ENR-140344	ENR	Judith Morgan	1942-12-17	UHC-85227-49	4493674179	112 Meadow Ln, Chandler, AZ	0.56	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+6 more
ENR-141773	ENR	Ryan R Butler	2001-07-04	UHC-03130-93	3875605862	8043 River Rd, Tucson, AZ	0.56	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing
CLM-424972	CLM	Luis Cole	1976-05-18	UHC-54865-68	—	1216 Grand Ave, Charlotte, NC	0.56	State name converted to code ZIP missing Gender normalised Placeholder values cleared
ENR-100256	ENR	Aaron O Lawrence	1961-02-02	UHC-70537-90	7265745716	7528 Apache Blvd, Chandler, AZ	0.56	Middle initial moved out of first name Street suffix standardised Address re-cased ZIP missing
ENR-125500	ENR	Marilyn Ray	1980-11-13	UHC-54757-66	—	6694 Sage Ct, Charlotte, NC	0.56	Name split from “Last, First”Street suffix standardised Address re-cased ZIP missing
ENR-128499	ENR	Henry Allen	1971-08-01	UHC-76663-03	—	8503 Pine Dr, Columbus, OH	0.56	Name split from “Last, First”Phone missing area code ZIP missing Email lower-cased
CLM-420465	CLM	Shirley Washington	—	UHC-05301-16	—	5417 Valley View Dr, San Diego, CA	0.56	Date of birth unreadable ZIP missing Gender normalised Placeholder values cleared
CLM-427879	CLM	Joyce Nunez	1991-01-18	UHC-97504-31	—	6894 Desert Sky Blvd # 693, Seattle, WA	0.56	SSN last four extracted Unit split from street ZIP missing Placeholder values cleared
CLM-427661	CLM	Mason Hamilton	1988-11-25	UHC-38301-28	—	3651 Ocean Ave, Gilbert, AZ	0.56	Name split from “Last, First”ZIP missing Gender normalised Placeholder values cleared
ENR-108035	ENR	Logan Y Thompson	1942-05-19	UHC-52807-74	5892928123	6607 Park Pl, Las Vegas, NV	0.56	Two-digit birth year Phone reformatted ZIP missing Gender normalised
ENR-119783	ENR	Benjamin R Hunter	—	UHC-32263-44	7119127618	7826 Willow Ct, Minneapolis, MN	0.56	Date of birth unreadable Phone reformatted ZIP missing Gender normalised
ENR-131223	ENR	Martha M Dominguez	1976-10-06	UHC-73212-31	3222632847	7973 Apache Blvd, Atlanta, GA	0.56	Member ID reformatted State name converted to code ZIP missing Gender normalised
ENR-118460	ENR	Joseph V Porter	1960-06-27	UHC-81468-86	—	6037 Sage Ct, Gilbert, AZ	0.56	State name converted to code ZIP missing Gender normalised Whitespace trimmed
CLM-403253	CLM	Harold V Ford	1948-12-14	UHC-03013-33	—	7988 Mesa Dr # 691, Miami, FL	0.56	Unit split from street State name converted to code ZIP missing Placeholder values cleared
ENR-116154	ENR	James E Watkins	—	UHC-32087-19	5792920257	4317 Union St, Tucson, AZ	0.56	Date of birth missing State name converted to code ZIP missing Placeholder values cleared
ENR-117331	ENR	Anan S Walsh	1957-03-01	UHC-93358-69	—	1738 Sunset Blvd # 498, Jacksonville, FL	0.56	Phone missing area code Unit split from street ZIP missing Whitespace trimmed
ENR-127342	ENR	Oliviia Boyd	1990-02-22	UHC-64956-73	4953555836	2665 Canyon Rd, Nashville, TN	0.56	Name split from “Last, First”Two-digit birth year ZIP missing Whitespace trimmed
ENR-112600	ENR	Andrew L Bennett	1959-07-03	UHC-25240-08	3412037316	7139 Grand Ave, Denver, CO	0.56	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+6 more
TPA-60143	TPA	Amber Watkins	1976-10-16	—	—	9383 Baseline Rd, Tempe, AZ	0.56	Name split from “Last, First”Two-digit birth year ZIP missing Placeholder values cleared
ENR-141954	ENR	Ethan Stephens	1980-08-04	UHC-27099-22	3709510533	9299 Forest Ave, Fresno, CA	0.56	Street suffix standardised Address re-cased ZIP missing Gender normalised

7,146 rows, page 49 of 143Previous Next