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-102333ENRLuis Burke1949-09-03UHC-72644-35—5820 Hillcrest Rd, Houston, TX, 770770.54Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-129744ENRKaren R Duncan1971-12-27UHC-38258-24—6670 Cedar Ln # 886, Miami, FL, 331630.54Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+1 more
ENR-119859ENRJordan Ellis—UHC-92342-9940729873039877 Mesa Dr, Houston, TX, 770260.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-118337ENRNancy W Mlils1981-07-20UHC-00702-2847063893237380 Oak St # 505, Charlotte, NC0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-116701ENRBryan Hicks1953-04-25UHC-57811-46—856 Valley View Dr, Los Angeles, CA, 900130.54Name split from “Last, First”Date of birth reformattedZIP+4 trimmedEmail lower-cased+1 more
ENR-113090ENRJason Cole2007-07-06UHC-46743-1864121137221897 Washington St # 701, Phoenix, AZ, 850060.54Two-digit birth yearPhone reformattedSSN last four extractedUnit split from street+1 more
ENR-131770ENRWei Q Morrison1956-07-26UHC-11160-33—5478 Canyon Rd Apt 34, Plano, TX, 750310.54Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-138699ENRCheryl Little1992-09-28UHC-89021-4352160937994835 Hillcrest Rd Apt 33, Eden Prairie, MN, 553900.54Name split from “Last, First”Phone reformattedSSN last four extractedUnit split from street+1 more
ENR-131937ENRSarah Rivera1991-04-26UHC-69163-8690975666139867 Sage Ct, Scottsdale, AZ, 852240.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-102559ENREugene H McCoy—UHC-78063-8576333985234186 Pine Dr, Orlando, FL0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-120212ENRJohn Clark1944-10-26UHC-32961-2037840468411606 Desert Sky Blvd, Plano, TX, 750370.54Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+1 more
ENR-142444ENRKatyh C Anderson1957-02-05UHC-30623-8949428753696950 River Rd Apt 35, Dallas, TX, 752980.54Middle initial moved out of first namePhone reformattedUnit split from streetState name converted to code+1 more
ENR-131565ENRAngela Woods1978-01-03UHC-12380-0141044952676025 Oak St, Minneapolis, MN, 554070.54Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
ENR-136872ENRRyan Richards1978-06-09UHC-25214-3636461599854533 Mesa Dr # 596, Los Angeles, CA, 900390.54Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+1 more
ENR-109460ENRKyle E Lopez1956-05-05UHC-73389-1194420250835858 Sage Ct, Chandler, AZ0.54Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-117987ENRSusan C Gardner1968-04-27UHC-08142-9391896860805508 Pine Dr # 675, Charlotte, NC, 282310.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-134947ENRJordan G Weaver1947-11-19UHC-41990-34—4916 Sunset Blvd, Phoenix, AZ0.54Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-132657ENRLawrence Kelly—UHC-38369-9245429502749622 Central Ave, Fresno, CA0.54Name re-casedDate of birth missingState name converted to codeZIP missing+1 more
ENR-138110ENRMaria L Richards—UHC-07157-4665145093473146 Bayshore Dr, Eden Prairie, MN, 553100.54Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+1 more
ENR-129216ENRHeather N Watson1999-02-19UHC-13281-285823689226310 Main St, Plano, TX, 750450.54Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-100695ENRBryan Peterson—UHC-76984-96—71 Willow Ct # 737, Mesa, AZ, 852340.54Date of birth unreadableUnit split from streetZIP+4 trimmedWhitespace trimmed+1 more
ENR-136293ENRBilly A Washington1996-02-02UHC-77163-13—1371 Desert Sky Blvd, Glendale, AZ, 853360.54Name re-casedTwo-digit birth yearCity re-casedState name converted to code+1 more
ENR-111122ENRJason Davis2008-11-02—88862584198435 Pine Dr Apt 15, Gilbert, AZ, 852880.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-120741ENREmily T Fuller1975-06-24UHC-91168-0788326229745073 Sunset Blvd, Miami, FL, 331960.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-103313ENRNicholas C Dominguez1943-05-08UHC-92617-6897273331426743 Baseline Rd Apt 12, Houston, TX, 770710.54Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+1 more
ENR-137634ENRAndrew J Montgomery—UHC-32115-7074724011353903 Mesa Dr, San Antonio, TX, 782840.54Middle initial moved out of first nameName re-casedDate of birth missingPhone reformatted+1 more
ENR-128263ENRBobby Castro1943-06-02UHC-60624-223069114821288 Ocean Ave Apt 13, Los Angeles, CA0.54Phone reformattedMember ID reformattedUnit split from streetState name converted to code+1 more
ENR-138055ENRJohn T Salazar1982-02-06UHC-74782-2682092656055809 Palm Dr, Gilbert, AZ, 852320.54Phone reformattedSSN last four extractedState name converted to codeEmail lower-cased+1 more
ENR-118814ENRCheryl T Jacobs1974-07-10UHC-69318-5283525380811398 Spring St, Eden Prairie, MN, 553820.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-102942ENRAmber P Espinoza1948-01-22UHC-65231-2470030703591009 Mountain View Dr, Los Angeles, CA, 900620.54Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
ENR-108652ENRCarroll Z Sophia1979-02-23UHC-64413-5258163884125642 Desert Sky Blvd, Atlanta, GA, 303940.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-108653ENRCarroll Z Sophia1979-02-23UHC-64413-5258163884125642 Desert Sky Blvd, Atlanta, GA, 303940.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-100027ENRAustin Henry2008-03-02UHC-53911-8271040698484483 Hillcrest Rd, Atlanta, GA, 303270.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-118382ENRVirginia Q Butler1998-05-09UHC-27368-9563453623064254 Valley View Dr # 367, Atlanta, GA, 303040.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-131841ENRCharlotte T Turner1961-12-18UHC-11473-2761393560987851 Union St, Nashville, TN0.54Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-132441ENRJeremy V McDonald1940-06-12UHC-67446-94—5567 Willow Ct, Fresno, CA, 937290.54Two-digit birth yearPhone missing area codeGender normalisedWhitespace trimmed+1 more
ENR-138597ENRAustin Rogers1986-07-06UHC-96104-2364774304937743 Sage Ct, San Antonio, TX, 782730.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-119904ENRJacob Banks1988-07-10UHC-77320-9045484884075849 Cedar Ln, Mesa, AZ, 852670.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-126893ENRBarbara N Murphy1959-07-01UHC-87414-3060993107603962 Mesa Dr Apt 6, Chandler, AZ0.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-126892ENRBarbara N Murphy1959-07-01UHC-87414-3060993107603962 Mesa Dr Apt 6, Chandler, AZ0.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-135038ENRTeresa D Cunningham—UHC-56407-995897165184981 Willow Ct, San Diego, CA, 921630.54Middle initial moved out of first nameDate of birth unreadablePhone reformattedStreet suffix standardised+1 more
ENR-120842ENRRonald Cox1942-12-27—27525981196366 Spring St, Plano, TX, 750020.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-111578ENRBruce Fowler1938-05-08UHC-81149-56—7225 Lincoln Way, Columbus, OH, 432130.54Phone missing area codeState name converted to codeZIP+4 trimmedEmail lower-cased+1 more
ENR-131003ENRElijah Grant1940-05-21UHC-75378-87—587 Church St, Eden Prairie, MN, 553770.54Phone missing area codeStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
ENR-124995ENRDebra W Sinhg—UHC-05447-844967867869887 Harbor Blvd, San Antonio, TX0.54Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
ENR-116103ENRScott Wilson1954-03-26UHC-00397-8237857258929053 Lincoln Way Apt 28, Sacramento, CA, 958790.54Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
ENR-113992ENRWillie Gibson1994-04-23UHC-28593-6935125751553603 Harbor Blvd, Tampa, FL, 336950.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-141534ENREd Y Carter2004-12-18UHC-08519-8283442878645858 Lake View Rd # 256, Minneapolis, MN, 554860.54Date of birth reformattedUnit split from streetState name converted to codeGender normalised+1 more
ENR-112297ENRBrittany T Gardner1986-05-11—76988874521215 Cedar Ln, Plano, TX, 750580.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-109119ENRDouglas R Peterson1980-05-13UHC-56966-41—991 Mountain View Dr, Fresno, CA, 937930.54Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+1 more
43,101 rows, page 97 of 863PreviousNext