About this Dataset

Foreign, Commonwealth And Development Office: Human Resources Management Information

Foreign, Commonwealth and Development Office (FCDO) data relating to human resources workforce management information summary data.
Publisher name: Foreign, Commonwealth and Development Office (FCDO)
Last updated: 2023-03-15T04:14:02Z

Tables

August 2021 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.august_2021_fcdo_hr_management_information

43.03 kB
9 rows
43 columns

CREATE TABLE august_2021_fcdo_hr_management_information (
  "year" BIGINT,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff_ao_aa_headcount" BIGINT  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" BIGINT  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" BIGINT  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" BIGINT  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" BIGINT  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" BIGINT  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" BIGINT  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_agency_staff_headcount" BIGINT  -- Non-payroll Staff; Agency Staff; Headcount,
  "non_payroll_staff_agency_staff_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Agency Staff; Full-time Equivalent,
  "non_payroll_staff_interim_managers_headcount" BIGINT  -- Non-payroll Staff; Interim Managers; Headcount,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Interim Managers; Full-time Equivalent,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT  -- Non-payroll Staff; Specialist Contractors; Headcount,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Full-time Equivalent,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT  -- Non-payroll Staff; Consultants/consultancy; Headcount,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Full-time Equivalent,
  "non_payroll_staff_total_headcount" BIGINT  -- Non-payroll Staff; Total; Headcount,
  "non_payroll_staff_total_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Total; Full-time Equivalent,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" VARCHAR  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" VARCHAR  -- Non-Payroll Staff Costs; Contingent Labour: Agency Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_costs_consultants_consultancy" VARCHAR  -- Non-Payroll Staff Costs; Consultants/consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_published_alongside_your_row_of_information" VARCHAR  -- Comments (NB: Published Alongside Your Row Of Information)
);

December 2020 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.december_2020_fcdo_hr_management_information

42.32 kB
9 rows
41 columns

CREATE TABLE december_2020_fcdo_hr_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

December 2021 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.december_2021_fcdo_hr_management_information

42.1 kB
9 rows
42 columns

CREATE TABLE december_2021_fcdo_hr_management_information (
  "year" BIGINT,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff_ao_aa_headcount" BIGINT  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" BIGINT  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" BIGINT  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" BIGINT  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" BIGINT  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" BIGINT  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" BIGINT  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_agency_staff_headcount" BIGINT  -- Non-payroll Staff; Agency Staff; Headcount,
  "non_payroll_staff_agency_staff_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Agency Staff; Full-time Equivalent,
  "non_payroll_staff_interim_managers_headcount" BIGINT  -- Non-payroll Staff; Interim Managers; Headcount,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Interim Managers; Full-time Equivalent,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT  -- Non-payroll Staff; Specialist Contractors; Headcount,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Full-time Equivalent,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT  -- Non-payroll Staff; Consultants/consultancy; Headcount,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Full-time Equivalent,
  "non_payroll_staff_total_headcount" BIGINT  -- Non-payroll Staff; Total; Headcount,
  "non_payroll_staff_total_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Total; Full-time Equivalent,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" VARCHAR  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" VARCHAR  -- Non-Payroll Staff Costs; Contingent Labour: Agency Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_costs_consultants_consultancy" VARCHAR  -- Non-Payroll Staff Costs; Consultants/consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs
);

February 2021 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.february_2021_fcdo_hr_management_information

42.3 kB
9 rows
41 columns

CREATE TABLE february_2021_fcdo_hr_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

February 2022 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.february_2022_fcdo_hr_management_information

41.84 kB
37 rows
42 columns

CREATE TABLE february_2022_fcdo_hr_management_information (
  "year" DOUBLE,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff_ao_aa_headcount" DOUBLE  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" DOUBLE  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" DOUBLE  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" DOUBLE  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" DOUBLE  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" DOUBLE  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" DOUBLE  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" DOUBLE  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_agency_staff_headcount" DOUBLE  -- Non-payroll Staff; Agency Staff; Headcount,
  "non_payroll_staff_agency_staff_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Agency Staff; Full-time Equivalent,
  "non_payroll_staff_interim_managers_headcount" DOUBLE  -- Non-payroll Staff; Interim Managers; Headcount,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Interim Managers; Full-time Equivalent,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Headcount,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Full-time Equivalent,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Headcount,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Full-time Equivalent,
  "non_payroll_staff_total_headcount" DOUBLE  -- Non-payroll Staff; Total; Headcount,
  "non_payroll_staff_total_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Total; Full-time Equivalent,
  "grand_total_workforce_numbers_headcount" DOUBLE  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" VARCHAR  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" VARCHAR  -- Non-Payroll Staff Costs; Contingent Labour: Agency Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_costs_consultants_consultancy" VARCHAR  -- Non-Payroll Staff Costs; Consultants/consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs
);

