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-115931ENRMichael T Mills—UHC-22066-2063693585095025 Highland Ave, Las Vegas, NV, 891910.54Date of birth missingStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-426935CLMAshley Garza1971-09-10——6125 Park Pl, Plano, TX, 750860.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-427044CLMHiroshi Martinez1993-08-16UHC-21659-3489927145136792 Valley View Dr # 147, Fresno, CA, 937560.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-408860CLMJoan T Hoffman1968-09-13UHC-43415-86—8411 Ridge Rd, Mesa, AZ, 852750.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-142389ENRChristian Q Wheeler1976-08-08UHC-84072-9925522169636628 Lincoln Way Apt 22, Tampa, FL, 336200.54Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+1 more
ENR-113990ENRDenise L Jensen1954-11-24UHC-41763-2959469619204637 Spring St, Eden Prairie, MN, 553610.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
TPA-50258TPAAnthony Nunez1991-07-06——6925 Lake View Rd, Chandler, AZ, 852050.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-62260TPACamila Parker1957-05-01——4559 Bayshore Dr Apt 13, Chandler, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-107618ENRAisha Austin1967-10-16UHC-45784-2620758444978211 Willow Ct, Charlotte, NC, 282950.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-140606ENRJose Pena—UHC-68169-2136737809611513 Indian School Rd, Los Angeles, CA0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-51820TPADebra Lawson1939-08-19—98042912476946 Market St, Dallas, TX, 752700.54Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+1 more
ENR-100439ENRChristine V Salazar1973-11-05UHC-75118-4794478047857127 Sunset Blvd, Plano, TX, 750200.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
TPA-54773TPADanielle Reid1999-03-23—53291083101276 Baseline Rd, Seattle, WA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
CLM-423741CLMWilliam Dean1997-11-24UHC-03327-76—3731 Bayshore Dr, Miami, FL, 331940.54SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-117935ENRSamantha Diaz1998-08-23UHC-92123-72—5983 Cedar Ln, Nashville, TN, 372060.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-117176ENRJoyce K Fsiher1974-05-01UHC-71280-2364248294566729 Washington St, Chandler, AZ, 852050.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-120284ENRChristian Wbeb1951-06-16UHC-95905-4235221579282035 Sunset Blvd, Houston, TX, 770440.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-403374CLMRachel Hughes1969-06-06UHC-06997-78—3782 Meadow Ln, Glendale, AZ, 853280.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-428715CLMFrances Spencer1992-07-12———0.54Two-digit birth yearPhone missing area codeGender normalisedWhitespace trimmed+1 more
CLM-405994CLMMei B White—UHC-02392-26—8916 River Rd, Jacksonville, FL, 322730.54Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-52141TPADiana Henry———9167 Camelback Rd, Eden Prairie, MN0.54Name split from “Last, First”Date of birth unreadableState code upper-casedZIP missing+1 more
CLM-405620CLMJessica Taylor1951-02-22UHC-33596-1234489004712381 Lincoln Way # 287, Nashville, TN0.54Phone reformattedUnit split from streetZIP missingGender normalised+1 more
ENR-130442ENRJose X Gordun1994-04-13UHC-27613-6087595690912402 Willow Ct, Tempe, AZ, 852680.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60678TPAJulie Arnold1981-09-06——9290 Oak St, Tempe, AZ, 852610.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-403892CLMBetty Willis2006-05-12UHC-26725-4394133196437434 Canyon Rd, Gilbert, AZ0.54Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-117565ENRSarah V Brown1976-04-18UHC-04155-27—9173 Apache Blvd, Minneapolis, MN, 554960.54Phone missing area codeStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-57097TPAAmanda I Hayes1991-04-02—44151561895103 River Rd, Denver, CO, 802040.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-418058CLMBrittany Nnez2006-06-06UHC-13686-89—2966 Cedar Ln, Seattle, WA, 981950.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-403325CLMHelen Snyder1982-06-03UHC-87519-986307396842455 Grand Ave # 189, Jacksonville, FL, 322760.54Two-digit birth yearPhone reformattedUnit split from streetGender normalised+1 more
ENR-141275ENRJeremy Roberts2002-08-08UHC-15499-5329228861801986 Church St, Atlanta, GA, 303190.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-125877ENRSara F Carpenter1954-05-13UHC-93904-2224263273965892 Willow Ct, Orlando, FL, 328340.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-412933CLMCheryl K Guzman2008-10-09UHC-71613-4296771662589620 Main St Apt 28, Minneapolis, MN, 554220.54Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-58530TPAOrtega Raymond———6056 Valley View Dr, Chandler, AZ, 852630.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
ENR-131423ENRMray L Bishop1971-12-21UHC-15059-18—4398 Sage Ct, Glendale, AZ, 853010.54Middle initial moved out of first nameName re-casedZIP+4 trimmedGender normalised+1 more
TPA-52771TPAMichelle Garza1964-01-08UHC-34895-65—6394 Indian School Rd, Tucson, AZ0.54Name re-casedPhone missing area codeZIP missingGender normalised+1 more
TPA-53971TPACarlos Nguyen1985-03-23UHC-33573-55—4442 Desert Sky Blvd Apt 30, San Antonio, TX, 782850.54Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-131144ENRCynthia B Castro—UHC-01960-8686857558144822 Baseline Rd, Denver, CO, 802480.54Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+1 more
TPA-51732TPABrenda Ramos1979-01-12——4632 Spring St, Tampa, FL, 336590.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-116135ENRWayne Castro2004-05-01UHC-11215-9562383803567173 Baseline Rd, Los Angeles, CA, 900260.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-100833ENRDiane Hart2008-02-04UHC-90073-9625981669207848 Ridge Rd, Miami, FL0.54Name split from “Last, First”Phone reformattedZIP missingGender normalised+1 more
PRV-24824PRVJoyce E Hanson1944-01-14——2684 Grand Ave, Plano, TX, 750620.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-418384CLMBrenda U Hernandez1996-04-12UHC-85229-30—1513 Bayshore Dr Apt 5, Seattle, WA, 981460.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-54890TPACamila Jones2007-03-06——4149 Bayshore Dr, Tampa, FL, 336330.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
TPA-56352TPADouglas Mendez1947-12-11UHC-96845-13—5921 Washington St, Miami, FL, 331880.54Two-digit birth yearState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
ENR-113202ENRPJunk1985-01-23UHC-31708-6494133724762064 Pine Dr, Tempe, AZ, 852180.54Phone reformattedSSN last four extractedGender normalisedWhitespace trimmed+1 more
CLM-404006CLMDonna Palmer1975-06-23UHC-21096-27—7728 Market St, Eden Prairie, MN, 553930.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-401597CLMBrandon E Porter——75759763247764 Pine Dr, Miami, FL0.54Name split from “Last, First”Date of birth unreadablePhone reformattedZIP missing+1 more
ENR-111772ENRMegan P Wheeler1971-03-12UHC-61260-06—8380 Sunset Blvd, Houston, TX, 770600.54Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-407977CLMEvelyn Griffin1980-12-09UHC-10238-52—5030 Market St, Columbus, OH, 432690.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-427421CLMGrace Watkins1979-12-27——9798 Central Ave, Los Angeles, CA, 900380.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
100,000 rows, page 205 of 2,000PreviousNext