Baselight

CINEA Project Portfolio

European Climate, Infrastructure and Environment Executive Agency

@eucinea.cinea_project_portfolio

Beneficiaries From Projects Managed By CINEA
@eucinea.cinea_project_portfolio.beneficiaries_from_projects_managed_by_cinea

List of beneficiaries from signed projects managed by CINEA

  • 1.82 MB
  • 57996 rows
  • 15 columns
project_number

PROJECT NUMBER

project_acronym

PROJECT ACRONYM

financial_framework

FINANCIAL FRAMEWORK

programme

PROGRAMME

subprogramme

SUBPROGRAMME

participant_legal_name

PARTICIPANT LEGAL NAME

participant_role

PARTICIPANT ROLE

participant_legal_status

PARTICIPANT LEGAL STATUS

sme_flag

SME FLAG

participant_city

PARTICIPANT CITY

participant_nuts_code

PARTICIPANT NUTS CODE

participant_country_code

PARTICIPANT COUNTRY CODE

participant_country_name

PARTICIPANT COUNTRY NAME

eu_contribution

EU CONTRIBUTION

load_date

LOAD DATE

25103622014-EU-TM-0732-S2014-2020CEFCEF TransportPlanta de Regasificación de Sagunto, S.A.PARTICIPANTPrivateMissingSagunto (Valencia)ES523ESSpain138557.51Fri Apr 11 2025 09:00:08 GMT+0000 (Coordinated Universal Time)
25103622014-EU-TM-0732-S2014-2020CEFCEF TransportFLOTA SUARDIAZ, S.L.PARTICIPANTPrivateMissingMadridES300ESSpain833871.94Fri Apr 11 2025 09:00:08 GMT+0000 (Coordinated Universal Time)
25294452014-EU-TM-0723-M2014-2020CEFCEF TransportSAS SOMANORPARTICIPANTPrivateMissingCAENFRD11FRFrance2904328.02Fri Apr 11 2025 09:00:08 GMT+0000 (Coordinated Universal Time)
25103542014-EU-TM-0686-S2014-2020CEFCEF TransportMinistero delle Infrastrutture e dei TrasportiPARTICIPANTPublicMissingRomaITI43ITItaly53049.57Fri Apr 11 2025 09:00:08 GMT+0000 (Coordinated Universal Time)
868156431.10-0016-UKNO-S-M-162014-2020CEFCEF EnergyNORTHCONNECT KSPARTICIPANTPrivateMissingKRISTIANSAND SNO092NONorway8696808.39Fri Apr 11 2025 09:00:08 GMT+0000 (Coordinated Universal Time)
9598795510.6-0011-DEFR-S-M-182014-2020CEFCEF Energyenergis-Netzgesellschaft mbHPARTICIPANTPrivateMissingSaarbrückenDEC01DEGermany286522.54Fri Apr 11 2025 09:00:08 GMT+0000 (Coordinated Universal Time)
26428552014-BE-TM-0238-M2014-2020CEFCEF TransportVlaamse Overheid (Flemish Authorities)COORDINATORPublicMissingBrusselBE100BEBelgium1070211.79Fri Apr 11 2025 09:00:08 GMT+0000 (Coordinated Universal Time)
25608272014-EU-TM-0190-W2014-2020CEFCEF TransportMinistero delle Infrastrutture e dei TrasportiCOORDINATORPublicMissingRomaITI43ITItaly439320000Fri Apr 11 2025 09:00:08 GMT+0000 (Coordinated Universal Time)
27509662014-EU-TM-0317-S2014-2020CEFCEF TransportS.C. Swarco Traffic Romania S.R.L.PARTICIPANTPrivateMissingBucharestRO321RORomania7403.11Fri Apr 11 2025 09:00:08 GMT+0000 (Coordinated Universal Time)
25703962014-EU-TM-0206-S2014-2020CEFCEF TransportSvitzer Sverige ABPARTICIPANTPrivateMissingVästra FrölundaSE232SESweden55359.69Fri Apr 11 2025 09:00:08 GMT+0000 (Coordinated Universal Time)

CREATE TABLE beneficiaries_from_projects_managed_by_cinea (
  "project_number" VARCHAR,
  "project_acronym" VARCHAR,
  "financial_framework" VARCHAR,
  "programme" VARCHAR,
  "subprogramme" VARCHAR,
  "participant_legal_name" VARCHAR,
  "participant_role" VARCHAR,
  "participant_legal_status" VARCHAR,
  "sme_flag" VARCHAR,
  "participant_city" VARCHAR,
  "participant_nuts_code" VARCHAR,
  "participant_country_code" VARCHAR,
  "participant_country_name" VARCHAR,
  "eu_contribution" DOUBLE,
  "load_date" TIMESTAMP
);

Share link

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