Exceptions To Cross-Government Moratoria On Spend In HMRC
HM Revenue and Customs
@ukgov.exceptions_to_government_moratoria_hmrc
HM Revenue and Customs
@ukgov.exceptions_to_government_moratoria_hmrc
CREATE TABLE advertising_and_marketing_april_to_june_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE advertising_and_marketing_apr_june_2019 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"case_details" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE advertising_and_marketing_apr_june_2020 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR
);
CREATE TABLE advertising_and_marketing_jan_mar_2019 (
"owning_dept_alb_department" VARCHAR,
"n__case_name" VARCHAR,
"n__value_excluding_vat" VARCHAR,
"n__approval_date" TIMESTAMP,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR
);
CREATE TABLE advertising_and_marketing_jan_mar_2020 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE advertising_and_marketing_january_2022_to_march_2022 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE advertising_and_marketing_january_to_march_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE advertising_and_marketing_july_sep_2019 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"case_details" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE advertising_and_marketing_july_sep_2020 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"property_type" VARCHAR,
"control" VARCHAR
);
CREATE TABLE advertising_and_marketing_july_to_september_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE advertising_and_marketing_oct_dec_2019 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"case_details" VARCHAR,
"value_excluding_vat" BIGINT,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE advertising_and_marketing_october_to_december_2020 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE advertising_and_marketing_october_to_december_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE advertising_marketing_and_communications_april_2022_to_17d5e19f (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE advertising_marketing_july_sep_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"dept" VARCHAR,
"alb" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" VARCHAR
);
CREATE TABLE advertising_marketing_oct_dec_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"dept" VARCHAR,
"alb" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" TIMESTAMP
);
CREATE TABLE commercial_april_2022_to_june_2022 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE commercial_april_to_june_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE commercial_apr_june_2019 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"case_details" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE commercial_apr_june_2020 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR
);
CREATE TABLE commercial_jan_mar_2019 (
"owning_dept_alb_department" VARCHAR,
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP
);
CREATE TABLE commercial_jan_mar_2020 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE commercial_january_2022_to_march_2022 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE commercial_january_to_march_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE commercial_july_sep_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"dept" VARCHAR,
"alb" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" TIMESTAMP
);
Anyone who has the link will be able to view this.