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

20.06 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  -- Total Value Approved (Ł),
  "basis_for_exception" VARCHAR,
  "approval_month" VARCHAR,
  "civil_service_grade_fte_aa_ao" BIGINT  -- Civil Service Grade (FTE) AA/AO,
  "civil_service_grade_fte_eo" BIGINT  -- Civil Service Grade (FTE)EO,
  "civil_service_grade_fte_heo" BIGINT  -- Civil Service Grade (FTE)HEO,
  "civil_service_grade_fte_seo" DOUBLE  -- Civil Service Grade (FTE) SEO,
  "civil_service_grade_fte_grade_6_7" BIGINT  -- Civil Service Grade (FTE) Grade 6 / 7,
  "civil_service_grade_fte_scs" BIGINT  -- Civil Service Grade (FTE) SCS,
  "civil_service_grade_fte_other" BIGINT  -- Civil Service Grade (FTE) Other,
  "civil_service_grade_headcount_aa_ao" BIGINT  -- Civil Service Grade (Headcount) AA/AO,
  "civil_service_grade_headcount_eo" BIGINT  -- Civil Service Grade (Headcount) EO,
  "civil_service_grade_headcount_heo" BIGINT  -- Civil Service Grade (Headcount) HEO,
  "civil_service_grade_headcount_seo" BIGINT  -- Civil Service Grade (Headcount) SEO,
  "civil_service_grade_headcount_grade_6_7" BIGINT  -- Civil Service Grade (Headcount) Grade 6 / 7,
  "civil_service_grade_headcount_scs" BIGINT  -- Civil Service Grade (Headcount) SCS,
  "civil_service_grade_headcount_other" BIGINT  -- Civil Service Grade (Headcount) Other,
  "total_approvals_headcount" BIGINT  -- Total Approvals (Headcount),
  "total_approvals_fte" DOUBLE  -- Total Approvals (FTE),
  "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.42 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  -- Value (Ł) (excluding VAT),
  "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

6.01 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.26 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

6.01 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.45 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  -- Value (È) (excluding VAT),
  "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.73 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  -- Civil Service Grade (FTE),
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "civil_service_grade_headcount" VARCHAR  -- Civil Service Grade (Headcount),
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "total_approvals_fte" DOUBLE  -- Total Approvals (FTE),
  "total_approvals_headcount" DOUBLE  -- Total Approvals (Headcount),
  "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

16.35 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  -- Total Value Approved (Ł),
  "basis_for_exception" VARCHAR,
  "approval_month" VARCHAR,
  "civil_service_grade_fte" VARCHAR  -- Civil Service Grade (FTE),
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "civil_service_grade_headcount" VARCHAR  -- Civil Service Grade (Headcount),
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "total_approvals_headcount" DOUBLE  -- Total Approvals (Headcount),
  "total_approvals_fte" DOUBLE  -- Total Approvals (FTE),
  "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

6.01 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.2 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  -- Value (Ł) (excluding VAT),
  "approval_date" TIMESTAMP
);

FCO Spending Controls - Recruitment Q4

@ukgov.https_www_gov_uk_government_collections_exceptions_data.fco_spending_controls_recruitment_q4

13.82 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  -- Civil Service Grade (FTE),
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "civil_service_grade_headcount" VARCHAR  -- Civil Service Grade (Headcount),
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "total_approvals_fte" DOUBLE  -- Total Approvals (FTE),
  "total_approvals_headcount" DOUBLE  -- Total Approvals (Headcount),
  "date_of_approval" VARCHAR
);