sources
Data license: CC-BY
1 row where datasetId = 5431 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 |
---|---|---|---|---|---|---|---|---|
21266 | UNECE (2021). Life Cycle Assessment of Electricity Generation Options. United Nations Economic Commission for Europe. | { "link": "https://unece.org/sed/documents/2021/10/reports/life-cycle-assessment-electricity-generation-options", "additionalInfo": "This dataset was updated on 8th July 2022 with the latest figures from the UNECE. You can find details of this correction and update from the UNECE here: https://unece.org/sites/default/files/2022-07/Corrigendum%20to%20UNECE%20LCA%20report%20-%20land%20use.pdf", "dataPublishedBy": "UNECE (2021). Life Cycle Assessment of Electricity Generation Options. United Nations Economic Commission for Europe." } |
2021-12-07 09:56:47 | 2021-12-07 09:56:47 | Life-cycle impacts of energy sources (UNECE) 5431 | This dataset was updated on 8th July 2022 with the latest figures from the UNECE. You can find details of this correction and update from the UNECE here: https://unece.org/sites/default/files/2022-07/Corrigendum%20to%20UNECE%20LCA%20report%20-%20land%20use.pdf | https://unece.org/sed/documents/2021/10/reports/life-cycle-assessment-electricity-generation-options | UNECE (2021). Life Cycle Assessment of Electricity Generation Options. United Nations Economic Commission for Europe. |
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");