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-125433ENRRachel Long1996-07-12UHC-84625-2132388328005552 Spring St Apt 24, Tampa, FL0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-118842ENRCheryl U Wang1959-07-15UHC-22851-7162238087712046 River Rd, Plano, TX, 750690.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126239ENROmar U Fields1970-08-01UHC-26432-52—7580 Ocean Ave, Dallas, TX, 752800.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-103733ENRBeverly B Taylor1996-03-12UHC-10404-5048424872458531 Canyon Rd, Mesa, AZ, 852400.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-134693ENRHenry Rios1989-07-25UHC-91003-9561193078572185 Palm Dr Apt 24, San Antonio, TX0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-126822ENRCarol Castillo2004-05-18UHC-75924-1061994112909167 Canyon Rd, Tampa, FL0.50Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
ENR-136227ENRElijah G Yang1990-04-17UHC-90889-134254694345418 Washington St, Las Vegas, NV0.50Name re-casedPhone reformattedState name converted to codeZIP missing+3 more
ENR-100492ENRKevin Fisher1959-11-06UHC-47560-9274571119596403 Oak St, Las Vegas, NV0.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-139925ENRBanks W William1991-07-21UHC-22405-8067274088048775 Valley View Dr, Columbus, OH0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111592ENRAngela Q Sanchez—UHC-92860-1091983854883176 Maple Ave, Tucson, AZ, 857130.50Date of birth missingStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-102074ENRLisa Stewart1947-01-24UHC-45005-8120325376801205 Apache Blvd, Minneapolis, MN, 554270.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-107801ENREmily A Peters1962-08-09UHC-24172-8251846788232414 Union St, Denver, CO, 802670.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-111086ENRAlbert Nunez1981-12-24UHC-51651-67—1681 Union St, Jacksonville, FL0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-110006ENRAmber D Chapman1992-04-28UHC-00847-2326126925458550 Canyon Rd, Tempe, AZ, 852350.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-128855ENREric C Hall1956-12-06UHC-73484-6820329035036838 Maple Ave, Dallas, TX, 752990.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132450ENRElizabeth Meyer1961-06-14UHC-33794-96—6250 Grand Ave, Scottsdale, AZ, 852780.50Name split from “Last, First”Member ID reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-130005ENRSara Armstrong—UHC-69116-9040992417089391 Market St, Dallas, TX0.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127340ENRDiane L Aguilar1956-07-17UHC-44282-2683160172962266 Park Pl, Sacramento, CA0.50Name split from “Last, First”State code upper-casedZIP missingEmail lower-cased+3 more
ENR-117033ENRLuis S Howard1987-09-10UHC-63334-20—744 Harbor Blvd Apt 37, Las Vegas, NV, 891390.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-131599ENRBryan Arnold—UHC-11391-7854962504988219 Central Ave, San Antonio, TX, 782720.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-137843ENRMarilyn T Johnson—UHC-48489-4258561645978315 Willow Ct, Denver, CO, 802940.52Name re-casedDate of birth unreadablePhone reformattedZIP+4 trimmed+2 more
ENR-122667ENRMaria L Ryan1965-03-01UHC-53814-0728981184928437 Lake View Rd, Atlanta, GA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-115594ENRCarl E Morrison1981-05-14UHC-43729-2421027090692448 Central Ave, Seattle, WA, 981380.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
ENR-105613ENRDaniel K Evans1998-08-16UHC-32054-3973575455906814 Willow Ct # 204, Fresno, CA, 937900.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-119432ENRWillie McCoy—UHC-22083-4487598473591428 Cedar Ln, Fresno, CA, 937810.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137049ENRJoey C Lynch1949-03-22UHC-21147-7960676074747688 Church St, Tempe, AZ, 852760.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-108640ENRVictoria N Bell1966-06-07UHC-63670-39—6719 Desert Sky Blvd, Fresno, CA0.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-115105ENRSarah W Olson2000-06-19UHC-48451-8475026043085496 River Rd Apt 31, Seattle, WA, 981810.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-126357ENRAnn P Bishop1950-06-14UHC-44942-9054647802541560 Mountain View Dr, Seattle, WA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-126358ENRAnn P Bishop1950-06-14UHC-44942-9054647802541560 Mountain View Dr, Seattle, WA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-109863ENRKeith F Nguyen—UHC-46334-9450880791446118 Harbor Blvd, Phoenix, AZ, 850780.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112888ENRJustin Gibson2005-01-06UHC-79224-70—8984 Maple Ave, Columbus, OH0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
ENR-141456ENRBrandon Moreno1983-09-07UHC-40927-0645238522881197 Hillcrest Rd, Columbus, OH, 432120.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-121904ENRDorothy W Wagner1999-11-07UHC-27472-49—1607 Forest Ave # 301, Tucson, AZ, 857330.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-112373ENRIsabella Berry1945-04-01UHC-10949-4768639285508659 Sage Ct Apt 37, Tucson, AZ, 857220.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-139404ENRSara Little—UHC-35431-6972676748996080 Mesa Dr, Atlanta, GA, 303270.52Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117512ENRLawrence G Anderson2001-08-07UHC-75461-1958435695676884 Meadow Ln, San Diego, CA0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-105325ENRAustin I Rodriguez1994-10-26UHC-11337-6190743487319749 Mesa Dr # 336, Mesa, AZ, 852880.52Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+2 more
ENR-125963ENRHarold Q Peterson2004-06-22UHC-40852-8332799388607323 Harbor Blvd, Las Vegas, NV, 891910.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-103065ENRJoseph I Moore1968-12-18UHC-87309-8390882735921466 Desert Sky Blvd Apt 20, Dallas, TX, 752390.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-138525ENRPatrick F Ford1995-10-11UHC-51035-4180373028509774 Willow Ct, Tampa, FL, 336870.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-108169ENRNoah Fox1999-04-07UHC-77666-11—4470 Meadow Ln, Dallas, TX, 752860.52Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-135905ENRMaargaret Diaz—UHC-18648-6361620966657146 Willow Ct, Columbus, OH0.52Name re-casedDate of birth unreadablePhone reformattedZIP missing+2 more
ENR-126372ENRMegan Guerrero1963-08-27UHC-90598-755893801480370 Forest Ave # 232, Austin, TX, 787560.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-111138ENRJudith S Owens1944-02-28UHC-30369-2694567313634041 Maple Ave, Fresno, CA, 937820.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-142031ENRBeverly Tran1961-08-17UHC-27198-302719576487112 Canyon Rd Apt 31, Chandler, AZ0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-126586ENRBradley Dainels1951-03-27UHC-82783-2159920174894074 Jefferson Ave, Austin, TX, 787510.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-125852ENRAngela L Wagner1942-12-13——1573 Maple Ave, Tucson, AZ, 857130.52Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-107254ENRJulia Y Morales1986-01-20UHC-43213-7940551220062365 Oak St Apt 2, Plano, TX, 750330.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-139631ENRRonald George1953-09-04UHC-01862-0265988498407249 Palm Dr, Houston, TX, 770960.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
43,101 rows, page 70 of 863PreviousNext