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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-51145TPACharlotte Shaw1941-11-28——9013 Canyon Rd, Chandler, AZ, 852110.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55996TPATimothy Dixon1951-11-17—44563109711368 Ridge Rd, Plano, TX0.52Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
CLM-405160CLMAlexis Fox2007-04-26UHC-32649-36—7627 Indian School Rd Apt 38, Gilbert, AZ, 852000.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+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
PRV-28752PRVJanet Carroll1938-02-10UHC-53190-2053262161376292 Union St Apt 6, Orlando, FL, 328100.52Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
CLM-414698CLMNicholas Elis1982-03-16UHC-59410-0333449271367082 Willow Ct # 712, Mesa, AZ, 852980.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-28929PRVGrace D Hughes1965-10-15—6717940564181 Central Ave, Tampa, FL, 336320.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56336TPABobby Stone1954-07-02—73995305082672 Grand Ave, Scottsdale, AZ, 852410.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+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
TPA-59517TPAKimberly Wright1983-10-10——6957 Bayshore Dr, Los Angeles, CA0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-405896CLMNoah Pena1977-02-21—70344085659475 Canyon Rd, Fresno, CA, 937010.52Name split from “Last, First”Phone reformattedStreet 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
CLM-410619CLMRonald Sanders1978-08-24UHC-31632-29—7520 Church St, Minneapolis, MN, 554140.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-401136CLMKayla Mejia2003-09-22UHC-37503-44—6725 Baseline Rd, Seattle, WA, 981600.52Two-digit birth yearStreet 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
CLM-417846CLMSean Castro1973-07-25UHC-78224-40—9846 Bayshore Dr, Tampa, FL, 336720.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-413106CLMHenry Hanson—UHC-69978-70—8735 Bayshore Dr, Houston, TX, 770670.52Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-411983CLMFuller Christian1993-07-18——7702 Harbor Blvd, Minneapolis, MN, 554310.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+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
TPA-54681TPALawrence Cunningham1998-07-17——9321 Mesa Dr # 239, Mesa, AZ0.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-430924CLMEmma Baker—UHC-19416-16—2129 Market St, Chandler, AZ, 852230.52Name split from “Last, First”Date of birth unreadableStreet 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
PRV-23860PRVDorothy F James1987-02-16UHC-93469-7740161111758094 Indian School Rd, Eden Prairie, MN, 553920.52Name split from “Last, First”Phone reformattedState name converted to codeZIP+4 trimmed+2 more
CLM-417003CLMDylan Clark1998-10-11—65536927113398 Apache Blvd Apt 15, Eden Prairie, MN, 553670.52Name split from “Last, First”Phone reformattedUnit split from streetGender normalised+2 more
ENR-130008ENRBarbara P Collins2004-05-17UHC-85662-209139945612647 Market St, Minneapolis, MN0.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57340TPADorothy Wagner———1607 Forest Ave, Tucson, AZ, 857330.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
TPA-53472TPATyler Long1981-04-15—41751778215731 Main St, Sacramento, CA, 958880.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress 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
CLM-422704CLMVirginia Cunningham1956-10-16UHC-75540-3835168136642093 Bayshore Dr Apt 26, Charlotte, NC, 282970.52Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+2 more
TPA-58191TPALauren Castillo1950-01-17——8106 Willow Ct Apt 25, Tempe, AZ, 852660.52Two-digit birth yearUnit 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
TPA-63699TPADouglas Smith1939-02-21—35545012256704 Valley View Dr, Seattle, WA, 981660.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
TPA-53571TPASofia Y Romero1978-10-13——8981 Willow Ct, Glendale, AZ, 853490.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-58633TPADylan Robinson2007-07-15——3396 Maple Ave, Orlando, FL, 328190.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+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
100,000 rows, page 151 of 2,000PreviousNext