CORDIS - EU Research Projects Under FP6 (2002-2006)
Publications Office of the European Union
@eupublicationsoffice.cordisfp6projects
Publications Office of the European Union
@eupublicationsoffice.cordisfp6projects
CREATE TABLE fp6_projects (
"projectid" VARCHAR,
"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" BIGINT,
"order" VARCHAR,
"role" VARCHAR,
"eccontribution" DOUBLE,
"neteccontribution" VARCHAR,
"totalcost" VARCHAR,
"endofparticipation" VARCHAR,
"active" VARCHAR
);
CREATE TABLE fp6_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.