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-52281TPABeverly Montgomery1940-05-17——820 Lake View Rd, Tempe, AZ, 852000.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-51528TPAAmy T Ryan2000-09-03——7338 Elm St, Charlotte, NC, 282040.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-61105TPABrandon Rodriguez1958-02-15——2098 Mountain View Dr, Dallas, TX, 752340.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-50630TPAJordan Hoffman1952-05-02——5062 Desert Sky Blvd, Las Vegas, NV, 891130.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60152TPAAmanda A West1977-05-16—92447034834670 Lake View Rd, Charlotte, NC, 282860.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60020TPABruce Wells1977-11-17——7373 Pine Dr # 846, Charlotte, NC, 282330.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63129TPAShirley Cunningham1973-12-10——3784 Central Ave, Seattle, WA, 981670.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-57584TPAMark Hawkins1973-02-22——1648 Main St, Tempe, AZ, 852890.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-61197TPAEdwards Aaron1998-02-07UHC-34450-15—6545 Pine Dr, Nashville, TN, 372540.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-54547TPAJudy Mtthews1986-08-25——3336 Mountain View Dr, San Diego, CA, 921980.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-57827TPAAngela Gilbert1964-01-11——336 Pine Dr, Miami, FL, 331620.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59095TPASantiago Park1941-08-20—73074652768358 River Rd, San Antonio, TX, 782780.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63270TPAPriya Fuller1951-07-13UHC-15580-0967647209488743 Maple Ave, Minneapolis, MN, 554040.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-62356TPADiego Brown1968-06-21—70196312208182 Lake View Rd, Seattle, WA, 981470.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59462TPAMariana Nguyen1945-08-06——9516 Ocean Ave, Chandler, AZ, 852500.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-63636TPAWillie Holmes1977-06-04——6486 Palm Dr, Phoenix, AZ, 850910.64Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+2 more
TPA-61123TPASofiia Guerrero1958-11-24—7436579225748 Cedar Ln, Eden Prairie, MN, 553810.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-52062TPAAshley Black1941-07-20——4377 Camelback Rd, Eden Prairie, MN, 553860.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-62859TPABenjamin Thompson1990-07-25——6807 Canyon Rd Apt 39, Denver, CO, 802180.64Name re-casedDate of birth reformattedUnit split from streetZIP+4 trimmed+2 more
TPA-51610TPAAna Stewart1954-07-21——2654 Sunset Blvd, Fresno, CA, 937760.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-54938TPAEmily Walker1957-12-26——541 Maple Ave, Austin, TX, 787490.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-63998TPAHarold Alvarado1974-10-05—42476228892637 Church St, San Antonio, TX0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61158TPAAhmed Hoffman1979-12-22—39797569891307 Pine Dr, Dallas, TX, 752000.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-53908TPAChristina Gonzalse1963-11-26—63260633163686 Lake View Rd, Scottsdale, AZ, 852190.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60941TPAEthan Wlch1941-06-23UHC-61196-41—9226 Lake View Rd # 443, Minneapolis, MN, 554090.64Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57867TPALarry Lynch1993-07-16——4992 Valley View Dr, San Antonio, TX, 782750.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51850TPAMaria Estrada1977-08-07——4025 Grand Ave, Jacksonville, FL0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59676TPASofia Lawrence2001-04-24UHC-25799-28—3103 Apache Blvd, Los Angeles, CA, 900440.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56789TPAJack M Barnes1979-04-24—76667693323185 Washington St, Las Vegas, NV, 891250.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-54972TPASamuel Turner1966-07-12——7369 Valley View Dr, Minneapolis, MN, 554420.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63643TPAMichelle F Henry1947-05-10—40430982277331 Grand Ave, Chandler, AZ, 852160.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-60900TPADiane P Morales1958-05-02——6994 Jefferson Ave, Seattle, WA, 981220.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
TPA-53122TPAAlbert Castillo1989-12-26—5575663500205 Church St, San Antonio, TX, 782280.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58602TPAGabriel Perkins1945-04-18——1327 Valley View Dr # 658, Scottsdale, AZ0.64Name re-casedUnit split from streetState code upper-casedZIP missing+2 more
TPA-59954TPABetty Cox1944-01-01——3527 Central Ave, Jacksonville, FL, 322750.64Name re-casedTwo-digit birth yearCity re-casedGender normalised+2 more
TPA-50496TPAEmma Espinoza1997-02-19—61634501284704 Desert Sky Blvd, Tucson, AZ, 857420.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57074TPABryan Evans1939-07-09UHC-00245-28—6067 Indian School Rd, Glendale, AZ, 853760.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61886TPAAlexis Henry1961-09-27——9695 Harbor Blvd, Tucson, AZ, 857790.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-56227TPAJesse Sandoval1962-10-14UHC-22226-3287626744932084 Jefferson Ave, Jacksonville, FL, 322860.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63223TPABetty Sandoval1944-09-25UHC-13305-47—1080 Desert Sky Blvd, Dallas, TX, 752270.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-61022TPABrandon V Clark1990-07-05——2821 Apache Blvd, Plano, TX, 750020.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54380TPADebra Rojas1942-07-15UHC-41714-20—2800 Sage Ct # 427, Las Vegas, NV, 891820.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-51467TPABenajmin Stewart1945-06-25—33147139602391 Willow Ct, Tempe, AZ, 852700.64Date of birth reformattedPhone reformattedState name converted to codeGender normalised+2 more
TPA-63272TPAChris Phillips——72830230793969 Hillcrest Rd, Gilbert, AZ0.64Name re-casedDate of birth unreadableCity re-casedZIP missing+2 more
TPA-54582TPARoy M Crawford2004-06-04——1696 Park Pl, Mesa, AZ, 852970.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55079TPABarbara Brooks1954-11-18—66842689577623 Bayshore Dr, Los Angeles, CA0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59440TPAGloria Stewart—UHC-97704-1747725615177869 Indian School Rd, Jacksonville, FL, 322000.64Date of birth unreadablePhone reformattedMember ID reformattedZIP+4 trimmed+2 more
TPA-56300TPABetty Pena1953-10-03——8194 Maple Ave, Nashville, TN, 372720.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57224TPAJonathan Mason———8561 Mesa Dr, Minneapolis, MN, 554670.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
TPA-59261TPAAna Hamilton2001-04-27UHC-11133-362183834671176 Baseline Rd, Las Vegas, NV, 891210.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 57 of 290PreviousNext