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-128229ENRValentina Q Patel1943-04-05UHC-58567-4651950396579493 Canyon Rd, Seattle, WA, 981150.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419010CLMJack Mills1971-05-18UHC-22367-74—9097 Pine Dr, Dallas, TX, 752760.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
PRV-22149PRVLucia E Butler1997-12-24UHC-64949-99—3810 River Rd, Denver, CO, 802100.50Name re-casedTwo-digit birth yearPhone missing area codeMember ID reformatted+3 more
PRV-22150PRVLucia E Butler1997-12-24UHC-64949-99—3810 River Rd, Denver, CO, 802100.50Name re-casedTwo-digit birth yearPhone missing area codeMember ID reformatted+3 more
PRV-22594PRVPatricia Gomez—UHC-71807-5229284186743964 Highland Ave, Scottsdale, AZ, 852990.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422554CLMFrances Long1959-08-23——3267 Park Pl, Tucson, AZ, 857630.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-60215TPAJackie L Wheeler1959-05-23——8137 Bayshore Dr, Plano, TX, 750110.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109477ENRBobby W Garrett1963-04-16UHC-52614-0870569808806221 Canyon Rd, Mesa, AZ, 852190.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-119000ENRAisha S Ryan2006-03-11UHC-58675-9198122386957550 Spring St, Gilbert, AZ, 852200.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104065ENRJudith Pena1939-08-25UHC-47584-4556151052681931 Baseline Rd, Denver, CO, 802650.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
ENR-133564ENRMason Baker1942-12-28UHC-52066-6896258224167065 Harbor Blvd Apt 34, Columbus, OH, 432620.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-400164CLMCharlotte Wheeler—UHC-02876-57—8961 Park Pl, Sacramento, CA, 958440.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-124174ENRPhilip Larson1953-11-19UHC-32280-2846094655245533 Market St, Tucson, AZ, 857030.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52409TPAAlicce Kelley1985-01-09——666 Elm St, Tempe, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-420741CLMCarl Banks1980-11-20UHC-01367-28—6504 Mountain View Dr, Minneapolis, MN, 554670.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24598PRVLori Roberts1999-01-04UHC-78605-17—9741 Canyon Rd, Houston, TX, 770710.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
ENR-108709ENRRJunk2002-05-24UHC-45296-2486582986113205 Union St, Tucson, AZ, 857890.50Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-419611CLMLogan Miller1959-06-03UHC-02605-09—4889 River Rd, Miami, FL, 331610.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-106080ENRKaren M Campbell1967-07-12UHC-50459-1437044730863013 Market St, San Antonio, TX, 782710.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138308ENRBetty Ray1991-11-01UHC-11103-39—9637 Cedar Ln, Orlando, FL0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-113241ENRKaren E Murphy1960-01-28UHC-64792-2437546952028224 Willow Ct, Seattle, WA, 981160.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407527CLMAlice Yang1997-02-18UHC-22171-25—3250 Forest Ave, Sacramento, CA0.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-422418CLMChristian Little1980-06-27UHC-28282-07—5811 Church St, Orlando, FL0.50Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+3 more
ENR-133708ENRIsabella Vasquez2002-12-07UHC-33559-0548098506596491 Washington St Apt 19, Tempe, AZ, 852450.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-118436ENRMaria I Jordan1956-08-02UHC-38848-2352451934199605 Cedar Ln, Austin, TX, 787450.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-118354ENRMariana R Santiago2007-11-22UHC-36282-56—4386 Jefferson Ave, Tucson, AZ, 857370.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
ENR-118353ENRMariana R Santiago2007-11-22UHC-36282-56—4386 Jefferson Ave, Tucson, AZ, 857370.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
CLM-406319CLMAlexis Wheeler1957-05-26UHC-74384-5836397242976355 Highland Ave, Orlando, FL, 328900.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-105549ENRPriya Rodriguez1950-11-12UHC-48070-6468898219013100 Apache Blvd, Seattle, WA0.50Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more
CLM-413838CLMDylan Rivera1988-12-22UHC-21374-4035286397052045 Meadow Ln, Glendale, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-64327TPALucia Lucas1942-09-22—89484115696590 Grand Ave, Sacramento, CA0.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-426548CLMAmanda Hill2001-08-08UHC-75623-6493280614066405 Desert Sky Blvd, Charlotte, NC0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-421487CLMVictoria Vasquez1951-10-26UHC-89929-68—6241 Market St, Orlando, FL, 328790.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417759CLMStephen Guerrero1966-09-27UHC-23579-5565628493001690 Union St, San Diego, CA, 921920.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408370CLMMason Maldonado—UHC-54625-23—1570 Union St, Tampa, FL, 336040.50Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+3 more
ENR-108512ENRKeith G Lewis1961-10-07UHC-47050-3123255997784875 Market St Apt 22, Scottsdale, AZ, 852140.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-25877PRVJack Murray1958-06-16UHC-23811-5691449122833124 Sunset Blvd Apt 19, Houston, TX, 770110.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402221CLMKim Crawford1995-10-25——3927 Ocean Ave Apt 12, Dallas, TX, 752180.50Name re-casedTwo-digit birth yearUnit split from streetCity re-cased+3 more
TPA-59544TPAMason Garrett2005-06-06UHC-88787-58—6530 Bayshore Dr, Nashville, TN, 372810.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127376ENRElizabeth I Wallace1976-06-08UHC-00524-8485580490656933 Oak St, Houston, TX, 770280.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114727ENRSharon E Meyer—UHC-78085-8797424875763676 Maple Ave, Los Angeles, CA0.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
CLM-428303CLMBrittany Moore1952-10-22—67726506942008 Park Pl Apt 6, Atlanta, GA, 303230.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-104791ENRRaymond N Armstrong1984-08-09UHC-54364-1788085898582275 Forest Ave, Sacramento, CA, 958510.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-23057PRVPaul Bailey1947-01-06UHC-74026-8334342192692994 Pine Dr, Las Vegas, NV0.50Name re-casedDate of birth reformattedState name converted to codeZIP missing+3 more
PRV-21342PRVJordan Torres1974-05-15UHC-00744-8083050211355082 Bayshore Dr, Phoenix, AZ, 850460.50Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased+3 more
CLM-424201CLMJake Wood1989-04-24UHC-23540-39—1377 Willow Ct, Scottsdale, AZ, 852040.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-105238ENRDiana J Russell1999-01-05UHC-52397-3488071500143778 Apache Blvd, Tempe, AZ, 852280.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402053CLMNancy Munoz1947-05-03—94895086573307 Elm St, Plano, TX, 750940.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401836CLMCynthia Ray2001-07-12——846 Highland Ave, San Diego, CA, 921340.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-418556CLMDoris McCoy1962-10-10UHC-01922-8231532497596408 Union St, Las Vegas, NV, 891460.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 95 of 2,000PreviousNext