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
ENR-116896ENRCarol N Russell2000-08-10UHC-46311-7268031310191060 Apache Blvd, Nashville, TN, 372210.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-428552CLMEugene Mendez1942-11-24——1937 Meadow Ln, Chandler, AZ, 852440.52SSN last four extractedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-400793CLMRoger Mason1964-04-28UHC-97852-8384893921245276 River Rd, Sacramento, CA0.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-120964ENRPamela B Rivera1959-06-01UHC-37756-2863460296706476 Baseline Rd, Austin, TX0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-413694CLMJesse Knight2004-04-28—39693084862451 Meadow Ln, Seattle, WA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-122117ENRGloria F Roberts1966-06-16UHC-36740-98—1681 Spring St, Austin, TX0.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-136973ENRRebecca K Ortiz1958-03-24UHC-50581-7647575770596811 Harbor Blvd Apt 8, Phoenix, AZ, 850910.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-125644ENRJessica Hunt2001-05-01UHC-40668-9286278604146736 Baseline Rd, Charlotte, NC0.52Phone reformattedState name converted to codeZIP missingGender normalised+2 more
ENR-142485ENRLinda V Payne1993-12-06UHC-07120-798087800471321 Mountain View Dr, Atlanta, GA, 303340.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-127296ENRDoris Q Fowler1957-12-26UHC-45462-2762434020789260 Apache Blvd, Minneapolis, MN, 554560.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-425278CLMPhilip R Bailey2006-02-08UHC-50588-6544075960364686 Ocean Ave # 412, Miami, FL, 331180.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-102385ENRLawrence X Young1953-09-03UHC-86523-3643593614073964 Oak St Apt 3, Tucson, AZ, 857720.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426269CLMSharon Lynch1942-12-05UHC-84606-18—7952 Mountain View Dr Apt 15, Nashville, TN, 372490.52Date of birth reformattedSSN last four extractedUnit split from streetCity re-cased+2 more
CLM-423259CLMMark Howell——5226252989—0.52Name split from “Last, First”Date of birth unreadablePhone reformattedGender normalised+2 more
ENR-110247ENRVirginia Cambell1960-05-26UHC-14615-2129443031576558 Highland Ave, San Antonio, TX0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20868PRVKathleen O Gibson2007-07-19UHC-89929-3833524730294256 Washington St, Seattle, WA, 981470.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400394CLMChristopherJunk1944-11-18UHC-48535-90—3313 Desert Sky Blvd, Minneapolis, MN, 554050.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
PRV-28854PRVVirginia Hansen1944-07-06——3692 Sunset Blvd Apt 30, Jacksonville, FL, 322200.52Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
ENR-103194ENRBrittany N Wrgiht1946-05-25UHC-09549-3732340812659086 Hillcrest Rd # 586, Miami, FL, 331010.52Phone reformattedUnit split from streetState name converted to codeEmail lower-cased+2 more
CLM-412033CLMSamuel L Wong2005-10-12——9102 Forest Ave, Houston, TX, 770620.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-121567ENRChristian Reid1972-02-24UHC-73377-6062141252991703 Broadway, Miami, FL, 331570.52Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
ENR-111200ENRCarroll K Roger1938-09-05UHC-33517-9722349545265997 Lincoln Way, Plano, TX, 750330.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-140223ENRDavis V Beverly1975-07-12UHC-26050-1745569803573508 Grand Ave # 221, Dallas, TX, 752950.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57168TPAAlice I Sanders2002-07-10——1418 Forest Ave, Plano, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-57167TPAAlice I Sanders2002-07-10——1418 Forest Ave, Plano, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-61310TPAAhmed I Li———9424 Park Pl, Eden Prairie, MN, 553610.52Name re-casedDate of birth missingState name converted to codeGender normalised+2 more
ENR-133913ENRBruce T Owens1947-01-12UHC-85462-6493171727312822 Cedar Ln, Phoenix, AZ, 850800.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103583ENRBeverly T Santos1946-10-27UHC-54601-5257960485103976 Baseline Rd, Sacramento, CA, 958110.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-122168ENRKevin N Reid1941-06-13UHC-59417-3727343407257948 Meadow Ln, Scottsdale, AZ, 852320.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-120631ENRChris Valdez1942-10-24UHC-97505-594996053513220 Pine Dr, Seattle, WA, 981070.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-409923CLMRandy L Castillo1981-06-23UHC-52935-57—7377 Mesa Dr, Las Vegas, NV, 891900.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21741PRVFrances Anderson1976-02-05—32483464427806 Market St, Dallas, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-21742PRVFrances Anderson1976-02-05—32483464427806 Market St, Dallas, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-124253ENRRonald O Crawford1985-12-25UHC-84729-7021148871813144 Market St Apt 9, San Antonio, TX, 782370.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-61489TPAValentina Morris2000-09-25UHC-14927-47—1890 Mesa Dr, Austin, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-59776TPANancy Austin1950-10-02——3707 Valley View Dr # 833, Austin, TX0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-121593ENRAnna F Bakar1944-10-27UHC-10154-5872278878473705 Palm Dr, Chandler, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-62452TPADenise L Hughes1997-09-03——8318 Central Ave, Denver, CO, 802190.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
ENR-127037ENRNatalie Daniels1951-11-28UHC-39276-1347983452215167 Ridge Rd, San Antonio, TX, 782710.52Name split from “Last, First”Date of birth reformattedState name converted to codeEmail lower-cased+2 more
ENR-127038ENRNatalie Daniels1951-11-28UHC-39276-1347983452215167 Ridge Rd, San Antonio, TX, 782710.52Name split from “Last, First”Date of birth reformattedState name converted to codeEmail lower-cased+2 more
CLM-414975CLMKeith Vasquze2000-09-04UHC-43961-56—3840 Elm St, Scottsdale, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-58481TPAGerald Banks1998-10-17UHC-54196-42—1424 Desert Sky Blvd, Mesa, AZ0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-26387PRVPatrick Mendez1963-09-16——6528 Church St, Plano, TX, 750990.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-401563CLMRichard Stewart1997-01-27——524 Mountain View Dr, Miami, FL0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-110700ENRSarah Marshall1941-06-20UHC-65902-1454178910314580 River Rd, Tucson, AZ, 857080.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-420397CLMCarol Castillo2004-05-18UHC-75924-10—9167 Canyon Rd, Tampa, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413599CLMSteven Carr—UHC-95393-63—3232 Willow Ct, Houston, TX, 770570.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-137444ENRIsabella Murphy1957-02-06UHC-81397-5322264767671338 Central Ave Apt 34, Columbus, OH, 432980.52Two-digit birth yearPhone reformattedSSN last four extractedUnit split from street+2 more
TPA-51416TPAKevin Rogers1973-08-11——4596 Central Ave, Plano, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-124974ENRLori Valdez1977-02-20UHC-27056-9129423648555922 Palm Dr, San Diego, CA0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 178 of 2,000PreviousNext