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-136509ENRMelissa P Ford1981-04-14UHC-87445-8951234809521213 Washington St, Houston, TX, 770470.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-105742ENRCarl A Hoffman1941-12-11UHC-12474-9990121726837522 Indian School Rd, Miami, FL, 331850.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-108463ENRJudith Olsoon1966-04-11UHC-31184-6835168610684157 Hillcrest Rd # 811, Phoenix, AZ, 850230.50Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+3 more
ENR-100666ENRJoyce B Knnedy1941-11-27UHC-84403-88—8996 Canyon Rd, Austin, TX, 787130.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-139439ENRLawrence Hoffman1971-02-10UHC-12016-6595394320235415 River Rd, Minneapolis, MN, 554160.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118387ENRMichelle Fileds1963-05-19UHC-78616-925967565808981 Main St, Gilbert, AZ0.50Date of birth reformattedPhone reformattedSSN last four extractedState name converted to code+3 more
ENR-121303ENRAisha Bryant1957-04-26UHC-82316-023532939439644 Ocean Ave, San Diego, CA, 921070.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-139312ENRArthur A Nichols1942-09-26UHC-48023-8995579254991576 Mountain View Dr, Columbus, OH0.50Two-digit birth yearPhone reformattedCity re-casedZIP missing+3 more
ENR-107077ENRMaria P Ramos1948-07-08UHC-85846-5046227164644261 Maple Ave, Tucson, AZ, 857070.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108001ENRLinda V Fields1968-10-11UHC-49146-7890970737041120 Pine Dr, Phoenix, AZ, 850810.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-142624ENRBrenda Medina1975-11-01UHC-58038-13—3908 Sage Ct, Sacramento, CA, 958620.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-130606ENRBetty Gray1982-10-01UHC-11992-1626895511811627 Mesa Dr, Miami, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109996ENRLaura I Chen2005-07-06UHC-72517-6854633912249250 Valley View Dr, Houston, TX, 770680.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-122070ENRAnthony Jackson1996-11-11UHC-47435-5370849711047175 Mesa Dr Apt 24, Dallas, TX, 752630.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-129692ENRDennis Collins2001-07-15UHC-50198-7326893598134690 Ocean Ave, Dallas, TX, 752800.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-140213ENRRuth V Snyder2002-08-13UHC-67308-5697145122618202 Highland Ave, Nashville, TN0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-136439ENRCarlos Hayes1970-05-15UHC-95618-9864068643083353 Main St, Atlanta, GA0.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-111816ENRWilliam Stone1939-11-11UHC-64855-0372493573385825 Spring St, Charlotte, NC0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122311ENRJacob J Smith—UHC-64359-98—4760 Canyon Rd, Atlanta, GA, 303610.50Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+3 more
ENR-132191ENRJuan Carter1949-07-13UHC-46842-5859793099137349 Pine Dr, Charlotte, NC, 282290.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129801ENRJoe Z Obrien1938-06-20UHC-91026-532615953563832 Oak St, Jacksonville, FL, 322880.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-138331ENRMegan Jordan—UHC-30587-3333885883912809 Valley View Dr, Atlanta, GA, 303190.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111247ENRBobby O Hanson2001-03-07UHC-43003-2798947918415986 Forest Ave, Houston, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116995ENRCheryl Guzman2008-10-09UHC-71613-4296771662589620 Main St # 128, Minneapolis, MN0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-138668ENRGeorge F Walker2006-09-14UHC-22901-2487294236054176 Washington St, Sacramento, CA, 958640.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-107649ENRRachel G Long1987-01-10UHC-19067-7235372248171076 River Rd Apt 12, Mesa, AZ0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-129432ENRMichael Grant1978-08-20UHC-99299-0360944518705329 Palm Dr, Las Vegas, NV, 891040.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-117151ENRPatrick Perez1975-05-24UHC-74189-6848755718966266 Cedar Ln, Gilbert, AZ0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-119394ENREmma K Brooks1972-05-01UHC-09562-952039757599453 Canyon Rd, Sacramento, CA0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132266ENRMarcus Q Brown1977-03-14UHC-58114-5825343908553581 Bayshore Dr, Plano, TX, 750450.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-126673ENRLaura Walsh1952-02-18UHC-49583-56—7897 Palm Dr, Plano, TX, 750110.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-136040ENRBarbara F Armstrong—UHC-32868-1877558539344485 Canyon Rd, Dallas, TX, 752600.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-128376ENRStephen Bowman1994-02-08UHC-77717-8946154512298981 Pine Dr, Plano, TX, 750800.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-142143ENRAlan Hart—UHC-90707-5742028080585735 Elm St, Denver, CO0.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121845ENRChristopher RJunk1963-03-15UHC-54205-35—5048 Indian School Rd, Las Vegas, NV0.50Street suffix standardisedAddress re-casedState code upper-casedZIP missing+3 more
ENR-142895ENRKenneth Y Black1982-04-26UHC-44296-79—4825 Valley View Dr, Orlando, FL, 328040.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109692ENRStephanie T Bishop1982-12-17UHC-68940-4172770180295282 River Rd, Las Vegas, NV, 891630.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-106856ENRRuht Gray1970-01-21UHC-61211-20—2395 Cedar Ln, Charlotte, NC, 282900.50Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+3 more
ENR-106869ENRDorothy Moreno1944-06-07UHC-95806-4580336582104861 Washington St, Gilbert, AZ, 852390.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-117600ENRDoris Mendoza1955-09-11UHC-31677-40—1438 Spring St, Houston, TX, 770230.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-133562ENRJack Kennedy1955-03-14UHC-82804-5781198035531930 Valley View Dr, Orlando, FL0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-138347ENRAlan E Nelson1946-12-20UHC-18575-5086520422925466 Canyon Rd, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127509ENRJacqueline L Campbell1942-06-26UHC-50807-8734893756481998 Broadway # 806, Seattle, WA, 981190.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-133715ENRBilly L Nuunez2002-05-24UHC-37928-09—3112 Desert Sky Blvd, Miami, FL, 331960.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-112270ENRRandy J Lewis2008-07-27UHC-17476-8770052686084551 Oak St, Atlanta, GA0.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-124400ENRWalter Hoffman1965-04-17UHC-83616-6737633379551445 Meadow Ln, Tempe, AZ, 852320.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112021ENRAna Jackson1950-11-11UHC-49207-2653486131249519 Indian School Rd, Tucson, AZ, 857680.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-106271ENRLucia Jenkins1993-12-04UHC-65576-3665046858951182 Main St, Glendale, AZ, 853170.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-124161ENRDoris I Chavez1966-09-12UHC-21944-4466863057346224 Grand Ave, Phoenix, AZ, 850140.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126994ENRMichelle D Murphy1951-01-17UHC-22881-1941387678392070 Valley View Dr, Scottsdale, AZ, 852090.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 57 of 863PreviousNext