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 = 5403 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
21238 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 
{
    "link": "https://zenodo.org/record/5589597#.YYf3EdnMK_0",
    "additionalInfo": "Consumption-based (trade-adjusted) energy use can be calculated from data published in the EXIOBASE v3.8.2 database using a multi-regional input-output (MRIO) model.\n\nThis MRIO model uses data on the quantity of goods traded, and the country-specific energy intensity of producing those goods to estimate the amount of energy embodied in exported goods, and in imported goods. \n\nConsumption-based (trade-adjusted) energy use is then calculated as domestic energy use minus energy embodied in exported goods, plus imported goods.\n\nThis trade-adjusted energy use data was calculated by <a href=\"https://baug.ethz.ch/en/department/people/staff/personen-detail.MjY1MDUz.TGlzdC82NzksLTU1NTc1NDEwMQ==.html\">Viktoras Kulionis</a> using this approach.\n\nThe EXIOBASE v3.8.2 database is available online: https://zenodo.org/record/5589597#.YYf3EdnMK_0.\n\nWe have calculated per capita metrics by combining this data with population data from the UN World Population Prospects: https://population.un.org/wpp/\n\nWe have calculated energy intensity metrics by combining this data with GDP data (measured in 2017 international dollars, which corrects for inflation and cross-country price differences) from the World Bank: https://data.worldbank.org/indicator\n\nCarbon intensity of energy is calculated by combining this data with CO2. emissions data from the Global Carbon Project.\nReference: Global Carbon Project. (2021). Supplemental data of Global Carbon Project 2021 (1.0) [Data set]. Global Carbon Project. https://doi.org/10.18160/gcp-2021.)\n\nThe EXIOBASE database contains a data error for Australia for 2018 and 2019, which provides erroneous results. We have therefore removed these two data points for Australia only.",
    "dataPublishedBy": "Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database"
}
 2021-11-09 09:36:24 2021-11-09 09:36:24 Consumption-based energy (Kulionis, 2021) 5403 Consumption-based (trade-adjusted) energy use can be calculated from data published in the EXIOBASE v3.8.2 database using a multi-regional input-output (MRIO) model. This MRIO model uses data on the quantity of goods traded, and the country-specific energy intensity of producing those goods to estimate the amount of energy embodied in exported goods, and in imported goods. Consumption-based (trade-adjusted) energy use is then calculated as domestic energy use minus energy embodied in exported goods, plus imported goods. This trade-adjusted energy use data was calculated by <a href="https://baug.ethz.ch/en/department/people/staff/personen-detail.MjY1MDUz.TGlzdC82NzksLTU1NTc1NDEwMQ==.html">Viktoras Kulionis</a> using this approach. The EXIOBASE v3.8.2 database is available online: https://zenodo.org/record/5589597#.YYf3EdnMK_0. We have calculated per capita metrics by combining this data with population data from the UN World Population Prospects: https://population.un.org/wpp/ We have calculated energy intensity metrics by combining this data with GDP data (measured in 2017 international dollars, which corrects for inflation and cross-country price differences) from the World Bank: https://data.worldbank.org/indicator Carbon intensity of energy is calculated by combining this data with CO2. emissions data from the Global Carbon Project. Reference: Global Carbon Project. (2021). Supplemental data of Global Carbon Project 2021 (1.0) [Data set]. Global Carbon Project. https://doi.org/10.18160/gcp-2021.) The EXIOBASE database contains a data error for Australia for 2018 and 2019, which provides erroneous results. We have therefore removed these two data points for Australia only. https://zenodo.org/record/5589597#.YYf3EdnMK_0 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database

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