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-58432TPAVictoria Yang1998-08-24—87155327644664 Forest Ave, Gilbert, AZ, 852480.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-53502TPASharon B Aguilar1981-06-17——9777 Grand Ave, Scottsdale, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-61108TPAPatrick J Turner1980-02-22—74678954689136 Jefferson Ave, Phoenix, AZ, 850160.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52603TPAAnna Gonzalez1984-04-25——425 Elm St, Denver, CO, 802410.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-51129TPAAisha Richards1955-10-16——7394 Harbor Blvd, Dallas, TX, 752950.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64388TPAJacqueline Rogers1972-07-03——8721 Ridge Rd, Scottsdale, AZ, 852970.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59792TPAAmber Ward2008-04-19——1260 Willow Ct, Austin, TX0.66Name re-casedTwo-digit birth yearZIP missingWhitespace trimmed+1 more
TPA-60534TPALori Q Yang1974-08-09—71747544655415 Forest Ave Apt 11, Dallas, TX, 752730.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64448TPAAdam Williamson1957-09-07—20623765996488 Central Ave, Fresno, CA, 937720.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-55075TPALawrence Mills1946-01-24——1067 Jefferson Ave, Seattle, WA, 981950.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-58378TPAWillie F Ray1961-09-01UHC-49421-70—271 Valley View Dr, Las Vegas, NV0.66Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+1 more
TPA-59013TPAAlice Hernandez1987-10-06——4948 Sage Ct, Nashville, TN, 372110.66Name split from “Last, First”Date of birth reformattedCity re-casedZIP+4 trimmed+1 more
TPA-52138TPAJacqueline Simmons2004-06-06——917 Spring St, Tempe, AZ, 852490.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58754TPABryan Remirez1996-01-11——9889 Indian School Rd, Plano, TX, 750090.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-63390TPACharrles X Butler1963-10-19——7058 Central Ave, Miami, FL, 331870.66Middle initial moved out of first nameName re-casedState name converted to codeWhitespace trimmed+1 more
TPA-56823TPAOlivya Perez1963-04-16——1737 Union St, Tampa, FL, 336890.66Street suffix standardisedAddress re-casedState name converted to codePlan code upper-cased+1 more
TPA-53909TPAGebriel O Mejia1961-12-12——1816 Forest Ave, Orlando, FL, 328260.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60477TPABenjamin Cox1983-03-07——2173 Main St, San Antonio, TX, 782300.66Name re-casedPhone missing area codeCity re-casedState name converted to code+1 more
TPA-51391TPAWatler Espinoza1973-10-15—89584432767825 Cedar Ln, Orlando, FL, 328510.66Name split from “Last, First”Phone reformattedSSN last four extractedWhitespace trimmed+1 more
TPA-60496TPAHeather Fuller1938-09-04——5849 Mesa Dr, Minneapolis, MN, 554780.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-61455TPAMartha Perkins2004-06-14——1561 Desert Sky Blvd, Mesa, AZ, 852130.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-51018TPALarry S Washington1982-12-10UHC-42860-77—475 Spring St, Glendale, AZ, 853720.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61201TPASandra Knight1956-08-03——5560 Sage Ct, Chandler, AZ, 852520.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-60075TPADouglas M Kim1940-07-09——5295 Market St, Fresno, CA, 937110.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-56780TPAJose Reyes1942-06-27UHC-54323-1676989335725287 Valley View Dr, Charlotte, NC, 282500.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-60724TPAAmber Reed1938-04-08——715 Valley View Dr, Miami, FL, 331830.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52474TPAMike Ward1943-01-07——7019 Spring St, San Antonio, TX, 782630.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-54035TPAEmma Q Estrada1978-03-01—46969082667700 Sage Ct, Charlotte, NC, 282690.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63263TPAChristine Marquez1941-01-03——5341 Meadow Ln, Tampa, FL, 336270.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-60838TPADiana Castro1977-10-11——2172 Ocean Ave, Orlando, FL, 328380.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53055TPAStephen Bryant1977-04-15——9317 Lincoln Way, Glendale, AZ, 853840.66Name split from “Last, First”City re-casedGender normalisedWhitespace trimmed+1 more
TPA-63243TPAJack Pierce1996-01-01—34992827698375 Spring St, Eden Prairie, MN, 553370.66Name re-casedTwo-digit birth yearState name converted to codeWhitespace trimmed+1 more
TPA-62165TPANancy Alexander—UHC-02077-35—4505 Spring St, Dallas, TX, 752530.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54415TPAPriya Aguilar2000-10-24——6298 Pine Dr, San Diego, CA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-51127TPAGregory Richardson1960-04-11UHC-32697-71—1687 Palm Dr, Dallas, TX, 752710.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-50770TPATimothy T Hill2008-11-08—67842187984849 Spring St Apt 19, Houston, TX, 770720.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-52866TPAKayla Henry1969-11-11——5247 Spring St, Columbus, OH, 432220.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60093TPAMelissa Owens1972-03-18——7251 Sunset Blvd, San Antonio, TX, 782220.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-62797TPAJudy Patterson1998-03-07——7921 Church St, Austin, TX, 787670.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-59122TPAAaron Pierce1942-09-19UHC-91720-52—7423 Park Pl, Houston, TX, 770630.66Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+1 more
TPA-56537TPAWells Rachel1974-05-08——4991 Market St, Minneapolis, MN, 554850.66Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+1 more
TPA-59328TPARalph Wang1952-06-03——7240 Grand Ave, Atlanta, GA, 303440.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-51682TPAAndrea U Brown1977-01-22—34475772232828 Desert Sky Blvd, San Diego, CA, 921050.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62310TPACheryl Wagner1962-03-27——7207 Spring St, Dallas, TX, 752470.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-64404TPABrian Hughes1940-08-27——6137 Valley View Dr, Charlotte, NC, 282350.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-53191TPATheresa P Stevens1954-10-25——9388 Church St, Eden Prairie, MN0.66Name re-casedState name converted to codeZIP missingWhitespace trimmed+1 more
TPA-56905TPAJerry Brooks2006-11-13——9445 Market St, Glendale, AZ, 853720.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-58170TPA—Junk1994-02-07——5068 Ocean Ave, Dallas, TX, 752180.66Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared+1 more
TPA-63596TPAWayne Spencr1999-12-01—55347268399632 Church St, Houston, TX0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
TPA-53031TPAEmily Greene1972-11-07—29755597074133 Willow Ct, Chandler, AZ, 852860.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
14,474 rows, page 71 of 290PreviousNext