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-107689ENRSofia O Duncan1938-06-28—75764232812365 River Rd, Denver, CO, 802170.54Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+1 more
ENR-120240ENRWillam H Thomas1950-10-27UHC-66305-2443769976618887 Palm Dr, Miami, FL0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-114156ENRBryan West—UHC-06733-8798188146835578 Main St, Minneapolis, MN, 554200.54Date of birth unreadableStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
ENR-139720ENRSteven M Griffin2008-09-14UHC-95954-44—1826 Central Ave, Sacramento, CA, 958390.54Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-126812ENRAhmed Reid1947-12-15UHC-00042-2591923527533342 Grand Ave, Glendale, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-131422ENRFatiima Hernandez—UHC-60097-8171440032978969 Apache Blvd, Mesa, AZ0.54Name split from “Last, First”Date of birth missingPhone reformattedCity re-cased+1 more
ENR-114339ENRMariana T McDonald1963-02-15UHC-89548-2639131929296528 Sunset Blvd, Minneapolis, MN, 554590.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-134740ENRJennifer Williamson1977-01-02UHC-04711-3794041445315587 Apache Blvd Apt 18, Denver, CO, 802900.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-103252ENRPeter Scott1950-11-02UHC-43722-10—2722 Mesa Dr, Scottsdale, AZ, 852170.54Phone missing area codeSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-108797ENRAna F Rojas1971-07-05UHC-82015-88—2168 Meadow Ln Apt 31, Mesa, AZ, 852140.54Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-141798ENREdward O Santos1980-10-27UHC-53994-50—7324 River Rd, Charlotte, NC, 282490.54Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-117509ENRSharon G Andrews1986-06-02UHC-97557-33—8169 Main St, Fresno, CA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-139674ENRGary Wagner1964-06-27UHC-71648-5788434145977160 Desert Sky Blvd, San Antonio, TX, 782610.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
ENR-100769ENRAnthony Y Nunze1991-07-06UHC-25307-4679370436546717 Valley View Dr, Austin, TX, 787070.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-104847ENRJennifer Anderson1975-07-27UHC-24465-0742344909213368 Willow Ct, Orlando, FL, 328930.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-110524ENRAshey O Fernandez2003-03-19UHC-00933-5937768500036961 Lake View Rd Apt 31, Fresno, CA, 937930.54Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-137999ENRWalter Payne1960-04-08UHC-73011-94—1587 Camelback Rd Apt 33, Tempe, AZ, 852290.54SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-126160ENRGery Q Nelson1968-12-10UHC-97451-6791661211821869 Oak St, San Diego, CA, 921560.54Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-116253ENRMarcus B Cooper1952-08-23UHC-91372-6081079172101213 Indian School Rd, Glendale, AZ, 853150.54Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
ENR-109412ENRSara L Fields—UHC-44926-42—1134 Union St, Austin, TX, 787070.54Name re-casedDate of birth unreadablePhone missing area codeGender normalised+1 more
ENR-104840ENRDiane Y Robinson1940-05-24UHC-27610-05—6707 Spring St # 180, Orlando, FL, 328060.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-118983ENRDiego F Ramos2004-01-13UHC-29121-61—4134 Maple Ave, Sacramento, CA, 958010.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-100449ENRKeyla Coleman1975-01-03UHC-81024-3561525513141530 Apache Blvd, Tampa, FL, 336060.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-119500ENRAustin Wood—UHC-01868-34—5714 Cedar Ln, Atlanta, GA, 303560.54Name split from “Last, First”Date of birth unreadableGender normalisedWhitespace trimmed+1 more
ENR-113835ENRSofia P Welch2005-09-24UHC-60104-27—9888 Main St, Eden Prairie, MN, 553300.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-100916ENRDylan B Scott1971-07-22UHC-89866-965498214267450 Pine Dr, Houston, TX, 770480.54Name split from “Last, First”Phone reformattedSSN last four extractedGender normalised+1 more
ENR-141252ENRLucia E Foster1941-02-06UHC-10708-39—9138 Lincoln Way, Las Vegas, NV0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-104415ENRWayne H Wang1963-02-23UHC-60912-66—9494 Market St, Jacksonville, FL, 322930.54Phone missing area codeSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-105948ENRRuth M Grant—UHC-11219-5884425253696335 Forest Ave, Tempe, AZ, 852350.54Name split from “Last, First”Date of birth unreadablePhone reformattedCity re-cased+1 more
ENR-111682ENRMelissa W Willis2001-11-16UHC-20645-30—2108 Sage Ct, Atlanta, GA0.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-108221ENRJennifer D Reyes1991-01-16UHC-48924-0944372372675349 Valley View Dr, Plano, TX, 750060.54Name split from “Last, First”Middle initial moved out of first namePhone reformattedState name converted to code+1 more
ENR-112718ENRJoshua B Hoffman—UHC-75819-13—4968 Indian School Rd, Austin, TX, 787250.54Name re-casedDate of birth missingPhone missing area codeGender normalised+1 more
ENR-117869ENRJoshua Cooper1962-10-20UHC-54359-8241352067448269 Pine Dr, Nashville, TN, 372340.54Name re-casedTwo-digit birth yearState name converted to codeZIP+4 trimmed+1 more
ENR-106579ENRAndrew V Reyes1977-12-22UHC-82778-2076286172866345 Ridge Rd, Eden Prairie, MN, 553680.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-118134ENRLinda Z Vargas1986-06-11UHC-27818-1691880994949669 Mountain View Dr # 288, Scottsdale, AZ, 852050.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-141571ENRSophia Jacobs1941-04-15UHC-74205-24—8862 Bayshore Dr Apt 26, Mesa, AZ, 852090.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-106331ENRAnthony Jackson1989-12-17UHC-88124-0393353858695099 Valley View Dr, Charlotte, NC, 282250.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-137400ENREmma Y Alvarez1980-08-14UHC-46560-0369567289411553 Bayshore Dr, Houston, TX, 770980.54Name re-casedTwo-digit birth yearState name converted to codeEmail lower-cased+1 more
ENR-104187ENRGeorge J Willis1939-10-03UHC-36586-6477544868014974 Maple Ave, Phoenix, AZ0.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-128354ENRJuan H Gonzalez1998-07-01UHC-25304-69—1356 Baseline Rd, Glendale, AZ, 853160.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-107588ENRKelly Wong2007-06-01UHC-18814-7356645624927943 Pine Dr, Dallas, TX0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-128222ENRJulie M Singh1975-08-19UHC-47477-3482579441274749 Maple Ave, Fresno, CA, 937210.54Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedState name converted to code+1 more
ENR-124938ENRNoah Ford1992-05-17UHC-06491-63—1617 Market St, Chandler, AZ0.54Name split from “Last, First”Phone missing area codeZIP missingWhitespace trimmed+1 more
ENR-139067ENRChristian Duncan1986-08-20UHC-25272-9946231833492753 Mountain View Dr, Los Angeles, CA, 900020.54Name split from “Last, First”Two-digit birth yearPhone reformattedEmail lower-cased+1 more
ENR-124243ENRRyan L Hunter1965-10-05UHC-48235-6397264298277479 Forest Ave, Charlotte, NC0.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-141786ENRDavid Q Hunter1957-02-20—81631339709047 Harbor Blvd, Las Vegas, NV0.54Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-141787ENRDavid Q Hunter1957-02-20—81631339709047 Harbor Blvd, Las Vegas, NV0.54Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-107751ENRDorothy Wagner1953-08-05UHC-38841-8324249755384345 Market St, Columbus, OH0.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-101397ENRJon Castillo1960-04-13UHC-72136-56923695623553 Apache Blvd # 443, Seattle, WA, 981110.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-117681ENRNoah Bryant1960-02-06UHC-04206-0298292842657257 Camelback Rd, Tempe, AZ0.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
43,101 rows, page 108 of 863PreviousNext