Special Report 27/2021: EU Support To Tourism

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
);

CREATE TABLE figure_6_erdf_budget_allocations_to_tourism_by_member_state (
  "code" VARCHAR,
  "ms" VARCHAR,
  "eu_amount_allocation_to_ics_55" DOUBLE,
  "n__56" DOUBLE,
  "n__57_million_euros" VARCHAR,
  "eu_amount_allocation_to_ics_74" VARCHAR,
  "n_75" VARCHAR,
  "n_91" VARCHAR,
  "n_92_and_93_million_euros" VARCHAR
);

CREATE TABLE figure_4_international_arrivals_in_the_eu (
  "ms_region" VARCHAR,
  "n__change_over_same_period_for_prevous_year" VARCHAR
);

CREATE TABLE table_2_erdf_budget_allocations_to_tourism_2014_2020 (
  "n_92" DOUBLE,
  "protection" VARCHAR,
  "n__development_and_promotion_of_tourism_assets" BIGINT,
  "n_831" VARCHAR
);

CREATE TABLE figure_1_international_arrivals_and_tourism_receipts_b_349d3d5c (
  "region" VARCHAR,
  "n__international_arrivals_by_region" VARCHAR,
  "receipts_billion_eur" DOUBLE,
  "number_of_visitors_millions" BIGINT,
  "n__international_toursim_receipts" VARCHAR
);

CREATE TABLE table_1_erdf_budget_allocations_to_tourism_2007_2013 (
  "intervention_code" DOUBLE,
  "description" VARCHAR,
  "declared_amount_in_million_euros" BIGINT
);

CREATE TABLE figure_2_contribution_of_tourism_to_gdp_and_employment_in_2019 (
  "country_region" VARCHAR,
  "contribution_to_gdp_2019" VARCHAR,
  "contribution_to_employment_2019" VARCHAR
);

CREATE TABLE figure_3_domestic_and_foreign_tourism_by_member_state__b14da389 (
  "region_ms" VARCHAR,
  "n__domestic_per_ms" VARCHAR,
  "n__foreign_per_ms" VARCHAR,
  "reporting" BIGINT,
  "foreign" BIGINT,
  "total" BIGINT
);