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-400880CLMJanet Wright1966-09-20UHC-45348-02—4019 Maple Ave, Minneapolis, MN, 554150.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-142797ENRMaria Perry1959-07-07UHC-21303-6289044235637211 Lake View Rd, Scottsdale, AZ, 852560.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-120722ENRRichard L Sandoval1947-10-27UHC-66581-8769229864237359 Harbor Blvd, San Diego, CA, 921070.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26322PRVMaria Delgado1996-06-14—24659137799693 Highland Ave Apt 24, Nashville, TN, 372850.52Name re-casedPhone reformattedUnit split from streetState name converted to code+2 more
TPA-61408TPAAlexaner Palmer1984-03-01——8899 Apache Blvd, Dallas, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-101673ENRWalter Rogers1947-10-27UHC-57013-9990434725053505 Baseline Rd # 880, Miami, FL, 331870.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-407177CLMAhmed T Wallace1970-07-11——4100 Cedar Ln, Scottsdale, AZ0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
ENR-135194ENRBilly M Robertson2004-11-07UHC-17775-6879328120181554 Grand Ave, Phoenix, AZ, 850230.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-130938ENRMason M Vasquze1952-12-01UHC-56594-0666964043267154 Maple Ave, Los Angeles, CA, 900970.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25757PRVEthan Simmons1947-08-08UHC-10103-539273792900922 Palm Dr Apt 24, Tempe, AZ, 852590.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-424065CLMPatricia Ross1949-05-22UHC-68744-18—52 Desert Sky Blvd, Glendale, AZ, 853940.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-28228PRVAmber Cruz1943-10-18UHC-42078-47—7339 Oak St, Austin, TX, 787070.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-126815ENRMary M Garrett2007-12-22UHC-35643-7439621122812645 Lake View Rd, Phoenix, AZ, 850180.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61052TPADavid Rios1995-08-18UHC-78651-32—1708 Camelback Rd, San Antonio, TX, 782660.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-430815CLMDiego Montgomery1950-06-08——2865 Main St, Columbus, OH, 432110.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-129837ENRBetty Saniago1938-02-07UHC-84720-4697652801526786 Elm St, Columbus, OH0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413278CLMKatherine King1944-12-21——5831 Meadow Ln # 329, Tempe, AZ, 852710.52Name re-casedTwo-digit birth yearUnit split from streetState name converted to code+2 more
ENR-105058ENRMariana X Roberts2002-01-01UHC-17847-1232855387303588 Meadow Ln Apt 12, San Antonio, TX, 782640.52Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+2 more
ENR-131858ENRKeith Carroll1988-08-27UHC-89001-4297543299053969 Apache Blvd, Tempe, AZ, 852020.52Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
CLM-419539CLMTerry Riley—UHC-75916-85—6634 Union St Apt 4, Seattle, WA, 981780.52Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-429105CLMWalter Gomez1945-05-22UHC-83989-3759069430612117 Camelback Rd, Chandler, AZ, 852990.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-430543CLMLauren Ryyan2006-01-13——4827 Hillcrest Rd # 940, Mesa, AZ, 852390.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56810TPADay Q Denny———2557 Bayshore Dr, Tempe, AZ, 852250.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-410806CLMRaymond Flores2007-11-09UHC-03771-175924754300147 Apache Blvd, Eden Prairie, MN, 553570.52Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-128683ENRJoshua Watson1993-02-28UHC-01191-7922288368762168 Elm St, Orlando, FL, 328480.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-406325CLMJeremy Ramos1965-08-26——674 River Rd Apt 23, Tempe, AZ, 852790.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-403930CLMDanielle White1999-07-17UHC-49036-2496991903275573 Bayshore Dr, Minneapolis, MN, 554700.52Name re-casedTwo-digit birth yearZIP+4 trimmedGender normalised+2 more
TPA-60660TPAAlexis Washington1988-02-18——4319 Camelback Rd Apt 29, Tampa, FL, 336960.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431912CLMMeyer I Omar1997-04-26UHC-76229-33—6245 Market St # 805, Dallas, TX, 752020.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-130206ENRMary C Ferguson1953-05-16UHC-59478-04—9096 Park Pl, Atlanta, GA, 303580.52Name re-casedPhone missing area codeCity re-casedState name converted to code+2 more
ENR-114980ENRChristina I Guzman1999-07-27UHC-18324-3930490360703359 Cedar Ln, Scottsdale, AZ, 852530.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-127059ENRLucia Vega1962-02-03UHC-18096-6232034498775744 Spring St # 598, Las Vegas, NV, 891680.52Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
ENR-127524ENRCynthia B Vazquez1980-11-27UHC-10386-4556083442578953 Spring St, Tucson, AZ, 857520.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-101748ENRAndrea R McDonald1960-02-20UHC-37874-9870226421046585 Park Pl, Nashville, TN, 372700.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-114356ENRValentina C Ray2000-05-10UHC-34927-0356168244923346 Sunset Blvd, Fresno, CA, 937500.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-25210PRVNicole M Butler1997-01-10UHC-48354-10—6720 Bayshore Dr, Eden Prairie, MN, 553160.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-52277TPAEmma Bryant1970-12-11——1609 Lincoln Way, Tucson, AZ, 857290.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-424502CLMHeather Santiago1984-05-12UHC-96448-7992162741516619 Spring St, Minneapolis, MN, 554440.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423687CLMTerry Johnson—UHC-42292-19—7141 Grand Ave, Dallas, TX, 752720.52Name split from “Last, First”Date of birth unreadableSSN last four extractedState code upper-cased+2 more
TPA-50879TPAChristina F Perez2000-01-20—45575448979108 Meadow Ln, Gilbert, AZ0.52Name split from “Last, First”Middle initial moved out of first nameCity re-casedZIP missing+2 more
ENR-111507ENR—Junk1997-08-09UHC-17258-15—7205 Central Ave, Nashville, TN, 372850.52Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-401231CLMDennis Matthews1968-10-04——4603 Desert Sky Blvd, Fresno, CA, 937520.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-409518CLMHiroshi Freeman1977-05-09UHC-18692-0345634854615685 Lake View Rd, Mesa, AZ, 852820.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-119694ENRChristine Bishop1963-08-16UHC-37025-5486876314623732 Indian School Rd Apt 25, San Antonio, TX, 782660.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-409570CLMHarold Mason1940-11-11UHC-33464-88—1481 Hillcrest Rd # 741, Gilbert, AZ, 852380.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-101494ENRJustin Z Webb1940-03-22UHC-44043-4137681724532138 Harbor Blvd, Austin, TX, 787480.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-56339TPAChristian Gonzalez1988-04-07——9250 Baseline Rd Apt 21, Nashville, TN0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-126363ENREdward W Elliott1979-05-08UHC-33180-8892052849362976 Park Pl, Tempe, AZ, 852300.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-112914ENRLinda D Matthews2000-05-27UHC-60641-4564326117625828 Baseline Rd, Tampa, FL, 336930.52Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-421301CLMDonald Mooe1991-05-04UHC-35863-3839442877769889 Indian School Rd, Austin, TX, 787610.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 142 of 2,000PreviousNext