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, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-107560ENROJunk1991-05-19—33546682492636 Highland Ave, Sacramento, CA, 958890.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407379CLMJoyce Vargas1953-08-24—93745524406679 Spring St, Nashville, TN, 372220.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20043PRVDoris T Mendoza1986-11-26UHC-29920-8730699775475813 Willow Ct, Charlotte, NC0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105632ENRHelen McCoy1999-07-23UHC-48762-313759522691858 Market St, Tampa, FL0.50Phone reformattedMember ID reformattedSSN last four extractedState name converted to code+3 more
CLM-428697CLMJoyec Hanson1963-01-25UHC-16292-82—7610 Mountain View Dr Apt 21, Plano, TX, 750190.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-140045ENRCharlotte F Ross1978-02-09UHC-07779-4060563295652008 Ocean Ave, Dallas, TX, 752530.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110472ENRDylan Santiago1991-06-20UHC-31030-97—8719 Pine Dr, Atlanta, GA, 303680.50Name re-casedTwo-digit birth yearPhone missing area codeCity re-cased+3 more
ENR-134392ENRCharles M Hoffman1958-06-21UHC-08773-0221525400322378 Bayshore Dr Apt 2, Mesa, AZ, 852750.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
PRV-23303PRVAna Carlson——32028016046642 Church St, Columbus, OH, 432870.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-123706ENRJessica Gordon1965-09-14UHC-38164-2195326354937519 Pine Dr Apt 35, Sacramento, CA0.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-429116CLMBrian Dixon—UHC-02163-23—8209 Maple Ave, Gilbert, AZ0.50Name re-casedDate of birth unreadableMember ID reformattedStreet suffix standardised+3 more
ENR-111011ENRJeremy Schmidt1971-11-24UHC-95137-59—4185 Meadow Ln, Los Angeles, CA, 900680.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-400548CLMAmy Wong1972-07-16UHC-19081-1686844642075871 Baseline Rd Apt 27, Glendale, AZ, 853200.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-117439ENRLucia E Bryant2000-10-15UHC-21632-3149980449647434 Market St # 638, Glendale, AZ, 853230.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-114560ENRSophia Miller2004-08-07—53865328819556 Canyon Rd, Miami, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116997ENRCarl Lewis1984-10-22UHC-93843-3775353331831821 Bayshore Dr, Orlando, FL0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63269TPADenise Pena1998-08-10——8859 Lake View Rd, Tucson, AZ, 857110.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-59334TPATheresa Jimenez1982-01-13—87569072202263 Bayshore Dr, Eden Prairie, MN0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-59333TPATheresa Jimenez1982-01-13—87569072202263 Bayshore Dr, Eden Prairie, MN0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-406409CLMAlexis Welch1950-05-21UHC-42203-08—6563 Canyon Rd, Phoenix, AZ, 850680.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-421461CLMJuan Kelly1945-10-24—89637628032386 Central Ave Apt 30, Phoenix, AZ, 850570.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-57320TPADouglas Jones1993-04-21UHC-06739-807159927250533 Willow Ct Apt 13, Chandler, AZ, 852300.50Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-132900ENRAhmed Rose1972-11-01UHC-11855-2090076841494535 Camelback Rd # 907, Seattle, WA0.50Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more
ENR-138795ENRJonathan Bryant—UHC-15588-8628791568378590 Apache Blvd, San Antonio, TX0.50Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+3 more
TPA-54821TPAHelen McCoy2004-04-17——5375 Oak St, Mesa, AZ, 852150.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63172TPAJesse D Lewsi——78045422172263 Oak St, Gilbert, AZ, 852330.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141552ENRBilly R Fisher1980-06-20UHC-98030-2769962691351611 Hillcrest Rd Apt 31, Seattle, WA, 981550.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-23988PRVTheresa Mendez1976-12-25——7707 River Rd # 553, Miami, FL0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-410930CLMAlice Armstrong——34429207127640 Forest Ave, Columbus, OH0.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127541ENRJoan U Morgan1953-12-09UHC-54119-0732493433363800 Washington St, Eden Prairie, MN, 553280.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415071CLMKaren Roberts1944-08-03UHC-49232-3145153527453071 Cedar Ln, San Diego, CA, 921600.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58564TPACharlotte Vasquez1989-12-02UHC-33932-81—6142 Cedar Ln, Jacksonville, FL, 322260.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-23275PRVJacob V Welch1958-01-25——1663 Highland Ave, Jacksonville, FL, 322160.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-125805ENRPaul Montgomery—UHC-33633-1892756166289334 Oak St, Phoenix, AZ, 850240.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-102128ENRAronld G Cheryl1939-07-17UHC-49778-2794744718991883 Canyon Rd, Chandler, AZ, 852800.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430195CLMSara Cox1961-08-17UHC-33317-40—7281 Ocean Ave, Seattle, WA, 981640.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-61220TPAPatrick Gilbert1986-05-26UHC-38235-14—9878 Indian School Rd Apt 12, Atlanta, GA0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-103358ENRJulie E Olson1972-11-08UHC-69723-7657830765152676 Hillcrest Rd, Jacksonville, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-139111ENRYuki Ruiz1972-03-21UHC-19041-11—6056 Ridge Rd, Nashville, TN, 372570.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-137078ENRJason R Morgan2006-04-10UHC-31457-9150427185662752 Hillcrest Rd, Tampa, FL0.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
CLM-406639CLMHarold N Vega—UHC-62854-39—9470 Highland Ave, Orlando, FL, 328420.50Name re-casedDate of birth unreadableCity re-casedState name converted to code+3 more
CLM-432090CLMBrittany I Garrett1970-01-05UHC-07264-35—3896 Hillcrest Rd, Los Angeles, CA, 900310.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-409987CLMNicole Hayes1939-04-16UHC-32516-687178720107695 Apache Blvd, Plano, TX0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-28173PRVNancy Y Johnson1982-09-21—73937503015070 Mountain View Dr, Atlanta, GA, 303750.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120144ENRKathryn J Hill1960-10-10UHC-93631-5546325010447190 Maple Ave, Jacksonville, FL, 322420.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-28630PRVAustin Rogers——64774304937743 Sage Ct, San Antonio, TX, 782730.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-127561ENRMason W Howard1981-02-03UHC-97472-9095552543272216 Church St, Jacksonville, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121404ENRLisa Bishop1946-04-25UHC-70027-5945557135435476 Mesa Dr, Fresno, CA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28858PRVCynthia Ross——91155340629101 Pine Dr, Seattle, WA, 981080.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55509TPABradnon White2000-04-11—69637928141696 Apache Blvd, Las Vegas, NV, 891710.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 131 of 2,000PreviousNext