January 2021 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.january_2021_fcdo_hr_management_information

42.31 kB
9 rows
41 columns

CREATE TABLE january_2021_fcdo_hr_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

January 2022 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.january_2022_fcdo_hr_management_information

42.06 kB
9 rows
42 columns

CREATE TABLE january_2022_fcdo_hr_management_information (
  "year" BIGINT,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff_ao_aa_headcount" BIGINT  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" BIGINT  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" BIGINT  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" BIGINT  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" BIGINT  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" BIGINT  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" BIGINT  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_agency_staff_headcount" BIGINT  -- Non-payroll Staff; Agency Staff; Headcount,
  "non_payroll_staff_agency_staff_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Agency Staff; Full-time Equivalent,
  "non_payroll_staff_interim_managers_headcount" BIGINT  -- Non-payroll Staff; Interim Managers; Headcount,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Interim Managers; Full-time Equivalent,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT  -- Non-payroll Staff; Specialist Contractors; Headcount,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Full-time Equivalent,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT  -- Non-payroll Staff; Consultants/consultancy; Headcount,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Full-time Equivalent,
  "non_payroll_staff_total_headcount" BIGINT  -- Non-payroll Staff; Total; Headcount,
  "non_payroll_staff_total_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Total; Full-time Equivalent,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" VARCHAR  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" VARCHAR  -- Non-Payroll Staff Costs; Contingent Labour: Agency Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_costs_consultants_consultancy" VARCHAR  -- Non-Payroll Staff Costs; Consultants/consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs
);

July 2021 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.july_2021_fcdo_hr_management_information

43.01 kB
9 rows
43 columns

CREATE TABLE july_2021_fcdo_hr_management_information (
  "year" BIGINT,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff_ao_aa_headcount" BIGINT  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" BIGINT  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" BIGINT  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" BIGINT  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" BIGINT  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" BIGINT  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" BIGINT  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_agency_staff_headcount" BIGINT  -- Non-payroll Staff; Agency Staff; Headcount,
  "non_payroll_staff_agency_staff_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Agency Staff; Full-time Equivalent,
  "non_payroll_staff_interim_managers_headcount" BIGINT  -- Non-payroll Staff; Interim Managers; Headcount,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Interim Managers; Full-time Equivalent,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT  -- Non-payroll Staff; Specialist Contractors; Headcount,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Full-time Equivalent,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT  -- Non-payroll Staff; Consultants/consultancy; Headcount,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Full-time Equivalent,
  "non_payroll_staff_total_headcount" BIGINT  -- Non-payroll Staff; Total; Headcount,
  "non_payroll_staff_total_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Total; Full-time Equivalent,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" VARCHAR  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" VARCHAR  -- Non-Payroll Staff Costs; Contingent Labour: Agency Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_costs_consultants_consultancy" VARCHAR  -- Non-Payroll Staff Costs; Consultants/consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_published_alongside_your_row_of_information" VARCHAR  -- Comments (NB: Published Alongside Your Row Of Information)
);

June 2021 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.june_2021_fcdo_hr_management_information

43.02 kB
9 rows
43 columns

CREATE TABLE june_2021_fcdo_hr_management_information (
  "year" BIGINT,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff_ao_aa_headcount" BIGINT  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" BIGINT  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" BIGINT  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" BIGINT  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" BIGINT  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" BIGINT  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" BIGINT  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_agency_staff_headcount" BIGINT  -- Non-payroll Staff; Agency Staff; Headcount,
  "non_payroll_staff_agency_staff_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Agency Staff; Full-time Equivalent,
  "non_payroll_staff_interim_managers_headcount" BIGINT  -- Non-payroll Staff; Interim Managers; Headcount,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Interim Managers; Full-time Equivalent,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT  -- Non-payroll Staff; Specialist Contractors; Headcount,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Full-time Equivalent,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT  -- Non-payroll Staff; Consultants/consultancy; Headcount,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Full-time Equivalent,
  "non_payroll_staff_total_headcount" BIGINT  -- Non-payroll Staff; Total; Headcount,
  "non_payroll_staff_total_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Total; Full-time Equivalent,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" VARCHAR  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" VARCHAR  -- Non-Payroll Staff Costs; Contingent Labour: Agency Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_costs_consultants_consultancy" VARCHAR  -- Non-Payroll Staff Costs; Consultants/consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_published_alongside_your_row_of_information" VARCHAR  -- Comments (NB: Published Alongside Your Row Of Information)
);

March 2021 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.march_2021_fcdo_hr_management_information

42.33 kB
9 rows
41 columns

