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-57746TPADenise Rivera1984-07-19——8656 Ocean Ave, Denver, CO, 802970.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-55577TPAJanet Carpenter1987-05-09UHC-93080-3020832235949345 Sunset Blvd, Atlanta, GA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-62604TPAPriya Long2004-12-02——9302 Baseline Rd, Sacramento, CA, 958360.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55685TPAKaren Snyder1983-11-04—75696212068467 Camelback Rd, Scottsdale, AZ, 852370.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-57234TPADrew Cooper1983-06-12UHC-45257-678329935777805 Desert Sky Blvd, Charlotte, NC, 282110.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
TPA-60693TPASharon Nunez1953-04-24——7758 Willow Ct, Las Vegas, NV, 891840.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56407TPANancy Cole2002-04-25——8672 Bayshore Dr, Atlanta, GA, 303240.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-54365TPAWei Bradley—UHC-76357-5531472199492524 Baseline Rd, Columbus, OH, 432970.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55878TPAJackie Le1977-04-28——4245 Meadow Ln, Las Vegas, NV, 891960.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-64333TPABobby Butler1974-09-27——9720 Central Ave, Columbus, OH, 432610.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-62876TPADiego Li1992-02-05——181 Meadow Ln, Jacksonville, FL0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-62875TPADiego Li1992-02-05——181 Meadow Ln, Jacksonville, FL0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-55970TPAPhilip Lawson2008-12-27——8364 Main St, Dallas, TX, 752170.66Two-digit birth yearCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-57115TPAAndrew Dominguez2008-06-06——2936 Broadway, Columbus, OH, 432500.66City re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-56961TPAJose Black1963-09-14—58362176864276 Cedar Ln, Fresno, CA, 937070.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-54312TPABruce Alvraez———8112 Main St, Dallas, TX, 752910.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52802TPARalph J Gutierrez1950-11-24UHC-07884-13—1974 Meadow Ln, Las Vegas, NV0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-50515TPAJoe Crawford1977-07-08——1032 Sunset Blvd, Denver, CO, 802180.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52530TPAChristopher A Austin1944-12-09——8029 Highland Ave, Austin, TX, 787150.66Middle initial moved out of first nameStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53508TPALawrence Diaz1938-06-03—93094408976968 Mesa Dr, Chandler, AZ, 852540.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-62685TPAAnthony Clark1986-08-14——8696 Forest Ave, San Antonio, TX, 782080.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55237TPAMariana Park2000-05-15—3823530792491 Sage Ct, Dallas, TX, 752210.66City re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-59271TPAElizabeth Dean1989-06-12—69350472844310 Church St, Austin, TX, 787470.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60990TPADiane F Flores1957-03-20—9679281052563 Market St # 928, Plano, TX, 750410.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61682TPADennis Patterson1969-03-28——3295 Market St # 470, Eden Prairie, MN, 553740.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-57613TPABrandon Johnson1990-06-21——8128 Washington St, Denver, CO, 802890.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-53879TPAAmanda Reyynolds1981-04-11—32628910117514 Ocean Ave, Tucson, AZ, 857250.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-56547TPAChristina Gardner1973-08-26——3126 Central Ave, Gilbert, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-60500TPALauren L Johnston1983-11-27——5404 Jefferson Ave, Tempe, AZ, 852250.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-52441TPASara Carr2001-07-14—50494520511350 Market St, Scottsdale, AZ, 852380.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-55226TPAChristina Caarroll1990-07-10——4892 Indian School Rd, Scottsdale, AZ, 852840.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-63111TPAChristine Moore———8018 Maple Ave, Scottsdale, AZ, 852670.66Name re-casedDate of birth unreadableCity re-casedZIP+4 trimmed+1 more
TPA-55784TPAMarcus Chavez———5658 Valley View Dr, Nashville, TN, 372980.66Name re-casedDate of birth missingGender normalisedWhitespace trimmed+1 more
TPA-57298TPACarol M Rodriguez1997-06-02——5317 Forest Ave, Nashville, TN, 372270.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-56188TPAElijah Taylor1985-04-15——5130 Highland Ave # 213, Dallas, TX, 752700.66Unit split from streetStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-59631TPASara Tran2003-09-20———0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-53295TPADennis Santos1998-09-18——2748 Sage Ct # 382, Tucson, AZ, 857430.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-51854TPAGabreil Russell1955-12-23UHC-05189-61—4477 Washington St, Columbus, OH, 432580.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60562TPAMargaret Roberts1939-12-16——5221 Cedar Ln, Houston, TX, 770170.66SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-61438TPARandy Edwards1976-04-07——1054 Washington St # 580, Miami, FL, 331280.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55710TPAChristopher Thomas1964-04-22——1594 Jefferson Ave, San Diego, CA, 921970.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-52948TPAJacqueline Nunez1947-06-14——2269 Sage Ct, Glendale, AZ, 853420.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51881TPA—Junk1955-10-14UHC-43403-52—1637 Mountain View Dr, Glendale, AZ, 853560.66Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared+1 more
TPA-61214TPALauren Frenklin——6453919863—0.66Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+1 more
TPA-59525TPAPamela Grant1949-06-15——6343 Maple Ave, Denver, CO, 802350.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-62364TPAReymond Reed1997-07-04——8798 Lincoln Way, Orlando, FL, 328560.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-63730TPASharon Lewis1982-06-20——7383 Central Ave, Houston, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-59628TPARobert Wells1998-08-26——6881 Ocean Ave, Nashville, TN, 372790.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56682TPAGordon Joshua1958-12-25——4104 Union St, Jacksonville, FL, 322860.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61614TPABobby Hnasen1941-09-22——1878 Lake View Rd, Tampa, FL, 336620.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 80 of 290PreviousNext