2014-2020 Kohesio Projects by European Structural and Investment Funds (ESI Funds) | Politics and Governance

About this Dataset

2014-2020 Kohesio Projects

This dataset presents the collection of projects (operations) financed by EU Cohesion policy funds. It provides their description ,location, thematic category, beneficiary, and more. For the 2014-2020 programming period these funds are the European Regional development Fund, the European Social Fund, and the Cohesion Fund. Projects are selected by the managing authorities of the programmes in the Member States and regions. Lists of projects are published by the managing authorities and processed by the European Commission (DG REGIO and DG CONNECT) to be shared in the Kohesio platform : https://kohesio.ec.europa.eu/en/ On data description, please refer to: https://kohesio.ec.europa.eu/en/faq
Publisher name: European Commission - Directorate General for Regional and Urban Policy
Last updated: 2024-12-09T16:56:01Z

Tables

Table 1

@esifunds.n_557j_pmg8.table_1

704.75 KB
1000 rows
30 columns


CREATE TABLE table_1 (
  "operation_unique_identifier" VARCHAR,
  "operation_name_english" VARCHAR,
  "operation_name_programme_language" VARCHAR,
  "country" VARCHAR,
  "postal_code" VARCHAR,
  "operation_start_date" TIMESTAMP,
  "operation_end_date" TIMESTAMP,
  "cofinancing_rate" DOUBLE,
  "total_eligible_expenditure_amount" DOUBLE,
  "total_eligible_expenditure_currency" VARCHAR,
  "project_eu_budget" DOUBLE,
  "beneficiary_unique_identifier" VARCHAR,
  "beneficiary_name" VARCHAR,
  "location_indicator_latitude_longitude" VARCHAR,
  "category_of_intervention" VARCHAR,
  "category_label" VARCHAR,
  "thematic_objective_id" VARCHAR,
  "thematic_objective_label" VARCHAR,
  "policy_objective_id" VARCHAR,
  "policy_objective_label" VARCHAR,
  "fund_code" VARCHAR,
  "fund_name" VARCHAR,
  "programme_code" VARCHAR,
  "programme_name" VARCHAR,
  "region" VARCHAR,
  "nuts3_code" VARCHAR,
  "programming_period" VARCHAR,
  "operation_summary_english" VARCHAR,
  "operation_summary_programme_language" VARCHAR,
  "managingauthority" VARCHAR
);