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 ```