Special Report 12/2022: Durability In Rural Development

CREATE TABLE figure_01_total_employment_rate_in_rural_areas_in_2019 (
  "country_region" VARCHAR  -- Country / Region,
  "employment_rate_total" VARCHAR  -- Employment Rate - Total,
  "employment_rate_rural_area" VARCHAR  -- Employment Rate - Rural Area
);

CREATE TABLE figure_08_share_of_active_tourist_accommodation_projects (
  "member_state_region" VARCHAR,
  "sample_size_for_tourist_accommodations_examined" BIGINT,
  "number_of_tourist_accommodations_active" BIGINT,
  "number_of_tourist_accomodation_not_active" BIGINT,
  "n__active" VARCHAR  -- % Active,
  "n__inactive" VARCHAR  -- % Inactive
);

CREATE TABLE figure_11_distribution_of_polish_beneficiaries_who_sto_03f85f27 (
  "beneficiaries_of_m312_in_poland" VARCHAR,
  "distribution_of_polish_beneficiaries_who_stopped_their_e1931251" BIGINT  -- Distribution Of Polish Beneficiaries Who Stopped Their Activity (Number),
  "distribution_of_polish_beneficiaries_who_stopped_their_df8b2b9c" VARCHAR  -- Distribution Of Polish Beneficiaries Who Stopped Their Activity (in %)
);

CREATE TABLE figure_11_distribution_of_polish_beneficiaries_who_sto_1ce8df73 (
  "beneficiaries_of_m311_in_poland" VARCHAR,
  "distribution_of_polish_beneficiaries_who_stopped_their_e1931251" BIGINT  -- Distribution Of Polish Beneficiaries Who Stopped Their Activity (Number),
  "distribution_of_polish_beneficiaries_who_stopped_their_df8b2b9c" VARCHAR  -- Distribution Of Polish Beneficiaries Who Stopped Their Activity (in %)
);

CREATE TABLE figure_12_status_of_main_activities_supported_under_me_124ee40b (
  "state_of_play_end_of_february_2020" VARCHAR,
  "services_for_agricultural_holdings_or_forestry" VARCHAR,
  "wholesale" VARCHAR,
  "services_for_the_population" VARCHAR,
  "construction_works_and_services" VARCHAR,
  "n__sports_and_leisure_facilities_for_tourists" VARCHAR  -- Sports And Leisure Facilities For Tourists,
  "retail" VARCHAR,
  "craft_or_handicraft" VARCHAR
);

CREATE TABLE figure_13_return_on_investments_investment_costs_and_t_9c9fe2da (
  "projects" VARCHAR,
  "return_on_investment_after_three_years_of_revenue_per_invested" DOUBLE  -- Return On Investment After Three Years (€ Of Revenue Per € Invested),
  "project_cost_in" BIGINT  -- Project Cost In €,
  "n_3_years_revenue_in" BIGINT  -- 3-years Revenue In €
);