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

4 rows where datasetId = 2800 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, 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
97539 Average weekly leisure estimates by age (Ramey and Francis (2009)) hours Leisure is defined as the time remaining after subtracting time spent in non-leisure activities from total time available. Authors subtract work, school, home production, commuting, and personal care from total time available. The authors assume commuting time is equal to 10 percent of work hours and school hours, and that personal care is 77 hours per week. For a discussion of the data behind these assumptions, see the Data Appendix in the paper by Ramey and Francis (2009) from which the data was taken. 2018-06-06 15:04:55 2023-06-15 05:05:42       A Century of Work and Leisure - Ramey and Francis (2009) 2800 Ramey and Francis (2009) 15537   
{}
 0           1                                  
97538 Weekly home production time by demographic group (Ramey and Francis (2009)) hours Time spent in home production activities by age group. Home production activities include planning, purchasing goods and services (except medical and personal care services), care of children and adults (both in the household and outside the household), general cleaning, care and repair of the house and grounds (including yard work, but excluding gardening), preparing and clearing food, making, mending, and laundering of clothing and other household textiles. 2018-06-06 15:04:55 2023-06-15 05:05:42       A Century of Work and Leisure - Ramey and Francis (2009) 2800 Ramey and Francis (2009) 15537   
{}
 0           1                                  
97537 Average weekly hours devoted to school (Ramey and Francis (2009)) hours Average hours a week that are devoted to school. Author's note that since school enrolment rates (used in constructing these estimates) were almost identical across genders, they do not distinguish by gender for those aged 14-17. However, because college enrolment rates differ across genders, the distinction is made for the 18-24 age group. Total refers to male and female individuals for each respective age group. Note these estimates are averaged over the entire year, so they are lower than the amount of time a student would spend during the school year. 2018-06-06 15:04:54 2023-06-15 05:05:42       A Century of Work and Leisure - Ramey and Francis (2009) 2800 Ramey and Francis (2009) 15537   
{}
 0           1                                  
97536 Average weekly hours worked per person by demographic group (Ramey and Francis (2009)) hours Mean hours worked per week per person, by age group. 2018-06-06 10:33:50 2023-06-15 05:05:42       A Century of Work and Leisure - Ramey and Francis (2009) 2800 Ramey and Francis (2009) 15537   
{}
 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");