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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-23833PRVMatthew F Burke1982-01-07—55445102372792 Desert Sky Blvd, Nashville, TN, 372910.52Name split from “Last, First”Phone reformattedState name converted to codeZIP+4 trimmed+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
CLM-415910CLMJanice Owens———1736 Harbor Blvd, Jacksonville, FL0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-415911CLMJanice Owens———1736 Harbor Blvd, Jacksonville, FL0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-431654CLMKenneth Sims1975-11-15UHC-21958-69—4019 Baseline Rd, Minneapolis, MN, 554340.52Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+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
CLM-418817CLMHenry R Jordan1968-05-02—36124317723607 Ridge Rd, Tampa, FL, 336460.52Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed+2 more
CLM-402498CLMNatalie Romero1970-11-09UHC-05876-8824395312141511 Baseline Rd, Glendale, AZ, 853390.52Name split from “Last, First”Date of birth reformattedMember ID reformattedState name converted to code+2 more
CLM-412332CLMJuan J Santiago1988-05-17UHC-94054-778593034625166 Union St, Plano, TX, 750370.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414881CLMJoan Matthews2006-02-15——2720 Bayshore Dr, Fresno, CA, 937740.52Name split from “Last, First”SSN last four extractedStreet 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
CLM-416778CLMAdam Li1945-01-18UHC-03793-43—51 Oak St, Houston, TX, 770500.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+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
CLM-411854CLMChristine Ortiz1975-01-27UHC-56393-98—9138 Apache Blvd, Glendale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-421795CLMAndrew Hunt2008-11-21UHC-90052-31—7960 Meadow Ln, Mesa, AZ0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410940CLMCarl Boyd1942-12-18UHC-08601-36—8407 Washington St, Mesa, AZ, 852690.52Name split from “Last, First”Date of birth 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
CLM-429791CLMAshley Coleman1950-09-15——4299 Washington St, Los Angeles, CA, 900570.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+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
CLM-410547CLMDanielle Ford2006-12-08UHC-47400-49—9012 Central Ave # 672, Plano, TX, 750810.52Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+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
TPA-53606TPAMadison Valdez——67393554691204 Washington St, Gilbert, AZ, 852340.52Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402786CLMLuis Wallace1939-02-04UHC-03439-0344559311126713 Main St, Columbus, OH, 432320.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-22218PRVLawrence Maldonado—UHC-97544-20—7498 Main St, Glendale, AZ, 853670.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+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
CLM-417747CLMCharles Richardson1963-11-23UHC-92117-87—9013 Highland Ave # 714, Minneapolis, MN, 554830.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56674TPAMarcus Carr1942-10-28——2952 Jefferson Ave, Tampa, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-59299TPAMatthew Marquez1984-02-09—80573329896565 Maple Ave, Glendale, AZ, 853220.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-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
TPA-53849TPAAndrea Bell2007-01-24——4106 Baseline Rd, Austin, TX, 787130.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-414661CLMSusan Carr2005-06-19UHC-11023-15—5207 Pine Dr, Las Vegas, NV, 891770.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-417885CLMBetty Patel1959-02-07UHC-54842-23—1321 River Rd, Charlotte, NC, 282910.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-430497CLMEric Harris1989-03-15UHC-75275-07—2516 Ridge Rd, Los Angeles, CA, 900640.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56594TPAGeorge Hernandez1955-03-23——6868 Ridge Rd, Mesa, AZ, 852970.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-408787CLMJacob D Hoffman1997-03-25——6402 Willow Ct, Chandler, AZ, 852360.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+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
TPA-57144TPAJacob Jensen1944-06-02——3352 Mountain View Dr, Las Vegas, NV0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+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
CLM-418790CLMElijah Ruiz1981-01-18UHC-16462-6124141508051368 Grand Ave, Mesa, AZ, 852490.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59904TPAMaria Lopez1945-04-08——3303 Forest Ave, Jacksonville, FL, 322430.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 147 of 2,000PreviousNext