CORDIS - EU Research Projects Under Horizon 2020 (2014-2020)
Publications Office of the European Union
@eupublicationsoffice.cordish2020projects
Publications Office of the European Union
@eupublicationsoffice.cordish2020projects
CREATE TABLE h2020_project_publications (
"id" VARCHAR,
"title" VARCHAR,
"ispublishedas" VARCHAR,
"authors" VARCHAR,
"journaltitle" VARCHAR,
"journalnumber" VARCHAR,
"publishedyear" DOUBLE,
"publishedpages" VARCHAR,
"issn" VARCHAR,
"isbn" VARCHAR,
"doi" VARCHAR,
"projectid" BIGINT,
"projectacronym" VARCHAR,
"collection" VARCHAR,
"contentupdatedate" TIMESTAMP,
"rcn" BIGINT
);
CREATE TABLE h2020_project_deliverables (
"id" VARCHAR,
"title" VARCHAR,
"deliverabletype" VARCHAR,
"description" VARCHAR,
"projectid" BIGINT,
"projectacronym" VARCHAR,
"url" VARCHAR,
"collection" VARCHAR,
"contentupdatedate" TIMESTAMP,
"rcn" BIGINT
);
CREATE TABLE h2020_projects (
"id" BIGINT,
"acronym" VARCHAR,
"status" VARCHAR,
"title" VARCHAR,
"startdate" TIMESTAMP,
"enddate" TIMESTAMP,
"totalcost" BIGINT,
"ecmaxcontribution" BIGINT,
"legalbasis" VARCHAR,
"topics" VARCHAR,
"ecsignaturedate" TIMESTAMP,
"frameworkprogramme" VARCHAR,
"mastercall" VARCHAR,
"subcall" VARCHAR,
"fundingscheme" VARCHAR,
"nature" VARCHAR,
"objective" VARCHAR,
"contentupdatedate" TIMESTAMP,
"rcn" BIGINT,
"grantdoi" VARCHAR
);
CREATE TABLE h2020_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.