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 = 5156 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
17886 Our World in Data based on BP; Shift Energy; UN Population & Maddison Database 
{
    "retrievedDate": "15th August 2020",
    "additionalInfo": "Primary energy consumption data was compiled by Our World in Data based on two key data sources: \n1. BP Statistical Review of World Energy: https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html\n2. Shift Energy Data Portal: https://www.theshiftdataportal.org/energy\n\nBP provides the longest and most up-to-date time-series of primary energy. However, it does provide data for all countries. We have therefore supplemented this dataset with energy data from the Shift Energy Data Portal. Where BP provides data for a given country, this data is adopted; for countries where this data is missing, we rely on Shift Energy figures.\n\nThe Shift Project draws on two sources: \n\u2013 Etemad & Luciani for the period 1900-1980 Bouda Etemad and Jean Luciani, World Energy Production 1900 \u2013 1985, ISBN 2-600-56007-6, Data digitalized and published with agreement of B. Etemad\n\u2013 US EIA Historical Statistics for 1980-2016. U.S. Energy Information Administration\n\nTo convert from total primary energy to per capita figures we use population figures from the UN World Population Prospects: https://population.un.org/wpp/.\n\nTo calculate energy per unit of GDP, we use total real GDP figures from the Maddison Project Database (2018): http://www.ggdc.net/maddison/oriindex.htm. This is measured in 2011$ which are PPP-adjusted.\n\n",
    "dataPublishedBy": "BP Statistical Review of World Energy; Shift Project; Maddison Project Database; UN Population Prospects"
}
 2020-08-15 13:01:26 2020-08-15 13:01:26 Primary energy consumption (BP & Shift, 2020) 5156 Primary energy consumption data was compiled by Our World in Data based on two key data sources: 1. BP Statistical Review of World Energy: https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html 2. Shift Energy Data Portal: https://www.theshiftdataportal.org/energy BP provides the longest and most up-to-date time-series of primary energy. However, it does provide data for all countries. We have therefore supplemented this dataset with energy data from the Shift Energy Data Portal. Where BP provides data for a given country, this data is adopted; for countries where this data is missing, we rely on Shift Energy figures. The Shift Project draws on two sources: – Etemad & Luciani for the period 1900-1980 Bouda Etemad and Jean Luciani, World Energy Production 1900 – 1985, ISBN 2-600-56007-6, Data digitalized and published with agreement of B. Etemad – US EIA Historical Statistics for 1980-2016. U.S. Energy Information Administration To convert from total primary energy to per capita figures we use population figures from the UN World Population Prospects: https://population.un.org/wpp/. To calculate energy per unit of GDP, we use total real GDP figures from the Maddison Project Database (2018): http://www.ggdc.net/maddison/oriindex.htm. This is measured in 2011$ which are PPP-adjusted.   BP Statistical Review of World Energy; Shift Project; Maddison Project Database; UN Population Prospects

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