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

8 rows where datasetId = 2708 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, 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
97468 Share of world merchandise trade - non-rich to non-rich (Fouquin and Hugot; CEPII 2016, Dyadic data) % The non-rich to non-rich trade series shows the proportion of merchandise exports that are exported from non-rich countries to other non-rich countries as a share of total world exports. Calculations use Fouquin and Hugot (CEPII 2016) dyadic trade data. 'Non-rich' countries are all countries in the world except: Australia, Austria, Belgium, Canada, Cyprus, Denmark, Finland, France, Germany, Greece, Iceland,Ireland, Israel, Italy, Japan, Luxembourg, Netherlands, Norway, Portugal, Spain, Sweden, Switzerland, United Kingdom, United States. 2018-05-02 13:52:37 2023-06-15 05:05:42       Share of world merchandise trade by type of trade - Fouquin and Hugot (CEPII 2016, Dyadic data) 2708 Fouquin and Hugot (CEPII 2016) 15440   
{}
 0           1                                  
97467 Share of world merchandise trade - non-rich to rich (Fouquin and Hugot; CEPII 2016, Dyadic data) % The non-rich to rich trade series shows the proportion of merchandise exports that are exported from non-rich countries to rich countries as a share of total world exports. Calculations use Fouquin and Hugot (CEPII 2016) dyadic trade data. 'Non-rich' countries are all countries in the world except: Australia, Austria, Belgium, Canada, Cyprus, Denmark, Finland, France, Germany, Greece, Iceland,Ireland, Israel, Italy, Japan, Luxembourg, Netherlands, Norway, Portugal, Spain, Sweden, Switzerland, United Kingdom, United States. 2018-05-02 13:52:37 2023-06-15 05:05:42       Share of world merchandise trade by type of trade - Fouquin and Hugot (CEPII 2016, Dyadic data) 2708 Fouquin and Hugot (CEPII 2016) 15440   
{}
 0           1                                  
97466 Share of world merchandise trade - rich to non-rich (Fouquin and Hugot; CEPII 2016, Dyadic data) % The rich to non-rich trade series shows the proportion of merchandise exports that are exported from rich countries to non-rich countries as a share of total world exports. Calculations use Fouquin and Hugot (CEPII 2016) dyadic trade data. 'Non-rich' countries are all countries in the world except: Australia, Austria, Belgium, Canada, Cyprus, Denmark, Finland, France, Germany, Greece, Iceland,Ireland, Israel, Italy, Japan, Luxembourg, Netherlands, Norway, Portugal, Spain, Sweden, Switzerland, United Kingdom, United States. 2018-05-02 13:52:37 2023-06-15 05:05:42       Share of world merchandise trade by type of trade - Fouquin and Hugot (CEPII 2016, Dyadic data) 2708 Fouquin and Hugot (CEPII 2016) 15440   
{}
 0           1                                  
97465 Share of world merchandise trade - rich to rich (Fouquin and Hugot; CEPII 2016, Dyadic data) % The rich to rich trade series shows the proportion of merchandise exports that are exported from rich countries to other rich countries as a share of total world exports. Calculations use Fouquin and Hugot (CEPII 2016) dyadic trade data. 'Non-rich' countries are all countries in the world except: Australia, Austria, Belgium, Canada, Cyprus, Denmark, Finland, France, Germany, Greece, Iceland,Ireland, Israel, Italy, Japan, Luxembourg, Netherlands, Norway, Portugal, Spain, Sweden, Switzerland, United Kingdom, United States. 2018-05-02 13:52:37 2023-06-15 05:05:42       Share of world merchandise trade by type of trade - Fouquin and Hugot (CEPII 2016, Dyadic data) 2708 Fouquin and Hugot (CEPII 2016) 15440   
{}
 0           1                                  
96428 Value of world merchandise trade - non-rich to non-rich (Fouquin and Hugot; CEPII 2016, Dyadic data) £ The value of world merchandise trade exports from non-rich to non-rich countries. Calculations use Fouquin and Hugot (CEPII 2016) dyadic trade data. 'Non-rich' countries are all countries in the world except: Australia, Austria, Belgium, Canada, Cyprus, Denmark, Finland, France, Germany, Greece, Iceland,Ireland, Israel, Italy, Japan, Luxembourg, Netherlands, Norway, Portugal, Spain, Sweden, Switzerland, United Kingdom, United States. 2018-03-28 14:28:06 2023-06-15 05:05:42       Share of world merchandise trade by type of trade - Fouquin and Hugot (CEPII 2016, Dyadic data) 2708 Fouquin and Hugot (CEPII 2016) 15440   
{}
 0           1                                  
96427 Value of world merchandise trade - non-rich to rich (Fouquin and Hugot; CEPII 2016, Dyadic data) £ The value of world merchandise trade exports from non-rich to rich countries. Calculations use Fouquin and Hugot (CEPII 2016) dyadic trade data. 'Non-rich' countries are all countries in the world except: Australia, Austria, Belgium, Canada, Cyprus, Denmark, Finland, France, Germany, Greece, Iceland,Ireland, Israel, Italy, Japan, Luxembourg, Netherlands, Norway, Portugal, Spain, Sweden, Switzerland, United Kingdom, United States. 2018-03-28 14:28:06 2023-06-15 05:05:42       Share of world merchandise trade by type of trade - Fouquin and Hugot (CEPII 2016, Dyadic data) 2708 Fouquin and Hugot (CEPII 2016) 15440   
{}
 0           1                                  
96426 Value of world merchandise trade - rich to non-rich (Fouquin and Hugot; CEPII 2016, Dyadic data) £ The value of world merchandise trade exports from rich to non-rich countries. Calculations use Fouquin and Hugot (CEPII 2016) dyadic trade data. 'Non-rich' countries are all countries in the world except: Australia, Austria, Belgium, Canada, Cyprus, Denmark, Finland, France, Germany, Greece, Iceland,Ireland, Israel, Italy, Japan, Luxembourg, Netherlands, Norway, Portugal, Spain, Sweden, Switzerland, United Kingdom, United States. 2018-03-28 14:28:06 2023-06-15 05:05:42       Share of world merchandise trade by type of trade - Fouquin and Hugot (CEPII 2016, Dyadic data) 2708 Fouquin and Hugot (CEPII 2016) 15440   
{}
 0           1                                  
96425 Value of world merchandise trade - rich to rich (Fouquin and Hugot; CEPII 2016, Dyadic data) £ The value of world merchandise trade exports from rich to rich countries. Calculations use Fouquin and Hugot (CEPII 2016) dyadic trade data. 'Non-rich' countries are all countries in the world except: Australia, Austria, Belgium, Canada, Cyprus, Denmark, Finland, France, Germany, Greece, Iceland,Ireland, Israel, Italy, Japan, Luxembourg, Netherlands, Norway, Portugal, Spain, Sweden, Switzerland, United Kingdom, United States. 2018-03-28 14:28:06 2023-06-15 05:05:42       Share of world merchandise trade by type of trade - Fouquin and Hugot (CEPII 2016, Dyadic data) 2708 Fouquin and Hugot (CEPII 2016) 15440   
{}
 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");