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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
21936	OWID based on Bleek (2017), Nuclear Threat Initiative (2022)	{ "link": "https://www.belfercenter.org/sites/default/files/files/publication/When%20Did%20%28and%20Didn%27t%29%20States%20Proliferate%3F_1.pdf; https://www.nti.org/countries/", "retrievedDate": "February 28, 2022", "additionalInfo": "This dataset provides information on nuclear weapons states, using data from Bleek (2017), which we double-checked with information from the Nuclear Threat Initiative (2022) for recent years.\n\nThe dataset distinguishes between countries not considering (score 0), considering (score of 1), pursuing (score 2), possessing nuclear weapons (score 3). \n\nA country is coded as not considering nuclear weapons if it neither considers, pursues, or possesses nuclear weapons.\n\nA country is coded as considering nuclear weapons if its leaders explore whether it is possible and desirable for them to attempt to acquire nuclear weapons, or they work to increase their nuclear weapons capabilities, but without launching a dedicated program.\n\nA country is coded as pursuing nuclear weapons if it has an active program to acquire nuclear weapons or to obtain the ability to construct them on short notice.\n\nA country is coded as possessing nuclear weapons if it has a nuclear-explosive device that it can deliver. Conducting an explosive nuclear test is therefore neither sufficient nor necessary.\n\nBelarus, Kazakhstan, and Ukraine are not coded as possessing nuclear weapons because they never had operational control of the nuclear weapons left over from the Soviet Union.\n\nYou can read more about specific countries in the profiles by Bleek (2017) and the Nuclear Threat Initiative (2022) by following the links.\n\nYou can download the code and complete dataset, including supplementary variables, from GitHub: https://github.com/owid/notebooks/tree/main/BastianHerre/nuclear_weapons", "dataPublishedBy": "Our World in Data, Bastian Herre", "dataPublisherSource": "Data comes from Bleek (2017), with supplementary information from the Nuclear Threat Initiative (2022) for recent years." }	2022-02-25 18:16:53	2022-02-25 18:16:53	Nuclear weapons proliferation – OWID based on Bleek (2017), Nuclear Threat Initiative (2022) 5538	This dataset provides information on nuclear weapons states, using data from Bleek (2017), which we double-checked with information from the Nuclear Threat Initiative (2022) for recent years. The dataset distinguishes between countries not considering (score 0), considering (score of 1), pursuing (score 2), possessing nuclear weapons (score 3). A country is coded as not considering nuclear weapons if it neither considers, pursues, or possesses nuclear weapons. A country is coded as considering nuclear weapons if its leaders explore whether it is possible and desirable for them to attempt to acquire nuclear weapons, or they work to increase their nuclear weapons capabilities, but without launching a dedicated program. A country is coded as pursuing nuclear weapons if it has an active program to acquire nuclear weapons or to obtain the ability to construct them on short notice. A country is coded as possessing nuclear weapons if it has a nuclear-explosive device that it can deliver. Conducting an explosive nuclear test is therefore neither sufficient nor necessary. Belarus, Kazakhstan, and Ukraine are not coded as possessing nuclear weapons because they never had operational control of the nuclear weapons left over from the Soviet Union. You can read more about specific countries in the profiles by Bleek (2017) and the Nuclear Threat Initiative (2022) by following the links. You can download the code and complete dataset, including supplementary variables, from GitHub: https://github.com/owid/notebooks/tree/main/BastianHerre/nuclear_weapons	https://www.belfercenter.org/sites/default/files/files/publication/When%20Did%20%28and%20Didn%27t%29%20States%20Proliferate%3F_1.pdf; https://www.nti.org/countries/	Our World in Data, Bastian Herre

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