Exceptions To Cross-Government Moratoria On Spend In Department For International Development

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

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

CREATE TABLE advertising_exceptions_january_to_march_2019 (
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "status_decision_result" VARCHAR,
  "approval_date" VARCHAR
);

CREATE TABLE advertising_exceptions_january_to_march_2020 (
  "reference_number" VARCHAR,
  "owning_dept_alb_department" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (£) (excluding VAT),
  "approval_date" TIMESTAMP,
  "control" VARCHAR
);

CREATE TABLE advertising_exceptions_july_to_september_2018 (
  "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
);

CREATE TABLE advertising_exceptions_july_to_september_2019 (
  "hmg_ref" VARCHAR,
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "approval_date" TIMESTAMP
);

CREATE TABLE advertising_exceptions_october_to_december_2018 (
  "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
);

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

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

CREATE TABLE commercial_exceptions_april_to_june_2020 (
  "owning_dept" VARCHAR,
  "title" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (£) (excluding VAT),
  "approval_date" TIMESTAMP,
  "control" VARCHAR
);

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

CREATE TABLE commercial_exceptions_january_to_march_2020 (
  "reference_number" VARCHAR,
  "owning_dept_alb_department" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (£) (excluding VAT),
  "approval_date" TIMESTAMP,
  "control" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

CREATE TABLE commercial_exceptions_july_to_september_2018 (
  "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,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

CREATE TABLE commercial_exceptions_july_to_september_2020 (
  "hmgc5318" VARCHAR,
  "international_citizen_service_2_ics2" VARCHAR  -- International Citizen Service 2 (ICS2),
  "this_was_for_an_extension_to_existing_contract_for_a_y_d4c180e3" VARCHAR  -- This Was For An Extension To Existing Contract For A Youth Volunteering Scheme,
  "dfid" VARCHAR,
  "commercial" VARCHAR,
  "n__16_400_000" VARCHAR  -- Ł16,400,000,
  "n_14_08_2019" TIMESTAMP  -- 14/08/2019
);

CREATE TABLE commercial_exceptions_october_to_december_2018 (
  "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
);

CREATE TABLE commercial_exceptions_october_to_december_2019 (
  "reference_number" VARCHAR,
  "dept" VARCHAR,
  "description" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (£) (excluding VAT),
  "approval_date" TIMESTAMP,
  "control" VARCHAR
);

CREATE TABLE consultancy_exceptions_april_to_june_2020 (
  "hmg_ref" VARCHAR,
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "approval_date" VARCHAR
);

CREATE TABLE consultancy_exceptions_for_july_to_september_2019 (
  "hmg_ref" VARCHAR,
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "approval_date" VARCHAR
);

CREATE TABLE consultancy_exceptions_january_to_march_2019 (
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "status_decision_result" VARCHAR,
  "approval_date" VARCHAR
);

CREATE TABLE consultancy_exceptions_january_to_march_2020 (
  "hmg_ref" VARCHAR,
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "approval_date" VARCHAR
);

CREATE TABLE consultancy_exceptions_july_to_september_2018 (
  "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
);

CREATE TABLE consultancy_exceptions_july_to_september_2020 (
  "hmg_ref" VARCHAR,
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "approval_date" VARCHAR
);

CREATE TABLE consultancy_exceptions_october_to_december_2018 (
  "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
);

CREATE TABLE consultancy_exceptions_october_to_december_2019 (
  "hmg_ref" VARCHAR,
  "title" VARCHAR,
  "description_notes_for_minister" VARCHAR,
  "dept" VARCHAR,
  "control_type" VARCHAR,
  "requested_value" VARCHAR,
  "approval_date" VARCHAR
);

CREATE TABLE exceptions_to_cross_government_moratoria_on_spend_in_d_c27387d1 (
  "tool_ref" VARCHAR,
  "department" VARCHAR,
  "organisation_name" VARCHAR,
  "project_name" VARCHAR,
  "basis_for_expenditure_approval" VARCHAR,
  "total_value_approved_m" VARCHAR  -- Total Value Approved (ŁM),
  "date_of_approval" VARCHAR
);