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
PRV-28601PRVValentina Singh1955-11-26UHC-67875-96—4496 Union St, Dallas, TX, 752950.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-417913CLMAmy Fernandez2005-10-02——8451 Willow Ct, Austin, TX, 787870.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-423067CLMPhilyp Fox1993-12-25———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-131503ENRSantiago Mason2007-05-19UHC-55720-6295625148988400 Pine Dr, Nashville, TN, 372680.82Name split from “Last, First”Phone reformattedWhitespace trimmed
CLM-427215CLMAshley M Bowman1954-07-27—4277801336—0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-409132CLMStephen H Miller1998-05-04UHC-10946-99—8460 Baseline Rd, Jacksonville, FL, 322100.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-423024CLMKyle Smith1983-12-24UHC-64566-52——0.82Name split from “Last, First”Member ID reformattedPlaceholder values cleared
ENR-133344ENRAustin Myers1966-12-10UHC-06290-6070568559468458 Market St, Tucson, AZ, 857340.82Name split from “Last, First”Phone reformattedEmail lower-cased
CLM-423321CLMHarold Ramirez1943-04-28UHC-18546-96——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-50404TPABrandon Munoz1965-08-06—4199034858466 Desert Sky Blvd, Jacksonville, FL, 322530.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-409786CLMCheryl Welh1938-01-06UHC-07157-28——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-416055CLMBrenda Harper1940-05-15———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-129648ENRTimothy N Wheeler1939-02-03UHC-43507-1823627906873238 Jefferson Ave, San Antonio, TX, 782390.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-119247ENRTeresa G Hill1958-06-28UHC-97178-204022294079—0.82Name split from “Last, First”Date of birth reformattedPhone reformatted
CLM-408655CLMJames Ramirez2000-11-27UHC-84711-77——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-407089CLMVincent G Watkins2000-11-26UHC-63848-42——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-24166PRVFatia Pena1940-12-03——8502 Broadway, Orlando, FL, 328890.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-428951CLMLori Miller1942-02-11UHC-11050-439055430691—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-56416TPAIsabella Sanchez1952-07-26UHC-07904-9195752664633413 Valley View Dr, San Antonio, TX, 782840.82Name split from “Last, First”Phone reformattedMember ID reformatted
CLM-408154CLMElijah Allen1943-12-01UHC-15522-206168902010—0.82Name split from “Last, First”Phone reformattedWhitespace trimmed
TPA-51382TPAMaria B Davis1996-12-03——8013 Union St, Miami, FL, 331320.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-104348ENRSofia Vargas1954-02-16UHC-72868-4053421425082814 Central Ave, Tucson, AZ, 857060.82Name split from “Last, First”Date of birth reformattedPlan code upper-cased
ENR-137397ENRPaul Ross1983-09-13UHC-15295-38—3208 Lincoln Way, Plano, TX, 750290.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-403096CLMAnn Adams1964-03-09UHC-49487-89—4774 Broadway, Scottsdale, AZ, 852440.82Name split from “Last, First”Address re-casedPlaceholder values cleared
TPA-64059TPADaniel Wright1993-01-04——3838 Lincoln Way, Las Vegas, NV, 891670.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-406464CLMKathleen Moore1977-02-10—45556668964834 Forest Ave, Los Angeles, CA, 900380.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-406465CLMKathleen Moore1977-02-10—45556668964834 Forest Ave, Los Angeles, CA, 900380.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-422340CLMJack Dnun1944-06-26UHC-52947-29—5132 Oak St, Plano, TX, 750840.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-62664TPAAustin Allen1939-03-24———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-415149CLMMarcus Carr1942-10-28——2952 Jefferson Ave, Tampa, FL, 336180.82Name split from “Last, First”State code upper-casedPlaceholder values cleared
PRV-22103PRVMateo Kelly1947-07-10—4894443862—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-21824PRVHarold I Fisher1962-04-25—8633139086—0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
ENR-139496ENRRoger Carroll2003-09-20UHC-99287-9255079488428485 Meadow Ln, Minneapolis, MN, 554020.82Name split from “Last, First”Member ID reformattedPlaceholder values cleared
ENR-126213ENRYuki E Ross1982-03-01UHC-58641-4988968942102922 Park Pl, Las Vegas, NV, 891900.82Name split from “Last, First”Date of birth reformattedPhone reformatted
CLM-413625CLMEric Sullivan1963-09-08—4495005274—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-413624CLMEric Sullivan1963-09-08—4495005274—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-424038CLMAhmed C Cruz1986-04-22UHC-49614-51——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-133595ENRBryan I Ray1958-11-20UHC-15231-8589768525079671 Indian School Rd, Tucson, AZ, 857650.82Name split from “Last, First”Date of birth reformattedPhone reformatted
ENR-108363ENROmar Collins2001-09-13UHC-17620-3822922273249690 Hillcrest Rd, Atlanta, GA, 303410.82Name split from “Last, First”Member ID reformattedEmail lower-cased
ENR-126188ENRJessiac B Reid1980-05-01UHC-65268-2291977039265218 Washington St, Seattle, WA, 981670.82Name split from “Last, First”Phone reformattedWhitespace trimmed
CLM-420932CLMJessica Romero1959-11-02———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-129510ENRCamila Dominguez1960-10-25UHC-58481-2933297387079100 Grand Ave, Houston, TX, 770790.82Name split from “Last, First”Date of birth reformattedWhitespace trimmed
CLM-420226CLMElliott R Raymond1956-04-25———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
ENR-127737ENRStephen Vega1962-12-18UHC-77318-2041642060044621 Park Pl, Dallas, TX, 752930.82Name split from “Last, First”Date of birth reformattedWhitespace trimmed
CLM-422552CLMEthan Porter1969-01-18UHC-50566-98——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-422551CLMEthan Porter1969-01-18UHC-50566-98——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-420393CLMBrittany Nichols1984-08-18UHC-42580-56—4311 Sage Ct, Eden Prairie, MN, 553570.82Name split from “Last, First”City re-casedPlaceholder values cleared
PRV-26428PRVHiroshi X Flores1966-10-20UHC-41870-78—9389 Valley View Dr, Mesa, AZ, 852680.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-121619ENRHenry W Le2005-03-22UHC-67222-5822960786962816 Lincoln Way, Minneapolis, MN, 554710.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
ENR-104902ENRRobert P Rihardson1979-01-15UHC-08428-9368623796012701 Meadow Ln, Los Angeles, CA, 900480.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
9,980 rows, page 188 of 200PreviousNext