owid: variables: 3 rows where datasetId = 5659 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

3 rows where datasetId = 5659 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	sourceId	display	schemaVersion
450402	democracy_satisf_low_claassen	The variable denotes the lower-bound estimate of the average extent to which citizens are satisfied with democracy in their own country. It combines responses across more than one thousand nationally-representative surveys on how citizens' satisfaction with democracy. An examples of a survey questions is: "On the whole, how satisfied or dissatisfied are you with the way democracy works in [own country]?" Responses above the median were considered as satisfaction with democracy. Dissatisfied respondents may have actively expressed dissatisfaction with democracy, may have given an indifferent answer, may have answered "I don't know", or may not have responded at all. The variable matches Claassen's variable satis_l95. Higher scores indicate more satisfaction. Positive scores mean that citizen satisfaction with democracy is higher than the average across all countries and years. A score of 1 means that citizen support lies one standard deviation above the average support.	2022-07-18 16:14:21	2023-06-15 05:05:42	Democratic satisfaction - Claassen 5659	Claassen (2022) 22719	{ "includeInTable": true }	1
450401	democracy_satisf_high_claassen	The variable denotes the upper-bound estimate of the average extent to which citizens are satisfied with democracy in their own country. It combines responses across more than one thousand nationally-representative surveys on how citizens' satisfaction with democracy. An examples of a survey questions is: "On the whole, how satisfied or dissatisfied are you with the way democracy works in [own country]?" Responses above the median were considered as satisfaction with democracy. Dissatisfied respondents may have actively expressed dissatisfaction with democracy, may have given an indifferent answer, may have answered "I don't know", or may not have responded at all. The variable matches Claassen's variable satis_u95. Higher scores indicate more satisfaction. Positive scores mean that citizen satisfaction with democracy is higher than the average across all countries and years. A score of 1 means that citizen support lies one standard deviation above the average support.	2022-07-18 16:14:21	2023-06-15 05:05:42	Democratic satisfaction - Claassen 5659	Claassen (2022) 22719	{ "includeInTable": true }	1
450400	democracy_satisf_claassen	The variable denotes the central estimate of the average extent to which citizens are satisfied with democracy in their own country. It combines responses across more than one thousand nationally-representative surveys on how citizens' satisfaction with democracy. An examples of a survey questions is: "On the whole, how satisfied or dissatisfied are you with the way democracy works in [own country]?" Responses above the median were considered as satisfaction with democracy. Dissatisfied respondents may have actively expressed dissatisfaction with democracy, may have given an indifferent answer, may have answered "I don't know", or may not have responded at all. The variable matches Claassen's variable satis. Higher scores indicate more satisfaction. Positive scores mean that citizen satisfaction with democracy is higher than the average across all countries and years. A score of 1 means that citizen support lies one standard deviation above the average support.	2022-07-18 16:14:21	2023-06-15 05:05:42	Democratic satisfaction - Claassen 5659	Claassen (2022) 22719	{ "name": "Citizen satisfaction with democracy", "includeInTable": true }	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");