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-55275TPAMegan Herrera1991-02-23——4453 Indian School Rd, Denver, CO, 802280.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-60780TPADeborah Grant1942-10-14UHC-98028-7668492075014908 Ridge Rd, Chandler, AZ, 852030.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-55310TPABilly Lawson1989-05-13——2366 Oak St, Columbus, OH, 432030.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
TPA-63424TPAVincent Meyer1984-12-22—3678386470237 Sage Ct, Plano, TX, 750140.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-59885TPAMarilyn Hall1963-03-04——1501 Valley View Dr, Eden Prairie, MN, 553040.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60786TPAAna P Burns2008-04-14——5119 Willow Ct, Dallas, TX, 752720.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-52309TPAPamela Griffin1942-08-10UHC-70075-68—9620 Cedar Ln, Fresno, CA, 937000.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62946TPAKayla B Dominguez2005-12-04——9187 Hillcrest Rd, Mesa, AZ, 852310.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60173TPAWillie Washington1952-03-19—6058602454893 Sunset Blvd, Seattle, WA, 981470.66Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
TPA-52343TPAEdward Herrera1942-04-27—75163143518620 Harbor Blvd, Tampa, FL, 336760.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-57773TPADavid Andrews1950-09-02UHC-01919-1869540093483567 Sunset Blvd, Jacksonville, FL, 322150.66Phone reformattedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
TPA-60825TPAAndrew Sanders1991-07-16—20444513095567 Bayshore Dr, Tampa, FL, 336170.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-55997TPADnaiel Sanchez2004-03-03——345 Main St, Austin, TX, 787990.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-59343TPAJuan Dean1978-07-12—91920938117400 Church St, Glendale, AZ, 853760.66Phone reformattedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
TPA-56585TPADouglas Carpenter1945-07-21UHC-55704-92—3423 Jefferson Ave # 642, Tampa, FL, 336480.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-63291TPARoy Young1986-11-17——967 Oak St, Gilbert, AZ, 852020.66Name re-casedDate of birth reformattedState name converted to codeGender normalised+1 more
TPA-56706TPASamuel Robinson1966-03-26——944 Hillcrest Rd, Los Angeles, CA, 900800.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64429TPAPatrick Wells1969-09-19——8113 Church St, Nashville, TN, 372970.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54881TPACynthia Chapman—UHC-71505-92—5035 Camelback Rd, Glendale, AZ, 853410.66Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-55930TPAEdward Cook1976-03-25—504735088539 Mesa Dr, Eden Prairie, MN, 553020.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61300TPAJustin Oliver1964-08-14——7132 Church St, Las Vegas, NV, 891950.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59813TPAHeather Cox1957-09-25——613 Ridge Rd, Los Angeles, CA, 900080.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-64396TPAHiroshi Peterosn1947-08-28UHC-47694-32—6875 Apache Blvd # 572, Gilbert, AZ, 852340.66Date of birth reformattedUnit split from streetCity re-casedGender normalised+1 more
TPA-59802TPAOmaar Myres1982-12-10——7679 Maple Ave, Orlando, FL0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-52612TPAHunt Stephanie1938-10-16—45620207861688 Grand Ave, San Diego, CA0.66Phone reformattedZIP missingGender normalisedWhitespace trimmed+1 more
TPA-60521TPAJohn Hamilton1939-02-07——3945 Main St, Tucson, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-58952TPAKayla Gomez1981-07-08——8000 Lake View Rd, Plano, TX, 750120.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-61883TPAPatrick Walker1997-07-01UHC-86582-20—9298 Washington St, Atlanta, GA, 303620.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-58023TPAJulia Tran1973-07-16——7521 Meadow Ln, Sacramento, CA, 958240.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62333TPASarah Perkins1949-06-25——2882 Indian School Rd, Sacramento, CA, 958220.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62332TPASarah Perkins1949-06-25——2882 Indian School Rd, Sacramento, CA, 958220.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-61791TPAJose Harvey1991-04-12——8461 Elm St, San Diego, CA, 921360.66Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-54759TPACharlotte Kenndy2008-05-19——1168 Apache Blvd, San Diego, CA, 921460.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-51562TPAMary Edwards1949-09-06——7363 Forest Ave, Miami, FL, 331760.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51871TPAJoseph Porter1950-10-08UHC-81208-98—6339 Valley View Dr, Chandler, AZ, 852450.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-59134TPACynthia West1970-05-14UHC-57502-44—8007 Washington St, Tampa, FL, 336810.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-57396TPASophia Ryan1958-07-11—51492382022546 Ridge Rd, Tucson, AZ, 857540.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-63991TPADorothy Russell1990-09-17—70492318569373 Spring St, Mesa, AZ, 852080.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-57220TPAKenneth Miller1954-07-05——9815 Indian School Rd, Plano, TX, 750430.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
TPA-58399TPAValentina Mendoza1991-04-01—68562244105443 Washington St, Eden Prairie, MN, 553150.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55623TPAWei Johnnson1982-08-04—79450349558648 Spring St, Miami, FL, 331830.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52414TPAAnn Simpson1975-01-13—426830885163 Indian School Rd, Tempe, AZ, 852970.66Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+1 more
TPA-57756TPAMariana Mreno1964-01-12UHC-30139-4990785463972366 Apache Blvd, Jacksonville, FL, 322690.66Date of birth reformattedPhone reformattedState name converted to codeGender normalised+1 more
TPA-61186TPAShirley Thomas1950-01-03—89149420534157 Jefferson Ave, San Diego, CA, 921550.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-58043TPABradley Williamson1951-10-02——5316 Forest Ave, Charlotte, NC, 282890.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-52535TPARebecca Burton1945-09-24——4816 Central Ave, Orlando, FL, 328730.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-54114TPALawrence Wheeler———6746 Meadow Ln, Orlando, FL, 328040.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-58348TPAJack Boyd———1043 Washington St, Columbus, OH, 432690.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56868TPAChristina Turner1980-02-06——4965 Meadow Ln, Tucson, AZ, 857100.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-62248TPAGabriel Weber2004-05-01——3435 Desert Sky Blvd, San Antonio, TX0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
14,474 rows, page 76 of 290PreviousNext