HR Data

CREATE TABLE jan_2017 (
  "plymouth_city_council_directorate" VARCHAR,
  "number_of_female_staff" DOUBLE,
  "number_of_male_staff" DOUBLE,
  "total_number_of_staff" DOUBLE,
  "number_of_contractual_hours_in_directorate" DOUBLE,
  "number_of_full_time_staff" DOUBLE,
  "number_of_part_time_staff" DOUBLE
);

CREATE TABLE mar_2017 (
  "plymouth_city_council_directorate" VARCHAR,
  "number_of_female_staff" BIGINT,
  "number_of_male_staff" BIGINT,
  "total_number_of_staff" BIGINT,
  "number_of_contractual_hours_in_directorate" DOUBLE,
  "number_of_full_time_staff" BIGINT,
  "number_of_part_time_staff" BIGINT
);