owid: sources: 1 row where datasetId = 5367 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 = 5367 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
20600	RAM Legacy Database; Hilborn,et al. (2020). Effective fisheries management instrumental in improving fish stock status.	{ "link": "https://www.ramlegacy.org/", "retrievedDate": "10th September 2021", "additionalInfo": "This dataset provides aggregated data on fish biomass, fishing pressure and catch by region and taxa, based on the results of the RAM Legacy Stock Assessment Database: https://www.ramlegacy.org/\n\nThis aggregated data was provided by Michael\u00a0Melnychuk, researcher on the RAM Legacy Database.\n\nThese results were published in PNAS here:\nHilborn, R., Amoroso, R. O., Anderson, C. M., Baum, J. K., Branch, T. A., Costello, C., ... & Ye, Y. (2020). Effective fisheries management instrumental in improving fish stock status. Proceedings of the National Academy of Sciences, 117(4), 2218-2224. Available at: https://www.pnas.org/content/117/4/2218\n\nDefinitions are as follows:\n\u2013 'Biomass' is a measure of biomass of fish divided by the biomass of fish at the maximum sustainable yield (B / Bmsy)\n\u2013 'Fishing pressure' is a measure of fishing pressure divided by the pressure at the maximum sustainable yield (U / Umsy)\n\u2013 'Catch' is a measure of the annual catch divided by the mean catch across the stock's time series", "dataPublishedBy": "RAM Legacy Stock Assessment Database. 2021. Version 4.495-assessment-only. Retrieved from DOI:10.5281/zenodo.4824192." }	2021-09-10 10:18:38	2021-09-10 10:18:38	Marine stocks by region and taxa (ramlegacy) 5367	This dataset provides aggregated data on fish biomass, fishing pressure and catch by region and taxa, based on the results of the RAM Legacy Stock Assessment Database: https://www.ramlegacy.org/ This aggregated data was provided by Michael Melnychuk, researcher on the RAM Legacy Database. These results were published in PNAS here: Hilborn, R., Amoroso, R. O., Anderson, C. M., Baum, J. K., Branch, T. A., Costello, C., ... & Ye, Y. (2020). Effective fisheries management instrumental in improving fish stock status. Proceedings of the National Academy of Sciences, 117(4), 2218-2224. Available at: https://www.pnas.org/content/117/4/2218 Definitions are as follows: – 'Biomass' is a measure of biomass of fish divided by the biomass of fish at the maximum sustainable yield (B / Bmsy) – 'Fishing pressure' is a measure of fishing pressure divided by the pressure at the maximum sustainable yield (U / Umsy) – 'Catch' is a measure of the annual catch divided by the mean catch across the stock's time series	https://www.ramlegacy.org/	RAM Legacy Stock Assessment Database. 2021. Version 4.495-assessment-only. Retrieved from DOI:10.5281/zenodo.4824192.

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