variables

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 datasetId = 5533 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name unit description createdAt updatedAt code coverage timespan datasetId sourceId shortUnit display columnOrder originalMetadata grapherConfigAdmin shortName catalogPath dimensions schemaVersion processingLevel processingLog titlePublic titleVariant attributionShort attribution descriptionShort descriptionFromProducer descriptionKey descriptionProcessing licenses license grapherConfigETL type sort dataChecksum metadataChecksum
411768 military_expenditure_share_gdp   Our data on military expenditure as a share of GDP is imported from the SIPRI Military Expenditure Database, Stockholm International Peace Research Institute (SIPRI), https://www.sipri.org/databases/milex 2022-02-24 15:39:47 2023-06-15 05:05:42       Military expenditure - OWID based on CoW & SIPRI 5533 Correlates of War Project, Stockholm International Peace Research Institute, MeasuringWorth 21931   
{
    "name": "Military expenditure as a share of GDP",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
411767 military_expenditure_per_capita   Our team builds and maintains a long-run dataset on military expenditure by country, region, and for the world, based on two key sources: - 1816 to 2016: National Material Capabilities dataset, Correlates of War Project, https://correlatesofwar.org/data-sets/national-material-capabilities - 2017 onwards: SIPRI Military Expenditure Database, Stockholm International Peace Research Institute (SIPRI), https://www.sipri.org/databases/milex For the period 1816 to 1913, expenditures in the Correlates of War project are expressed in current-year British Pounds. Values are transformed to current-year US Dollars based on exchanges rates downloaded from the MeasuringWorth project: Lawrence H. Officer, 'Dollar-Pound Exchange Rate From 1791,' MeasuringWorth, 2022. URL: https://www.measuringworth.com/datasets/exchangepound/ 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/ Military expenditure per capita is calculated by dividing our long-run dataset on military expenditure, by our long-run dataset on population (<a href="https://ourworldindata.org/population-sources">What are the sources for Our World in Data’s population estimates?</a>). 2022-02-24 15:14:37 2023-06-15 05:05:42       Military expenditure - OWID based on CoW & SIPRI 5533 Correlates of War Project, Stockholm International Peace Research Institute, MeasuringWorth 21931   
{
    "name": "Military expenditure per capita",
    "unit": "2020 US Dollars",
    "shortUnit": "$",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
411765 military_expenditure   Our team builds and maintains a long-run dataset on military expenditure by country, region, and for the world, based on two key sources: - 1816 to 2016: National Material Capabilities dataset, Correlates of War Project, https://correlatesofwar.org/data-sets/national-material-capabilities - 2017 onwards: SIPRI Military Expenditure Database, Stockholm International Peace Research Institute (SIPRI), https://www.sipri.org/databases/milex For the period 1816 to 1913, expenditures in the Correlates of War project are expressed in current-year British Pounds. Values are transformed to current-year US Dollars based on exchanges rates downloaded from the MeasuringWorth project: Lawrence H. Officer, 'Dollar-Pound Exchange Rate From 1791,' MeasuringWorth, 2022. URL: https://www.measuringworth.com/datasets/exchangepound/ 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 14:09:03 2023-06-15 05:05:42       Military expenditure - OWID based on CoW & SIPRI 5533 Correlates of War Project, Stockholm International Peace Research Institute, MeasuringWorth 21931   
{
    "name": "Military expenditure",
    "unit": "2020 US Dollars",
    "shortUnit": "$",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  

Advanced export

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

CSV options: 

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