sources
Data license: CC-BY
1 row where datasetId = 5813 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
27099 | International Renewable Energy Agency (IRENA) (2022) | { "link": "https://irena.org/publications/2022/Jul/Renewable-Power-Generation-Costs-in-2021", "retrievedDate": "2022-10-20", "additionalInfo": "Levelized cost of energy (LCOE) estimates the average cost per unit of energy generated across the lifetime of a new power plant. It is measured in 2021 US$ per kilowatt-hour.\n", "dataPublishedBy": "\u00a9 2022 by International Renewable Energy Agency (IRENA)", "dataPublisherSource": null } |
2022-10-24 14:26:45 | 2023-02-22 21:04:04 | Renewable power generation costs 5813 | Levelized cost of energy (LCOE) estimates the average cost per unit of energy generated across the lifetime of a new power plant. It is measured in 2021 US$ per kilowatt-hour. | https://irena.org/publications/2022/Jul/Renewable-Power-Generation-Costs-in-2021 | © 2022 by International Renewable Energy Agency (IRENA) |
Advanced export
JSON shape: default, array, newline-delimited, object
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");