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-50040TPASean Jordan1974-11-07——1511 Elm St, Houston, TX, 770920.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-53696TPAMarilyn Reynolds1945-06-15—85096828355503 Central Ave, Orlando, FL, 328650.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57703TPAShirley Larson2002-03-01UHC-40728-4337778936843209 Washington St, Columbus, OH, 432060.76Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more
TPA-57785TPAJosh Snyder1948-08-20—86351733802793 Desert Sky Blvd, Atlanta, GA, 303800.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57841TPAZachary Rios1949-06-20——7635 Oak St, Houston, TX, 770200.76Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more
TPA-56499TPAShirley Lopez1991-06-04—3136272862—0.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-63118TPARachel Lawson1999-11-24——5424 Washington St, Austin, TX, 787400.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51323TPALaura F Reyes1987-02-18——6236 Spring St, Dallas, TX, 752160.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63198TPAJanice Park1971-10-21—74855124007404 Meadow Ln, Eden Prairie, MN, 553630.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53065TPAJesscia Dixon1950-06-11——7604 Canyon Rd, Charlotte, NC, 282810.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-54265TPAHelen Alexander1967-12-14—36257486197137 Cedar Ln, Nashville, TN, 372620.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55472TPAHeather Simmons1959-10-01——839 Central Ave, Sacramento, CA, 958120.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62085TPAMei Grant1967-07-21——8400 Main St, Eden Prairie, MN, 553190.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52265TPARichard Hudson1974-01-08—70174000067415 Sage Ct, Seattle, WA, 981830.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53807TPAJean Vasquez1972-09-15UHC-72732-38—447 Ocean Ave, Jacksonville, FL, 322040.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58434TPAChristine Lawson1940-02-08—45487980208494 Market St, Charlotte, NC, 282510.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63441TPAMatthew Ellis1967-12-06UHC-13836-14—4838 Jefferson Ave, Houston, TX, 770530.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62465TPAAdam Obrien1982-04-02—42685436844314 Sunset Blvd, Chandler, AZ, 852080.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-64128TPADiego F Ellis1977-03-18——7590 Willow Ct, Orlando, FL, 328760.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-61909TPAAlexis Arnold1978-10-19——6036 Bayshore Dr, San Diego, CA, 921500.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58550TPADylan Obrien1981-08-09—51799568154022 Meadow Ln, Fresno, CA, 937610.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50271TPAKenneth Dunn1950-03-15——345 Harbor Blvd, Atlanta, GA, 303900.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54476TPAPhilip George1973-10-03——3287 Main St, Phoenix, AZ, 850550.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61461TPALisa Payne1977-09-12——6546 Pine Dr, Tucson, AZ, 857690.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58457TPADrew Marquez1997-07-22UHC-66250-4061052421616343 Willow Ct, Orlando, FL, 328380.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63171TPAEvelyn Berry1997-05-13—66549213364129 Valley View Dr, Jacksonville, FL, 322230.76Name re-casedPhone reformattedCity re-casedGender normalised+2 more
TPA-50537TPALinda Riley1982-07-15—74259411771557 Central Ave, Seattle, WA, 981230.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58140TPAJustin Schultz1985-08-09—42860948676556 Mountain View Dr, Glendale, AZ, 853090.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-51270TPACarlos Vega1954-09-24—6799189248819 Desert Sky Blvd, Tampa, FL, 336230.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54013TPAFrances Simpson2006-12-03——4657 Forest Ave, Plano, TX, 750840.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63778TPAStephen Robertson1974-04-26—68077911444568 Canyon Rd, Fresno, CA, 937350.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53608TPAAngela Montgomery1972-11-26UHC-50629-28—5712 Baseline Rd, Plano, TX, 750470.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62908TPAThomas P Pierce1948-03-05—37652547481406 Maple Ave, Orlando, FL, 328120.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60254TPAElizabeth Larson1955-06-12UHC-23618-99——0.76Name re-casedDate of birth reformattedMember ID reformattedGender normalised+2 more
TPA-59008TPABetty F Wallace1955-10-16UHC-43761-1645583927267130 Union St, Los Angeles, CA, 900130.76Name re-casedPhone reformattedState code upper-casedZIP+4 trimmed+2 more
TPA-64382TPAPamela Franklin1977-06-13—91671439018256 Pine Dr, San Antonio, TX, 782230.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51934TPALucia Wood1943-05-22—34187496198150 Pine Dr, Fresno, CA, 937260.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52698TPAMraiana Peters1948-07-02—38923792228657 Meadow Ln, Houston, TX, 770000.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-61106TPAWei Knight2003-01-13——5983 Harbor Blvd, Minneapolis, MN, 554400.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54679TPACarolyn King1957-07-13——2064 Park Pl, San Antonio, TX, 782710.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56214TPARoy Chavez1939-11-04——1429 Apache Blvd, Chandler, AZ, 852950.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50962TPASteven Ruyz1971-06-18—5573298954860 Bayshore Dr, Tucson, AZ, 857340.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51002TPADebra Ray1981-11-28—61678340312737 Meadow Ln, Miami, FL, 331230.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55260TPAGregory Peters1993-05-27—5132351550263 Grand Ave, Charlotte, NC, 282130.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-50151TPAEric Sims1947-06-04—25357722404759 Oak St, Tampa, FL, 336820.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52984TPAJulie Pena1988-12-02—294850511159 Mountain View Dr, Tucson, AZ, 857390.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63882TPAWaalter Munoz2001-05-12UHC-46892-79—6152 Sage Ct, Seattle, WA, 981560.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-59843TPADaniel Z Bllack2005-02-09——4370 Spring St, Phoenix, AZ, 850780.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52027TPAChristina Snyder1943-04-03—42488192095219 Willow Ct, Phoenix, AZ, 850580.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60632TPAArthur Johnston1943-01-08——9472 Cedar Ln, Plano, TX, 750670.76Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more
14,474 rows, page 114 of 290PreviousNext