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-120007ENRRoy K Snyder1975-04-16UHC-03945-17—3787 Jefferson Ave # 531, Seattle, WA, 981510.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-108051ENRDonald Meyer1987-07-10UHC-63332-2985295180135980 Washington St # 386, Columbus, OH, 432110.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-107187ENRBilly J Crawford1958-10-03UHC-98380-2422422059208274 Market St, Sacramento, CA, 958160.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-101637ENRJeffrey Q Parker1957-09-12UHC-89349-27—408 Oak St, Orlando, FL, 328580.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-113446ENROmar T Matthews1974-12-10UHC-66764-3388834316187558 Washington St Apt 10, Chandler, AZ, 852520.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-125074ENRGerald Little—UHC-94042-5169159416523476 Ocean Ave, Columbus, OH, 432970.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-102391ENRCarolyn Jimenez1943-02-17UHC-13964-6144182283487201 Meadow Ln # 227, Houston, TX, 770540.52Date of birth reformattedUnit split from streetCity re-casedState name converted to code+2 more
ENR-134956ENRHannah Ortiz1957-10-10UHC-87191-3744328528126790 Harbor Blvd, San Diego, CA0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-136967ENRNatalie P Gray1996-11-08UHC-64557-4955172297467891 Jefferson Ave Apt 27, Seattle, WA, 981040.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-132670ENRAaron Alexander1956-03-20UHC-32032-51—6261 Highland Ave, Denver, CO, 802670.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-129309ENRBetty J Dunn—UHC-03470-3044852324161582 Bayshore Dr, Austin, TX, 787020.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-105853ENRJoshua Crawford2001-05-16UHC-10821-8871395179891998 Sage Ct, Chandler, AZ, 852010.52Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
ENR-110540ENRRichard Z Herera1984-08-28UHC-90195-3981831533349847 Maple Ave, Tucson, AZ, 857550.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-139284ENRMichelle F Harvye1950-05-22UHC-63801-8464426616842326 Oak St, San Antonio, TX, 782000.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-110280ENRDiane Mendez1973-12-13UHC-02276-61—6371 Grand Ave, Las Vegas, NV, 891910.52Name split from “Last, First”Phone missing area codeMember ID reformattedStreet suffix standardised+2 more
ENR-130951ENREugene Franklin1999-06-01UHC-34876-6795375194624137 Mountain View Dr, Miami, FL, 331450.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112663ENRTeresa Vazquez2005-01-09UHC-14612-7191142963701235 Elm St, San Diego, CA, 921770.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-118489ENRIsabella N Lynch—UHC-07898-24—630 Church St, Phoenix, AZ, 850990.52Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-118490ENRIsabella N Lynch—UHC-07898-24—630 Church St, Phoenix, AZ, 850990.52Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-106821ENRBeverly Montgomery—UHC-55657-247337623845820 Lake View Rd, Tempe, AZ, 852000.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-123550ENRGeorge Silva1972-09-06UHC-43784-6848072529219064 Camelback Rd, Glendale, AZ0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-135074ENRJuan S Carroll1956-10-23UHC-09236-7438258530022194 Central Ave Apt 2, Tucson, AZ, 857450.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-104750ENRCamila Montgomery2007-10-20UHC-03721-0951124593958901 Pine Dr, Minneapolis, MN, 554320.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-108903ENRAlan D Taylor1964-03-06UHC-03445-29—8573 Sunset Blvd, Jacksonville, FL, 322360.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-112901ENRNicholas Harris1967-05-19UHC-74346-37—2764 Washington St, Fresno, CA, 937290.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-133008ENRPeter L Rios1957-09-19UHC-05397-9768822959054756 Mesa Dr Apt 26, Plano, TX, 750430.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-134974ENRCynthia Stephns1957-04-06UHC-44022-0721738939068209 Bayshore Dr, Atlanta, GA, 303640.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-107494ENRFrank Alvarado1968-11-17UHC-72561-53—9413 Central Ave, Glendale, AZ, 853780.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-114602ENRJessica M Evans1974-08-13UHC-87523-8854060060532157 River Rd, Dallas, TX, 752420.52SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-132014ENRAbigail Luna1940-11-08UHC-74464-6967098805894651 Hillcrest Rd, Jacksonville, FL0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-111515ENRCruz O Larry1999-07-15UHC-19187-5662524980241872 Elm St, Seattle, WA, 981280.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127152ENRDaniel G Carroll1970-06-20UHC-02920-7993381036776778 Elm St, Charlotte, NC, 282180.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-121484ENRDylanJunk1959-09-19UHC-37245-6725287082998950 Apache Blvd, Houston, TX, 770250.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-139240ENRSophia Riley1981-12-20UHC-88399-8945639811426152 Washington St, San Diego, CA, 921730.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-113531ENRMegan T Garcia1979-11-28UHC-85835-9482965065879530 Forest Ave # 859, Austin, TX, 787230.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-117623ENRRobert Li1958-02-14UHC-01999-78—9518 Desert Sky Blvd, Chandler, AZ, 852800.52Name split from “Last, First”Phone missing area codeMember ID reformattedStreet suffix standardised+2 more
ENR-124420ENRJean Wang1965-07-21UHC-49440-9179582278712348 Elm St, Glendale, AZ, 853680.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-105600ENRGabriel Russell—UHC-05189-6161758840344477 Washington St, Columbus, OH, 432580.52Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
ENR-114402ENRGerald Wright1998-09-24UHC-16903-15—223 Church St, Miami, FL, 331140.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-140694ENRMichelle Phillips1946-10-01UHC-44626-2258990447524100 Lake View Rd Apt 37, Miami, FL, 331480.52Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-116607ENRAmanda U Santos—UHC-26059-183486712651723 Meadow Ln, Austin, TX, 787290.52Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-131455ENRPatricia Q Ross1949-05-22UHC-68744-18775851139552 Desert Sky Blvd # 609, Glendale, AZ, 853940.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-107535ENRRandy Franklin1939-02-21UHC-11089-4069192443288402 Canyon Rd, Scottsdale, AZ, 852460.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111886ENRCarlos E Black1984-07-05UHC-87243-2245466461461501 Willow Ct, Houston, TX0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-107964ENRNicole Sullivan2005-09-21UHC-05239-5856163507185598 Valley View Dr, Tempe, AZ, 852350.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-125967ENRMariana Guzamn1954-06-03UHC-05958-1265774604693575 Hillcrest Rd, Columbus, OH, 432660.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-104570ENRCarl M Robertson—UHC-16735-8453228496433388 Jefferson Ave, Phoenix, AZ, 850030.52Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
ENR-131529ENRDorothy N Hayes2007-11-07UHC-27529-3133269177056272 Bayshore Dr, Tucson, AZ, 857290.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126326ENRAisha Salazar1967-12-18UHC-25890-6084043352349703 Willow Ct, Las Vegas, NV, 891930.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-133159ENRLiz Z Pierce1965-07-21UHC-28078-4842843309343566 Central Ave, San Antonio, TX, 782130.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
43,101 rows, page 84 of 863PreviousNext