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-121824ENRElijah Burke2003-04-06UHC-58551-9135292775457099 Elm St, Glendale, AZ, 853600.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-412328CLMJuan Harris1964-11-17UHC-78189-727794991234—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-412327CLMJuan Harris1964-11-17UHC-78189-727794991234—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59734TPAEmily Fuller1986-02-02——5531 Baseline Rd, Tampa, FL, 336710.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-54507TPAJessica M Soto1971-04-14———0.80Name split from “Last, First”Date of birth reformattedPlan code upper-casedPlaceholder values cleared
ENR-103374ENRMadison Nichols1999-10-21UHC-83753-9326735321812676 Ridge Rd, Jacksonville, FL, 322880.80Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased
ENR-119939ENRBarbara Jones2002-06-14UHC-41956-9140352040042937 Sunset Blvd, Los Angeles, CA, 900710.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-62324TPAMary Herrrera1973-03-20——7943 Palm Dr, Houston, TX, 770400.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-423420CLMJoyce F Jensen1953-09-21———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-404629CLMJacqueline Bailey1939-06-16UHC-30577-17——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-103271ENRBruce W Maldonado1975-04-15UHC-52868-2653439976069375 Union St, Tucson, AZ, 857380.80Name split from “Last, First”Date of birth reformattedPlan code upper-casedWhitespace trimmed
TPA-63627TPAMatthew Cox1952-01-15—8509834923—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-411523CLMKimberly Berry1983-04-14UHC-52540-5267798486318813 Apache Blvd, Mesa, AZ, 852260.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
CLM-412330CLMAmber S Adams1973-09-14UHC-14192-295052656345—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-50019TPAJeeremy Franklin1974-09-25UHC-69691-367618885265—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-124693ENRNicholas N Stephens1981-02-16UHC-10068-7379540291626724 River Rd, Houston, TX, 770970.80Name split from “Last, First”Phone reformattedEmail lower-casedWhitespace trimmed
ENR-131150ENRJeremy Black1991-06-26UHC-57324-0133138176036364 Harbor Blvd, Mesa, AZ, 852920.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
CLM-425583CLMMark Hernandez2000-11-13UHC-59408-499227518837—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20230PRVAnna S Fisher1990-09-28UHC-66514-159384466330—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-417630CLMCarolyn Campbell1950-02-15UHC-91732-23—7292 Broadway, Denver, CO, 802440.80Name split from “Last, First”Member ID reformattedAddress re-casedPlaceholder values cleared
TPA-50162TPAKatherine Payne1945-07-05—3453147322352 Meadow Ln, Miami, FL, 331910.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-414486CLMSandra M Guzman1941-03-22———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-409440CLMCynthia Castro1981-10-06UHC-71182-79—1248 Sunset Blvd, Seattle, WA, 981890.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-50269TPAKatherine Spencer1941-12-05———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-27345PRVMaria P Henry1981-02-04UHC-39990-48—4187 Central Ave, Plano, TX, 750530.80Name split from “Last, First”Date of birth reformattedCity re-casedPlaceholder values cleared
TPA-63763TPAJose Ellis1963-01-01———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-404309CLMJacqueline T Jimenez1950-09-07UHC-16993-83——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62367TPAElizabeth Gray1958-06-25—97675372653136 Sunset Blvd, Minneapolis, MN, 554880.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-400306CLMJohn Brooks1995-06-08UHC-96259-4087228827232490 Broadway, Mesa, AZ, 852750.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-427947CLMJames Owens1966-02-24UHC-52508-5122753310399781 Harbor Blvd, Phoenix, AZ, 850160.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-406237CLMSharon Hanson2000-07-07UHC-65180-552427033344—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57032TPARachel Coleman1981-12-28—660953506793 Ocean Ave, Jacksonville, FL, 322620.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-28617PRVJonathan Burton2006-09-23UHC-87120-2097166703844473 Mesa Dr, Dallas, TX, 752380.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59752TPABarbara Rogers1993-12-17—93249831283065 Valley View Dr, Mesa, AZ, 852920.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-422587CLMBruce Clark1990-05-02UHC-63878-37——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-425547CLMDouglas Welch2003-09-27UHC-49873-667764236423—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-134166ENRAnthony Y Morgan2001-09-05UHC-23469-6226627002985791 Indian School Rd, Scottsdale, AZ, 852310.80Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased
ENR-121651ENRAnthony Weaver1999-03-14UHC-71437-697475189556—0.80Name split from “Last, First”Phone reformattedEmail lower-casedPlaceholder values cleared
CLM-426671CLMSean Blaack2000-04-23UHC-29465-84——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-410573CLMHarold P Rojas1972-04-17—4998740265—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-139315ENRLucia Oliver1978-03-13UHC-03058-9678699404381236 Cedar Ln, Mesa, AZ, 852190.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
CLM-404997CLMBruce Bowman1939-02-28UHC-63573-1375949299493068 Pine Dr, Gilbert, AZ, 852400.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-108007ENRMarcus Roberts2005-04-16UHC-52099-2840091567361639 River Rd, Miami, FL, 331220.80Name split from “Last, First”Date of birth reformattedMember ID reformattedPlan code upper-cased
TPA-64055TPADonna Mason2002-04-14—96782611861781 Forest Ave, San Antonio, TX, 782450.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-115557ENREdward McDonaald1977-01-23UHC-73216-6172144352029633 Cedar Ln, Scottsdale, AZ, 852510.80Name split from “Last, First”Date of birth reformattedState code upper-casedPlaceholder values cleared
TPA-53607TPAMaria Valdez1942-10-01——7473 Central Ave, Gilbert, AZ, 852360.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-405240CLMDorothy Moreno1944-06-07UHC-95806-458033658210—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59100TPAYuki Gilbert1979-05-10——4855 Broadway, Atlanta, GA, 303890.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-138667ENRReebcca E Cox1997-02-09UHC-65252-8835825090378322 Sage Ct, Orlando, FL, 328580.80Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased
PRV-27610PRVDunna Reed1985-11-09—44756244589147 Park Pl, Jacksonville, FL, 322420.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
9,980 rows, page 163 of 200PreviousNext