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

4 rows where sourceId = 29467 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, updatedAt, timespan, display, type, 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
804376 9.1.2 - Freight loaded and unloaded, maritime transport (metric tons) - IS_RDP_LULFRG metric tons Freight loaded and unloaded, maritime transport (metric tons) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-09-01-02.pdf 2023-08-17 17:27:52 2024-07-08 16:18:57     2010-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Conference on Trade and Development 29467   
{
    "unit": "metric tons"
}
 0     _9_1_2__is_rdp_lulfrg grapher/un/2023-08-16/un_sdg/_9_1_2__is_rdp_lulfrg#_9_1_2__is_rdp_lulfrg   1                 
[]
         int 
[]
 b6cfdf5ae3e3f82a9012321305173f3e 6fdbb5881380ef633acdbcedadb3f937
802612 17.5.1 - Number of countries with a signed bilateral investment treaty (BIT) with least developed countries and developing countries (Number) - SG_CPA_SIGN_BIT number Number of countries with a signed bilateral investment treaty (BIT) with least developed countries and developing countries (Number) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-05-01.pdf 2023-08-17 17:14:14 2024-07-08 16:16:48     1959-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Conference on Trade and Development 29467   
{
    "unit": "number"
}
 0     _17_5_1__sg_cpa_sign_bit grapher/un/2023-08-16/un_sdg/_17_5_1__sg_cpa_sign_bit#_17_5_1__sg_cpa_sign_bit   1                 
[]
         int 
[]
 84dd73089b21ccbe5c0d8749af7ee600 36f3806956287be833822a86dcf22ed2
802611 17.5.1 - Number of countries with an in-force bilateral investment treaty (BIT) with least developed countries and developing countries (Number) - SG_CPA_INFORCE_BIT number Number of countries with an in-force bilateral investment treaty (BIT) with least developed countries and developing countries (Number) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-05-01.pdf 2023-08-17 17:14:13 2024-07-08 16:16:48     1959-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Conference on Trade and Development 29467   
{
    "unit": "number"
}
 0     _17_5_1__sg_cpa_inforce_bit grapher/un/2023-08-16/un_sdg/_17_5_1__sg_cpa_inforce_bit#_17_5_1__sg_cpa_inforce_bit   1                 
[]
         int 
[]
 f2b1a01dd6ea5b6d2f5476a100e59c48 e13144e8c57e833c1091d4aad49b61ab
802608 17.3.1 - Foreign direct investment (FDI) inflows (millions of United States dollars) - GF_FRN_FDI millions of current united states dollars Foreign direct investment (FDI) inflows (millions of United States dollars) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-03-01.pdf 2023-08-17 17:14:12 2024-07-08 16:16:48     1990-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Conference on Trade and Development 29467   
{
    "unit": "millions of current united states dollars"
}
 0     _17_3_1__gf_frn_fdi grapher/un/2023-08-16/un_sdg/_17_3_1__gf_frn_fdi#_17_3_1__gf_frn_fdi   1                 
[]
         float 
[]
 10b23f72eadeee657832f71db054d188 3397d7490e5138f62e2471084a6bb509

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