sources
Data license: CC-BY
1 row where datasetId = 3110 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
16245 | Global primary energy share (Smil & BP) | { "link": "http://vaclavsmil.com/2016/12/14/energy-transitions-global-and-national-perspectives-second-expanded-and-updated-edition/ ; http://www.bp.com/statisticalreview", "retrievedDate": "26th November 2018", "additionalInfo": "Global share of primary energy consumption by source, calculated by Our World in Data based on absolute energy consumption figures from Smil (2017) and BP Statistical Review of World Energy (2018).\n\nThis data comprises of a combination of data from Appendix A of Vaclav Smil's Updated and Revised Edition of his book, 'Energy Transitions: Global and National Perspectives' (2017). & BP Statistical Review of World Energy.\n\nAll data prior to the year 1965 is sourced from Smil (2017). All data from 1965 onwards, with the exception of traditional biomass is sourced from BP Statistical Review. Smil's estimates of traditional biomass have been used for the full series, with interpolation of annual changes by Our World in Data between reported 5-year increments by Smil. Traditional biomass for the years 2016 and 2017 have been estimated based on the approximate rate of change in the previous 5 years from Smil data.\n\nData represents primary energy (rather than final energy) consumption. 'Other renewables' represents all renewable sources minus solar, wind, and hydropower (e.g. geothermal, wave and tidal, and modern biofuels).\n", "dataPublishedBy": "Vaclav Smil (2017). Energy Transitions: Global and National Perspectives. & BP Statistical Review of World Energy." } |
2018-11-26 15:01:56 | 2018-11-26 15:01:56 | Global primary energy share (Smil & BP) 3110 | Global share of primary energy consumption by source, calculated by Our World in Data based on absolute energy consumption figures from Smil (2017) and BP Statistical Review of World Energy (2018). This data comprises of a combination of data from Appendix A of Vaclav Smil's Updated and Revised Edition of his book, 'Energy Transitions: Global and National Perspectives' (2017). & BP Statistical Review of World Energy. All data prior to the year 1965 is sourced from Smil (2017). All data from 1965 onwards, with the exception of traditional biomass is sourced from BP Statistical Review. Smil's estimates of traditional biomass have been used for the full series, with interpolation of annual changes by Our World in Data between reported 5-year increments by Smil. Traditional biomass for the years 2016 and 2017 have been estimated based on the approximate rate of change in the previous 5 years from Smil data. Data represents primary energy (rather than final energy) consumption. 'Other renewables' represents all renewable sources minus solar, wind, and hydropower (e.g. geothermal, wave and tidal, and modern biofuels). | http://vaclavsmil.com/2016/12/14/energy-transitions-global-and-national-perspectives-second-expanded-and-updated-edition/ ; http://www.bp.com/statisticalreview | Vaclav Smil (2017). Energy Transitions: Global and National Perspectives. & BP Statistical Review of World Energy. |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "sources" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(512) NULL , "description" TEXT NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");