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 = 2731 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
15464 UN Environment Programme (2023) 
{
    "link": "http://ede.grid.unep.ch/",
    "retrievedDate": "5th April 2018",
    "additionalInfo": "Through The Vienna Convention on the Protection of the Ozone Layer governments committed themselves to protect the ozone layer and to co-operate with each other in scientific research to improve understanding of the atmospheric processes.\n\nThe Montreal Protocol on Substances that Deplete the Ozone Layer was adopted by Governments in 1987 and has been modified five times so far. Its control provisions were strengthened through four adjustments to the Protocol adopted in London (1990), Copenhagen (1992), Vienna (1995), Montreal (1997) and Beijing (1999). The Protocol aims to reduce and eventually eliminate the emissions of man-made ozone depleting substances",
    "dataPublishedBy": "United Nations Environment Programme (UNEP)",
    "dataPublisherSource": null
}
 2018-04-05 20:53:44 2023-03-23 16:15:57 Parties to Montreal Protocol (UNEP, 2023) 2731 Through The Vienna Convention on the Protection of the Ozone Layer governments committed themselves to protect the ozone layer and to co-operate with each other in scientific research to improve understanding of the atmospheric processes. The Montreal Protocol on Substances that Deplete the Ozone Layer was adopted by Governments in 1987 and has been modified five times so far. Its control provisions were strengthened through four adjustments to the Protocol adopted in London (1990), Copenhagen (1992), Vienna (1995), Montreal (1997) and Beijing (1999). The Protocol aims to reduce and eventually eliminate the emissions of man-made ozone depleting substances http://ede.grid.unep.ch/ United Nations Environment Programme (UNEP)

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