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-56864TPAPeter V Baker2001-04-28——9241 Sunset Blvd, Fresno, CA, 937570.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60476TPABryan Hamilton2002-06-03——2921 Ocean Ave, Denver, CO, 802230.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63715TPAAnthony Gibson1963-06-08—57046434422139 Forest Ave, Minneapolis, MN, 554280.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50877TPABrian K Wong1946-09-25——2639 Canyon Rd, Plano, TX, 750330.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62188TPALogan Spencer—UHC-89476-4892667593826116 Meadow Ln, Las Vegas, NV, 891910.78Date of birth unreadablePhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-51793TPACamila D Alvarado1977-07-19——2575 Park Pl, Charlotte, NC, 282010.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60996TPAWei Cruz1943-11-23UHC-51966-6380428960079317 Indian School Rd, Plano, TX, 750140.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54162TPAJessica Beennett1991-05-02——5439 Camelback Rd, Denver, CO, 802060.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58482TPABrenda Harris1986-05-16——5419 Jefferson Ave, Plano, TX, 750430.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60665TPABrandon Guzman1948-12-09—37089703173766 Sunset Blvd, Tempe, AZ, 852260.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-63294TPAFrank Yang1954-06-13——4140 Jefferson Ave, Nashville, TN, 372720.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62777TPACheryl Weaver1965-09-19——5516 Lake View Rd, Miami, FL, 331260.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54401TPAShirley George1976-07-24——7203 Sunset Blvd, Charlotte, NC, 282310.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-61672TPAPhilip Gilbert1978-05-09——69 Meadow Ln, Jacksonville, FL, 322030.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64187TPALogan Otriz1960-07-15—33774333876603 Jefferson Ave, Miami, FL, 331910.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62166TPAMariana Owens1998-06-24—51989818776172 Ocean Ave, Orlando, FL, 328360.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53427TPABen Webb1967-03-24UHC-91181-7341847092719584 Hillcrest Rd, San Diego, CA, 921730.78Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51830TPAKevin Bakeer2001-01-12—89668714869150 Church St, Jacksonville, FL, 322250.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57757TPAMason Espinoza1941-11-26——9727 Canyon Rd, Scottsdale, AZ, 852560.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59297TPAMaria Fields2001-09-12—87926882398076 Highland Ave, Seattle, WA, 981950.78Street suffix standardisedAddress re-casedState code upper-casedEmail lower-cased+1 more
TPA-64016TPAChristian Rivera1988-10-19UHC-65906-62—1552 Willow Ct, Tucson, AZ, 857850.78Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62182TPADonald Adams1946-11-07——9804 Sunset Blvd, Plano, TX, 750030.78Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-58388TPAHiroshi Espinoza1997-12-09—92584954332482 Mesa Dr # 998, Tempe, AZ, 852260.78Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+1 more
TPA-57173TPAAlbert Deniels1954-05-11——5558 Oak St, Tampa, FL, 336810.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53542TPAKimberly Maldonado1991-02-08——8564 Washington St, Columbus, OH, 432550.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52342TPAMegan Chavez2006-02-24——1613 Lincoln Way, Las Vegas, NV, 891120.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62152TPABrian Matthews1964-09-19——6673 Meadow Ln, Miami, FL, 331320.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64346TPAJnaet Hernandez1974-05-06——37 Oak St, Orlando, FL0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-56109TPADiana V Bowman1949-07-02—83760576543258 Forest Ave, Tucson, AZ, 857420.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61221TPADennis Daniels1972-02-10UHC-93018-85—3114 Elm St, Houston, TX, 770410.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62200TPAMargaret Ryan1961-09-12—24188577343627 Mountain View Dr, Nashville, TN, 372290.78Phone reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more
TPA-60452TPASarah Boyd1955-02-23UHC-43849-7980931010761040 Willow Ct, Glendale, AZ, 853760.78Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58428TPAMegan Ortega1972-09-09UHC-29695-462283978085—0.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-55609TPAEthan U Turner1979-07-21UHC-63512-82—3909 Central Ave, Seattle, WA, 981190.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-63469TPAEvelyn Hudson1989-06-07——1021 Grand Ave, Plano, TX, 750340.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58365TPABarbara Castillo1940-11-11——2447 Mesa Dr, Columbus, OH, 432920.78SSN last four extractedCity re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-55938TPAJennifer Auilar1938-06-12——1514 Harbor Blvd, Gilbert, AZ, 852100.78Name re-casedDate of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-55119TPAJuan Jordan2000-07-03——7107 Jefferson Ave, Plano, TX, 750640.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-60690TPABeverly Butler1993-10-06UHC-36916-8536880405388572 Ocean Ave, Houston, TX, 770780.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60540TPARoger Harrison1981-01-09——778 Harbor Blvd, Glendale, AZ, 853450.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-58622TPAMary Lewis1964-12-11——801 Highland Ave, Eden Prairie, MN, 553150.78Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-63822TPARoy U Ortiz1995-04-07UHC-61154-157566682215—0.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-50185TPAAshley Thomas1966-01-12—3126167284—0.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-55030TPAOlivia Andrews1939-10-13——1729 Union St, Charlotte, NC, 282610.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50836TPAKayla Berry1951-03-20——1481 Bayshore Dr, Denver, CO, 802560.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53350TPARussell L Marshall1998-01-25—2203983496—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-54220TPASamantha U Patterson1973-10-20——1608 Sage Ct, Scottsdale, AZ, 852900.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-56154TPAPamela G Chen1941-11-06—7979437379—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-52374TPAJoshua Hill1990-06-01UHC-62851-1125248790321228 Central Ave, Seattle, WA, 981250.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58384TPAKevin Wheeler1946-04-21——6231 Broadway, Plano, TX, 750220.78Name split from “Last, First”Date of birth reformattedAddress re-casedCity re-cased+1 more
14,474 rows, page 134 of 290PreviousNext