sources
Data license: CC-BY
1 row where datasetId = 502 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 |
---|---|---|---|---|---|---|---|---|
638 | Vaclav Smil (2017) & BP Statistical Review of World Energy | { "link": "http://vaclavsmil.com/2016/12/14/energy-transitions-global-and-national-perspectives-second-expanded-and-updated-edition/ ; https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html", "retrievedDate": "10th August 2020", "additionalInfo": "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.\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 are only available until 2015. For the years 2016 onwards, we have assumed a similar level of traditional biomass consumption. This is approximately in line with recent trends in traditional biomass from Smil's data.\n\nOur World in Data has normalised all BP fossil fuels data to terawatt-hours (TWh) using a conversion factor of 277.778 to convert from exajoules (EJ) to TWh.\n\nThis dataset includes primary energy data using two methodologies.\n(1) 'direct' primary energy, which does not take account of the inefficiencies in fossil fuel production. Fossil fuel data in its input equivalents (in exajoules) is compared to electricity generation (not in input equivalents) of nuclear and renewables.\n\n(2) 'substitution' primary energy, which does take account of inefficiencies in fossil fuel production. This converts non-fossil energy to their 'input equivalents' \u2013 the amount of primary energy that would be needed if they had the same inefficiencies as fossil fuels. This is the methodology adopted in the BP statistics when all data is compared in exajoules. \n\n\n\n", "dataPublishedBy": "Vaclav Smil (2017). Energy Transitions: Global and National Perspectives. & BP Statistical Review of World Energy.", "dataPublisherSource": null } |
2017-06-01 12:55:51 | 2018-05-24 09:33:37 | Global Primary Energy Consumption - Vaclav Smil (2017) & BP Statistics (2020) 502 | 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 are only available until 2015. For the years 2016 onwards, we have assumed a similar level of traditional biomass consumption. This is approximately in line with recent trends in traditional biomass from Smil's data. Our World in Data has normalised all BP fossil fuels data to terawatt-hours (TWh) using a conversion factor of 277.778 to convert from exajoules (EJ) to TWh. This dataset includes primary energy data using two methodologies. (1) 'direct' primary energy, which does not take account of the inefficiencies in fossil fuel production. Fossil fuel data in its input equivalents (in exajoules) is compared to electricity generation (not in input equivalents) of nuclear and renewables. (2) 'substitution' primary energy, which does take account of inefficiencies in fossil fuel production. This converts non-fossil energy to their 'input equivalents' – the amount of primary energy that would be needed if they had the same inefficiencies as fossil fuels. This is the methodology adopted in the BP statistics when all data is compared in exajoules. | http://vaclavsmil.com/2016/12/14/energy-transitions-global-and-national-perspectives-second-expanded-and-updated-edition/ ; https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html | 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");