CREATE TABLE march_2021_fcdo_hr_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

March 2022 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.march_2022_fcdo_hr_management_information

42.09 kB
9 rows
42 columns

CREATE TABLE march_2022_fcdo_hr_management_information (
  "year" BIGINT,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff_ao_aa_headcount" BIGINT  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" BIGINT  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" BIGINT  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" BIGINT  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" BIGINT  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" BIGINT  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" BIGINT  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_agency_staff_headcount" BIGINT  -- Non-payroll Staff; Agency Staff; Headcount,
  "non_payroll_staff_agency_staff_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Agency Staff; Full-time Equivalent,
  "non_payroll_staff_interim_managers_headcount" BIGINT  -- Non-payroll Staff; Interim Managers; Headcount,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Interim Managers; Full-time Equivalent,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT  -- Non-payroll Staff; Specialist Contractors; Headcount,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Full-time Equivalent,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT  -- Non-payroll Staff; Consultants/consultancy; Headcount,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Full-time Equivalent,
  "non_payroll_staff_total_headcount" BIGINT  -- Non-payroll Staff; Total; Headcount,
  "non_payroll_staff_total_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Total; Full-time Equivalent,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" VARCHAR  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" VARCHAR  -- Non-Payroll Staff Costs; Contingent Labour: Agency Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_costs_consultants_consultancy" VARCHAR  -- Non-Payroll Staff Costs; Consultants/consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs
);

May 2021 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.may_2021_fcdo_hr_management_information

42.38 kB
9 rows
41 columns

CREATE TABLE may_2021_fcdo_hr_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

November 2020 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.november_2020_fcdo_hr_management_information

42.31 kB
9 rows
41 columns

CREATE TABLE november_2020_fcdo_hr_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

November 2021 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.november_2021_fcdo_hr_management_information

42.94 kB
9 rows
43 columns

CREATE TABLE november_2021_fcdo_hr_management_information (
  "year" BIGINT,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff_ao_aa_headcount" BIGINT  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" BIGINT  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" BIGINT  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" BIGINT  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" BIGINT  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" BIGINT  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" BIGINT  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" BIGINT  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_agency_staff_headcount" BIGINT  -- Non-payroll Staff; Agency Staff; Headcount,
  "non_payroll_staff_agency_staff_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Agency Staff; Full-time Equivalent,
  "non_payroll_staff_interim_managers_headcount" BIGINT  -- Non-payroll Staff; Interim Managers; Headcount,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Interim Managers; Full-time Equivalent,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT  -- Non-payroll Staff; Specialist Contractors; Headcount,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Full-time Equivalent,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT  -- Non-payroll Staff; Consultants/consultancy; Headcount,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Full-time Equivalent,
  "non_payroll_staff_total_headcount" BIGINT  -- Non-payroll Staff; Total; Headcount,
  "non_payroll_staff_total_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Total; Full-time Equivalent,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" VARCHAR  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" VARCHAR  -- Non-Payroll Staff Costs; Contingent Labour: Agency Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_costs_consultants_consultancy" VARCHAR  -- Non-Payroll Staff Costs; Consultants/consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comment" VARCHAR
);

October 2020 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.october_2020_fcdo_hr_management_information

42.29 kB
9 rows
41 columns

CREATE TABLE october_2020_fcdo_hr_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

October 2021 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.october_2021_fcdo_hr_management_information

47.16 kB
460 rows
51 columns

CREATE TABLE october_2021_fcdo_hr_management_information (
  "year" DOUBLE,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff_ao_aa_headcount" DOUBLE  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" DOUBLE  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" DOUBLE  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" DOUBLE  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" DOUBLE  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" DOUBLE  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" DOUBLE  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" DOUBLE  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_agency_staff_headcount" DOUBLE  -- Non-payroll Staff; Agency Staff; Headcount,
  "non_payroll_staff_agency_staff_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Agency Staff; Full-time Equivalent,
  "non_payroll_staff_interim_managers_headcount" DOUBLE  -- Non-payroll Staff; Interim Managers; Headcount,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Interim Managers; Full-time Equivalent,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Headcount,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Full-time Equivalent,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Headcount,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Full-time Equivalent,
  "non_payroll_staff_total_headcount" DOUBLE  -- Non-payroll Staff; Total; Headcount,
  "non_payroll_staff_total_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Total; Full-time Equivalent,
  "grand_total_workforce_numbers_headcount" DOUBLE  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" VARCHAR  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" VARCHAR  -- Non-Payroll Staff Costs; Contingent Labour: Agency Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_costs_consultants_consultancy" VARCHAR  -- Non-Payroll Staff Costs; Consultants/consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50
);

September 2020 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.september_2020_fcdo_hr_management_information

