CORDIS - EU Research Projects Under HORIZON EUROPE (2021-2027)
Publications Office of the European Union
@eupublicationsoffice.cordis_eu_research_projects_under_horizon_europe_2021_2027
Publications Office of the European Union
@eupublicationsoffice.cordis_eu_research_projects_under_horizon_europe_2021_2027
CREATE TABLE horizon_projects (
"projectid" BIGINT,
"projectacronym" VARCHAR,
"organisationid" BIGINT,
"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" TIMESTAMP,
"rcn" BIGINT,
"order" DOUBLE,
"role" VARCHAR,
"eccontribution" DOUBLE,
"neteccontribution" DOUBLE,
"totalcost" DOUBLE,
"endofparticipation" BOOLEAN,
"active" VARCHAR
);
CREATE TABLE horizon_projects_deliverables (
"id" VARCHAR,
"title" VARCHAR,
"deliverabletype" VARCHAR,
"description" VARCHAR,
"projectid" BIGINT,
"projectacronym" VARCHAR,
"url" VARCHAR,
"collection" VARCHAR,
"contentupdatedate" TIMESTAMP,
"rcn" BIGINT
);
CREATE TABLE horizon_publications (
"id" VARCHAR,
"title" VARCHAR,
"ispublishedas" VARCHAR,
"authors" VARCHAR,
"journaltitle" VARCHAR,
"journalnumber" VARCHAR,
"publishedyear" DOUBLE,
"publishedpages" VARCHAR,
"issn" VARCHAR,
"isbn" VARCHAR,
"doi" VARCHAR,
"projectid" VARCHAR,
"projectacronym" VARCHAR,
"collection" VARCHAR,
"contentupdatedate" VARCHAR,
"rcn" DOUBLE
);
CREATE TABLE horizon_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.