owid: variables: 3 rows where sourceId = 21930 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

3 rows where sourceId = 21930 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	sourceId	display	schemaVersion
411764	military_personnel_share	Notes and definitions as provided by the source. 1. Military personnel estimates include active, regular military units of the land, naval, and air components. Troops in the reserves such as those found in the United States were not included in the state’s annual total. Colonial troops (such as Indian troops under British command during India’s colonial period) were usually not included in this total if they were a separately administered force. 2. The military personnel data exclude the military forces of foreign military forces, semi-autonomous states and protectorates, and insurgent troops. Such units were not part of a regular national armed force under a military chain of command. Their inclusion would distort the number of personnel that could be summoned when deemed necessary. 3. Figures reflect the project's best judgment on which forces were intended for combat with foreign parties. Irregular forces such as civil defense units, frontier guards, gendarmerie, carabinieri, and other quasi-military units were nominally responsible for defending outlying districts or for internal security and could be mobilized in times of war. We usually excluded them, however, because they were not integral to the regular armed forces (e.g. Cossack troops of nineteenth-century Russia). When these forces were the only military a nation had they were still excluded (e.g. Costa Rica and Switzerland). 4. Armed forces in several semi-feudal nations, including the warlord armies in pre-modern Japan and China, and Jannissary troops in the Ottoman Empire: We counted only those forces that were acting at the behest of the central government. For example, we included only the Imperial troops and those armies of feudal lords operating on the behalf of the throne in the case of pre-modern Japan. 5. National police forces organized for both foreign and domestic purposes and found in several developing nations in the twentieth century: Such units come directly under the military chain of command and are fully a part of the armed for…	2022-02-24 09:58:20	2023-06-15 05:05:42	Correlates of War (CoW) - National Material Capabilities 5532	Correlates of War Project - National Material Capabilities 21930	{ "name": "Military personnel as a share of total population", "unit": "%", "shortUnit": "%", "includeInTable": true, "numDecimalPlaces": 2 }	1
411763	military_expenditure_post1914	Military expenditure is adjusted for inflation and expressed in 2020 US Dollars. Prices are adjusted over time based on the annual Consumer Price Index (CPI) for the United States since 1914, downloaded from the MeasuringWorth project. Lawrence H. Officer and Samuel H. Williamson, "The Annual Consumer Price Index for the United States, 1774-Present," MeasuringWorth, 2022. URL: http://www.measuringworth.com/uscpi/	2022-02-24 09:58:20	2023-06-15 05:05:42	Correlates of War (CoW) - National Material Capabilities 5532	Correlates of War Project - National Material Capabilities 21930	{ "name": "Military expenditure", "unit": "2020 US-$", "shortUnit": "$", "includeInTable": true }	1
411761	military_personnel	Notes and definitions as provided by the source. 1. Military personnel estimates include active, regular military units of the land, naval, and air components. Troops in the reserves such as those found in the United States were not included in the state’s annual total. Colonial troops (such as Indian troops under British command during India’s colonial period) were usually not included in this total if they were a separately administered force. 2. The military personnel data exclude the military forces of foreign military forces, semi-autonomous states and protectorates, and insurgent troops. Such units were not part of a regular national armed force under a military chain of command. Their inclusion would distort the number of personnel that could be summoned when deemed necessary. 3. Figures reflect the project's best judgment on which forces were intended for combat with foreign parties. Irregular forces such as civil defense units, frontier guards, gendarmerie, carabinieri, and other quasi-military units were nominally responsible for defending outlying districts or for internal security and could be mobilized in times of war. We usually excluded them, however, because they were not integral to the regular armed forces (e.g. Cossack troops of nineteenth-century Russia). When these forces were the only military a nation had they were still excluded (e.g. Costa Rica and Switzerland). 4. Armed forces in several semi-feudal nations, including the warlord armies in pre-modern Japan and China, and Jannissary troops in the Ottoman Empire: We counted only those forces that were acting at the behest of the central government. For example, we included only the Imperial troops and those armies of feudal lords operating on the behalf of the throne in the case of pre-modern Japan. 5. National police forces organized for both foreign and domestic purposes and found in several developing nations in the twentieth century: Such units come directly under the military chain of command and are fully a part of the armed for…	2022-02-24 09:58:20	2023-06-15 05:05:42	Correlates of War (CoW) - National Material Capabilities 5532	Correlates of War Project - National Material Capabilities 21930	{ "name": "Military personnel", "includeInTable": true }	1

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