About this Dataset

FCO Exceptions To Spending Control Data

This dataset is a list of those items of spend that have been allowed in the Foreign and Commonwealth Office since the announcement (24 May 2010) of five cross-government moratoria: ICT spend above £1m; Advertising & Marketing; consultancy; Property leases & lease extensions; and Civil Service recruitment.
Publisher name: Foreign and Commonwealth Office
Last updated: 2024-09-14T12:25:17Z

Tables

FCO Exceptions To Spending Control Data

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_exceptions_to_spending_control_data

19.59 KB
5 rows
24 columns


CREATE TABLE fco_exceptions_to_spending_control_data (
  "department" VARCHAR,
  "organisation_name" VARCHAR,
  "basis_for_expenditure_approval" VARCHAR,
  "project_name" VARCHAR,
  "total_value_approved" VARCHAR,
  "basis_for_exception" VARCHAR,
  "approval_month" VARCHAR,
  "civil_service_grade_fte_aa_ao" BIGINT,
  "civil_service_grade_fte_eo" BIGINT,
  "civil_service_grade_fte_heo" BIGINT,
  "civil_service_grade_fte_seo" DOUBLE,
  "civil_service_grade_fte_grade_6_7" BIGINT,
  "civil_service_grade_fte_scs" BIGINT,
  "civil_service_grade_fte_other" BIGINT,
  "civil_service_grade_headcount_aa_ao" BIGINT,
  "civil_service_grade_headcount_eo" BIGINT,
  "civil_service_grade_headcount_heo" BIGINT,
  "civil_service_grade_headcount_seo" BIGINT,
  "civil_service_grade_headcount_grade_6_7" BIGINT,
  "civil_service_grade_headcount_scs" BIGINT,
  "civil_service_grade_headcount_other" BIGINT,
  "total_approvals_headcount" BIGINT,
  "total_approvals_fte" DOUBLE,
  "date_of_approval" VARCHAR
);

FCO Exceptions To Spending Controls: April - June 2019

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_exceptions_to_spending_controls_april_june_2019

9.2 KB
10 rows
7 columns


CREATE TABLE fco_exceptions_to_spending_controls_april_june_2019 (
  "reference_number" VARCHAR,
  "owning_dept_alb_department" VARCHAR,
  "control_type" VARCHAR,
  "case_name" VARCHAR,
  "case_details" VARCHAR,
  "value_excluding_vat" VARCHAR,
  "approval_date" TIMESTAMP
);

FCO Exceptions To Spending Controls: Facilities Management: January - March 2019

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_exceptions_to_spending_controls_facilities_managem_54c76dff

5.87 KB
999 rows
8 columns


CREATE TABLE fco_exceptions_to_spending_controls_facilities_managem_54c76dff (
  "hmg_ref" VARCHAR,
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "status_decision_result" VARCHAR,
  "minister_sub_date" VARCHAR
);

FCO Exceptions To Spending Controls: ICT January - March 2019

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_exceptions_to_spending_controls_ict_january_march_2019

8.07 KB
1 row
8 columns


CREATE TABLE fco_exceptions_to_spending_controls_ict_january_march_2019 (
  "hmg_ref" VARCHAR,
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "status_decision_result" VARCHAR,
  "minister_sub_date" TIMESTAMP
);

FCO Exceptions To Spending Controls: Property January - March 2019

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_exceptions_to_spending_controls_property_january_march_2019

5.87 KB
999 rows
8 columns


CREATE TABLE fco_exceptions_to_spending_controls_property_january_march_2019 (
  "hmg_ref" VARCHAR,
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "status_decision_result" VARCHAR,
  "minister_sub_date" VARCHAR
);

FCO Exceptions To Spending Controls Q1–2020 - Commerical

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_exceptions_to_spending_controls_q1_2020_commerical

5.32 KB
3 rows
6 columns


CREATE TABLE fco_exceptions_to_spending_controls_q1_2020_commerical (
  "reference_number" VARCHAR,
  "owning_dept_alb_department" VARCHAR,
  "control" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR,
  "approval_date" TIMESTAMP
);

FCO Exceptions To Spending Controls Q1–2020 - Recruitment

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_exceptions_to_spending_controls_q1_2020_recruitment

13.4 KB
7 rows
20 columns


CREATE TABLE fco_exceptions_to_spending_controls_q1_2020_recruitment (
  "department" VARCHAR,
  "organisation_name" VARCHAR,
  "approval_month" VARCHAR,
  "civil_service_grade_fte" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "civil_service_grade_headcount" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "total_approvals_fte" DOUBLE,
  "total_approvals_headcount" DOUBLE,
  "date_of_approval" VARCHAR
);

FCO Exceptions To Spending Controls: Recruitment April - June 2019

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_exceptions_to_spending_controls_recruitment_april_june_2019

15.96 KB
7 rows
24 columns


CREATE TABLE fco_exceptions_to_spending_controls_recruitment_april_june_2019 (
  "department" VARCHAR,
  "organisation_name" VARCHAR,
  "basis_for_expenditure_approval" VARCHAR,
  "project_name" VARCHAR,
  "total_value_approved" VARCHAR,
  "basis_for_exception" VARCHAR,
  "approval_month" VARCHAR,
  "civil_service_grade_fte" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "civil_service_grade_headcount" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "total_approvals_headcount" DOUBLE,
  "total_approvals_fte" DOUBLE,
  "date_of_approval" VARCHAR
);

FCO Exceptions To Spendng Controls: Advertising And Marketing: January - March 2019

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_exceptions_to_spendng_controls_advertising_and_mar_222ac3d1

5.87 KB
999 rows
8 columns


CREATE TABLE fco_exceptions_to_spendng_controls_advertising_and_mar_222ac3d1 (
  "hmg_ref" VARCHAR,
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "status_decision_result" VARCHAR,
  "minister_sub_date" VARCHAR
);

FCO Spending Controls Data Q4

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_spending_controls_data_q4

6.06 KB
7 rows
6 columns


CREATE TABLE fco_spending_controls_data_q4 (
  "reference_number" VARCHAR,
  "owning_dept_alb_department" VARCHAR,
  "control" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR,
  "approval_date" TIMESTAMP
);

FCO Spending Controls - Recruitment Q4

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_spending_controls_recruitment_q4

13.5 KB
7 rows
20 columns


CREATE TABLE fco_spending_controls_recruitment_q4 (
  "department" VARCHAR,
  "organisation_name" VARCHAR,
  "approval_month" VARCHAR,
  "civil_service_grade_fte" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "civil_service_grade_headcount" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "total_approvals_fte" DOUBLE,
  "total_approvals_headcount" DOUBLE,
  "date_of_approval" VARCHAR
);