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 = 5850 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
29563 UN Environment, Frankfurt School-UNEP Centre, BNEF 
{
    "link": "https://www.unep.org/resources/report/global-trends-renewable-energy-investment-2019",
    "retrievedDate": "2023-01-03",
    "additionalInfo": "\nRenewable energy investments, extracted from Fig. 21 of the Global Trends in Renewable Energy Investment 2019 report, by UN Environment, Frankfurt School-UNEP Centre, BNEF.\n\nInvestment adjusts for re-invested equity, and includes estimates for undisclosed deals. Figures excludes investments in large hydropower schemes.\n",
    "dataPublishedBy": "UN Environment, Frankfurt School-UNEP Centre, BNEF. Copyright \u00a9 Frankfurt School of Finance & Management gGmbH 2019\n"
}
 2023-12-14 12:03:28 2023-12-20 08:07:12 Investment in renewable energy by technology (UNEP, 2019) 5850 Renewable energy investments, extracted from Fig. 21 of the Global Trends in Renewable Energy Investment 2019 report, by UN Environment, Frankfurt School-UNEP Centre, BNEF. Investment adjusts for re-invested equity, and includes estimates for undisclosed deals. Figures excludes investments in large hydropower schemes. https://www.unep.org/resources/report/global-trends-renewable-energy-investment-2019 UN Environment, Frankfurt School-UNEP Centre, BNEF. Copyright © Frankfurt School of Finance & Management gGmbH 2019
27247 UN Environment, Frankfurt School-UNEP Centre, BNEF 
{
    "link": "https://www.unep.org/resources/report/global-trends-renewable-energy-investment-2019",
    "retrievedDate": "2023-01-03",
    "additionalInfo": "Renewable energy investments, extracted from Fig. 21 of the Global Trends in Renewable Energy Investment 2019 report, by UN Environment, Frankfurt School-UNEP Centre, BNEF.\n\nInvestment adjusts for re-invested equity, and includes estimates for undisclosed deals. Figures excludes investments in large hydropower schemes.\n",
    "dataPublishedBy": "UN Environment, Frankfurt School-UNEP Centre, BNEF. Copyright \u00a9 Frankfurt School of Finance & Management gGmbH 2019\n"
}
 2023-01-04 14:58:56 2023-12-20 08:07:10 Investment in renewable energy by technology (UNEP, 2019) 5850 Renewable energy investments, extracted from Fig. 21 of the Global Trends in Renewable Energy Investment 2019 report, by UN Environment, Frankfurt School-UNEP Centre, BNEF. Investment adjusts for re-invested equity, and includes estimates for undisclosed deals. Figures excludes investments in large hydropower schemes. https://www.unep.org/resources/report/global-trends-renewable-energy-investment-2019 UN Environment, Frankfurt School-UNEP Centre, BNEF. Copyright © Frankfurt School of Finance & Management gGmbH 2019

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