About this Dataset

Organogram Of Staff Roles & Salaries

Organogram (organisation chart) showing all staff roles. Names and salaries are also listed for the Senior Civil Servants. Organogram data is released by all central government departments and their agencies since 2010. Snapshots for 31st March and 30th September are published by 6th June and 6th December each year. The published data is validated and released in CSV format and OGL-licensed for reuse. For more information about this series, see: http://guidance.data.gov.uk/organogram-data.html
Publisher name: Foreign and Commonwealth Office
Last updated: 2024-09-14T18:00:05Z

Tables

FCO Junior Staff And Salary Data March 2019

@ukgov.organogram_foreign_and_commonwealth_office.fco_junior_staff_and_salary_data_march_2019

10.44 kB
65,321 rows
10 columns

CREATE TABLE fco_junior_staff_and_salary_data_march_2019 (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" DOUBLE,
  "grade" VARCHAR,
  "payscale_minimum" DOUBLE  -- Payscale Minimum (£),
  "payscale_maximum" DOUBLE  -- Payscale Maximum (£),
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR
);

FCO Junior Staff And Salary Details March 2019

@ukgov.organogram_foreign_and_commonwealth_office.fco_junior_staff_and_salary_details_march_2019

10.54 kB
215 rows
10 columns

CREATE TABLE fco_junior_staff_and_salary_details_march_2019 (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT  -- Payscale Minimum (Ł),
  "payscale_maximum" BIGINT  -- Payscale Maximum (Ł),
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" BIGINT,
  "professional_occupational_group" VARCHAR
);

FCO Senior Staff And Salary Data March 2019

@ukgov.organogram_foreign_and_commonwealth_office.fco_senior_staff_and_salary_data_march_2019

35.45 kB
1,999 rows
42 columns

CREATE TABLE fco_senior_staff_and_salary_data_march_2019 (
  "post_unique_reference" DOUBLE,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR  -- Grade (or Equivalent),
  "job_title" VARCHAR,
  "job_team_function" VARCHAR,
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "contact_phone" VARCHAR,
  "contact_e_mail" VARCHAR,
  "reports_to_senior_post" VARCHAR,
  "salary_cost_of_reports" DOUBLE  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" DOUBLE  -- Actual Pay Floor (£),
  "actual_pay_ceiling" DOUBLE  -- Actual Pay Ceiling (£),
  "total_pay" VARCHAR  -- Total Pay (£),
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?,
  "column_a_invalid" BOOLEAN,
  "column_b_invalid" BOOLEAN,
  "column_c_invalid" BOOLEAN,
  "column_d_invalid" BOOLEAN,
  "column_e_invalid" BOOLEAN,
  "column_f_invalid" BOOLEAN,
  "column_g_invalid" BOOLEAN,
  "column_h_invalid" BOOLEAN,
  "column_i_invalid" BOOLEAN,
  "column_j_invalid" BOOLEAN,
  "column_k_invalid" BOOLEAN,
  "column_l_invalid" BOOLEAN,
  "column_m_invalid" BOOLEAN,
  "column_n_invalid" BOOLEAN,
  "column_o_invalid" BOOLEAN,
  "column_p_invalid" BOOLEAN,
  "column_q_invalid" BOOLEAN,
  "row_has_errors" BOOLEAN  -- Row Has Errors?,
  "valid_as_number" BIGINT,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "a_valid" BOOLEAN  -- A Valid?,
  "j_valid" BOOLEAN  -- J Valid?,
  "text_value" BIGINT
);

Organogram Of Staff Roles & Salaries

@ukgov.organogram_foreign_and_commonwealth_office.organogram_of_staff_roles_salaries

10.52 kB
200 rows
10 columns

CREATE TABLE organogram_of_staff_roles_salaries (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT  -- Payscale Minimum (£),
  "payscale_maximum" BIGINT  -- Payscale Maximum (£),
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR
);