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-60026TPADiane Hunt1974-07-11——772 Bayshore Dr, Austin, TX, 787810.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
ENR-124783ENRHeather Moarles1942-08-03UHC-30285-90—6122 Baseline Rd Apt 26, Austin, TX, 787080.54Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-421977CLMKathy Garrett—UHC-28181-3132545854376193 Pine Dr, San Antonio, TX, 782590.54Name re-casedDate of birth unreadableState name converted to codeGender normalised+1 more
CLM-411282CLMMelissa Hudson———1991 Grand Ave, Miami, FL, 331000.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-411283CLMMelissa Hudson———1991 Grand Ave, Miami, FL, 331000.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
ENR-123076ENRPatrick Freeman1981-04-01UHC-46779-2677962403578966 Highland Ave Apt 11, San Diego, CA, 921650.54Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-403945CLMYuki Fox1944-10-15——3744 Park Pl, Denver, CO, 802470.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-117933ENRHeather P Perez1961-11-18UHC-55402-8164483125348482 Church St # 462, Eden Prairie, MN, 553940.54Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+1 more
TPA-64421TPAPatrick Jacobs1952-01-27——2015 Sage Ct # 158, Las Vegas, NV0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-139756ENRAustin H Li1943-07-11UHC-37537-13—4095 Bayshore Dr, Scottsdale, AZ, 852620.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-415812CLMJoshua Simmons1974-12-28UHC-19558-30—1213 Main St, Seattle, WA, 981480.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-415813CLMJoshua Simmons1974-12-28UHC-19558-30—1213 Main St, Seattle, WA, 981480.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-425919CLMStephanie Martinez1978-06-25——4964 Church St, Sacramento, CA, 958100.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-424161CLMRandy Maldonado1963-10-24UHC-17028-42—8563 Apache Blvd, Glendale, AZ, 853690.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-432714CLMHarold L Hansun1959-12-11UHC-26394-19—8336 Hillcrest Rd, Plano, TX, 750750.54Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-115998ENRSean A Roberts1959-07-19UHC-73892-4421648101497042 Ocean Ave, Eden Prairie, MN, 553050.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-100503ENREric Sims—UHC-69655-0725357722404759 Oak St, Tampa, FL0.54Date of birth unreadablePhone reformattedState name converted to codeZIP missing+1 more
PRV-26919PRVJean Holmes1977-09-23—80857287245649 Oak St # 929, Los Angeles, CA, 900660.54Phone reformattedUnit split from streetState name converted to codeZIP+4 trimmed+1 more
ENR-114108ENRHannah R Rivera1967-09-15UHC-32282-46—3233 Central Ave, Atlanta, GA, 303090.54Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-123004ENRChristopher E Guerrero1990-08-04UHC-94197-0558638397007502 Forest Ave, Scottsdale, AZ0.54Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-111883ENRJoyce Bwoman1953-08-08UHC-07872-4773096028561658 Canyon Rd, Plano, TX, 750170.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54337TPAEvelyn Gardner1981-08-14——7508 Highland Ave, Los Angeles, CA, 900200.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-428498CLMJose Powell1975-07-26UHC-57609-34—8444 Highland Ave, Chandler, AZ, 852860.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-101184ENREric G Hoffman2007-09-02UHC-44737-8375837807764427 Desert Sky Blvd, Plano, TX0.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-114321ENRTheresa D Turner1970-08-04UHC-58865-8145679462376512 River Rd, San Diego, CA, 921110.54Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+1 more
ENR-103599ENRJack Reed—UHC-42013-97—9195 River Rd, Charlotte, NC, 282550.54Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+1 more
ENR-113386ENRKatherine Romero1960-05-18UHC-26431-2291345580053633 Mountain View Dr, Tampa, FL, 336830.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
ENR-117765ENREugene R Meyer1997-03-06UHC-35995-6355621857619009 Union St, Plano, TX, 750730.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-141622ENRAhmed X Sims1972-07-07UHC-36382-8190044417477759 Harbor Blvd, Dallas, TX, 752570.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-102013ENRSamantha Meyer1992-03-20UHC-98383-40—8827 Main St Apt 35, Chandler, AZ, 852400.54Two-digit birth yearUnit split from streetState name converted to codeWhitespace trimmed+1 more
ENR-120382ENRBryan S Cunningham2003-12-01UHC-70418-3187599615783596 Desert Sky Blvd, Miami, FL, 331150.54Phone reformattedState name converted to codeZIP+4 trimmedGender normalised+1 more
CLM-407695CLMBob U Weber1982-03-12UHC-94741-69—5930 Maple Ave # 563, Chandler, AZ, 852700.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-122494ENRRussell Q Maatthews—UHC-68793-9796843978758711 Union St, San Antonio, TX0.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-100327ENRRoy Wood—UHC-48767-5260672361022733 Sunset Blvd, Gilbert, AZ, 852120.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-102001ENRKayla Medina1953-05-27UHC-08933-32—8044 Forest Ave, Mesa, AZ, 852060.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58553TPABarbara Chavez1984-04-28——6126 Indian School Rd, San Antonio, TX0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-103494ENRWatson N Amy1942-07-11UHC-71029-2495527480429190 Apache Blvd Apt 31, San Diego, CA, 921580.54Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+1 more
PRV-23974PRVChristine V Martinez1999-08-16UHC-53553-34—4871 Mountain View Dr # 113, Tampa, FL, 336160.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-120083ENRNancy Marshall1995-12-28UHC-46794-1598574756743906 Grand Ave # 487, Phoenix, AZ, 850870.54Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-113580ENRDavid X Hudson1941-10-26UHC-52527-30—2624 River Rd, San Antonio, TX, 782040.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-50646TPARobert Alexander1959-03-08UHC-08776-212725843105814 Camelback Rd, Orlando, FL, 328660.54Name re-casedTwo-digit birth yearState name converted to codeGender normalised+1 more
ENR-126131ENRCarl N Moore1957-06-26UHC-52150-95—4666 Forest Ave, Minneapolis, MN0.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-113006ENRSntiago Garza1994-07-26UHC-94718-7031575055024439 Highland Ave, Atlanta, GA, 303150.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-136911ENRPhilip I Fox1942-06-16UHC-24518-6942745671295198 Baseline Rd, Los Angeles, CA, 900770.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60001TPADaniel Reid1980-05-26——7481 Park Pl, Houston, TX, 770460.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-123021ENRJanet Perry1966-11-20UHC-78618-4549967182079064 Bayshore Dr, Charlotte, NC, 282810.54Two-digit birth yearPhone reformattedSSN last four extractedState name converted to code+1 more
ENR-141907ENRJustin Hernandez1939-02-15UHC-93913-1260328498714617 Willow Ct, Gilbert, AZ0.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-27677PRVFrank Robertson1982-05-16UHC-20010-8680275831772074 Hillcrest Rd, Tampa, FL0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-120644ENRBrandon P Mason1940-02-11UHC-72913-092296444365617 Elm St, Tucson, AZ, 857010.54Name split from “Last, First”City re-casedState name converted to codeGender normalised+1 more
ENR-120554ENRAnna Ortega—UHC-30781-8086248896391899 Elm St, Las Vegas, NV0.54Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
100,000 rows, page 200 of 2,000PreviousNext