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
CLM-425012CLMAisha Medina1999-02-06——7802 Ocean Ave # 205, San Antonio, TX, 782700.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-20235PRVCharles M Bradley1951-07-19UHC-01729-01—7702 Willow Ct, Jacksonville, FL, 322630.52Middle initial moved out of first nameTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-119227ENRLarry M Franklin1955-01-19UHC-07734-4589450555158091 Sunset Blvd Apt 22, Atlanta, GA, 303110.52Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
TPA-60773TPAAngela Wells1985-07-25——2563 Pine Dr Apt 6, Fresno, CA, 937150.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-421335CLMMaria E Spencer1977-03-27—7254509368973 Sage Ct, Eden Prairie, MN, 553490.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-116535ENRNJunk1959-01-02UHC-04096-4180671981494598 Spring St, Dallas, TX, 752620.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-430883CLMAustin Espinoza2003-02-23UHC-00961-0831334686982063 Valley View Dr, Minneapolis, MN, 554830.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-413172CLMAliceJunk1970-09-28—94185073228729 Park Pl, Houston, TX, 770780.52Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+2 more
CLM-414677CLMDunn Wei1946-05-02UHC-73139-8837561217026309 Lincoln Way # 414, Plano, TX, 750410.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-58824TPAStaven Turner1940-04-27——7023 River Rd, Gilbert, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
PRV-25282PRVWei Rogers1958-11-27UHC-04137-5478698052244311 Market St, Atlanta, GA0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427555CLMKymberly Wood1984-10-03——6099 Cedar Ln, Tucson, AZ, 857080.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-139675ENRMaria U Montgomery1951-04-08UHC-73684-4561734444292720 Baseline Rd, Plano, TX, 750560.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-400107CLMCharles N Hall1983-05-04——9101 Sage Ct, Tucson, AZ, 857980.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-129330ENRJose Hernandez2008-07-01UHC-17958-03—8649 Camelback Rd # 107, Columbus, OH0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-420148CLMSusan Yang2000-01-13UHC-21009-42—3414 Church St, Jacksonville, FL0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-133006ENRPriya G Arnold1943-10-15UHC-20609-3363476449064401 Ridge Rd, Seattle, WA, 981310.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-123632ENRJacqueline N Sanders—UHC-15346-562998888429737 Grand Ave, Glendale, AZ, 853350.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403691CLMGary V Weber1980-03-13UHC-46874-68—7590 Forest Ave, Seattle, WA, 981000.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-101600ENRWalter Garza2008-06-23UHC-07202-12—5014 Ocean Ave, Charlotte, NC, 282690.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-24566PRVJack M Barnes1979-04-24UHC-75054-56—3185 Washington St, Las Vegas, NV, 891250.52Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-414140CLMRaymond Banks1966-04-28UHC-72994-01—3219 Grand Ave, Eden Prairie, MN0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-412170CLMElizabeth Young1979-01-13UHC-34103-14—6703 Sage Ct, Miami, FL, 331330.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-106029ENRSofia Luna1995-01-17UHC-09907-3051959377704207 Cedar Ln, Dallas, TX0.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-25356PRVJames Sanders2000-11-24—69767753592275 Sage Ct, Minneapolis, MN0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-428068CLMStephen X Rios1965-11-22——1021 Ocean Ave, Charlotte, NC, 282720.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420777CLMCarol Turner1968-07-17UHC-07012-53—6068 Main St, Mesa, AZ, 852300.52Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+2 more
TPA-60511TPASean Garrett1941-08-10—75095546763081 Indian School Rd, Tampa, FL, 336620.52Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-64196TPARoger Wang1950-02-04—52873107095745 Jefferson Ave, Charlotte, NC, 282710.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-114953ENRJonathan E Wheelar2007-10-20UHC-72162-7796020963878429 Hillcrest Rd, Scottsdale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-55934TPAJeremy X Armstrong1989-04-21——9463 Harbor Blvd, Plano, TX, 750510.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-63090TPARussell Kennedy1980-05-20——4980 Jefferson Ave, Charlotte, NC, 282110.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-140579ENREthan Garza2002-06-26UHC-91432-9434968159379873 Market St, Atlanta, GA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-129563ENRTimothy Phillips2005-07-25UHC-10844-4030386150815321 River Rd, Tempe, AZ, 852050.52Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
ENR-105500ENRJustin Andrews1981-06-15UHC-75001-9871129988815448 Ridge Rd, Eden Prairie, MN, 553230.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-29096PRVTony R Bishop1984-03-26UHC-85028-3938445794102606 Valley View Dr, Seattle, WA, 981340.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102773ENRSara H Hamilton1977-01-11UHC-62889-7550660143721559 Broadway # 898, Seattle, WA, 981130.52Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+2 more
TPA-60309TPAHannah Vazquez2008-07-21——5714 River Rd # 643, Dallas, TX, 752950.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-28217PRVAshley D Cook1970-12-27UHC-87838-91—857 Palm Dr, Tampa, FL, 336280.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-118264ENRMariana Webb1981-01-23UHC-95353-72—4877 Mountain View Dr Apt 21, Seattle, WA, 981190.52Name split from “Last, First”Date of birth reformattedUnit split from streetState name converted to code+2 more
PRV-25471PRVScott Alvarado1973-09-21—96492973885896 Hillcrest Rd, Glendale, AZ, 853990.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400335CLMTerry Edwards1951-05-18—91463554921429 Desert Sky Blvd Apt 15, Miami, FL, 331690.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-120750ENRLarry L Morales2002-09-18UHC-01817-6562174769771782 Ridge Rd, Sacramento, CA, 958530.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57525TPAEvelyn P Coleman1987-02-14—23596813181338 Ridge Rd # 465, Gilbert, AZ, 852530.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-132860ENRRose F Brittany2003-08-03UHC-64681-4524590383678817 Canyon Rd, Tucson, AZ0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-105289ENRTheresa Stewart2005-05-23UHC-25878-4846381326344082 Ridge Rd, Scottsdale, AZ, 852660.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-142110ENRSandra Hudson1987-04-08UHC-87344-62—4344 Desert Sky Blvd, Seattle, WA, 981000.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
TPA-56560TPATimothy Berry2007-12-24——1940 Cedar Ln Apt 26, Plano, TX, 750950.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-120311ENRBrittany Long1978-06-02UHC-81737-6866574788206125 Forest Ave, Tempe, AZ0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56001TPAScott Powell1958-11-17——7010 Park Pl, Plano, TX0.52Name split from “Last, First”Two-digit birth yearCity re-casedZIP missing+2 more
100,000 rows, page 145 of 2,000PreviousNext