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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
6727	Smallpox and its Eradication - Fenner, Henderson, Arita, Jezek, and Ladnyi (1988) - WHO	{ "link": "http://whqlibdoc.who.int/smallpox/9241561106.pdf", "retrievedDate": "11/09/2017", "additionalInfo": "The only data not taken from the maps but from the text are the data for Canada, USA, Australia and New Zealand: For Canada the authors reported that \u201cendemic smallpox was eliminated by 1944\u201d, for the USA only that it was eliminated \u201cthe latter half of the 1940s\u201d (I chose 1948 for the visualization). Dates for the last outbreaks of smallpox in Australia (1917) and New Zealand (1914) are reported in the text \u2013 in both countries smallpox has always been rare. \r\n\r\nThe dates for Madagascar and Namibia are not exactly known \u2013 the authors only report that smallpox was eradicated in Madagascar before 1918 and for Namibia before 1955 (so I chose these years for eradication). \r\n\r\nCountries are shown in their current borders \u2013 successor countries of Yugoslavia, the USSR and the Sudan are assigned the eradication date of these states: 1925 for Yugoslavia, 1936 for the USSR, and 1972 for the Sudan.", "dataPublishedBy": "Maps in Chapter 8 of F. Fenner, D. A. Henderson, I. Arita, Z. Jezek, I. D. Ladnyi (1988) \u2013 Smallpox and its Eradication. World Health Organization (WHO) 1988.", "dataPublisherSource": "In-text citations refer the reader to academic publications for individual countries or continents." }	2017-09-11 12:21:38	2017-11-15 17:28:41	Year of smallpox eradication by country - WHO (1988) 917	The only data not taken from the maps but from the text are the data for Canada, USA, Australia and New Zealand: For Canada the authors reported that “endemic smallpox was eliminated by 1944”, for the USA only that it was eliminated “the latter half of the 1940s” (I chose 1948 for the visualization). Dates for the last outbreaks of smallpox in Australia (1917) and New Zealand (1914) are reported in the text – in both countries smallpox has always been rare. The dates for Madagascar and Namibia are not exactly known – the authors only report that smallpox was eradicated in Madagascar before 1918 and for Namibia before 1955 (so I chose these years for eradication). Countries are shown in their current borders – successor countries of Yugoslavia, the USSR and the Sudan are assigned the eradication date of these states: 1925 for Yugoslavia, 1936 for the USSR, and 1972 for the Sudan.	http://whqlibdoc.who.int/smallpox/9241561106.pdf	Maps in Chapter 8 of F. Fenner, D. A. Henderson, I. Arita, Z. Jezek, I. D. Ladnyi (1988) – Smallpox and its Eradication. World Health Organization (WHO) 1988.

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