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

4 rows where datasetId = 6117 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, additionalInfo, dataPublishedBy, createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
29196 Energy Institute Statistical Review of World Energy based on S&P Global Platts (2023) 
{
    "link": "https://www.energyinst.org/statistical-review/",
    "retrievedDate": "2023-06-27",
    "additionalInfo": "The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year.\n",
    "dataPublishedBy": "Energy Institute Statistical Review of World Energy based on S&P Global Platts (2023)"
}
 2023-11-07 09:43:23 2023-12-14 12:09:34 Energy Institute Statistical Review of World Energy (2023) 6117 The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year. https://www.energyinst.org/statistical-review/ Energy Institute Statistical Review of World Energy based on S&P Global Platts (2023)
29195 Energy Institute Statistical Review of World Energy (2023) 
{
    "link": "https://www.energyinst.org/statistical-review/",
    "retrievedDate": "2023-06-27",
    "additionalInfo": "The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year.\n\nThe Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year. Previously produced by BP, the Review has been providing timely, comprehensive and objective data to the energy community since 1952.\n",
    "dataPublishedBy": "Energy Institute Statistical Review of World Energy (2023)"
}
 2023-11-07 09:43:07 2023-12-14 12:09:29 Energy Institute Statistical Review of World Energy (2023) 6117 The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year. The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year. Previously produced by BP, the Review has been providing timely, comprehensive and objective data to the energy community since 1952. https://www.energyinst.org/statistical-review/ Energy Institute Statistical Review of World Energy (2023)
29194 Energy Institute Statistical Review of World Energy (2023) 
{
    "link": "https://www.energyinst.org/statistical-review/",
    "retrievedDate": "2023-06-27",
    "additionalInfo": "The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year.\n",
    "dataPublishedBy": "Energy Institute Statistical Review of World Energy (2023)"
}
 2023-11-07 09:43:03 2023-12-14 12:09:17 Energy Institute Statistical Review of World Energy (2023) 6117 The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year. https://www.energyinst.org/statistical-review/ Energy Institute Statistical Review of World Energy (2023)
27911 Energy Institute Statistical Review of World Energy (2023) 
{
    "link": "https://www.energyinst.org/statistical-review/",
    "retrievedDate": "2023-06-28",
    "additionalInfo": "The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year. Previously produced by BP, the Review has been providing timely, comprehensive and objective data to the energy community since 1952.\n",
    "dataPublishedBy": "Energy Institute Statistical Review of World Energy (2023)"
}
 2023-07-06 13:22:25 2023-12-14 12:09:27 Energy Institute Statistical Review of World Energy (2023) 6117 The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year. Previously produced by BP, the Review has been providing timely, comprehensive and objective data to the energy community since 1952. https://www.energyinst.org/statistical-review/ Energy Institute Statistical Review of World Energy (2023)

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