CORDIS - EU Research Projects Under FP7 (2007-2013)
Publications Office of the European Union
@eupublicationsoffice.cordisfp7projects
Publications Office of the European Union
@eupublicationsoffice.cordisfp7projects
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
);
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
);
CREATE TABLE fp7_publications (
"n_115001_identification_of_dlk1_dio3_imprinted_gene_cl_90de27db" VARCHAR,
"n__harri_couttet" VARCHAR,
"n__philippe_bolognani" VARCHAR,
"n__federico_mueller" VARCHAR,
"n__arne_dubost" VARCHAR,
"n__valerie_luisier" VARCHAR,
"n__raphaelle_espinola" VARCHAR,
"n__alberto_del_rio_vitry" VARCHAR,
"n__veronique_unterberger" VARCHAR,
"n__elif_b_thomson" VARCHAR,
"n__john_p_treindl" VARCHAR,
"n__fridolin_metzger" VARCHAR,
"n__ute_wrzodek" VARCHAR,
"n__clemens_hahne" VARCHAR,
"n__florian_zollinger" VARCHAR,
"n__tulipan_brasa" VARCHAR,
"n__sarah_kalteis" VARCHAR,
"n__magdalena_marcellin" VARCHAR,
"n__magali_giudicelli" VARCHAR,
"n__fanny_braeuning" VARCHAR,
"n__albert_morawiec" VARCHAR,
"n__laurent_zamurovic" VARCHAR,
"n__natasa_laengle" VARCHAR,
"n__ulrich_scheer" VARCHAR,
"n__nico_schuebeler" VARCHAR,
"n__dirk_goodman" VARCHAR,
"n__jay_chibout" VARCHAR,
"n__salah_dine_marlowe" VARCHAR,
"n__jennifer_theil" VARCHAR,
"n__diethilde_heard" VARCHAR,
"n__david_j_grenet" VARCHAR,
"n__olivier_zell" VARCHAR,
"n__andreas_templin" VARCHAR,
"n__markus_f_meehan" VARCHAR,
"n__richard_r_wolf" VARCHAR,
"n__roland_c_elcombe" VARCHAR,
"n__clifford_r_schwarz" VARCHAR,
"n__michael_moulin" VARCHAR,
"n__pierre_terranova" VARCHAR,
"n__remi_moggs" VARCHAR,
"n__jonathan_g_10_1093_toxsci_kfs303_article_toxicologi_ec1eaecd" VARCHAR
);
CREATE TABLE fp7_report_summaries (
"id" VARCHAR,
"title" VARCHAR,
"projectid" BIGINT,
"projectacronym" VARCHAR,
"attachment" VARCHAR,
"contentupdatedate" TIMESTAMP,
"rcn" BIGINT
);
Anyone who has the link will be able to view this.