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 = 5222 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
17951 Lelieveld et al. (2019). Effects of fossil fuel and total anthropogenic emission removal on public health and climate. PNAS. 
{
    "link": "https://www.pnas.org/content/116/15/7192",
    "retrievedDate": "17th November 2020",
    "additionalInfo": "Lelieveld et al. (2019) quantify excess mortality and years of life lost (YLL) from air pollution. \n\nThey do this by applying an atmospheric chemistry\u2013general circulation model to calculate the impacts of air pollution on climate and public health. This model includes concentrations of ozone (O3) and particulate matter, including PM2.5. These concentrations are then used to convert to health burden based on the Global Burden of Disease methodology.\n\n\u2013 Air pollution deaths from all sources includes pollution from all anthropogenic sources (fossil fuels, agriculture, residential energy use, and non-fossil industrial emissions) and natural emissions from sources such as desert dust.\n\u2013 Air pollution deaths from fossil fuels includes local air pollution generated from the burning of coal, oil and gas.\n\u2013 Air pollution deaths from all anthropogenic sources includes pollution from fossil fuels plus agriculture, residential energy use, and non-fossil industrial emissions.\n\nOur World in Data has also converted these mortality and YLL metrics into rates based on the population figures included in the study's Supplemental material.\n\nOur World in Data has also calculated fossil fuel and total anthropogenic pollution deaths as a share of total air pollution deaths based on the paper's original data.",
    "dataPublishedBy": "Lelieveld, J., Klingm\u00fcller, K., Pozzer, A., Burnett, R. T., Haines, A., & Ramanathan, V. (2019). Effects of fossil fuel and total anthropogenic emission removal on public health and climate. Proceedings of the National Academy of Sciences, 116(15), 7192-7197."
}
 2020-11-17 18:11:05 2020-11-17 18:11:05 Deaths attributed to air pollution (Lelieveld et al. 2019) 5222 Lelieveld et al. (2019) quantify excess mortality and years of life lost (YLL) from air pollution. They do this by applying an atmospheric chemistry–general circulation model to calculate the impacts of air pollution on climate and public health. This model includes concentrations of ozone (O3) and particulate matter, including PM2.5. These concentrations are then used to convert to health burden based on the Global Burden of Disease methodology. – Air pollution deaths from all sources includes pollution from all anthropogenic sources (fossil fuels, agriculture, residential energy use, and non-fossil industrial emissions) and natural emissions from sources such as desert dust. – Air pollution deaths from fossil fuels includes local air pollution generated from the burning of coal, oil and gas. – Air pollution deaths from all anthropogenic sources includes pollution from fossil fuels plus agriculture, residential energy use, and non-fossil industrial emissions. Our World in Data has also converted these mortality and YLL metrics into rates based on the population figures included in the study's Supplemental material. Our World in Data has also calculated fossil fuel and total anthropogenic pollution deaths as a share of total air pollution deaths based on the paper's original data. https://www.pnas.org/content/116/15/7192 Lelieveld, J., Klingmüller, K., Pozzer, A., Burnett, R. T., Haines, A., & Ramanathan, V. (2019). Effects of fossil fuel and total anthropogenic emission removal on public health and climate. Proceedings of the National Academy of Sciences, 116(15), 7192-7197.

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