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

Enrollment, 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
ENR-120269	ENR	Ronald G Flores	1996-04-24	UHC-43464-13	9415542057	7090 Canyon Rd, Sacramento, CA, 95850	0.82	Phone reformatted State code upper-cased Gender normalised
ENR-134697	ENR	Cynthia D Carlson	1997-07-15	UHC-39422-61	—	4545 Park Pl, Chandler, AZ, 85297	0.82	Name re-cased Phone missing area code State code upper-cased
ENR-141926	ENR	Madison Q Wilson	1946-10-13	UHC-30657-32	—	1800 Lake View Rd, Atlanta, GA, 30366	0.82	Name re-cased State code upper-cased ZIP+4 trimmed
ENR-141483	ENR	Yuki Park	2004-04-23	UHC-60795-85	8915141723	6274 Camelback Rd, Tampa, FL, 33696	0.82	SSN last four extracted State code upper-cased Email lower-cased
ENR-122376	ENR	Joshua Crawford	1976-11-22	UHC-22291-10	2445474690	3815 Lincoln Way, Tampa, FL, 33691	0.84	State code upper-cased Gender normalised
ENR-122377	ENR	Joshua Crawford	1976-11-22	UHC-22291-10	2445474690	3815 Lincoln Way, Tampa, FL, 33691	0.84	State code upper-cased Gender normalised
ENR-135187	ENR	Janice B Ellis	1972-12-12	UHC-19036-34	—	8206 Sunset Blvd, Fresno, CA, 93710	0.84	Phone missing area code State code upper-cased
ENR-137170	ENR	Frank Watkins	1973-12-19	UHC-14109-41	2678679440	9153 Lake View Rd, San Antonio, TX, 78214	0.84	State code upper-cased Gender normalised
ENR-106256	ENR	Shirley Dixon	1992-01-20	UHC-15098-65	3939620981	5144 Ocean Ave, Chandler, AZ, 85281	0.84	Name split from “Last, First”State code upper-cased
ENR-106255	ENR	Shirley Dixon	1992-01-20	UHC-15098-65	3939620981	5144 Ocean Ave, Chandler, AZ, 85281	0.84	Name split from “Last, First”State code upper-cased
ENR-122259	ENR	Willie Harper	2000-09-13	UHC-88343-77	4348505661	750 Central Ave, Gilbert, AZ, 85211	0.86	Name re-cased Phone reformatted State code upper-cased Email lower-cased+3 more
ENR-118320	ENR	Steven L Mason	1946-10-25	UHC-70500-23	2546918588	586 Hillcrest Rd, Gilbert, AZ, 85203	0.86	Name re-cased Phone reformatted City re-cased State code upper-cased+3 more
ENR-101750	ENR	Angela I Hawkins	1940-08-24	UHC-86812-10	5688248155	975 Lincoln Way, Minneapolis, MN, 55432	0.86	Name re-cased Date of birth reformatted Phone reformatted Member ID reformatted+3 more
ENR-108092	ENR	Carol J Allen	1949-11-14	UHC-29947-52	5098935303	6323 Elm St, Mesa, AZ, 85257	0.86	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+3 more
ENR-134767	ENR	Brian B Carpenter	1975-09-10	UHC-74079-84	5885332447	3989 Broadway, Denver, CO, 80290	0.86	Name re-cased Phone reformatted Member ID reformatted Address re-cased+3 more
ENR-124300	ENR	Jack Y Dunn	2007-02-20	UHC-74181-40	4384003779	414 Broadway, Nashville, TN, 37216	0.86	Date of birth reformatted Phone reformatted Member ID 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
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
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
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
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
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
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
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
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
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
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
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
ENR-110383	ENR	Russell M Jenkins	1981-01-19	UHC-53169-39	3286834487	3948 Church St, Sacramento, CA, 95868	0.88	Phone reformatted City re-cased State code upper-cased Email lower-cased+2 more
ENR-107218	ENR	Watson N Steven	1974-11-05	UHC-12782-69	2099274389	8584 Valley View Dr, Denver, CO, 80290	0.88	Name re-cased Date of birth reformatted Phone reformatted State code upper-cased+2 more
ENR-116774	ENR	Ssuan X Cunningham	1972-05-03	UHC-54309-49	3028957021	1351 Baseline Rd, Gilbert, AZ, 85266	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more
ENR-124356	ENR	Sarah T Bowman	1997-02-21	UHC-34402-83	8094501550	8490 Spring St, Scottsdale, AZ, 85206	0.88	Name re-cased Date of birth reformatted Phone reformatted City re-cased+2 more

1,918 rows, page 32 of 39Previous Next