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 = 5220 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
145498 Biweekly deaths per million people     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145497 Biweekly cases per million people     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145496 Weekly deaths per million people     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145495 Weekly cases per million people     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145494 Biweekly death growth (%)     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "name": "Biweekly growth in deaths",
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145493 Biweekly case growth (%)     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "name": "Biweekly growth in cases",
    "unit": "%",
    "zeroDay": "2020-01-21",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145492 Biweekly deaths     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "name": "Biweekly deaths",
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": ""
}
 0           1                                  
145491 Biweekly cases     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "name": "Biweekly cases",
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": ""
}
 0           1                                  
145490 Weekly death growth (%)     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145489 Weekly case growth (%)     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145488 Weekly deaths     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145487 Weekly cases     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145482 Has population ≥ 5M AND had ≥100 cases ≥21 days ago AND has testing data     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145481 Days since the total confirmed cases of COVID-19 reached 100 (with population ≥ 5M)     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false,
    "entityAnnotationsMap": ""
}
 0           1                                  
145479 Case fatality rate of COVID-19 (%) (Only observations with ≥100 cases)     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "unit": "%",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145478 Case fatality rate of COVID-19 (%)     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "name": "Case fatality rate",
    "unit": "%",
    "zeroDay": "2020-01-21",
    "tolerance": 2,
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145477 Daily new confirmed deaths due to COVID-19 per million people (rolling 7-day average, right-aligned)     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145476 Daily new confirmed cases of COVID-19 per million people (rolling 7-day average, right-aligned)     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145473 Daily new confirmed deaths due to COVID-19 (rolling 7-day average, right-aligned)     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145471 Daily new confirmed cases due to COVID-19 (rolling 7-day average, right-aligned)     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145459 Days since the total confirmed deaths of COVID-19 per million people reached 0.1     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false,
    "entityAnnotationsMap": ""
}
 0           1                                  
145458 Days since the total confirmed cases of COVID-19 per million people reached 1     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "name": "Days since the total confirmed cases per million people reached 1",
    "unit": "days",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false,
    "entityAnnotationsMap": ""
}
 0           1                                  
145457 Days since the total confirmed deaths of COVID-19 reached 5     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false,
    "entityAnnotationsMap": ""
}
 0           1                                  
145456 Days since the total confirmed cases of COVID-19 reached 100     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": false,
    "entityAnnotationsMap": ""
}
 0           1                                  
145455 Total confirmed deaths due to COVID-19 per million people     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "unit": "deaths per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145454 Total confirmed cases of COVID-19 per million people     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "unit": "cases per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145453 Daily new confirmed deaths due to COVID-19 per million people     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "unit": "deaths per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145452 Daily new confirmed cases of COVID-19 per million people     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145451 Total confirmed deaths due to COVID-19     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145450 Total confirmed cases of COVID-19     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": ""
}
 0           1                                  
145449 Daily new confirmed deaths due to COVID-19     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "name": "Daily confirmed deaths",
    "unit": "deaths",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": ""
}
 0           1                                  
145448 Daily new confirmed cases of COVID-19     2020-11-17 14:14:48 2023-06-15 05:05:42       COVID-19 - Johns Hopkins University 5220 Johns Hopkins University CSSE COVID-19 Data 17950   
{
    "name": "Daily confirmed cases",
    "unit": "cases",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": ""
}
 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");