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-133769ENRDiego Snyder—UHC-57459-8239893418772917 Washington St, Seattle, WA, 981010.50Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-427006CLMJon Weber1998-03-17UHC-45344-39—4212 Maple Ave, Gilbert, AZ, 852390.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-415956CLMRyan Hill1966-09-13UHC-71857-4035939730072450 Ridge Rd, Tempe, AZ, 852860.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-105156ENRWillie Schmit1946-01-03UHC-97718-8375397946787642 Forest Ave, Seattle, WA, 981180.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
CLM-431250CLMBarbara Cox1962-01-13——1468 Hillcrest Rd, Columbus, OH0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-404520CLMKathryn A Perez1986-11-13UHC-05255-47—1011 Indian School Rd, Seattle, WA, 981170.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405175CLMCharles Jenkins—UHC-72962-24—7771 Forest Ave, Fresno, CA, 937820.50Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
ENR-120010ENRDennis G Carter1993-05-11UHC-04709-165205396307749 Mountain View Dr, Atlanta, GA, 303810.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-107311ENRGabriel P Salazar1943-02-04UHC-97571-1723781443434562 Union St, Gilbert, AZ0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-109977ENRChristina I Perez1944-11-01—94530536264757 Ridge Rd Apt 5, Glendale, AZ, 853310.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-131509ENROmar D Ferguson1950-11-04UHC-22742-2460271456747551 Harbor Blvd, Los Angeles, CA, 900220.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21983PRVJulia Webb1990-04-26—56532743135812 Oak St Apt 39, Fresno, CA, 937670.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-422584CLMJohn Hughes1947-09-08UHC-46207-33—1769 Mesa Dr, Tempe, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-24141PRVJanet W Wallace1939-11-19UHC-29568-5585887939712662 Elm St Apt 37, Glendale, AZ, 853950.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-134155ENRAdam R Vasquez1973-04-07UHC-36719-4794172967375966 Cedar Ln, Charlotte, NC, 282880.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-411209CLMEric Rios1966-11-03—35028393643440 Willow Ct, Atlanta, GA, 303820.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417414CLMAngela Martin2006-02-23——3353 Ridge Rd, Tucson, AZ, 857950.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407558CLMBobby Clark1949-08-03UHC-74673-9483248352969785 Indian School Rd, Seattle, WA0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-421888CLMSara K Kelley2008-09-20UHC-40791-6398690060891277 Willow Ct, Tucson, AZ, 857860.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-51578TPAMegan Little1998-09-25——2116 Washington St # 340, Dallas, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-432468CLMDonald Simpson1976-07-23—56438163262920 Central Ave, Denver, CO, 802530.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-432213CLMDennis Rojas1945-11-25UHC-65284-1374055362725077 Church St, Orlando, FL, 328970.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-411146CLMMaria Nichols1984-12-26UHC-63435-6593790062221856 Willow Ct Apt 35, Minneapolis, MN, 554640.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-415679CLMShirley Chavez1956-05-14—74262237822044 Mesa Dr # 600, Chandler, AZ0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-115846ENRDeborah Z Little1946-06-28—39589587732259 Jefferson Ave # 907, Charlotte, NC, 282250.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-113971ENREvelyn V Coleman—UHC-59991-6275539331085757 Main St, Tampa, FL, 336720.50Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+3 more
CLM-408910CLMBradnon G Jacobs1955-08-05UHC-10592-7285197385499500 Grand Ave # 352, Orlando, FL, 328250.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-428879CLMJonathan Parker1985-01-21UHC-64109-25—6409 Lake View Rd, Gilbert, AZ, 852330.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-20621PRVKayla Wong1966-10-13—61249291385312 Apache Blvd, Mesa, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-407040CLMDenny J Baker1967-07-16UHC-24430-47—4332 Jefferson Ave, Orlando, FL, 328820.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134290ENRJeremy K Martin1940-04-16—30540133112692 Canyon Rd, Los Angeles, CA, 900230.50Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+3 more
ENR-136959ENRSamuel Warren2003-06-02UHC-67401-51—4561 Pine Dr, Mesa, AZ, 852460.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-416248CLMFatima Garrett2003-04-16—62427580786743 Park Pl Apt 36, Chandler, AZ, 852190.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-140496ENROmar A Price1998-12-10UHC-59884-8433684215172765 Spring St, Scottsdale, AZ0.50Name re-casedPhone reformattedCity re-casedState name converted to code+3 more
CLM-412567CLMKathleen Lane2001-01-26UHC-31114-8049497250277643 Highland Ave, Miami, FL0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126930ENRKelly Burns1941-07-07UHC-13674-7725830465925638 Park Pl Apt 13, Chandler, AZ, 852860.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
PRV-28856PRVDonna P Torres1957-03-17UHC-62265-9268781026352673 Park Pl, Tempe, AZ0.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-58541TPAAmy Snyder1984-12-03—76398282459570 Sunset Blvd # 484, Miami, FL, 331430.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-127573ENRDaivd Powell2004-04-27UHC-50609-6292597410021225 Canyon Rd, Austin, TX0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-25904PRVChristopher Bishop1981-09-28—75632580329509 Forest Ave, Houston, TX, 770780.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-122200ENRCarol Hall2004-04-28UHC-68238-77—6376 Desert Sky Blvd, Phoenix, AZ, 850180.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58713TPAMei Moreno1945-09-16——4287 Mountain View Dr, Denver, CO, 802860.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-114594ENRCarl S Chhen1997-08-15UHC-16221-28—8246 Canyon Rd, Charlotte, NC, 282690.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403972CLMTyler Wagner1951-07-18——8381 Main St, Gilbert, AZ, 852700.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-55579TPALuis Lee1965-04-28——7876 Bayshore Dr, Phoenix, AZ, 850750.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121120ENRSean Allen—UHC-74463-6869728926739243 Union St, Seattle, WA, 981830.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
CLM-410468CLMSean Daniels1986-05-18——6525 Sunset Blvd, Los Angeles, CA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139678ENRRichard McDonald1966-04-08UHC-41907-9136040422541822 Central Ave, Orlando, FL, 328630.50Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-108415ENRTyler Dean2004-08-17UHC-36417-9656687124794144 Canyon Rd, Seattle, WA, 981770.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-427166CLMBrandon Martin1952-12-02——962 Harbor Blvd, Glendale, AZ, 853900.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
100,000 rows, page 91 of 2,000PreviousNext