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 = 5158 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
17888 Fossil fuel production (BP & Shift (2020)) 
{
    "retrievedDate": "17th August 2020",
    "additionalInfo": "This dataset on fossil fuel production is produced by combining the latest data from the BP Statistical Review of World Energy and the Shift Project Data Portal.\n\nBP provide fossil fuel production data from 1965 onwards. The Shift Data Portal provides long-term data to 1900, but only extends to 2016.\n\nTo maintain consistency with the energy datasets on Our World in Data, we have taken BP data as preference \u2013 meaning if BP provides data for the given country and year, this is used. Where data is not available from BP for a given country, or pre-1965 we rely on the Shift Project.\n\nWe have converted primary production in exajoules to terawatt-hours using the conversion factor: 278.\n\nBP Statistical Review of World Energy: https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html\nShift Data Project: https://www.theshiftdataportal.org/energy\n\nProduction per capita has been calculated using population data from the UN World Population Prospects: https://population.un.org/wpp/.",
    "dataPublishedBy": "BP Statistical Review of World Energy; and SHIFT Data Portal"
}
 2020-08-17 19:56:38 2020-08-17 19:56:38 Fossil fuel production (BP & Shift (2020)) 5158 This dataset on fossil fuel production is produced by combining the latest data from the BP Statistical Review of World Energy and the Shift Project Data Portal. BP provide fossil fuel production data from 1965 onwards. The Shift Data Portal provides long-term data to 1900, but only extends to 2016. To maintain consistency with the energy datasets on Our World in Data, we have taken BP data as preference – meaning if BP provides data for the given country and year, this is used. Where data is not available from BP for a given country, or pre-1965 we rely on the Shift Project. We have converted primary production in exajoules to terawatt-hours using the conversion factor: 278. BP Statistical Review of World Energy: https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html Shift Data Project: https://www.theshiftdataportal.org/energy Production per capita has been calculated using population data from the UN World Population Prospects: https://population.un.org/wpp/.   BP Statistical Review of World Energy; and SHIFT Data Portal

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