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-52054TPAJesse Walker1941-05-04——5667 Camelback Rd, Columbus, OH, 432860.88Name re-casedDate of birth reformattedState code upper-casedEmail lower-cased+2 more
TPA-52634TPAKenneth Turner1956-10-21—93622254522587 Main St, Glendale, AZ, 853090.88Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more
TPA-51878TPACamila Dalgado1975-06-05—88962519864527 Desert Sky Blvd, Glendale, AZ, 853010.88Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more
TPA-55270TPAPamela U Ortega1956-08-27UHC-81594-207037460429871 Baseline Rd, Seattle, WA, 981570.88Date of birth reformattedPhone reformattedMember ID reformattedCity re-cased+2 more
TPA-54903TPABryan Garrett1986-03-15——8805 Broadway, Charlotte, NC, 282070.88Name re-casedDate of birth reformattedAddress re-casedCity re-cased+2 more
TPA-59788TPAJudith Palmer1997-02-02—58927228074983 Pine Dr, Orlando, FL, 328910.88Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more
TPA-51967TPACamila Perez1974-09-02—82242174163967 Highland Ave, Los Angeles, CA, 900650.88Name re-casedPhone reformattedCity re-casedEmail lower-cased+2 more
TPA-52242TPABrenda Elliott1951-12-23—78980001328417 Central Ave, Sacramento, CA, 958350.88Date of birth reformattedPhone reformattedCity re-casedEmail lower-cased+2 more
TPA-58759TPALucia G Jenkins1962-08-09—2517636966—0.88Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more
TPA-57698TPAKyle Lynch1947-10-15—7977288722—0.88Name re-casedPhone reformattedEmail lower-casedPlan code upper-cased+2 more
TPA-51504TPAMartha Morales2002-08-01—68073030894587 Cedar Ln, Gilbert, AZ, 852330.88Date of birth reformattedPhone reformattedCity re-casedEmail lower-cased+2 more
TPA-55477TPAAlexis Yang1997-10-17—30737953345797 Elm St, Scottsdale, AZ, 852780.88Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
TPA-50005TPABecky V Guerrero1994-08-12UHC-73120-26—9512 Broadway, San Antonio, TX, 782210.88Name re-casedDate of birth reformattedMember ID reformattedEmail lower-cased+2 more
TPA-52201TPAKathleen Stewart1938-10-13—7186347441317 Mountain View Dr, Charlotte, NC, 282400.88Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
TPA-51730TPAJeremy Wagner1995-05-10—3948288733—0.88Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more
TPA-58756TPASandra Lewis2005-01-08—67935633497524 Pine Dr, Dallas, TX, 752900.88Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
TPA-60911TPAMariana Murray1947-11-27UHC-91822-9227533573694122 Elm St, Las Vegas, NV, 891190.88Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
TPA-61435TPAHiroshi Henderson1981-04-02—71066537957926 Camelback Rd, Tucson, AZ, 857400.90Phone reformattedCity re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-53370TPAValentina Pricce2004-04-24—64772099319812 Meadow Ln, Phoenix, AZ, 850320.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-58411TPAWei Greene1945-01-21UHC-23580-88—63 Lincoln Way, Jacksonville, FL, 322210.90Name re-casedMember ID reformattedCity re-casedWhitespace trimmed+1 more
TPA-53495TPAAna Rogers1973-11-20—32839984072242 Pine Dr, Mesa, AZ, 852310.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-60362TPALogan Rose1964-05-02—4434690389—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-53039TPAAnna Evans2005-01-06—4887751985—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-51706TPASandra Salazar2007-03-05——8418 Church St, Plano, TX, 750950.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-50490TPAHnnah D Padilla1982-06-18—30864589671746 Spring St, Dallas, TX, 752840.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-60746TPAMariana Stewart1984-05-09UHC-55215-31—4958 Indian School Rd, Houston, TX, 770560.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-63758TPAArun Wst1942-08-06—50585163657968 Main St, Jacksonville, FL, 322150.90Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-57253TPAMatthew F Li1954-11-22—9898066435—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-61549TPARussell Schultz1964-07-04—5392815153—0.90Name re-casedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-62832TPALuis Black1993-12-20——6457 Broadway, Tempe, AZ, 852760.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-62059TPASamuel F Weaver1995-11-10—53844155227528 Central Ave, Mesa, AZ, 852330.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-63773TPAAdams K Zachary1959-02-12UHC-77933-8880831521345796 Broadway, Orlando, FL, 328410.90Name re-casedPhone reformattedAddress re-casedState code upper-cased+1 more
TPA-54724TPAGloria Hicks1952-03-18——6778 Jefferson Ave, Glendale, AZ, 853890.90Date of birth reformattedCity re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-55343TPARuth Rose2006-07-19UHC-77128-2067085610564493 Main St, Minneapolis, MN, 554920.90Name re-casedPhone reformattedMember ID reformattedCity re-cased+1 more
TPA-59690TPAErric Davis1981-02-16—20641639289238 Market St, Plano, TX, 750900.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-54957TPADonna James2006-06-08—72083537666962 Mesa Dr, Miami, FL, 331540.90Date of birth reformattedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-62170TPAScott Kim1983-10-25UHC-31124-945904957335—0.90Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-56849TPAPhilip Carroll1942-06-22—38864030804716 Highland Ave, San Diego, CA, 921300.90Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-63837TPARachel Nichols1970-07-06———0.90Name re-casedDate of birth reformattedPlan code upper-casedWhitespace trimmed+1 more
TPA-58286TPAJustin Mratinez1958-09-07UHC-20070-186819303791—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-52628TPAJames M Hamilton1994-09-27—46632562492485 Mountain View Dr, Los Angeles, CA, 900400.90Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-52865TPAJordan V Garcia1983-04-26—59899092978139 Harbor Blvd, Chandler, AZ, 852670.90Date of birth reformattedPhone reformattedState code upper-casedWhitespace trimmed+1 more
TPA-53121TPACamila G Olsoon1949-01-07——3970 Sage Ct, Atlanta, GA, 303420.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-56591TPAEugene Wallace1942-06-16—22073350968878 Baseline Rd, Jacksonville, FL, 322190.90Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-56466TPADoris D Watson1951-12-05—5264765344—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-59527TPAEric Morgan1995-05-07—71448261594634 Indian School Rd, Denver, CO, 802310.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-62321TPARadny Vazquez1960-06-15—6365778967—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-50501TPAIsabella Welch1981-10-04—7289517598—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-57223TPAHenry Le2005-03-22—22960786962816 Lincoln Way, Minneapolis, MN, 554710.90Date of birth reformattedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-52229TPASofia Fuller1956-08-14——9744 Cedar Ln, Tucson, AZ, 857840.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
14,474 rows, page 223 of 290PreviousNext