Special Report 27/2021: EU Support To Tourism
European Court of Auditors
@eca.special_report_27_2021_eu_support_to_tourism
European Court of Auditors
@eca.special_report_27_2021_eu_support_to_tourism
EU Support to tourism. Need for a fresh strategic orientation and a better funding approach
Publisher name: European Court of Auditors
Publisher URL: https://www.eca.europa.eu
Last updated: 2024-06-11T16:18:47Z
CREATE TABLE figure_1_international_arrivals_and_tourism_receipts_b_349d3d5c (
"region" VARCHAR,
"n__international_arrivals_by_region" VARCHAR -- % International Arrivals By Region,
"receipts_billion_eur" DOUBLE,
"number_of_visitors_millions" BIGINT -- Number Of Visitors (millions),
"n__international_toursim_receipts" VARCHAR -- %International Toursim Receipts
);CREATE TABLE figure_2_contribution_of_tourism_to_gdp_and_employment_in_2019 (
"country_region" VARCHAR,
"contribution_to_gdp_2019" VARCHAR -- Contribution To GDP (2019),
"contribution_to_employment_2019" VARCHAR -- Contribution To Employment (2019)
);CREATE TABLE figure_3_domestic_and_foreign_tourism_by_member_state__b14da389 (
"region_ms" VARCHAR,
"n__domestic_per_ms" VARCHAR -- %domestic Per MS,
"n__foreign_per_ms" VARCHAR -- %foreign Per MS,
"reporting" BIGINT,
"foreign" BIGINT,
"total" BIGINT
);CREATE TABLE figure_4_international_arrivals_in_the_eu (
"ms_region" VARCHAR,
"n__change_over_same_period_for_prevous_year" VARCHAR -- % Change Over Same Period For Prevous Year
);CREATE TABLE figure_5_reduction_of_the_contribution_of_travel_tourism_to_gdp (
"ms_region" VARCHAR,
"change_in_travel_tourism_to_gdp_from_2020_compared_to_2019" VARCHAR -- Change In Travel & Tourism To GDP From 2020 Compared To 2019
);CREATE TABLE figure_6_erdf_budget_allocations_to_tourism_by_member_state (
"code" VARCHAR,
"ms" VARCHAR,
"eu_amount_allocation_to_ics_55" DOUBLE -- EU Amount (allocation To ICs 55,
"n__56" DOUBLE -- 56,
"n__57_million_euros" VARCHAR -- 57) (million Euros),
"eu_amount_allocation_to_ics_74" VARCHAR -- EU Amount (allocation To ICs 74,
"n_75" VARCHAR -- 75,
"n_91" VARCHAR -- 91,
"n_92_and_93_million_euros" VARCHAR -- 92 And 93) (million Euros)
);CREATE TABLE table_1_erdf_budget_allocations_to_tourism_2007_2013 (
"intervention_code" DOUBLE,
"description" VARCHAR,
"declared_amount_in_million_euros" BIGINT -- Declared Amount (in Million Euros)
);CREATE TABLE table_2_erdf_budget_allocations_to_tourism_2014_2020 (
"n_92" DOUBLE -- 92,
"protection" VARCHAR,
"n__development_and_promotion_of_tourism_assets" BIGINT -- Development And Promotion Of Tourism Assets,
"n_831" VARCHAR -- 831
);Anyone who has the link will be able to view this.