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 31 December will be published. 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: Environment Agency
Last updated: 2025-04-30T04:00:21Z

Tables

2024-01-24 Organogram (Junior)

@ukgov.organogram_environment_agency.n_2024_01_24_organogram_junior

77.61 KB
6243 rows
11 columns


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

2024-01-24 Organogram (Senior)

@ukgov.organogram_environment_agency.n_2024_01_24_organogram_senior

36.82 KB
116 rows
20 columns


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

2024-07-31 Organogram (Junior)

@ukgov.organogram_environment_agency.n_2024_07_31_organogram_junior

58.69 KB
6292 rows
11 columns


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

2024-07-31 Organogram (Senior)

@ukgov.organogram_environment_agency.n_2024_07_31_organogram_senior

38.54 KB
165 rows
20 columns


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

2024-10-30 Organogram (Junior)

@ukgov.organogram_environment_agency.n_2024_10_30_organogram_junior

60.8 KB
6303 rows
11 columns


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

2024-10-30 Organogram (Senior)

@ukgov.organogram_environment_agency.n_2024_10_30_organogram_senior

37.17 KB
145 rows
20 columns


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

2024-12-31 Organogram (Junior)

@ukgov.organogram_environment_agency.n_2024_12_31_organogram_junior

60.07 KB
6283 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_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2024-12-31 Organogram (Senior)

@ukgov.organogram_environment_agency.n_2024_12_31_organogram_senior

37.66 KB
137 rows
20 columns


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

2025-03-31 Organogram (Junior)

@ukgov.organogram_environment_agency.n_2025_03_31_organogram_junior

60.55 KB
6363 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_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2025-03-31 Organogram (Senior)

@ukgov.organogram_environment_agency.n_2025_03_31_organogram_senior

38.23 KB
156 rows
20 columns


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