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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, shortUnit, 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
158718 Women who believe a husband is justified in beating his wife when she refuses sex with him (%)   Percentage of women ages 15-49 who believe a husband/partner is justified in hitting or beating his wife/partner when she refuses sex with him. 2021-08-10 01:59:15 2023-06-15 05:05:42 SG.VAW.REFU.ZS   1999-2020 World Development Indicators - World Bank (2021.07.30) 5357 Data compiled from multiple sources by World Bank 18088   
{}
 0 
{}
         1                                  
158717 Women who believe a husband is justified in beating his wife when she neglects the children (%)   Percentage of women ages 15-49 who believe a husband/partner is justified in hitting or beating his wife/partner when she neglects the children. 2021-08-10 01:59:15 2023-06-15 05:05:42 SG.VAW.NEGL.ZS   1999-2020 World Development Indicators - World Bank (2021.07.30) 5357 Data compiled from multiple sources by World Bank 18088   
{}
 0 
{}
         1                                  
158716 Women who believe a husband is justified in beating his wife when she goes out without telling him (%)   Percentage of women ages 15-49 who believe a husband/partner is justified in hitting or beating his wife/partner when she goes out without telling him. 2021-08-10 01:59:15 2023-06-15 05:05:42 SG.VAW.GOES.ZS   1999-2020 World Development Indicators - World Bank (2021.07.30) 5357 Data compiled from multiple sources by World Bank 18088   
{}
 0 
{}
         1                                  
158715 Women who believe a husband is justified in beating his wife when she burns the food (%)   Percentage of women ages 15-49 who believe a husband/partner is justified in hitting or beating his wife/partner when she burns the food. 2021-08-10 01:59:15 2023-06-15 05:05:42 SG.VAW.BURN.ZS   1999-2020 World Development Indicators - World Bank (2021.07.30) 5357 Data compiled from multiple sources by World Bank 18088   
{}
 0 
{}
         1                                  
158714 Women who believe a husband is justified in beating his wife when she argues with him (%)   Percentage of women ages 15-49 who believe a husband/partner is justified in hitting or beating his wife/partner when she argues with him. 2021-08-10 01:59:15 2023-06-15 05:05:42 SG.VAW.ARGU.ZS   1999-2020 World Development Indicators - World Bank (2021.07.30) 5357 Data compiled from multiple sources by World Bank 18088   
{}
 0 
{}
         1                                  
147800 Women who believe a husband is justified in beating his wife (any of five reasons) (%) % Percentage of women ages 15-49 who believe a husband/partner is justified in hitting or beating his wife/partner for any of the following five reasons: argues with him; refuses to have sex; burns the food; goes out without telling him; or when she neglects the children. 2021-08-09 06:23:32 2023-06-15 05:05:42 SG.VAW.REAS.ZS   1999-2020 World Development Indicators - World Bank (2021.07.30) 5357 Data compiled from multiple sources by World Bank 18088 % 
{}
 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");