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.

Normalised records

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-135325ENRCarolyn Williamson1948-01-27UHC-33058-2262768777521659 Hillcrest Rd, Eden Prairie, MN, 553130.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-100678ENRRoy Butler—UHC-98340-5028568955789411 Desert Sky Blvd, Glendale, AZ, 853100.52Name split from “Last, First”Date of birth missingPhone reformattedMember ID reformatted+2 more
ENR-142459ENRRoy Hudson—UHC-66699-3059786388736067 Mountain View Dr, Scottsdale, AZ, 852320.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126089ENRBrian Hart1971-08-20—63851265691729 Highland Ave, San Antonio, TX0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-121535ENRSean W Estrada1976-12-02UHC-36955-3667585540426902 Washington St, Atlanta, GA0.52Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+2 more
ENR-125392ENRMelissa C McDnoald—UHC-49869-2646193273068927 Washington St, Charlotte, NC, 282130.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-135676ENRRachel C Flores2006-02-05UHC-97143-2786435665995831 Sunset Blvd Apt 39, Plano, TX, 750800.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-105931ENREugene Edwards1992-04-08UHC-98038-1173689547244452 River Rd, Seattle, WA, 981120.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-103210ENRKeith Mills1940-08-12UHC-71507-3791351906872266 Jefferson Ave # 283, Los Angeles, CA, 900440.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-134690ENRDorothy Franklin1976-08-17UHC-90811-84—1448 Desert Sky Blvd, Atlanta, GA, 303890.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-100936ENRAbigail H Simmons1953-06-10UHC-39038-398013629545749 Canyon Rd, Jacksonville, FL, 322090.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-103719ENREugene Tran1985-09-05UHC-63592-2441365528307045 Forest Ave, Las Vegas, NV, 891850.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-137443ENRDeborah Wood1952-03-25UHC-17825-2126235661529553 Palm Dr, Houston, TX, 770800.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126211ENRLucia D Thompson1985-12-14UHC-83698-89243416666019 Pine Dr, San Antonio, TX0.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-116707ENRDouglas V Peterson2005-09-15UHC-28270-41—2515 Sunset Blvd, Minneapolis, MN, 554530.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-112710ENRAdam L Ortega2002-10-06UHC-52099-8283299740876213 Valley View Dr, Denver, CO0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-101394ENRThomas Green1980-12-23UHC-57264-6650856669526585 Desert Sky Blvd # 548, San Antonio, TX, 782710.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-114327ENRChristine Evans2001-12-17UHC-01717-8935868424321279 Baseline Rd, Sacramento, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-129779ENRBeth S Reyes1944-11-12UHC-73785-4634172119086171 Spring St, Fresno, CA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127400ENRDonald Z Baker1982-01-10UHC-82382-1685041865249253 Apache Blvd # 996, Seattle, WA, 981350.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-102126ENRMelissa D Vasquez1998-05-26UHC-30778-6670552242403165 Lincoln Way, Dallas, TX, 752870.52Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+2 more
ENR-101842ENRWillie Mendoza1987-03-03UHC-26415-69—23 Meadow Ln, Tempe, AZ, 852610.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-134940ENRMadison Snyder2000-09-10UHC-85917-43—6640 Cedar Ln, Plano, TX0.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-130008ENRBarbara P Collins2004-05-17UHC-85662-209139945612647 Market St, Minneapolis, MN0.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-123786ENREmily D Chen1949-03-07UHC-23290-4966238597418476 Palm Dr, Glendale, AZ, 853810.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-142737ENRCharles J Wanng1970-06-14UHC-77837-2586337787618724 Camelback Rd, Charlotte, NC, 282490.52Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+2 more
ENR-116432ENRLaura Watkins1995-07-08UHC-10917-2422673147368758 River Rd Apt 32, Las Vegas, NV, 891350.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-130118ENRMarilyn Chavez1983-05-23UHC-35235-1727332188232301 Union St, Scottsdale, AZ0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-139444ENRArthur I Cooper1974-01-05UHC-91339-64—9829 Canyon Rd, Mesa, AZ0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-104370ENRPriya Spencer1974-11-09UHC-43621-393186362486334 Market St, Denver, CO, 802850.52Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-110213ENRAna Ward2001-06-13UHC-74459-0355240162212271 Mountain View Dr, Minneapolis, MN, 554350.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-134698ENRCynthia Carlson1997-07-15UHC-39422-61—4545 Park Pl, Chandler, AZ, 852970.52Name split from “Last, First”Date of birth reformattedPhone missing area codeState name converted to code+2 more
ENR-107891ENRElijah Moore2002-01-06UHC-84075-7996298558469244 Sunset Blvd, Seattle, WA, 981850.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142795ENREugene B Martinez1992-01-17UHC-33187-4823226440185914 Canyon Rd Apt 30, Austin, TX0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-112504ENRSharon P Mendez1974-04-01UHC-87920-2521867488026167 Ocean Ave, Phoenix, AZ, 850800.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-131070ENRGary Wells2005-02-20UHC-91876-7486886622383046 Spring St, San Diego, CA, 921890.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-128228ENRMeyer C Scott—UHC-86113-05—7628 Sage Ct, Phoenix, AZ, 850830.52Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-121324ENRGerald H Murphy1940-12-23UHC-39938-7394872201266591 River Rd, Tampa, FL0.52Two-digit birth yearPhone reformattedState name converted to codeZIP missing+2 more
ENR-124869ENRJoan O Sanders1956-07-08UHC-39294-5181194153176335 Bayshore Dr, Dallas, TX, 752120.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109617ENRJoshua C Nelson1975-02-24UHC-27770-8561437234541628 Camelback Rd, Denver, CO, 802380.52Name re-casedTwo-digit birth yearCity re-casedState name converted to code+2 more
ENR-135336ENRKatheerine E Butler1938-10-05UHC-58714-0979054446687504 Desert Sky Blvd, Houston, TX, 770990.52Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-140180ENRJennifer Stone1944-01-13UHC-97396-923432564579405 Sunset Blvd # 177, Fresno, CA, 937620.52Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-128643ENRSamuel U Rivera1944-10-26UHC-03534-3254048420285200 Palm Dr # 470, Tucson, AZ, 857490.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-113494ENRAmanda West1999-10-16UHC-07852-5156855071002723 Lincoln Way, Tempe, AZ, 852630.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-102981ENRRussell U Jensen1960-08-26UHC-60553-9786462834163170 Main St, Scottsdale, AZ, 852740.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-136433ENRAnthony Murray1940-07-20UHC-01079-25—2175 Washington St, Houston, TX, 770060.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-112739ENRAlice Foster1950-02-28UHC-58749-30350544971061 Lake View Rd, Columbus, OH, 432740.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-114540ENRMadison G Baker1940-06-12UHC-84526-6862559354964020 Harbor Blvd, San Antonio, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-142804ENRDenise C Sullivan1965-08-05—83779444927428 Lincoln Way Apt 28, Chandler, AZ, 852720.52Two-digit birth yearPhone reformattedUnit split from streetGender normalised+2 more
ENR-111775ENRTheresa Morrison1942-12-17UHC-09600-8849875118109222 Baseline Rd, Las Vegas, NV0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
43,101 rows, page 75 of 863PreviousNext