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

2 rows where datasetId = 6134 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
29215 Energy Institute Statistical Review of World Energy (2023); Ember; Ember's European Electricity Review (2022); Department for Business, Energy & Industrial Strategy of the UK 
{
    "link": "https://www.energyinst.org/statistical-review/ ; https://ember-climate.org/data-catalogue/yearly-electricity-data/ ; https://ember-climate.org/insights/research/european-electricity-review-2022/ ; https://www.gov.uk/government/statistical-data-sets/historical-electricity-data",
    "retrievedDate": "2023-06-27",
    "additionalInfo": "The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year.\n\nThe Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year. Previously produced by BP, the Review has been providing timely, comprehensive and objective data to the energy community since 1952.\n\nEmber's latest yearly electricity generation, capacity, emissions and demand data from over 200 geographies.\n\nThis dataset contains yearly electricity generation, capacity, emissions, import and demand data for over 200 geographies. Data is collected from multi-country datasets (EIA, Eurostat, BP, UN) as well as national sources (e.g China data from the National Bureau of Statistics).\n\nYou can find more about Ember's methodology in this document: https://ember-climate.org/app/uploads/2022/07/Ember-Electricity-Data-Methodology.pdf\n\nThe historical electricity data in the United Kingdom comes from the Digest of UK Energy Statistics (DUKES), published by the UK's Department for Business, Energy & Industrial Strategy (BEIS).\n",
    "dataPublishedBy": "Energy Institute Statistical Review of World Energy (2023); Ember; Department for Business, Energy & Industrial Strategy of the UK"
}
 2023-11-07 15:11:15 2023-12-19 13:34:31 UK historical electricity (DUKES, 2023c) 6134 The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year. The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year. Previously produced by BP, the Review has been providing timely, comprehensive and objective data to the energy community since 1952. Ember's latest yearly electricity generation, capacity, emissions and demand data from over 200 geographies. This dataset contains yearly electricity generation, capacity, emissions, import and demand data for over 200 geographies. Data is collected from multi-country datasets (EIA, Eurostat, BP, UN) as well as national sources (e.g China data from the National Bureau of Statistics). You can find more about Ember's methodology in this document: https://ember-climate.org/app/uploads/2022/07/Ember-Electricity-Data-Methodology.pdf The historical electricity data in the United Kingdom comes from the Digest of UK Energy Statistics (DUKES), published by the UK's Department for Business, Energy & Industrial Strategy (BEIS). https://www.energyinst.org/statistical-review/ ; https://ember-climate.org/data-catalogue/yearly-electricity-data/ ; https://ember-climate.org/insights/research/european-electricity-review-2022/ ; https://www.gov.uk/government/statistical-data-sets/historical-electricity-data Energy Institute Statistical Review of World Energy (2023); Ember; Department for Business, Energy & Industrial Strategy of the UK
28872 Department for Business, Energy & Industrial Strategy of the UK 
{
    "link": "https://www.gov.uk/government/statistical-data-sets/historical-electricity-data",
    "retrievedDate": "2023-07-10",
    "additionalInfo": "All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from [the Digest of UK Energy Statistics (DUKES), published by the UK's Department for Business, Energy & Industrial Strategy](https://www.gov.uk/government/statistics/electricity-chapter-5-digest-of-united-kingdom-energy-statistics-dukes).\n\nAll other data is sourced from the [the Energy Institute (EI) Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [Ember's Yearly Electricity Data](https://ember-climate.org/data-catalogue/yearly-electricity-data/). Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.\n\nThe historical electricity data in the United Kingdom comes from the Digest of UK Energy Statistics (DUKES), published by the UK's Department for Business, Energy & Industrial Strategy (BEIS).\n",
    "dataPublishedBy": "Department for Business, Energy & Industrial Strategy of the UK"
}
 2023-09-20 22:48:13 2023-12-19 13:34:28 UK historical electricity (DUKES, 2023c) 6134 All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from [the Digest of UK Energy Statistics (DUKES), published by the UK's Department for Business, Energy & Industrial Strategy](https://www.gov.uk/government/statistics/electricity-chapter-5-digest-of-united-kingdom-energy-statistics-dukes). All other data is sourced from the [the Energy Institute (EI) Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [Ember's Yearly Electricity Data](https://ember-climate.org/data-catalogue/yearly-electricity-data/). Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available. The historical electricity data in the United Kingdom comes from the Digest of UK Energy Statistics (DUKES), published by the UK's Department for Business, Energy & Industrial Strategy (BEIS). https://www.gov.uk/government/statistical-data-sets/historical-electricity-data Department for Business, Energy & Industrial Strategy of the UK

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