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
ENR-127418ENRSteve M Harrison1955-03-22UHC-14162-8537528473389547 Indian School Rd, San Antonio, TX0.38Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
CLM-416937CLMAmberJunk1950-05-03UHC-16493-1828473580593362 Pine Dr # 516, San Antonio, TX, 782520.38Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-425692CLMMei Maldonado1945-11-02UHC-86595-66—7457 Park Pl, Houston, TX, 770820.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-119858ENRHeather N Hart1940-09-07UHC-30106-3420897630473708 Hillcrest Rd, Miami, FL0.38Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-136545ENRSamantha C Cruz—UHC-37990-57—4590 Bayshore Dr, Columbus, OH, 432500.38Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-25503PRVRoy Q Simpson1956-07-16UHC-12089-1696777551199767 Harbor Blvd, Gilbert, AZ0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100140ENRAsutin O Aguilar1993-07-28UHC-85487-9465069675633665 River Rd, Los Angeles, CA, 900490.38Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-104265ENRDiego Jimenez1940-09-20UHC-73976-8758731812635774 Hillcrest Rd Apt 21, Tampa, FL, 336750.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-141216ENRMark E Edwards1956-10-11UHC-45206-3370977373117708 Highland Ave, Eden Prairie, MN, 553390.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140916ENREthan Y Thompson1939-03-09UHC-90196-9580490262401975 Desert Sky Blvd Apt 39, Glendale, AZ, 853120.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-27984PRVAlbert U Johnston1961-05-09UHC-58242-5755487785045512 Highland Ave, Tucson, AZ, 857500.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134733ENRBryan Matthews1988-07-28UHC-23750-6192463300128907 Harbor Blvd, Plano, TX, 750850.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404275CLMAndrea Medina1987-08-16——4090 Church St, Tucson, AZ, 857570.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-101967ENRCheryl A Cunningham1949-09-03UHC-44238-0182297307751762 Cedar Ln, Chandler, AZ, 852800.38Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-417303CLMTheresa Burns1961-08-13UHC-49456-9186776512396374 River Rd, Miami, FL, 331460.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
TPA-58755TPAKelly Vasquez——83682681362110 Church St Apt 30, Mesa, AZ, 852740.38Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-401181CLMDiego P Bishop1959-12-25UHC-89423-8629630504726395 Jefferson Ave, Eden Prairie, MN, 553450.38Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
ENR-132234ENRAndrew Vargas1941-06-24UHC-46683-84—8072 Mountain View Dr # 982, San Diego, CA, 921040.38Name split from “Last, First”Date of birth reformattedSSN last four extractedUnit split from street+3 more
ENR-109321ENRAlice N Spencer—UHC-71190-27—4684 Mountain View Dr # 932, Houston, TX, 770170.38Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
ENR-109322ENRAlice N Spencer—UHC-71190-27—4684 Mountain View Dr # 932, Houston, TX, 770170.38Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
CLM-413403CLMSarah Hunt1998-07-09UHC-87592-4238084394903523 Market St, Houston, TX, 770460.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-53033TPAJesse Brooks1959-09-04——7865 Meadow Ln Apt 17, Eden Prairie, MN, 553650.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-100627ENRJuulia N Obrien1941-01-03UHC-51219-306657760070497 Oak St, Gilbert, AZ, 852800.38Middle initial moved out of first nameName re-casedTwo-digit birth yearStreet suffix standardised+3 more
TPA-54742TPADJunk1958-05-15UHC-96374-1552996987034017 Main St, Las Vegas, NV, 891610.38Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-414132CLMKaren Welch1955-01-05UHC-51273-0255681198965842 Washington St, Plano, TX, 750960.38Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-109454ENRSofiia Robertson1956-08-16UHC-53644-18—1630 Mesa Dr, Minneapolis, MN, 554680.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-400449CLMMargaret Cavez1951-03-19UHC-92419-11—5663 Spring St # 869, Minneapolis, MN, 554570.38Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-105205ENREmma Jimenez1947-03-08UHC-12284-5025976806336157 Palm Dr, Glendale, AZ0.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114808ENRDeborah Romero1954-12-26UHC-22670-8984261493908812 Lincoln Way, Los Angeles, CA, 900760.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-417337CLMJudy Z Pierce1991-02-15UHC-76830-07—2875 Maple Ave Apt 11, San Antonio, TX0.38Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-112221ENRRachel W Elliott1995-11-25UHC-94005-3296128520339231 River Rd, San Antonio, TX, 782410.38Middle initial moved out of first namePhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-425686CLMAustin Robertson1968-10-16UHC-45622-09—7410 Ocean Ave Apt 39, Jacksonville, FL, 322220.38Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-400130CLMMargaret Reyes—UHC-72818-46—2556 Lake View Rd, Tampa, FL0.38Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-103110ENRGary Price1976-10-01UHC-09967-5792186900918120 Bayshore Dr # 842, Chandler, AZ, 852190.38Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-51745TPASam Estrada1976-06-12—21281895821665 Palm Dr Apt 10, Dallas, TX, 752660.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-429414CLMDouglas X Lewis1967-09-08UHC-76690-56—560 Spring St Apt 6, Dallas, TX, 752540.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-133097ENRRalph R Grreen1994-02-21UHC-95379-38—831 Ridge Rd Apt 33, Mesa, AZ0.38Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
TPA-57049TPANathan Burns1951-06-09——9807 Mesa Dr # 200, Austin, TX, 787790.38SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-103508ENRJeffrey R Rice1986-06-14UHC-50934-22—788 Washington St # 129, Mesa, AZ, 852610.38Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25043PRVJoyce G Price1964-01-27——3725 Jefferson Ave, Columbus, OH0.38Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-422304CLMOmar Arnold1976-04-22UHC-09544-10—1974 Baseline Rd, Jacksonville, FL, 322540.38Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-63037TPASteve King1969-01-20——5493 Meadow Ln, Los Angeles, CA, 900190.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-120588ENRDiana P Ruiz—UHC-17013-5248436395696684 Indian School Rd, Tucson, AZ, 857710.38Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-105526ENRWillie N Gonzalez1938-08-11UHC-09367-6849975649278463 Indian School Rd Apt 10, Seattle, WA, 981600.38Middle initial moved out of first namePhone reformattedMember ID reformattedUnit split from street+3 more
ENR-118274ENREmma A Rios1960-01-12UHC-40743-44—1383 Willow Ct, Denver, CO, 802970.38Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141838ENRAna P Lewis1951-03-11—39246694787077 Palm Dr # 323, Austin, TX, 787180.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-104799ENRBradley W Hart1967-02-21UHC-04020-5323966984151900 Sunset Blvd Apt 4, Las Vegas, NV, 891250.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-423373CLMBrandon Halll1997-08-11UHC-21070-59—1192 Union St Apt 7, Chandler, AZ, 852800.38Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-425900CLMAshley Castro1970-04-21——1834 Jefferson Ave, Austin, TX0.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-403736CLMAdam Singh2002-01-12UHC-60218-20—5610 Camelback Rd, Nashville, TN, 372170.38Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 32 of 2,000PreviousNext