owid: sources: 1 row where datasetId = 5760 sorted by id descending

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 = 5760 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
27027	Morales-Caselles et al. (2021). An inshore–offshore sorting system revealed from global classification of ocean litter.	{ "link": "https://www.nature.com/articles/s41893-021-00720-8", "additionalInfo": "This study included samples more than 12 million litter items retrieved from 7 major river and ocean environments globally. To build such a large inventories of macro-litter items, the authors compiled a total of 36 datasets providing counts of litter by item typology in river waters and riverbed, shoreline, nearshore waters (<100\u2009km from shoreline) and nearshore seafloor (<100\u2009m depth, <100\u2009km from shoreline), open waters (>100\u2009km from shoreline) and deep seafloor (>100\u2009m depth, >100\u2009km from shoreline).\n\nThese litter items were classified according to their material composition, type of product and probable origin.\n\nOn average, 80% of the items were made of plastic, followed by metal (7%\u2009\u00b1\u20097%), glass (5%\u2009\u00b1\u20096%) and fabric (3%\u2009\u00b1\u20093%).\n\nThis data by region is shown as the share of items in nearshore waters (<100 km from the shoreline).", "dataPublishedBy": "Morales-Caselles, C., Viejo, J., Mart\u00ed, E., Gonz\u00e1lez-Fern\u00e1ndez, D., Pragnell-Raasch, H., Gonz\u00e1lez-Gordillo, J. I., ... & C\u00f3zar, A. (2021). An inshore\u2013offshore sorting system revealed from global classification of ocean litter. Nature Sustainability, 4(6), 484-493." }	2022-09-08 15:54:29	2022-09-08 15:54:29	ocean_waste_items_by_region 5760	This study included samples more than 12 million litter items retrieved from 7 major river and ocean environments globally. To build such a large inventories of macro-litter items, the authors compiled a total of 36 datasets providing counts of litter by item typology in river waters and riverbed, shoreline, nearshore waters (<100 km from shoreline) and nearshore seafloor (<100 m depth, <100 km from shoreline), open waters (>100 km from shoreline) and deep seafloor (>100 m depth, >100 km from shoreline). These litter items were classified according to their material composition, type of product and probable origin. On average, 80% of the items were made of plastic, followed by metal (7% ± 7%), glass (5% ± 6%) and fabric (3% ± 3%). This data by region is shown as the share of items in nearshore waters (<100 km from the shoreline).	https://www.nature.com/articles/s41893-021-00720-8	Morales-Caselles, C., Viejo, J., Martí, E., González-Fernández, D., Pragnell-Raasch, H., González-Gordillo, J. I., ... & Cózar, A. (2021). An inshore–offshore sorting system revealed from global classification of ocean litter. Nature Sustainability, 4(6), 484-493.

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