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-135687ENRSophia L Fowler1954-12-16UHC-00499-1226947120467348 Broadway Apt 24, Miami, FL, 331230.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-110992ENRLauren L Russell1980-03-15UHC-49356-318467332947502 Hillcrest Rd, Columbus, OH0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-134270ENREmily L Diaz—UHC-97744-34—3389 Camelback Rd, Nashville, TN, 372250.60Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+4 more
ENR-106787ENRMariana I Carlson1958-07-21UHC-83774-8679081419573744 Elm St # 522, Minneapolis, MN, 554740.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-106291ENRMateo V Perkins2004-11-20UHC-15495-9438461921158531 Ridge Rd, Nashville, TN, 372700.60Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
ENR-106012ENRSean Morreno1989-08-28UHC-94786-1976896996428250 Elm St, San Diego, CA, 921880.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-114998ENRAisha Willis1961-04-17UHC-57295-0692929129905745 Canyon Rd # 441, Phoenix, AZ, 850720.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-114984ENRSusan N Howard1995-01-09UHC-23868-3130356829459163 Willow Ct, Plano, TX, 750890.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104154ENRAnn Simmons1954-09-13UHC-19311-6631543726953060 Market St, Glendale, AZ, 853940.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-107972ENRJohn Delgado1990-07-14UHC-78053-8164783501269808 Market St, Sacramento, CA, 958730.60Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-131607ENRMadison Edwards1995-01-13UHC-69976-7443568305307010 Meadow Ln, Charlotte, NC, 282770.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-111942ENRAaron J Bell1940-03-15UHC-97382-48—6456 Baseline Rd Apt 20, Houston, TX, 770850.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-101952ENRJason Li1970-05-16UHC-97033-0324784096398580 Lincoln Way, Phoenix, AZ, 850410.60Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
ENR-101910ENREdward Mejia1963-01-05UHC-45725-9882596026463267 Palm Dr, Denver, CO, 802540.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-102453ENRMichelle R Cox2008-06-19UHC-75069-5324851709042167 Sunset Blvd, Orlando, FL0.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-137492ENRZachary O Greene1944-01-17—57442614587572 Baseline Rd, Austin, TX, 787180.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141363ENRJeremy Z Watson1985-01-18UHC-78439-13—6845 Valley View Dr # 982, Chandler, AZ, 852460.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-114510ENRRobert Q Collins1952-01-11UHC-33675-909125616549626 Spring St, Sacramento, CA, 958590.60Middle initial moved out of first namePhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-132983ENRDenis R Griffin1989-11-22UHC-11850-53—4985 Valley View Dr, Phoenix, AZ, 850220.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-126283ENRBradley Armstrong1947-12-15UHC-69711-5749588183176289 Market St Apt 1, Chandler, AZ, 852660.60Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-141557ENRThomas Castillo1972-11-12UHC-88761-5984342768768253 Spring St, Tucson, AZ, 857700.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-117618ENRKyle Richards1981-02-28UHC-09435-3740768581471539 Indian School Rd, Minneapolis, MN, 554330.60Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102660ENRDonna R Richards1951-12-10UHC-51434-1892072487908054 Grand Ave, Columbus, OH0.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-124496ENRCharles G Holmes1977-03-17UHC-85650-9931678009921149 Desert Sky Blvd, Nashville, TN, 372290.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-114645ENRVincent Larson—UHC-73026-6288549842272120 Church St, Dallas, TX, 752400.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-108066ENRArjun Ray1966-09-21UHC-51751-3562763223718416 Baseline Rd, Nashville, TN, 372050.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-135042ENRPatricia Hicks1984-05-19UHC-34406-0228252864847193 Main St, Chandler, AZ, 852850.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-126805ENRValentina O Wheeler1953-05-22UHC-44407-7496452758724300 Valley View Dr # 876, Nashville, TN, 372030.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-102020ENRHelen Guerrero1982-11-01UHC-96377-2441871744539053 Lincoln Way Apt 2, Columbus, OH, 432460.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-122228ENRJoshua G Watsun1984-12-12UHC-62896-7030186017477627 Highland Ave, Chandler, AZ, 852040.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-122229ENRJoshua G Watsun1984-12-12UHC-62896-7030186017477627 Highland Ave, Chandler, AZ, 852040.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-132278ENRGabriel Phillips1980-01-03UHC-86029-0138244763015932 Sage Ct Apt 26, San Antonio, TX, 782990.60Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more
ENR-103280ENRMelissa Black1988-07-05UHC-84832-6088294332292435 Meadow Ln # 874, Eden Prairie, MN, 553530.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-109126ENRJeremy Carlson1989-08-01UHC-96041-6291072685866448 Church St, Eden Prairie, MN, 553770.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-131487ENRJoshua D Wagner1939-06-04UHC-39831-7470761560586809 Market St, San Diego, CA, 921750.60Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
ENR-112389ENRBrandon Mejia1994-12-12UHC-98769-0438793241773682 Cedar Ln, Minneapolis, MN, 554630.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-126471ENRRssell S Fuller1976-09-18UHC-39766-3782965928947563 Maple Ave, Phoenix, AZ, 850690.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-139695ENRChristian Perez1952-11-25UHC-25263-9366742176491745 Sunset Blvd, Orlando, FL, 328150.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-137817ENROJunk1961-10-13UHC-77677-0845222818787897 Palm Dr, Nashville, TN, 372760.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-110223ENRSamantha Carlson1974-05-01UHC-35190-77699551989482 Sage Ct, Tampa, FL, 336070.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-139193ENRLogan Payne1986-04-08UHC-81447-442884325587279 Apache Blvd, Orlando, FL, 328300.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-131604ENRAlan T Gray1991-02-28UHC-21586-5481128116978700 Spring St, Las Vegas, NV, 891140.60Date of birth reformattedPhone reformattedCity re-casedState name converted to code+4 more
ENR-128763ENRDennis Weber2008-10-19UHC-92414-2868878686994332 Central Ave, Miami, FL, 331050.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-141031ENRRaymond C Freeman1953-01-23UHC-96816-8848236483633667 Valley View Dr, Tempe, AZ0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132498ENRKenneth V West1989-04-08UHC-16174-7872132713141690 Baseline Rd, Atlanta, GA0.60Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
ENR-120828ENRDiane C Snyder1953-08-25UHC-68765-3660828704963890 Cedar Ln, Plano, TX, 750810.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-122158ENRRichard Hunter2006-10-22UHC-39251-8252079533611801 Meadow Ln, Chandler, AZ, 852610.60Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-128109ENRJuan Kelly1945-10-24UHC-12228-0489637628032386 Central Ave, Phoenix, AZ, 850570.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-128797ENRJanice D Riley2007-10-04UHC-13352-8120132642997419 Spring St, San Antonio, TX0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-135786ENRDebraJunk1981-02-07UHC-22689-5360692986721474 Ocean Ave, Mesa, AZ0.60Name re-casedPhone reformattedMember ID reformattedCity re-cased+4 more
43,101 rows, page 125 of 863PreviousNext