first name last name   role     location   Compensation Level  state
      john       smith      Manager     LA         A                 CA
      john       smith      Manager     BOS        B                 MA
      super      smither    developer   LA         B                 CA
      tina       taylor     supervisor  SFO        A                 CA
      tina       taylor     supervisor  BOS        B                 MA


     first name  last name  role        dept
     john         smith     manager     finance
     john         smith     manager     hr
     super        smither   developer   PA
     tina         taylor    supervisor  HR
     tina         taylor    supervisor  hr

first name last name   role     location   Compensation state dept
 john        smith      Manager    LA          A          CA finance
 john        smith      Manager    BOS         B          MA hr
 super       smither    developer  LA          B          CA PA
 tina        taylor     supervisor SFO         A          CA HR
 tina        taylor     supervisor  BOS        B          MA HR