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-51322TPASamantha Jensen1962-07-24——8073 Central Ave, Fresno, CA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-60045TPAZachary Greene1992-12-26UHC-69793-13—3732 Palm Dr # 883, Los Angeles, CA, 900670.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-64316TPAGabriel Day1991-11-24——1249 Indian School Rd, Austin, TX, 787170.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-52405TPAAlice Bailey1988-07-02UHC-77231-18—5898 Forest Ave, Tempe, AZ, 852680.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-57628TPAAndy Jimenez1966-02-28—57987907793408 Spring St, Dallas, TX, 752090.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60015TPARussell F Lee1966-02-19UHC-71483-825723182318336 Forest Ave, Denver, CO, 802790.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58769TPAPeter Duncan1950-04-19——445 Elm St, Gilbert, AZ, 852250.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-54096TPAJames Hunter1991-12-20—97087882321586 Grand Ave, Tucson, AZ, 857740.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62161TPAChristian Meyer2007-04-25—48345538182940 Indian School Rd, Dallas, TX, 752160.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-53283TPAMegan Rivera1971-12-11——4402 Elm St, San Antonio, TX0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60679TPAWayne G Matthews1955-07-24—53823362403815 Highland Ave, Charlotte, NC, 282630.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58249TPAGray Brown1950-01-24——5247 Jefferson Ave # 286, Tucson, AZ, 857890.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-51221TPAMartha Chapman1947-11-06—56451297826938 Lincoln Way Apt 5, Seattle, WA, 981460.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57492TPAKenneth Henry2001-05-17—52455426234427 Forest Ave, Dallas, TX, 752080.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-53934TPAMaria O Gomez1954-10-20—33347584756645 Apache Blvd, Atlanta, GA, 303800.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58720TPASofia Wood1956-04-13—4432864696297 Oak St, Sacramento, CA, 958410.64Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
TPA-60536TPAAaron Hill1953-01-22UHC-43515-39—6660 Willow Ct, Nashville, TN, 372560.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-57612TPAMatthew Dunn2008-11-24—78060519922604 Ocean Ave, Tempe, AZ, 852820.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55823TPAJoan Hoffman1942-09-22—29677560344691 River Rd, Scottsdale, AZ, 852030.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-62567TPAKelly Pierce1975-11-01—94177048767028 Mesa Dr, Plano, TX, 750020.64Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
TPA-56202TPAMichael Franklin1977-08-13——4937 Canyon Rd, Plano, TX, 750590.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64072TPAMariana Little——51457910284453 Market St, Chandler, AZ, 852860.64Name re-casedDate of birth unreadablePhone reformattedZIP+4 trimmed+2 more
TPA-63553TPAJose Harvey1970-03-26UHC-69584-36—8072 Oak St, Houston, TX, 770630.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55397TPAJoradn D Wheeler1954-09-25——9746 Mesa Dr, Mesa, AZ, 852580.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-63109TPAVincent Hughes1978-01-02—51892542978897 Willow Ct, Mesa, AZ, 852920.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54646TPARoegr X Johnston1996-03-06——1206 Desert Sky Blvd # 822, Miami, FL, 331200.64Name re-casedDate of birth reformattedUnit split from streetGender normalised+2 more
TPA-52860TPACynthia Price1941-10-01—86988683272275 Mountain View Dr, Los Angeles, CA, 900630.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56691TPALarry Cole2003-05-14——2198 River Rd, Charlotte, NC, 282200.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59068TPAScott Thomas1970-07-24—71347475622385 Park Pl, Eden Prairie, MN, 553740.64SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55006TPAPamela Burns1944-05-11——8027 Ridge Rd, Houston, TX0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-52269TPAAnna Luna1999-08-19——5012 Oak St, Jacksonville, FL, 322130.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-61045TPAKyle Miller1927-10-17—2157418181436 Union St, Minneapolis, MN, 554580.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52954TPABryan Espinoza1994-09-02——1947 Lincoln Way, Chandler, AZ, 852750.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-58008TPATeresa Paarker1970-03-07——4695 Ocean Ave, Gilbert, AZ, 852350.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-58139TPAJack Y Dunn2007-02-20——414 Broadway Apt 40, Nashville, TN, 372160.64Name re-casedUnit split from streetEmail lower-casedGender normalised+2 more
TPA-61969TPARoy Hunt1951-05-15—7953319602748 Forest Ave, Eden Prairie, MN, 553790.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61818TPARebekca Mendoza—UHC-41468-6086963900349585 Baseline Rd, Houston, TX, 770940.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54951TPAKimberly Chavez1943-06-23—55652251363310 Oak St, Charlotte, NC, 282910.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-60358TPAKyle Marquez1961-05-17——3116 Main St, Glendale, AZ, 853670.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50743TPALarry Porter1995-06-19——2951 Indian School Rd Apt 5, San Antonio, TX, 782120.64Date of birth reformattedUnit split from streetCity re-casedZIP+4 trimmed+2 more
TPA-55355TPARoy U Mills1949-09-10UHC-24316-20—1396 Union St, Sacramento, CA, 958030.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61721TPAKevin Freeman1952-09-01——7508 Oak St, Mesa, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-52273TPAAmy Reed1945-12-14——6175 Canyon Rd, Austin, TX, 787160.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59358TPAElizabeth Santiago1974-02-24—46341656651713 Ridge Rd, Mesa, AZ, 852740.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-63020TPAPatrick Herrera1997-08-03—72048503171704 Forest Ave, Plano, TX, 750600.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55276TPAJose Wang1988-02-03——3956 Indian School Rd, Atlanta, GA, 303080.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60040TPALsa Willis1974-09-05——1426 Park Pl, Tucson, AZ, 857200.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-54844TPALuri Cruz—UHC-43223-03—3912 Main St, Austin, TX0.64Name re-casedDate of birth unreadableMember ID reformattedCity re-cased+2 more
TPA-62950TPAAnn Sims1992-02-16—40295073132701 Pine Dr, Gilbert, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63002TPAJean Cule1968-08-07—41246947087258 Spring St, Scottsdale, AZ, 852340.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 66 of 290PreviousNext