2021-2027 Form Of Support Planned Vs Implemented
@esifunds.ycmp_cica
@esifunds.ycmp_cica
CREATE TABLE table_1 (
"ms" VARCHAR,
"ms_name" VARCHAR,
"cci" VARCHAR,
"programme_short_title" VARCHAR,
"programme_status" VARCHAR,
"programme_version" DOUBLE,
"programme_adoption_date" TIMESTAMP,
"fund" VARCHAR,
"fund_family" VARCHAR,
"category_region_name" VARCHAR,
"tod_cycle" BIGINT,
"tod_year" BIGINT,
"tod_reference_version" DOUBLE,
"tod_status_short_name" VARCHAR,
"priority_code" VARCHAR,
"priority_name" VARCHAR,
"step_priority" BOOLEAN,
"pol_obj_short_name" VARCHAR,
"pol_obj_code" VARCHAR,
"pol_obj_name" VARCHAR,
"spec_obj_short_name" VARCHAR,
"spec_obj_code" VARCHAR,
"spec_obj_name" VARCHAR,
"dimension_type" VARCHAR,
"category_short_title" VARCHAR,
"category_code" BIGINT,
"category_node" VARCHAR,
"cofinancing_rate" DOUBLE,
"eu_amount" DOUBLE,
"total_amount" DOUBLE,
"total_eligiblecost_of_selectedoperations" DOUBLE,
"eueligible_costs_decided_selectednotional" DOUBLE,
"totalspendeligibleexpenditure_declared" DOUBLE,
"euspendshare_eligexpendituredeclarednotional" DOUBLE,
"climate_weighting" BIGINT,
"eu_climate_amount" BIGINT,
"total_climate_amount" BIGINT,
"decided_euamountforclimateaction_est" BIGINT,
"spent_euamountforclimateaction_est" BIGINT,
"environmental_weighting" BIGINT,
"eu_environmental_amount" BIGINT,
"total_environmental_amount" BIGINT,
"decided_euenvironmental_amount_est" BIGINT,
"spent_euenvironmental_amount_est" BIGINT,
"biodiversity_weighting" BIGINT,
"eu_biodiversity_amount" BIGINT,
"total_biodiversity_amount" BIGINT,
"decided_euamount_biodiversity_amount_est" BIGINT,
"spent_euamount_biodiversity_amount_est" BIGINT,
"gender_weighting" BIGINT,
"eu_gender_amount" BIGINT,
"total_gender_amount" BIGINT,
"decided_eugender_amount_est" BIGINT,
"spent_eugender_amount_est" BIGINT,
"clean_air_weighting" BIGINT,
"eu_clean_air_amount" BIGINT,
"total_clean_air_amount" BIGINT,
"decided_eucleanairamount_est" BIGINT,
"spent_eucleanairamount_est" BIGINT,
"digital_weighting" BIGINT,
"eu_amount_digital" BIGINT,
"total_amount_digital" BIGINT,
"decided_euamountfordigital_est" BIGINT,
"spent_euamountfordigital_est" BIGINT,
"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,
"number_of_operations" BIGINT,
"is_latest_tod_cycle" BOOLEAN
);
Anyone who has the link will be able to view this.