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-114586ENRKing Sofia1959-10-18UHC-08034-3045460295071813 Valley View Dr Apt 31, Scottsdale, AZ, 852480.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-117606ENREmily X Willis2001-01-12UHC-12444-5825645376721859 Market St, Miami, FL, 331680.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-57998TPAHayes B Gloria2006-11-05UHC-74017-49—9821 Spring St, Fresno, CA, 937700.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
ENR-101409ENROlivia I Carrr1950-07-25—67784417303834 Forest Ave Apt 20, Jacksonville, FL, 322220.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-420482CLMDorothy Hall—UHC-15763-54—6357 Highland Ave, Las Vegas, NV, 891310.52Date of birth unreadableSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-429160CLMJason Z Thompson1994-08-22—59130302331783 Indian School Rd, Nashville, TN, 372410.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-100846ENRJustin Robertson2005-01-13UHC-36053-5055747068011356 River Rd, San Antonio, TX, 782380.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423213CLMAndrea Stewart1963-09-05——9243 Pine Dr # 435, Chandler, AZ, 852020.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-102972ENRSean K Jenkins1946-04-18—97965439502326 Desert Sky Blvd, Chandler, AZ, 852630.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-424245CLMGabriel Freeman1997-01-10——8222 Park Pl, Las Vegas, NV, 891590.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-400052CLMDiane Lee1970-01-11UHC-83472-9183877247254401 Sunset Blvd, Scottsdale, AZ, 852000.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63010TPAAustin Rogers1986-07-06——7743 Sage Ct, San Antonio, TX, 782730.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-118078ENRJoshua O Lawson1965-11-09—53048864487160 Apache Blvd, Denver, CO0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+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-122321ENRSara C Burton—UHC-23295-3049261451779018 Bayshore Dr, Gilbert, AZ, 852850.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-427464CLMJacqueline Bennett—UHC-63718-39—5967 Washington St, Tempe, AZ, 852710.52Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-120562ENRAnna C Fox1995-06-05UHC-77555-1849383021038586 Central Ave, San Diego, CA0.52Middle initial moved out of first namePhone reformattedCity re-casedZIP missing+2 more
ENR-108626ENRKevin Boyd2007-02-20UHC-41277-6842292424779379 Ridge Rd Apt 30, Columbus, OH0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-102311ENRKenneth Marshall—UHC-85421-0766453962747655 Camelback Rd # 370, Las Vegas, NV, 891900.52Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-61873TPAKatherrine Estrada1969-09-09—51770476283002 Elm St, Dallas, TX, 752620.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
PRV-22440PRVGloria Webb1941-12-28UHC-39563-01—7915 Mountain View Dr, Austin, TX, 787570.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-133719ENRJazon H Ruuiz2000-12-27UHC-96989-7858138238915935 Jefferson Ave, Chandler, AZ, 852510.52Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400574CLMKyle Williams—UHC-29313-6781398072614352 Indian School Rd, Tampa, FL, 336820.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-105083ENRDorothy T Clakr1989-03-13UHC-97273-05—9671 Sunset Blvd, San Antonio, TX0.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-109712ENRAmber Z Moreno—UHC-42609-2546347849217167 Elm St, Chandler, AZ, 852400.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50139TPAPriya Alexander1983-03-13——1179 Canyon Rd, Tempe, AZ, 852920.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-136287ENRBradley E Lawrence1991-06-06UHC-86126-6582353236454747 Desert Sky Blvd, Jacksonville, FL0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137572ENRChristopher Young1993-07-09UHC-27607-79—1866 Church St, Chandler, AZ, 852690.52Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-101416ENRMartha C Murphy1950-02-01UHC-96988-5761877603698376 Camelback Rd, Scottsdale, AZ, 852320.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-138672ENRNicholas V Wood2001-03-23UHC-57484-4944956109913622 Oak St, Tampa, FL, 336750.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-140720ENRJose H Sims1986-01-20UHC-00961-2368224785183700 Park Pl, Las Vegas, NV, 891010.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-138527ENRDeborah Y Waard1989-10-07UHC-37082-416374497703817 Willow Ct, Minneapolis, MN, 554470.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-133431ENRKelly Wallace2001-09-05UHC-98623-51—9436 Oak St, Scottsdale, AZ, 852870.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-61253TPAJoe Bradley2005-11-16——5348 Apache Blvd Apt 39, Denver, CO0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-23606PRVKyle Hall1971-12-28UHC-40356-4549871648663425 River Rd, Eden Prairie, MN, 553960.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-431573CLMCatherine Wright———4260 Lake View Rd, Jacksonville, FL, 322560.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-114249ENRMegan P Carpenter1946-06-01UHC-78670-6350257052843675 Willow Ct, Nashville, TN, 372310.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-100549ENRJoshua Willis1945-04-07UHC-25334-7943376392596663 Oak St Apt 14, Sacramento, CA, 958350.52Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+2 more
TPA-62226TPARussell Young1950-05-14——6989 Mountain View Dr, Tempe, AZ, 852720.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127021ENRCarolyn Z Porter1995-04-15UHC-44477-87—5268 Church St, Seattle, WA, 981880.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
TPA-59506TPAArjun G Morris1999-02-21——3815 Cedar Ln, Scottsdale, AZ, 852900.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-140830ENRElizzabeth V Lucas2008-07-01UHC-40561-1380982350848572 Sage Ct Apt 37, Plano, TX0.52Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
TPA-55600TPAZachary Gonzalez1994-03-17—93780451436204 Hillcrest Rd, Las Vegas, NV0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-405833CLMSara Carr1982-05-24UHC-76869-45—3915 Washington St, Nashville, TN, 372930.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-409656CLMDylan Berry—UHC-73876-98—7702 Harbor Blvd, Plano, TX, 750590.52Date of birth unreadableMember ID reformattedState name converted to codeZIP+4 trimmed+2 more
PRV-23064PRVPaul A Crawford2000-04-03UHC-85132-11—5404 Highland Ave, Columbus, OH, 432980.52Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-413190CLMFrank Salazar———7978 Desert Sky Blvd, Tucson, AZ, 857180.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-413191CLMFrank Salazar———7978 Desert Sky Blvd, Tucson, AZ, 857180.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-111851ENRJuan Carroll1960-11-20UHC-88791-7821643618006460 Church St # 925, San Antonio, TX0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 167 of 2,000PreviousNext