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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-106211ENRZachary G Jimenez1982-08-04UHC-69199-85—4427 Valley View Dr, Plano, TX, 750100.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-419843CLMLuis Holmes1967-11-14UHC-39290-46—6193 Mesa Dr # 433, Dallas, TX, 752380.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-118847ENRJordan Stone1989-11-22UHC-29838-90—2253 Sage Ct, Fresno, CA0.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-111584ENRArnold Eugene1945-12-07UHC-30243-3862960559458379 Valley View Dr # 593, Gilbert, AZ, 852040.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-403854CLMMargaret Torres1995-06-22UHC-34210-05—1549 Ridge Rd, Jacksonville, FL, 322920.54Name split from “Last, First”City re-casedZIP+4 trimmedGender normalised+1 more
ENR-117437ENRCarl Park1963-01-14UHC-65013-1963725633939297 Ocean Ave, Fresno, CA, 937410.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
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
CLM-420711CLMKathleen Castillo1998-11-21——3704 Sage Ct, Dallas, TX0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+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
CLM-405176CLMCharles G Jenkins1977-07-28UHC-72962-24—7771 Forest Ave # 660, Fresno, CA0.54Date of birth reformattedUnit split from streetZIP missingGender normalised+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
TPA-60399TPAEric Simposn1998-10-18——8776 Canyon Rd, Columbus, OH, 432890.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
PRV-26528PRVEmily Bennett1981-02-04—39866428035579 Lake View Rd, Fresno, CA, 937230.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+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
TPA-58670TPASarah Nelson———2553 Canyon Rd Apt 19, Eden Prairie, MN, 553450.54Name re-casedDate of birth unreadableUnit split from streetState name converted to code+1 more
TPA-57216TPABenjamin Lee2006-09-23——5582 Valley View Dr, Houston, TX, 770950.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-415427CLMCheryl Q Walker1944-07-15UHC-28401-8073620812697688 Valley View Dr, San Antonio, TX, 782560.54Name split from “Last, First”Phone reformattedSSN last four extractedGender normalised+1 more
CLM-415022CLMJeremy K Franklin1984-05-15UHC-73727-24—4598 Canyon Rd, Tempe, AZ, 852430.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+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
CLM-417836CLMMichael Lynch1940-03-05UHC-82219-8483254944104883 Park Pl, Tempe, AZ, 852020.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+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
CLM-416432CLMDouglas Burns1994-09-24——344 Church St, Fresno, CA, 937860.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-419189CLMAustin Clark2007-06-05UHC-09557-645915446811—0.54Two-digit birth yearPhone reformattedSSN last four extractedGender normalised+1 more
CLM-404685CLMPat Castillo—UHC-12275-948154560222106 Ridge Rd, Nashville, TN0.54Name re-casedDate of birth unreadableState name converted to codeZIP missing+1 more
TPA-51056TPAMary Allen1974-10-02UHC-94733-16—4111 Grand Ave # 224, Eden Prairie, MN, 553680.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+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
PRV-26059PRVMason V Sanchez1953-01-04——1884 Forest Ave, San Antonio, TX, 782780.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+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
CLM-431669CLMMichael A Howard1947-06-26UHC-16390-23—2431 Park Pl, Las Vegas, NV, 891510.54Name split from “Last, First”Two-digit birth yearMember ID reformattedState name converted to code+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
CLM-418272CLMShirley P Morgan1997-05-16——3737 Meadow Ln, Charlotte, NC0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+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
CLM-409671CLMJeffrey Garza1979-09-09UHC-77639-01—6249 Mesa Dr, Atlanta, GA, 303660.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-28764PRVWeaver Danielle1971-06-27UHC-98676-06—724 Palm Dr, Atlanta, GA, 303410.54Name split from “Last, First”Two-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
CLM-430039CLMTimothy P George1941-06-24UHC-62919-0124128137854259 Valley View Dr, San Diego, CA0.54Middle initial moved out of first nameState name converted to codeZIP missingWhitespace trimmed+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
TPA-53366TPABrittany Knight1950-10-10——3394 Mesa Dr, Columbus, OH, 432810.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+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
100,000 rows, page 199 of 2,000PreviousNext