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-64081TPALogan U Flores1967-12-06—61169889887165 Sunset Blvd, Sacramento, CA, 958760.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-54728TPAJudy Maritn1977-07-26—92881113359886 Highland Ave, Gilbert, AZ0.78Name re-casedDate of birth reformattedPhone reformattedZIP missing+1 more
TPA-60291TPAEugene C Padilla2007-06-27—53786330731804 Ridge Rd, Chandler, AZ, 852990.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56445TPAKayla Mendez1963-06-14—56088949913449 Forest Ave # 281, Plano, TX, 750170.78Name re-casedDate of birth reformattedUnit split from streetWhitespace trimmed+1 more
TPA-61837TPAChristian Simmons1990-12-02——976 Valley View Dr, Mesa, AZ, 852690.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60261TPAEvelyn Palmer1956-01-03—53352733492570 Lake View Rd, Fresno, CA, 937700.78Name re-casedTwo-digit birth yearState code upper-casedWhitespace trimmed+1 more
TPA-61109TPAJean Gonzales1941-09-26UHC-86751-2435847574966416 Canyon Rd, San Antonio, TX, 782770.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51828TPAPhilip Nichols1988-04-04—61449717565140 Park Pl, San Diego, CA, 921550.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64119TPASamuel Kim1969-07-22—62464473933839 Park Pl, Columbus, OH, 432160.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-64120TPASamuel Kim1969-07-22—62464473933839 Park Pl, Columbus, OH, 432160.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-58839TPAOlivia Campbell1987-09-15—41787862734368 Cedar Ln, Los Angeles, CA, 900350.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50072TPASean Cook1984-03-16—33527034699409 Valley View Dr, Jacksonville, FL, 322100.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63776TPAStephen Robertson1974-04-26——4568 Canyon Rd, Fresno, CA, 937350.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-56533TPAIsabella Burton1980-11-25——3009 Apache Blvd, Tempe, AZ, 852380.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50957TPAKimberly West1987-09-24——1188 Pine Dr, Los Angeles, CA, 900050.78Name re-casedDate of birth reformattedPhone missing area codeWhitespace trimmed+1 more
TPA-56641TPAElizabeth N Ray1992-08-26——3693 Main St, Scottsdale, AZ, 852880.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55991TPAMargaret Taylor2005-06-28—39039456147621 Ridge Rd, Austin, TX, 787610.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55869TPAAmanda West1987-06-04——9779 Valley View Dr, Tucson, AZ, 857340.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-57373TPACharles Watson1952-06-16—71020904252196 Spring St, Tempe, AZ, 852210.78Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-57803TPAWilliam Tucker1940-03-14——136 Elm St, Minneapolis, MN, 554800.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50482TPALarry Bennett1975-08-04——5746 Market St, Columbus, OH, 432780.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-54861TPAHunter Cyntiha1967-08-19UHC-39831-20—668 Hillcrest Rd, Fresno, CA, 937020.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63688TPAChristian Coleman2001-06-07——1394 Palm Dr, San Diego, CA, 921750.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-63888TPANatalie Moore1963-05-18—27324988691524 Valley View Dr, Austin, TX, 787760.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-52208TPAAnna Martin1966-05-02—4813589530766 Park Pl, Chandler, AZ, 852610.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58744TPARyan L Castillo1957-12-14——4562 Lake View Rd, Tucson, AZ, 857000.78Date of birth reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more
TPA-53369TPAPeter Kelly1981-07-09UHC-28833-25—8295 Mountain View Dr, Las Vegas, NV, 891060.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60037TPATiomthy Butler2006-02-24—38622376264267 Church St Apt 38, Seattle, WA, 981570.78Date of birth reformattedPhone reformattedUnit split from streetWhitespace trimmed+1 more
TPA-58360TPALawrence Burke1981-07-17——6947 Apache Blvd, Mesa, AZ, 852510.78Name re-casedDate of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-61379TPADoris Klly1957-03-07——9827 Highland Ave, Seattle, WA, 981620.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-62714TPACheryl Garza2004-07-18—3125114372207 Union St, Tempe, AZ, 852030.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-50326TPAMatthhew Hayes1993-02-07—46492191325670 River Rd, Denver, CO, 802200.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61507TPARoy W Orega1952-09-11——5579 Baseline Rd, Phoenix, AZ, 850540.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60039TPALogan Richards1975-05-13———0.78Date of birth reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more
TPA-59189TPAMichelle Carpenter1960-07-18——8637 Ocean Ave, Chandler, AZ, 852780.78Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-59478TPAKim Harvey1960-01-28——1939 Palm Dr, Miami, FL, 331530.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-63599TPAJudy Armstrong1940-08-04—3349330130—0.78Phone reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more
TPA-61524TPAAdem Vasquez1973-04-07—94172967375966 Cedar Ln, Charlotte, NC, 282880.78Name re-casedCity re-casedState name converted to codeWhitespace trimmed+1 more
TPA-56183TPAMark Garza1946-07-07—52687559307320 Washington St, Charlotte, NC, 282010.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54042TPAJason K Gordon1952-06-05—22773068128596 Desert Sky Blvd, Plano, TX, 750520.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56337TPAAna Wong1980-05-28—39559593764229 Pine Dr, Scottsdale, AZ, 852770.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-57554TPASantiago Edwards2005-04-18——2556 Oak St, Sacramento, CA, 958470.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-63772TPALiz D Myers1981-12-18——9332 Ridge Rd, Dallas, TX, 752920.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63712TPARobert Patterson1982-10-18——8502 Ridge Rd, Phoenix, AZ, 850040.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-61375TPAJoan J Soto1981-05-17——1004 Apache Blvd, Los Angeles, CA, 900000.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-64341TPAPaul Morris1987-08-17——9224 Sunset Blvd, Las Vegas, NV, 891570.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60984TPABetty Wang1977-05-08—37350192812663 Park Pl, Glendale, AZ, 853350.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59459TPAAngela Burns1967-09-14——743 Lake View Rd, Sacramento, CA, 958150.78Date of birth reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-51214TPAAlan Brown2004-01-08—6279760412740 Central Ave, Phoenix, AZ, 850770.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59992TPAWilliam Hudson1995-08-11UHC-43451-15—5967 Church St, Tempe, AZ, 852980.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
14,474 rows, page 143 of 290PreviousNext