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-61068TPAScott Knight1964-04-01——5464 Oak St, Miami, FL, 331310.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62191TPASean C Cunningham1976-03-27—74136256729346 Cedar Ln, Eden Prairie, MN, 553080.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
TPA-52344TPALuis W Hill1942-10-27——7828 Meadow Ln, Gilbert, AZ, 852710.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50738TPASean Nunez1997-10-03—44251504034431 Forest Ave, Fresno, CA, 937040.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53017TPAJonathan Ferguson1945-06-13—87371585048474 River Rd, San Diego, CA, 921900.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-58150TPABruce Sanchez1958-03-21UHC-55488-7272449318202162 Hillcrest Rd, Sacramento, CA, 958430.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51795TPAAmber Colemman1948-07-20——1524 Market St, Dallas, TX, 752030.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62330TPAKevin Fernandez1971-05-07——1111 River Rd, Tempe, AZ, 852220.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-58346TPACarolyn Pierce1990-11-13——2381 Mountain View Dr, Jacksonville, FL, 322960.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50715TPAJudy Schultz1971-11-05—67445835063200 Ridge Rd, Minneapolis, MN0.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
TPA-64287TPAAna N Mendoza1983-03-07—55187274962702 Lake View Rd, Atlanta, GA, 303070.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58936TPASean Young2007-07-27—36886379213421 Indian School Rd, Phoenix, AZ, 850600.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-56062TPASara Butler1957-12-03—22833938077267 Grand Ave, Columbus, OH, 432060.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59886TPAMarilyn Hlal1963-03-04—79542165111501 Valley View Dr, Eden Prairie, MN, 553040.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50547TPAAlbert P Claark1977-05-15—88625329487039 Apache Blvd, Eden Prairie, MN, 553300.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62455TPABilly Woods2008-12-28—64173754709638 Sage Ct, Atlanta, GA, 303380.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53701TPAJose Alvarez1940-03-14—80128368576690 Sunset Blvd, Orlando, FL, 328180.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52915TPAKelly E Ortiz1972-07-07UHC-39478-818776432736311 Ridge Rd, Plano, TX, 750650.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-64431TPAJoseph Payne1971-07-21—86033692478176 Hillcrest Rd, Orlando, FL, 328970.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54649TPAAna X James1952-02-17UHC-70297-5884390585801093 Jefferson Ave, Plano, TX, 750770.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54191TPAVirginia Rice1942-12-26——6678 Lincoln Way, Fresno, CA, 937260.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63854TPAAlice Snyder1981-06-05—51491079945736 Market St, Scottsdale, AZ, 852030.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51714TPAMark Z Fox1993-04-05—74791839051877 Indian School Rd, Atlanta, GA, 303020.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-62223TPAMargaret Jensen1955-12-27UHC-87953-5473930255888046 Sunset Blvd, Glendale, AZ, 853230.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52461TPAJean Mills1961-04-07——6528 Grand Ave, Columbus, OH, 432320.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64225TPAJoan Prcie1938-10-13—87752178665568 River Rd, Seattle, WA, 981440.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50124TPAValentina Austin1980-11-05——6663 Highland Ave, Gilbert, AZ, 852920.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54197TPAPaul Long1994-08-14——231 Elm St, Denver, CO, 802250.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63826TPAKevin Gonzales1949-10-25——5627 Union St, San Diego, CA, 921500.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53214TPADot Medina1967-10-19——1837 Pine Dr, Houston, TX, 770410.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63435TPAPhillips L Elizabeth1968-02-25—34467682971555 Jefferson Ave, Glendale, AZ, 853560.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50911TPADennis W Williams1980-03-15——6382 Sage Ct, Gilbert, AZ, 852040.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56453TPAGrace Sandoval1994-07-17UHC-09986-75—3704 Canyon Rd, Glendale, AZ, 853310.74Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57364TPAJordan Ramirez1985-10-28—46387265163884 Mountain View Dr, Tampa, FL, 336710.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61280TPAKathryn Taylor1959-11-11—22840087776925 Market St, Charlotte, NC, 282570.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52994TPABryan Bailey1950-02-26—79061964593511 Union St, Las Vegas, NV, 891570.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56662TPAMark Ramirez1959-05-03UHC-99276-30—4317 Lake View Rd, Seattle, WA, 981090.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61952TPAJena T Davis1947-11-14—64892492955123 Forest Ave, Sacramento, CA, 958040.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55423TPALisa Hawkins2004-03-27——6779 Broadway, Charlotte, NC, 282500.74Name re-casedDate of birth reformattedAddress re-casedCity re-cased+3 more
TPA-61683TPACarol D King1980-12-06—62265638704013 Union St, Nashville, TN, 372850.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63141TPABetty M Burke1966-02-08——4250 Mountain View Dr, Phoenix, AZ, 850860.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62556TPALauren Vasquez1960-10-16—42254103608820 Ridge Rd, Minneapolis, MN, 554110.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56498TPASandra Obrien1985-10-07——7731 Spring St, Atlanta, GA, 303200.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63909TPAMyers George1970-10-13—20652194262198 Sage Ct, Scottsdale, AZ, 852180.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54621TPASofia Welch2005-09-24—24985551399888 Main St, Eden Prairie, MN, 553300.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-54178TPADonald Griffin1973-05-26——9557 Main St, Mesa, AZ, 852730.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51907TPADenise L Holmes1964-03-12—65239242698668 Central Ave, Gilbert, AZ, 852640.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-62533TPAShirley A Meyer1976-09-12UHC-36691-72—413 Cedar Ln, Seattle, WA, 981870.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54107TPABetty Mendez1998-09-03—85696859495766 Spring St, Dallas, TX, 752160.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61992TPAShirley Powell1949-02-22—90099779027038 Main St, Sacramento, CA, 958590.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
14,474 rows, page 105 of 290PreviousNext