2021-2027 Achievement Details (multi-funds) Timeseries
REGIO-EVAL@ec.europa.eu
@esifunds.xi3a_zddk
REGIO-EVAL@ec.europa.eu
@esifunds.xi3a_zddk
CREATE TABLE table_1 (
"ms" VARCHAR,
"ms_name" VARCHAR,
"cci" VARCHAR,
"programme_version" DOUBLE,
"programme_status" VARCHAR,
"programme_adoption_date" TIMESTAMP,
"programme_short_title" VARCHAR,
"programme_full_title_en" VARCHAR,
"programme_full_title" VARCHAR,
"fund" VARCHAR,
"fund_family" VARCHAR,
"tod_cycle" BIGINT,
"tod_reference_version" DOUBLE,
"tod_status_short_name" VARCHAR,
"priority_code" VARCHAR,
"priority_name" VARCHAR,
"step_priority" BOOLEAN,
"policy_objective_short_name" VARCHAR,
"policy_objective_code" BIGINT,
"policy_objective_name" VARCHAR,
"specific_objective_short" VARCHAR,
"specific_objective_code" VARCHAR,
"specific_objective_name" VARCHAR,
"category_of_region" VARCHAR,
"indicator_type" VARCHAR,
"indicator_type_output_result" VARCHAR,
"common_indicators_y_n" BOOLEAN,
"indicator_short_name" VARCHAR,
"ind_code" VARCHAR,
"indicator_long_name" VARCHAR,
"measurement_unit" VARCHAR,
"term_indicator_measurement_unit" VARCHAR,
"term_target_measurement_unit" VARCHAR,
"common_indicator_code_output" VARCHAR,
"programme_specific_indicator_code_output" VARCHAR,
"rsv_indicator_code_output" VARCHAR,
"ind_group_code" VARCHAR,
"baseline_value" BIGINT,
"milestone_value_2024" DOUBLE,
"target_value_2029" DOUBLE,
"decided_value" DOUBLE,
"implemented_value" DOUBLE,
"add_to_open_data_y_n" VARCHAR,
"visualise_by_fund_ms" VARCHAR,
"visualise_by_po_so" VARCHAR,
"ind_group_name" VARCHAR,
"odp_order" BIGINT,
"odp_indicator_code" VARCHAR,
"is_latest_tod_cycle" BOOLEAN
);
Anyone who has the link will be able to view this.