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-427581CLMRalph K Peterson1995-08-04UHC-53260-0545885719841958 Market St, Sacramento, CA, 958830.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-131770ENRWei Q Morrison1956-07-26UHC-11160-33—5478 Canyon Rd Apt 34, Plano, TX, 750310.54Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-138699ENRCheryl Little1992-09-28UHC-89021-4352160937994835 Hillcrest Rd Apt 33, Eden Prairie, MN, 553900.54Name split from “Last, First”Phone reformattedSSN last four extractedUnit split from street+1 more
TPA-55069TPAJoshua Ramos1952-07-04——1749 Broadway # 313, Minneapolis, MN0.54Name split from “Last, First”Unit split from streetZIP missingWhitespace trimmed+1 more
PRV-28370PRVNicole K Willis1997-02-08UHC-86882-0474080182671520 Highland Ave, Gilbert, AZ, 852990.54Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed+1 more
CLM-414646CLMWlliam Powell1973-01-13UHC-92775-0345547921341719 Ridge Rd, Eden Prairie, MN, 553370.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
ENR-131937ENRSarah Rivera1991-04-26UHC-69163-8690975666139867 Sage Ct, Scottsdale, AZ, 852240.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-102559ENREugene H McCoy—UHC-78063-8576333985234186 Pine Dr, Orlando, FL0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-120212ENRJohn Clark1944-10-26UHC-32961-2037840468411606 Desert Sky Blvd, Plano, TX, 750370.54Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+1 more
ENR-142444ENRKatyh C Anderson1957-02-05UHC-30623-8949428753696950 River Rd Apt 35, Dallas, TX, 752980.54Middle initial moved out of first namePhone reformattedUnit split from streetState name converted to code+1 more
CLM-415530CLMRaymond Martinez1964-07-23UHC-76339-68——0.54Name re-casedTwo-digit birth yearPhone missing area codeGender normalised+1 more
CLM-400440CLMJuen Castro1979-08-01——3550 Sunset Blvd, San Antonio, TX, 782610.54Two-digit birth yearState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-410770CLMAbigail C Johnston2002-06-09——5319 Meadow Ln, Dallas, TX, 752350.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-25101PRVWillie C Elliott1943-01-20UHC-22957-69—9782 Ridge Rd, Tempe, AZ, 852890.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-25100PRVWillie C Elliott1943-01-20UHC-22957-69—9782 Ridge Rd, Tempe, AZ, 852890.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-131565ENRAngela Woods1978-01-03UHC-12380-0141044952676025 Oak St, Minneapolis, MN, 554070.54Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-58371TPASofia Garrett1987-05-08UHC-60736-866707143325256 Ocean Ave, Seattle, WA, 981970.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
CLM-429451CLMMason Hawkins1943-07-07UHC-57852-17—6154 Palm Dr # 459, Tempe, AZ, 852380.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-136872ENRRyan Richards1978-06-09UHC-25214-3636461599854533 Mesa Dr # 596, Los Angeles, CA, 900390.54Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+1 more
CLM-413647CLMJanet Dunn—UHC-23650-03—7704 Lake View Rd, Nashville, TN, 372280.54Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
ENR-109460ENRKyle E Lopez1956-05-05UHC-73389-1194420250835858 Sage Ct, Chandler, AZ0.54Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-57596TPACharlotte M Haansen———2692 Palm Dr, Scottsdale, AZ, 852710.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
PRV-28326PRVShirley A Meyer1976-09-12—2663373260413 Cedar Ln, Seattle, WA, 981870.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-117987ENRSusan C Gardner1968-04-27UHC-08142-9391896860805508 Pine Dr # 675, Charlotte, NC, 282310.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-134947ENRJordan G Weaver1947-11-19UHC-41990-34—4916 Sunset Blvd, Phoenix, AZ0.54Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-132657ENRLawrence Kelly—UHC-38369-9245429502749622 Central Ave, Fresno, CA0.54Name re-casedDate of birth missingState name converted to codeZIP missing+1 more
ENR-138110ENRMaria L Richards—UHC-07157-4665145093473146 Bayshore Dr, Eden Prairie, MN, 553100.54Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+1 more
ENR-129216ENRHeather N Watson1999-02-19UHC-13281-285823689226310 Main St, Plano, TX, 750450.54Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-100695ENRBryan Peterson—UHC-76984-96—71 Willow Ct # 737, Mesa, AZ, 852340.54Date of birth unreadableUnit split from streetZIP+4 trimmedWhitespace trimmed+1 more
TPA-53929TPACheryl Dunn1987-12-14——6313 Highland Ave, Eden Prairie, MN, 553630.54Name split from “Last, First”Two-digit birth yearCity re-casedState name converted to code+1 more
ENR-136293ENRBilly A Washington1996-02-02UHC-77163-13—1371 Desert Sky Blvd, Glendale, AZ, 853360.54Name re-casedTwo-digit birth yearCity re-casedState name converted to code+1 more
ENR-111122ENRJason Davis2008-11-02—88862584198435 Pine Dr Apt 15, Gilbert, AZ, 852880.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-427532CLMChristian Meyer2007-04-25—48345538182940 Indian School Rd # 324, Dallas, TX, 752160.54Two-digit birth yearPhone reformattedUnit split from streetGender normalised+1 more
ENR-120741ENREmily T Fuller1975-06-24UHC-91168-0788326229745073 Sunset Blvd, Miami, FL, 331960.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-420047CLMSamuel Alvarez1939-10-18UHC-86926-4356754115577856 Highland Ave # 429, Columbus, OH, 432820.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-103313ENRNicholas C Dominguez1943-05-08UHC-92617-6897273331426743 Baseline Rd Apt 12, Houston, TX, 770710.54Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+1 more
ENR-137634ENRAndrew J Montgomery—UHC-32115-7074724011353903 Mesa Dr, San Antonio, TX, 782840.54Middle initial moved out of first nameName re-casedDate of birth missingPhone reformatted+1 more
CLM-432502CLMLori Roberts1948-04-24—54536822583853 Hillcrest Rd, Tempe, AZ, 852530.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-128263ENRBobby Castro1943-06-02UHC-60624-223069114821288 Ocean Ave Apt 13, Los Angeles, CA0.54Phone reformattedMember ID reformattedUnit split from streetState name converted to code+1 more
ENR-138055ENRJohn T Salazar1982-02-06UHC-74782-2682092656055809 Palm Dr, Gilbert, AZ, 852320.54Phone reformattedSSN last four extractedState name converted to codeEmail lower-cased+1 more
TPA-62377TPADrew James1939-01-24——7426 Forest Ave, Jacksonville, FL, 322210.54Name split from “Last, First”State code upper-casedZIP+4 trimmedGender normalised+1 more
ENR-118814ENRCheryl T Jacobs1974-07-10UHC-69318-5283525380811398 Spring St, Eden Prairie, MN, 553820.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-102942ENRAmber P Espinoza1948-01-22UHC-65231-2470030703591009 Mountain View Dr, Los Angeles, CA, 900620.54Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
ENR-108652ENRCarroll Z Sophia1979-02-23UHC-64413-5258163884125642 Desert Sky Blvd, Atlanta, GA, 303940.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-108653ENRCarroll Z Sophia1979-02-23UHC-64413-5258163884125642 Desert Sky Blvd, Atlanta, GA, 303940.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-100027ENRAustin Henry2008-03-02UHC-53911-8271040698484483 Hillcrest Rd, Atlanta, GA, 303270.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53255TPASarah Vazquez1982-04-20—21925582807529 Grand Ave, Tucson, AZ, 857320.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-402456CLMPhilip Marshall1939-03-28UHC-88317-89—7863 Washington St, Phoenix, AZ, 850830.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-118382ENRVirginia Q Butler1998-05-09UHC-27368-9563453623064254 Valley View Dr # 367, Atlanta, GA, 303040.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-131841ENRCharlotte T Turner1961-12-18UHC-11473-2761393560987851 Union St, Nashville, TN0.54Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
100,000 rows, page 196 of 2,000PreviousNext