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 = 6130 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
29203 Energy Institute Statistical Review of World Energy (2023) 
{
    "link": "https://www.energyinst.org/statistical-review/",
    "retrievedDate": "2023-06-27",
    "additionalInfo": "The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year.\n",
    "dataPublishedBy": "Energy Institute Statistical Review of World Energy (2023)"
}
 2023-11-07 09:43:48 2023-12-19 13:30:26 Energy mix (Energy Institute, 2023) 6130 The Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year. https://www.energyinst.org/statistical-review/ Energy Institute Statistical Review of World Energy (2023)
29202 Energy Institute Statistical Review of World Energy (2023) 
{
    "link": "https://www.energyinst.org/statistical-review/",
    "retrievedDate": "2023-06-27",
    "additionalInfo": "Raw data on energy consumption is sourced from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review).\n\nPrimary energy in exajoules (EJ) has been converted to TWh by Our World in Data based on a conversion factor of 1,000,000 / 3,600 (~277.778).\n\nFor non-fossil based electricity sources (nuclear, hydro, wind, solar, geothermal, biomass in power, and other renewable sources), the Statistical Review's generation (in TWh) corresponds to gross generation and not accounting for cross-border electricity supply.\nAlso, for non-fossil based electricity, there are two ways to define primary energy:\n* One is \"direct primary energy\", which corresponds to electricity generation (in TWh).\n* The other is \"input-equivalent primary energy\" (also called \"primary energy using the substitution method\").\n This is the amount of fuel that would be required by thermal power stations to generate the reported electricity, as explained in [the Statistical Review methodology document](https://www.energyinst.org/__data/assets/pdf_file/0003/1055541/Methodology.pdf). For example, if a country's nuclear power generated 100 TWh of electricity, and assuming that the efficiency of a standard thermal power plant is 38%, the input equivalent primary energy for this country would be 100 TWh / 0.38 = 263 TWh = 0.95 EJ. This input-equivalent primary energy takes account of the inefficiencies in fossil fuel production and provides a better approximation of each source's share of \"final energy\" consumption.\n\nAdditional metrics have been calculated by Our World in Data:\n- Annual change in energy consumption by source: this is calculated as the difference from the previous year.\n- % of total primary energy: calculated as each source's share of primary energy (direct energy and primary energy using the substitution method) from all sources.\n- Per capita energy by source: calculated as primary energy consumption by source, divided by population.\n\nPer capita figures have been calculated using a population dataset that is built and maintained by Our World in Data, based on [different sources](https://ourworldindata.org/population-sources).\n\nThe Energy Institute Statistical Review of World Energy analyses data on world energy markets from the prior year.\n",
    "dataPublishedBy": "Energy Institute Statistical Review of World Energy (2023)"
}
 2023-11-07 09:43:47 2023-12-19 13:30:09 Energy mix (Energy Institute, 2023) 6130 Raw data on energy consumption is sourced from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review). Primary energy in exajoules (EJ) has been converted to TWh by Our World in Data based on a conversion factor of 1,000,000 / 3,600 (~277.778). For non-fossil based electricity sources (nuclear, hydro, wind, solar, geothermal, biomass in power, and other renewable sources), the Statistical Review's generation (in TWh) corresponds to gross generation and not accounting for cross-border electricity supply. Also, for non-fossil based electricity, there are two ways to define primary energy: * One is "direct primary energy", which corresponds to electricity generation (in TWh). * The other is "input-equivalent primary energy" (also called "primary energy using the substitution method"). This is the amount of fuel that would be required by thermal power stations to generate the reported electricity, as explained in [the Statistical Review methodology document](https://www.energyinst.org/__data/assets/pdf_file/0003/1055541/Methodology.pdf). For example, if a country's nuclear power generated 100 TWh of electricity, and assuming that the efficiency of a standard thermal power plant is 38%, the input equivalent primary energy for this country would be 100 TWh / 0.38 = 263 TWh = 0.95 EJ. This input-equivalent primary energy takes account of the inefficiencies in fossil fuel production and provides a better approximation of each source's share of "final energy" consumption. Additional metrics have been calculated by Our World in Data: - Annual change in energy consumption by source: this is calculated as the difference from the previous year. - % of total primary energy: calculated as each source's share of primary energy (direct energy and primary energy using the substitution method) from all sources. - Per capita energy by source: calculated as primary energy consumption by source, divided by population. Per capita figures have been calculated using a population data… https://www.energyinst.org/statistical-review/ Energy Institute Statistical Review of World Energy (2023)

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