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
TPA-63580TPAFatima Bowman1989-06-08———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57004TPAAlexander Johnston2006-02-24———0.80Name split from “Last, First”Plan code upper-casedWhitespace trimmedPlaceholder values cleared
ENR-135426ENRHioshi D Wheeler1979-06-24UHC-36036-1578168638931173 Sunset Blvd, Orlando, FL, 328160.80Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted
CLM-431569CLMJuna Obriien2008-07-20UHC-63527-62—1923 Elm St, Los Angeles, CA, 900450.80Name split from “Last, First”Name re-casedCity re-casedPlaceholder values cleared
ENR-123198ENRTheresa Mejia1950-03-10UHC-12335-755379148304929 Highland Ave, Seattle, WA, 981770.80Name split from “Last, First”Date of birth reformattedPlan code upper-casedWhitespace trimmed
ENR-117744ENRAshley A Arnold1960-12-17UHC-00958-1886096939555208 Baseline Rd, Sacramento, CA, 958160.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-421111CLMDouglas U Warren1944-09-25UHC-53814-57—9292 Broadway, Orlando, FL, 328080.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
ENR-104510ENRKathryn Pierce1939-02-21UHC-95401-1653352574499528 Washington St, Tampa, FL, 336280.80Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed
TPA-54808TPAMelissa Sims1949-08-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54807TPAMelissa Sims1949-08-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-413929CLMHarold Rmos1978-08-26UHC-42336-852087905762—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62856TPAAmber Z Olson1965-06-20—6602446586—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-401504CLMKimberly Miller2002-12-17UHC-03074-285977327599—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-407120CLMFrank K Bowman1976-05-12UHC-05898-408403412160520 Lake View Rd, San Diego, CA, 921060.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-109566ENRWalter Pierce2001-04-03UHC-43500-6449334398119186 Grand Ave, Fresno, CA, 937460.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
ENR-117795ENRJudith Hudson2007-07-16UHC-21859-6179733324993419 Ocean Ave, Plano, TX, 750840.80Name split from “Last, First”Date of birth reformattedPhone reformattedEmail lower-cased
CLM-411981CLMDouglas Gonzales1954-12-17UHC-31335-663778778088—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23629PRVWei Alexander2000-09-27—47898909915244 Camelback Rd, Phoenix, AZ, 850190.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-105562ENRWelch K Dennis1986-10-24UHC-89611-1542052277443154 Maple Ave, Los Angeles, CA, 900520.80Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed
ENR-106715ENRKaren M Salazar1977-11-07UHC-08069-234399319682—0.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
CLM-430342CLMRaymond Carlson1975-09-18UHC-58887-83—2186 Baseline Rd, Atlanta, GA, 303420.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-27869PRVGeorge Gonzzales1944-02-26UHC-26152-277047922841—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-105538ENREric Q Fernandez1942-09-28UHC-44933-622446882663276 Ridge Rd, Orlando, FL, 328110.80Name split from “Last, First”Date of birth reformattedPhone reformattedEmail lower-cased
CLM-407286CLMSamuel Rojas1980-08-07UHC-84537-44——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62898TPABrandon Fox1977-08-01——7835 Meadow Ln, Phoenix, AZ, 850920.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-417313CLMJason A Wheeler1954-08-10UHC-04921-587058205106—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57733TPAJudy E Vega1996-03-15—9157390906—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-432819CLMVirginia Guerrero1939-07-02—65274883667836 Ocean Ave, Miami, FL, 331460.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-113297ENRHelen R Guzman1977-07-25UHC-62092-104839340028939 Meadow Ln, Minneapolis, MN, 554160.80Name split from “Last, First”Date of birth reformattedCity re-casedPlaceholder values cleared
ENR-142686ENRTeresa Grant1962-02-14UHC-91760-7559695680985420 Mountain View Dr, Jacksonville, FL, 322100.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28554PRVAisha I Powell1963-07-22—5429453518—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-109860ENRElizabeth Stevens1947-05-28UHC-93786-92——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-401448CLMMelissa Cruz1996-09-15UHC-43441-53—8804 Mesa Dr, Gilbert, AZ, 852490.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-405239CLMGuerrero W Anthony1993-12-01—6177725230—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-102642ENRKevin Z Gonzales1979-04-17UHC-66033-8276321678982112 Hillcrest Rd, Chandler, AZ, 852600.80Name split from “Last, First”Member ID reformattedCity re-casedWhitespace trimmed
CLM-427325CLMLisa D Obrien2004-10-24UHC-77989-41—3140 Lake View Rd, Tucson, AZ, 857300.80Name split from “Last, First”Name re-casedState code upper-casedPlaceholder values cleared
CLM-422509CLMRobert Marquez1950-08-05UHC-09983-434509933499590 Palm Dr, Scottsdale, AZ, 852000.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-127318ENRCarol O Jacobs2004-10-14UHC-65981-1689724270063789 Ridge Rd, Seattle, WA, 981360.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-110830ENRJean Z Ford1987-02-01UHC-58932-47—5920 Cedar Ln, Eden Prairie, MN, 553600.80Name split from “Last, First”Date of birth reformattedCity re-casedPlaceholder values cleared
CLM-408551CLMMariana D Anderson2000-10-14——340 Ocean Ave, Columbus, OH, 432740.80Name split from “Last, First”Date of birth reformattedCity re-casedPlaceholder values cleared
CLM-413697CLMKelly Z Perez1991-08-15UHC-12316-2922770781621759 Mountain View Dr, Los Angeles, CA, 900000.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53057TPANicholas Bradlley1954-07-23——9694 Broadway, Las Vegas, NV, 891120.80Name split from “Last, First”Date of birth reformattedAddress re-casedPlaceholder values cleared
ENR-135692ENRBilly Medina1947-04-11UHC-51862-7573168519043674 Canyon Rd, Gilbert, AZ, 852390.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55091TPAElizabeth Crawford2002-07-18—6113531127—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-422485CLMSam Brown2001-05-09UHC-22101-799465149159—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-104571ENRAlan I Howell1980-06-07UHC-76458-51—7152 Mesa Dr, Tucson, AZ, 857730.80Name split from “Last, First”Date of birth reformattedCity re-casedPlaceholder values cleared
CLM-401493CLMBruce Morris1948-12-27—21686548031843 Market St, San Antonio, TX, 782610.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61104TPAColeman Steven1943-09-27———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-424000CLMDonna Guzman1947-11-14UHC-71147-44——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-112554ENRBobby Harris2002-06-23UHC-14387-9571425452685709 Washington St, Houston, TX, 770250.80Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased
9,980 rows, page 175 of 200PreviousNext