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-132146ENRMary H Nguyen1990-03-12UHC-55840-85—7858 River Rd, Los Angeles, CA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-132145ENRMary H Nguyen1990-03-12UHC-55840-85—7858 River Rd, Los Angeles, CA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-108140ENRJerry S Meyer1955-02-05UHC-94668-4768188037806076 Pine Dr, Plano, TX, 750710.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-118692ENRAdam Green2003-05-12UHC-08215-14—731 Market St, Austin, TX, 787430.52Name split from “Last, First”Phone missing area codeState code upper-casedZIP+4 trimmed+2 more
ENR-130994ENRElijah Alexander2005-04-15UHC-94455-0882134866162219 Palm Dr, Seattle, WA0.52Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-102111ENRSophia Fox1973-06-20UHC-96989-3249894044105249 Sage Ct, Houston, TX0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109012ENRRuth E Harvey1940-10-13UHC-80628-18—5958 Main St Apt 32, Gilbert, AZ, 852250.52Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+2 more
ENR-107715ENRBenjamin W Brown1951-08-19UHC-16254-0688480624639444 Union St, Mesa, AZ, 852840.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-109109ENRMarilyn H Herrrera1959-02-03UHC-34250-0528437424609296 Ridge Rd, Orlando, FL, 328340.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-114754ENRBryan Morrison1992-11-17UHC-63751-61—2645 Harbor Blvd Apt 40, Seattle, WA, 981550.52Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
ENR-115920ENRJess K Stephens1948-06-15UHC-76732-26—9811 Canyon Rd, Eden Prairie, MN, 553400.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-115117ENRJerry L Riey1941-10-02UHC-25201-66—4607 Pine Dr, Charlotte, NC, 282140.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-117558ENRStephanie Knight1950-11-05UHC-08962-3852489639256930 Main St, Gilbert, AZ, 852840.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-118552ENRBenjamin Moore—UHC-21155-1224564250658078 Meadow Ln, Jacksonville, FL, 322850.52Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+2 more
ENR-126172ENRAna TJunk1940-12-03UHC-78398-3248232537067129 Washington St, Orlando, FL, 328300.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-130984ENRBradley Z Lawrence1954-01-17UHC-30637-6329937092656725 Valley View Dr Apt 6, Atlanta, GA, 303650.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-138211ENRHeather Nelson1977-12-27UHC-32033-8893445338183480 Main St # 814, Plano, TX0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-142089ENRBobby T Bailey1943-08-01UHC-45632-4931460302802275 Baseline Rd, Plano, TX, 750320.52Middle initial moved out of first nameTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-132080ENRJudy X Walker1964-12-08UHC-62518-6361757550141921 Grand Ave, Fresno, CA, 937280.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-115901ENRSofia Anderson1967-01-26UHC-62309-8681541758395335 Forest Ave, Fresno, CA, 937620.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-123483ENRMichael Q Santiago1982-03-19UHC-18032-1224729443226144 Indian School Rd # 650, Atlanta, GA, 303130.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-121827ENRBeverly D Wodos—UHC-61084-844206867407715 Willow Ct, Chandler, AZ, 852770.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126777ENRNick V Jones1987-04-25UHC-74859-2032967397392080 Valley View Dr, Nashville, TN0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-124107ENRPatricia I Edwards1990-08-27UHC-40472-1330179064481996 Elm St, Tampa, FL, 336610.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111833ENRJoan F Jacobs1985-03-01UHC-79278-16—4384 Cedar Ln, Miami, FL, 331330.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-139288ENRChrristian Ruiz2004-06-11UHC-87732-2765236601645969 Willow Ct, Gilbert, AZ, 852360.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-114511ENRDoris Yang1968-12-03UHC-09369-7922824482213736 Pine Dr, Phoenix, AZ, 850140.52Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-129111ENRKevin Reyes1938-04-09UHC-54672-045716478007172 Sage Ct, Seattle, WA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-129112ENRKevin Reyes1938-04-09UHC-54672-045716478007172 Sage Ct, Seattle, WA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117546ENRLogan Y Gonzales1986-07-13UHC-19729-25—6025 River Rd, Orlando, FL, 328990.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-118590ENREmma Hudson1975-12-12UHC-78903-5596226915425153 Sunset Blvd, Phoenix, AZ, 850850.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-121403ENRChristian Y Castillo1973-10-17UHC-97898-4469937274185226 Mountain View Dr, San Diego, CA, 921230.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-122077ENRAaron D Clark1940-11-08UHC-73956-3041581406151800 River Rd Apt 39, Charlotte, NC, 282020.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-128465ENRBilly Z Castillo1961-03-08UHC-03191-11—4676 Harbor Blvd, Atlanta, GA, 303990.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-119543ENRRandy Meyer1984-07-26UHC-39293-8870726199052773 Mountain View Dr, Tucson, AZ, 857530.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-107102ENRVirginia N Smith2001-07-22UHC-62024-7389023009519017 Palm Dr, Atlanta, GA, 303820.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102670ENRSandra F Wong1991-10-17UHC-64829-08—2833 Ocean Ave, Orlando, FL, 328450.52Two-digit birth yearMember ID reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-125757ENRGeorge J Cooper1988-06-04UHC-06641-6246780914015636 Willow Ct, Tampa, FL, 336690.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103812ENRBruce L Campbell2000-03-02UHC-55606-0737641560827816 Desert Sky Blvd, Atlanta, GA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-115166ENRNancy Willis1990-11-10UHC-80349-4992588121407572 Bayshore Dr, Los Angeles, CA, 900790.52Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-123999ENRJuan S Estrada1965-08-13UHC-86762-06—1448 Main St, Jacksonville, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-115968ENRStephen Hayes1954-03-20UHC-21260-7064334714673539 Union St, Scottsdale, AZ, 852030.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-135484ENRBeverly Andrews1967-12-18UHC-52608-7951663472462649 Canyon Rd Apt 13, Nashville, TN, 372990.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-116372ENRMateo Garza1977-06-20UHC-27538-3572274710496866 Central Ave, Atlanta, GA, 303520.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-100774ENRJudith J Chavez1947-08-17UHC-03402-97—3704 Sunset Blvd Apt 2, Orlando, FL, 328930.52Name split from “Last, First”Date of birth reformattedUnit split from streetCity re-cased+2 more
ENR-104951ENRGerald F Miller1983-04-03—85063317603450 Maple Ave Apt 39, Denver, CO, 802180.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-118628ENRJessica N Pena1967-12-17UHC-66466-5370296773636112 Washington St, Fresno, CA, 937460.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-138761ENRMelissa Y Delgado2007-07-28UHC-61902-2147350654615380 Apache Blvd, Fresno, CA, 937690.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117798ENRHeather Ramirez1985-09-07UHC-96401-9467566956873843 Main St, Plano, TX, 750500.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137881ENROlivia Montgomery—UHC-04428-7988561618369665 Market St Apt 40, Gilbert, AZ, 852000.52Name re-casedDate of birth unreadablePhone reformattedUnit split from street+2 more
43,101 rows, page 90 of 863PreviousNext