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
TPA-63783TPAJason Kelley1949-01-20——4295 Palm Dr, Las Vegas, NV, 891400.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-21379PRVMateo Rivera——5374470369115 Canyon Rd, Scottsdale, AZ, 852070.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-107233ENRDoris P Simmpson1998-05-10UHC-01495-377798106558638 Hillcrest Rd, Seattle, WA, 981050.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-62156TPALinda Smith1960-12-14UHC-42244-1490892529386026 Indian School Rd, Tampa, FL, 336090.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119066ENRCarlos F Perry2003-05-14—57541785571213 Spring St Apt 1, San Antonio, TX, 782260.52Middle initial moved out of first nameUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-64036TPAEvelyn Guzman1990-07-11——5792 Bayshore Dr # 818, Seattle, WA, 981780.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-142477ENRJeremy G Scott1980-01-26UHC-34112-33—9678 Forest Ave, Dallas, TX, 752250.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
ENR-142484ENRJulie F Hall—UHC-83195-1788637419241783 Union St, Jacksonville, FL, 322020.52Middle initial moved out of first nameDate of birth missingPhone reformattedStreet suffix standardised+2 more
CLM-431568CLMJery Obrien1955-01-20UHC-15196-52—4060 Mesa Dr # 800, Jacksonville, FL, 322040.52Name split from “Last, First”Name re-casedUnit split from streetStreet suffix standardised+2 more
ENR-127730ENRKathryn L Gutierrez—UHC-77738-1928533338421505 Palm Dr, Austin, TX0.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-129826ENRKyle Burton1975-08-22UHC-26348-5078398961575561 Ocean Ave, San Antonio, TX, 782160.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-20299PRVBrenda Weaver1950-07-25—95964603105530 Grand Ave Apt 35, Tampa, FL, 336170.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-101680ENROmar Diaz—UHC-01138-1528850984075356 Harbor Blvd, Dallas, TX0.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137369ENRRachel X Russell1991-04-22UHC-59733-4985178699268899 Forest Ave, Glendale, AZ, 853980.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-111030ENRAlbert A Herrera1979-02-01UHC-78925-8526726448785972 Baseline Rd, Charlotte, NC, 282210.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-415894CLMDiego Lane1943-06-06——1277 Baseline Rd, San Diego, CA, 921860.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
PRV-22898PRVAaron Hicks—UHC-68928-73—6607 Desert Sky Blvd Apt 28, Eden Prairie, MN0.52Name re-casedDate of birth unreadableUnit split from streetZIP missing+2 more
CLM-414186CLMCarlos Daniels1943-06-12UHC-16011-75—7763 Main St, Gilbert, AZ, 852180.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-430685CLMSharn Bell2006-07-20UHC-77136-29—6511 Sage Ct, Houston, TX, 770180.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-115338ENRAndrea Watkins1973-10-08UHC-03284-6663651245956651 Hillcrest Rd, Jacksonville, FL0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
TPA-56058TPAHenry Z Johnson1982-05-24——8640 Willow Ct, Tucson, AZ, 857570.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-133558ENRLisa B Walker1950-02-28UHC-69000-2396962959747489 Valley View Dr, Denver, CO0.52Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-104805ENRVincent V Singh1951-10-08UHC-60582-925876182273688 Baseline Rd, Miami, FL, 331730.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-118569ENRBrandon Fowler1938-06-25UHC-57396-575496745470820 Mesa Dr, Minneapolis, MN0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-424078CLMHannah Bradley1971-09-11——3317 Elm St, Houston, TX0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
TPA-59444TPAWilliam Payne1942-07-04——6262 Sunset Blvd # 599, Charlotte, NC, 282040.52Name re-casedDate of birth reformattedUnit split from streetState name converted to code+2 more
ENR-119097ENROlivia R Hamilton1948-01-01UHC-98232-9823492289121843 Main St, Las Vegas, NV, 891420.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58033TPAJennifer Powell1953-10-20——5942 Forest Ave, Gilbert, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-134302ENRAlexander C Chavez1961-04-07UHC-68036-1269036608172654 Oak St, Orlando, FL, 328750.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-54179TPARalph D Chavez1988-12-07——8378 Ridge Rd, Denver, CO, 802580.52Name re-casedDate of birth reformattedPhone missing area codeZIP+4 trimmed+2 more
CLM-415759CLMMichael Anderson1966-05-26UHC-95902-85—8542 Willow Ct, Jacksonville, FL, 322600.52Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416296CLMJerry Watkins1957-07-07UHC-20153-7294077037482207 Washington St # 434, Los Angeles, CA, 900980.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432114CLMJulie Miller2007-01-20—62784060307356 Camelback Rd, Tucson, AZ0.52Name split from “Last, First”Phone reformattedZIP missingGender normalised+2 more
ENR-138748ENRSpencer D Janet1949-05-01UHC-89276-4320361229068719 Washington St, Orlando, FL, 328850.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112963ENRJoe Q Hernandez—UHC-15476-727448370918795 Maple Ave, Tempe, AZ, 852950.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422371CLMJess Q Sanchez———2365 Mountain View Dr, Sacramento, CA, 958880.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-424951CLMJoe E Ramos1969-08-23UHC-60247-7630585354166532 Mountain View Dr, San Antonio, TX, 782810.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-24008PRVKathryn Hart1950-12-28UHC-87384-3470660070871571 Main St Apt 13, Scottsdale, AZ, 852870.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-138554ENRLogan P Sanders1962-11-27UHC-91805-8069949506985114 Forest Ave, Fresno, CA, 937690.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405330CLMRachel H Wong1946-03-22—81840202239625 Ocean Ave, Denver, CO, 802320.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405331CLMRachel H Wong1946-03-22—81840202239625 Ocean Ave, Denver, CO, 802320.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-429517CLMJulia D Luna1971-02-15——8584 Main St # 607, Tampa, FL, 336780.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-103245ENRBilly X Green1951-07-15UHC-62141-7563591761213510 Sage Ct, San Antonio, TX, 782670.52Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-406616CLMDenise T Henderson1969-04-06——5931 Jefferson Ave Apt 30, Tampa, FL, 336110.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414277CLMZachary Wakins—UHC-26709-9271268536309266 Ridge Rd, Atlanta, GA, 303220.52Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
ENR-142594ENRMei Q Howell1961-04-12UHC-44146-2890046781633682 Spring St, Las Vegas, NV, 891350.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-132126ENRAmy Collins1970-09-28UHC-11297-5091356501754997 Maple Ave, Minneapolis, MN, 554930.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-119240ENRAmy Lane1961-05-10UHC-24923-3157432034408713 Camelback Rd, Tempe, AZ, 852740.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-114324ENRRonald R Lawson1991-08-03UHC-93268-33—4129 Highland Ave, San Antonio, TX, 782410.52Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-141146ENRBrian Fox1969-01-20UHC-56910-92—3889 Spring St, Chandler, AZ, 852040.52Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+2 more
100,000 rows, page 144 of 2,000PreviousNext