Exceptions To Cross-Government Moratoria On Spend In Department For International Development
Department for International Development
@ukgov.exceptions_to_government_moratoria_department_for_inte_5bac32ad
Department for International Development
@ukgov.exceptions_to_government_moratoria_department_for_inte_5bac32ad
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,
"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,
"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,
"approval_date" TIMESTAMP,
"control" VARCHAR,
"unnamed_6" VARCHAR
);
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
);
CREATE TABLE commercial_exceptions_july_to_september_2020 (
"hmgc5318" VARCHAR,
"international_citizen_service_2_ics2" VARCHAR,
"this_was_for_an_extension_to_existing_contract_for_a_y_d4c180e3" VARCHAR,
"dfid" VARCHAR,
"commercial" VARCHAR,
"n__16_400_000" VARCHAR,
"n_14_08_2019" TIMESTAMP
);
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,
"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,
"date_of_approval" VARCHAR
);
Anyone who has the link will be able to view this.