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-136192ENRAlice U Davis2002-06-01UHC-14521-52—6411 Desert Sky Blvd, Miami, FL, 331080.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState code upper-cased+2 more
ENR-124968ENREmily Jimenez1974-01-09UHC-37262-7992174385802840 Spring St, Minneapolis, MN0.52Date of birth reformattedSSN last four extractedState name converted to codeZIP missing+2 more
ENR-125305ENRAustin Clark2007-06-05UHC-09557-64—9803 Washington St # 633, Dallas, TX, 752570.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-135606ENRAustin Perkins1977-06-08UHC-84670-6839770714755500 Union St, Seattle, WA, 981710.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-114193ENRMason N Jenkins1971-02-08UHC-44213-3140386435112754 Meadow Ln, Minneapolis, MN0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-104598ENRDiego Castillo2007-02-09UHC-69309-4485244904563312 Maple Ave Apt 35, Houston, TX, 770380.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-120713ENRBrian Wells2001-07-16UHC-78951-3134335266117743 Market St, Tampa, FL0.52Name split from “Last, First”Phone reformattedMember ID reformattedZIP missing+2 more
ENR-140506ENRJesse K Kim1995-01-28UHC-52083-96—8917 Maple Ave, Phoenix, AZ, 850020.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-110254ENREmily B Gibson1977-10-15UHC-33914-455169147893960 Palm Dr Apt 15, Fresno, CA, 937440.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-140434ENRSandra C Young1938-09-22UHC-48035-6022471654228637 Mountain View Dr, San Antonio, TX0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-107266ENRKenneth Gonzalz1964-05-07UHC-04241-4421052889731000 Hillcrest Rd, Dallas, TX, 752470.52Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-102607ENRJudy K Kelly1959-11-11UHC-32707-8572146543186312 Indian School Rd, Fresno, CA, 937810.52Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
ENR-124842ENRAna X Luna1970-06-08UHC-91289-4528752962626915 Lake View Rd # 611, Nashville, TN, 372800.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-124986ENRElizabethJunk1985-06-17UHC-07694-8992576537549041 Baseline Rd, Fresno, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-125890ENRKimberly W Henderson1980-02-01UHC-76058-1645091116855226 Desert Sky Blvd, Austin, TX, 787720.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-122638ENRCarolyn E Olson1966-07-08UHC-95316-3152943355597469 Camelback Rd, Houston, TX, 770180.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-132529ENRCeryl D Thomas2004-07-05UHC-65987-5534585429948717 Ridge Rd, Houston, TX, 770470.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-104164ENRRussell L Tucker1953-03-14UHC-79982-50—7821 Central Ave, Scottsdale, AZ, 852620.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-111076ENRJacqueline Grant1978-12-02UHC-43018-8371081288309887 Spring St # 854, Charlotte, NC, 282690.52Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-124421ENRRussell Powell1939-10-22UHC-73379-98—8283 Willow Ct, Fresno, CA0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-124405ENRAngela J Alvarado1957-08-09UHC-25514-9956141312122119 Church St, Chandler, AZ, 852970.52Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
ENR-108054ENRFrank L Murray2006-09-23UHC-51068-9560358820376786 Mountain View Dr, Fresno, CA0.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-126626ENRJoe Olson—UHC-47916-6739058154098847 Market St, Scottsdale, AZ, 852450.52Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
ENR-129542ENRBobby L Payne1988-08-17UHC-54861-7623158603187432 Palm Dr, Columbus, OH, 432480.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-140161ENREugene J Jacobs1947-06-19UHC-70574-6249485072831650 Meadow Ln, Jacksonville, FL, 322630.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100467ENRChristina O Gray1982-06-23UHC-11437-6021161837638282 Cedar Ln, Charlotte, NC, 282850.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-133548ENRBradley Flores—UHC-20706-40—3417 Indian School Rd, Gilbert, AZ, 852960.52Name re-casedDate of birth unreadableSSN last four extractedStreet suffix standardised+2 more
ENR-111395ENRAlexis Garza1969-02-17UHC-59195-323157024133141 Bayshore Dr, Tucson, AZ, 857060.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-121856ENRMarcus Nguyen1981-01-17UHC-61216-0860442112218499 Forest Ave, Houston, TX, 770370.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-123058ENREmily N Williams1964-02-18UHC-97981-1444891485499305 Cedar Ln, Atlanta, GA, 303050.52Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
ENR-117401ENRTomy Mendoza2007-04-23UHC-73410-8486399368164060 Grand Ave, Eden Prairie, MN, 553930.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-139250ENRAlexis D Elliott1988-12-28UHC-17655-37—3400 Ridge Rd, Miami, FL, 331490.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-109533ENRDylan Y Rojas1974-10-07UHC-97077-1581228846904391 Camelback Rd, Austin, TX, 787620.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-128007ENRCynthia Baker1938-09-16UHC-45011-8045478011815643 Park Pl, Phoenix, AZ, 850440.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-131031ENRTeresa P Burton1956-04-24UHC-61347-45—5876 Indian School Rd # 546, Minneapolis, MN, 554670.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-120043ENRSantiago Padilla1981-11-04UHC-48047-31—6082 Grand Ave, San Diego, CA, 921470.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-130095ENREvelyn Perez1999-04-20UHC-48058-7655273605193972 Ocean Ave, Los Angeles, CA, 900770.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-103152ENRTheresa Andrews1998-05-22UHC-47418-4049124953143267 Central Ave, Austin, TX, 787490.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-126405ENRKayla I Cole1978-01-06UHC-96523-8469298891491075 Sunset Blvd, San Antonio, TX, 782480.52Two-digit birth yearPhone reformattedState name converted to codeGender normalised+2 more
ENR-130627ENRCarolyn Y Porter1960-04-02UHC-22051-9296045202104594 River Rd, Sacramento, CA, 958150.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-102557ENRLaura O Andrews1980-06-20UHC-68182-6526881387042321 Maple Ave Apt 2, Los Angeles, CA, 900910.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-105911ENRJesse Black1982-07-10UHC-62534-65—7388 Maple Ave, Dallas, TX, 752470.52Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-112612ENRBradley G Austin1938-05-07UHC-84381-5841167534797207 Washington St, Fresno, CA, 937380.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-123393ENRMaria V Wagner1983-05-02UHC-23015-9440591796344726 Valley View Dr Apt 13, Orlando, FL, 328770.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-105961ENRHeather O Griffin1987-08-11UHC-60659-3182482290928521 Palm Dr, Jacksonville, FL, 322780.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-125094ENRAnn O Fernandez1995-04-14UHC-94337-3198482790378664 Lake View Rd, Seattle, WA, 981120.52Name split from “Last, First”Date of birth reformattedState name converted to codeZIP+4 trimmed+2 more
ENR-122678ENRFatima Reyes—UHC-25320-9583961708383893 Meadow Ln # 874, Charlotte, NC, 282040.52Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+2 more
ENR-106510ENRAnn Ryan2002-08-24UHC-62398-098399494266423 Oak St, Las Vegas, NV, 891350.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-113380ENRWilliam I Stevens—UHC-54815-5227543458465378 Palm Dr # 216, Los Angeles, CA, 900020.52Name re-casedDate of birth missingPhone reformattedUnit split from street+2 more
ENR-127653ENRPatricia K Porter1986-09-25UHC-40405-0546329043928080 Forest Ave Apt 9, Denver, CO0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
43,101 rows, page 78 of 863PreviousNext