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 = 5509 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
21323 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 
{
    "link": "https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html; https://ember-climate.org/data/; https://ember-climate.org/project/european-electricity-review-2022/",
    "retrievedDate": "13th February 2022",
    "additionalInfo": "Data is compiled by Our World in Data based on three main sources: \n\u2013 BP Statistical Review of World Energy: https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html\n\u2013 Ember: https://ember-climate.org/data/\n- Ember European Electricity Review (2022): https://ember-climate.org/project/european-electricity-review-2022/\n\nWe also include European carbon intensities (gCO2/kWh) from Ember: https://ember-climate.org/project/eu-power-sector-2020/. The underlying source for much of this data is the European Environment Agency: https://www.eea.europa.eu/ims/greenhouse-gas-emission-intensity-of-1 \n\nElectricity mix data from BP provides primary energy (not just electricity) consumption data, meaning energy and electricity data is consistent from the same source. It provides a longer time-series (dating back to 1965) versus only 2000 from Ember. However, BP does not provide data for all countries and is not as up-to-date as Ember data.\n\nSo, where data from Ember is available for a given country or year, we rely on it as the primary source. We then supplement this with data from BP where it's not available.\n\n2021 electricity data is currently only available for European countries based on the latest European Electricity Review.\n\nOur World in Data has converted absolute electricity production by source to the share in the mix by dividing each by total electricity production.",
    "dataPublishedBy": "BP Statistical Review of World Energy & Ember"
}
 2022-02-10 10:37:57 2022-02-10 10:37:57 Electricity mix from BP & EMBER (2022) - archive 5509 Data is compiled by Our World in Data based on three main sources: – BP Statistical Review of World Energy: https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html – Ember: https://ember-climate.org/data/ - Ember European Electricity Review (2022): https://ember-climate.org/project/european-electricity-review-2022/ We also include European carbon intensities (gCO2/kWh) from Ember: https://ember-climate.org/project/eu-power-sector-2020/. The underlying source for much of this data is the European Environment Agency: https://www.eea.europa.eu/ims/greenhouse-gas-emission-intensity-of-1 Electricity mix data from BP provides primary energy (not just electricity) consumption data, meaning energy and electricity data is consistent from the same source. It provides a longer time-series (dating back to 1965) versus only 2000 from Ember. However, BP does not provide data for all countries and is not as up-to-date as Ember data. So, where data from Ember is available for a given country or year, we rely on it as the primary source. We then supplement this with data from BP where it's not available. 2021 electricity data is currently only available for European countries based on the latest European Electricity Review. Our World in Data has converted absolute electricity production by source to the share in the mix by dividing each by total electricity production. https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html; https://ember-climate.org/data/; https://ember-climate.org/project/european-electricity-review-2022/ BP Statistical Review of World Energy & Ember

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