About this Dataset

Defra Organogram March 2022

Defra Organogram as of March 2022
Publisher name: Department for Environment, Food and Rural Affairs
Last updated: 2023-02-18T04:12:01Z

Tables

2022-06-09 Organogram (Junior)

@ukgov.defra2_organogram_march_2022.n_2022_06_09_organogram_junior

21.08 kB
2,451 rows
11 columns

CREATE TABLE n_2022_06_09_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
);

2022-06-09 Organogram (Senior)

@ukgov.defra2_organogram_march_2022.n_2022_06_09_organogram_senior

22.6 kB
232 rows
20 columns

CREATE TABLE n_2022_06_09_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?
);

2023-02-17 Organogram (Junior)

@ukgov.defra2_organogram_march_2022.n_2023_02_17_organogram_junior

19.9 kB
2,064 rows
11 columns

CREATE TABLE n_2023_02_17_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
);

2023-02-17 Organogram (Senior)

@ukgov.defra2_organogram_march_2022.n_2023_02_17_organogram_senior

24.5 kB
215 rows
20 columns

CREATE TABLE n_2023_02_17_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?
);