HMRC Senior Officials Travel Report
HM Revenue and Customs
@ukgov.hmrc_senior_officials_travel_report
HM Revenue and Customs
@ukgov.hmrc_senior_officials_travel_report
CREATE TABLE hmrc_senior_officials_travel_report (
"hm_revenue_and_customs_senior_officials_travel_report" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"n_1st_january_to_31st_march_2014" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE senior_officials_travel_report_april_2022_to_june_2022 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE senior_officials_travel_report_april_to_june_2020 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" TIMESTAMP,
"duration_of_visit_days" DOUBLE,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR
);
CREATE TABLE senior_officials_travel_report_april_to_june_2021 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR
);
CREATE TABLE senior_officials_travel_report_january_2022_to_march_2022 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE senior_officials_travel_report_january_2023_to_march_2023 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" DOUBLE,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" 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 senior_officials_travel_report_january_to_march_2020 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" TIMESTAMP,
"duration_of_visit_days" DOUBLE,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR
);
CREATE TABLE senior_officials_travel_report_january_to_march_2021 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE senior_officials_travel_report_july_to_september_2019 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" TIMESTAMP,
"duration_of_visit_days" BIGINT,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE senior_officials_travel_report_july_to_september_2020 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE senior_officials_travel_report_july_to_september_2021 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE senior_officials_travel_report_october_to_december_2019 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" TIMESTAMP,
"duration_of_visit_days" BIGINT,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE senior_officials_travel_report_october_to_december_2020 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR
);
CREATE TABLE senior_officials_travel_report_october_to_december_2021 (
"senior_officials_name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"accommodation_meals" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
Anyone who has the link will be able to view this.