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

31 rows where datasetId = 5653 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display, 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
450281 Trade openness (share of exports and imports in GDP)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Trade openness",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
450280 Productivity: output per hour worked     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Productivity: output per hour worked",
    "unit": "International-$ (at 2017 prices) per hour",
    "shortUnit": "$/h",
    "includeInTable": true
}
 0           1                                  
450279 GDP per capita (using national accounts growth rates)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "GDP per capita",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450278 GDP per capita (output, single price benchmark)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "GDP per capita",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450277 GDP per capita (expenditure, single price benchmark)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "GDP per capita",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450276 GDP per capita (output, multiple price benchmarks)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "GDP per capita",
    "unit": "constant 2017 international-$",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450275 GDP per capita (expenditure, multiple price benchmarks)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "GDP per capita",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450274 Share of residual trade and GDP statistical discrepancy in GDP     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Share of residual trade and GDP statistical discrepancy in GDP",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
450273 Share of merchandise imports in GDP     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Share of merchandise imports in GDP",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
450272 Share of merchandise exports in GDP     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Share of merchandise exports in GDP",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
450271 Share of government consumption in GDP     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Share of government consumption in GDP",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
450270 Share of gross capital formation in GDP     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Share of gross capital formation in GDP",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
450269 Share of household consumption in GDP     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Share of household consumption in GDP",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
450268 Average depreciation rate of the capital stock     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Average depreciation rate of the capital stock",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
450267 Real internal rate of return     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Real internal rate of return",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
450266 Share of labour compensation in GDP     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Share of labour compensation in GDP",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
450265 Total factor productivity index (using national accounts) (2017=1)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "TFP index",
    "includeInTable": true
}
 0           1                                  
450264 Capital stock (using national accounts)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Capital stock",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450263 Domestic absorption (consumption plus investment) (using national accounts)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Consumption plus investment",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450262 Consumption of households and government (using national accounts)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Consumption of households and government",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450261 GDP (using national accounts growth rates)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "GDP",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450260 Capital stock (single price benchmark)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Capital stock",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450259 GDP (output, single price benchmark)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "GDP",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450258 GDP (expenditure, single price benchmark)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "GDP",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450257 Domestic absorption (consumption plus investment) (single price benchmark)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Consumption plus investment",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450256 Consumption of households and government (single price benchmark)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Consumption of households and government",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450255 Annual working hours per worker     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Annual working hours",
    "unit": "Hours",
    "shortUnit": "h",
    "includeInTable": true
}
 0           1                                  
450254 Number of people in work     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Number of people in work",
    "unit": "People in work",
    "shortUnit": "p",
    "includeInTable": true
}
 0           1                                  
450253 Population     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "Population",
    "unit": "People",
    "shortUnit": "p",
    "includeInTable": true
}
 0           1                                  
450252 GDP (output, multiple price benchmarks)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "GDP",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
450251 GDP (expenditure, multiple price benchmarks)     2022-07-12 16:47:20 2023-06-15 05:05:42       Penn World Table version 10.0 5653 Feenstra et al. (2015), Penn World Table 10.0 22713   
{
    "name": "GDP",
    "unit": "International-$ (at 2017 prices)",
    "shortUnit": "$",
    "includeInTable": true
}
 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");