owid: variables: 4 rows where datasetId = 6646 sorted by id descending

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

4 rows where datasetId = 6646 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	unit	createdAt	updatedAt	timespan	datasetId	shortUnit	display	shortName	catalogPath	schemaVersion	processingLevel	titlePublic	descriptionShort	descriptionFromProducer	descriptionKey	type	sort	dataChecksum	metadataChecksum
959843	Military expenditure (% of GDP)	% of GDP	2024-07-30 12:02:09	2024-07-30 12:02:10	1948-2023	SIPRI Military Expenditure Database 6646	%	{ "name": "Military expenditure (% of GDP)", "unit": "% of GDP", "shortUnit": "%", "tolerance": 5, "numDecimalPlaces": 1 }	share_gdp	grapher/sipri/2024-07-08/military_expenditure/military_expenditure#share_gdp	2	minor	Military expenditure (% of GDP)	Includes military and civil personnel, operation and maintenance, procurement, military research and development, infrastructure, and aid. Civil defense and current expenditures for previous military activities are excluded.	Although the lack of sufficiently detailed data makes it difficult to apply a common definition of military expenditure on a worldwide basis, SIPRI has adopted a definition as a guideline. Where possible, SIPRI military expenditure data include all current and capital expenditure on: (a) the armed forces, including peacekeeping forces; (b) defence ministries and other government agencies engaged in defence projects; (c) paramilitary forces, when judged to be trained and equipped for military operations; and (d) military space activities. This should include expenditure on: i. personnel, including: a. salaries of military and civil personnel; b. retirement pensions of military personnel, and; c. social services for personnel; ii. operations and maintenance; iii. procurement; iv. military research and development; v. military infrastructure spending, including military bases. and; vi. military aid (in the military expenditure of the donor country). SIPRI’s estimate of military aid includes financial contributions, training and operational costs, replacement costs of the military equipment stocks donated to recipients and payments to procure additional military equipment for the recipient. However, it does not include the estimated value of military equipment stocks donated. Civil defence and current expenditures on previous military activities, such as veterans' benefits, demobilization, conversion and weapon destruction are excluded. In practice it is not possible to apply this definition for all countries, and in many cases SIPRI is confined to using the national data provided. Priority is then given to the choice of a uniform definition over time for each country in order to achieve consistency over time, rather than to adjusting the figures for single years according to a common definition. In the light of these difficulties, military expenditure data is most appropriately used for comparisons over time, and may be less suitable for close comparison between individual countries. Reference should always be made,…	[]	float	[]	041744f5debc4ed041ebd0ab3092668b	6dbec264eebdc872fae1e6660310cd84
959842	Military expenditure (% of government spending)	% of government spending	2024-07-30 12:02:09	2024-07-30 12:02:10	1988-2023	SIPRI Military Expenditure Database 6646	%	{ "name": "Military expenditure (% of government spending)", "unit": "% of government spending", "shortUnit": "%", "tolerance": 5, "numDecimalPlaces": 1 }	share_govt_spending	grapher/sipri/2024-07-08/military_expenditure/military_expenditure#share_govt_spending	2	minor	Military expenditure (% of government spending)	Includes military and civil personnel, operation and maintenance, procurement, military research and development, infrastructure, and aid. Civil defense and current expenditures for previous military activities are excluded.	Although the lack of sufficiently detailed data makes it difficult to apply a common definition of military expenditure on a worldwide basis, SIPRI has adopted a definition as a guideline. Where possible, SIPRI military expenditure data include all current and capital expenditure on: (a) the armed forces, including peacekeeping forces; (b) defence ministries and other government agencies engaged in defence projects; (c) paramilitary forces, when judged to be trained and equipped for military operations; and (d) military space activities. This should include expenditure on: i. personnel, including: a. salaries of military and civil personnel; b. retirement pensions of military personnel, and; c. social services for personnel; ii. operations and maintenance; iii. procurement; iv. military research and development; v. military infrastructure spending, including military bases. and; vi. military aid (in the military expenditure of the donor country). SIPRI’s estimate of military aid includes financial contributions, training and operational costs, replacement costs of the military equipment stocks donated to recipients and payments to procure additional military equipment for the recipient. However, it does not include the estimated value of military equipment stocks donated. Civil defence and current expenditures on previous military activities, such as veterans' benefits, demobilization, conversion and weapon destruction are excluded. In practice it is not possible to apply this definition for all countries, and in many cases SIPRI is confined to using the national data provided. Priority is then given to the choice of a uniform definition over time for each country in order to achieve consistency over time, rather than to adjusting the figures for single years according to a common definition. In the light of these difficulties, military expenditure data is most appropriately used for comparisons over time, and may be less suitable for close comparison between individual countries. Reference should always be made,…	[]	float	[]	4b1dfee2252898e937352aa910df4569	890194da4539645f051328c04d635536
959841	Military expenditure per capita (current US$)	current US$	2024-07-30 12:02:09	2024-07-30 12:02:11	1988-2023	SIPRI Military Expenditure Database 6646	$	{ "name": "Military expenditure per capita", "unit": "current US$", "shortUnit": "$", "tolerance": 5, "numDecimalPlaces": 0 }	per_capita	grapher/sipri/2024-07-08/military_expenditure/military_expenditure#per_capita	2	minor	Military expenditure per capita	Includes military and civil personnel, operation and maintenance, procurement, military research and development, infrastructure, and aid. Civil defense and current expenditures for previous military activities are excluded. This data is expressed in US dollars. It is not adjusted for inflation or differences in the cost of living between countries.	Figures are in current US$. Although the lack of sufficiently detailed data makes it difficult to apply a common definition of military expenditure on a worldwide basis, SIPRI has adopted a definition as a guideline. Where possible, SIPRI military expenditure data include all current and capital expenditure on: (a) the armed forces, including peacekeeping forces; (b) defence ministries and other government agencies engaged in defence projects; (c) paramilitary forces, when judged to be trained and equipped for military operations; and (d) military space activities. This should include expenditure on: i. personnel, including: a. salaries of military and civil personnel; b. retirement pensions of military personnel, and; c. social services for personnel; ii. operations and maintenance; iii. procurement; iv. military research and development; v. military infrastructure spending, including military bases. and; vi. military aid (in the military expenditure of the donor country). SIPRI’s estimate of military aid includes financial contributions, training and operational costs, replacement costs of the military equipment stocks donated to recipients and payments to procure additional military equipment for the recipient. However, it does not include the estimated value of military equipment stocks donated. Civil defence and current expenditures on previous military activities, such as veterans' benefits, demobilization, conversion and weapon destruction are excluded. In practice it is not possible to apply this definition for all countries, and in many cases SIPRI is confined to using the national data provided. Priority is then given to the choice of a uniform definition over time for each country in order to achieve consistency over time, rather than to adjusting the figures for single years according to a common definition. In the light of these difficulties, military expenditure data is most appropriately used for comparisons over time, and may be less suitable for close comparison between individual countries. Ref…	[]	float	[]	5ac5b371d61df2c40e7b3803b19f726e	5fcea06da450c567e1ec86b710c7b160
959840	Military expenditure (constant US$)	constant 2022 US$	2024-07-30 12:02:09	2024-07-30 12:02:10	1948-2023	SIPRI Military Expenditure Database 6646	$	{ "name": "Military expenditure", "unit": "constant 2022 US$", "shortUnit": "$", "tolerance": 5, "numDecimalPlaces": 0 }	constant_usd	grapher/sipri/2024-07-08/military_expenditure/military_expenditure#constant_usd	2	minor	Military expenditure	Includes military and civil personnel, operation and maintenance, procurement, military research and development, infrastructure, and aid. Civil defense and current expenditures for previous military activities are excluded. This data is expressed in US dollars. It is adjusted for inflation but does not account for differences in the cost of living between countries.	Military expenditure by country, in constant (2022) US$, 1949-2023. Figures are in US$, at constant 2022 prices and exchange rates. Although the lack of sufficiently detailed data makes it difficult to apply a common definition of military expenditure on a worldwide basis, SIPRI has adopted a definition as a guideline. Where possible, SIPRI military expenditure data include all current and capital expenditure on: (a) the armed forces, including peacekeeping forces; (b) defence ministries and other government agencies engaged in defence projects; (c) paramilitary forces, when judged to be trained and equipped for military operations; and (d) military space activities. This should include expenditure on: i. personnel, including: a. salaries of military and civil personnel; b. retirement pensions of military personnel, and; c. social services for personnel; ii. operations and maintenance; iii. procurement; iv. military research and development; v. military infrastructure spending, including military bases. and; vi. military aid (in the military expenditure of the donor country). SIPRI’s estimate of military aid includes financial contributions, training and operational costs, replacement costs of the military equipment stocks donated to recipients and payments to procure additional military equipment for the recipient. However, it does not include the estimated value of military equipment stocks donated. Civil defence and current expenditures on previous military activities, such as veterans' benefits, demobilization, conversion and weapon destruction are excluded. In practice it is not possible to apply this definition for all countries, and in many cases SIPRI is confined to using the national data provided. Priority is then given to the choice of a uniform definition over time for each country in order to achieve consistency over time, rather than to adjusting the figures for single years according to a common definition. In the light of these difficulties, military expenditure data is most appropriately used fo…	[]	float	[]	5dc1b61aed83b1b36d5def6c8eca4c4d	8459f8790ec8f6cae3b0568c88b2bf9d

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE "variables" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(750) NULL  ,
	"unit" VARCHAR(255) NOT NULL  ,
	"description" TEXT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"code" VARCHAR(255) NULL  ,
	"coverage" VARCHAR(255) NOT NULL  ,
	"timespan" VARCHAR(255) NOT NULL  ,
	"datasetId" INTEGER NOT NULL  ,
	"sourceId" INTEGER NULL  ,
	"shortUnit" VARCHAR(255) NULL  ,
	"display" TEXT NOT NULL  ,
	"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
	"originalMetadata" TEXT NULL  ,
	"grapherConfigAdmin" TEXT NULL  ,
	"shortName" VARCHAR(255) NULL  ,
	"catalogPath" VARCHAR(767) NULL  ,
	"dimensions" TEXT NULL  ,
	"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
	"processingLevel" VARCHAR(30) NULL  ,
	"processingLog" TEXT NULL  ,
	"titlePublic" VARCHAR(512) NULL  ,
	"titleVariant" VARCHAR(255) NULL  ,
	"attributionShort" VARCHAR(512) NULL  ,
	"attribution" TEXT NULL  ,
	"descriptionShort" TEXT NULL  ,
	"descriptionFromProducer" TEXT NULL  ,
	"descriptionKey" TEXT NULL  ,
	"descriptionProcessing" TEXT NULL  ,
	"licenses" TEXT NULL  ,
	"license" TEXT NULL  ,
	"grapherConfigETL" TEXT NULL  ,
	"type" TEXT NULL  ,
	"sort" TEXT NULL  ,
	"dataChecksum" VARCHAR(64) NULL  ,
	"metadataChecksum" VARCHAR(64) NULL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");