CINEA Project Portfolio by European Climate, Infrastructure and Environment Executive Agency (CINEA) | Finance and Economics

About this Dataset

CINEA Project Portfolio

This dataset contains data about all signed Grant Agreements (GA) managed by the European Climate, Infrastructure and Environment Executive Agency (CINEA) as of 2014 call for proposals.
Publisher name: European Climate, Infrastructure and Environment Executive Agency
Publisher URL: https://commission.europa.eu/about/departments-and-executive-agencies/european-climate-infrastructure-and-environment-executive-agency
Last updated: 2024-12-13T11:25:28Z

Tables

Beneficiaries From Projects Managed By CINEA

@eucinea.cinea_project_portfolio.beneficiaries_from_projects_managed_by_cinea

1.85 MB
58194 rows
15 columns


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
);

Location Of The Projects Managed By CINEA

@eucinea.cinea_project_portfolio.location_of_the_projects_managed_by_cinea

6.28 KB
10 rows
7 columns


CREATE TABLE location_of_the_projects_managed_by_cinea (
  "project_number" BIGINT,
  "programme" VARCHAR,
  "country" VARCHAR,
  "nuts1_region" VARCHAR,
  "nuts2_region" VARCHAR,
  "nuts3_region" VARCHAR,
  "load_date" TIMESTAMP
);

Projects Managed By CINEA

@eucinea.cinea_project_portfolio.projects_managed_by_cinea

6.36 MB
6899 rows
21 columns


CREATE TABLE projects_managed_by_cinea (
  "project_number" VARCHAR,
  "project_acronym" VARCHAR,
  "project_title" VARCHAR,
  "project_description" VARCHAR,
  "call_acronym" VARCHAR,
  "call_description" VARCHAR,
  "call_year" BIGINT,
  "financial_framework" VARCHAR,
  "programme_description" VARCHAR,
  "programme" VARCHAR,
  "project_status" VARCHAR,
  "subprogramme" VARCHAR,
  "project_termination_date" TIMESTAMP,
  "project_closure_date" TIMESTAMP,
  "project_start_date" TIMESTAMP,
  "project_end_date" TIMESTAMP,
  "project_duration" BIGINT,
  "project_eu_funding" DOUBLE,
  "project_fiche_link" VARCHAR,
  "project_url" VARCHAR,
  "load_date" TIMESTAMP
);