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 31 March and 30 September were published on a 6-monthly basis each year up until 2021, since when snapshots for 31 March, 30 June, 30 September and 31 December are published quarterly. 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 Click Preview next to a dataset to view interactive visualisations of the data.
Publisher name: HM Revenue and Customs
Last updated: 2025-05-02T04:00:25Z

Tables

2023-06-30 Organogram (Senior)

@ukgov.organogram_hm_revenue_and_customs.n_2023_06_30_organogram_senior

61.2 kB
590 rows
20 columns

CREATE TABLE n_2023_06_30_organogram_senior (
  "post_unique_reference" VARCHAR,
  "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-09-30 Organogram (Junior)

@ukgov.organogram_hm_revenue_and_customs.n_2023_09_30_organogram_junior

55.41 kB
13,739 rows
11 columns

CREATE TABLE n_2023_09_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "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.organogram_hm_revenue_and_customs.n_2023_09_30_organogram_senior

60.48 kB
595 rows
20 columns

CREATE TABLE n_2023_09_30_organogram_senior (
  "post_unique_reference" VARCHAR,
  "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" 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.organogram_hm_revenue_and_customs.n_2023_12_31_organogram_junior

55.51 kB
13,699 rows
11 columns

CREATE TABLE n_2023_12_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "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.organogram_hm_revenue_and_customs.n_2023_12_31_organogram_senior

54.84 kB
603 rows
20 columns

CREATE TABLE n_2023_12_31_organogram_senior (
  "post_unique_reference" VARCHAR,
  "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" 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-03-31 Organogram (Junior)

@ukgov.organogram_hm_revenue_and_customs.n_2024_03_31_organogram_junior

54.94 kB
13,563 rows
11 columns

CREATE TABLE n_2024_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "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.organogram_hm_revenue_and_customs.n_2024_03_31_organogram_senior

55.16 kB
635 rows
20 columns

CREATE TABLE n_2024_03_31_organogram_senior (
  "post_unique_reference" VARCHAR,
  "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" 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-06-30 Organogram (Junior)

@ukgov.organogram_hm_revenue_and_customs.n_2024_06_30_organogram_junior

55.09 kB
13,334 rows
11 columns

CREATE TABLE n_2024_06_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "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-06-30 Organogram (Senior)

@ukgov.organogram_hm_revenue_and_customs.n_2024_06_30_organogram_senior

49.49 kB
567 rows
20 columns

CREATE TABLE n_2024_06_30_organogram_senior (
  "post_unique_reference" VARCHAR,
  "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" 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-09-30 Organogram (Junior)

@ukgov.organogram_hm_revenue_and_customs.n_2024_09_30_organogram_junior

64.52 kB
13,363 rows
11 columns

CREATE TABLE n_2024_09_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "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,
  "office_region" VARCHAR
);

2024-09-30 Organogram (Senior)

@ukgov.organogram_hm_revenue_and_customs.n_2024_09_30_organogram_senior

48.1 kB
589 rows
20 columns

CREATE TABLE n_2024_09_30_organogram_senior (
  "post_unique_reference" VARCHAR,
  "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" 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-12-31 Organogram (Junior)

@ukgov.organogram_hm_revenue_and_customs.n_2024_12_31_organogram_junior

55.09 kB
13,348 rows
11 columns

CREATE TABLE n_2024_12_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "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.organogram_hm_revenue_and_customs.n_2024_12_31_organogram_senior

48.87 kB
587 rows
20 columns

CREATE TABLE n_2024_12_31_organogram_senior (
  "post_unique_reference" VARCHAR,
  "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" 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?
);

2025-03-31 Organogram (Junior)

@ukgov.organogram_hm_revenue_and_customs.n_2025_03_31_organogram_junior

55.22 kB
13,494 rows
11 columns

CREATE TABLE n_2025_03_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "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_revenue_and_customs.n_2025_03_31_organogram_senior

48.83 kB
587 rows
20 columns

CREATE TABLE n_2025_03_31_organogram_senior (
  "post_unique_reference" VARCHAR,
  "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" 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?
);

Organogram Of Staff Roles & Salaries

@ukgov.organogram_hm_revenue_and_customs.organogram_of_staff_roles_salaries

42.97 kB
419 rows
19 columns

CREATE TABLE organogram_of_staff_roles_salaries (
  "post_unique_reference" VARCHAR,
  "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" VARCHAR  -- Actual Pay Floor (£),
  "actual_pay_ceiling" VARCHAR  -- Actual Pay Ceiling (£),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "professional_occupational_group" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT  -- Valid?
);

Table 17

@ukgov.organogram_hm_revenue_and_customs.table_17

36.48 kB
346 rows
19 columns

CREATE TABLE table_17 (
  "post_unique_reference" VARCHAR,
  "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,
  "notes" VARCHAR,
  "valid" VARCHAR  -- Valid?
);