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 property_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
);
CREATE TABLE property_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" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE property_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 property_july_to_september_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE property_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 property_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 property_october_to_december_2020 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE property_october_to_december_2021 (
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" VARCHAR,
"control" VARCHAR
);
CREATE TABLE recruitment_apr_june_2019 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"total_value_approved" VARCHAR,
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"total_approvals_headcount" DOUBLE,
"total_approvals_fte" DOUBLE,
"date_of_approval" TIMESTAMP
);
CREATE TABLE recruitment_apr_june_2020 (
"department" VARCHAR,
"ref_number" VARCHAR,
"organisation_name" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"total_approvals_headcount" VARCHAR,
"total_approvals_fte" DOUBLE,
"date_of_approval" TIMESTAMP
);
CREATE TABLE recruitment_jan_mar_2019 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"total_approvals_headcount" DOUBLE,
"total_approvals_fte" DOUBLE,
"date_of_approval" VARCHAR
);
CREATE TABLE recruitment_jan_mar_2020 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"ref_number" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"total_approvals_headcount" VARCHAR,
"total_approvals_fte" DOUBLE,
"date_of_approval" TIMESTAMP
);
CREATE TABLE recruitment_july_sep_2018 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"total_approvals_headcount" DOUBLE,
"total_approvals_fte" DOUBLE,
"date_of_approval" VARCHAR
);
CREATE TABLE recruitment_july_sep_2019 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"total_value_approved" VARCHAR,
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"total_approvals_headcount" DOUBLE,
"total_approvals_fte" DOUBLE,
"date_of_approval" TIMESTAMP
);
CREATE TABLE recruitment_oct_dec_2018 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"total_approvals_headcount" DOUBLE,
"total_approvals_fte" DOUBLE,
"date_of_approval" VARCHAR
);
CREATE TABLE recruitment_oct_dec_2019 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"total_approvals_headcount" DOUBLE,
"total_approvals_fte" DOUBLE,
"date_of_approval" TIMESTAMP
);
Anyone who has the link will be able to view this.