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-100971ENRRonald Perez1980-01-07UHC-12194-3546982270133180 Elm St, Charlotte, NC, 282840.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
ENR-109063ENRAmber O Delgado1998-09-15UHC-52060-8571689812176469 Market St # 734, Minneapolis, MN, 554010.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-125433ENRRachel Long1996-07-12UHC-84625-2132388328005552 Spring St Apt 24, Tampa, FL0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-118842ENRCheryl U Wang1959-07-15UHC-22851-7162238087712046 River Rd, Plano, TX, 750690.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126239ENROmar U Fields1970-08-01UHC-26432-52—7580 Ocean Ave, Dallas, TX, 752800.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-103733ENRBeverly B Taylor1996-03-12UHC-10404-5048424872458531 Canyon Rd, Mesa, AZ, 852400.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-432583CLMMateo Caarlson1937-10-22—5974108821805 Ocean Ave, Atlanta, GA, 303820.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405155CLMGregory Hunt1978-09-14UHC-84710-60—4621 Sage Ct, Scottsdale, AZ0.50Date of birth reformattedMember ID reformattedSSN last four extractedZIP missing+3 more
PRV-29470PRVDiana Pena1978-11-05—94161715818865 Sunset Blvd, Atlanta, GA, 303090.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134693ENRHenry Rios1989-07-25UHC-91003-9561193078572185 Palm Dr Apt 24, San Antonio, TX0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-401606CLMMartha Simmons2002-02-09——1191 Park Pl # 792, Atlanta, GA, 303060.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-126822ENRCarol Castillo2004-05-18UHC-75924-1061994112909167 Canyon Rd, Tampa, FL0.50Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
PRV-27098PRVJean Owens1956-07-14—93428361894511 Cedar Ln, San Diego, CA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25168PRVJames Crawford1974-01-28UHC-30066-1392255689123463 Washington St, Tampa, FL, 336700.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-136227ENRElijah G Yang1990-04-17UHC-90889-134254694345418 Washington St, Las Vegas, NV0.50Name re-casedPhone reformattedState name converted to codeZIP missing+3 more
ENR-100492ENRKevin Fisher1959-11-06UHC-47560-9274571119596403 Oak St, Las Vegas, NV0.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-139925ENRBanks W William1991-07-21UHC-22405-8067274088048775 Valley View Dr, Columbus, OH0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407003CLMGrace Lawrence1990-02-28UHC-55097-42—5929 Central Ave, Glendale, AZ0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432319CLMJustin Powell1983-02-13UHC-42263-27—2150 Spring St, Columbus, OH, 432550.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-23229PRVBJunk1962-08-14UHC-74741-2562423121313629 Park Pl, Tucson, AZ, 857710.50Two-digit birth yearPhone reformattedMember ID reformattedZIP+4 trimmed+3 more
ENR-111592ENRAngela Q Sanchez—UHC-92860-1091983854883176 Maple Ave, Tucson, AZ, 857130.50Date of birth missingStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-102074ENRLisa Stewart1947-01-24UHC-45005-8120325376801205 Apache Blvd, Minneapolis, MN, 554270.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-107801ENREmily A Peters1962-08-09UHC-24172-8251846788232414 Union St, Denver, CO, 802670.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-111086ENRAlbert Nunez1981-12-24UHC-51651-67—1681 Union St, Jacksonville, FL0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-26800PRVLuis Gonzales1939-08-26UHC-00878-25—4733 Canyon Rd, Atlanta, GA, 303390.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
TPA-50243TPABryan Valdez1986-09-17——5624 Canyon Rd, Columbus, OH, 432730.50Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-412069CLMRuth Dunn2002-12-22——1310 Apache Blvd, Tampa, FL, 336230.50Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-110006ENRAmber D Chapman1992-04-28UHC-00847-2326126925458550 Canyon Rd, Tempe, AZ, 852350.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-406629CLMWilliam Howard1946-05-27—63221577719694 Bayshore Dr, Nashville, TN, 372770.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402399CLMBeth Jimenez1945-05-25UHC-65211-83—8362 Hillcrest Rd # 155, Columbus, OH0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408511CLMBobby I Dominguez2005-12-21UHC-26590-88—1263 Canyon Rd Apt 7, Dallas, TX, 752650.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-128855ENREric C Hall1956-12-06UHC-73484-6820329035036838 Maple Ave, Dallas, TX, 752990.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132450ENRElizabeth Meyer1961-06-14UHC-33794-96—6250 Grand Ave, Scottsdale, AZ, 852780.50Name split from “Last, First”Member ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-410849CLMCharlotte Kennedy2008-05-19—22730032891168 Apache Blvd, San Diego, CA, 921460.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-130005ENRSara Armstrong—UHC-69116-9040992417089391 Market St, Dallas, TX0.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421557CLMDonald Stewart———5415 Highland Ave, Minneapolis, MN, 554980.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422632CLMHeather Hudson1938-03-05—9293965350359 Jefferson Ave, Fresno, CA, 937710.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-426350CLMMaria R Jordan1979-04-01——7536 Central Ave, Atlanta, GA, 303850.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432163CLMJordan Thoomas1948-03-05UHC-00688-86—5317 Jefferson Ave, Sacramento, CA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-54024TPAJoan Phillips1945-04-28—68268290521773 Mesa Dr, Austin, TX, 787820.50Name split from “Last, First”Two-digit birth yearPhone reformattedState code upper-cased+3 more
ENR-127340ENRDiane L Aguilar1956-07-17UHC-44282-2683160172962266 Park Pl, Sacramento, CA0.50Name split from “Last, First”State code upper-casedZIP missingEmail lower-cased+3 more
CLM-416985CLMKenneth Henry2001-05-17UHC-27427-73—4427 Forest Ave, Dallas, TX0.50Name split from “Last, First”Date of birth reformattedState name converted to codeZIP missing+3 more
CLM-421393CLMMason Miller1955-12-23UHC-52836-22—825 Mountain View Dr, Houston, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-117033ENRLuis S Howard1987-09-10UHC-63334-20—744 Harbor Blvd Apt 37, Las Vegas, NV, 891390.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-131599ENRBryan Arnold—UHC-11391-7854962504988219 Central Ave, San Antonio, TX, 782720.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-402885CLMNoah Chapman2002-04-15——397 Palm Dr, Phoenix, AZ0.52Name split from “Last, First”Date of birth reformattedPhone missing area codeCity re-cased+2 more
TPA-54772TPACharlotte Valdez1991-05-01—83022176981375 Canyon Rd Apt 26, Columbus, OH, 432880.52Two-digit birth yearPhone reformattedUnit split from streetState code upper-cased+2 more
ENR-137843ENRMarilyn T Johnson—UHC-48489-4258561645978315 Willow Ct, Denver, CO, 802940.52Name re-casedDate of birth unreadablePhone reformattedZIP+4 trimmed+2 more
CLM-417906CLMAmanda I Fsher1970-08-21UHC-11517-28—5090 Willow Ct # 378, Phoenix, AZ, 850070.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-401956CLMAshley Murphy1952-10-12——1854 Oak St, Las Vegas, NV, 891560.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
100,000 rows, page 140 of 2,000PreviousNext