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-137351ENRHarold B Sanders2006-04-26UHC-57938-526742296498498 Park Pl # 337, Sacramento, CA, 958130.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-122916ENRHelen Wallace2006-03-25UHC-46407-62—8344 Mountain View Dr, Phoenix, AZ, 850290.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-126755ENREvelyn Ramos—UHC-70497-0763956033258644 Elm St, Plano, TX0.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109888ENRJuan Tran2007-06-20UHC-08444-394312024556354 Central Ave # 791, Plano, TX, 750470.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-101149ENRKayla M Chavez—UHC-09981-9935497272098478 Oak St Apt 10, Las Vegas, NV, 891980.52Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-101975ENRAmy R Hawkins1994-05-13UHC-63576-0987031731426772 Hillcrest Rd Apt 11, Charlotte, NC, 282670.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-130316ENRKatherine H Rose—UHC-31860-41—2876 Oak St, Denver, CO, 802210.52Name re-casedDate of birth missingPhone missing area codeStreet suffix standardised+2 more
ENR-114962ENRHeather Garza1983-04-15UHC-85505-9362794808197382 Baseline Rd, Phoenix, AZ, 850130.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-130367ENRGrace Montgomery1984-02-21UHC-74716-175928770083592 Mountain View Dr, Fresno, CA, 937790.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-101874ENRKeelly Williamson2002-09-08UHC-46667-3074726156009407 Union St, Chandler, AZ0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-125082ENRBarbara Espinoza1953-03-07UHC-74131-0292742972741702 Lincoln Way, Jacksonville, FL, 322140.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111330ENRGeorge Patterson1983-02-09UHC-34242-4860851256235376 Central Ave # 493, San Antonio, TX, 782050.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-114606ENREric T Bowman1950-05-23UHC-56333-0545093036058419 Central Ave # 287, Nashville, TN, 372960.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-129562ENRTheresa U Hicks1969-02-09UHC-01574-14—1799 Highland Ave, Jacksonville, FL, 322080.52Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+2 more
ENR-106103ENREthan I Wright1967-03-17UHC-95641-0540841100638968 Main St, Mesa, AZ, 852980.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-130684ENRKevin X Guerrero1985-05-16UHC-46668-3634878413902840 Apache Blvd, Dallas, TX0.52Two-digit birth yearPhone reformattedZIP missingGender normalised+2 more
ENR-113108ENRLori T Ward1965-06-23UHC-57208-30—5185 Maple Ave, Denver, CO, 802710.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
ENR-127855ENRBetsy Parker1941-06-22UHC-00177-45—1852 Cedar Ln, Seattle, WA, 981410.52Member ID reformattedState name converted to codeZIP+4 trimmedGender normalised+2 more
ENR-108749ENRGabriel P Carter—UHC-25374-6642966360117602 Spring St, Scottsdale, AZ, 852820.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-127310ENRBryan Graham1999-09-04UHC-39222-6676564482296502 Market St # 568, Charlotte, NC, 282390.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-126441ENRKeith I Bailey1986-02-12UHC-91055-8448394324011902 Park Pl, Seattle, WA0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-128823ENRElijah N Payne2000-07-03UHC-20841-62—7940 Hillcrest Rd, Gilbert, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-113922ENRAustin Pena—UHC-44306-4956924067195302 Mountain View Dr, Glendale, AZ0.52Name re-casedDate of birth unreadablePhone reformattedZIP missing+2 more
ENR-126621ENRAmber T Wellls1939-12-20UHC-53150-3061226333917373 Jefferson Ave, Chandler, AZ, 852150.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112534ENRJakke K Harvey1986-07-03UHC-64879-3431433357705435 Highland Ave, Miami, FL0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
ENR-102426ENRIsabella Bowman1953-10-22UHC-75417-10—1711 Union St, Chandler, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-130397ENRKlye Harper1997-08-03UHC-68942-5726798013311435 Jefferson Ave Apt 25, Gilbert, AZ, 852940.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-108724ENRGabriel R Ross1982-07-27UHC-82385-4341237472435064 Mesa Dr, Sacramento, CA, 958750.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-108725ENRGabriel R Ross1982-07-27UHC-82385-4341237472435064 Mesa Dr, Sacramento, CA, 958750.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-136737ENRShirley Spencer1968-09-14UHC-49565-9855785124584384 Lincoln Way Apt 22, Fresno, CA, 937800.52Phone reformattedUnit split from streetCity re-casedState name converted to code+2 more
ENR-112438ENRSandra Spencer1981-03-07UHC-91154-1163272312922833 Willow Ct Apt 16, Chandler, AZ, 852920.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-117265ENRRonald D Daniels1943-03-18UHC-95529-06—2498 Oak St Apt 33, Plano, TX, 750330.52Name re-casedMember ID reformattedUnit split from streetZIP+4 trimmed+2 more
ENR-112667ENRWilliam V Vega1954-01-12UHC-29188-4533696585636214 Main St, Chandler, AZ0.52Phone reformattedState name converted to codeZIP missingGender normalised+2 more
ENR-122295ENRFrances R Bryant1955-04-02UHC-39441-1451371054183296 Lake View Rd, Minneapolis, MN, 554460.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-139557ENRJesse D Wang1951-05-04UHC-64399-8056279037914970 Grand Ave # 581, Chandler, AZ, 852450.52Middle initial moved out of first namePhone reformattedSSN last four extractedUnit split from street+2 more
ENR-130437ENRJennifer G Aguilar1942-11-23——3751 Forest Ave, Los Angeles, CA, 900610.52Phone missing area codeState name converted to codeZIP+4 trimmedEmail lower-cased+2 more
ENR-105409ENRAnna D Moore—UHC-72564-3294827504194022 Sage Ct, Plano, TX, 750070.52Name re-casedDate of birth missingPhone reformattedZIP+4 trimmed+2 more
ENR-104037ENRAndrew Little1958-05-10UHC-87409-1959466731457294 Spring St, Chandler, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-109526ENRHeather K Arnold1939-10-06UHC-93459-9753681911236480 Lincoln Way # 698, San Diego, CA, 921950.52Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+2 more
ENR-113707ENRYJunk1945-01-20UHC-61792-31—9312 Indian School Rd, Orlando, FL0.52Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+2 more
ENR-118282ENRMason G Young1971-01-20UHC-08186-30—1217 Oak St, Tempe, AZ, 852620.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-113864ENRPhilip Butler1980-02-07UHC-93273-2648199636786519 Baseline Rd, Jacksonville, FL0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121090ENREthan Warren1983-03-11UHC-72208-5052189030193131 Elm St, Sacramento, CA, 958030.52Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
ENR-119437ENRScott D Bryant1972-08-07UHC-95355-1339435881502176 Broadway, San Antonio, TX, 782000.52Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+2 more
ENR-124921ENRLauren Washington1965-10-28UHC-74755-05—6518 Harbor Blvd, Scottsdale, AZ, 852320.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-108517ENRJohn K Price1938-06-23UHC-15883-4067573164048990 Canyon Rd, Tucson, AZ, 857810.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-135374ENRThomas M Anderson1965-04-13UHC-56943-8053929789874269 Oak St, Tucson, AZ0.52Name re-casedPhone reformattedSSN last four extractedState name converted to code+2 more
ENR-124140ENRRachel Fields—UHC-87438-08—3746 Valley View Dr, Gilbert, AZ, 852100.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-107274ENRNathan Tucker1982-07-18UHC-69609-125058955843573 Union St, Houston, TX, 770090.52Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-106259ENRMegan Andrews1962-05-13UHC-94788-82—8147 Mesa Dr Apt 13, Jacksonville, FL, 322330.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
43,101 rows, page 95 of 863PreviousNext