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 = 951 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
6810 UK DECC & Department for Business, Energy & Industrial Strategy (BEIS). 
{
    "link": "https://www.gov.uk/government/statistical-data-sets/historical-coal-data-coal-production-availability-and-consumption",
    "retrievedDate": "17th August 2020",
    "additionalInfo": "Data originally published by the UK's Department for Energy and Climate Change (DECC) in 2013. Updated in 2018 by the UK's Department for Business, Energy & Industrial Strategy (BEIS).\n\nEmployment figures in the coal industry include contractors, and are sourced by DECC from The Coal Authority.\n\nCoal production per worker was calculated by dividing total UK coal output by the number employed in any given year.\n\nThe share of the total workforce employed in the coal industry was calculated by dividing by total UK workforce figures available in 'A millennium of macroeconomic data' by the Bank of England. Available at: http://www.bankofengland.co.uk/research/Pages/datasets/default.aspx [accessed 5th October 2017].",
    "dataPublishedBy": "Department for Business, Energy & Industrial Strategy (BEIS)",
    "dataPublisherSource": null
}
 2017-10-05 16:31:17 2017-11-20 18:32:24 Coal output and employment in UK - BEIS (2020) 951 Data originally published by the UK's Department for Energy and Climate Change (DECC) in 2013. Updated in 2018 by the UK's Department for Business, Energy & Industrial Strategy (BEIS). Employment figures in the coal industry include contractors, and are sourced by DECC from The Coal Authority. Coal production per worker was calculated by dividing total UK coal output by the number employed in any given year. The share of the total workforce employed in the coal industry was calculated by dividing by total UK workforce figures available in 'A millennium of macroeconomic data' by the Bank of England. Available at: http://www.bankofengland.co.uk/research/Pages/datasets/default.aspx [accessed 5th October 2017]. https://www.gov.uk/government/statistical-data-sets/historical-coal-data-coal-production-availability-and-consumption Department for Business, Energy & Industrial Strategy (BEIS)

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