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-141654ENRAnn Contreras1970-02-27UHC-63950-5926972344457875 Willow Ct, Atlanta, GA0.50Phone reformattedCity re-casedState name converted to codeZIP missing+3 more
ENR-102779ENRAlexis Mejia—UHC-10534-16—530 Baseline Rd, Tucson, AZ0.50Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-101378ENRJack H Hudson1946-12-16UHC-98393-2670880106155259 River Rd, Gilbert, AZ, 852650.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121181ENRJeremy Aguilar1979-11-21UHC-85770-8093429619667625 Palm Dr, Jacksonville, FL, 322910.50Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-106851ENRCatherine U Kelly1960-03-04UHC-17734-12—4121 Mesa Dr, Las Vegas, NV, 891110.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-118827ENRSteve B Hayes1945-03-09UHC-96739-9087127520325994 Willow Ct, Scottsdale, AZ, 852640.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-129652ENRDebra C Rose1955-05-23UHC-38793-8079685645917416 Baseline Rd Apt 36, Mesa, AZ, 852760.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-126984ENRCarlos Romero1943-09-23UHC-75490-3929452976205637 Market St, Tampa, FL, 336470.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-142492ENRRebecca E Morrison1959-09-24UHC-30681-21—4518 Forest Ave, Tucson, AZ, 857860.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-138234ENRAlice I Hart1957-07-10UHC-33459-5977322087121510 Valley View Dr, Nashville, TN, 372180.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
ENR-141361ENRLucia Mendoza1965-02-03UHC-92600-0237948033503079 Sunset Blvd Apt 13, Tucson, AZ, 857640.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-125631ENRBruce Gardner2004-09-23UHC-64895-2333232506165610 Hillcrest Rd, Fresno, CA, 937610.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-128870ENRMatthew V Singh1993-08-04UHC-24784-5231154964511811 Indian School Rd, Charlotte, NC, 282570.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-121033ENRCarl R Jones1962-07-01UHC-55397-6658583236212044 Washington St, Dallas, TX, 752330.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116175ENRJennifer C Ryan—UHC-62129-5758352533714040 Sunset Blvd, San Antonio, TX, 782500.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135527ENRZachary M Watkins1994-12-18UHC-59413-9064127621061963 Highland Ave, Austin, TX0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-105517ENRJonatan F Wells1997-04-19UHC-50263-5368180720269341 Church St, Seattle, WA, 981600.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138382ENRJennifer H Fisher2007-10-13UHC-19102-39—3860 Ocean Ave, Tempe, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-122210ENRChristina P Johnston1963-07-26UHC-64381-5665224308401967 Central Ave, Jacksonville, FL, 322450.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132573ENRJon Q Dominguez1965-02-16UHC-49789-8988056255691946 Valley View Dr, Las Vegas, NV, 891810.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-134567ENRCarlos Clark1975-12-08UHC-35686-8769174658573497 Church St, Miami, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133709ENRDoris Kelly1957-03-07UHC-00217-4839527269809827 Highland Ave, Seattle, WA, 981620.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-127869ENRGary Peters1954-08-17—5129654132355 Mesa Dr, Plano, TX, 750010.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-107133ENRElijah Q Cox1986-06-28UHC-15378-0870875501645551 Main St # 267, Jacksonville, FL0.50Phone reformattedUnit split from streetCity re-casedZIP missing+3 more
ENR-105940ENRRandy T Schultz1945-01-18UHC-67392-09—5172 Cedar Ln, Plano, TX, 750490.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100514ENRBobby C Gilbert2001-02-27UHC-67259-6636428100706310 Grand Ave, Dallas, TX, 752530.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-101798ENRAmy Graham1942-12-08UHC-93467-2281281782783276 Oak St, Seattle, WA, 981480.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-106432ENRMei A Mendez1939-01-11UHC-90033-138557633406612 Hillcrest Rd Apt 11, Charlotte, NC, 282480.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-116957ENRAmber E Reyes—UHC-63044-2735255158836206 Ridge Rd, Minneapolis, MN, 554110.50Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-109278ENRPamela Mitchell—UHC-76970-8178835418945418 River Rd, Phoenix, AZ, 850730.50Date of birth unreadablePhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-124656ENRHannah K Owens1946-10-28UHC-20754-8642730074646773 Willow Ct Apt 38, Orlando, FL, 328040.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-125174ENRIsabella K Aguiilar———839 Mesa Dr Apt 12, Austin, TX, 787560.50Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
ENR-128099ENRRalph A Jimenez1989-07-12UHC-36480-4940264401125171 Desert Sky Blvd, Los Angeles, CA, 900630.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105215ENRArjun Ray1963-03-12UHC-68947-5271577051275602 Camelback Rd Apt 8, Atlanta, GA, 303050.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-102180ENRDonald G Ross1997-12-09UHC-84152-83—223 Indian School Rd, Charlotte, NC, 282010.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
ENR-116797ENRSophia K Robertson1942-08-12UHC-82419-72—5540 Hillcrest Rd, Austin, TX, 787030.50Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+3 more
ENR-110260ENRPeter M Gonzalez1995-02-07UHC-67948-80—6218 Mesa Dr Apt 12, Scottsdale, AZ, 852460.50Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
ENR-102257ENRAlex R Marquez1969-06-04UHC-60235-8275528374495581 Lincoln Way, Minneapolis, MN, 554130.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130510ENRAhmed I Hayes1998-05-03UHC-61342-464545116766896 Bayshore Dr Apt 38, Plano, TX, 750560.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-107657ENRBryan V Carr1959-11-01UHC-84837-9593848822317382 Pine Dr, Atlanta, GA, 303490.50Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-129663ENRDeborah W Willis1975-02-17UHC-78282-1321167272612399 Harbor Blvd, Miami, FL0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133627ENRRoger E Ortiz1980-03-26UHC-11679-6151073343643575 Baseline Rd, Austin, TX0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-120166ENRDanielle Sims1961-10-28UHC-89107-0123947570393165 Willow Ct Apt 40, Tampa, FL, 336070.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-128771ENRJeffrey W Harrison1942-09-28UHC-17502-0755929090246635 Canyon Rd, Las Vegas, NV0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141061ENRMargaret T Watson2007-04-27UHC-53720-0475224041245608 Elm St # 807, Orlando, FL, 328830.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-139380ENROlivia S Jackson1939-08-05UHC-00850-9456266985098395 Highland Ave # 437, Dallas, TX, 752860.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-134762ENRNathan S Kennedy1971-07-24UHC-94717-3195242106451676 Spring St, Mesa, AZ, 852440.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-137919ENRHannah Valdez1969-03-27UHC-12876-94—4569 Baseline Rd, Glendale, AZ, 853570.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107574ENRBilly W King1968-10-17UHC-34428-447933475889381 Sage Ct, Houston, TX, 770980.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141175ENRElizabeth D Matthews1994-08-26UHC-83163-5962575997988220 Bayshore Dr, Orlando, FL, 328550.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 59 of 863PreviousNext