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-114923ENRRoy Q Rojas1987-12-17UHC-27701-82—5072 Hillcrest Rd, Seattle, WA, 981190.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-59140TPANathan Salazar1956-08-11———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-102098ENRCynthia Ryan1992-07-22UHC-40295-5651222497704288 Union St, Minneapolis, MN, 554570.80Name split from “Last, First”Phone reformattedPlan code upper-casedWhitespace trimmed
TPA-62050TPALogan R Vargas1965-06-07—8119287403—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-406780CLMDonna V Russell1996-11-19—3658973097—0.80Name split from “Last, First”Phone reformattedEmail lower-casedPlaceholder values cleared
TPA-52325TPAKathryn Watson2004-11-20—62875122463234 Palm Dr, Charlotte, NC, 282110.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-140058ENRJanet S Garrett1995-11-27UHC-41886-2143669049956771 Broadway, Miami, FL, 331540.80Name split from “Last, First”Phone reformattedAddress re-casedWhitespace trimmed
CLM-402137CLMJustin Carr1939-05-17UHC-98318-07——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57143TPAGreg Valdez1940-07-20——5929 Oak St, Charlotte, NC, 282110.80Name split from “Last, First”Date of birth reformattedCity re-casedPlaceholder values cleared
CLM-400190CLMJean A Torres1997-05-05—81178657802059 Camelback Rd, Houston, TX, 770250.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-27731PRVPatrick D Lewis1939-02-28UHC-79870-1033998182139157 Camelback Rd, Dallas, TX, 752860.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-119732ENRMegan Banks1963-10-03UHC-43841-4535427534847623 Ocean Ave, Dallas, TX, 752860.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlan code upper-cased
CLM-413965CLMDavid Nguyen1945-01-25UHC-96172-78—7133 Camelback Rd, Austin, TX, 787400.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-121940ENRCamila Romero1941-04-20UHC-45685-1439680477086264 Forest Ave, Tampa, FL, 336740.80Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed
CLM-428523CLMJoshua Morris1997-07-01UHC-52115-69—5767 Sunset Blvd, Houston, TX, 770500.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-427067CLMSan A Gordon1948-09-19—62695403929787 Canyon Rd, Mesa, AZ, 852720.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62015TPACarol Murrray1967-04-06—8755683662—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-126823ENRTyler F Nelson2004-09-03UHC-31251-5166671918001786 Central Ave, Orlando, FL, 328030.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
ENR-137507ENRLaura Z Jacubs1985-03-21UHC-87411-8279192262552503 Lincoln Way, Atlanta, GA, 303840.80Name split from “Last, First”Date of birth reformattedCity re-casedWhitespace trimmed
CLM-420949CLMHenry Fernandez1963-09-11UHC-34820-26——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54230TPAJeremy Kim1942-09-06———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-415104CLMRalph Oliver1995-03-26—9882029621—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57777TPASam Watson1993-05-12—93057783317942 Pine Dr, San Antonio, TX, 782600.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-426926CLMChristina Washington1966-11-22UHC-41326-428389215536317 Broadway, Seattle, WA, 981870.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-28860PRVMariana Mitchell1972-03-12UHC-47406-207717381941762 Sage Ct, Tempe, AZ, 852030.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-418707CLMMichelle J Carpenter2004-12-26UHC-19794-404466247822—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-405451CLMJacob U McDonald1938-03-26—7167501791—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-422734CLMHeather Hart1960-06-27UHC-02743-926385063717—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22097PRVChristian Yang1945-08-01—9002477102—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-21381PRVKatherine Knight2001-03-26—89150777077895 Willow Ct, Plano, TX, 750490.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-132098ENRNatalie Harper1974-06-13UHC-41642-3955896015794968 Camelback Rd, Atlanta, GA, 303070.80Name split from “Last, First”Date of birth reformattedEmail lower-casedWhitespace trimmed
CLM-407210CLMChris Webb1988-01-17UHC-62698-47——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-404090CLMRussell F Holmes1943-10-14UHC-47288-776575017298—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-123739ENRJoseph Hunt1983-12-06UHC-70128-7581221476234149 Central Ave, Austin, TX, 787100.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-25154PRVJessica Fernandez1951-04-07——3338 Highland Ave, Austin, TX, 787890.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
CLM-431240CLMMariana Cook1996-12-14—72594506777666 Sunset Blvd, Atlanta, GA, 303390.80Name split from “Last, First”Phone reformattedState code upper-casedWhitespace trimmed
PRV-21972PRVChristian Santiago1987-03-15—39477032483993 Jefferson Ave, San Antonio, TX, 782020.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62803TPARussell Lee1969-11-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61039TPAJoe Cox1997-10-04——9489 Mountain View Dr, Plano, TX, 750390.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-118379ENRChristine Bryant1964-01-02UHC-13671-7831391130308446 Union St, Jacksonville, FL, 322340.80Name split from “Last, First”Phone reformattedMember ID reformattedState code upper-cased
CLM-402723CLMGerald Jones1951-11-21——5976 Harbor Blvd, Atlanta, GA, 303370.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
CLM-430064CLMKyle G Meyer1976-10-28UHC-64032-367879715728—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-122690ENRGregory Dixon1989-11-13UHC-47337-39—4750 Highland Ave, Glendale, AZ, 853140.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-57208TPAKimberly Ramirez1961-09-17——8356 Park Pl, Dallas, TX, 752630.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59686TPAAlexander E Snyder1992-07-21——9767 Union St, Atlanta, GA, 303130.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-420038CLMEvelyn Delgado1961-10-05UHC-46372-43—495 Church St, Plano, TX, 750740.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51646TPAHeather Walsh1942-10-11———0.80Name split from “Last, First”Date of birth reformattedEmail lower-casedWhitespace trimmed
ENR-117940ENRWillie E Owens2008-09-07UHC-56415-4461267907254477 Central Ave, Columbus, OH, 432440.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
ENR-115263ENRLawrece E Mejia1964-12-23UHC-44229-8396033195488170 Church St, Tucson, AZ, 857270.80Name split from “Last, First”Phone reformattedMember ID reformattedWhitespace trimmed
CLM-416212CLMTim Freemman1992-07-09UHC-34025-6093169663895657 Market St, Seattle, WA, 981030.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
9,980 rows, page 173 of 200PreviousNext