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 = 4887 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
17618 Deaths per TWh from low-carbon energy (Sovacool et al., 2016) 
{
    "link": "https://www.sciencedirect.com/science/article/pii/S0959652615009877",
    "retrievedDate": "6th January 2020",
    "additionalInfo": "Number of deaths attributed to energy-related accidents of low-carbon energy sources, measured as the number of deaths per terawatt-hour of production.\n\nSovacool et al. (2016) developed a database of energy-related accidents over the period from 1950 to 2014. They define an accident as: \"an unintentional incident or event at an energy facility that led to either one death (or more) or at least $50,000 in property damage.\"\n\nThis database was developed based on a series of academic databases (including ScienceDirect and EBSCO host) as well as the internet (using Google and Safari).\n\nThe normalized death rate data is presented by Sovacool et al. (2016) as the number of deaths per TWh over the period from 1990 to 2013.",
    "dataPublishedBy": "Sovacool, B. K., Andersen, R., Sorensen, S., Sorensen, K., Tienda, V., Vainorius, A., ... & Bj\u00f8rn-Thygesen, F. (2016). Balancing safety with sustainability: assessing the risk of accidents for modern low-carbon energy systems. Journal of cleaner production, 112, 3952-3965."
}
 2020-01-06 12:22:50 2020-01-06 12:22:50 Deaths per TWh from low-carbon energy (Sovacool et al., 2016) 4887 Number of deaths attributed to energy-related accidents of low-carbon energy sources, measured as the number of deaths per terawatt-hour of production. Sovacool et al. (2016) developed a database of energy-related accidents over the period from 1950 to 2014. They define an accident as: "an unintentional incident or event at an energy facility that led to either one death (or more) or at least $50,000 in property damage." This database was developed based on a series of academic databases (including ScienceDirect and EBSCO host) as well as the internet (using Google and Safari). The normalized death rate data is presented by Sovacool et al. (2016) as the number of deaths per TWh over the period from 1990 to 2013. https://www.sciencedirect.com/science/article/pii/S0959652615009877 Sovacool, B. K., Andersen, R., Sorensen, S., Sorensen, K., Tienda, V., Vainorius, A., ... & Bjørn-Thygesen, F. (2016). Balancing safety with sustainability: assessing the risk of accidents for modern low-carbon energy systems. Journal of cleaner production, 112, 3952-3965.

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