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 = 5163 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
17893 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 
{
    "link": "https://theicct.org/publications/co2-emissions-commercial-aviation-2018",
    "retrievedDate": "1st September 2020",
    "additionalInfo": "Data on revenue passenger kilometres (RPKs) and carbon dioxide emissions from aviation are sourced from the International Council on Clean Transportation (ICCT).\n\nIn its 2018 review of commercial aviation it provides data on RPKs and CO\u2082 emissions for domestic flights, international flights and total emissions for each country. Under this framework, 'international' RPKs and emissions are allocated to the <b>country of departure</b>.\n\nOur World in Data has calculated per capita RPKs and aviation emissions by dividing these values by population figures in 2018 for each country, sourced from the UN World Population Prospects: https://population.un.org/wpp/\n\nThese per capita footprints do not necessarily reflect the amount of travel by locals in a given location. This is especially true if a country has high tourist volumes: much of the departures will result from travellers rather than local residents. We have therefore also calculated 'adjusted' aviation footprints by multiplying per capita international RPKs and CO2 emissions by an adjustment factor.\n\nThis adjustment factor is taken as the ratio between inbound and outbound arrivals, sourced from the World Bank: https://datacatalog.worldbank.org/dataset/world-development-indicators.\n\nThis adjustment methodology was also featured in analysis by the ICCT here: https://theicct.org/blog/staff/not-every-tonne-of-aviation-CO2",
    "dataPublishedBy": "Graver, B., Zhang, K., & Rutherford, D. (2019). CO2 emissions from commercial aviation, 2018. The International Council of Clean Transportation."
}
 2020-09-01 15:43:23 2020-09-01 15:43:23 Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Data on revenue passenger kilometres (RPKs) and carbon dioxide emissions from aviation are sourced from the International Council on Clean Transportation (ICCT). In its 2018 review of commercial aviation it provides data on RPKs and CO₂ emissions for domestic flights, international flights and total emissions for each country. Under this framework, 'international' RPKs and emissions are allocated to the <b>country of departure</b>. Our World in Data has calculated per capita RPKs and aviation emissions by dividing these values by population figures in 2018 for each country, sourced from the UN World Population Prospects: https://population.un.org/wpp/ These per capita footprints do not necessarily reflect the amount of travel by locals in a given location. This is especially true if a country has high tourist volumes: much of the departures will result from travellers rather than local residents. We have therefore also calculated 'adjusted' aviation footprints by multiplying per capita international RPKs and CO2 emissions by an adjustment factor. This adjustment factor is taken as the ratio between inbound and outbound arrivals, sourced from the World Bank: https://datacatalog.worldbank.org/dataset/world-development-indicators. This adjustment methodology was also featured in analysis by the ICCT here: https://theicct.org/blog/staff/not-every-tonne-of-aviation-CO2 https://theicct.org/publications/co2-emissions-commercial-aviation-2018 Graver, B., Zhang, K., & Rutherford, D. (2019). CO2 emissions from commercial aviation, 2018. The International Council of Clean Transportation.

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