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-133115ENRJudy Woods1985-03-26UHC-47262-5630972786045281 Canyon Rd, Houston, TX, 770980.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-131785ENRHeather Z Medina—UHC-25268-76—7546 Baseline Rd, Charlotte, NC, 282570.54Name split from “Last, First”Date of birth unreadableZIP+4 trimmedPlan code upper-cased+1 more
ENR-125876ENRSaarh Nelson1981-10-23UHC-87307-4037454246882553 Canyon Rd # 780, Eden Prairie, MN, 553450.54Phone reformattedUnit split from streetState name converted to codeZIP+4 trimmed+1 more
ENR-136672ENRAisha Peterson1978-04-07UHC-50378-8283780534951389 Pine Dr, Nashville, TN, 372140.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-136671ENRAisha Peterson1978-04-07UHC-50378-8283780534951389 Pine Dr, Nashville, TN, 372140.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-115466ENRWilliam T Brooks1982-01-07UHC-41838-11—2313 Canyon Rd, Chandler, AZ, 852860.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-121241ENREugene Q Turneer1999-11-14UHC-36409-3245285027475304 Apache Blvd, Las Vegas, NV, 891130.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-116543ENR—Junk—UHC-13913-4068323536542548 Cedar Ln, Eden Prairie, MN, 553400.54Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+1 more
ENR-103167ENRWei Ford2008-01-21UHC-99083-2198040368204584 Washington St, Jacksonville, FL, 322570.54Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-100048ENREric James2006-07-22UHC-28042-5323448375566336 Hillcrest Rd, San Diego, CA, 921450.54Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
ENR-106549ENRJack Marshall1963-06-13UHC-15423-9143026968714285 Main St, Mesa, AZ, 852630.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-135791ENRBrenda E Stewart1958-03-28UHC-39537-9033947915442741 Hillcrest Rd # 366, Miami, FL, 331430.54Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-134949ENRIsabella X George1944-12-24UHC-40296-7475029284332699 Palm Dr, Sacramento, CA, 958280.54Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+1 more
ENR-124028ENRWalter R Stewart1987-11-13UHC-24161-3147342529576528 Camelback Rd, Gilbert, AZ, 852180.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-133531ENRMason McDunald1974-03-23UHC-56620-79—2651 Mountain View Dr Apt 14, Glendale, AZ, 853360.54Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-130522ENRCynthia F Riley2005-03-25UHC-72872-0583050919226028 Pine Dr, Fresno, CA0.54Name split from “Last, First”Phone reformattedZIP missingEmail lower-cased+1 more
ENR-119999ENRMartha L Kim1972-01-20UHC-00401-49—8400 Broadway, San Diego, CA, 921780.54Phone missing area codeSSN last four extractedAddress re-casedState code upper-cased+1 more
ENR-136639ENRGregory Nelson1958-10-28UHC-18210-1720756775255556 Desert Sky Blvd, Glendale, AZ, 853820.54Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
ENR-140521ENRTerry Arnold1941-04-23UHC-90021-6379871583666184 Pine Dr, San Antonio, TX, 782350.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-135488ENRSteven S Perez1970-08-25UHC-15579-3195223884048280 Union St, San Antonio, TX, 782180.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-138595ENRBilly Z Herrera1981-04-28UHC-97480-7176198167623510 Park Pl, Fresno, CA, 937790.54Name split from “Last, First”Phone reformattedSSN last four extractedGender normalised+1 more
ENR-129554ENRAndrew H Burton1970-08-05UHC-88406-1247421450164315 Camelback Rd, Tampa, FL0.54Name split from “Last, First”SSN last four extractedZIP missingEmail lower-cased+1 more
ENR-112797ENRAndrea Franklin1983-11-15UHC-15465-9884122430542792 Ocean Ave, Tempe, AZ, 852550.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-111722ENRIsabella Vargas1986-02-11UHC-15108-515275895476552 Harbor Blvd, Tampa, FL, 336170.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-124783ENRHeather Moarles1942-08-03UHC-30285-90—6122 Baseline Rd Apt 26, Austin, TX, 787080.54Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-123076ENRPatrick Freeman1981-04-01UHC-46779-2677962403578966 Highland Ave Apt 11, San Diego, CA, 921650.54Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-117933ENRHeather P Perez1961-11-18UHC-55402-8164483125348482 Church St # 462, Eden Prairie, MN, 553940.54Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+1 more
ENR-139756ENRAustin H Li1943-07-11UHC-37537-13—4095 Bayshore Dr, Scottsdale, AZ, 852620.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-115998ENRSean A Roberts1959-07-19UHC-73892-4421648101497042 Ocean Ave, Eden Prairie, MN, 553050.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-100503ENREric Sims—UHC-69655-0725357722404759 Oak St, Tampa, FL0.54Date of birth unreadablePhone reformattedState name converted to codeZIP missing+1 more
ENR-114108ENRHannah R Rivera1967-09-15UHC-32282-46—3233 Central Ave, Atlanta, GA, 303090.54Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-123004ENRChristopher E Guerrero1990-08-04UHC-94197-0558638397007502 Forest Ave, Scottsdale, AZ0.54Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-111883ENRJoyce Bwoman1953-08-08UHC-07872-4773096028561658 Canyon Rd, Plano, TX, 750170.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-101184ENREric G Hoffman2007-09-02UHC-44737-8375837807764427 Desert Sky Blvd, Plano, TX0.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-114321ENRTheresa D Turner1970-08-04UHC-58865-8145679462376512 River Rd, San Diego, CA, 921110.54Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+1 more
ENR-103599ENRJack Reed—UHC-42013-97—9195 River Rd, Charlotte, NC, 282550.54Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+1 more
ENR-113386ENRKatherine Romero1960-05-18UHC-26431-2291345580053633 Mountain View Dr, Tampa, FL, 336830.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
ENR-117765ENREugene R Meyer1997-03-06UHC-35995-6355621857619009 Union St, Plano, TX, 750730.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-141622ENRAhmed X Sims1972-07-07UHC-36382-8190044417477759 Harbor Blvd, Dallas, TX, 752570.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-102013ENRSamantha Meyer1992-03-20UHC-98383-40—8827 Main St Apt 35, Chandler, AZ, 852400.54Two-digit birth yearUnit split from streetState name converted to codeWhitespace trimmed+1 more
ENR-120382ENRBryan S Cunningham2003-12-01UHC-70418-3187599615783596 Desert Sky Blvd, Miami, FL, 331150.54Phone reformattedState name converted to codeZIP+4 trimmedGender normalised+1 more
ENR-122494ENRRussell Q Maatthews—UHC-68793-9796843978758711 Union St, San Antonio, TX0.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-100327ENRRoy Wood—UHC-48767-5260672361022733 Sunset Blvd, Gilbert, AZ, 852120.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-102001ENRKayla Medina1953-05-27UHC-08933-32—8044 Forest Ave, Mesa, AZ, 852060.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-103494ENRWatson N Amy1942-07-11UHC-71029-2495527480429190 Apache Blvd Apt 31, San Diego, CA, 921580.54Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+1 more
ENR-120083ENRNancy Marshall1995-12-28UHC-46794-1598574756743906 Grand Ave # 487, Phoenix, AZ, 850870.54Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-113580ENRDavid X Hudson1941-10-26UHC-52527-30—2624 River Rd, San Antonio, TX, 782040.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-126131ENRCarl N Moore1957-06-26UHC-52150-95—4666 Forest Ave, Minneapolis, MN0.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-113006ENRSntiago Garza1994-07-26UHC-94718-7031575055024439 Highland Ave, Atlanta, GA, 303150.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-136911ENRPhilip I Fox1942-06-16UHC-24518-6942745671295198 Baseline Rd, Los Angeles, CA, 900770.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
43,101 rows, page 99 of 863PreviousNext