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-428702CLMHelen Thomas—UHC-64641-02—5587 Grand Ave, Tucson, AZ, 857720.40Name split from “Last, First”Date of birth missingPhone missing area codeGender normalised+2 more
CLM-430856CLMKaren Young—UHC-94385-95—2949 Hillcrest Rd Apt 1, San Diego, CA0.40Date of birth unreadableSSN last four extractedUnit split from streetZIP missing+2 more
ENR-114691ENRTerry J Mendez1945-08-24UHC-17080-47—9756 Valley View Dr, Dallas, TX, 752330.40Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-422795CLMWilliam Lynch1958-01-03——8148 Sunset Blvd, Los Angeles, CA, 900130.40Name split from “Last, First”Two-digit birth yearPhone missing area codeGender normalised+2 more
TPA-61504TPASara Willis1952-11-05—31042399683782 Valley View Dr, Scottsdale, AZ, 852450.40Name re-casedTwo-digit birth yearState name converted to codeZIP+4 trimmed+2 more
TPA-55902TPALinda Martinez1949-11-21——9175 Elm St Apt 28, Seattle, WA, 981720.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-127040ENRKevin G Richards1963-12-08UHC-68933-7130977787678866 Union St, Los Angeles, CA, 900440.40Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-111379ENRKathryn U Black1999-08-22UHC-64841-78—3358 Hillcrest Rd Apt 33, Columbus, OH, 432470.40SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-130035ENRAna Q Bailey1955-11-03UHC-92400-2065246790349425 Forest Ave, San Diego, CA0.40Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61970TPAArjun P Morrison——86651698422175 Camelback Rd Apt 32, Austin, TX, 787350.40Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-101697ENRSean Y Daniels1990-07-07UHC-27724-3823523098806022 Cedar Ln Apt 36, Orlando, FL, 328250.40Two-digit birth yearSSN last four extractedUnit split from streetStreet suffix standardised+2 more
TPA-53658TPAShirley Hamilton1967-04-03——7867 Canyon Rd, Jacksonville, FL, 322070.40Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-407461CLMCarolyn M Palmer———1182 Apache Blvd, Orlando, FL, 328860.40Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-133572ENRRoger McDonald1946-11-09UHC-71156-86—1786 Palm Dr # 676, Fresno, CA, 937880.40Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-129101ENRWillie L Wells1947-02-04UHC-94921-2539227233086530 Lincoln Way, Glendale, AZ, 853720.40Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-405782CLMMatthew Ryan———2434 Willow Ct, Eden Prairie, MN, 553860.40Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-416413CLMNancy I Sandoval1983-11-03UHC-95939-6795582604872398 Desert Sky Blvd, Scottsdale, AZ, 852840.40Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414951CLMKathryn Gonzalez1988-08-13UHC-91606-76—4472 Main St, Minneapolis, MN0.40Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-420653CLMJacob Z Carpenter—UHC-24720-46—5511 Mountain View Dr, Tempe, AZ0.40Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-103170ENRPeter E Roberts1988-04-11UHC-41456-8640762909737569 Church St, Scottsdale, AZ, 852530.40Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103096ENRDiana A Hudson—UHC-99151-84—4568 Elm St, Tempe, AZ, 852810.40Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-114084ENRWalter D Parker1996-06-10UHC-95006-0823378400731424 Meadow Ln, Orlando, FL, 328290.40Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-140811ENRJanet S Lewis1970-10-07UHC-35740-3561646249993583 River Rd # 937, Phoenix, AZ, 850550.40Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-52980TPAJacqueline Burke1994-12-08——904 Baseline Rd Apt 33, Tucson, AZ, 857020.42Name split from “Last, First”Unit split from streetZIP+4 trimmedGender normalised+1 more
ENR-123869ENRRaymond X Patel1983-07-14UHC-58315-2473178532365018 Broadway Apt 7, Dallas, TX, 752010.42Name re-casedTwo-digit birth yearUnit split from streetZIP+4 trimmed+1 more
ENR-138224ENRElizabeth U Olson1946-11-20UHC-70010-4657555866676038 Grand Ave, Dallas, TX, 752210.42Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-105872ENRPriya Dixon1998-08-21UHC-42866-5132095319584608 Desert Sky Blvd, Columbus, OH, 432610.42Name split from “Last, First”Two-digit birth yearPhone reformattedState name converted to code+1 more
ENR-120955ENRElijah Montgomery1956-12-07UHC-48585-5172430627126026 Sage Ct, Denver, CO0.42Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-409599CLMDebra J Olson1973-11-04—62472237648781 Indian School Rd, Orlando, FL, 328280.42Name split from “Last, First”Two-digit birth yearZIP+4 trimmedGender normalised+1 more
ENR-135882ENRSusan Mitchell1975-09-07UHC-29467-72—1896 Lincoln Way # 805, Tampa, FL0.42Name re-casedPhone missing area codeUnit split from streetZIP missing+1 more
ENR-118744ENRJeremy C Howard1989-02-15UHC-37377-19—9211 Maple Ave, Houston, TX0.42Two-digit birth yearPhone missing area codeSSN last four extractedCity re-cased+1 more
CLM-415699CLMJudy Burns1980-12-09——3367 Maple Ave Apt 35, Seattle, WA, 981090.42Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-127275ENRWalter E Hernandez2001-11-13UHC-05632-9430599259292225 Ridge Rd, Nashville, TN0.42Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-112340ENRMatthew Alexander—UHC-01927-6796894387898271 Mountain View Dr, Glendale, AZ, 853280.42Date of birth unreadablePhone reformattedState name converted to codeZIP+4 trimmed+1 more
ENR-134638ENRKevin N Rios1985-03-20UHC-15324-69—6283 Desert Sky Blvd Apt 2, Houston, TX0.42Name re-casedPhone missing area codeUnit split from streetZIP missing+1 more
TPA-54949TPADaniel Austin1967-05-16——7940 Mesa Dr Apt 37, Scottsdale, AZ0.42Name split from “Last, First”Unit split from streetState name converted to codeZIP missing+1 more
ENR-110513ENRJoshua R Hayes1956-04-13UHC-85275-2259185841283463 Mountain View Dr, San Diego, CA, 921490.42Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-135224ENROlivia X Cloe2008-08-16UHC-38020-85—6381 Harbor Blvd # 292, Eden Prairie, MN0.42Name split from “Last, First”Date of birth reformattedPhone missing area codeUnit split from street+1 more
TPA-54953TPAJudy J Nichols1977-03-04——468 Spring St Apt 17, Phoenix, AZ, 850030.42Name split from “Last, First”Two-digit birth yearUnit split from streetGender normalised+1 more
ENR-131372ENRWalter X Ray1991-11-28UHC-99412-1081557609921070 Cedar Ln, Austin, TX0.42Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-112594ENRMegan M Simpson1996-02-28UHC-32074-70—9117 Market St Apt 30, Los Angeles, CA, 900910.42Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-136020ENRMJunk2002-07-06—58888564972512 Pine Dr, Phoenix, AZ, 850390.42Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-142246ENRAmer A Greene1990-06-27UHC-89256-42—9432 Park Pl, San Antonio, TX, 782040.42Phone missing area codeSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
TPA-53704TPAJason Davis2008-11-02UHC-10468-5888862584198435 Pine Dr, Gilbert, AZ, 852880.42Phone reformattedSSN last four extractedState name converted to codeZIP+4 trimmed+1 more
ENR-128715ENRJoshua L Harper1971-08-11UHC-85497-416416367192282 Ocean Ave, Los Angeles, CA, 900230.42Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+1 more
PRV-24156PRVCharlotte Washington2005-08-24UHC-01290-5498369330031416 Washington St Apt 15, Denver, CO, 802110.42Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-104573ENRKevin S Espinoza1957-12-15UHC-95455-8841331632225811 Union St, Denver, CO, 802160.42Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-143027ENRDoris Meyer1960-12-20UHC-45303-32—7944 Valley View Dr # 283, Plano, TX0.42Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-21865PRVJessica Larson1995-02-09—59634890323604 Maple Ave # 500, Las Vegas, NV0.42Name split from “Last, First”Unit split from streetState name converted to codeZIP missing+1 more
ENR-123362ENRCheryl Hansen—UHC-33532-41—4801 Hillcrest Rd, Scottsdale, AZ0.42Date of birth missingSSN last four extractedZIP missingGender normalised+1 more
100,000 rows, page 39 of 2,000PreviousNext