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

6 rows where sourceId = 29464 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
802582 17.18.3 - Countries with national statistical plans that are under implementation (1 = YES; 0 = NO) - SG_STT_NSDSIMPL number Countries with national statistical plans that are under implementation (1 = YES; 0 = NO) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-18-03.pdf 2023-08-17 17:14:00 2024-07-08 16:16:46     2019-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 PARIS21 SDG Survey via United Nations Global SDG Database 29464   
{
    "unit": "number"
}
 0     _17_18_3__sg_stt_nsdsimpl grapher/un/2023-08-16/un_sdg/_17_18_3__sg_stt_nsdsimpl#_17_18_3__sg_stt_nsdsimpl   1                 
[]
         int 
[]
 5ab07abad60d5a06f3962f3f2a763fa4 61958fd4a67e60bd1e81c39f8842b363
802581 17.18.3 - Countries with national statistical plans that are fully funded (1 = YES; 0 = NO) - SG_STT_NSDSFND number Countries with national statistical plans that are fully funded (1 = YES; 0 = NO) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-18-03.pdf 2023-08-17 17:13:59 2024-07-08 16:16:46     2019-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 PARIS21 SDG Survey via United Nations Global SDG Database 29464   
{
    "unit": "number"
}
 0     _17_18_3__sg_stt_nsdsfnd grapher/un/2023-08-16/un_sdg/_17_18_3__sg_stt_nsdsfnd#_17_18_3__sg_stt_nsdsfnd   1                 
[]
         int 
[]
 a5fe17a56fa8c6121ca842550ce5b034 3649aa57d27d4e68cb1f314b23d4c5d3
802580 17.18.3 - Countries with national statistical plans with funding from others (1 = YES; 0 = NO) - SG_STT_NSDSFDOTHR number Countries with national statistical plans with funding from others (1 = YES; 0 = NO) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-18-03.pdf 2023-08-17 17:13:59 2024-07-08 16:16:46     2019-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 PARIS21 SDG Survey via United Nations Global SDG Database 29464   
{
    "unit": "number"
}
 0     _17_18_3__sg_stt_nsdsfdothr grapher/un/2023-08-16/un_sdg/_17_18_3__sg_stt_nsdsfdothr#_17_18_3__sg_stt_nsdsfdothr   1                 
[]
         int 
[]
 f421603e1fde5de473e92ce526694b27 02fea84709d670c484b67a3eaedf9997
802579 17.18.3 - Countries with national statistical plans with funding from Government (1 = YES; 0 = NO) - SG_STT_NSDSFDGVT number Countries with national statistical plans with funding from Government (1 = YES; 0 = NO) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-18-03.pdf 2023-08-17 17:13:58 2024-07-08 16:16:46     2019-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 PARIS21 SDG Survey via United Nations Global SDG Database 29464   
{
    "unit": "number"
}
 0     _17_18_3__sg_stt_nsdsfdgvt grapher/un/2023-08-16/un_sdg/_17_18_3__sg_stt_nsdsfdgvt#_17_18_3__sg_stt_nsdsfdgvt   1                 
[]
         int 
[]
 1d2636b280aab90749d362fc887a3b80 92609fd033c89864410ad37a13c97d7b
802578 17.18.3 - Countries with national statistical plans with funding from donors (1 = YES; 0 = NO) - SG_STT_NSDSFDDNR number Countries with national statistical plans with funding from donors (1 = YES; 0 = NO) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-18-03.pdf 2023-08-17 17:13:58 2024-07-08 16:16:46     2019-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 PARIS21 SDG Survey via United Nations Global SDG Database 29464   
{
    "unit": "number"
}
 0     _17_18_3__sg_stt_nsdsfddnr grapher/un/2023-08-16/un_sdg/_17_18_3__sg_stt_nsdsfddnr#_17_18_3__sg_stt_nsdsfddnr   1                 
[]
         int 
[]
 5ae27733dfcc32d3ac1f789ef44d21a2 3c1d187ab7914c84e447ab250b176015
802577 17.18.2 - Countries with national statistical legislation exists that complies with the Fundamental Principles of Official Statistics (1 = YES; 0 = NO) - SG_STT_FPOS number Countries with national statistical legislation exists that complies with the Fundamental Principles of Official Statistics (1 = YES; 0 = NO) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-18-02.pdf 2023-08-17 17:13:57 2024-07-08 16:16:46     2019-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 PARIS21 SDG Survey via United Nations Global SDG Database 29464   
{
    "unit": "number"
}
 0     _17_18_2__sg_stt_fpos grapher/un/2023-08-16/un_sdg/_17_18_2__sg_stt_fpos#_17_18_2__sg_stt_fpos   1                 
[]
         int 
[]
 a265a5cac456cb5cb005dc736675d44b e5346838a80787c5ed6971f6c7fa3520

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