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-140994ENRSusan Contreras1963-04-01UHC-06057-20—7437 Sage Ct, Columbus, OH, 432950.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-427517CLMCatherine Chen1941-03-06UHC-58328-78—3233 Sunset Blvd, Plano, TX0.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-139579ENREthan E Gardner1961-03-01—75838119828361 Indian School Rd, Nashville, TN, 372480.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132614ENRJanet A Hicks1953-06-15UHC-36211-77381293546340 Main St, Columbus, OH, 432410.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53382TPARoger George1983-01-10—45334726181902 Washington St, Atlanta, GA, 303620.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410765CLMBrittany Fowler1948-04-11—77383111154303 Lake View Rd Apt 28, San Antonio, TX, 782740.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-128765ENRKeith Long1985-12-28UHC-61870-1936569137678925 Highland Ave, Jacksonville, FL, 322270.50Phone reformattedSSN last four extractedCity re-casedZIP+4 trimmed+3 more
ENR-115653ENRJordan Z Tucker2007-11-17UHC-04978-28—7544 Ridge Rd, Phoenix, AZ, 850630.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-115654ENRJordan Z Tucker2007-11-17UHC-04978-28—7544 Ridge Rd, Phoenix, AZ, 850630.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-26592PRVDeb Robinson1946-06-14UHC-84327-1438470630633973 Union St, Austin, TX, 787340.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21950PRVDanielle Collins1983-10-27—48248842802407 Park Pl, Tampa, FL, 336100.50Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+3 more
ENR-115157ENRAigail Y Franklin2001-09-17UHC-02014-7932734002986682 Central Ave, Phoenix, AZ, 850790.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122561ENRSophia T Jensen1955-01-11—75983402209101 Union St, Atlanta, GA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125827ENRSaron Ford1965-12-07UHC-29790-883493993797845 Indian School Rd, Charlotte, NC, 282170.50Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-130440ENRElijah A Medina1950-10-18UHC-16726-8637527262707673 Ridge Rd # 905, Plano, TX, 750140.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-133331ENRBobby T Nelson—UHC-69366-1972339441952623 Ocean Ave, Gilbert, AZ, 852670.50Middle initial moved out of first nameDate of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-137470ENRMatthew D Shwa—UHC-20965-7162784739681303 Ocean Ave, Fresno, CA, 937930.50Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
CLM-400698CLMMarcuus Collins1946-03-20UHC-00187-2837725247343486 Harbor Blvd, Fresno, CA0.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-407227CLMVincent Lee1979-01-01UHC-40504-2568977459664326 Sunset Blvd, Houston, TX, 770680.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115280ENRLawrence K Weaver1964-02-04UHC-26133-9892921200243519 Church St Apt 22, Tempe, AZ, 852190.50Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
ENR-111784ENRJim X Herrera2007-10-15UHC-91233-3155065931723206 Washington St, Las Vegas, NV0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412718CLMJanice K Patel1993-06-11UHC-60883-6556586490432290 Central Ave, Phoenix, AZ0.50Date of birth reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-401292CLMChristopher Coleeman1950-04-12——1911 Ocean Ave, Miami, FL, 331720.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-137450ENRSnyder H Carolyn1967-06-26UHC-76043-3540369172129463 Hillcrest Rd, Eden Prairie, MN, 553910.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-21630PRVDiego Q Riley1994-07-22UHC-05758-7520967928701017 Harbor Blvd, Miami, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427401CLMAmy X Gonzalez1984-04-03—45625959126841 River Rd Apt 35, San Diego, CA, 921190.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-26572PRVRuth Ford1973-12-26—72195637123627 Desert Sky Blvd # 199, Tempe, AZ0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-430580CLMMatthew K Long1990-05-18UHC-59379-93—5571 Meadow Ln, Glendale, AZ0.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-63518TPAKimberly Vega1961-03-18——9577 Spring St, Nashville, TN, 372170.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-121813ENRLawrence J Williams1987-07-11UHC-68040-1989888049677519 Highland Ave, Minneapolis, MN, 554610.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-418234CLMEguene Soto1991-01-02——9360 Lake View Rd, Eden Prairie, MN0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
PRV-21704PRVBen Harvey1949-06-01UHC-69892-5161960528922760 Apache Blvd, Tucson, AZ, 857440.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116674ENRJackie K Simpson1977-08-11—42597784769403 Highland Ave, Gilbert, AZ, 852460.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-119875ENRJesse L Bowman1997-04-20UHC-57466-8247082102399636 Desert Sky Blvd, Sacramento, CA0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-410229CLMRussell Hicks1974-03-05UHC-25635-113292866762294 Central Ave, Charlotte, NC, 282840.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-125220ENRDebra S Meyer1981-02-03UHC-68461-3088177450153651 Central Ave, San Diego, CA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415304CLMAmy Lawrence2003-09-23——2012 Mountain View Dr, Denver, CO, 802470.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-421445CLMJulie Vasquez1944-08-01UHC-85680-4898323857564713 Jefferson Ave, Tampa, FL, 336130.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-421446CLMJulie Vasquez1944-08-01UHC-85680-4898323857564713 Jefferson Ave, Tampa, FL, 336130.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-400216CLMHarold Pena1997-05-15—41587012421236 Union St, Charlotte, NC, 282390.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400215CLMHarold Pena1997-05-15—41587012421236 Union St, Charlotte, NC, 282390.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110626ENREmily J Martin1997-05-14UHC-23423-5096661365763958 Elm St, Miami, FL, 331090.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-128484ENRShirley Lee—UHC-25265-2691358189169437 Camelback Rd, Columbus, OH, 432050.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-117136ENRHannah B Simmons—UHC-61478-1259579112752317 Church St, Fresno, CA, 937780.50Name split from “Last, First”Date of birth missingPhone reformattedMember ID reformatted+3 more
CLM-408945CLMPat Lawis1979-06-05UHC-15634-1261842346634359 Forest Ave, Nashville, TN, 372770.50Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132829ENRWei L Medina1925-10-25UHC-05721-07—4780 Lake View Rd, Plano, TX, 750670.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-101833ENRRobert S Campbell1972-06-02UHC-60444-5742939605842785 Willow Ct, Charlotte, NC, 282530.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-112846ENRDeborah S Berry1940-01-16UHC-77773-4258678505652880 Pine Dr, Gilbert, AZ, 852570.50Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51542TPAAhmed Moore1988-10-26—47279633805163 Valley View Dr, Houston, TX, 770250.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400010CLMRay Walsh1951-11-03UHC-09175-90—764 Baseline Rd, Seattle, WA, 981980.50Phone missing area codeStreet suffix standardisedAddress re-casedState code upper-cased+3 more
100,000 rows, page 124 of 2,000PreviousNext