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-113795ENRPhilip C Rodriuez1953-05-16UHC-24881-73—473 Washington St, Tempe, AZ, 852470.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-121053ENRJason W Vasquez2007-07-06UHC-22579-4688248096674450 Sage Ct # 631, Los Angeles, CA, 900400.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-120965ENRDiane Lewis1952-01-14UHC-42576-07—7809 Broadway, Dallas, TX0.50Two-digit birth yearAddress re-casedCity re-casedZIP missing+3 more
ENR-115733ENRSandra Reyes—UHC-77075-9882491835948178 Market St, Dallas, TX, 752300.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116324ENRAndrew Foster1955-10-12UHC-85895-3263942653306503 Cedar Ln, Las Vegas, NV, 891730.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-128506ENRValentina Jackson1965-01-20UHC-77916-695397472494462 Lake View Rd, Eden Prairie, MN, 553670.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-115143ENRKala S Carter1970-04-24UHC-01830-9840046545633471 Apache Blvd # 448, Miami, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-100424ENRDouglas W George1985-12-18UHC-91044-2921464805329884 River Rd, Tempe, AZ, 852170.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-142600ENRCarl C Simmons—UHC-25020-0889423385955222 Ocean Ave, Denver, CO, 802900.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-133970ENRIsabella R Ferguson1995-12-16UHC-91349-7225875298309627 Ocean Ave, Phoenix, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-119577ENRJoshua V Wallace1990-03-27UHC-69314-9981498658702783 Oak St, Jacksonville, FL, 322150.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-105064ENRBenjamin Burton1970-06-13UHC-06418-8767287885676438 Washington St, Chandler, AZ, 852040.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-113206ENRJoseph Fowler1950-08-18UHC-38879-7223530379967897 Elm St Apt 34, Miami, FL0.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-113569ENRTeresa V Jensen1969-05-24UHC-06673-31—7399 Forest Ave, Los Angeles, CA, 900570.50Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
ENR-117611ENRBradley Peterson—UHC-57031-7141377507917298 Washington St, Miami, FL0.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139060ENRJeremy K Moore1995-09-27UHC-26263-4594557312227041 Willow Ct, Mesa, AZ, 852620.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118174ENRRoss S Keith1939-07-21UHC-82496-4837689744654892 Baseline Rd, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134430ENROlivia G Johnson1971-01-09UHC-35132-0473878299188638 Washington St, Seattle, WA, 981810.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-112216ENRLane S Carol1956-06-01UHC-14000-0257574998277896 Willow Ct, Mesa, AZ, 852500.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-122923ENRCarl Tran1959-06-10UHC-23306-3856435506129834 Desert Sky Blvd, Eden Prairie, MN0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-135959ENRJulie N Garrett1940-06-04UHC-79164-9223331351395021 Pine Dr, San Antonio, TX, 782210.50Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-128573ENRKathryn Sanders1984-05-23UHC-07424-634855737664452 Bayshore Dr # 126, Las Vegas, NV, 891060.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-124929ENRAmber I Fernandez1970-08-14UHC-71712-8160855744801598 Central Ave, Minneapolis, MN, 554930.50Middle initial moved out of first namePhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-142347ENRGary B Hughes1979-03-22UHC-28631-85—3338 Willow Ct, Orlando, FL, 328260.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-123573ENREdwadr Spencer1970-05-03UHC-01211-7378686625746489 Elm St, Seattle, WA0.50Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111638ENRSarah Henderson1972-04-16UHC-24133-9357169004318426 Cedar Ln # 716, Mesa, AZ0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-117416ENRSusan King1980-11-07UHC-87239-1152162626777530 Apache Blvd, Scottsdale, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132288ENRDaniel U Jordan1970-02-07UHC-15360-0155569594702166 Mountain View Dr # 335, Plano, TX, 750150.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-117653ENRCarl Z Allen1998-09-06UHC-59779-2684531334946680 Meadow Ln, Nashville, TN, 372080.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116899ENRJoshua Santiago2006-03-26UHC-23843-59—8004 Mountain View Dr, Charlotte, NC, 282570.50Name split from “Last, First”Two-digit birth yearMember ID reformattedStreet suffix standardised+3 more
ENR-116898ENRJoshua Santiago2006-03-26UHC-23843-59—8004 Mountain View Dr, Charlotte, NC, 282570.50Name split from “Last, First”Two-digit birth yearMember ID reformattedStreet suffix standardised+3 more
ENR-110477ENRDeborah E Black1952-07-11UHC-14123-8827278449956026 Palm Dr # 297, Sacramento, CA, 958860.50Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
ENR-127384ENRJacqueline N Vargas1983-07-26UHC-67158-7522749800119060 Mesa Dr, Houston, TX0.50Date of birth reformattedPhone reformattedCity re-casedState name converted to code+3 more
ENR-126510ENRMarcus X Bishop2007-09-13UHC-31910-589556941252853 Park Pl, Gilbert, AZ, 852030.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109220ENRSofia Kim2007-02-04UHC-90210-5459724037088467 Elm St, Gilbert, AZ, 852570.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123756ENRAnna Z Hudson1938-04-27UHC-12146-8627029100971281 Market St, Tucson, AZ0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131155ENRYuki T Johnson1960-07-06UHC-34539-0825680280668287 Apache Blvd Apt 11, Columbus, OH, 432550.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-112912ENRJulie P Soto—UHC-12423-0333144941208093 Jefferson Ave, San Diego, CA, 921880.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-119978ENRSJunk1940-03-22UHC-56448-4978266113229120 Harbor Blvd, Miami, FL, 331210.50Member ID reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
ENR-107261ENRKathryn Y Lawsoon1941-09-02UHC-96469-2343961185596143 Washington St Apt 3, San Antonio, TX, 782740.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-107435ENREric Fuller1975-09-21UHC-24655-87—8373 Market St, San Diego, CA, 921900.50Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-109285ENRMadison M Thompson1995-01-11UHC-19680-9331035059939482 Highland Ave, San Antonio, TX, 782490.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118717ENRWei Moore1956-01-25UHC-46942-2347159825385844 Baseline Rd, Los Angeles, CA0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103543ENRMarilyn Palmer—UHC-43877-855445616647617 Camelback Rd, Las Vegas, NV, 891720.50Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-133465ENRMark Hernandez2000-11-13UHC-59408-4992275188376600 Elm St, Gilbert, AZ, 852560.50Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+3 more
ENR-110649ENRKathryn Perry1971-07-27UHC-90777-0576949111174230 Pine Dr Apt 4, Atlanta, GA0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-110449ENRJoyce Sanders1954-07-12UHC-76833-5291869993141135 Harbor Blvd Apt 16, San Antonio, TX, 782720.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-120813ENROmar F Dunn1981-11-14UHC-59784-8694780147415238 Union St, Chandler, AZ, 852300.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137156ENRVincent L West2003-01-17UHC-43500-5938637833658724 Central Ave Apt 7, Plano, TX, 750110.50Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-136235ENRGary A Ross1970-06-13UHC-20327-4780153407476125 Sunset Blvd, Columbus, OH0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
43,101 rows, page 56 of 863PreviousNext