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

5 rows where datasetId = 6562 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, createdAt (date), updatedAt (date), descriptionKey (array)

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
932025 The leading cause of death in all ages (OWID mix)     2024-06-12 19:07:38 2024-07-25 23:35:36     1980-2021 Global Burden of Disease, Cause Hierarchy 6562     
{}
 0     leading_deaths_level_owid grapher/ihme_gbd/2024-06-10/leading_causes_deaths/leading_cause_level_owid_in_all_ages#leading_deaths_level_owid   2 major               
[
    "For each country-year the disease or injury that caused the most deaths according to the [IHME - Global Burden of Disease Study](https://www.healthdata.org/research-analysis/gbd)."
]
         string 
[]
 21f70d3f85d3442c4f1118c3bb6f9a6d 60288cf5f0f5fcf83e2d654d1c3e847f
932024 The leading cause of death in all ages (level 4)     2024-06-12 19:07:37 2024-07-25 23:35:36     1980-2021 Global Burden of Disease, Cause Hierarchy 6562     
{}
 0     leading_deaths_level_4 grapher/ihme_gbd/2024-06-10/leading_causes_deaths/leading_cause_level_4_in_all_ages#leading_deaths_level_4   2 major               
[
    "For each country-year the disease or injury that caused the most deaths according to the [IHME - Global Burden of Disease Study](https://www.healthdata.org/research-analysis/gbd)."
]
         string 
[]
 e52f6bb37994eca453998a7e7197cfc5 990ccfc7d6749b20ef9b149a321c1fb3
932023 The leading cause of death in all ages (level 3)     2024-06-12 19:07:37 2024-07-25 23:35:36     1980-2021 Global Burden of Disease, Cause Hierarchy 6562     
{}
 0     leading_deaths_level_3 grapher/ihme_gbd/2024-06-10/leading_causes_deaths/leading_cause_level_3_in_all_ages#leading_deaths_level_3   2 major               
[
    "For each country-year the disease or injury that caused the most deaths according to the [IHME - Global Burden of Disease Study](https://www.healthdata.org/research-analysis/gbd)."
]
         string 
[]
 e361bef6a42cc19ed4bb421e42624a0f d9b6b675aae297d0c34f2f9150c7dc1c
932022 The leading cause of death in all ages (level 2)     2024-06-12 19:07:37 2024-07-25 23:35:36     1980-2021 Global Burden of Disease, Cause Hierarchy 6562     
{}
 0     leading_deaths_level_2 grapher/ihme_gbd/2024-06-10/leading_causes_deaths/leading_cause_level_2_in_all_ages#leading_deaths_level_2   2 major               
[
    "For each country-year the disease or injury that caused the most deaths according to the [IHME - Global Burden of Disease Study](https://www.healthdata.org/research-analysis/gbd)."
]
         string 
[]
 79794175e428e6299595dfc6f81d48d1 d0beca9603b9afe25f3e2ce261d7e92c
932021 The leading cause of death in all ages (level 1)     2024-06-12 19:07:37 2024-07-25 23:35:36     1980-2021 Global Burden of Disease, Cause Hierarchy 6562     
{}
 0     leading_deaths_level_1 grapher/ihme_gbd/2024-06-10/leading_causes_deaths/leading_cause_level_1_in_all_ages#leading_deaths_level_1   2 major   Leading causes of death           
[
    "For each country-year the disease or injury that caused the most deaths according to the [IHME - Global Burden of Disease Study](https://www.healthdata.org/research-analysis/gbd)."
]
         string 
[]
 59e76ba32b0e68842e1980a1bee58bb2 28a6b4269eba027bfecd67318f769fdf

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