Data from European-funded projects retrieved from Funding and Tenders

Data on European-funded projects retrieved from the Funding and Tenders website on the following page: https://ec.europa.eu/info/funding-tenders/opportunities/portal/screen/opportunities/projects-results

The code allows you to use the site API to generate a file for all projects.

5 files are generated:
- projects.csv (most important): contains the list of all the projects of the site

# List of columns
'reference', 'url', 'title', 'summary', 'content', 'checksum', 'subTypeOfAction', 'typeOfAction', 'endDate', 'projectWebsite', 'objective', 'freeKeywords', 'subProgramme', 'topicAbbreviation', 'overallBudget', 'topicDescription','acronym', 'programmePeriod', 'programmes', 'euContributionRate', 'euContributionAmount', 'ecSignatureDate', 'topicId', 'programDescription', 'fundedUnder', 'programAbbreviation', 'projectId', 'programId', 'programId', 'startDate', 'status', 'destination', 'destinationGroup', 'programmeDivision', 'crossCuttingPriorities', 'mission'

• deliverables.csv: deliverables for each project

# List of columns
id, title, description, code, documentId, workPackageTitle, acceptedDate, sourceUpdateDate, deliverableLink, programId, projectId, reference, deliverableRef, number, name, nature, disseminationLevel, estimatedEffort, leadBeneficiaryPIC, dueDateInMonth, dueDate, wpiref

• participants.csv: participants for each project

# List of columns
role, pic, legalName, postalAddress.id, postalAddress.abbreviation, postalAddress.classId, postalAddress.context, postalAddress.description, postalAddress.postalCode, postalAddress.street, postalAddress.city, countryCode.id, countryCode.abbreviation, countryCode.classId, countryCode.context, countryCode.description, countryCode.postalCode, countryCode.street, countryCode.city, countryCode.countryCode, latitude, longitude, activityType, eucontribution, status, order, organizationType, type, sme, programId, projectId, reference, website, postalAddress.poBox, postalAddress.region, postalAddress.cedex

• publications.csv: publications of projects

# List of projects
id, title, doi, authors, journalTitle, journalNumber, publisher, publishedYear, publishedPages, issn, programId, projectId, reference

• summaries.csv: Project summaries

# List of columns
id, summary, paymentDate, workPerformed, finalResults, periodFrom, periodTo, sourceUpdateDate, programId, projectId, reference