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
ENR-104395ENRDebra Green2003-11-26UHC-24356-58—4701 Washington St, Chandler, AZ, 852050.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-28556PRVCarlos A Webb1949-12-20UHC-82977-748783040123—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-119074ENRKyle Moore1969-02-16UHC-40857-3267231369116882 Camelback Rd, Minneapolis, MN, 554580.80Name split from “Last, First”Date of birth reformattedPhone reformattedEmail lower-cased
ENR-122764ENRLori P Baker1968-03-05UHC-81821-187122378569—0.80Name split from “Last, First”Phone reformattedEmail lower-casedPlaceholder values cleared
CLM-400019CLMAustin Z Henry2008-03-02UHC-53911-827104069848—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-414531CLMMaria Flores1998-02-23UHC-15319-5169062922957307 Oak St, Tempe, AZ, 852370.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-104920ENRSamuel Ramirez1986-05-28UHC-35438-685425687978895 Church St, Glendale, AZ, 853760.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-117123ENRPaul M Mejia1994-10-14UHC-10438-5439761078956670 Cedar Ln, Minneapolis, MN, 554730.80Name split from “Last, First”Phone reformattedState code upper-casedWhitespace trimmed
CLM-425731CLMMichlle Lynch1984-08-17UHC-87332-24—7870 Forest Ave, Houston, TX, 770480.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-410924CLMRonald Lawson1991-08-03UHC-93268-33——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-419341CLMRichard Boyd1957-09-01——7982 Central Ave, Glendale, AZ, 853370.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-415773CLMPamela P Lucas1941-05-22UHC-69961-095538783842—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-117450ENRLisa Hicks1984-01-14UHC-45936-13—8771 Apache Blvd, Seattle, WA, 981610.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-123859ENRJoyce Rios1977-04-28UHC-99569-5979886221514611 Oak St, Nashville, TN, 372720.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
CLM-407171CLMJose Fuller1988-04-27UHC-59366-38——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-122529ENRStephen M Martinez1989-02-03UHC-67802-9785235741476738 Indian School Rd, Tampa, FL, 336650.80Name split from “Last, First”Phone reformattedMember ID reformattedWhitespace trimmed
CLM-423927CLMEthan Wood1961-04-06UHC-73564-9138192289015108 Lincoln Way, Nashville, TN, 372580.80Name split from “Last, First”Phone reformattedMember ID reformattedPlaceholder values cleared
PRV-22910PRVGary Gutierrez2008-08-03—74157879535455 Bayshore Dr, Houston, TX, 770770.80Name split from “Last, First”Phone reformattedEmail lower-casedPlaceholder values cleared
ENR-126005ENRAndrew Martin1971-06-27UHC-32419-0521834779312187 River Rd, Plano, TX, 750030.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
ENR-118344ENRCamila Burton2003-01-14UHC-40210-7833340751426355 Mesa Dr, Seattle, WA, 981850.80Name split from “Last, First”City re-casedEmail lower-casedPlan code upper-cased
CLM-427960CLMCharlotte Wells1985-06-05UHC-61324-562758885833—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-107289ENRBradley Morrison1982-11-11UHC-89051-37—461 Central Ave, Tucson, AZ, 857130.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-415998CLMLarry I Mendoza1972-11-08UHC-94891-6759434357273521 Maple Ave, Charlotte, NC, 282030.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-418421CLMJoseph Vargas1967-03-08UHC-78519-237969068393—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-415896CLMVirginia W Bennett2007-07-09UHC-85901-18—3368 Lincoln Way, San Antonio, TX, 782460.80Name split from “Last, First”Date of birth reformattedMember ID reformattedPlaceholder values cleared
CLM-407337CLMElijah D Sandoval1995-08-03——4630 Market St, Miami, FL, 331450.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
ENR-127030ENRJuan P Thompson1991-10-12UHC-06717-957032197718161 Ridge Rd, Tampa, FL, 336400.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63274TPABenjamin Taylor1965-12-19—90283459918247 Lake View Rd, Gilbert, AZ, 852170.80Name split from “Last, First”Phone reformattedState code upper-casedPlaceholder values cleared
TPA-59730TPAAmy Davis1987-11-28—6658721312—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-430173CLMMegan Reyes1978-11-12UHC-34680-22——0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
ENR-127811ENRDon Kim1969-09-21—21336685294188 Hillcrest Rd, Gilbert, AZ, 852660.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-55726TPAKathleen Brooks1987-01-02—34433155948400 Broadway, Tempe, AZ, 852160.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
CLM-402290CLMAnna G Young1988-03-28—2089919527—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25322PRVKvein Cunningham1962-09-09—2608973093—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56055TPACatherine T Robertson1941-07-02——4634 Desert Sky Blvd, Fresno, CA, 937660.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-417508CLMHiroshi Meyer1988-10-03UHC-79807-84—3492 Willow Ct, Austin, TX, 787230.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-424693CLMJulia Dean1987-06-17UHC-21980-71——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51494TPARyan C Patel2008-04-15—5068686599—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-124495ENRMariana E Matthews1941-02-12UHC-24776-398857922664241 Jefferson Ave, Tempe, AZ, 852770.80Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed
PRV-20098PRVEric Sims1947-06-04UHC-69655-072535772240—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-408335CLMMateo Gonzalees1978-04-10UHC-83490-214712284517—0.80Name split from “Last, First”Phone reformattedMember ID reformattedPlaceholder values cleared
CLM-401015CLMStephen U Bradley1960-07-28UHC-51253-792119164469—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58084TPALogan Morgan1975-11-03——5987 Ocean Ave, Glendale, AZ, 853590.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
ENR-107211ENRDennis Marquez1994-05-12UHC-77582-7851530204163955 Spring St, Scottsdale, AZ, 852070.80Name split from “Last, First”Date of birth reformattedMember ID reformattedEmail lower-cased
CLM-424877CLMElizabeth Washington1959-09-22UHC-87962-7435197982167320 Maple Ave, Columbus, OH, 432390.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-139681ENRCarlos C Riivera1950-02-02UHC-03714-6951667202014640 Canyon Rd, Eden Prairie, MN, 553720.80Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed
CLM-410315CLMDonna Hoffman1998-08-07—4402656997—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-414083CLMJoseph Porter1960-06-27UHC-81468-8623755107736037 Sage Ct, Gilbert, AZ, 852380.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-413360CLMRonald Padilla2001-08-28—47098678416044 Broadway, Eden Prairie, MN, 553700.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-22869PRVTyler Bradley1984-12-11—55728471493905 Cedar Ln, Seattle, WA, 981780.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
9,980 rows, page 176 of 200PreviousNext