CORDIS Reference Data
Publications Office of the European Union
@eupublicationsoffice.cordisref_data
Publications Office of the European Union
@eupublicationsoffice.cordisref_data
CREATE TABLE horizon_topics (
"id" VARCHAR,
"language" VARCHAR,
"code" VARCHAR,
"startdate" VARCHAR,
"enddate" VARCHAR,
"title" VARCHAR,
"shorttitle" VARCHAR,
"objective" VARCHAR,
"keywords" VARCHAR,
"frameworkprogramme" VARCHAR,
"parentprogramme" VARCHAR,
"legalbasis" VARCHAR,
"call" VARCHAR,
"contentupdatedate" TIMESTAMP,
"rcn" BIGINT
);
CREATE TABLE h2020_programmes (
"id" VARCHAR,
"language" VARCHAR,
"code" VARCHAR,
"startdate" TIMESTAMP,
"enddate" TIMESTAMP,
"title" VARCHAR,
"shorttitle" VARCHAR,
"objective" VARCHAR,
"keywords" VARCHAR,
"frameworkprogramme" VARCHAR,
"parentprogramme" VARCHAR,
"legalbasis" VARCHAR,
"call" VARCHAR,
"contentupdatedate" TIMESTAMP,
"rcn" BIGINT
);
CREATE TABLE horizon_programmes (
"id" VARCHAR,
"language" VARCHAR,
"code" VARCHAR,
"startdate" TIMESTAMP,
"enddate" TIMESTAMP,
"title" VARCHAR,
"shorttitle" VARCHAR,
"objective" VARCHAR,
"keywords" VARCHAR,
"frameworkprogramme" VARCHAR,
"parentprogramme" VARCHAR,
"legalbasis" VARCHAR,
"call" VARCHAR,
"contentupdatedate" TIMESTAMP,
"rcn" BIGINT
);
CREATE TABLE h2020_topics (
"id" VARCHAR,
"language" VARCHAR,
"code" VARCHAR,
"startdate" VARCHAR,
"enddate" VARCHAR,
"title" VARCHAR,
"shorttitle" VARCHAR,
"objective" VARCHAR,
"keywords" VARCHAR,
"frameworkprogramme" VARCHAR,
"parentprogramme" VARCHAR,
"legalbasis" VARCHAR,
"call" VARCHAR,
"contentupdatedate" TIMESTAMP,
"rcn" BIGINT
);
Anyone who has the link will be able to view this.