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
TPA-58737TPABrian Hart1972-08-20—63851265691729 Highland Ave Apt 26, San Antonio, TX, 782580.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-421544CLMMegan Medina1944-10-12——3116 Hillcrest Rd, Jacksonville, FL, 322450.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-428129CLMRuth Meyer2004-06-19UHC-88349-2786473581078704 Central Ave, Glendale, AZ, 853410.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-113826ENRAhmed Z Burke1958-06-22UHC-38144-7238776477452720 Spring St Apt 19, Minneapolis, MN, 554350.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-113260ENRCarolyn Moore—UHC-65072-5222049560988841 Jefferson Ave, Nashville, TN, 372230.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
TPA-61042TPATyler Jenkins1999-10-06——7396 Ridge Rd, Fresno, CA, 937430.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-119166ENRAshley Alvarado1992-05-17UHC-25866-6358583078485400 Washington St, Atlanta, GA, 303770.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
CLM-401340CLMCatherine X Ellis1939-12-19UHC-05992-1975137687123991 Park Pl, Chandler, AZ, 852020.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-405449CLMDrew Brdaley—UHC-76594-50—3975 Sunset Blvd, Fresno, CA, 937920.50Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-403110CLMAndrea Fuller2005-03-01—31774117138857 Camelback Rd # 513, Tucson, AZ, 857370.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-123774ENRFields O Walter1938-08-18UHC-01743-6460369302649344 Camelback Rd, Fresno, CA0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
ENR-136539ENRLgan Q Tran1997-05-11UHC-26362-9072965001554762 Canyon Rd, Plano, TX, 750570.50Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-400628CLMAlexander Thompson—UHC-81966-47—8452 Central Ave, Eden Prairie, MN0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-123558ENRAmanad Fisher1970-08-21UHC-11517-2825344436135090 Willow Ct # 652, Phoenix, AZ, 850070.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-136039ENRLucia Gonzalez1978-07-05UHC-77260-8976320528213897 Bayshore Dr, Sacramento, CA, 958730.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100158ENRBobby Hoffman1987-01-23UHC-04901-7791084658003548 Camelback Rd Apt 34, Denver, CO, 802900.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-139290ENRDaniels Jeremy—UHC-69692-8136992279254069 Oak St, Denver, CO, 802190.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27414PRVStephanie J Wagner—UHC-41796-51—7721 River Rd, Gilbert, AZ, 852050.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-408816CLMVicoria Franklin———5345 Valley View Dr, Denver, CO0.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-139952ENRMarilyn Ramirez1970-06-01UHC-67599-81—8681 Spring St, Charlotte, NC0.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-124663ENRRonald Long—UHC-17595-06—3301 Oak St, Charlotte, NC, 282700.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-100752ENRJose L Fower1999-10-17UHC-49377-6730323040236354 Forest Ave, Minneapolis, MN0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-116486ENRMei Gant1950-02-14UHC-98407-6273431918363793 Lake View Rd, San Diego, CA, 921680.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-431476CLMWalter Schmidt1969-06-01UHC-99198-9189424875298499 Elm St, Charlotte, NC0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61972TPACarolyn Long1941-01-20——2878 Market St, Austin, TX, 787420.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-108504ENRRyan Laura1993-01-22UHC-44301-7435074820259430 Sunset Blvd, Charlotte, NC0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-120091ENRBobby Torres1945-05-09UHC-38502-0186560507886470 Lake View Rd, Glendale, AZ, 853570.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108636ENRBrenda Riley1954-12-20UHC-37821-1695622030552264 Park Pl Apt 19, Scottsdale, AZ, 852750.50Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+3 more
ENR-112923ENRKimberly H Hernandez—UHC-45537-9172880668341697 Desert Sky Blvd Apt 3, Chandler, AZ, 852540.50Date of birth reformattedDate of birth unreadablePhone reformattedUnit split from street+3 more
ENR-142960ENRWilliam Thomas1966-01-16UHC-30395-0455359493506199 Cedar Ln, Seattle, WA, 981730.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430907CLMEugne Edwards1968-07-25——6041 Ridge Rd, Mesa, AZ, 852180.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-410745CLMVega P Joan1975-02-05—74599712912744 Market St, Glendale, AZ, 853310.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412861CLMMarc Burke2008-04-17UHC-79080-92—4628 River Rd Apt 26, San Antonio, TX, 782780.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-22172PRVDorothy Medina1967-10-19UHC-55197-7394073349861837 Pine Dr, Houston, TX, 770410.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-133557ENRChritian BJunk2007-07-24UHC-28089-14—9378 Willow Ct, Scottsdale, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-59494TPAFrank Carpenter1999-02-27——1999 Cedar Ln, Austin, TX, 787370.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23075PRVRalph S Fields1980-02-01—53387151287885 Washington St, Columbus, OH, 432250.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108830ENRKimberly Z Salazar1971-04-19UHC-10291-1665671889692158 Palm Dr, Sacramento, CA, 958540.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118529ENRGary G Greene1983-08-06UHC-86614-4687064243294571 Jefferson Ave, Atlanta, GA, 303640.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-119876ENRRobert Z Dominguez—UHC-72381-8840663491983310 Willow Ct, Los Angeles, CA0.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
CLM-412466CLMAlexis Watkins1946-10-08UHC-25813-0162346315353596 Elm St, Orlando, FL, 328610.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112547ENRBecky P Ferguson1939-04-11UHC-58326-172436302509429 Harbor Blvd # 785, Tampa, FL, 336580.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-405638CLMBrandon Snyder—UHC-55662-93—8063 Pine Dr, Nashville, TN, 372480.50Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-111348ENRJulie Hall2008-02-10UHC-86527-9052120956106710 Mesa Dr, San Antonio, TX, 782490.50Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-114399ENRSandra Peterson1970-06-24UHC-01975-4263120632299822 Washington St, Los Angeles, CA0.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-400495CLMJudith Gonzales1995-04-21UHC-65932-60—144 Canyon Rd, Seattle, WA, 981950.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-400496CLMJudith Gonzales1995-04-21UHC-65932-60—144 Canyon Rd, Seattle, WA, 981950.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-22632PRVCarol U James1996-11-22——5225 Union St, Tucson, AZ, 857230.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-110363ENRChristian I Gonzales—UHC-04668-8053964479712643 Maple Ave, Orlando, FL, 328790.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-419924CLMWayne Davis1956-05-25UHC-67278-9624484152144681 Oak St, Eden Prairie, MN, 553090.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
100,000 rows, page 122 of 2,000PreviousNext