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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-432276CLMVirginia Armstrong1961-07-18UHC-99958-978458388168—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-134775ENRGilbert Abigail2007-07-19UHC-90522-1948925724061028 Grand Ave, Nashville, TN, 372140.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-117841ENRJanet Dunn1969-05-20—7038497022—0.80Name split from “Last, First”Date of birth reformattedEmail lower-casedWhitespace trimmed
PRV-23477PRVRebecca Greene2006-05-05UHC-66153-41—3070 Palm Dr, Tampa, FL, 336940.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-23476PRVRebecca Greene2006-05-05UHC-66153-41—3070 Palm Dr, Tampa, FL, 336940.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
ENR-127845ENRSharon X Reynolds1981-02-01UHC-55069-695148055266653 Ocean Ave, San Diego, CA, 921670.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
TPA-61731TPAMatthew Spencer2002-08-26—5719070427—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-127641ENRJessica U Carter1977-08-02UHC-74848-2689541344792230 Hillcrest Rd, Phoenix, AZ, 850440.80Name split from “Last, First”Phone reformattedEmail lower-casedWhitespace trimmed
CLM-421636CLMWillie Wang1997-12-05—7644344853—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-406449CLMBrian E Flores2001-06-10UHC-95145-33—438 Baseline Rd, Tucson, AZ, 857410.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50173TPARalph Elliott1993-06-26UHC-06749-672268174021—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-418573CLMKelly G Bishop1958-01-12UHC-23217-249615919930—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-61770TPANancy Richards1948-06-12UHC-93715-498129566702—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-403062CLMJulie Cox2008-04-06—4565150171—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-415752CLMDennis Watkins1994-06-21UHC-26047-788268386135—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-110732ENRRichard Silva2005-06-25UHC-51819-3024435068334024 Lake View Rd, Gilbert, AZ, 852060.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-411471CLMAlice Simpson2004-09-19UHC-94887-7825872468382454 Spring St, Sacramento, CA, 958250.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-424560CLMBruce Burke1979-08-05UHC-27034-47——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-108558ENRGreg Myers1963-03-11UHC-56955-7441651686135794 Lincoln Way, Fresno, CA, 937770.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-405845CLMJessica Rogers1941-09-24UHC-93976-9946568743563358 Central Ave, San Diego, CA, 921980.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27025PRVAmanda Rogers1938-02-02UHC-77469-1391777480466473 Spring St, Glendale, AZ, 853310.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-415460CLMMadison Padilla1968-11-07UHC-93662-76—6184 Ridge Rd, Miami, FL, 331780.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-100706ENRIsabella Harrison1987-09-12UHC-74842-6093334127191414 Apache Blvd, Glendale, AZ, 853630.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
TPA-63459TPADiane Le1952-09-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-112590ENRDorothy Burke1976-08-12UHC-46982-0888550660673149 Harbor Blvd, Denver, CO, 802260.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
TPA-63018TPAJack Hoffman1949-11-27—7876653289—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-417196CLMAmber Harvey1998-10-18UHC-45573-36—6154 Main St, Dallas, TX, 752750.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
ENR-122505ENRJeremy Perkins1984-03-05UHC-28780-8043551371652499 Forest Ave, Tucson, AZ, 857890.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
CLM-410721CLMJose Munoz1982-11-23——4377 Jefferson Ave, Atlanta, GA, 303370.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-26240PRVSofia Thompson1987-07-21—64393130664099 Willow Ct, Charlotte, NC, 282680.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-103050ENRAustin M Yang1983-07-18UHC-35695-4486158220649563 River Rd, Los Angeles, CA, 900990.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-112024ENRJuan Mason1991-06-04UHC-64375-113786491061415 Ocean Ave, Eden Prairie, MN, 553520.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
CLM-424530CLMCynthia Washington1945-04-24UHC-73781-5535835233896260 Harbor Blvd, Tucson, AZ, 857220.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-29438PRVJerry Y Watson1983-04-17—68338210247251 Grand Ave, Sacramento, CA, 958400.80Name split from “Last, First”Date of birth reformattedState code upper-casedPlaceholder values cleared
ENR-123605ENRSophia Benntt1958-07-01UHC-88981-1039430741604092 Ridge Rd, Houston, TX, 770810.80Name split from “Last, First”Phone reformattedEmail lower-casedWhitespace trimmed
ENR-130489ENRPhilip B Perkins1972-12-22UHC-55250-1748035222333449 Palm Dr, Seattle, WA, 981920.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
CLM-400578CLMBobby S Luna1977-04-22UHC-10718-284222340620—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-419887CLMBrian Walsh1969-11-11——83 Lincoln Way, Houston, TX, 770960.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61015TPARalph Wright1942-07-13—46348176009787 River Rd, Phoenix, AZ, 850640.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
ENR-105810ENRDiaz O Billy1946-11-23—68840574646602 Grand Ave, San Antonio, TX, 782370.80Name split from “Last, First”Phone reformattedState code upper-casedWhitespace trimmed
TPA-58114TPAAaron Jones1992-10-01—5204402227—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-406544CLMMke Jurdan2000-11-24UHC-94325-832125125878—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-133057ENRNicholas E Ptaterson1966-10-09UHC-92913-3642099043628555 Valley View Dr, Nashville, TN, 372960.80Name split from “Last, First”Date of birth reformattedMember ID reformattedWhitespace trimmed
CLM-413305CLMLisa Hicks1984-01-14UHC-45936-13——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-403971CLMKenneth Z Tucker1947-04-12—2384297613—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-127519ENRTimothy H Vasquez1946-08-16UHC-40176-5089722714014462 Baseline Rd, San Antonio, TX, 782000.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
CLM-403912CLMAlbert Marshall1938-08-12UHC-66758-20—1431 Ocean Ave, San Diego, CA, 921300.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-413901CLMJustin A Johnson2003-07-03UHC-07622-056656228532—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58790TPAWayne Davis1956-05-25———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-427973CLMChristopher V Obrien1982-05-11——5265 Central Ave, Atlanta, GA, 303320.80Name split from “Last, First”Name re-casedWhitespace trimmedPlaceholder values cleared
9,980 rows, page 170 of 200PreviousNext