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-51630TPAJennifer Perez———6039 Grand Ave, Tucson, AZ, 857490.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56616TPAJudith Owens1969-09-17——8433 Lincoln Way, Miami, FL, 331510.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
TPA-52372TPAElijah Tran2008-03-05—60056978135797 Elm St, San Antonio, TX0.66Phone reformattedState name converted to codeZIP missingEmail lower-cased+1 more
TPA-61981TPAJordan D Padilla2000-03-12——1639 Baseline Rd, Phoenix, AZ, 850320.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-58048TPAJean Singh1951-03-25——6624 Hillcrest Rd, Phoenix, AZ, 850540.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53146TPAKevin Peters1976-04-17——2466 Broadway, Columbus, OH, 432970.66Two-digit birth yearAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-63134TPAChristina Jimenez1945-06-26—57949242521998 Desert Sky Blvd, Scottsdale, AZ, 852790.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61899TPAJuan N Hunter1965-09-22—61877348425057 Valley View Dr, Chandler, AZ, 852490.66Name split from “Last, First”Phone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-59822TPABarbara Howadr1979-03-23——3433 Highland Ave, Fresno, CA, 937360.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-57561TPARandy Armstrong1959-01-07——5427 Harbor Blvd, San Antonio, TX, 782270.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-63185TPALuis Stevens2003-07-18——7599 Grand Ave, Sacramento, CA, 958500.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56811TPAJean Robertson1961-11-09—69672034987484 Camelback Rd # 960, Columbus, OH, 432340.66Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+1 more
TPA-50169TPAMark Stevens1987-08-18UHC-76775-97—3343 Apache Blvd, Sacramento, CA, 958820.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-54237TPAPatricia Phillips1963-07-20——3971 Jefferson Ave # 862, Los Angeles, CA, 900100.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50643TPAMartha Carter1989-09-22UHC-40028-3089233398418319 Lake View Rd, Las Vegas, NV, 891040.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-55131TPABrandon Park1957-07-13——1620 Willow Ct, Scottsdale, AZ, 852940.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-52475TPAJack M Ortiz1957-12-15UHC-23081-51—8618 Elm St, Mesa, AZ, 852340.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-61896TPAEmily Tran1969-09-23——6266 Bayshore Dr, Denver, CO, 802310.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64251TPADavid Howell1978-06-19——1246 Camelback Rd # 223, Columbus, OH, 432100.66Name split from “Last, First”Unit split from streetCity re-casedWhitespace trimmed+1 more
TPA-50813TPAEmily Warreen1996-07-11—66963300668997 Maple Ave, Mesa, AZ, 852600.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54915TPAMei Elis1938-06-27UHC-77487-48—1321 Ridge Rd, San Antonio, TX, 782760.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-54914TPAMei Elis1938-06-27UHC-77487-48—1321 Ridge Rd, San Antonio, TX, 782760.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-61562TPAMark Marquez1953-02-28—71064276615772 Sage Ct, San Antonio, TX, 782710.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60820TPAPriya Oliver1991-12-26UHC-10668-45—8786 Harbor Blvd, Glendale, AZ, 853780.66Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+1 more
TPA-58803TPAJudy Ward1978-11-04——931 Sunset Blvd, San Antonio, TX, 782190.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-60459TPAAmanda Martinez1962-06-21—5305175038700 Church St Apt 38, Orlando, FL, 328880.66Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+1 more
TPA-59014TPATyler S Hrt1943-02-14—79798748757011 Camelback Rd, Scottsdale, AZ, 852210.66Name split from “Last, First”Date of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-53075TPAValentina Mejia1987-12-19—27063925712993 Bayshore Dr, Tucson, AZ, 857240.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-54596TPACarolyn Price2005-12-07——8651 Ridge Rd, Atlanta, GA, 303910.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60284TPAYuki Wright1986-02-22—94668355889017 Pine Dr, Jacksonville, FL, 322410.66City re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-60206TPAPhilip J Morrison1945-03-05——4733 Meadow Ln, Las Vegas, NV, 891020.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-61989TPASteven N Welch2002-11-08UHC-34050-08—9598 Mountain View Dr, Atlanta, GA, 303680.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-61990TPASteven N Welch2002-11-08UHC-34050-08—9598 Mountain View Dr, Atlanta, GA, 303680.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-58461TPAMichelle Mason1990-12-28——4639 Forest Ave, Seattle, WA, 981940.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-59289TPAHeather Riso1943-01-24UHC-25713-90——0.66Name split from “Last, First”Date of birth reformattedMember ID reformattedGender normalised+1 more
TPA-64100TPAHenry Waard1939-03-06——2753 Sunset Blvd, San Diego, CA, 921600.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50036TPAAustin O Aguilar1993-07-28——3665 River Rd, Los Angeles, CA, 900490.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-51471TPAJoseph Martin1948-01-18——4130 Washington St, Gilbert, AZ, 852850.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-52660TPALuis Reynolds1946-04-03—40526450215142 Baseline Rd, Tucson, AZ, 857050.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52900TPAJames Alexander1966-08-01UHC-16779-1571761562484342 Harbor Blvd, Columbus, OH, 432290.66Name re-casedPhone reformattedSSN last four extractedState name converted to code+1 more
TPA-64308TPAJuztin L Cruz1944-09-18——2917 Ridge Rd Apt 1, San Antonio, TX, 782730.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-63720TPASoophia Wang1950-01-28—62035191676636 Spring St, Jacksonville, FL0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-60470TPAAlexis Edwards2002-05-11——2299 Cedar Ln, Atlanta, GA, 303200.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-62214TPAHiroshi A Moore1950-09-08——952 Union St # 246, Glendale, AZ, 853880.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-51532TPADiego O Castillo2007-02-09——3312 Maple Ave, Houston, TX, 770380.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-60513TPADaniel Stephens1993-08-03—59850321904109 Willow Ct, Tempe, AZ, 852440.66Name re-casedPhone reformattedState name converted to codeGender normalised+1 more
TPA-53025TPARutth Harvey1940-10-13UHC-80628-18—5958 Main St, Gilbert, AZ, 852250.66Two-digit birth yearCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-62149TPAEric I Schmidt2005-05-04——311 Meadow Ln, Mesa, AZ0.66Name re-casedTwo-digit birth yearZIP missingWhitespace trimmed+1 more
TPA-55120TPALawrencce E Mejia———8170 Church St, Tucson, AZ, 857270.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-61339TPAMei Maldonado1945-11-02——7457 Park Pl, Houston, TX, 770820.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
14,474 rows, page 77 of 290PreviousNext