sources
Data license: CC-BY
1 row where datasetId = 5570 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 |
|---|---|---|---|---|---|---|---|---|
| 21961 | Our World in Data based on BP Statistical Review of World Energy (2021) | {
"link": "https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html",
"retrievedDate": "31st March 2022",
"additionalInfo": "Raw data on energy consumption is sourced from the BP Statistical Review of World Energy. Available at: https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html\n\nPrimary energy in exajoules (EJ) has been converted to TWh by Our World in Data based on a conversion factor of 277.778.\n\nEach source's share of energy based on the \"substitution method\" were calculated by Our World in Data by taking all energy sources' energy normalised to EJ \u2013 this takes account of the inefficiencies in fossil fuel production and is a better approximation of \"final energy\" consumption.\n\nAdditional metrics have been calculated by Our World in Data:\n\u2013 Annual change in energy consumption by source: this is calculated as the difference from the previous year\n\u2013 % of total primary energy: calculated as each source's share of primary energy from all sources\n\u2013 Per capita energy by source: calculated as primary energy consumption by source, divided by population.\n\nPer capita figures have been calculated using a population dataset that is built and maintained by Our World in Data, based on different sources:\nhttps://ourworldindata.org/population-sources",
"dataPublishedBy": "BP Statistical Review of World Energy"
} |
2022-03-31 15:05:11 | 2022-03-31 15:05:11 | Energy mix from BP (2021) 5570 | Raw data on energy consumption is sourced from the BP Statistical Review of World Energy. Available at: https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html Primary energy in exajoules (EJ) has been converted to TWh by Our World in Data based on a conversion factor of 277.778. Each source's share of energy based on the "substitution method" were calculated by Our World in Data by taking all energy sources' energy normalised to EJ – this takes account of the inefficiencies in fossil fuel production and is a better approximation of "final energy" consumption. Additional metrics have been calculated by Our World in Data: – Annual change in energy consumption by source: this is calculated as the difference from the previous year – % of total primary energy: calculated as each source's share of primary energy from all sources – Per capita energy by source: calculated as primary energy consumption by source, divided by population. Per capita figures have been calculated using a population dataset that is built and maintained by Our World in Data, based on different sources: https://ourworldindata.org/population-sources | https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html | 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");