2021-2027 Planned Finances Detailed (categorisation, Multi Funds)
Directorate-General for Regional and Urban Policy
@ecdgregio.n_2021_2027_planned_finances_detailed_categorisation_m_221674bd
Directorate-General for Regional and Urban Policy
@ecdgregio.n_2021_2027_planned_finances_detailed_categorisation_m_221674bd
CREATE TABLE n_2021_2027_planned_finances_detailed_categorisation_m_d9b94a34 (
"ms" VARCHAR,
"ms_name_en" VARCHAR,
"cci" VARCHAR,
"programme_title_short" VARCHAR,
"programme_title_en" VARCHAR,
"programme_title_full" VARCHAR,
"status" VARCHAR,
"version" DOUBLE,
"last_adoption_date_ecms" TIMESTAMP,
"fund" VARCHAR,
"fund_family" 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" BIGINT,
"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.