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 = 5198 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
17928 Deaths per TWh energy production 
{
    "additionalInfo": "Death rates from energy production is measured as the number of deaths by energy source per terawatt-hour (TWh) of electricity production. \n\nData on death rates from fossil fuels is sourced from Markandya, A., & Wilkinson, P. (2007).\n\nData on death rates from solar and wind is sourced from Sovacool et al. (2016) based on a database of accidents from these sources.\n\nWe estimate deaths rates for nuclear energy based on the latest death toll figures from Chernobyl and Fukushima as described in our article here: https://ourworldindata.org/what-was-the-death-toll-from-chernobyl-and-fukushima\n\nWe estimate death rates from hydropower based on an updated list of historical hydropower accidents, dating back to 1965, sourced primarily from the underlying database included in Sovacool et al. (2016). For more information, see our article: https://ourworldindata.org/safest-sources-of-energy",
    "dataPublishedBy": "Sovacool et al. (2016); and Markandya, A., & Wilkinson, P. (2007)"
}
 2020-10-16 17:17:34 2020-10-16 17:17:34 Deaths per TWh energy production 5198 Death rates from energy production is measured as the number of deaths by energy source per terawatt-hour (TWh) of electricity production. Data on death rates from fossil fuels is sourced from Markandya, A., & Wilkinson, P. (2007). Data on death rates from solar and wind is sourced from Sovacool et al. (2016) based on a database of accidents from these sources. We estimate deaths rates for nuclear energy based on the latest death toll figures from Chernobyl and Fukushima as described in our article here: https://ourworldindata.org/what-was-the-death-toll-from-chernobyl-and-fukushima We estimate death rates from hydropower based on an updated list of historical hydropower accidents, dating back to 1965, sourced primarily from the underlying database included in Sovacool et al. (2016). For more information, see our article: https://ourworldindata.org/safest-sources-of-energy   Sovacool et al. (2016); and Markandya, A., & Wilkinson, P. (2007)

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