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
CLM-432004CLMKevin Mitchell1962-07-27UHC-59458-43—661 Valley View Dr, Dallas, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-126932ENRKathleen B Rice—UHC-07246-9461751071219857 Main St, Tampa, FL, 336530.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-432772CLMDan Webb—UHC-96158-05—7729 Union St, Atlanta, GA, 303090.52Date of birth unreadableSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-130655ENRMegan Q Snyder1964-08-06UHC-93058-5473746861796921 Camelback Rd, Sacramento, CA, 958970.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406564CLMAnthuny U Rios1984-09-02UHC-38512-88—5354 Camelback Rd, Gilbert, AZ, 852460.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-63948TPANatalie Ryan2004-06-05——9790 Washington St # 404, Minneapolis, MN0.52Name re-casedUnit split from streetZIP missingGender normalised+2 more
CLM-400312CLMJames Romero1992-08-19UHC-88315-3981564994812891 Sunset Blvd, Dallas, TX0.52Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
ENR-111654ENRBJunk2000-07-15UHC-49072-2453545991226548 Bayshore Dr, Mesa, AZ, 852450.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416624CLMDennis Vargas1944-05-16—72259914755789 Elm St # 203, Gilbert, AZ, 852970.52Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
ENR-119657ENRSteve C Nichols1945-05-04UHC-56677-0595525396073615 Sunset Blvd, Los Angeles, CA, 900380.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-426593CLMAmanda Patterson1977-02-24UHC-12161-92—5482 Desert Sky Blvd # 778, Chandler, AZ, 852340.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61511TPAKayla Brooks———9810 Forest Ave, Miami, FL, 331050.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-111039ENRMason A Maldonado1982-10-08UHC-54625-23—1570 Union St # 121, Tampa, FL, 336040.52Two-digit birth yearMember ID reformattedUnit split from streetGender normalised+2 more
ENR-121888ENRMaatthew X Cruz1944-06-17UHC-91463-54—7979 Pine Dr # 573, Eden Prairie, MN, 553740.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-110607ENRMark Cunningham1985-07-21UHC-57907-0562244968325277 Park Pl, Scottsdale, AZ, 852250.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-430513CLMLauren H Rice——47723888347069 Sage Ct, Los Angeles, CA, 900950.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404580CLMMelissa Dominguez1941-01-16——6079 Canyon Rd, Columbus, OH0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
ENR-118161ENRJacob T Olson1974-05-07UHC-08496-9475938627781616 Lake View Rd, Las Vegas, NV, 891310.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-130018ENRSantiago Gibson2000-04-19UHC-15032-4947960513139582 Willow Ct # 618, Houston, TX, 770500.52Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-416825CLMCynthia Mason——36177133808767 Central Ave Apt 38, Fresno, CA, 937660.52Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-409960CLMKyle Taylor2006-05-28UHC-63974-9570395137588390 Market St, Tampa, FL0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417586CLMHannah Luna1980-07-17UHC-65080-5496424096714685 Grand Ave, Tampa, FL0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-61309TPAAhmed Li——8079369613—0.52Name split from “Last, First”Date of birth unreadablePhone reformattedGender normalised+2 more
ENR-117203ENRKelly L Guerrero—UHC-67014-513754796593285 Cedar Ln, Tempe, AZ, 852060.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-26220PRVOmar T Davis1980-11-19—78836651742400 Mountain View Dr, Nashville, TN, 372410.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-21165PRVEmily Valdez1942-11-17——2291 Ridge Rd, Orlando, FL, 328550.52Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-109613ENRMichael J Bishop1994-10-07UHC-91419-8282866724158711 Apache Blvd # 216, Los Angeles, CA, 900580.52Name re-casedPhone reformattedSSN last four extractedUnit split from street+2 more
ENR-102907ENRVincent Delgado1985-10-16UHC-73386-2876579159698194 Mountain View Dr # 824, Orlando, FL, 328880.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-142878ENRHiroshi I Butler1966-04-03UHC-41564-7334871747484742 Oak St, Denver, CO, 802310.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-415802CLMBrian Daniels1991-04-27——1346 Grand Ave, Mesa, AZ, 852530.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-115103ENRMaggie Cruz2001-01-09UHC-61807-71—9104 Jefferson Ave, Glendale, AZ, 853530.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-115102ENRMaggie Cruz2001-01-09UHC-61807-71—9104 Jefferson Ave, Glendale, AZ, 853530.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-22328PRVBrittany Q Graham1987-01-04UHC-81173-0953760236133057 Sunset Blvd, Tampa, FL0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-409392CLMAbigail K Holmes1994-03-16UHC-14169-2740835969516461 Main St, Denver, CO, 802000.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403550CLMCarolyn O Jackson2002-11-02UHC-39760-46—2843 Mesa Dr, Atlanta, GA, 303050.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-424362CLMPamela Hayes1967-07-20——3336 Valley View Dr, Atlanta, GA, 303250.52Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-102983ENREmily A George1964-04-20UHC-80583-2222861350845984 Sunset Blvd, Plano, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-132999ENRBrittany P Morales2003-09-13UHC-09344-34—1731 Park Pl, Chandler, AZ, 852330.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-118961ENRDoris Aguilar1945-12-08UHC-72012-8881566003527409 Mesa Dr, Jacksonville, FL, 322630.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-58524TPAMarcus Boyd1980-03-05—88523314518120 Central Ave Apt 2, Las Vegas, NV, 891440.52Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
PRV-26601PRVJudith Mittchell—UHC-88504-2783496331626212 Meadow Ln, Tucson, AZ0.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-428688CLMIsabella Wang———600 Church St, Minneapolis, MN, 554330.52Name split from “Last, First”Date of birth unreadableZIP+4 trimmedPlan code upper-cased+2 more
ENR-139256ENRNathan I Stephens1963-05-09UHC-96209-0365943559694241 Mesa Dr, Minneapolis, MN0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-142229ENRKenneth E Gilbert1969-06-12UHC-30518-9587775700943202 Canyon Rd, Glendale, AZ, 853670.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-138120ENROmar Q Reed1962-02-17UHC-46285-34—8059 Indian School Rd, Miami, FL, 331360.52Date of birth reformattedPhone missing area codeCity re-casedZIP+4 trimmed+2 more
ENR-113943ENRLinda Martinez1953-09-17UHC-63238-7333396149646116 Pine Dr Apt 30, Seattle, WA0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418581CLMSamuel Santiago1960-07-21UHC-56570-42—2697 Cedar Ln, Las Vegas, NV, 891860.52Name re-casedMember ID reformattedSSN last four extractedState name converted to code+2 more
CLM-431666CLMRoger Luna1960-10-11——2436 Indian School Rd, Miami, FL, 331480.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56478TPASteven George—UHC-39607-73—3251 Desert Sky Blvd, Charlotte, NC0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-134776ENRJeremy F Contreras1948-03-15UHC-79282-0225056504865889 Ocean Ave, Jacksonville, FL, 322010.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 177 of 2,000PreviousNext