osamede20
commented
1 year ago Updated dataset has been transformed.
The updated SPARQL query and Chart are on the Mitigation dashboard and titled: Public energy research, development and demonstration (RD&D) spending, UK, 2011 to 2021, £million (nominal prices)
The SPARQL query is given as:
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX energy_sector: <https://gss-cogs.github.io/provider-beis/out/IEA-Energy-RD-D-Spend/iea-energy-rd-d-spend/energy-technology-rd-d-budgets.csv#dimension/energy-sector>
PREFIX country: <https://gss-cogs.github.io/provider-beis/out/IEA-Energy-RD-D-Spend/iea-energy-rd-d-spend/energy-technology-rd-d-budgets.csv#dimension/country>
PREFIX year: <https://gss-cogs.github.io/provider-beis/out/IEA-Energy-RD-D-Spend/iea-energy-rd-d-spend/energy-technology-rd-d-budgets.csv#dimension/year>
PREFIX national_currency_2021_prices: <https://gss-cogs.github.io/provider-beis/out/IEA-Energy-RD-D-Spend/iea-energy-rd-d-spend/energy-technology-rd-d-budgets.csv#measure/national-currency-nominal>
SELECT ?energy_sector ?country ?year ?national_currency_nominal
WHERE
{
?row a qb:Observation;
energy_sector: /rdfs:label ?energy_sector;
country: /rdfs:label ?country;
year: /rdfs:label ?year;
national_currency_2021_prices: ?national_currency_nominal
FILTER (?energy_sector!="Total Budget")
}
ORDER BY ASC(?year) ?energy_sector
Data refresh (DS team?) Updated SPARQL (DS team?) Update Chart title, narrative and notes