Baselight
Sign In

2021-2027 Finances Detailed Planned Vs Implemented (timeseries)

REGIO-EVAL@ec.europa.eu

@esifunds.n_3git_md5z

Table 1
@esifunds.n_3git_md5z.table_1

  • 164.97 KB
  • 1000 rows
  • 72 columns
ms

Ms

ms_name

Ms Name

cci

Cci

programme_short_title

Programme Short Title

programme_status

Programme Status

programme_version

Programme Version

programme_adoption_date

Programme Adoption Date

fund

Fund

fund_family

Fund Family

category_region_name

Category Region Name

tod_cycle

Tod Cycle

tod_year

Tod Year

tod_reference_version

Tod Reference Version

tod_status_short_name

Tod Status Short Name

priority_code

Priority Code

priority_name

Priority Name

pol_obj_short_name

Pol Obj Short Name

pol_obj_code

Pol Obj Code

pol_obj_name

Pol Obj Name

spec_obj_short_name

Spec Obj Short Name

spec_obj_code

Spec Obj Code

spec_obj_name

Spec Obj Name

dimension_type

Dimension Type

category_short_title

Category Short Title

category_code

Category Code

category_node

Category Node

cofinancing_rate

Cofinancing Rate

eu_amount

Eu Amount

total_amount

Total Amount

total_eligiblecost_of_selectedoperations

Total Eligiblecost Of Selectedoperations

eueligible_costs_decided_selectednotional

Eueligible Costs Decided Selectednotional

totalspendeligibleexpenditure_declared

Totalspendeligibleexpenditure Declared

euspendshare_eligexpendituredeclarednotional

Euspendshare Eligexpendituredeclarednotional

climate_weighting

Climate Weighting

eu_climate_amount

Eu Climate Amount

total_climate_amount

Total Climate Amount

decided_euamountforclimateaction_est

Decided Euamountforclimateaction Est

spent_euamountforclimateaction_est

Spent Euamountforclimateaction Est

environmental_weighting

Environmental Weighting

eu_environmental_amount

Eu Environmental Amount

total_environmental_amount

Total Environmental Amount

decided_euenvironmental_amount_est

Decided Euenvironmental Amount Est

spent_euenvironmental_amount_est

Spent Euenvironmental Amount Est

biodiversity_weighting

Biodiversity Weighting

eu_biodiversity_amount

Eu Biodiversity Amount

total_biodiversity_amount

Total Biodiversity Amount

decided_euamount_biodiversity_amount_est

Decided Euamount Biodiversity Amount Est

spent_euamount_biodiversity_amount_est

Spent Euamount Biodiversity Amount Est

gender_weighting

Gender Weighting

eu_gender_amount

Eu Gender Amount

total_gender_amount

Total Gender Amount

decided_eugender_amount_est

Decided Eugender Amount Est

spent_eugender_amount_est

Spent Eugender Amount Est

clean_air_weighting

Clean Air Weighting

eu_clean_air_amount

Eu Clean Air Amount

total_clean_air_amount

Total Clean Air Amount

decided_eucleanairamount_est

Decided Eucleanairamount Est

spent_eucleanairamount_est

Spent Eucleanairamount Est

digital_weighting

Digital Weighting

eu_amount_digital

Eu Amount Digital

total_amount_digital

Total Amount Digital

decided_euamountfordigital_est

Decided Euamountfordigital Est

spent_euamountfordigital_est

Spent Euamountfordigital Est

sustainable_urban_development

Sustainable Urban Development

territorial_tool

Territorial Tool

territory_type

Territory Type

un_sdg_tracking

Un Sdg Tracking

jtf_themes

Jtf Themes

priority_type_code

Priority Type Code

priority_type_description

Priority Type Description

number_of_operations

Number Of Operations

is_latest_tod_cycle

Is Latest Tod Cycle

