sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 5112 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
17842 Our World in Data based on BP Statistical Review of World Energy (2020) 
{
    "link": "http://www.bp.com/statisticalreview",
    "additionalInfo": "Raw data on energy consumption is sourced from the BP Statistical Review of World Energy. Available at: http://www.bp.com/statisticalreview\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 (source from the UN Population Division)",
    "dataPublishedBy": "BP Statistical Review of World Energy"
}
 2020-07-12 05:54:51 2020-07-12 05:54:51 Energy mix from BP (2020) 5112 Raw data on energy consumption is sourced from the BP Statistical Review of World Energy. Available at: http://www.bp.com/statisticalreview 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 (source from the UN Population Division) http://www.bp.com/statisticalreview BP Statistical Review of World Energy

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");