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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-62112TPANicholas Park1963-11-01—47872589076548 Jefferson Ave, Los Angeles, CA, 900470.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-57090TPARebecca Collins1972-06-13—7983907113—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-55158TPACatherine Collins1952-01-23—2254902786—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56553TPAScott Gibson1966-11-03———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51198TPAMason Moore1984-05-16—32567543877231 Indian School Rd, Chandler, AZ, 852200.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-53827TPASamuel Watkins1979-04-28———0.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-53826TPASamuel Watkins1979-04-28———0.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-58619TPAJacob Mitchell2001-05-13UHC-92974-06—7326 Apache Blvd, Columbus, OH, 432870.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60323TPAJoseph Kim1952-01-04—6426584513—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50652TPAKimberly Miller2002-12-17—59773275993861 Ridge Rd, Sacramento, CA, 958330.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52930TPAElizabeth Harrison1965-09-25UHC-17943-364235550063—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63401TPAJuan Burke1960-06-11——2760 Spring St, Miami, FL, 331060.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-63101TPAChris Lee2000-05-13—85345064718465 Lake View Rd, Gilbert, AZ, 852630.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53722TPAMaggie Gibson2004-05-16—89730795427161 Lake View Rd, Columbus, OH, 432150.92Name re-casedPhone reformattedState code upper-casedPlaceholder values cleared
TPA-53210TPABryan Bradley1941-10-26UHC-11645-27——0.92Name re-casedMember ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-61403TPABarb Little1987-04-01—4963848797629 Spring St, Sacramento, CA, 958410.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-63396TPALauren West1986-04-03—9709122698—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62313TPARuth Reyes1954-04-27UHC-60020-37—485 Spring St, Nashville, TN, 372240.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50571TPAKeith C Brooks1986-03-26—8735187339—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57316TPARalph Q Ruz1954-06-03——777 Lake View Rd, Fresno, CA, 937600.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-53975TPASarah Ward1954-02-01—23065186739079 Cedar Ln, Gilbert, AZ, 852910.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62264TPABeverly X Brown1941-05-11——8563 Desert Sky Blvd, Tucson, AZ, 857880.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52131TPAAlan I Castillo1954-06-12UHC-85083-26244718860036 Hillcrest Rd, Mesa, AZ, 852460.92Date of birth reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-51691TPAGeorge Reid1995-01-28—35152317383403 Indian School Rd, Atlanta, GA, 303650.92Date of birth reformattedPhone reformattedEmail lower-casedPlaceholder values cleared
TPA-62315TPASteven G Guerrero1959-03-02—6586229403—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63189TPALogan Payne1986-04-08——279 Apache Blvd, Orlando, FL, 328300.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59897TPAMark D Perez1962-05-13—61194068368922 Canyon Rd, Los Angeles, CA, 900890.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58531TPAKeith Cole1950-11-04UHC-98804-07—4613 Grand Ave, San Antonio, TX, 782550.92Date of birth reformattedCity re-casedEmail lower-casedPlaceholder values cleared
TPA-50555TPAJoseph Fields1967-12-01——704 Grand Ave, Denver, CO, 802540.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-52270TPAVirgiia Ortiz2008-03-22UHC-29964-5397699347248997 Broadway, Denver, CO, 802280.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-58236TPAEmily Wilson1961-02-26——3781 Lincoln Way, Charlotte, NC, 282540.92State code upper-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-51631TPACynthai Castro1988-10-16———0.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-55919TPAJason Johnston1987-07-21—96556558025392 Highland Ave, San Diego, CA, 921020.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60189TPAFrances Wnog1997-11-20—71789217206245 Broadway, Denver, CO, 802350.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52738TPAMariana Romero1988-01-03UHC-63176-19—7145 Baseline Rd, Eden Prairie, MN, 553550.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59285TPAMateo Hughes1965-05-14UHC-97145-41——0.92Name re-casedDate of birth reformattedEmail lower-casedPlaceholder values cleared
TPA-52678TPANicholas Gomez1984-01-17UHC-98466-97—2392 Willow Ct, Chandler, AZ, 852780.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59793TPAJean E Harrison2004-10-13—80064150546547 Broadway, Sacramento, CA, 958860.92Date of birth reformattedPhone reformattedCity re-casedPlaceholder values cleared
TPA-53449TPAMark Moore1944-12-06—61056895548179 Ridge Rd, Columbus, OH, 432100.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56540TPAOlivia Long1997-07-15—82427421581779 Jefferson Ave, Miami, FL, 331250.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-62701TPAMary Hamilton1961-07-01—3598889997391 Union St, Tucson, AZ, 857060.92Date of birth reformattedPhone reformattedState code upper-casedPlaceholder values cleared
TPA-64210TPADoris Q Obrien1973-11-11UHC-18952-16—8287 Grand Ave, Fresno, CA, 937050.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63174TPAJessica Warren1986-07-17——7351 River Rd, Plano, TX, 750130.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56841TPABeverly Hunter1996-11-15UHC-61579-577736722371—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56840TPABeverly Hunter1996-11-15UHC-61579-577736722371—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56151TPABruce Banks1983-06-21——5040 Harbor Blvd, Atlanta, GA, 303340.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58519TPAKelly Y Espinoza1989-05-10UHC-51195-8785860214249183 Central Ave, Jacksonville, FL, 322860.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52416TPAEmily Martinez2004-08-11—67867368319266 Sage Ct, Orlando, FL, 328110.92Date of birth reformattedPhone reformattedCity re-casedPlaceholder values cleared
TPA-52877TPAMason Torres1982-07-15—31448071276111 Church St, Orlando, FL, 328750.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55962TPARachel Lee1939-11-02——3132 Meadow Ln, Las Vegas, NV, 891390.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 230 of 290PreviousNext