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

9 rows where datasetId = 5919 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timespan, 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
576807 Do you think most people try to take advantage of you % % of respondents replying that people "would take advantage" when asked "Do you think most people try to take advantage of you". Possible answers include they "would try to be fair", "would take advantage" and "do not know". 2023-03-10 12:09:27 2023-10-27 12:25:39     2004-2014 Trust questions in the World Values Survey Dataset (WVS, 2022) (Private) 5919 World Values Survey (2022) 27424 % 
{
    "name": "Do you think most people try to take advantage of you",
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     take_advantage grapher/wvs/2023-03-10/wvs_trust/wvs_trust#take_advantage   1                                  
576806 Trust: People you meet for the first time (not at all) % % of respondents replying that they "do not trust at all" when asked "I‘d like to ask you how much you trust people from various groups. Could you tell me for each whether you trust people from this group completely, somewhat, not very much or not at all?" in the group "People you meet for the first time". 2023-03-10 12:09:27 2023-10-27 12:25:39     2009-2022 Trust questions in the World Values Survey Dataset (WVS, 2022) (Private) 5919 World Values Survey (2022) 27424 % 
{
    "name": "Trust: People you meet for the first time (not at all)",
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     trust_first_not_at_all grapher/wvs/2023-03-10/wvs_trust/wvs_trust#trust_first_not_at_all   1                                  
576805 Trust: People you know personally (not at all) % % of respondents replying that they "do not trust at all" when asked "I‘d like to ask you how much you trust people from various groups. Could you tell me for each whether you trust people from this group completely, somewhat, not very much or not at all?" in the group "People you know personally". 2023-03-10 12:09:27 2023-10-27 12:25:39     2009-2022 Trust questions in the World Values Survey Dataset (WVS, 2022) (Private) 5919 World Values Survey (2022) 27424 % 
{
    "name": "Trust: People you know personally (not at all)",
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     trust_personally_not_at_all grapher/wvs/2023-03-10/wvs_trust/wvs_trust#trust_personally_not_at_all   1                                  
576804 Trust: People you know personally % % of respondents replying that they "trust completely" or "trust somewhat" when asked "I‘d like to ask you how much you trust people from various groups. Could you tell me for each whether you trust people from this group completely, somewhat, not very much or not at all?" in the group "People you know personally". 2023-03-10 12:09:27 2023-10-27 12:25:39     2009-2022 Trust questions in the World Values Survey Dataset (WVS, 2022) (Private) 5919 World Values Survey (2022) 27424 % 
{
    "name": "Trust: People you know personally",
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     trust_personally grapher/wvs/2023-03-10/wvs_trust/wvs_trust#trust_personally   1                                  
576803 Trust: Confidence in government % % of respondents replying that they "trust completely" or "trust somewhat" when asked "I am going to name a number of organisations. For each one, could you tell me how much confidence you have in them: is it a great deal of confidence, quite a lot of confidence, not very much confidence or none at all?". 2023-03-10 12:09:27 2023-10-27 12:25:39     1993-2022 Trust questions in the World Values Survey Dataset (WVS, 2022) (Private) 5919 World Values Survey (2022) 27424 % 
{
    "name": "Trust: Confidence in government",
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     confidence_government grapher/wvs/2023-03-10/wvs_trust/wvs_trust#confidence_government   1                                  
576802 Trust: People you know personally (not very much) % % of respondents replying that they "do not trust very much" when asked "I‘d like to ask you how much you trust people from various groups. Could you tell me for each whether you trust people from this group completely, somewhat, not very much or not at all?" in the group "People you know personally". 2023-03-10 12:09:27 2023-10-27 12:25:39     2009-2022 Trust questions in the World Values Survey Dataset (WVS, 2022) (Private) 5919 World Values Survey (2022) 27424 % 
{
    "name": "Trust: People you know personally (not very much)",
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     trust_personally_not_very_much grapher/wvs/2023-03-10/wvs_trust/wvs_trust#trust_personally_not_very_much   1                                  
576801 Trust: People you meet for the first time (not very much) % % of respondents replying that they "do not trust very much" when asked "I‘d like to ask you how much you trust people from various groups. Could you tell me for each whether you trust people from this group completely, somewhat, not very much or not at all?" in the group "People you meet for the first time". 2023-03-10 12:09:27 2023-10-27 12:25:39     2009-2022 Trust questions in the World Values Survey Dataset (WVS, 2022) (Private) 5919 World Values Survey (2022) 27424 % 
{
    "name": "Trust: People you meet for the first time (not very much)",
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     trust_first_not_very_much grapher/wvs/2023-03-10/wvs_trust/wvs_trust#trust_first_not_very_much   1                                  
576800 Trust: People you meet for the first time % % of respondents replying that they "trust completely" or "trust somewhat" when asked "I‘d like to ask you how much you trust people from various groups. Could you tell me for each whether you trust people from this group completely, somewhat, not very much or not at all?" in the group "People you meet for the first time". 2023-03-10 12:09:27 2023-10-27 12:25:39     2009-2022 Trust questions in the World Values Survey Dataset (WVS, 2022) (Private) 5919 World Values Survey (2022) 27424 % 
{
    "name": "Trust: People you meet for the first time",
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     trust_first grapher/wvs/2023-03-10/wvs_trust/wvs_trust#trust_first   1                                  
576799 Most of the people can be trusted % % of respondents replying "Most people can be trusted" when asked "Generally speaking, would you say that most people can be trusted or that you need to be very careful in dealing with people?" Possible answers include "Most people can be trusted", "Do not know" and "Need to be very careful". 2023-03-10 12:09:27 2023-10-27 12:25:39     1984-2022 Trust questions in the World Values Survey Dataset (WVS, 2022) (Private) 5919 World Values Survey (2022) 27424 % 
{
    "name": "Most of the people can be trusted",
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     trust grapher/wvs/2023-03-10/wvs_trust/wvs_trust#trust   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");