Organogram Of Staff Roles & Salaries
Department for Education
@ukgov.organogram_department_for_education
Department for Education
@ukgov.organogram_department_for_education
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 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
Publisher name: Department for Education
Last updated: 2025-04-26T04:03:06Z
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" 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?
);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" DOUBLE,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR
);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" 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?
);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
);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" 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?
);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" DOUBLE,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR
);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" 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?
);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" DOUBLE,
"professional_occupational_group" VARCHAR,
"office_region" VARCHAR
);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?
);CREATE TABLE organogram_junior_data_september_2019 (
"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
);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?
);CREATE TABLE organogram_senior_data_september_2019 (
"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" DOUBLE -- Salary Cost Of Reports (£),
"fte" DOUBLE,
"actual_pay_floor" VARCHAR -- Actual Pay Floor (£),
"actual_pay_ceiling" VARCHAR -- Actual Pay Ceiling (£),
"total_pay" VARCHAR -- Total Pay (£),
"professional_occupational_group" VARCHAR,
"notes" VARCHAR
);Anyone who has the link will be able to view this.