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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-60592TPABrian Luna2000-02-17——2217 Indian School Rd, Minneapolis, MN, 554110.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-60035TPAAna N Gilbert1979-03-17—3386953263—0.78Name re-casedTwo-digit birth yearPlan code upper-casedWhitespace trimmed+1 more
TPA-63260TPARick Murray2000-05-02——958 Pine Dr, Seattle, WA, 981870.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-56622TPAJoseph Dean1992-07-20—27730972535930 River Rd # 746, Houston, TX, 770590.78Name re-casedDate of birth reformattedPhone reformattedUnit split from street+1 more
TPA-59950TPAPaul Thomas1976-03-20——5585 Grand Ave, Las Vegas, NV, 891920.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60400TPAEric Simpson1998-10-18—98437521108776 Canyon Rd, Columbus, OH, 432890.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52340TPAJoseph Kennedy1946-06-09——522 Valley View Dr, Fresno, CA, 937080.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58096TPAPamela Pierce1985-09-21——5981 Meadow Ln, Phoenix, AZ, 850370.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-61574TPAAnna Payne1966-11-27——3257 Market St # 795, Austin, TX, 787860.78Name re-casedDate of birth reformattedUnit split from streetWhitespace trimmed+1 more
TPA-52373TPAJerry Franklin1963-04-23—39753399012202 Apache Blvd, Houston, TX, 770320.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56279TPAHenry Wells1994-05-08—2483558215—0.78Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more
TPA-53037TPALauren Mason1953-05-25——2872 Church St, Tempe, AZ, 852050.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59124TPAJoe Carlson1974-02-08—73594617838045 Willow Ct, Tampa, FL, 336950.78Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-58727TPAAmber Watson2001-05-13—42632399483827 Church St, Columbus, OH, 432560.78Name re-casedDate of birth reformattedPhone reformattedState name converted to code+1 more
TPA-58382TPAGloria Franklin1974-06-06UHC-58135-07—9640 Meadow Ln, Nashville, TN, 372030.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51402TPALinda C Spencer1966-09-16—33284803956260 Ridge Rd, Tucson, AZ, 857870.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62253TPAAnthony Harris2002-11-20UHC-93261-8883643901456767 Palm Dr, Orlando, FL, 328330.78Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+1 more
TPA-58854TPAVictoria Salazar1970-06-13——9172 Lake View Rd, Los Angeles, CA0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-53750TPAVictoria Hunt2004-02-03—34925796708062 Cedar Ln, Dallas, TX, 752730.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57999TPALawrence Roberts1982-07-10UHC-89575-5524070259158451 Jefferson Ave, Nashville, TN, 372390.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57432TPARobert Thomas1966-03-15——4075 Park Pl, Nashville, TN, 372740.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56359TPADanielle Ramirez1954-01-10—29590543289333 Lincoln Way, Eden Prairie, MN, 553630.78Date of birth reformattedPhone reformattedSSN last four extractedWhitespace trimmed+1 more
TPA-63676TPABrandon H Fields1969-09-11UHC-95171-29—2541 Willow Ct, Denver, CO, 802980.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-51561TPAPhilip Harris1978-06-25——1274 Main St, Austin, TX, 787610.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53273TPACaarolyn M Palmer2004-08-19—7285629177—0.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-63500TPARuth Sanchez1996-05-14UHC-68224-02—2653 Elm St, Columbus, OH, 432980.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55860TPAIsabella Stewart1995-11-01—91597688519036 Mesa Dr, Charlotte, NC, 282390.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55861TPAIsabella Stewart1995-11-01—91597688519036 Mesa Dr, Charlotte, NC, 282390.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58610TPARoy Obrien2008-09-19——3089 Mountain View Dr, Houston, TX, 770610.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50882TPAMateo G Carter1973-08-09—39623498372383 Baseline Rd, Seattle, WA, 981320.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61714TPATyler Reyes——47890388544440 Maple Ave, Orlando, FL, 328490.78Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-59856TPADavid Wng1968-08-14—29144649627085 Bayshore Dr, Atlanta, GA, 303600.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61728TPARalph Armstrong1957-02-11——7059 Desert Sky Blvd, Glendale, AZ, 853670.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-51449TPAAnn Dominguez1959-12-03—55120548112671 Grand Ave, Los Angeles, CA, 900420.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-51076TPAPeter Scott1950-11-02——2722 Mesa Dr, Scottsdale, AZ, 852170.78Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-52251TPADouglas Woods2000-08-17UHC-13693-42—1511 Highland Ave, Gilbert, AZ, 852850.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54101TPAWei Mendoza1965-07-18——69 Mountain View Dr, Tampa, FL, 336790.78Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-58287TPAHannah K Owens1947-10-28——6773 Willow Ct, Orlando, FL, 328040.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-59585TPAMatthew Mrquez1963-03-11—31065031843974 Harbor Blvd, Sacramento, CA, 958240.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-59244TPASandra Gardner1958-11-11——129 Palm Dr, Jacksonville, FL, 322830.78Name re-casedCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-56508TPAFrances White1968-11-16——3852 Main St, Dallas, TX, 752960.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-54347TPAOmar Wung1952-11-11——8933 Mesa Dr, Minneapolis, MN, 554580.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62320TPARandy Vazquez1960-06-15——9686 Lake View Rd, Austin, TX, 787920.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-57681TPAJess Rios2005-04-05——656 Hillcrest Rd, Jacksonville, FL, 322770.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51801TPAKyle Patterson2004-05-08UHC-99347-41—6733 Lake View Rd, Tucson, AZ, 857970.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52710TPAAdam R Collins1975-06-08—39958480232667 Canyon Rd, Tucson, AZ, 857650.78Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-54485TPARussell W Wong1985-05-08UHC-32502-69—6766 Desert Sky Blvd, Houston, TX, 770220.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-54070TPAWayne Bryant1958-12-15—64445985447704 Jefferson Ave, Eden Prairie, MN, 553410.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57715TPAAbigail Roberts1963-06-08——3460 Market St, Nashville, TN, 372980.78Name re-casedTwo-digit birth yearCity re-casedWhitespace trimmed+1 more
TPA-62376TPAKen Q Hamilton1985-10-18UHC-66672-48—4095 Lake View Rd, Sacramento, CA, 958830.78Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
14,474 rows, page 139 of 290PreviousNext