About this Dataset

CORDIS - EU Research Projects Under FP7 (2007-2013)

This dataset contains projects funded by the European Union under the seventh framework programme for Research and technological development (FP7) from 2007 to 2013. The file 'FP7 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 'FP7 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 October 2018. Reference data (countries, funding schemes/types of action, subjects (SIC codes)) can be found in this dataset: https://data.europa.eu/euodp/en/data/dataset/cordisref-data EURIO Knowledge graph data from CORDIS in the form of named graphs can be found in this dataset: https://data.europa.eu/data/datasets/named-graphs-from-eurio-knowledge-graph?locale=en
Publisher name: Publications Office of the European Union
Publisher URL: https://op.europa.eu
Last updated: 2025-04-11T07:18:35Z

Tables

FP7 Project IPRs

@eupublicationsoffice.cordisfp7projects.fp7_project_iprs

761.03 kB
5,293 rows
18 columns

CREATE TABLE fp7_project_iprs (
  "projectid" DOUBLE,
  "type" VARCHAR,
  "title" VARCHAR,
  "organisationid" DOUBLE,
  "applicantname" VARCHAR,
  "applicationdate" TIMESTAMP,
  "applicationprefix" VARCHAR,
  "applicationidentifier" VARCHAR,
  "applicationkind" VARCHAR,
  "epoappurl" VARCHAR,
  "prioritydate" TIMESTAMP,
  "patenttype" VARCHAR,
  "awarddate" TIMESTAMP,
  "awardprefix" VARCHAR,
  "awardidentifier" VARCHAR,
  "awardkind" VARCHAR,
  "epopuburl" VARCHAR,
  "patentfamilyidentifier" DOUBLE
);

FP7 Projects

@eupublicationsoffice.cordisfp7projects.fp7_projects

10.47 MB
140,064 rows
25 columns

CREATE TABLE fp7_projects (
  "projectid" BIGINT,
  "projectacronym" VARCHAR,
  "organisationid" DOUBLE,
  "vatnumber" VARCHAR,
  "name" VARCHAR,
  "shortname" VARCHAR,
  "sme" VARCHAR,
  "activitytype" VARCHAR,
  "street" VARCHAR,
  "postcode" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "nutscode" VARCHAR,
  "geolocation" VARCHAR,
  "organizationurl" VARCHAR,
  "contactform" VARCHAR,
  "contentupdatedate" VARCHAR,
  "rcn" VARCHAR,
  "order" VARCHAR,
  "role" VARCHAR,
  "eccontribution" VARCHAR,
  "neteccontribution" VARCHAR,
  "totalcost" VARCHAR,
  "endofparticipation" VARCHAR,
  "active" VARCHAR
);

FP7 Publications

@eupublicationsoffice.cordisfp7projects.fp7_publications

70.35 MB
306,032 rows
41 columns

CREATE TABLE fp7_publications (
  "n_115001_identification_of_dlk1_dio3_imprinted_gene_cl_90de27db" VARCHAR  -- 115001;"Identification Of Dlk1-Dio3 Imprinted Gene Cluster Noncoding RNAs As Novel Candidate Biomarkers For Liver Tumor Promotion";"Lempiainen,
  "n__harri_couttet" VARCHAR  -- Harri; Couttet,
  "n__philippe_bolognani" VARCHAR  -- Philippe; Bolognani,
  "n__federico_mueller" VARCHAR  -- Federico; Mueller,
  "n__arne_dubost" VARCHAR  -- Arne; Dubost,
  "n__valerie_luisier" VARCHAR  -- Valerie; Luisier,
  "n__raphaelle_espinola" VARCHAR  -- Raphaelle; Espinola,
  "n__alberto_del_rio_vitry" VARCHAR  -- Alberto Del Rio; Vitry,
  "n__veronique_unterberger" VARCHAR  -- Veronique; Unterberger,
  "n__elif_b_thomson" VARCHAR  -- Elif B.; Thomson,
  "n__john_p_treindl" VARCHAR  -- John P.; Treindl,
  "n__fridolin_metzger" VARCHAR  -- Fridolin; Metzger,
  "n__ute_wrzodek" VARCHAR  -- Ute; Wrzodek,
  "n__clemens_hahne" VARCHAR  -- Clemens; Hahne,
  "n__florian_zollinger" VARCHAR  -- Florian; Zollinger,
  "n__tulipan_brasa" VARCHAR  -- Tulipan; Brasa,
  "n__sarah_kalteis" VARCHAR  -- Sarah; Kalteis,
  "n__magdalena_marcellin" VARCHAR  -- Magdalena; Marcellin,
  "n__magali_giudicelli" VARCHAR  -- Magali; Giudicelli,
  "n__fanny_braeuning" VARCHAR  -- Fanny; Braeuning,
  "n__albert_morawiec" VARCHAR  -- Albert; Morawiec,
  "n__laurent_zamurovic" VARCHAR  -- Laurent; Zamurovic,
  "n__natasa_laengle" VARCHAR  -- Natasa; Laengle,
  "n__ulrich_scheer" VARCHAR  -- Ulrich; Scheer,
  "n__nico_schuebeler" VARCHAR  -- Nico; Schuebeler,
  "n__dirk_goodman" VARCHAR  -- Dirk; Goodman,
  "n__jay_chibout" VARCHAR  -- Jay; Chibout,
  "n__salah_dine_marlowe" VARCHAR  -- Salah-Dine; Marlowe,
  "n__jennifer_theil" VARCHAR  -- Jennifer; Theil,
  "n__diethilde_heard" VARCHAR  -- Diethilde; Heard,
  "n__david_j_grenet" VARCHAR  -- David J.; Grenet,
  "n__olivier_zell" VARCHAR  -- Olivier; Zell,
  "n__andreas_templin" VARCHAR  -- Andreas; Templin,
  "n__markus_f_meehan" VARCHAR  -- Markus F.; Meehan,
  "n__richard_r_wolf" VARCHAR  -- Richard R.; Wolf,
  "n__roland_c_elcombe" VARCHAR  -- Roland C.; Elcombe,
  "n__clifford_r_schwarz" VARCHAR  -- Clifford R.; Schwarz,
  "n__michael_moulin" VARCHAR  -- Michael; Moulin,
  "n__pierre_terranova" VARCHAR  -- Pierre; Terranova,
  "n__remi_moggs" VARCHAR  -- Remi; Moggs,
  "n__jonathan_g_10_1093_toxsci_kfs303_article_toxicologi_ec1eaecd" VARCHAR  -- Jonathan G.";"10.1093/toxsci/kfs303";"ARTICLE";"";"TOXICOLOGICAL SCIENCES";"";"131";"375-386";"10.1093/toxsci/kfs303";4764DDFEB06BE7CEBD43CFDD46AE85B4FEB7626E
);

FP7 Report Summaries

@eupublicationsoffice.cordisfp7projects.fp7_report_summaries

2.59 MB
21,605 rows
7 columns

CREATE TABLE fp7_report_summaries (
  "id" VARCHAR,
  "title" VARCHAR,
  "projectid" BIGINT,
  "projectacronym" VARCHAR,
  "attachment" VARCHAR,
  "contentupdatedate" TIMESTAMP,
  "rcn" BIGINT
);