ESIF 2014-2020 Categorisation ERDF-ESF-CF Planned Vs Implemented
DG REGIO
@esifunds.n_3kkx_ekfq
DG REGIO
@esifunds.n_3kkx_ekfq
CREATE TABLE table_1 (
"ms" VARCHAR,
"cci" VARCHAR,
"title" VARCHAR,
"programme_version" DOUBLE,
"status" VARCHAR,
"priority" VARCHAR,
"pax_react_eu" VARCHAR,
"pax_care" VARCHAR,
"pax_react_eu_care" VARCHAR,
"fund" VARCHAR,
"category_of_region" VARCHAR,
"year" BIGINT,
"dimension_type" VARCHAR,
"dimension_title_short" VARCHAR,
"dimension_code" VARCHAR,
"dimension_title" VARCHAR,
"financial_data_version" VARCHAR,
"eu_cofinancing_rate" DOUBLE,
"planned_total_amount_notional" DOUBLE,
"planned_eu_amount" DOUBLE,
"total_eligible_costs_selected_fin_data" DOUBLE,
"eu_eligible_costs_selected_fin_data_notional" DOUBLE,
"public_eligible_costs_fin_data" DOUBLE,
"total_elig_expenditure_declared_fin_data" DOUBLE,
"eu_elig_expenditure_declared_fin_data_notional" DOUBLE,
"reference_date" TIMESTAMP,
"planned_eu_amount_climate_change" DOUBLE,
"eu_eligible_costs_notional_climate_change" DOUBLE,
"eu_eligible_expenditure_notional_climate_change" DOUBLE,
"planned_eu_amount_biodiversity" DOUBLE,
"eu_eligible_costs_notional_biodiversity" DOUBLE,
"eu_eligible_expenditure_notional_biodiversity" DOUBLE,
"planned_eu_amount_clean_air" DOUBLE,
"eu_eligible_costs_notional_clean_air" DOUBLE,
"eu_eligible_expenditure_notional_clean_air" DOUBLE,
"number_of_operations" DOUBLE,
"to" VARCHAR,
"to_short" VARCHAR,
"sdg_mapping_description" VARCHAR
);
Anyone who has the link will be able to view this.