sources
Data license: CC-BY
1 row where datasetId = 500 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 |
---|---|---|---|---|---|---|---|---|
632 | Investment in renewables by technology - IRENA (2017) | { "link": "http://resourceirena.irena.org/gateway/dashboard/", "retrievedDate": "30/05/2017", "additionalInfo": "Renewable investment figures are measured in billion USD per year. Investment adjusts for re-invested equity, and includes estimates for undisclosed deals.\r\n\r\nFigures excludes investments in large hydropower schemes.", "dataPublishedBy": "International Renewable Energy Agency (IRENA)", "dataPublisherSource": "Frankfurt School-UNEP Centre/BNEF (2017). Global Trends in Renewable Energy Investment 2017. Available at: http://fs-unep-centre.org/sites/default/files/publications/globaltrendsinrenewableenergyinvestment2017.pdf" } |
2017-05-30 17:21:36 | 2017-11-23 11:15:04 | Investment in renewables by technology - IRENA (2017) 500 | Renewable investment figures are measured in billion USD per year. Investment adjusts for re-invested equity, and includes estimates for undisclosed deals. Figures excludes investments in large hydropower schemes. | http://resourceirena.irena.org/gateway/dashboard/ | 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");