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 = 6128 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, updatedAt, createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
29201 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:43 2023-12-14 12:11:33 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 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)
29200 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\nThe 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:43 2023-12-14 12:11:33 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 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. 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)
29199 Energy Institute Statistical Review of World Energy (2023) 
{
    "link": "https://www.energyinst.org/statistical-review/",
    "retrievedDate": "2023-06-27",
    "additionalInfo": "The Reserves-to-Production (R/P) Ratio measures the number of years of fuel supplies left based on current annual consumption rates. Note that this can change through time through the discovery of new fuel reserves, and increases in annual consumption.\n\nThe 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:42 2023-12-14 12:11:31 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 The Reserves-to-Production (R/P) Ratio measures the number of years of fuel supplies left based on current annual consumption rates. Note that this can change through time through the discovery of new fuel reserves, and increases in annual consumption. 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)
28655 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-08-31 05:39:35 2023-12-14 12:11:33 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 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");