Baselight
Sign In

MOD-Organogram Of Staff Roles & Salaries-AIR Command

Air Command

@ukgov.organogram_air_command

Loading...
Loading...

About this Dataset

MOD-Organogram Of Staff Roles & Salaries-AIR Command

Organogram (organisation chart) showing all staff roles. Names and salaries are also listed for the Senior Civil Servants 2* and above. Organogram data has been released by all central government departments and their agencies since 2010. Snapshots are published quarterly for datasets from 31st March; 30th June; 30th September and 31st 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: Air Command
Last updated: 2025-04-26T04:02:56Z

Tables

MOD-Organogram Of Staff Roles & Salaries-AIR Command

@ukgov.organogram_air_command.mod_organogram_of_staff_roles_salaries_air_command
  • 12.54 KB
  • 318 rows
  • 10 columns
Loading... 

CREATE TABLE mod_organogram_of_staff_roles_salaries_air_command (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR
);

2018-09-30 Organogram (Junior)

@ukgov.organogram_air_command.n_2018_09_30_organogram_junior
  • 12.38 KB
  • 305 rows
  • 10 columns
Loading... 

CREATE TABLE n_2018_09_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR
);

2018-09-30 Organogram (Senior)

@ukgov.organogram_air_command.n_2018_09_30_organogram_senior
  • 21.93 KB
  • 52 rows
  • 19 columns
Loading... 

CREATE TABLE n_2018_09_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

2019-03-31 Organogram (Junior)

@ukgov.organogram_air_command.n_2019_03_31_organogram_junior
  • 12.73 KB
  • 328 rows
  • 10 columns
Loading... 

CREATE TABLE n_2019_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR
);

2019-03-31 Organogram (Senior)

@ukgov.organogram_air_command.n_2019_03_31_organogram_senior
  • 22.11 KB
  • 52 rows
  • 19 columns
Loading... 

CREATE TABLE n_2019_03_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

2021-03-31 Organogram (Junior)

@ukgov.organogram_air_command.n_2021_03_31_organogram_junior
  • 12.91 KB
  • 353 rows
  • 10 columns
Loading... 

CREATE TABLE n_2021_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR
);

2021-03-31 Organogram (Senior)

@ukgov.organogram_air_command.n_2021_03_31_organogram_senior
  • 22.7 KB
  • 54 rows
  • 19 columns
Loading... 

CREATE TABLE n_2021_03_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

2021-06-30 Organogram (Junior)

@ukgov.organogram_air_command.n_2021_06_30_organogram_junior
  • 12.77 KB
  • 348 rows
  • 10 columns
Loading... 

CREATE TABLE n_2021_06_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR
);

2021-06-30 Organogram (Senior)

@ukgov.organogram_air_command.n_2021_06_30_organogram_senior
  • 23.1 KB
  • 54 rows
  • 19 columns
Loading... 

CREATE TABLE n_2021_06_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

2021-12-31 Organogram (Junior)

@ukgov.organogram_air_command.n_2021_12_31_organogram_junior
  • 15.87 KB
  • 873 rows
  • 11 columns
Loading... 

CREATE TABLE n_2021_12_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2021-12-31 Organogram (Senior)

@ukgov.organogram_air_command.n_2021_12_31_organogram_senior
  • 24.54 KB
  • 56 rows
  • 20 columns
Loading... 

CREATE TABLE n_2021_12_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

2022-06-30 Organogram (Junior)

@ukgov.organogram_air_command.n_2022_06_30_organogram_junior
  • 13.07 KB
  • 604 rows
  • 11 columns
Loading... 

CREATE TABLE n_2022_06_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2022-06-30 Organogram (Senior)

@ukgov.organogram_air_command.n_2022_06_30_organogram_senior
  • 23.94 KB
  • 57 rows
  • 20 columns
Loading... 

CREATE TABLE n_2022_06_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" DOUBLE
);

2022-10-29 Organogram (Junior)

@ukgov.organogram_air_command.n_2022_10_29_organogram_junior
  • 12.78 KB
  • 536 rows
  • 11 columns
Loading... 

CREATE TABLE n_2022_10_29_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2022-10-29 Organogram (Senior)

@ukgov.organogram_air_command.n_2022_10_29_organogram_senior
  • 23.33 KB
  • 61 rows
  • 20 columns
Loading... 

CREATE TABLE n_2022_10_29_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

2023-01-31 Organogram (Junior)

@ukgov.organogram_air_command.n_2023_01_31_organogram_junior
  • 12.58 KB
  • 560 rows
  • 11 columns
Loading... 

CREATE TABLE n_2023_01_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2023-01-31 Organogram (Senior)

@ukgov.organogram_air_command.n_2023_01_31_organogram_senior
  • 22.72 KB
  • 59 rows
  • 20 columns
Loading... 

CREATE TABLE n_2023_01_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT,
  "actual_pay_ceiling" BIGINT,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

2023-03-31 Organogram (Junior)

@ukgov.organogram_air_command.n_2023_03_31_organogram_junior
  • 12.44 KB
  • 560 rows
  • 11 columns
Loading... 

CREATE TABLE n_2023_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2023-03-31 Organogram (Senior)

@ukgov.organogram_air_command.n_2023_03_31_organogram_senior
  • 22.44 KB
  • 62 rows
  • 20 columns
Loading... 

CREATE TABLE n_2023_03_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

2023-06-30 Organogram (Junior)

@ukgov.organogram_air_command.n_2023_06_30_organogram_junior
  • 12.93 KB
  • 969 rows
  • 11 columns
Loading... 

CREATE TABLE n_2023_06_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" VARCHAR,
  "payscale_maximum" VARCHAR,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2023-06-30 Organogram (Senior)

@ukgov.organogram_air_command.n_2023_06_30_organogram_senior
  • 22.74 KB
  • 61 rows
  • 20 columns
Loading... 

CREATE TABLE n_2023_06_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT,
  "actual_pay_ceiling" BIGINT,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

2023-09-30 Organogram (Junior)

@ukgov.organogram_air_command.n_2023_09_30_organogram_junior
  • 13.98 KB
  • 1058 rows
  • 11 columns
Loading... 

CREATE TABLE n_2023_09_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" VARCHAR,
  "payscale_maximum" VARCHAR,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2023-09-30 Organogram (Senior)

@ukgov.organogram_air_command.n_2023_09_30_organogram_senior
  • 22.44 KB
  • 60 rows
  • 20 columns
Loading... 

CREATE TABLE n_2023_09_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT,
  "actual_pay_ceiling" BIGINT,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

2024-01-25 Organogram (Junior)

@ukgov.organogram_air_command.n_2024_01_25_organogram_junior
  • 12.65 KB
  • 566 rows
  • 11 columns
Loading... 

CREATE TABLE n_2024_01_25_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" BIGINT,
  "grade" VARCHAR,
  "payscale_minimum" VARCHAR,
  "payscale_maximum" VARCHAR,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2024-01-25 Organogram (Senior)

@ukgov.organogram_air_command.n_2024_01_25_organogram_senior
  • 22.57 KB
  • 52 rows
  • 20 columns
Loading... 

CREATE TABLE n_2024_01_25_organogram_senior (
  "post_unique_reference" BIGINT,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "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" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" BIGINT,
  "actual_pay_ceiling" BIGINT,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

Share link

Anyone who has the link will be able to view this.