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-424189CLMTeresa Murphy1967-10-09UHC-72939-6731822362184268 Broadway, Mesa, AZ, 852690.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-410000CLMPriya McDonald2007-08-25UHC-04817-13—5470 Market St, Tucson, AZ, 857080.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54171TPARussell Dean1981-07-23—7348393066—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-142820ENRRichard Simmosn1950-12-25UHC-60650-958603727016286 Central Ave, San Diego, CA, 921160.80Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted
CLM-428046CLMRoger R Arnold1998-06-21———0.80Name split from “Last, First”Plan code upper-casedWhitespace trimmedPlaceholder values cleared
CLM-403575CLMJames Gomez2000-10-26UHC-35346-4350352579995032 Broadway, Tempe, AZ, 852180.80Name split from “Last, First”Address re-casedWhitespace trimmedPlaceholder values cleared
CLM-409809CLMAlbert Williams1960-08-14—6602675424—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-404332CLMSharon Miller1960-03-24UHC-41797-448019652436—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-423464CLMAmber Willis1990-08-08UHC-07211-06——0.80Name split from “Last, First”Plan code upper-casedWhitespace trimmedPlaceholder values cleared
ENR-122423ENREric X Wong1985-04-05UHC-55149-7756151371136146 Meadow Ln, Orlando, FL, 328780.80Name split from “Last, First”Phone reformattedMember ID reformattedPlaceholder values cleared
PRV-26972PRVLucia Smith1983-10-17UHC-73102-4885066461257359 Washington St, Nashville, TN, 372070.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-119590ENRYuki Russell1992-02-03UHC-70987-625953467601365 Lincoln Way, Los Angeles, CA, 900040.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
CLM-403765CLMAlice Robinson1955-12-26UHC-97366-44—8625 Spring St, Eden Prairie, MN, 553650.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-137941ENRLawrence C Duncan1938-05-06UHC-36484-667224584491—0.80Name split from “Last, First”Phone reformattedMember ID reformattedWhitespace trimmed
ENR-113488ENRFrank Carter1947-02-18UHC-10287-51—8754 Meadow Ln, Tempe, AZ, 852770.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
ENR-105687ENRScott Q Murray1941-11-27UHC-89251-10—979 Broadway, Jacksonville, FL, 322970.80Name split from “Last, First”Date of birth reformattedMember ID reformattedPlaceholder values cleared
ENR-125084ENRGerald Y Lynch1951-07-10UHC-68982-2598241606714618 Main St, Sacramento, CA, 958850.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-107651ENRMary N Fields1988-03-05UHC-83147-5567235711529296 Oak St, Gilbert, AZ, 852480.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52947TPADouglas Schultz1954-10-05———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-25072PRVAlan Jensen1978-10-09—84961788012617 Oak St, Seattle, WA, 981710.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-29323PRVVictoria Singh1941-04-18UHC-82237-0848741656973955 Grand Ave, Chandler, AZ, 852550.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-423038CLMKelly Silva1965-06-28———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55367TPASean L Fuller1986-08-24——1395 Grand Ave, Chandler, AZ, 852010.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
CLM-430660CLMJudith C Schultz1988-10-24——1867 Pine Dr, Houston, TX, 770770.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-415848CLMCamila Marshall1956-12-09—3347020523—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-139547ENRRachel S Taylor2004-08-20UHC-30724-466516315887391 Broadway, Houston, TX, 770230.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
CLM-427643CLMGary Ross1970-06-13—80153407476125 Sunset Blvd, Columbus, OH, 432680.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53217TPAJason Fowler1940-08-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-112523ENRCynthiia N Luna1970-06-09UHC-76246-7085878756285505 Washington St, Atlanta, GA, 303010.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-404215CLMJanice Clark1988-06-25UHC-78491-2351899049772719 River Rd, Orlando, FL, 328170.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-119319ENRNoah Pena1956-04-21UHC-91234-2625386236079141 Oak St, Tempe, AZ, 852410.80Name split from “Last, First”Date of birth reformattedPhone reformattedEmail lower-cased
ENR-110535ENRJonathan G Watson1966-12-01UHC-80132-5149448935523535 Broadway, Houston, TX, 770720.80Name split from “Last, First”Phone reformattedAddress re-casedWhitespace trimmed
PRV-20208PRVAlice K Crawford1953-10-20UHC-75258-478197445112—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20670PRVGregory McCoy1942-05-15—51827909678994 Lake View Rd, Nashville, TN, 372930.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22502PRVMaria Wang1976-04-07UHC-01269-47—6033 Mesa Dr, Phoenix, AZ, 850040.80Name split from “Last, First”Member ID reformattedEmail lower-casedPlaceholder values cleared
ENR-127472ENRMarc Rojas1979-09-12UHC-13207-059517343345—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-416521CLMGrace V Fisher1971-03-01UHC-44389-913313736736—0.80Name split from “Last, First”Phone reformattedMember ID reformattedPlaceholder values cleared
CLM-415005CLMLaura Watkins1961-02-15—29472844132762 Willow Ct, Mesa, AZ, 852310.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-427559CLMWillie Valdez1988-02-17UHC-39473-3568488128975816 Washington St, Charlotte, NC, 282540.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52071TPAAnna I Mason1972-01-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58234TPAElizabeth Hansun1981-10-23——1726 Elm St, San Antonio, TX, 782470.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
ENR-139851ENRKayla Wilzon1999-12-01UHC-85786-6038954308874661 Mesa Dr, Nashville, TN, 372720.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
CLM-409148CLMZachary Nichos1973-09-11—63449420607771 Harbor Blvd, Atlanta, GA, 303780.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-408704CLMAmanda Larson1948-12-20—6463650878—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-406787CLMEdward Delgado1986-01-16UHC-98565-10——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-135186ENRMatthew A Warrne1958-10-03UHC-53986-45—6845 Lake View Rd, San Diego, CA, 921540.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
CLM-409709CLMDonna Coleman1942-10-15—62450652447430 Palm Dr, Sacramento, CA, 958480.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63115TPAChristine Snyder1993-04-25——5818 River Rd, Gilbert, AZ, 852990.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-431087CLMNatalie Thompson1999-02-26UHC-21601-34——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-420034CLMAbigail F Adams1940-04-10UHC-47242-41—9028 Spring St, Glendale, AZ, 853700.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
9,980 rows, page 164 of 200PreviousNext