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 sourceId = 29459 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: updatedAt, timespan, 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
802555 17.13.1 - Tax revenue as a proportion of GDP (%) - GC_TAX_TOTL_GD_ZS % Tax revenue as a proportion of GDP (%) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-13-01.pdf 2023-08-17 17:13:47 2024-07-08 16:16:44     1972-2020 United Nations Sustainable Development Goals (2023-Q2) 6193 International Monetary Fund (IMF), World Bank and Organisation for Economic Co-operation and Development 29459 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _17_13_1__gc_tax_totl_gd_zs grapher/un/2023-08-16/un_sdg/_17_13_1__gc_tax_totl_gd_zs#_17_13_1__gc_tax_totl_gd_zs   1                 
[]
         float 
[]
 5279560b7cdebe4610fa3b99f3c8913f 12607d20fc61e121c14de1f9b4494af4
802554 17.13.1 - Cash surplus/deficit as a proportion of GDP (%) - GC_BAL_CASH_GD_ZS % Cash surplus/deficit as a proportion of GDP (%) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-13-01.pdf 2023-08-17 17:13:46 2024-07-08 16:16:44     1972-2020 United Nations Sustainable Development Goals (2023-Q2) 6193 International Monetary Fund (IMF), World Bank and Organisation for Economic Co-operation and Development 29459 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _17_13_1__gc_bal_cash_gd_zs grapher/un/2023-08-16/un_sdg/_17_13_1__gc_bal_cash_gd_zs#_17_13_1__gc_bal_cash_gd_zs   1                 
[]
         float 
[]
 bd99c8fcd052398a7fd92d03c4332873 d2909cad01a98bbbf644bfd9fc452136
802546 17.13.1 - Foreign direct investment, net inflows, as a proportion of GDP (%) - BX_KLT_DINV_WD_GD_ZS % Foreign direct investment, net inflows, as a proportion of GDP (%) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-13-01.pdf 2023-08-17 17:13:43 2024-07-08 16:16:43     1970-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 International Monetary Fund (IMF), World Bank and Organisation for Economic Co-operation and Development 29459 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _17_13_1__bx_klt_dinv_wd_gd_zs grapher/un/2023-08-16/un_sdg/_17_13_1__bx_klt_dinv_wd_gd_zs#_17_13_1__bx_klt_dinv_wd_gd_zs   1                 
[]
         float 
[]
 823447f98dc9080a37b8af7d3abe92f8 a732e145b400b591a6329ce04a62aa0c

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