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 sourceId = 15597 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, description, 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
97772 Female-to-male life expectancy ratio at 45 (HMD (2018) and others)   Female-to-male life expectancy ratio conditional on reaching age 45. 2018-08-03 09:32:30 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 0           1                                  
97771 Female-to-male life expectancy ratio at 15 (HMD (2018) and others)   Female-to-male life expectancy ratio conditional on reaching age 15. 2018-08-03 09:32:30 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 0           1                                  
97770 Female-to-male life expectancy ratio at birth (HMD (2018) and others)   Female-to-male life expectancy ratio at age 0. 2018-08-03 09:32:30 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 0           1                                  
97769 Female minus male life expectancy at 45 (HMD (2018) and others) years The difference in female and male life expectancy at age 45. 2018-08-03 09:32:30 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 0           1                                  
97768 Female minus male life expectancy at 15 (HMD (2018) and others) years The difference in female and male life expectancy at age 15. 2018-08-03 09:32:30 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 0           1                                  
97767 Female minus male life expectancy at birth (HMD (2018) and others) years The difference in female and male life expectancy at age 0. 2018-08-03 09:32:29 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 0           1                                  
97766 Female life expectancy at 45 (HMD (2018) and others) years Life expectancy conditional on reaching age 45, expressed as expected age at death, not as years left to live. 2018-08-03 09:32:29 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 0           1                                  
97765 Female life expectancy at 15 (HMD (2018) and others) years Life expectancy conditional on reaching age 15, expressed as expected age at death, not as years left to live. 2018-08-03 09:32:29 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 0           1                                  
97764 Female life expectancy at birth (HMD (2018) and others) years Life expectancy at age 0. 2018-08-03 09:32:29 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 0           1                                  
97763 Male life expectancy at 45 (HMD (2018) and others) years Life expectancy conditional on reaching age 45, expressed as expected age at death, not as years left to live. 2018-08-03 09:32:29 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 0           1                                  
97762 Male life expectancy at 15 (HMD (2018) and others) years Life expectancy conditional on reaching age 15, expressed as expected age at death, not as years left to live. 2018-08-03 09:32:29 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 0           1                                  
97761 Male life expectancy at birth (HMD (2018) and others) years Life expectancy at age 0. 2018-08-03 09:32:29 2023-06-15 05:05:42       Male and female life expectancy by age in the long run (Human Mortality Database (2018) and others) 2863 Human Mortality Database (2018) and others 15597   
{}
 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");