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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
17021	Whale catch by decade (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 is presented as decadal totals where '1900' is equal to the total catch from 1900 to 1909; '1910' is from 1910 to 1919 etc. For the decade '2010', only the years 2010 to 2015 are currently included.\n\nData 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 09:27:09	2019-08-28 09:27:09	Whale catch by decade (Rocha et al. & IWC) 4193	Data is presented as decadal totals where '1900' is equal to the total catch from 1900 to 1909; '1910' is from 1910 to 1919 etc. For the decade '2010', only the years 2010 to 2015 are currently included. 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");