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

32 rows where datasetId = 5883 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display, 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
541490 Biweekly deaths per million people     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541489 Biweekly cases per million people     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541488 Weekly deaths per million people     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541487 Weekly cases per million people     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541486 Biweekly death growth (%)     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "name": "Biweekly death growth",
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541485 Biweekly case growth (%)     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "name": "Biweekly growth in cases",
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541484 Biweekly deaths     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "name": "Biweekly deaths",
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
541483 Biweekly cases     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "name": "Biweekly cases",
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
541482 Weekly death growth (%)     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
541481 Weekly case growth (%)     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
541480 Weekly deaths     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541479 Weekly cases     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541478 Has population ≥ 5M AND had ≥100 cases ≥21 days ago AND has testing data     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541477 Days since the total confirmed cases of COVID-19 reached 100 (with population ≥ 5M)     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
541476 Case fatality rate of COVID-19 (%) (Only observations with ≥100 cases)     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
541475 Case fatality rate of COVID-19 (%)     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541474 Daily new confirmed deaths due to COVID-19 per million people (rolling 7-day average, right-aligned)     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541473 Daily new confirmed cases of COVID-19 per million people (rolling 7-day average, right-aligned)     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541472 Daily new confirmed deaths due to COVID-19 (rolling 7-day average, right-aligned)     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541471 Daily new confirmed cases due to COVID-19 (rolling 7-day average, right-aligned)     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541470 Days since the total confirmed deaths of COVID-19 per million people reached 0.1     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
541469 Days since the total confirmed cases of COVID-19 per million people reached 1     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "name": "Days since the total confirmed cases per million people reached 1",
    "unit": "days",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
541468 Days since the total confirmed deaths of COVID-19 reached 5     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
541467 Days since the total confirmed cases of COVID-19 reached 100     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false
}
 0           1                                  
541466 Total confirmed deaths due to COVID-19 per million people     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "unit": "deaths per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541465 Total confirmed cases of COVID-19 per million people     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "unit": "cases per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541464 Daily new confirmed deaths due to COVID-19 per million people     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "unit": "deaths per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541463 Daily new confirmed cases of COVID-19 per million people     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541462 Total confirmed deaths due to COVID-19     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541461 Total confirmed cases of COVID-19     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
541460 Daily new confirmed deaths due to COVID-19     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "name": "Daily confirmed deaths",
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
541459 Daily new confirmed cases of COVID-19     2023-02-17 16:35:04 2023-06-15 05:05:42       COVID-19 Cases and deaths - WHO 5883 World Health Organization 27310   
{
    "name": "Daily confirmed cases",
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 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");