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 = 2827 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
15558 Our World in Data based on Geyer et al. (2017) and OECD 
{
    "link": "",
    "retrievedDate": "",
    "additionalInfo": "This data measures plastic production as the sum of polymer resin and fiber production. This is measured in metric tonnes.\n\nIt comes two datasets.\n\nData from 1950 to 2015 is taken directly from the work of Geyer et al. (2017), published in the journal Science Advances.\nhttp://advances.sciencemag.org/content/3/7/e1700782.full\n\nThe data point for 2019 comes from the work of the OECD Global Plastics Outlook (available here: https://doi.org/10.1787/efff24eb-en).\n\nSince estimates of plastic production were not available for the years 2016, 2017 and 2018, Our World in Data have estimated these figures based the assumption of a 5% annual growth rate in production. This growth rate was estimated based on the annual growth rates in the last decade of the Geyer et al. (2017) dataset. Assumptions of a 5% growth rate also match closely with the OECD's 2019 figures.",
    "dataPublishedBy": "Our World in Data based on Geyer et al. (2017) and OECD",
    "dataPublisherSource": null
}
 2018-07-02 13:54:45 2018-07-19 15:40:10 Global plastic production (Geyer et al. and OECD) 2827 This data measures plastic production as the sum of polymer resin and fiber production. This is measured in metric tonnes. It comes two datasets. Data from 1950 to 2015 is taken directly from the work of Geyer et al. (2017), published in the journal Science Advances. http://advances.sciencemag.org/content/3/7/e1700782.full The data point for 2019 comes from the work of the OECD Global Plastics Outlook (available here: https://doi.org/10.1787/efff24eb-en). Since estimates of plastic production were not available for the years 2016, 2017 and 2018, Our World in Data have estimated these figures based the assumption of a 5% annual growth rate in production. This growth rate was estimated based on the annual growth rates in the last decade of the Geyer et al. (2017) dataset. Assumptions of a 5% growth rate also match closely with the OECD's 2019 figures.   Our World in Data based on Geyer et al. (2017) and OECD

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