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 = 4878 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
17609 GHG emissions per capita (EDGAR) 
{
    "link": "http://data.worldbank.org/data-catalog/world-development-indicators",
    "retrievedDate": "1st December 2019",
    "additionalInfo": "Total greenhouse gas emissions in CO2 equivalent are composed of CO2 totals excluding short-cycle biomass burning (such as agricultural waste burning and Savannah burning) but including other biomass burning (such as forest fires, post-burn decay, peat fires and decay of drained peatlands), all anthropogenic CH4 sources, N2O sources and F-gases (HFCs, PFCs and SF6).\n\nFigures on per capita greenhouse gas (GHG) emissions were calculated by Our World in Data based on total GHG emissions, and population data published in the World Bank, World Development Indicators. \n\nThe World Bank (WDI) publishes figures on annual GHG emissions by country, sourced from the European Commission, Joint Research Centre (JRC)/Netherlands Environmental Assessment Agency (PBL). And population data sourced from the UN World Population Prospects.\n\nPer capita GHG emissions per year was calculated by dividing total annual emissions by country by its population in the given year.\n\nPer capita GHG emissions per day was calculated by diving annual per capita figures by 365 (and converting from tonnes to kilograms by multiplying by 1000).\n\nThe World Bank, World Development Indicators can be sourced at: http://data.worldbank.org/data-catalog/world-development-indicators\n\nThe original data from EDGAR can be sourced at: http://edgar.jrc.ec.europa.eu/",
    "dataPublishedBy": "Calculated by Our World in Data based on data from the World Bank \u2013 World Development Indicators",
    "dataPublisherSource": "European Commission, Joint Research Centre (JRC)/Netherlands Environmental Assessment Agency (PBL). Emission Database for Global Atmospheric Research (EDGAR), EDGARv4.2 FT2012: http://edgar.jrc.ec.europa.eu/"
}
 2019-12-01 09:26:14 2019-12-01 09:26:14 GHG emissions per capita (EDGAR, 2019) 4878 Total greenhouse gas emissions in CO2 equivalent are composed of CO2 totals excluding short-cycle biomass burning (such as agricultural waste burning and Savannah burning) but including other biomass burning (such as forest fires, post-burn decay, peat fires and decay of drained peatlands), all anthropogenic CH4 sources, N2O sources and F-gases (HFCs, PFCs and SF6). Figures on per capita greenhouse gas (GHG) emissions were calculated by Our World in Data based on total GHG emissions, and population data published in the World Bank, World Development Indicators. The World Bank (WDI) publishes figures on annual GHG emissions by country, sourced from the European Commission, Joint Research Centre (JRC)/Netherlands Environmental Assessment Agency (PBL). And population data sourced from the UN World Population Prospects. Per capita GHG emissions per year was calculated by dividing total annual emissions by country by its population in the given year. Per capita GHG emissions per day was calculated by diving annual per capita figures by 365 (and converting from tonnes to kilograms by multiplying by 1000). The World Bank, World Development Indicators can be sourced at: http://data.worldbank.org/data-catalog/world-development-indicators The original data from EDGAR can be sourced at: http://edgar.jrc.ec.europa.eu/ http://data.worldbank.org/data-catalog/world-development-indicators Calculated by Our World in Data based on data from the World Bank – World Development Indicators

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