About this Dataset

DESNZ 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. Snapshots are published on 31st January, 30th April, 31st July and 31st October. 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. Note that previous data has been uploaded under the BEIS dataset.
Publisher name: Department for Energy Security and Net Zero
Last updated: 2025-04-29T04:06:16Z

Tables

2023-09-30 Organogram (Junior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2023_09_30_organogram_junior

14.85 kB
643 rows
11 columns

CREATE TABLE n_2023_09_30_organogram_junior (
  "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" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2023-09-30 Organogram (Senior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2023_09_30_organogram_senior

21.63 kB
206 rows
20 columns

CREATE TABLE n_2023_09_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2023-12-31 Organogram (Junior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2023_12_31_organogram_junior

14.81 kB
687 rows
11 columns

CREATE TABLE n_2023_12_31_organogram_junior (
  "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" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2023-12-31 Organogram (Senior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2023_12_31_organogram_senior

21.74 kB
199 rows
20 columns

CREATE TABLE n_2023_12_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

2024-03-31 Organogram (Junior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2024_03_31_organogram_junior

15.33 kB
743 rows
11 columns

CREATE TABLE n_2024_03_31_organogram_junior (
  "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" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2024-03-31 Organogram (Senior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2024_03_31_organogram_senior

21.8 kB
211 rows
20 columns

CREATE TABLE n_2024_03_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" DOUBLE  -- Valid?
);

2024-07-30 Organogram (Junior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2024_07_30_organogram_junior

15.3 kB
749 rows
11 columns

CREATE TABLE n_2024_07_30_organogram_junior (
  "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" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2024-07-30 Organogram (Senior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2024_07_30_organogram_senior

21.76 kB
211 rows
20 columns

CREATE TABLE n_2024_07_30_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" DOUBLE  -- Valid?
);

2024-11-01 Organogram (Junior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2024_11_01_organogram_junior

15.65 kB
800 rows
11 columns

CREATE TABLE n_2024_11_01_organogram_junior (
  "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" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2024-11-01 Organogram (Senior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2024_11_01_organogram_senior

22.06 kB
218 rows
20 columns

CREATE TABLE n_2024_11_01_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" DOUBLE  -- Valid?
);

2024-12-31 Organogram (Junior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2024_12_31_organogram_junior

14.44 kB
877 rows
11 columns

CREATE TABLE n_2024_12_31_organogram_junior (
  "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" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2024-12-31 Organogram (Senior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2024_12_31_organogram_senior

22.02 kB
222 rows
20 columns

CREATE TABLE n_2024_12_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" DOUBLE  -- Valid?
);

2025-03-31 Organogram (Junior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2025_03_31_organogram_junior

14.25 kB
907 rows
11 columns

CREATE TABLE n_2025_03_31_organogram_junior (
  "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" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2025-03-31 Organogram (Senior)

@ukgov.desnz_organogram_of_staff_roles_salaries.n_2025_03_31_organogram_senior

22.5 kB
235 rows
20 columns

CREATE TABLE n_2025_03_31_organogram_senior (
  "post_unique_reference" BIGINT,
  "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" VARCHAR  -- Salary Cost Of Reports (£),
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" DOUBLE  -- Valid?
);