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 = 651 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
2801 Hubbert's Peak - Cavallo and EIA 
{
    "link": "https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=pet&s=mcrfpus1&f=a",
    "retrievedDate": null,
    "additionalInfo": "Data on actual US oil production is based on reported historical figures from the US Energy Information Administration (EIA). This has been plotted based on its dataset on annual 'US Field Production of Crude Oil'. Available online at: https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=pet&s=mcrfpus1&f=a [accessed 30th July 2017].\r\n\r\nData on Hubbert's hypothesised peak oil production in the US is based on distribution analysis discussed and reported in: Cavallo, A. J. (2004). Hubbert\u2019s petroleum production model: an evaluation and implications for world oil production forecasts. Natural Resources Research, 13(4), 211-221.",
    "dataPublishedBy": "EIA",
    "dataPublisherSource": "Historical figures, census data."
}
 2017-07-30 16:09:38 2017-11-23 11:02:26 Hubbert's Peak - Cavallo & EIA 651 Data on actual US oil production is based on reported historical figures from the US Energy Information Administration (EIA). This has been plotted based on its dataset on annual 'US Field Production of Crude Oil'. Available online at: https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=pet&s=mcrfpus1&f=a [accessed 30th July 2017]. Data on Hubbert's hypothesised peak oil production in the US is based on distribution analysis discussed and reported in: Cavallo, A. J. (2004). Hubbert’s petroleum production model: an evaluation and implications for world oil production forecasts. Natural Resources Research, 13(4), 211-221. https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=pet&s=mcrfpus1&f=a EIA

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