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, junk only, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-426723CLMGeorgeJunk1944-02-26UHC-26152-27—4249 Union St, Scottsdale, AZ, 852130.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103344ENRJoseph QJunk1991-08-04UHC-11166-1096160669209484 Highland Ave, Tucson, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-28862PRV—Junk2006-03-14—49287317678767 Harbor Blvd, Sacramento, CA0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108466ENR—Junk1988-10-03UHC-47094-1238432456562590 Sage Ct, Glendale, AZ, 853190.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-29149PRVLoogan GJunk2006-12-10UHC-62238-0152952754187132 Main St, Atlanta, GA, 303640.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103251ENRCJunk1977-12-02UHC-33344-7022083981876511 Harbor Blvd, Tampa, FL, 336080.50Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424756CLM—Junk1948-08-09UHC-15768-9566529518291765 Mesa Dr, Minneapolis, MN, 554620.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107560ENROJunk1991-05-19—33546682492636 Highland Ave, Sacramento, CA, 958890.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105726ENRUJunk1966-03-12UHC-76518-547278331495733 Spring St, Los Angeles, CA, 900890.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131549ENRLori WJunk1951-03-15UHC-50744-7144565177973221 Canyon Rd, Minneapolis, MN, 554060.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-23229PRVBJunk1962-08-14UHC-74741-2562423121313629 Park Pl, Tucson, AZ, 857710.50Two-digit birth yearPhone reformattedMember ID reformattedZIP+4 trimmed+3 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
ENR-116535ENRNJunk1959-01-02UHC-04096-4180671981494598 Spring St, Dallas, TX, 752620.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-413172CLMAliceJunk1970-09-28—94185073228729 Park Pl, Houston, TX, 770780.52Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+2 more
CLM-410012CLM—Junk1981-10-05UHC-80308-05—1263 Harbor Blvd, Gilbert, AZ, 852770.52Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
ENR-125990ENREvelynJunk1943-05-11UHC-35484-1854836913404609 Desert Sky Blvd, Tempe, AZ, 852130.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-141235ENR—Junk2002-09-26UHC-55937-6042285731475295 Main St, Mesa, AZ, 852410.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-123012ENRPatricia RJunk1992-08-25UHC-68939-9490897613945270 Highland Ave, Chandler, AZ, 852270.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-109011ENR—Junk—UHC-18966-01—2701 Mesa Dr, Tempe, AZ, 852400.52Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-124986ENRElizabethJunk1985-06-17UHC-07694-8992576537549041 Baseline Rd, Fresno, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-25633PRV—Junk2002-03-22——4094 Apache Blvd, Los Angeles, CA, 900850.52Date of birth reformattedPhone missing area codeState name converted to codeWhitespace trimmed+2 more
ENR-132413ENRIJunk2007-02-06UHC-55057-0567651843527501 Apache Blvd, Seattle, WA, 981630.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421086CLMPatrickJunk1992-05-21UHC-25254-36—1167 Cedar Ln, Columbus, OH, 432610.52Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+2 more
TPA-58561TPAQJunk2001-03-04UHC-59973-8764356936274763 Church St Apt 38, Plano, TX, 750680.52Phone reformattedUnit split from streetCity re-casedZIP+4 trimmed+2 more
ENR-119862ENR—Junk1970-03-25UHC-26068-2947251750806252 Valley View Dr, Minneapolis, MN, 554480.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-108250ENRYJunk1949-11-20UHC-71270-8033447360839156 Church St, Tucson, AZ, 857920.52Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
ENR-126267ENRXJunk1994-02-07UHC-72104-0586035194478276 Spring St, Las Vegas, NV0.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126268ENRXJunk1994-02-07UHC-72104-0586035194478276 Spring St, Las Vegas, NV0.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121170ENRDonald OJunk1999-01-19UHC-13344-8043769137795902 Broadway # 844, Eden Prairie, MN, 553220.52Name re-casedDate of birth reformattedUnit split from streetGender normalised+2 more
CLM-428368CLMTJunk1991-02-02UHC-14684-42—2259 Union St, Seattle, WA, 981730.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121484ENRDylanJunk1959-09-19UHC-37245-6725287082998950 Apache Blvd, Houston, TX, 770250.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-110913ENRMatthewJunk1992-09-05UHC-62583-9155275627086539 Highland Ave, Plano, TX, 750360.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-111654ENRBJunk2000-07-15UHC-49072-2453545991226548 Bayshore Dr, Mesa, AZ, 852450.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+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
TPA-54609TPA—Junk2004-04-13—62880478415051 Market St, Plano, TX, 750430.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-115215ENRBJunk1966-06-21UHC-05736-0441173089276799 Desert Sky Blvd, Jacksonville, FL, 322320.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-136633ENRJamesJunk1966-02-24UHC-52508-51—9781 Harbor Blvd, Phoenix, AZ0.52Name re-casedState name converted to codeZIP missingWhitespace trimmed+2 more
ENR-126172ENRAna TJunk1940-12-03UHC-78398-3248232537067129 Washington St, Orlando, FL, 328300.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414594CLM—Junk1963-06-14UHC-45096-59—3449 Forest Ave, Plano, TX, 750170.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-415631CLMSJunk1952-06-25UHC-75504-6440421611777190 Sunset Blvd # 502, Glendale, AZ, 853970.52Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
ENR-104662ENRKelly SJunk2002-11-22UHC-86692-9181834981882310 Highland Ave, Columbus, OH, 432860.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417150CLMMariaJunk1977-08-11—44776457507203 Central Ave, Los Angeles, CA, 900800.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427801CLM—Junk1993-07-11—42423609701303 Maple Ave, Mesa, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-125183ENRTerryJunk1994-07-21UHC-97302-8437478248981875 Indian School Rd, Dallas, TX, 752540.52Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420968CLMMelissaJunk1998-06-13UHC-73960-39—4529 Grand Ave # 997, Minneapolis, MN, 554920.52Name re-casedTwo-digit birth yearUnit split from streetWhitespace trimmed+2 more
ENR-139115ENRKJunk1940-07-15UHC-71964-5387378102526331 Ocean Ave, Dallas, TX, 752910.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119223ENRKJunk1971-03-15UHC-94640-273012390145547 Oak St, Plano, TX, 750880.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63043TPA—Junk1975-03-16——4120 River Rd, Jacksonville, FL0.52Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+2 more
PRV-26111PRVEJunk2000-05-06UHC-64732-9976794262347447 Central Ave, Miami, FL, 331710.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-400348CLM—Junk1950-12-14UHC-83429-9575649720078824 Ocean Ave, Charlotte, NC, 282940.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
505 rows, page 3 of 11PreviousNext