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-52981TPABen Davis1971-12-09—96378817784361 Cedar Ln, Las Vegas, NV, 891510.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61950TPAEugene Oliver1980-09-23—29380070943552 Spring St, Charlotte, NC, 282210.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-56076TPADoris Dominguez2001-12-16——607 Sage Ct, Tampa, FL, 336560.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63745TPAJanet Vazquez1988-12-01——2641 Palm Dr, Seattle, WA, 981100.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56486TPACarol G Bishop1991-06-15—29992358848981 Church St, Columbus, OH, 432320.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62434TPALogan Young1946-04-22—2883596938602 Mesa Dr, San Antonio, TX, 782220.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56020TPASamantha Diaz1998-08-23——1859 Meadow Ln, Tucson, AZ, 857890.74Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57515TPAJordan Hill2001-11-11—26871619786475 Washington St, Orlando, FL, 328770.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61722TPABran Aguilar1948-09-16—34582285698656 Central Ave, Denver, CO, 802250.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50323TPAJacob Obrien1953-12-07UHC-35819-3589743929858849 Cedar Ln, San Diego, CA, 921420.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57146TPATeresa Martinez1976-02-26——332 Cedar Ln, Tucson, AZ, 857520.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63425TPAVincent Meyer1984-12-22—3678386470237 Sage Ct, Plano, TX, 750140.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62501TPAWayne Ray2003-12-15—22099949711480 Jefferson Ave, Dallas, TX, 752960.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61751TPARalph Martinez1965-03-28——9712 Main St, Atlanta, GA, 303360.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52381TPAPaul Warren1950-04-14——8163 Hillcrest Rd, Columbus, OH, 432530.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53278TPABarbara M Estrada1942-09-28UHC-62835-1544447494465846 Highland Ave, Glendale, AZ, 853030.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
TPA-51259TPAJim Reid2008-10-13——5685 Sage Ct, Scottsdale, AZ, 852690.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62489TPAOlivia Woods1971-02-02—33834755133669 Broadway, Fresno, CA, 937110.74Name re-casedDate of birth reformattedPhone reformattedAddress re-cased+3 more
TPA-56890TPAAustin Reid1958-06-25—62344399596147 Harbor Blvd, Mesa, AZ0.74Name re-casedDate of birth reformattedPhone reformattedState code upper-cased+3 more
TPA-55624TPABrenda Long1955-11-11—93683886277814 Hillcrest Rd, San Antonio, TX, 782090.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62545TPAGeorge Munoz1955-12-02UHC-50698-4398987725425175 Indian School Rd, Atlanta, GA, 303850.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61676TPAHiroshi N Greene1997-09-26——7106 Market St, Sacramento, CA, 958960.74Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53320TPAJonathan J Scott1964-01-16—60028811785318 Maple Ave, Seattle, WA, 981590.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52729TPAPatricia Diaz1988-12-12UHC-24304-3922491437981160 Washington St, Minneapolis, MN, 554270.74Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-51266TPAAlexis G Porter1963-01-26—60261419205157 Hillcrest Rd, Sacramento, CA, 958030.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50641TPAAsutin Stevens1992-06-12—73766883709145 Canyon Rd, Columbus, OH, 432810.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50640TPAAsutin Stevens1992-06-12—73766883709145 Canyon Rd, Columbus, OH, 432810.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50208TPALawrence Sanchez1939-11-08UHC-61874-0722370782936912 Baseline Rd, Tucson, AZ, 857160.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51342TPARyan Rios1988-09-13—8335460505635 Union St, Tucson, AZ, 857980.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54217TPAAlan Ramos1971-09-24—979342686334 Washington St, Seattle, WA, 981320.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58109TPAHelen Oliver1978-08-26—74466773287301 Church St, Columbus, OH, 432500.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52070TPAAnn Cook2002-01-18UHC-96679-77—6761 Park Pl, Fresno, CA, 937460.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50917TPAAna Fox1954-09-13UHC-70153-8069864024239363 Lake View Rd, Minneapolis, MN, 554960.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-55456TPAKyle Park1987-07-17UHC-98992-5366566853961344 Central Ave, Tempe, AZ, 852210.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52490TPAAaron Colle1994-08-21—74043106543158 Elm St, Tucson, AZ, 857420.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53013TPAJason Robertson1950-01-11—35078466314486 Baseline Rd, Dallas, TX, 752230.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-54905TPAVictoria Padilla1952-10-26UHC-84331-08—5959 Canyon Rd, Las Vegas, NV, 891220.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-63039TPAGloria Lopez1942-12-10—66341138641893 Central Ave, Tempe, AZ, 852230.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62593TPAPhilip Red1951-08-10——3340 Palm Dr, Nashville, TN, 372370.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-56312TPAMargaret Rice2001-03-12——1283 Church St, Eden Prairie, MN, 553870.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60205TPAWilliam Knight1941-02-10—3535879695267 Grand Ave, Los Angeles, CA, 900700.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-53236TPABrian Vazquez1970-07-16—36466159984314 Washington St, Sacramento, CA, 958310.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50849TPAAlbert Fields1969-03-03—96621192793255 Union St, Minneapolis, MN, 554200.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-57109TPADaniel Ward1948-04-16—35483943588568 Highland Ave, Austin, TX, 787310.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51991TPASofia Baker1944-07-07—68554470212623 Baseline Rd, Dallas, TX, 752610.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59651TPAHannah Gonzales1965-10-12—67332238432372 Central Ave, Fresno, CA, 937030.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61125TPAElijah Li1942-01-05—54633065926856 Mesa Dr, Las Vegas, NV, 891900.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-56996TPAChristine Harvey1997-03-09—3793261896141 Apache Blvd, Tucson, AZ, 857530.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58279TPARalph Z Bell1976-11-03—48139047998457 Apache Blvd, Tempe, AZ, 852010.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-54305TPABryan Williams2007-08-09—21983656683380 Park Pl, Tempe, AZ, 852010.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
14,474 rows, page 107 of 290PreviousNext