2021-2027 Planned Finances Detailed (categorisation, Multi Funds)
REGIO-EVAL@ec.europa.eu
@esifunds.hgyj_gyin
REGIO-EVAL@ec.europa.eu
@esifunds.hgyj_gyin
CREATE TABLE table_1 (
"ms" VARCHAR,
"ms_name_en" VARCHAR,
"cci" VARCHAR,
"programme_title_short" VARCHAR,
"programme_title_en" VARCHAR,
"programme_title_full" VARCHAR,
"programme_status" VARCHAR,
"programme_version" DOUBLE,
"programme_adoption_date" TIMESTAMP,
"fund" VARCHAR,
"fund_family" VARCHAR,
"mid_term_review" VARCHAR,
"category_of_region" VARCHAR,
"priority_code" VARCHAR,
"priority_name" VARCHAR,
"step_priority" VARCHAR,
"policy_objective_short_name" VARCHAR,
"policy_objective_code" VARCHAR,
"policy_objective_name" VARCHAR,
"specific_objective_short_name" VARCHAR,
"specific_objective_code" VARCHAR,
"specific_objective_name" VARCHAR,
"dimension_type" VARCHAR,
"category_title_short" VARCHAR,
"category_code" VARCHAR,
"category_name" VARCHAR,
"cofinancing_rate" DOUBLE,
"eu_amount" DOUBLE,
"total_amount" DOUBLE,
"climate_weighting" DOUBLE,
"eu_climate_amount" DOUBLE,
"total_climate_amount" DOUBLE,
"environmental_weighting" DOUBLE,
"eu_environmental_amount" DOUBLE,
"total_environmental_amount" DOUBLE,
"biodiversity_weighting" DOUBLE,
"eu_biodiversity_amount" DOUBLE,
"total_biodiversity_amount" DOUBLE,
"gender_weighting" DOUBLE,
"eu_gender_amount" DOUBLE,
"total_gender_amount" DOUBLE,
"clean_air_weighting" DOUBLE,
"eu_clean_air_amount" DOUBLE,
"total_clean_air_amount" DOUBLE,
"digital_weighting" DOUBLE,
"eu_amount_digital" DOUBLE,
"total_amount_digital" DOUBLE,
"sustainable_urban_development" VARCHAR,
"territorial_tool" VARCHAR,
"territory_type" VARCHAR,
"un_sdg_tracking" VARCHAR,
"jtf_themes" VARCHAR,
"priority_type_code" VARCHAR,
"priority_type_description" VARCHAR
);
Anyone who has the link will be able to view this.