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-139011ENRPatrick I Santiago1951-07-19UHC-87991-71—1176 Willow Ct, Fresno, CA, 937980.52Name re-casedPhone missing area codeSSN last four extractedStreet suffix standardised+2 more
ENR-114967ENRAdam Williamson1951-08-21UHC-78870-26—2585 Harbor Blvd, Houston, TX0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-114966ENRAdam Williamson1951-08-21UHC-78870-26—2585 Harbor Blvd, Houston, TX0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-139243ENRPricce V Mateo2008-02-20UHC-70897-2961960875674704 Mountain View Dr, Tempe, AZ, 852410.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-113173ENRMariana T Green1989-08-17UHC-41515-8035471599299052 Grand Ave, Denver, CO, 802220.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-120467ENRWei Kim1968-03-07UHC-37453-9477874259927066 Hillcrest Rd, Houston, TX, 770520.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102782ENRHolmes E Bruce1966-07-06UHC-64889-2633036082948363 Main St, Tucson, AZ, 857690.52Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-126339ENRCheryl P Allen—UHC-03912-0174682923099106 Sunset Blvd, Mesa, AZ0.52Name split from “Last, First”Date of birth reformattedDate of birth unreadableZIP missing+2 more
ENR-137966ENRHannah Rojas1963-01-04UHC-56751-8597755291341371 Lake View Rd, Nashville, TN0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-131756ENRBrenda Carpenter1953-05-23UHC-50968-5533544329064125 Canyon Rd # 218, Minneapolis, MN, 554190.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-107157ENRBradley N Alvarado—UHC-60977-1585588615729460 Apache Blvd, Orlando, FL, 328000.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-137250ENRThomas L Wallace1978-02-12UHC-19625-0245963176624115 Market St, Las Vegas, NV, 891490.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-107229ENRLnda Stevens1949-05-21UHC-29670-5769330221295554 Forest Ave, Dallas, TX, 752200.52Two-digit birth yearPhone reformattedCity re-casedState name converted to code+2 more
ENR-114185ENRAaron Garcia1963-04-27UHC-88510-6575197651267813 Desert Sky Blvd, Minneapolis, MN, 554240.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126483ENRJose Mejia1978-12-13UHC-36493-0398490501684197 Indian School Rd, Fresno, CA, 937110.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-117421ENRAlbert B Little1974-06-23UHC-32994-6127341476332310 Oak St # 666, Tempe, AZ0.52Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+2 more
ENR-130948ENRGoria Wilson1984-11-23UHC-54456-1396431408944217 River Rd, Austin, TX, 787850.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-108949ENRPaul Fisher1950-05-11UHC-57034-7128835149951977 Mountain View Dr Apt 2, Eden Prairie, MN, 553610.52Name split from “Last, First”Unit split from streetCity re-casedState name converted to code+2 more
ENR-121850ENRBeverly Z Simmons1941-08-28UHC-14430-6848132932833203 Spring St, Austin, TX, 787060.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111805ENRElizabeth Clark1991-06-26UHC-08079-45—878 Pine Dr, San Diego, CA0.52Name split from “Last, First”City re-casedState name converted to codeZIP missing+2 more
ENR-100218ENRAustin I Wong1960-08-26UHC-42508-7257194346472723 Grand Ave Apt 35, Houston, TX, 770240.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-105488ENRJonathan Richards1986-09-07UHC-51651-9669143422074292 Camelback Rd, Charlotte, NC, 282310.52Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed+2 more
ENR-114206ENRWilliam M Herrera—UHC-27008-72—1009 Church St, Minneapolis, MN, 554470.52Name re-casedDate of birth unreadablePhone missing area codeState name converted to code+2 more
ENR-120601ENRCamila Austin1969-04-17UHC-85544-9781834658628623 River Rd, Las Vegas, NV, 891350.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-113174ENRMariana T Green1989-08-17UHC-41515-8035471599299052 Grand Ave Apt 1, Denver, CO, 802220.52Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
ENR-128079ENRPriya N Stewart1976-08-09UHC-29329-4946727702486977 Hillcrest Rd # 880, Jacksonville, FL, 322570.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-140552ENRRoger Chavez1971-05-02UHC-06007-3953885435406965 Broadway, Miami, FL, 331590.52Two-digit birth yearPhone reformattedState name converted to codeEmail lower-cased+2 more
ENR-134138ENRMarcus B Singh1941-05-20UHC-84028-9381778578328266 Bayshore Dr, Tampa, FL, 336650.52Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
ENR-120790ENRKatheen N Porter1945-12-06UHC-38152-2151458385844540 Harbor Blvd, Las Vegas, NV0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-140262ENRCheryl Banks1985-09-01UHC-00187-2963270109379272 Grand Ave, Dallas, TX, 752740.52Name split from “Last, First”Phone reformattedState name converted to codeEmail lower-cased+2 more
ENR-126894ENRChristine Jackson1956-01-19UHC-72896-5923666319105956 Bayshore Dr, Tucson, AZ0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-133440ENRLuis Y Moore2008-09-11UHC-48649-2196793366719374 Ridge Rd, Houston, TX, 770830.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-129833ENRAnthony Rogers1975-09-08UHC-27408-94—7260 Grand Ave, Phoenix, AZ, 850300.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
ENR-130795ENRPhilip B Sipmson1940-08-26UHC-19865-6439455253309221 Market St, Minneapolis, MN, 554930.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-123242ENRDiana S Bailey1999-10-21UHC-96404-93—3860 Spring St, Miami, FL0.52Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-107571ENRMichelle Harvey—UHC-39297-7087374906311657 Ridge Rd, San Diego, CA, 921910.52Name split from “Last, First”Date of birth missingPhone reformattedZIP+4 trimmed+2 more
ENR-122564ENRValentina Wood1989-02-20UHC-77504-308498752268464 Oak St, Gilbert, AZ0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127240ENRAnn G Russell2006-06-08UHC-35547-4838856569604502 Hillcrest Rd, San Diego, CA, 921030.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-115922ENRWalter L Alvarez1941-06-02UHC-32233-1737537900454448 Sage Ct, Houston, TX, 770310.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-130653ENRMadison Hawkins1950-04-28UHC-18827-8063654324043643 Forest Ave Apt 20, Gilbert, AZ, 852310.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-139983ENRRalph Garcia1945-04-22UHC-55034-7437357843472592 Forest Ave, Miami, FL, 331150.52Name split from “Last, First”Phone reformattedSSN last four extractedState name converted to code+2 more
ENR-122114ENRAnthony Q Garcia1993-05-08UHC-14322-9638450414599491 Bayshore Dr, Houston, TX, 770300.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-115373ENRSusan Ward1959-08-18UHC-02824-24—8521 Highland Ave, Nashville, TN, 372280.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-130349ENRKeith Griffin1979-04-15UHC-52969-8850884260499173 Lake View Rd Apt 2, Tucson, AZ, 857950.52Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
ENR-142997ENRNoah K Boyd—UHC-94724-49—474 Washington St, Glendale, AZ0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-126394ENRJoyce Watson1938-11-17UHC-18256-9240171225813969 Lincoln Way, Jacksonville, FL, 322970.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
ENR-141042ENREmily X Foster1988-02-21UHC-40785-7526449499801701 Meadow Ln, Gilbert, AZ, 852820.52Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+2 more
ENR-140858ENRAhmed O Coleman1957-03-03UHC-59645-1051260659714581 Forest Ave, Columbus, OH0.52Name split from “Last, First”Phone reformattedZIP missingEmail lower-cased+2 more
ENR-141185ENRKyle Cook2001-09-07UHC-25023-4421661476119327 Broadway, Scottsdale, AZ, 852410.52Name split from “Last, First”Phone reformattedSSN last four extractedCity re-cased+2 more
ENR-102571ENRMei F Estrada1958-06-13UHC-89965-96—8211 Church St, Tempe, AZ0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
43,101 rows, page 73 of 863PreviousNext