Gateway to Research dataset

Gateway to Research dataset

Gateway to Research (GtR) is the UKRI portal onto publicly funded research.

We're collecting an updated data snapshot every week.

Data tables

To import the data tables, initialise the GtR data getter class

from getters import gtr

Gtr = gtr.GtrGetter()

Below we provide simple schemas, ie column names and descriptions. Note that some columns contain no information (likely an API artefact) but their names are kept for the sake of completeness.

Projects

Gtr.projects

Information about 150,000+ projects funded by the UKRI (as of autumn 2024).

Column	Description
links	Links to other GtR data tables
ext
id	Unique database entry id
outcomeid
href	API link
created	Timestamp indicating when the record was created
updated
identifiers	Project reference numbers (can be more than one)
title	Title the project
status	Current status of the project: 'Active' or 'Closed'
grantCategory	Type of grant, such as 'Research Grant', 'Studentship', 'Collaborative R&D' and others
leadFunder	Lead funding organisation, usually a research council or Innovate UK
leadOrganisationDepartment	Department in the funded organisation leading the project
abstractText	Description of the project
techAbstractText	Technical description of the project (if available)
potentialImpact	Statement describing the potential impact of the project or research (if available)
healthCategories
researchActivities
researchSubjects	Research categories
researchTopics	Research categories (unclear what's the difference with researchActivities
rcukProgrammes
start
end
participantValues	Organisations participating in the project (if available)

Funds

Information about project funding

Column	Description
links	Links to other GtR data tables
ext
id	Unique database entry id
outcomeid
href	API link
created	Timestamp indicating when the record was created
updated
start	Timestamp when the funding period started
end	Timestamp when the funding period ended
valuePounds	Amount of funding
category	Funding category, can be one of three values: INCOME_ACTUAL, EXPENDITURE_ACTUAL and SUPPLEMENTARY_UNIT_AWARDS. Most of the entires are INCOME_ACTUAL
type

Organisations

Column	Description
links	Links to other GtR data tables such as projects or persons
ext
id	Unique database entry id
outcomeid
href	API link
created	Timestamp indicating when the record was created
updated
name	Name of the organisation
regNumber
website
addresses	Address of the organisation (if available)

Persons

Column	Description
links	Links to other GtR data tables such as projects and organisations
ext
id	Unique database entry id
outcomeid
href	API link
created	Timestamp indicating when the record was created
updated
firstName	First name
otherNames	Other names
surname	Last name
email
orcidId	ORCID if available