Name: EU Research Projects
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

EU Research Projects

Description

This dataset contains projects and related organisations funded by the European Union under the Horizon 2020 framework programme for research and innovation from 2014 to 2020.

The file 'H2020 Projects' contains the public grant information for each project, including the following information: Record Control Number (RCN), project ID (grant agreement number), project acronym, project status, funding programme, topic, project title, project start date, project end date, project objective, project total cost, EC max contribution (commitment), call ID, funding scheme (type of action), coordinator, coordinator country, participants (ordered in a semi-colon separated list), participant countries (ordered in a semi-colon separated list).

In the individual XML files of the projects you'll find, in addition, their classification with the newly introduced EuroSciVoc taxonomy (fields of science) as well as links to related editorial articles such as news or Results in Brief.

The participating organisations are listed in the file 'H2020 Organisations' which includes: project Record Control Number (RCN), project ID, project acronym, organisation role, organisation ID, organisation name, organisation short name, organisation type, participation ended (true/false), EC contribution, organisation country.

The periodic or final report summaries (or publishable summaries) from the projects have been included since September 2018.

The lists of publications and deliverables from the projects have been included since May 2019.

Reference data (programmes topics, funding schemes (types of action), organisation types and countries) can be found in this dataset: https://data.europa.eu/euodp/en/data/dataset/cordisref-data

CORDIS datasets are produced monthly. Therefore, inconsistencies may occur between what is presented on the CORDIS live website and the datasets.

Acknowledgements

Official link: https://data.europa.eu/euodp/en/data/dataset/cordisH2020projects

Inspiration

Your data will be in front of the world's largest data science community. What questions do you want to see answered?

Tables

Cordis H2020organizations

@kaggle.hgultekin_eu_research_projects.cordis_h2020organizations

8.43 MB
135994 rows
24 columns


CREATE TABLE cordis_h2020organizations (
  "projectrcn" BIGINT,
  "projectid" BIGINT,
  "projectacronym" VARCHAR,
  "role" VARCHAR,
  "id" BIGINT,
  "name" VARCHAR,
  "shortname" VARCHAR,
  "activitytype" VARCHAR,
  "endofparticipation" BOOLEAN,
  "eccontribution" DOUBLE,
  "country" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "postcode" VARCHAR,
  "organizationurl" VARCHAR,
  "vatnumber" VARCHAR,
  "contactform" VARCHAR,
  "contacttype" VARCHAR,
  "contacttitle" VARCHAR,
  "contactfirstnames" VARCHAR,
  "contactlastnames" VARCHAR,
  "contactfunction" VARCHAR,
  "contacttelephonenumber" VARCHAR,
  "contactfaxnumber" VARCHAR
);

Cordis H2020projectdeliverables

@kaggle.hgultekin_eu_research_projects.cordis_h2020projectdeliverables

10.8 MB
72175 rows
10 columns


CREATE TABLE cordis_h2020projectdeliverables (
  "rcn" BIGINT,
  "title" VARCHAR,
  "projectid" BIGINT,
  "projectacronym" VARCHAR,
  "programme" VARCHAR,
  "topics" VARCHAR,
  "description" VARCHAR,
  "deliverabletype" VARCHAR,
  "url" VARCHAR,
  "lastupdatedate" TIMESTAMP
);

Cordis H2020projects

@kaggle.hgultekin_eu_research_projects.cordis_h2020projects

35.45 MB
30084 rows
21 columns


CREATE TABLE cordis_h2020projects (
  "rcn" BIGINT,
  "id" BIGINT,
  "acronym" VARCHAR,
  "status" VARCHAR,
  "programme" VARCHAR,
  "topics" VARCHAR,
  "frameworkprogramme" VARCHAR,
  "title" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "projecturl" VARCHAR,
  "objective" VARCHAR,
  "totalcost" DOUBLE,
  "ecmaxcontribution" BIGINT,
  "call" VARCHAR,
  "fundingscheme" VARCHAR,
  "coordinator" VARCHAR,
  "coordinatorcountry" VARCHAR,
  "participants" VARCHAR,
  "participantcountries" VARCHAR,
  "subjects" VARCHAR
);

Cordis H2020reports

@kaggle.hgultekin_eu_research_projects.cordis_h2020reports

57.3 MB
16469 rows
15 columns


CREATE TABLE cordis_h2020reports (
  "rcn" VARCHAR,
  "language" VARCHAR,
  "title" VARCHAR,
  "teaser" VARCHAR,
  "summary" VARCHAR,
  "workperformed" VARCHAR,
  "finalresults" VARCHAR,
  "lastupdatedate" VARCHAR,
  "country" VARCHAR,
  "projectid" VARCHAR,
  "projectacronym" VARCHAR,
  "programme" VARCHAR,
  "topics" VARCHAR,
  "relatedfile" VARCHAR,
  "url" VARCHAR
);