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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, timespan, 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
8654 Cases of diphtheria per million population (WHO and UNPD 2017)   Diphtheria cases per 1,000,000 population. Dividing the number of confirmed diphtheria cases (reported by WHO 2017) by total population of the country (in millions, reported by World Population Prospects 2017, UN). 2017-08-03 12:39:23 2023-06-15 05:05:42   Global by country and world region 1974-2015 Cases of tetanus per million population (WHO and UNPD 2017) (split) 3014 OWID Disease Burden Variables (using WHO and UNPD) 2820 cases per 1,000,000 population 
{}
 0           1                                  
8653 Cases of measles per million population (WHO and UNPD 2017)   Measles cases per 1,000,000 population. Dividing the number of confirmed measles cases (reported by WHO 2017) by total population of the country (in millions, reported by World Population Prospects 2017, UN). 2017-08-03 12:39:22 2023-06-15 05:05:42   Global by country and world region 1980-2015 Cases of tetanus per million population (WHO and UNPD 2017) (split) 3014 OWID Disease Burden Variables (using WHO and UNPD) 2820 cases per 1,000,000 population 
{}
 0           1                                  
8652 Cases of pertussis per million population (WHO and UNPD 2017)   Pertussis cases per 1,000,000 population. Dividing the number of confirmed pertussis cases (reported by WHO 2017) by total population of the country (in millions, reported by World Population Prospects 2017, UN). 2017-08-03 12:39:22 2023-06-15 05:05:42   Global by country and world region 1974-2015 Cases of tetanus per million population (WHO and UNPD 2017) (split) 3014 OWID Disease Burden Variables (using WHO and UNPD) 2820 cases per 1,000,000 population 
{}
 0           1                                  
8651 Cases of polio per million population (WHO and UNPD 2017)   Polio cases per 1,000,000 population. Dividing the number of confirmed polio cases (reported by WHO 2017) by total population of the country (in millions, reported by World Population Prospects 2017, UN). 2017-08-03 12:39:22 2023-06-15 05:05:42   Global by country and world region 2010-2014 Cases of tetanus per million population (WHO and UNPD 2017) (split) 3014 OWID Disease Burden Variables (using WHO and UNPD) 2820 cases per 1,000,000 population 
{}
 0           1                                  
8650 Cases of tetanus per million population (WHO and UNPD 2017)   Tetanus cases per 1,000,000 population. Dividing the number of confirmed tetanus cases (reported by WHO 2017) by total population of the country (in millions, reported by World Population Prospects 2017, UN). 2017-08-03 12:39:22 2023-06-15 05:05:42   Global by country and world region 1974-2015 Cases of tetanus per million population (WHO and UNPD 2017) (split) 3014 OWID Disease Burden Variables (using WHO and UNPD) 2820 cases per 1,000,000 population 
{}
 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");