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-56986TPANancy Hansen1986-12-04—86295224552091 Ridge Rd, Minneapolis, MN, 554200.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53434TPAGloria Guerrero1981-09-15——8067 Apache Blvd, Tucson, AZ, 857910.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55189TPAGloria George1995-08-23—31666674979610 Jefferson Ave, Minneapolis, MN, 554130.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53895TPAGeorge Simpson1953-11-01——3637 Harbor Blvd, Orlando, FL, 328890.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53233TPAMarilyn West1965-09-17UHC-51771-85—5435 Apache Blvd, San Diego, CA, 921560.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-57133TPACarl Wang1944-04-05——8827 River Rd, Orlando, FL, 328000.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-55618TPAChristina Herrera———6995 Pine Dr, Plano, TX, 750520.64Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-59144TPARaymond Munoz1976-05-13UHC-91631-6968069926998454 Apache Blvd, Scottsdale, AZ, 852480.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-57149TPAJoyce Black2005-08-22——9734 Park Pl, Eden Prairie, MN, 553600.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-50281TPAHarold McDonald2006-09-18——1397 Bayshore Dr, Orlando, FL0.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-53144TPAHelen Kelley1996-05-12—77046235589444 Valley View Dr, Columbus, OH, 432480.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53336TPADiana Oliver———7663 Maple Ave, Columbus, OH, 432220.64Date of birth missingStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-55689TPAPamela H Collins1942-09-03——1992 Meadow Ln, Mesa, AZ, 852420.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59984TPAJohn Morales1966-02-26—98978438267673 Camelback Rd, Plano, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-60695TPALawrence Carpenter1948-04-25UHC-02642-89—132 Valley View Dr Apt 22, Columbus, OH, 432810.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58127TPAJoyce Hernandez2005-09-21——9781 River Rd, Eden Prairie, MN, 553190.64Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more
TPA-54040TPAMark Davis1962-06-10—58622330281403 Pine Dr, Mesa, AZ, 852480.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60816TPAPamela Armstrong1974-10-10UHC-77233-16—2114 Jefferson Ave, Plano, TX, 750410.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62542TPAArthur Rivera1966-04-15——8948 Apache Blvd, Houston, TX, 770540.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
TPA-61551TPAAlice F Lopez1992-09-15—57049672247635 Baseline Rd, Tempe, AZ, 852350.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64178TPAJulie Miller2007-01-20—62784060307356 Camelback Rd, Tucson, AZ, 857100.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63931TPAZachary Scott1949-12-24—60678269868108 Canyon Rd, Plano, TX, 750850.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63333TPALarry Moreno1959-04-27—31944910916676 Oak St, Tempe, AZ, 852710.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56953TPAJanet Vega1962-07-19——6144 Baseline Rd Apt 2, Eden Prairie, MN, 553620.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56954TPAJanet Vega1962-07-19——6144 Baseline Rd Apt 2, Eden Prairie, MN, 553620.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-60728TPATeresa Tompson1988-10-23——3780 Mountain View Dr, Tempe, AZ, 852620.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54660TPACarl Long1982-10-17—60943113034180 Maple Ave, Orlando, FL, 328600.64Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-61707TPAThomas Sims1971-03-19—98171314184750 Grand Ave, Orlando, FL, 328980.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-52652TPAVictoria Luna1947-05-10——7581 Willow Ct, Mesa, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-63659TPAGrace Richardson1979-11-01—5666887063489 Ocean Ave, Scottsdale, AZ, 852010.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56965TPABetty Hart1993-04-17—91581802254852 Union St, Charlotte, NC0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-55027TPADeborah Thompson1963-04-19——6191 Lake View Rd, Tucson, AZ, 857670.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60542TPATyler Edwards1988-03-04—84250814228005 Church St, Los Angeles, CA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-52834TPACathreine W Nguyen1998-09-22—94237992534832 Main St, San Antonio, TX, 782650.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-53015TPASusan Edwars1977-01-25—21092206299543 Main St, Sacramento, CA, 958030.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56384TPADavid Simmons1959-08-06——1491 Lake View Rd, Fresno, CA0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63462TPAJordan Kelley1953-06-05——4822 Pine Dr, Eden Prairie, MN0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55647TPAMei Li1953-11-28—71166845569840 Palm Dr, Jacksonville, FL, 322550.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51348TPAPat Carter1994-02-05——6994 Cedar Ln, Miami, FL, 331350.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-57522TPAThomas Foster1999-05-26—3877444007369 Ocean Ave, Denver, CO, 802600.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54727TPAOlivia Q Hall1965-02-10UHC-36984-14—7950 Park Pl, Mesa, AZ, 852420.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-55093TPABetty Rose2004-02-14——1454 Grand Ave, Glendale, AZ, 853320.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60327TPAThomas Ana1983-07-19UHC-79194-9332849167618738 Camelback Rd, Scottsdale, AZ, 852280.64Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more
TPA-60910TPAMariana U Murray1947-11-27—27533573694122 Elm St, Las Vegas, NV0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53466TPALarry Walker———7933 Indian School Rd, Scottsdale, AZ, 852010.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-57899TPAThomas Hamilton1948-05-17——3945 Market St, Glendale, AZ, 853740.64Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-57820TPAMariana Ryan1956-05-09—78732588292596 Valley View Dr, Plano, TX, 750820.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-64168TPADeborah Murray1968-11-04——1166 Park Pl # 367, Las Vegas, NV, 891990.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-53260TPAGloria Fowler1964-09-07—65585881406908 Sage Ct, Tucson, AZ, 857530.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56870TPAGeorge Bryant1965-11-15——2407 Bayshore Dr, San Diego, CA, 921810.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 55 of 290PreviousNext