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 = 5665 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
22725 United Nations Comtrade Database 
{
    "link": "https://comtrade.un.org/data/",
    "additionalInfo": "This dataset measures the global trade of plastic waste. \n\nThe data is sourced from the commodity category '3915 \u2013 Waste, parings and scrap, of plastics' from the UN's Comtrade Database.\n\nThese results are also published in the UNCTAD report, published at: https://unctad.org/system/files/official-document/ser-rp-2020d12_en.pdf\n\nThe metrics 'Exports', 'Imports', 'Re-Exports' and 'Re-Imports' are taken directly from the UN Comtrade Database.\n\nWe have calculated several additional metrics:\n\n1. 'Net exports'. This is calculated as 'Exports' minus 'Imports'.\n2. All of these metrics in per capita terms. These are calculated by dividing by each country's population\n3. Share of the global total for each metric. These are calculated by dividing each country's figures by the total of all available countries (i.e. the world total) in each year.",
    "dataPublishedBy": "United Nations Comtrade Database"
}
 2022-07-26 13:33:47 2022-07-26 13:33:47 Plastic waste trade (UN Comtrade, 2022) 5665 This dataset measures the global trade of plastic waste. The data is sourced from the commodity category '3915 – Waste, parings and scrap, of plastics' from the UN's Comtrade Database. These results are also published in the UNCTAD report, published at: https://unctad.org/system/files/official-document/ser-rp-2020d12_en.pdf The metrics 'Exports', 'Imports', 'Re-Exports' and 'Re-Imports' are taken directly from the UN Comtrade Database. We have calculated several additional metrics: 1. 'Net exports'. This is calculated as 'Exports' minus 'Imports'. 2. All of these metrics in per capita terms. These are calculated by dividing by each country's population 3. Share of the global total for each metric. These are calculated by dividing each country's figures by the total of all available countries (i.e. the world total) in each year. https://comtrade.un.org/data/ United Nations Comtrade Database

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