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 = 653 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
2803 Crude Oil Consumption vs. Price - BP Statistics (2016) 
{
    "link": "https://www.bp.com/content/dam/bp/pdf/energy-economics/statistical-review-2016/bp-statistical-review-of-world-energy-2016-full-report.pdf",
    "retrievedDate": "31/07/2017",
    "additionalInfo": "Oil consumption data is based on reported global daily consumption. This includes crude oil, shale oil, oil sands and Natural Gas Liquids (the gas component of which is treated separately and not included).\n\nOil prices are based on average crude oil prices as the Arabian Light series from 1965-1983 and Brent dated series from 1984-2015. This is reported in 2015 US$ per cubic meter (deflated by BP Energy Review using the Consumer Price Index for the US).\n\nTo convert from barrels to cubic meters, we use a factor of 0.159, following BP's definitions.",
    "dataPublishedBy": "BP Statistical Review of World Energy 2016",
    "dataPublisherSource": "BP Statistical Review"
}
 2017-07-31 10:48:21 2017-11-23 10:57:35 Crude Oil Consumption vs. Price - BP Statistics (2016) 653 Oil consumption data is based on reported global daily consumption. This includes crude oil, shale oil, oil sands and Natural Gas Liquids (the gas component of which is treated separately and not included). Oil prices are based on average crude oil prices as the Arabian Light series from 1965-1983 and Brent dated series from 1984-2015. This is reported in 2015 US$ per cubic meter (deflated by BP Energy Review using the Consumer Price Index for the US). To convert from barrels to cubic meters, we use a factor of 0.159, following BP's definitions. https://www.bp.com/content/dam/bp/pdf/energy-economics/statistical-review-2016/bp-statistical-review-of-world-energy-2016-full-report.pdf BP Statistical Review of World Energy 2016

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