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, 30th June, 30th September and 31st December are published each quarter. 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: HM Treasury
Last updated: 2025-05-13T04:01:19Z

Tables

2025-03-31 Organogram (Junior)

@ukgov.organogram_hm_treasury.n_2025_03_31_organogram_junior

17.46 kB
707 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.organogram_hm_treasury.n_2025_03_31_organogram_senior

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