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

3 rows where datasetId = 6599 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
946933 Years lived with disability or diseases years   2024-07-02 16:03:20 2024-07-02 16:03:21     1990-2021 Global Burden of Disease - Health-adjusted life expectancy 6599     
{
    "unit": "years",
    "numDecimalPlaces": 1
}
 0     years_lived_with_disability grapher/ihme_gbd/2024-07-02/gbd_healthy_life_expectancy/gbd_healthy_life_expectancy#years_lived_with_disability   2 major               
[]
 The life expectancy at birth minus the health-adjusted life expectancy at birth       float 
[]
 21e25a03d0a1dcb46beae7f4e3ad256c 26b93281dd8fa71a0357070988c9112f
946932 Life expectancy at birth years   2024-07-02 16:03:20 2024-07-02 16:03:21     1990-2021 Global Burden of Disease - Health-adjusted life expectancy 6599     
{
    "unit": "years",
    "numDecimalPlaces": 1
}
 0     life_expectancy_newborn grapher/ihme_gbd/2024-07-02/gbd_healthy_life_expectancy/gbd_healthy_life_expectancy#life_expectancy_newborn   2 major           The number of years a person is expected to live from birth, assuming they will experience the age-specific mortality rate observed in a given year throughout their lifetime.   
[]
         float 
[]
 ba8d67ab0e630f553a9a4efe1be126e9 eed5cd37d2b2fa3f0610240408464fd2
946931 Health-adjusted life expectancy at birth years   2024-07-02 16:03:20 2024-07-02 16:03:21     1990-2021 Global Burden of Disease - Health-adjusted life expectancy 6599     
{
    "unit": "years",
    "numDecimalPlaces": 1
}
 0     healthy_life_expectancy_newborn grapher/ihme_gbd/2024-07-02/gbd_healthy_life_expectancy/gbd_healthy_life_expectancy#healthy_life_expectancy_newborn   2 major           The number of years that a newborn can expect to live in good health, if the rates of all-cause mortality and all-cause disability in a specified year of interest would remain constant into the future.   
[]
         float 
[]
 e07fdb8b83b336972e9c7d90fab27123 8193d884ad6f4a06ef934352bc55b43c

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");