NLNetherlands2021NL65AMPR001Netherlands - AMIFAdopted by EC3Fri Mar 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)AMIFHOMEVOID2024122024202412SentPO1 Asylum and migration1Asylum and migration3 Return33 ReturnIntervention FieldSO3.010 Operating support10Operating support0.854545518714638659.4817130344.91Y
PLPoland2021PL16FFPR003Lubelskie - PL - ERDF/ESF+Adopted by EC1.3Thu Nov 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)ERDFCohesionLess developed2023122023202312Sent11Rozwój zrównoważony terytorialniePO5 Europe closer to citizens5Europe closer to citizensRSO5.1 Integrated development in urban areasRSO5.1RSO5.1 Integrated development in urban areasIntervention Field166 Cultural heritage and cultural services166Protection, development and promotion of cultural heritage and cultural services0.84999999983537687441619851.77SDG 8 Decent work and economic growthOtherY
ELGreece2021EL16FFPR007Kentriki Makedonia – ERDF/ESF+Adopted by EC1.2Tue Sep 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)ERDFCohesionLess developed2023062023202306Sent04AΠροώθηση της Κοινωνικής Συνοχής στην Κεντρική Μακεδονία – Παρέμβαση του ΕΤΠΑPO4 Social Europe4Social EuropeRSO4.5 Access to health careRSO4.5RSO4.5 Access to health careIntervention Field127 Other social infrastructure for social inclusion127Other social infrastructure contributing to social inclusion in the community0.84999999981020000012000000SDG 1 No povertySocial infrastructureY
LVLatvia2021LV65AMPR001Latvia - AMIFAdopted by EC2Thu Apr 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)AMIFHOMEVOID2024122024202412SentPO1 Asylum and migration1Asylum and migration1 CEAS11 CEASIntervention FieldSO1.004 Children in migration4Children in migration0.7499999998Y
ITItaly2021IT16RFPR010Lombardia - ERDFAdopted by EC1.1Tue Aug 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)ERDFCohesionMore developed2023122023202312Sent2ASSE 2 - UN'EUROPA PIÙ VERDE, A BASSE EMISSIONI DI CARBONIO E IN TRANSIZIONE VERSO LA DECARBONIZZAZIONE E LA RESILIENZAPO2 Greener Europe2Greener EuropeRSO2.1 Energy efficiencyRSO2.1RSO2.1 Energy efficiencyIntervention Field042 Energy efficiency in housing - deep renovation42Energy efficiency renovation of existing housing stock, demonstration projects and supporting measures compliant with energy efficiency criteria0.410000000250000001100000000.44000000100000000.4400000010000000SDG 7 Affordable and clean energyClean energyY
SKSlovakia2021SK16FFPR001Programme Slovakia – SK– ERDF/CF/JTF/ESF+Adopted by EC1.2Thu Nov 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)JTFCohesionVOID2023062023202306Sent8P1Fond spravodlivej transformáciePO8 JTF specific objective8JTF specific objectiveJSO8.1 Just Transition FundJSO8.1JSO8.1 Just Transition FundIntervention Field025 Incubation, support to spin offs/outs + start ups25Incubation, support to spin offs and spin outs and start ups0.699999999237274005324857.15137274000.414909602129942.86SDG 8 Decent work and economic growthEnterprises and diversificationY
FIFinland2021FI16FFPR001Innovation and skills – FI – ERDF/ESF+/JTFAdopted by EC2Tue Dec 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)ESF+CohesionMore developed2024122024202412Sent4Työllistävä, osaava ja osallistava SuomiPO4 Social Europe4Social EuropeESO4.8 Active inclusion and employabilityESO4.8ESO4.8 Active inclusion and employabilityIntervention Field999 Flat rate technical assistance999Flat rate technical assistance – Article 36 (5) CPR0.427167.0767917.68TA and public administrationY
PLPoland2021PL05SFPR001Social Development - PL - ESF+Adopted by EC1.2Tue Dec 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)ESF+CohesionTransition2024062024202406SentIIIDostępność i usługi dla osób z niepełnosprawnościamiPO4 Social Europe4Social EuropeESO4.8 Active inclusion and employabilityESO4.8ESO4.8 Active inclusion and employabilityIntervention Field153 Employment integration for disadvantaged people153Pathways to integration and re‑entry into employment for disadvantaged people0.699999996167379229625602.91SDG 1 No povertySkills, job-search and educationY
TCInterreg2021TC16RFCB043Interreg VI-A - Estonia-LatviaAdopted by EC1.2Thu Dec 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Interreg FundsCohesionVOID2023062023202306Sent2Jointly and smartly growing businessesPO1 Smarter Europe1Smarter EuropeRSO1.3 Growth and competitiveness of SMEsRSO1.3RSO1.3 Growth and competitiveness of SMEsIntervention Field027 Innovation processes in SMEs27Innovation processes in SMEs (process, organisational, marketing, co‑creation, user and demand driven innovation)0.76498647268000001045770.130.4320000418308.05SDG 9 Industry, innovation, infrastructureEnterprises and diversificationY
FIFinland2021FI16FFPR001Innovation and skills – FI – ERDF/ESF+/JTFAdopted by EC2Tue Dec 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)JTFCohesionVOID2024062024202406Sent7Oikeudenmukaisen siirtymän SuomiPO8 JTF specific objective8JTF specific objectiveJSO8.1 Just Transition FundJSO8.1JSO8.1 Just Transition FundIntervention Field075 Enviro-friendly production processes in SMEs75Support to environmentally‑friendly production processes and resource efficiency in SMEs0.69999999861852904026470057.22802142119614994.66105769.9574038.961185290402802142128021421105769.950.4741161610588022.8811208568.442307.980.4741161610588022.8811208568.442307.98SDG 12 Responsible consumption and productionEnterprises and diversification55Y

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,
  "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" DOUBLE,
  "eu_climate_amount" DOUBLE,
  "total_climate_amount" DOUBLE,
  "decided_euamountforclimateaction_est" DOUBLE,
  "spent_euamountforclimateaction_est" DOUBLE,
  "environmental_weighting" DOUBLE,
  "eu_environmental_amount" DOUBLE,
  "total_environmental_amount" DOUBLE,
  "decided_euenvironmental_amount_est" DOUBLE,
  "spent_euenvironmental_amount_est" DOUBLE,
  "biodiversity_weighting" DOUBLE,
  "eu_biodiversity_amount" DOUBLE,
  "total_biodiversity_amount" DOUBLE,
  "decided_euamount_biodiversity_amount_est" DOUBLE,
  "spent_euamount_biodiversity_amount_est" DOUBLE,
  "gender_weighting" BIGINT,
  "eu_gender_amount" BIGINT,
  "total_gender_amount" BIGINT,
  "decided_eugender_amount_est" BIGINT,
  "spent_eugender_amount_est" BIGINT,
  "clean_air_weighting" DOUBLE,
  "eu_clean_air_amount" DOUBLE,
  "total_clean_air_amount" DOUBLE,
  "decided_eucleanairamount_est" DOUBLE,
  "spent_eucleanairamount_est" DOUBLE,
  "digital_weighting" DOUBLE,
  "eu_amount_digital" DOUBLE,
  "total_amount_digital" DOUBLE,
  "decided_euamountfordigital_est" DOUBLE,
  "spent_euamountfordigital_est" 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,
  "number_of_operations" BIGINT,
  "is_latest_tod_cycle" VARCHAR
);

Share link

Anyone who has the link will be able to view this.