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 = 6115 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
28069 International Renewable Energy Agency (IRENA) 
{
    "link": "https://www.irena.org/Statistics/Download-query-tools",
    "retrievedDate": "2023-06-28",
    "additionalInfo": "IRENA publishes detailed statistics on renewable energy capacity, power generation and renewable energy balances. This data is collected directly from members using the IRENA Renewable Energy Statistics questionnaire and is also supplemented by desk research where official statistics are not available.\n\nSome technologies include others, following this schema:\n\nTotal renewable energy\n  1. Hydropower\n      1.1 Renewable hydropower\n      1.2 Pumped storage *\n  2. Marine\n  3. Wind\n      3.1 Onshore wind energy\n      3.2 Offshore wind energy\n  4. Solar\n      4.1 Solar photovoltaic\n      4.2 Concentrated solar power\n  5. Bioenergy\n      5.1 Solid biofuels\n          5.1.1 Bagasse\n          5.1.2 Renewable municipal waste\n          5.1.3 Other solid biofuels\n      5.2 Liquid biofuels\n      5.3 Biogas\n  6. Geothermal\n\n* Pumped storage is included under the \"Hydropower\" category but not in the \"Total renewable energy\". Generation from mixed plants is split between hydropower and pumped storage as appropriate.\n\nThis data may be freely used, shared, copied, reproduced, printed and/or stored, provided that all such material is clearly attributed to IRENA and bears a notation of copyright (\u00a9 IRENA) with the year of copyright. Unless otherwise stated, the data provided are the property of the International Renewable Energy Agency (IRENA) and are subject to copyright by IRENA. Data attributed to third parties may be subject to third-party copyright and separate terms of use and restrictions, including restrictions in relation to any commercial use.\n",
    "dataPublishedBy": "International Renewable Energy Agency \u00a9 IRENA 2022"
}
 2023-07-20 13:41:37 2023-12-14 12:09:11 Renewable electricity capacity (IRENA, 2023-06-26) 6115 IRENA publishes detailed statistics on renewable energy capacity, power generation and renewable energy balances. This data is collected directly from members using the IRENA Renewable Energy Statistics questionnaire and is also supplemented by desk research where official statistics are not available. Some technologies include others, following this schema: Total renewable energy 1. Hydropower 1.1 Renewable hydropower 1.2 Pumped storage * 2. Marine 3. Wind 3.1 Onshore wind energy 3.2 Offshore wind energy 4. Solar 4.1 Solar photovoltaic 4.2 Concentrated solar power 5. Bioenergy 5.1 Solid biofuels 5.1.1 Bagasse 5.1.2 Renewable municipal waste 5.1.3 Other solid biofuels 5.2 Liquid biofuels 5.3 Biogas 6. Geothermal * Pumped storage is included under the "Hydropower" category but not in the "Total renewable energy". Generation from mixed plants is split between hydropower and pumped storage as appropriate. This data may be freely used, shared, copied, reproduced, printed and/or stored, provided that all such material is clearly attributed to IRENA and bears a notation of copyright (© IRENA) with the year of copyright. Unless otherwise stated, the data provided are the property of the International Renewable Energy Agency (IRENA) and are subject to copyright by IRENA. Data attributed to third parties may be subject to third-party copyright and separate terms of use and restrictions, including restrictions in relation to any commercial use. https://www.irena.org/Statistics/Download-query-tools International Renewable Energy Agency © IRENA 2022

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