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

12 rows where datasetId = 2821 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, 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
97601 Gainful work, study, men (European Commission (2004))   Time spent on main and second jobs and related activities, breaks and travel during working hours, and job seeking. The time spent on study at school and during free time is combined with gainful work. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 0           1                                  
97600 Domestic work, men (European Commission (2004))   Housework, child and adult care, gardening and pet care, construction and repairs, shopping and services, and household management. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 0           1                                  
97599 Travel, men (European Commission (2004))   Commuting and trips connected with all kinds of activities, except travel during working hours. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 0           1                                  
97598 Sleep, men (European Commission (2004))   Sleep during night or daytime, waiting for sleep, naps, as well as passive lying in bed because of sickness. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 0           1                                  
97597 Meals, personal care, men (European Commission (2004))   Meals, snacks and drinks, dressing, personal hygiene, making up, shaving, sexual activities and personal healthcare. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 0           1                                  
97596 Free time, men (European Commission (2004))   All other kinds of activities are included here, e.g. volunteer work and meetings, helping other households, socialising and entertainment, sports and outdoor activities, hobbies and games, reading, watching television, resting or doing nothing, as well as unspecified time use. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 0           1                                  
97595 Gainful work, study, women (European Commission (2004))   Time spent on main and second jobs and related activities, breaks and travel during working hours, and job seeking. The time spent on study at school and during free time is combined with gainful work. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 0           1                                  
97594 Domestic work, women (European Commission (2004))   Housework, child and adult care, gardening and pet care, construction and repairs, shopping and services, and household management. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 0           1                                  
97593 Travel, women (European Commission (2004))   Commuting and trips connected with all kinds of activities, except travel during working hours. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 0           1                                  
97592 Sleep, women (European Commission (2004))   Sleep during night or daytime, waiting for sleep, naps, as well as passive lying in bed because of sickness. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 0           1                                  
97591 Meals, personal care, women (European Commission (2004))   Meals, snacks and drinks, dressing, personal hygiene, making up, shaving, sexual activities and personal healthcare. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 0           1                                  
97590 Free time, women (European Commission (2004))   All other kinds of activities are included here, e.g. volunteer work and meetings, helping other households, socialising and entertainment, sports and outdoor activities, hobbies and games, reading, watching television, resting or doing nothing, as well as unspecified time use. 2018-06-20 13:50:52 2023-06-15 05:05:42       How Europeans spend their time - European Commission (2004) 2821 European Commission (2004) - How Europeans spend their time - Everyday life of men and women - Data 1998-2002 15552   
{}
 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");