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-420102CLMLuis Cooper—UHC-43368-79—3847 Maple Ave # 829, San Diego, CA, 921390.54Date of birth unreadableUnit split from streetCity re-casedState name converted to code+1 more
CLM-430254CLMShirley Brooks1980-12-17UHC-51174-59—9743 Sage Ct, San Diego, CA, 921190.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-424414CLMIsabella Adams1984-04-08UHC-34881-59—5521 Church St, Jacksonville, FL, 322760.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-425122CLMSamantha Lawrence1940-04-12UHC-39266-73—7120 Washington St, Tucson, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-421261CLMDorothy Bradley1952-09-12UHC-61130-896219104998634 Canyon Rd, Seattle, WA, 981000.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-124243ENRRyan L Hunter1965-10-05UHC-48235-6397264298277479 Forest Ave, Charlotte, NC0.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-141786ENRDavid Q Hunter1957-02-20—81631339709047 Harbor Blvd, Las Vegas, NV0.54Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-141787ENRDavid Q Hunter1957-02-20—81631339709047 Harbor Blvd, Las Vegas, NV0.54Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-107751ENRDorothy Wagner1953-08-05UHC-38841-8324249755384345 Market St, Columbus, OH0.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-408076CLMThomas Espinoza—UHC-83698-81——0.54Name split from “Last, First”Date of birth unreadableGender normalisedWhitespace trimmed+1 more
TPA-52662TPABrian Perkins1971-11-22UHC-98944-17—2848 Sage Ct, Seattle, WA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-421814CLMAbigail Allen1999-01-07UHC-78813-14—2171 Oak St # 361, Tampa, FL, 336830.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-101397ENRJon Castillo1960-04-13UHC-72136-56923695623553 Apache Blvd # 443, Seattle, WA, 981110.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-407560CLMBrandon Boyd1988-06-11UHC-74380-08—2563 Union St, Glendale, AZ, 853950.54Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-117681ENRNoah Bryant1960-02-06UHC-04206-0298292842657257 Camelback Rd, Tempe, AZ0.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-130893ENRSteven Hunt—UHC-31698-06—2211 Willow Ct, Charlotte, NC, 282080.54Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-405352CLMSantiago Gardner1988-07-05——628 Oak St, San Antonio, TX0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-428446CLMMichael K Holmes1999-05-15——6651 Broadway, Dallas, TX, 752630.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
ENR-101296ENRMatthew Jensen1973-08-26UHC-03797-0959059282654550 Jefferson Ave, Seattle, WA, 981710.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-118203ENRWilliam W Thomas1963-02-12UHC-69152-82—6444 Ridge Rd, Scottsdale, AZ, 852800.54Name re-casedPhone missing area codeState name converted to codeGender normalised+1 more
TPA-53891TPAFatima Vargas2006-12-02UHC-86574-22—4236 Sage Ct Apt 28, Tampa, FL0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-110415ENRBradley X Robinson1985-07-17UHC-47589-1078941437445501 Sunset Blvd, Tampa, FL, 336810.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-138197ENRDiane Diaz———3673 Ocean Ave, Atlanta, GA, 303360.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-420917CLMSam Ward1988-04-23UHC-59135-15—2150 Church St, Gilbert, AZ0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-111290ENRPatricia X Mills1995-01-07UHC-35380-7594636854967958 Mountain View Dr, Tampa, FL, 336540.54Middle initial moved out of first nameSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-432461CLMMartha Z Williamson1995-08-06UHC-86118-06—364 Broadway # 411, Plano, TX, 750940.54Two-digit birth yearPhone missing area codeUnit split from streetWhitespace trimmed+1 more
ENR-135072ENRCamila U Gibson1968-03-15UHC-37139-569162589539999 Bayshore Dr, Jacksonville, FL, 322720.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-120781ENREdwad Santiago1961-01-24UHC-06807-5593128459638477 Baseline Rd, Tempe, AZ, 852990.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-115214ENRHannah Andrews1987-09-21UHC-15893-4329629329899390 Palm Dr, Sacramento, CA0.54Name split from “Last, First”State code upper-casedZIP missingGender normalised+1 more
ENR-118975ENRPhillip L Barnes2005-01-26UHC-12496-0780884620562781 Indian School Rd, Denver, CO, 802790.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
CLM-430676CLMHiroshi Sims1972-10-22UHC-85479-92—393 Lincoln Way, Fresno, CA, 937660.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
PRV-20541PRVJudy Perez1996-05-07—28143231459661 Mesa Dr, Minneapolis, MN, 554560.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-412548CLMRachel D Coleman1949-10-19——935 Meadow Ln Apt 14, Atlanta, GA, 303760.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-54449TPAAlxis Brooks1966-03-25——741 Ridge Rd, San Antonio, TX, 782840.54Name split from “Last, First”State name converted to codeEmail lower-casedGender normalised+1 more
ENR-117531ENRKevin Vasquez1965-12-12UHC-02982-4149872118633689 Grand Ave, Scottsdale, AZ, 852660.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
TPA-57861TPAGregory Smith1980-08-27——9597 Sage Ct, Charlotte, NC, 282670.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-429043CLMRaymond Mason1997-01-09——2597 Mountain View Dr, Austin, TX, 787470.54Name split from “Last, First”SSN last four extractedZIP+4 trimmedWhitespace trimmed+1 more
ENR-101849ENRStephen Murphy1992-11-09UHC-54490-8323453846712604 River Rd, Eden Prairie, MN0.54Name split from “Last, First”Two-digit birth yearPhone reformattedZIP missing+1 more
TPA-57709TPABrndon Shaw1960-11-07——7007 Oak St, Denver, CO0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-100083ENRMelissa D Fields1951-09-13UHC-11822-388014746440754 Central Ave, Houston, TX, 770850.54Middle initial moved out of first nameTwo-digit birth yearPhone reformattedStreet suffix standardised+1 more
TPA-62758TPADiane George1994-09-26——6546 Spring St Apt 8, Houston, TX, 770770.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-131179ENRDoris O Weaver1994-04-04UHC-85018-09—1270 Spring St, Columbus, OH, 432100.54Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-430240CLMAustin Robinson1955-04-05UHC-83901-9524399025971519 Ridge Rd, Tampa, FL, 336610.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-113719ENRAmy Yang2002-08-10UHC-84531-1047357489301529 Market St, Fresno, CA, 937610.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-406467CLMElizabeth Fox2005-12-07——9575 Ocean Ave, Los Angeles, CA, 900570.54State name converted to codeZIP+4 trimmedGender normalisedPlan code upper-cased+1 more
CLM-431970CLMJohn Wood1978-07-17UHC-22176-7169539176432517 Park Pl, Mesa, AZ, 852130.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-119745ENRBobby Bowman1956-08-05UHC-05130-582445047058362 Indian School Rd Apt 32, Las Vegas, NV, 891910.54Name split from “Last, First”Phone reformattedUnit split from streetGender normalised+1 more
ENR-120819ENRKaren L Woods1944-07-03UHC-39950-1970161269889357 Indian School Rd, Plano, TX0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-125488ENRMarc Murray2007-03-02UHC-72241-88—2029 Mountain View Dr # 686, Columbus, OH, 432200.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-102186ENRChristina Garza2006-12-07UHC-41809-1373036185596305 Harbor Blvd, Glendale, AZ, 853620.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
100,000 rows, page 218 of 2,000PreviousNext