sources
Data license: CC-BY
1 row where datasetId = 515 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 |
---|---|---|---|---|---|---|---|---|
651 | Energy Prices - BP Statistics (2016) | { "link": "http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html", "retrievedDate": "03/06/2017", "additionalInfo": "Prices corrected to 2015 US$ using the Consumer Price Index for the US\r\n\r\nPrices have been normalised to a commodity-specific index by the author where prices in 2000=100", "dataPublishedBy": "BP Statistical Review of World Energy 2016", "dataPublisherSource": null } |
2017-06-03 15:15:02 | 2017-11-20 15:17:22 | Energy Prices - BP Statistics (2016) 515 | Prices corrected to 2015 US$ using the Consumer Price Index for the US Prices have been normalised to a commodity-specific index by the author where prices in 2000=100 | http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html | BP Statistical Review of World Energy 2016 |
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");