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-402779CLMJacob Myers1991-07-11UHC-18643-777902923811—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-120635ENRKimberly Harvey1986-05-25UHC-10955-5855935190592965 Washington St, Nashville, TN, 372990.80Name split from “Last, First”Phone reformattedMember ID reformattedWhitespace trimmed
PRV-20941PRVPeter K Adams2003-05-10—3706468573—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21340PRVHannah Wood1982-10-02UHC-77455-70—8882 Harbor Blvd, Houston, TX, 770050.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60756TPAJacob N Gonzales2003-01-01———0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-60757TPAJacob N Gonzales2003-01-01———0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-20236PRVChristina Peters1943-10-27UHC-28826-823535380503—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-129867ENRElijah Young1952-11-26UHC-77203-39—6380 Lake View Rd, Tampa, FL, 336810.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
CLM-420347CLMMateo Vega1939-06-18—8334717898—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-407632CLMGregory Wanger1987-12-28UHC-51627-2294183834236925 Broadway, Miami, FL, 331050.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-407631CLMGregory Wanger1987-12-28UHC-51627-2294183834236925 Broadway, Miami, FL, 331050.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-115581ENRHenry Yang1987-12-03UHC-64402-8971176058274104 Highland Ave, Dallas, TX, 752980.80Name split from “Last, First”Phone reformattedEmail lower-casedPlan code upper-cased
CLM-405690CLMRuth Hanson1985-06-06—8265345553—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52105TPALauren James1965-04-05—38975902179798 Main St, Tucson, AZ, 857320.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-407207CLMShirley Cruz1978-10-23UHC-86255-7884572800687175 Ridge Rd, Glendale, AZ, 853550.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-119127ENRMei Lynch1959-12-25UHC-40531-3524996711021834 Washington St, Plano, TX, 750910.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-427650CLMEric Wheeler1997-06-10—2015855404—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63697TPASofia S Web1960-12-02——265 Ridge Rd, Tampa, FL, 336450.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-63819TPATeresa Munoz1949-05-17UHC-73954-80—4514 Broadway, Orlando, FL, 328680.80Name split from “Last, First”Member ID reformattedAddress re-casedPlaceholder values cleared
ENR-113142ENRVirginia F Hayes1980-02-12UHC-99818-0764880561392603 Jefferson Ave, Los Angeles, CA, 900820.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-409308CLMWayne V Arnold1964-08-20—7845295243—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-419265CLMGabriel Dixon2007-08-13UHC-81103-725752213244—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28596PRVBobby Wilson1994-01-12—2094822436—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-21849PRVMason Wagner1962-08-16—91431820551593 Church St, San Antonio, TX, 782150.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-51533TPAJoseph Wang1976-04-25———0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
CLM-410457CLMJack Black1940-05-11UHC-42214-282616860193—0.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
CLM-400291CLMBrian Ryan1973-08-28—3054801558—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-406205CLMNicole Snyder1950-01-09UHC-92703-71——0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-23404PRVZachary Simpson1964-12-08—76487699805711 Church St, Miami, FL, 331830.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
CLM-402283CLMSteven Ruiz1971-06-18UHC-69104-20——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-26006PRVArjun Stone1987-03-17—6575655180—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-129187ENRPaul D Freeman1979-12-01UHC-28021-3864791830602670 Sage Ct, Charlotte, NC, 282380.80Name split from “Last, First”Phone reformattedEmail lower-casedWhitespace trimmed
TPA-60255TPAJanet Dixon2007-10-04——2945 Lincoln Way, Houston, TX, 770780.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-100274ENREdward Nelson1939-06-15UHC-34778-1166729961785196 Union St, Denver, CO, 802330.80Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted
CLM-405819CLMJustin T Hawkins1943-07-02—35949925702459 Sunset Blvd, Tucson, AZ, 857700.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-103903ENRBruce J Henderson1958-05-06UHC-02311-1662332354153113 Camelback Rd, Glendale, AZ, 853180.80Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted
TPA-58019TPAHarold K Mejia1969-10-17—51633202942037 Desert Sky Blvd, Las Vegas, NV, 891090.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-412682CLMLuis Lee1965-04-28—2645827180—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59458TPAMegan Berry1943-10-26—70576943096422 Highland Ave, Sacramento, CA, 958880.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-405791CLMPamela Chen1955-10-09UHC-59611-1276573567422159 Maple Ave, Tucson, AZ, 857490.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-414330CLMBobby Evans1976-07-03UHC-75183-23—6622 Maple Ave, Sacramento, CA, 958760.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-423849CLMOmar Nunez1982-10-16UHC-16297-37—518 Baseline Rd, Mesa, AZ, 852270.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50752TPASamantha N Hughes2003-06-15—60999897923646 Meadow Ln, Gilbert, AZ, 852930.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-409399CLMStephen M Fowler2001-09-27UHC-96013-136007978481—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58394TPAAmber Fernandez1970-08-14——3495 Hillcrest Rd, San Diego, CA, 921290.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-104423ENRKate Marshall1943-08-16UHC-61716-6557198860696981 Grand Ave, Fresno, CA, 937350.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-432370CLMBrandon Martin2003-01-17UHC-01660-568787811703—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59436TPARonald Guerrero1953-09-22UHC-63884-9681499493208347 Market St, Scottsdale, AZ, 852620.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-429613CLMMason Carlson1946-09-16——9434 Willow Ct, Orlando, FL, 328060.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
ENR-131419ENRMatthew Matthews1942-05-02UHC-91869-1352921112505623 Lincoln Way, Plano, TX, 750190.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
9,980 rows, page 167 of 200PreviousNext