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-129950ENRBetty P Elliott1959-03-21UHC-42063-2096261127509399 Central Ave, Columbus, OH, 432900.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102597ENRKelly Ray1956-10-25UHC-29979-9489620913047409 Hillcrest Rd, Fresno, CA, 937430.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-132820ENRAlice L Morrison1965-01-13UHC-39317-9722939689387940 Sage Ct, San Antonio, TX, 782650.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-142773ENRBryan X Cole1980-05-18UHC-40503-5851527822882690 Union St, Denver, CO, 802180.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-133146ENRAhmed M McDonald1956-06-08UHC-73330-8747260098333492 Union St, Atlanta, GA, 303640.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-109295ENRMargaret B Brown1948-06-19UHC-88357-0937164531115224 Central Ave, Houston, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-109233ENRMariana Roberts1979-06-21UHC-18824-9955379908053135 Market St Apt 17, San Diego, CA, 921890.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-119185ENROmar H Morales1973-10-04UHC-38951-8752288547896303 Park Pl, Tempe, AZ, 852240.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-118434ENRMaria I Jordan1956-08-02UHC-38848-2352451934194541 Spring St, Seattle, WA, 981500.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-118435ENRMaria I Jordan1956-08-02UHC-38848-2352451934194541 Spring St, Seattle, WA, 981500.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-139848ENRChristien McDonald1997-12-12UHC-77835-8587399233996840 Spring St, Charlotte, NC, 282750.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-112337ENRGerald W Ramirez1975-05-28UHC-09097-4984843426457735 Ridge Rd, Nashville, TN, 372360.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-136994ENRBenjamin B Harris1961-06-17UHC-10489-4044946578483587 Harbor Blvd, San Antonio, TX, 782630.60Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-138360ENRKen Barnes1982-10-20UHC-22269-872527899354737 Oak St, Chandler, AZ, 852400.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-127080ENRTheresa Green1965-10-27UHC-90230-783037512221949 Canyon Rd, San Diego, CA, 921150.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-107219ENRMei N Watkins1986-04-13UHC-62597-7386137461172223 Apache Blvd, Chandler, AZ0.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-113474ENRJim Johnson1945-07-21UHC-22933-1141154594129124 Grand Ave, Tempe, AZ, 852590.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-118642ENRWalter G Medina2008-11-16UHC-70862-607669759855974 Canyon Rd, Tempe, AZ, 852230.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-115041ENRHarold Nguyen1994-06-13UHC-06434-7532922915174469 Union St, Plano, TX, 750490.60Name re-casedPhone reformattedSSN last four extractedCity re-cased+4 more
ENR-109039ENRRonald N Gutierrez1959-08-02UHC-84184-6026220947367935 Palm Dr Apt 33, Miami, FL, 331500.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-123093ENRArjun G Hall2002-03-11UHC-12634-222567233942663 Jefferson Ave, Minneapolis, MN, 554480.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-122892ENRJeremy X Austin1956-05-06UHC-43876-0651554252071708 Apache Blvd, Minneapolis, MN, 554410.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-114224ENRBruce V Little1941-07-05UHC-76002-3475126087762833 Sunset Blvd, San Diego, CA, 921150.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-140298ENRDonna O Burton2002-06-16UHC-38505-4228560037108162 Mesa Dr Apt 27, Tampa, FL, 336970.60Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-108519ENRSteven Schmidt1995-02-05UHC-49596-7973972638558944 Central Ave, Orlando, FL, 328700.60Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-133996ENRSteven Edwards1943-10-14UHC-25642-7467398354071488 Hillcrest Rd # 665, San Diego, CA, 921720.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-101620ENRWang H Hiroshi1966-02-10UHC-08450-6675754945704121 Valley View Dr, Houston, TX, 770430.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-131917ENRSamantha Y Rose1989-04-19UHC-87146-4682979507275577 Washington St, Tucson, AZ, 857100.60Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-140349ENRJudy T Knight—UHC-66791-4662134985111771 Ridge Rd, Scottsdale, AZ, 852840.60Date of birth missingPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-133132ENRJoan L Murphy2000-05-01UHC-51326-26—4518 Sage Ct, Jacksonville, FL0.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-119772ENRJeremy Franklin1984-05-15UHC-73727-2427983065734598 Canyon Rd, Tempe, AZ, 852430.60Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124745ENREthan Perry2007-06-27UHC-68803-96—124 Park Pl, Eden Prairie, MN, 553570.60Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-141377ENREvelyn M Moore1955-08-25—40228474517193 Elm St, Atlanta, GA, 303390.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-133861ENRJoe Ford1948-09-25UHC-81018-8454979899926634 Canyon Rd, Minneapolis, MN, 554150.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102521ENRCarol U Richardson2001-02-20UHC-63269-963386124631350 River Rd # 191, Orlando, FL, 328960.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-140427ENRLisa F Rogers1955-05-21UHC-24194-2122861305766526 Park Pl, Los Angeles, CA, 900480.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-128608ENRCharles O Fuller1942-11-20UHC-40826-722699632658227 River Rd, Charlotte, NC, 282210.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-136533ENRCheryl L Peterson1958-03-10UHC-22463-5483440998318368 Hillcrest Rd, Denver, CO0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-114818ENRMei Ford2003-10-10UHC-16602-1790175631289236 Sage Ct, Dallas, TX, 752680.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-122986ENRKathy Morgan1994-04-23UHC-44662-6955353077905250 Spring St, Fresno, CA, 937540.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-111098ENRJames Burke1947-01-12UHC-47425-0774860230836978 Forest Ave, San Diego, CA, 921280.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-109864ENRSamantha L Perez1996-03-25UHC-74382-2368235117065062 Ridge Rd, Houston, TX, 770400.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-123910ENRSean Yang1966-01-27UHC-08711-4084454151329465 Palm Dr, San Diego, CA, 921910.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-133594ENRAmy M Ruiz1999-10-06—28051931472277 Highland Ave, Eden Prairie, MN, 553330.60Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-130650ENRHannah Vazquez2008-07-21UHC-72499-6946857756225714 River Rd, Dallas, TX, 752950.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-105454ENRAhmed Rice1994-04-07UHC-03543-903435426191273 Main St, Tucson, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-108619ENRHelen Vazquez1980-06-04UHC-23011-57—1526 Market St, Houston, TX, 770840.60Name re-casedDate of birth reformattedMember ID reformattedSSN last four extracted+4 more
ENR-126318ENRMaria Holmes1944-06-28UHC-41418-76—3447 Desert Sky Blvd, Tempe, AZ, 852900.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-130228ENRMason Clark1949-09-12UHC-58223-41—3158 Bayshore Dr, Houston, TX, 770100.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-137834ENREddie P Hnry1990-12-09UHC-97702-6774864647603721 Washington St, Columbus, OH0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
43,101 rows, page 122 of 863PreviousNext