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-135532ENRPriya Little1949-11-22UHC-53505-6975281682429710 Desert Sky Blvd, Columbus, OH, 432130.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411917CLMOlivia Anderson1990-05-17UHC-15283-6992169225014847 Bayshore Dr # 745, Tucson, AZ0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-129025ENRKenneth H Kelley2002-12-13UHC-23045-7791778007296639 Harbor Blvd, Tempe, AZ0.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-59848TPAJudy Carroll—UHC-24401-9890482926202492 Mountain View Dr, San Diego, CA, 921570.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-414541CLMBobby Carroll1998-09-03UHC-56827-6045961408928355 Palm Dr Apt 24, Chandler, AZ, 852540.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-136884ENRJack Bishop1943-04-02UHC-95340-024489283197411 Washington St, San Antonio, TX, 782800.50Two-digit birth yearPhone reformattedCity re-casedState name converted to code+3 more
ENR-128976ENRLucia Stone1995-04-04UHC-78323-1489656241432092 Bayshore Dr, Tempe, AZ, 852400.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113426ENRJennifer J Nunez1981-07-17UHC-84002-2040290786412821 Grand Ave, Eden Prairie, MN0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-111837ENRWalter O Peterson1965-10-07UHC-30055-9873956617634110 Spring St, Seattle, WA, 981440.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-127659ENRBilly O Morris2002-09-27UHC-18091-6689853237624614 Jefferson Ave, Denver, CO, 802740.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62298TPAMariana Perez1994-09-22——4020 Meadow Ln, San Diego, CA, 921210.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-121516ENRGregory M Payne1946-01-12UHC-68898-1024475026259887 Valley View Dr # 775, Los Angeles, CA, 900640.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-59347TPASteve Alvarez2007-02-25—77997605166594 Spring St, San Antonio, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110791ENRMJunk1993-04-16UHC-59220-8950924093102179 Pine Dr, Los Angeles, CA, 900730.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105619ENRGary Welch1940-12-20UHC-29174-7626679600602977 Main St # 237, Seattle, WA, 981510.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-138061ENRSophia F Carroll1994-02-22UHC-95494-8068678735441654 Highland Ave, Miami, FL, 331870.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413401CLMLauren H Shaw1997-08-15UHC-70188-66—2823 Spring St, Los Angeles, CA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-134152ENRDouglas R Woods1940-01-07UHC-42719-1937232335462430 Elm St, Columbus, OH0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-62778TPAEmma M Rodriguez1977-10-28——8610 Church St, Tempe, AZ, 852210.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-51600TPAIsabella N Harris1996-01-27—49056381043768 Mesa Dr, Eden Prairie, MN, 553460.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106293ENRMateo V Perkins2004-11-20UHC-15495-9438461921158531 Ridge Rd Apt 13, Nashville, TN, 372700.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-105366ENRCarl Carpenter1950-12-14UHC-83740-01—8723 Central Ave, Sacramento, CA, 958450.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-59374TPAValentina QJunk1949-10-14——3256 Market St, Tucson, AZ, 857100.50Name re-casedStreet suffix standardisedAddress re-casedGender normalised+3 more
CLM-415118CLMCharlie Burke1955-11-08UHC-58990-73—5211 Sunset Blvd # 664, Atlanta, GA, 303540.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-28545PRVWalter Gomez1945-05-22—59069430612117 Camelback Rd # 570, Chandler, AZ, 852990.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-141654ENRAnn Contreras1970-02-27UHC-63950-5926972344457875 Willow Ct, Atlanta, GA0.50Phone reformattedCity re-casedState name converted to codeZIP missing+3 more
CLM-416909CLMAngela Perez1955-05-05UHC-27456-12—2789 Valley View Dr, Atlanta, GA, 303310.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-102779ENRAlexis Mejia—UHC-10534-16—530 Baseline Rd, Tucson, AZ0.50Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-101378ENRJack H Hudson1946-12-16UHC-98393-2670880106155259 River Rd, Gilbert, AZ, 852650.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121181ENRJeremy Aguilar1979-11-21UHC-85770-8093429619667625 Palm Dr, Jacksonville, FL, 322910.50Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-429829CLMNancy Porter1940-07-15UHC-71964-53—6331 Ocean Ave, Dallas, TX, 752910.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-60605TPAKaren D Johnson1984-11-09——5052 Sunset Blvd, Tampa, FL, 336620.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-405130CLMSofia Obrien1967-03-16UHC-11144-4176136033717485 Ridge Rd, Jacksonville, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20016PRVSmaantha Young1990-04-28UHC-43942-38—5157 Harbor Blvd, San Antonio, TX, 782310.50Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+3 more
ENR-106851ENRCatherine U Kelly1960-03-04UHC-17734-12—4121 Mesa Dr, Las Vegas, NV, 891110.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-53541TPADeborah Freeman1943-02-20——1889 Market St, Orlando, FL, 328320.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-118827ENRSteve B Hayes1945-03-09UHC-96739-9087127520325994 Willow Ct, Scottsdale, AZ, 852640.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-129652ENRDebra C Rose1955-05-23UHC-38793-8079685645917416 Baseline Rd Apt 36, Mesa, AZ, 852760.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-126984ENRCarlos Romero1943-09-23UHC-75490-3929452976205637 Market St, Tampa, FL, 336470.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-142492ENRRebecca E Morrison1959-09-24UHC-30681-21—4518 Forest Ave, Tucson, AZ, 857860.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-138234ENRAlice I Hart1957-07-10UHC-33459-5977322087121510 Valley View Dr, Nashville, TN, 372180.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
CLM-418700CLMGeorge Shaw1984-10-02UHC-36004-7779965395686572 Bayshore Dr # 840, Tucson, AZ, 857800.50Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more
ENR-141361ENRLucia Mendoza1965-02-03UHC-92600-0237948033503079 Sunset Blvd Apt 13, Tucson, AZ, 857640.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-125631ENRBruce Gardner2004-09-23UHC-64895-2333232506165610 Hillcrest Rd, Fresno, CA, 937610.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-128870ENRMatthew V Singh1993-08-04UHC-24784-5231154964511811 Indian School Rd, Charlotte, NC, 282570.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-121033ENRCarl R Jones1962-07-01UHC-55397-6658583236212044 Washington St, Dallas, TX, 752330.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429734CLMRalph Reyes2001-05-26—72864968049795 Union St, Fresno, CA, 937190.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116175ENRJennifer C Ryan—UHC-62129-5758352533714040 Sunset Blvd, San Antonio, TX, 782500.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56030TPAArthur Richards1984-05-11——4040 Baseline Rd, Los Angeles, CA0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
ENR-135527ENRZachary M Watkins1994-12-18UHC-59413-9064127621061963 Highland Ave, Austin, TX0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
100,000 rows, page 116 of 2,000PreviousNext