owid: variables: 1 row where datasetId = 2674 sorted by id descending

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

1 row where datasetId = 2674 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
93889	WEO Index overall score (Economist Intelligence Unit (2012))		The Women's Economic Opportunity (WEO) Index measures five categories to determine whether the environment for both women employees and women entrepreneurs is favourable. Five category scores are calculated from the unweighted mean of underlying indicators and scaled 0-100, where 100=most favourable. These categories are: Labor policy and practice (comprising two sub-categories: Labor policy and labor practice); Access to Finance; Education and training; Women's legal and social status; and the General business environment. Each category or sub-category features either four or five underlying indicators. The overall score (from 0-100) is calculated from a simple average of the unweighted category and indicator variables. That is, every indicator contributes equally to their parent category and every category contributes equally to the overall score.	2018-03-22 13:48:41	2023-06-15 05:05:42				Women's Economic Opportunity 2012 - Economist Intelligence Unit (2012) 2674	Women's Economic Opportunity 2012 - Economist Intelligence Unit (2012) 14898		{}	0						1

Advanced export

JSON shape: default, array, newline-delimited, object

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