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-53006TPATommy Sandoval1954-06-23——1297 Apache Blvd Apt 19, Charlotte, NC0.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55484TPAJoseph Ward1957-04-24—51340615256443 Bayshore Dr, Glendale, AZ, 853670.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52806TPABilly Bennett1952-01-25——1043 Sage Ct, Seattle, WA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53981TPATerry E Owens1967-05-12—29420997622368 Camelback Rd, Mesa, AZ, 852310.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54398TPASharon Ellis1983-09-20—93644275628570 Maple Ave, Phoenix, AZ, 850850.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-52268TPAMariana Carlson1958-07-21UHC-83774-86—3744 Elm St, Minneapolis, MN0.50Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-58269TPACarol Walker1946-02-09——8826 Canyon Rd # 879, Sacramento, CA, 958910.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-54122TPAJustin Russell1972-06-26——2618 Church St Apt 35, Nashville, TN0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-58617TPABryan Walker1962-11-10——385 Oak St, Miami, FL0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
TPA-62943TPAKyle A Lane1981-11-07UHC-74857-31—9320 Willow Ct # 758, Dallas, TX, 752090.50Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-63768TPADot Castillo1973-03-26UHC-27256-0985299325399595 Harbor Blvd, Plano, TX, 750670.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-63577TPAJanice West1955-07-13——6528 Main St, Scottsdale, AZ, 852350.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60482TPAAlan Schmidt1992-10-27—39330054755248 Canyon Rd Apt 26, Minneapolis, MN0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61584TPAHeather Rios—UHC-67463-2364729547796475 Desert Sky Blvd # 668, Sacramento, CA, 958270.50Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
TPA-61585TPAHeather Rios—UHC-67463-2364729547796475 Desert Sky Blvd # 668, Sacramento, CA, 958270.50Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
TPA-60469TPADaniel Owens1995-09-12UHC-62595-38—2304 Church St, Minneapolis, MN0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51792TPACamila D Alvarado——53855790462575 Park Pl, Charlotte, NC, 282010.50Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-53408TPARonald Harrison2004-05-22UHC-33242-35—8077 Maple Ave, Denver, CO, 802670.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50669TPADonna Myers1972-10-07——6906 Desert Sky Blvd, Houston, TX0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-50273TPAJacqueline Lawwrence2007-06-11—52480023028326 Desert Sky Blvd, Eden Prairie, MN, 553000.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53687TPADoris George1947-01-18——9649 Canyon Rd, Plano, TX, 750960.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50638TPAKayla Sims1987-05-14—32762880517655 Washington St, Atlanta, GA, 303710.50Name re-casedPhone reformattedSSN last four extractedZIP+4 trimmed+3 more
TPA-50650TPAKimberly Russell1995-05-06——454 Jefferson Ave, Tempe, AZ0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55445TPAJnaice Hanson1966-12-14—85071437005303 Willow Ct, Tempe, AZ, 852710.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-51992TPASean Mureno1989-08-28——8250 Elm St, San Diego, CA, 921880.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-54099TPATeresa Greene1966-10-05—80967197276237 Oak St, San Diego, CA, 921780.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-56675TPAMaria D Cruz1989-07-28—69164244911792 Forest Ave, Phoenix, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-50635TPASandra P Alvarez1948-03-21—77967528523403 Ridge Rd # 203, Tampa, FL, 336220.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-51093TPAKelly Carter1964-06-03—7283671484405 Maple Ave, San Antonio, TX, 782690.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-58902TPADiego M Lawrence2005-03-13UHC-68548-0844650485571001 Hillcrest Rd Apt 36, Tempe, AZ, 852030.50Middle initial moved out of first nameDate of birth reformattedMember ID reformattedUnit split from street+3 more
TPA-52987TPAThomas F Freeman2006-04-07——1119 Pine Dr, Charlotte, NC0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58016TPAVincent Thomas1939-06-11UHC-72529-9889937979261569 Elm St, Las Vegas, NV, 891770.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59910TPASusan Gray1975-12-26——9559 Lincoln Way, Seattle, WA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-57710TPACharlotte Duncan1989-11-08——9268 Valley View Dr, Columbus, OH, 432640.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-53917TPAAmanda Ortiz1971-11-28——9163 Desert Sky Blvd, Atlanta, GA, 303610.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-51496TPAAbigail McDoald1969-07-26——2735 Washington St # 570, Fresno, CA, 937100.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
TPA-60105TPADiana Mills1954-03-08—41861584998309 Canyon Rd, Denver, CO, 802370.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52935TPAJohnny Little1968-05-02——1768 Maple Ave, Gilbert, AZ, 852540.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61486TPAChristian Salazar———6140 Elm St, Columbus, OH, 432020.50Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+3 more
TPA-56790TPAJack M Barnes1979-04-24—76667693323185 Washington St, Las Vegas, NV, 891250.50Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
TPA-57654TPAJudy Pierce1991-02-15UHC-76830-07—2875 Maple Ave Apt 8, San Antonio, TX, 782390.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61089TPADiana Dean1970-06-22—51545293622271 Indian School Rd, Orlando, FL, 328520.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55016TPAMariana S Hart1950-10-09——4835 Pine Dr, Scottsdale, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-58671TPASarra F Carpenter1954-05-13UHC-93904-2224263273965892 Willow Ct, Orlando, FL, 328340.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-58853TPALaura P Perry1980-02-09—90382036395380 Ocean Ave, Gilbert, AZ, 852890.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55585TPAAbigail Alexander1940-03-04——6190 Indian School Rd, Atlanta, GA, 303920.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-55048TPACarl Montgomery1963-08-11UHC-57349-54—1278 Lake View Rd, Seattle, WA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-60312TPALarry Salazar1959-01-11——3354 Park Pl, Gilbert, AZ, 852570.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-56976TPAJohn Ramos1941-03-16——8029 Park Pl # 157, San Antonio, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-57988TPALucia N Montgmoery1947-12-09—65173901592513 Harbor Blvd, Houston, TX, 770840.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
14,474 rows, page 13 of 290PreviousNext