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 = 29475 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
803643 5.1.1 - Legal frameworks that promote, enforce and monitor gender equality (percentage of achievement, 0 - 100) -- Area 2: violence against women - SG_LGL_GENEQVAW % Legal frameworks that promote, enforce and monitor gender equality (percentage of achievement, 0 - 100) -- Area 2: violence against women Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-05-01-01.pdf 2023-08-17 17:22:13 2024-07-08 16:18:04     2018-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Women 29475 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _5_1_1__sg_lgl_geneqvaw grapher/un/2023-08-16/un_sdg/_5_1_1__sg_lgl_geneqvaw#_5_1_1__sg_lgl_geneqvaw   1                 
[]
         float 
[]
 fc7fec77a8c0b8f73cbe5137c4fb3446 c28025416f838d2a13c01f6c8edc426d
803642 5.1.1 - Legal frameworks that promote, enforce and monitor gender equality (percentage of achievement, 0 - 100) -- Area 4: marriage and family - SG_LGL_GENEQMAR % Legal frameworks that promote, enforce and monitor gender equality (percentage of achievement, 0 - 100) -- Area 4: marriage and family Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-05-01-01.pdf 2023-08-17 17:22:13 2024-07-08 16:18:04     2018-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Women 29475 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _5_1_1__sg_lgl_geneqmar grapher/un/2023-08-16/un_sdg/_5_1_1__sg_lgl_geneqmar#_5_1_1__sg_lgl_geneqmar   1                 
[]
         float 
[]
 28d8c8c5ca1f2e89fade549f0752b0f0 2f50855ce0b27e40c96892d2057b45e1
803641 5.1.1 - Legal frameworks that promote, enforce and monitor gender equality (percentage of achievement, 0 - 100) -- Area 1: overarching legal frameworks and public life - SG_LGL_GENEQLFP % Legal frameworks that promote, enforce and monitor gender equality (percentage of achievement, 0 - 100) -- Area 1: overarching legal frameworks and public life Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-05-01-01.pdf 2023-08-17 17:22:12 2024-07-08 16:18:04     2018-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Women 29475 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _5_1_1__sg_lgl_geneqlfp grapher/un/2023-08-16/un_sdg/_5_1_1__sg_lgl_geneqlfp#_5_1_1__sg_lgl_geneqlfp   1                 
[]
         float 
[]
 d60c045faa39fd18474e38ede7df3f4f ef3e3fe7d2ded01e25d7a29101a20301
803640 5.1.1 - Legal frameworks that promote, enforce and monitor gender equality (percentage of achievement, 0 - 100) -- Area 3: employment and economic benefits - SG_LGL_GENEQEMP % Legal frameworks that promote, enforce and monitor gender equality (percentage of achievement, 0 - 100) -- Area 3: employment and economic benefits Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-05-01-01.pdf 2023-08-17 17:22:12 2024-07-08 16:18:04     2018-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Women 29475 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _5_1_1__sg_lgl_geneqemp grapher/un/2023-08-16/un_sdg/_5_1_1__sg_lgl_geneqemp#_5_1_1__sg_lgl_geneqemp   1                 
[]
         float 
[]
 3b1f368d531fb48fe1df5a2ee9d8695f 400dc933972da641a9f17b415e97053e

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