42.32 kB
9 rows
41 columns

CREATE TABLE september_2020_fcdo_hr_management_information (
  "organisation_name" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR,
  "payroll_staff_costs_allowances" VARCHAR,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "payroll_staff_costs_overtime" VARCHAR,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR,
  "payroll_staff_costs_total_paybill_for_payroll_staff" VARCHAR,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" VARCHAR  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" VARCHAR  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

September 2021 FCDO HR Management Information

@ukgov.https_www_gov_uk_government_collections_fcdo_workforce_d7546775.september_2021_fcdo_hr_management_information

42.81 kB
46 rows
43 columns

CREATE TABLE september_2021_fcdo_hr_management_information (
  "year" DOUBLE,
  "month" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff_ao_aa_headcount" DOUBLE  -- Payroll Staff; AO/AA; Headcount,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE  -- Payroll Staff; AO/AA; Full-time Equivalent,
  "payroll_staff_eo_headcount" DOUBLE  -- Payroll Staff; EO; Headcount,
  "payroll_staff_eo_full_time_equivalent" DOUBLE  -- Payroll Staff; EO; Full-time Equivalent,
  "payroll_staff_seo_heo_headcount" DOUBLE  -- Payroll Staff; SEO/HEO; Headcount,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE  -- Payroll Staff; SEO/HEO; Full-time Equivalent,
  "payroll_staff_grade_6_7_headcount" DOUBLE  -- Payroll Staff; Grade 6/7; Headcount,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE  -- Payroll Staff; Grade 6/7; Full-time Equivalent,
  "payroll_staff_scs_headcount" DOUBLE  -- Payroll Staff; SCS; Headcount,
  "payroll_staff_scs_full_time_equivalent" DOUBLE  -- Payroll Staff; SCS; Full-time Equivalent,
  "payroll_staff_other_unknown_unspecified_headcount" DOUBLE  -- Payroll Staff; Other, Unknown, Unspecified; Headcount,
  "payroll_staff_other_unknown_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff; Other, Unknown, Unspecified; Full-time Equivalent,
  "payroll_staff_total_headcount" DOUBLE  -- Payroll Staff; Total; Headcount,
  "payroll_staff_total_full_time_equivalent" DOUBLE  -- Payroll Staff; Total; Full-time Equivalent,
  "non_payroll_staff_agency_staff_headcount" DOUBLE  -- Non-payroll Staff; Agency Staff; Headcount,
  "non_payroll_staff_agency_staff_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Agency Staff; Full-time Equivalent,
  "non_payroll_staff_interim_managers_headcount" DOUBLE  -- Non-payroll Staff; Interim Managers; Headcount,
  "non_payroll_staff_interim_managers_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Interim Managers; Full-time Equivalent,
  "non_payroll_staff_specialist_contractors_headcount" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Headcount,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Specialist Contractors; Full-time Equivalent,
  "non_payroll_staff_consultants_consultancy_headcount" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Headcount,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Consultants/consultancy; Full-time Equivalent,
  "non_payroll_staff_total_headcount" DOUBLE  -- Non-payroll Staff; Total; Headcount,
  "non_payroll_staff_total_full_time_equivalent" DOUBLE  -- Non-payroll Staff; Total; Full-time Equivalent,
  "grand_total_workforce_numbers_headcount" DOUBLE  -- Grand Total (workforce Numbers); Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers); Full-time Equivalent,
  "payroll_staff_costs_salary" VARCHAR  -- Payroll Staff Costs; Salary,
  "payroll_staff_costs_allowances" VARCHAR  -- Payroll Staff Costs; Allowances,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR  -- Payroll Staff Costs; Non-consolidated Performance Payments,
  "payroll_staff_costs_overtime" VARCHAR  -- Payroll Staff Costs; Overtime,
  "payroll_staff_costs_employer_pension_contributions" VARCHAR  -- Payroll Staff Costs; Employer Pension Contributions,
  "payroll_staff_costs_employer_national_insurance_contributions" VARCHAR  -- Payroll Staff Costs; Employer National Insurance Contributions,
  "payroll_staff_costs_total_paybill" VARCHAR  -- Payroll Staff Costs; Total Paybill,
  "non_payroll_staff_costs_contingent_labour_agency_staff_0dec6ad5" VARCHAR  -- Non-Payroll Staff Costs; Contingent Labour: Agency Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_costs_consultants_consultancy" VARCHAR  -- Non-Payroll Staff Costs; Consultants/consultancy,
  "non_payroll_staff_costs_total_staff_costs" VARCHAR  -- Non-Payroll Staff Costs; Total Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_published_alongside_your_row_of_information" VARCHAR  -- Comments (NB: Published Alongside Your Row Of Information)
);