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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
17020	Whale catch (Rocha et al.; IWC)	{ "link": "https://web.archive.org/web/20220613153315/https://iwc.int/public/downloads/8sXJb/Total_catches_since_1986.pdf", "retrievedDate": "5th December 2022", "additionalInfo": "Data on whale catch is sourced from two sources:\n\nFigures over the 20th century (1900-1999) is from: Rocha, R. C., Clapham, P. J., & Ivashchenko, Y. V. (2014). Emptying the oceans: a summary of industrial whaling catches in the 20th century. Marine Fisheries Review, 76(4), 37-48.\n\nThe above paper draws on data originally published by the International Whaling Commission (IWC).\n\nData from 2000 onwards is sourced directly from the International Whaling Commissions (IWC) which recorded the number of catches at: https://web.archive.org/web/20220613153315/https://iwc.int/public/downloads/8sXJb/Total_catches_since_1986.pdf\n\nFor the bowhead whale we source directly from the IWC from 1989 onwards.", "dataPublishedBy": "Rocha et al. (2014) & the International Whaling Commission (IWC)" }	2019-08-28 04:19:46	2019-08-28 04:19:46	Whale catch (Rocha et al.; IWC) 4192	Data on whale catch is sourced from two sources: Figures over the 20th century (1900-1999) is from: Rocha, R. C., Clapham, P. J., & Ivashchenko, Y. V. (2014). Emptying the oceans: a summary of industrial whaling catches in the 20th century. Marine Fisheries Review, 76(4), 37-48. The above paper draws on data originally published by the International Whaling Commission (IWC). Data from 2000 onwards is sourced directly from the International Whaling Commissions (IWC) which recorded the number of catches at: https://web.archive.org/web/20220613153315/https://iwc.int/public/downloads/8sXJb/Total_catches_since_1986.pdf For the bowhead whale we source directly from the IWC from 1989 onwards.	https://web.archive.org/web/20220613153315/https://iwc.int/public/downloads/8sXJb/Total_catches_since_1986.pdf	Rocha et al. (2014) & the International Whaling Commission (IWC)

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