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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-129855ENRMegan K Johnston1999-09-12UHC-38617-0848649218816312 Ridge Rd, San Diego, CA0.48Street suffix standardisedAddress re-casedCity re-casedState name converted to code+4 more
ENR-102158ENRPhilip T Hall1945-11-02UHC-71742-6423728093303728 Hillcrest Rd, San Diego, CA, 921770.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-100964ENRJon W Bryant1980-03-06UHC-60743-9420675263096901 Baseline Rd, Plano, TX, 750330.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-138806ENRTyler H Holmes1946-08-06UHC-39697-4163244445331884 Grand Ave, Houston, TX, 770520.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-110929ENRShirley Obriien2000-12-26UHC-56714-8759432486854525 Hillcrest Rd, Gilbert, AZ, 852600.48Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
ENR-103999ENRJudith Brown2002-05-09UHC-51197-1098380689753207 Maple Ave Apt 15, Scottsdale, AZ, 852950.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-137589ENRKevin Howard1967-09-16UHC-68679-3948343847195866 Sunset Blvd, Chandler, AZ, 852120.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-118511ENRPaul Gilbert1952-08-21UHC-18539-67—6577 Ridge Rd, Houston, TX, 770480.48Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-100033ENRVincent L Oliver1973-05-14UHC-16577-4074764225646938 Apache Blvd, San Diego, CA, 921610.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
ENR-113479ENRVincent G Chapman2001-08-26UHC-05422-137213594201694 Lake View Rd, Tampa, FL, 336090.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129174ENRLucia C Wood1946-04-20UHC-62547-5932367001492088 Indian School Rd, Los Angeles, CA0.48Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
ENR-128036ENRCarlos M Hughes1955-05-05UHC-29904-363896114765516 Sunset Blvd Apt 37, Plano, TX, 750470.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-143072ENRValentina E Garrett—UHC-90419-9291287591116804 Ocean Ave, Plano, TX, 750130.48Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-127481ENRNoah J Mendez1984-04-12UHC-58028-4927993121407772 Ridge Rd, Glendale, AZ0.48Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
ENR-136190ENRJoe C Day1948-02-19UHC-72292-7935889862996135 Apache Blvd, Miami, FL, 331330.48Middle initial moved out of first namePhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-141661ENRWilliam T Rodriguez1993-05-23UHC-66982-3724774206272554 Market St, Columbus, OH, 432960.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-117107ENRJudy Stevens1962-08-11UHC-82487-2040196889173652 Palm Dr, Los Angeles, CA, 900410.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-118684ENRBradley L Henry2003-04-13UHC-31206-7164060039777362 Park Pl # 878, Chandler, AZ, 852940.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-119674ENRTyer S Torrees2002-11-05UHC-22537-4483894130039062 Oak St, Tampa, FL, 336730.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-105568ENRMatthew Carroll1999-01-17UHC-31003-234908055318223 Market St, San Diego, CA0.48Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-120651ENRKaren Lucas1956-07-02UHC-43243-0950656610466460 Bayshore Dr Apt 23, Phoenix, AZ0.48Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-131811ENRLuis G Perry1946-06-14UHC-22698-52—8902 Park Pl, Tucson, AZ, 857550.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-121709ENRBeverly Mendoza2008-09-20UHC-46120-8645727213009052 Desert Sky Blvd, Tampa, FL0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133959ENRJennier K Graham1962-09-18UHC-93558-2587449619888552 Highland Ave, Houston, TX, 770640.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-122588ENRLuis Nelson1972-10-11UHC-24502-41—7817 Sage Ct, Las Vegas, NV0.48Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141381ENRBeverly Henry1938-07-18UHC-07701-7888198760744245 Lake View Rd Apt 29, Scottsdale, AZ, 852600.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-142354ENRJudy M Lynch1966-09-04UHC-41671-34—5926 Mesa Dr # 463, Austin, TX, 787180.48Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-114465ENRDaniel Spencer1988-07-25UHC-34290-395803814153738 Grand Ave, Tucson, AZ0.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-142862ENRRobert T Ray1986-11-19UHC-38009-7570185010119442 Pine Dr, Seattle, WA, 981280.48Two-digit birth yearPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-104273ENRAshhley Park1946-12-01UHC-07501-1487761704219167 Forest Ave, San Antonio, TX0.48Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-136554ENRBradley McDonald2006-02-04UHC-28129-6564229319655167 Main St Apt 30, Eden Prairie, MN0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-136504ENRRuh C Montgomery1968-10-18UHC-83646-29—125 Sunset Blvd, Atlanta, GA, 303830.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-113152ENRTler Sullivan1992-07-06UHC-70041-9096032156481500 Meadow Ln, Miami, FL, 331150.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-130499ENRBradley U Green1970-06-22UHC-21055-7341288721346742 Market St, Austin, TX, 787410.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-132257ENRChristina H Hawkins1975-10-25UHC-77082-7320148569662144 Cedar Ln, Austin, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132029ENRAngela U Henry1969-08-26UHC-34788-4177658683528514 Desert Sky Blvd, San Antonio, TX, 782760.48Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-117997ENRElizabeth N Contreras1965-06-13UHC-92452-2671450301385143 Elm St, Nashville, TN, 372470.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132937ENRVincent Lee1989-04-10UHC-01286-91—6997 River Rd, Glendale, AZ, 853380.50Phone missing area codeSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-142745ENRAmanda Bennett2004-01-08UHC-35446-7748276298396065 Union St # 946, Columbus, OH, 432510.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-114825ENRDaniel X Austin1967-05-16UHC-34567-1086247414771430 Pine Dr # 733, Denver, CO, 802620.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-106784ENRDenise L Morgan1995-12-27UHC-49964-5553462324965211 Harbor Blvd Apt 36, Houston, TX, 770850.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-138625ENRLuis Hicks1963-12-07UHC-24118-3322589847247581 Lincoln Way, Tempe, AZ, 852190.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138278ENRSophia Stone1985-10-25UHC-25297-9397690779037630 Mesa Dr # 889, Columbus, OH, 432400.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130246ENREmily X Little1996-04-14UHC-12266-1973754036033165 Sunset Blvd, Chandler, AZ, 852920.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-130247ENREmily X Little1996-04-14UHC-12266-1973754036033165 Sunset Blvd, Chandler, AZ, 852920.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-127584ENRNicole Snyder1988-07-06UHC-47909-5433024176736336 Spring St, San Antonio, TX, 782370.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-102993ENRJesse C Peters1982-04-06UHC-85390-3852038922626712 Ridge Rd, Glendale, AZ, 853610.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-111913ENRChristine D Barnes2006-01-22UHC-70917-3253226338615821 Washington St, Columbus, OH0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107361ENRWilliam Bradley1964-03-20UHC-33492-59—9247 Jefferson Ave, Glendale, AZ, 853490.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113893ENRAnthony Q Cox—UHC-21551-4535130312238525 Willow Ct, Glendale, AZ0.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
43,101 rows, page 44 of 863PreviousNext