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
CLM-419936CLMDoris Q Jordan1991-06-26UHC-58784-9162485972587210 Canyon Rd, Charlotte, NC, 282750.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-142656ENRJereym Q Walsh—UHC-83689-77—2882 Lincoln Way, Orlando, FL, 328560.54Name split from “Last, First”Date of birth unreadableZIP+4 trimmedWhitespace trimmed+1 more
CLM-406995CLMCharles Bryant1995-10-01UHC-30385-79—8292 Hillcrest Rd Apt 38, Las Vegas, NV, 891060.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-54713TPAAnna Scott1966-07-27UHC-14025-28—2964 Central Ave, Columbus, OH, 432930.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-112775ENRDiane Dellgado1973-05-02UHC-09723-27—8266 Elm St, San Antonio, TX, 782480.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-104282ENRDaniel Santiago1998-07-24UHC-56034-9968570130545968 Park Pl, Phoenix, AZ, 850280.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
PRV-20681PRVJohnston Lawrence1952-10-18—52380413885968 Park Pl, Chandler, AZ, 852230.54Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+1 more
PRV-23297PRVJacob X Rios2008-04-24UHC-73234-7135025455083158 Canyon Rd, Orlando, FL, 328630.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-117448ENRKeith M McCoy1999-07-22UHC-96522-2637256115166187 Maple Ave, Minneapolis, MN, 554090.54Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+1 more
CLM-402496CLMEvelyn Fisher2005-10-08UHC-52353-84—489 Highland Ave, Sacramento, CA, 958260.54Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-122427ENREmily E Wallace1997-05-22UHC-54030-645119659260189 Palm Dr, Scottsdale, AZ, 852830.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-115640ENRJesse H Martin1958-10-04UHC-46287-4335357405302119 Pine Dr, Las Vegas, NV, 891930.54Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-136696ENRCaroln QJunk1976-01-16UHC-52262-4454374059572854 River Rd, Dallas, TX, 752350.54Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-111244ENRSusan Z Sims1958-07-18UHC-18790-4369227621342297 Elm St, Austin, TX, 787420.54Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+1 more
ENR-137147ENRDoris Brooks1945-09-21UHC-60379-2975494803797254 Spring St, Dallas, TX, 752630.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-56746TPAGeorge Dominguez2001-04-12——974 Sage Ct, Seattle, WA, 981940.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-50644TPARobert Alexander1959-03-08——814 Camelback Rd, Orlando, FL, 328660.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
TPA-50645TPARobert Alexander1959-03-08——814 Camelback Rd, Orlando, FL, 328660.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-142723ENRRuth Jordan2005-02-16UHC-16459-44—6914 Sage Ct Apt 30, Sacramento, CA, 958940.54Name re-casedTwo-digit birth yearUnit split from streetGender normalised+1 more
PRV-22893PRVEvelyn Gardner1981-08-14UHC-86706-8773556252577508 Highland Ave, Los Angeles, CA, 900200.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
PRV-23588PRVWillie Armsttrong1957-11-18UHC-69417-66—5056 Market St, Las Vegas, NV, 891730.54Name split from “Last, First”Two-digit birth yearPhone missing area codeWhitespace trimmed+1 more
ENR-126806ENRRonald P Espinoza1971-03-13UHC-53546-06—1715 Highland Ave, Gilbert, AZ, 852700.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-112892ENRJoseph Hernandez1973-03-03UHC-40659-34—4451 Canyon Rd, San Diego, CA, 921690.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-112891ENRJoseph Hernandez1973-03-03UHC-40659-34—4451 Canyon Rd, San Diego, CA, 921690.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
TPA-57227TPAGregory Campbell2003-06-18—68787804186371 Mountain View Dr, Austin, TX, 787910.54Two-digit birth yearState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-403095CLMAnn Adams1964-03-09UHC-49487-89—4774 Broadway, Scottsdale, AZ, 852440.54Name split from “Last, First”Member ID reformattedAddress re-casedZIP+4 trimmed+1 more
ENR-106838ENRDorothy A Gray1945-08-20UHC-28039-8779766347769607 Meadow Ln, Las Vegas, NV0.54Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-432615CLMDorothy Fernandez1958-06-18UHC-11988-64—4640 Pine Dr, San Diego, CA, 921810.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
TPA-63317TPAJohn Matthhews1957-08-27——5065 Indian School Rd Apt 25, Plano, TX, 750290.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-430897CLMMartha Tran1979-12-14UHC-27532-54—9876 Broadway, Seattle, WA, 981470.54State name converted to codeZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
PRV-25242PRVRyan Chen—UHC-69720-39—4269 Maple Ave # 585, San Diego, CA, 921510.54Name re-casedDate of birth unreadableUnit split from streetZIP+4 trimmed+1 more
PRV-25241PRVRyan Chen—UHC-69720-39—4269 Maple Ave # 585, San Diego, CA, 921510.54Name re-casedDate of birth unreadableUnit split from streetZIP+4 trimmed+1 more
CLM-417333CLMNoah Park1955-07-17UHC-70378-4727272621177869 Elm St, San Antonio, TX0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-136140ENRBrian Patel1955-12-13UHC-11526-6984031116002765 Lincoln Way Apt 17, Charlotte, NC, 282000.54Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+1 more
CLM-404097CLMAlex Berry1967-05-21——806 Apache Blvd, Los Angeles, CA, 900480.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-103734ENRRandy Tucker1974-05-03UHC-77271-97—8420 Central Ave, Jacksonville, FL0.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-56733TPARaymond Hansen1966-09-17——4381 Palm Dr, San Diego, CA0.54State name converted to codeZIP missingGender normalisedWhitespace trimmed+1 more
CLM-420608CLMElizabeth Kennedy1946-03-05UHC-31956-48—2428 Valley View Dr, Jacksonville, FL, 322870.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-118759ENRAdam H Harper1995-09-18UHC-83331-37—2959 Mountain View Dr, Tempe, AZ, 852210.54Middle initial moved out of first nameTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-131551ENRKathryn Ross1957-08-13UHC-29384-1476756144676403 Mesa Dr Apt 4, Dallas, TX, 752580.54Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+1 more
PRV-21600PRVLarry W Spencer—UHC-16960-57—5830 Lake View Rd # 488, Miami, FL, 331390.54Date of birth unreadablePhone missing area codeUnit split from streetWhitespace trimmed+1 more
ENR-116937ENRBenjamin Burns1986-12-06UHC-58662-4257549804617578 Harbor Blvd, Phoenix, AZ, 850700.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-133501ENRCharles Z Morales1996-07-06UHC-79311-87—1061 Mesa Dr, Charlotte, NC, 282440.54Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-128284ENRJerry F Chen1976-06-01UHC-02228-38—5860 Forest Ave, Denver, CO, 802250.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-138747ENRPamela J Welch1946-05-25UHC-09702-11—6696 Lake View Rd # 376, Tempe, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-57659TPARuth Meyer1986-12-01—83858549632426 Forest Ave, Charlotte, NC0.54Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
ENR-141959ENRCheryl M Romero1981-03-12UHC-34011-4930460889106536 Highland Ave, Glendale, AZ, 853340.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
ENR-129819ENRAna Park1994-01-06UHC-18093-4355729070746822 Highland Ave, Scottsdale, AZ, 852310.54Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+1 more
CLM-411964CLMFrances Porter1962-08-20UHC-44995-70—9881 Lincoln Way, Las Vegas, NV0.54Date of birth reformattedState name converted to codeZIP missingGender normalised+1 more
CLM-426932CLMBrittany Moore2007-05-24——2956 Sunset Blvd, Tampa, FL, 336510.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
100,000 rows, page 212 of 2,000PreviousNext