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
PRV-28696PRVHenry King1989-12-02——3949 Central Ave Apt 11, Las Vegas, NV0.38Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
ENR-107209ENRValentina B Duncan1952-02-08UHC-28239-7633176674185220 Indian School Rd, Los Angeles, CA0.38Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51181TPAPatrcik T Grant1963-01-08——592 Apache Blvd, Atlanta, GA, 303720.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-123148ENRSara J Allen2001-11-27UHC-39389-95—5893 Indian School Rd, Tucson, AZ0.38Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-127824ENRWillie N Ellis1995-03-19UHC-79765-16—8597 Cedar Ln, San Diego, CA, 921860.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-103239ENRPriya N Phillips1940-01-02UHC-10701-4774996082206123 Apache Blvd, Columbus, OH, 432430.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-117703ENRLinda W Ortega—UHC-22191-2754243099818401 Sunset Blvd, Dallas, TX, 752430.38Name split from “Last, First”Middle initial moved out of first nameDate of birth unreadablePhone reformatted+3 more
ENR-104599ENRJoseph M Wang1976-04-25UHC-31813-40—7202 River Rd Apt 32, San Diego, CA0.38Name re-casedPhone missing area codeMember ID reformattedUnit split from street+3 more
ENR-138352ENRArjun Meyer2006-05-24UHC-25647-22—3470 Jefferson Ave, Phoenix, AZ0.38Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-428266CLMLaura Thommas1940-04-21UHC-63477-40—2534 Central Ave # 407, Columbus, OH, 432270.38Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-112918ENRBetty Martinez1996-03-10UHC-16621-1973249306025975 Lake View Rd # 834, Jacksonville, FL, 322740.38Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+3 more
CLM-420249CLMNathan Mendoza1952-11-13UHC-94958-6480345258125711 Elm St, Atlanta, GA0.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126056ENRAlexander U Payne2007-04-03UHC-40615-862942080306241 Ridge Rd, Tempe, AZ, 852230.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403709CLMKeith Vazquez1965-05-23—20966825676164 Grand Ave Apt 19, Scottsdale, AZ0.38Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-57027TPAJudith Mills1943-05-28—39481505867674 Pine Dr, Denver, CO, 802050.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-110328ENRMichael Gardner1960-06-10UHC-58642-8482740250534736 Meadow Ln, Charlotte, NC, 282720.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110377ENRKyle P Mason1952-03-09UHC-06799-9485455931915448 Ocean Ave, Denver, CO, 802110.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-119434ENRFrances Z White1968-11-16UHC-12054-2264757341213852 Main St, Dallas, TX0.38Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61249TPATheresa Gonzales2007-09-28——3488 Lake View Rd Apt 33, Nashville, TN, 372220.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-22615PRVMary Moreno1992-12-28—91677916782055 Cedar Ln Apt 30, Phoenix, AZ, 850500.40Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-426262CLMJulia Calrson1963-11-18UHC-47137-69—4096 Central Ave, Gilbert, AZ, 852150.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-426263CLMJulia Calrson1963-11-18UHC-47137-69—4096 Central Ave, Gilbert, AZ, 852150.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-412128CLMRuth Rose2006-07-19——4493 Main St, Minneapolis, MN, 554920.40Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-136909ENRJoseph Jimenez—UHC-63252-0831276095829058 Camelback Rd, Tempe, AZ, 852440.40Name split from “Last, First”Date of birth missingSSN last four extractedStreet suffix standardised+2 more
ENR-103663ENRRalph F Burke2002-09-27UHC-69359-45—4824 River Rd, Atlanta, GA0.40Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-115542ENRRoy A Parker1998-01-16UHC-22953-3752260324795194 Cedar Ln, San Diego, CA, 921580.40Name split from “Last, First”Middle initial moved out of first nameTwo-digit birth yearPhone reformatted+2 more
ENR-106768ENRChaarlotte Pierce1952-11-13UHC-17584-8862949848626045 Meadow Ln, San Antonio, TX, 782650.40Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64469TPAVirginia Guerrero1939-07-02——7836 Ocean Ave, Miami, FL, 331460.40Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-138265ENRSarah E Contreras1947-06-23UHC-09556-3091878465202116 Washington St # 543, San Antonio, TX, 782050.40Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-50661TPARonald Gonzales1951-05-19——2738 Central Ave, Jacksonville, FL0.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-117674ENRChristopher H Perry1989-12-01UHC-52638-72—1905 Harbor Blvd, Sacramento, CA, 958930.40Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-56125TPANatalie Park2004-04-25——3479 Ocean Ave, Gilbert, AZ, 852400.40Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-123932ENRLuis Hudson—UHC-27450-5434754911643881 Pine Dr, Chandler, AZ, 852410.40Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402189CLMTheresa West1982-03-22UHC-07177-15—8304 Baseline Rd, San Diego, CA, 921310.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-107277ENRDanielle Walsh1984-02-04UHC-00298-6394599869669278 River Rd, Columbus, OH, 432500.40Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-432413CLMJudy Henry1987-05-03UHC-61460-03——0.40Name split from “Last, First”Phone missing area codeSSN last four extractedGender normalised+2 more
ENR-113184ENRCharlotte G Larson1991-02-27UHC-18308-0161696179977747 Pine Dr, Charlotte, NC, 282660.40Name split from “Last, First”Two-digit birth yearPhone reformattedState name converted to code+2 more
ENR-105424ENRElijah F Reyes—UHC-97983-2920649070619605 Valley View Dr, Fresno, CA0.40Name split from “Last, First”Date of birth unreadablePhone reformattedZIP missing+2 more
ENR-123653ENRHiroshi G Park1959-12-07UHC-48459-6254643549214378 Apache Blvd, Gilbert, AZ, 852410.40Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-104130ENRNatalie James1972-03-18UHC-44696-0976894676895951 Desert Sky Blvd, Scottsdale, AZ, 852370.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-24012PRVTheresa A Cook1987-01-13—49924856978803 Mountain View Dr # 687, Denver, CO, 802970.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-100596ENRJuan Castro1979-08-01UHC-48650-39—3550 Sunset Blvd, San Antonio, TX, 782610.40Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-407481CLMSteven G Ellis1944-12-28UHC-97673-7649180304326255 Park Pl, Jacksonville, FL, 322720.40Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedSSN last four extracted+2 more
ENR-125118ENRPat I Howard1968-04-16UHC-28807-93—9540 Ocean Ave Apt 24, Nashville, TN, 372650.40Name split from “Last, First”SSN last four extractedUnit split from streetZIP+4 trimmed+2 more
ENR-103810ENRJusttin H Vega1963-07-18UHC-33269-6171185336908801 Washington St, Austin, TX, 787940.40SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405173CLMBarbara R Silva1965-04-05—33641360397394 Valley View Dr, Austin, TX, 787810.40Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-125064ENRVirginia B Hamilton—UHC-42593-6764028669784719 Ocean Ave, Gilbert, AZ, 852090.40Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-112536ENRJennifer Larson1989-06-21UHC-10361-8326553301944725 Elm St, Phoenix, AZ, 850480.40Name split from “Last, First”Two-digit birth yearSSN last four extractedStreet suffix standardised+2 more
ENR-103632ENRMark Ray1947-03-25UHC-24246-6275968286587803 Valley View Dr Apt 32, Chandler, AZ0.40Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-142141ENRKiberly Carlson1992-02-13UHC-99272-7796778917448110 Highland Ave # 808, Mesa, AZ0.40Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 34 of 2,000PreviousNext