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 commercial_july_sep_2019 (
"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
);
CREATE TABLE commercial_july_sep_2020 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"property_type" VARCHAR,
"control" VARCHAR
);
CREATE TABLE commercial_july_to_september_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE commercial_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_oct_dec_2019 (
"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_october_to_december_2020 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE commercial_october_to_december_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE consultancy_april_to_june_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE consultancy_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 consultancy_apr_june_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 consultancy_jan_mar_2019 (
"owning_dept_alb_department" VARCHAR,
"n__case_name" VARCHAR,
"n__value_excluding_vat" VARCHAR,
"n__approval_date" VARCHAR,
"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 consultancy_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 consultancy_january_2022_to_march_2022 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE consultancy_january_to_march_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE consultancy_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 consultancy_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 consultancy_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 consultancy_july_to_september_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE consultancy_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" VARCHAR
);
CREATE TABLE consultancy_oct_dec_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 consultancy_october_to_december_2020 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE consultancy_october_to_december_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE contingent_labour_april_2022_to_june_2022 (
"q1_22_23" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE contingent_labour_april_2024_to_june_2024 (
"owning_dept_alb_department" VARCHAR,
"civil_service_grade_equivalent_head_count" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE contingent_labour_january_2023_to_march_2023 (
"owning_dept_alb_department" VARCHAR,
"civil_service_grade_equivalent_head_count" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
Anyone who has the link will be able to view this.