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

26 rows where datasetId = 5078 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, 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
180238 pregnant_vaccine_eligibility     2021-12-09 17:00:38 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0           1                                  
180237 vaccine_eligibility_age_at_risk     2021-12-08 16:59:35 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0           1                                  
180236 vaccine_availability     2021-12-08 16:59:35 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0           1                                  
180235 vaccine_eligibility_age     2021-12-08 16:59:35 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0           1                                  
176071 vaccine_eligibility     2021-09-09 17:30:48 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
145532 vaccination_policy     2020-12-09 12:28:02 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
145270 facial_coverings     2020-10-23 08:30:55 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Facial coverings (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
143515 containment_index     2020-08-26 08:30:44 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "COVID-19 Containment and Health Index",
    "unit": "(0 to 100, 100 = strictest)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142751 testing_policy     2020-05-04 15:23:09 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Testing policy (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142750 international_support     2020-05-04 15:23:09 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "International support (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142749 debt_relief   This metric records if the Government is freezing financial obligations (e.g. stopping loan repayments, preventing services like water from stopping, or banning evictions). 0 - No debt relief 1 - Narrow relief, specific to one kind of contract 2 - broad debt/contract relief 2020-05-04 15:23:09 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Debt or contract relief",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142748 income_support   This metric captures if the government is covering the salaries or providing direct cash payments, universal basic income, or similar, of people who lose their jobs or cannot work. (Includes payments to firms if explicitly linked to payroll/ salaries). 0 - no income support 1 - government is replacing less than 50% of lost salary (or if a flat sum, it is less than 50% median salary) 2 - government is replacing 50% or more of lost salary (or if a flat sum, it is greater than 50% median salary) 2020-05-04 15:23:09 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Income support",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142747 stay_home_requirements     2020-05-04 15:23:09 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Stay at home requirements (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142746 restriction_gatherings     2020-05-04 15:23:09 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Restrictions on gatherings (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142679 stringency_index     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Government Response Stringency Index",
    "unit": "(0 to 100, 100 = strictest)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142678 contact_tracing     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Contact tracing (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142676 investment_vaccines     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Investment in COVID-19 vaccines",
    "unit": "$",
    "zeroDay": "2020-01-01",
    "shortUnit": "$",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142675 emergency_investment_healthcare     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Emergency investment in health care (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142673 fiscal_measures     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Fiscal measures (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142672 international_travel_controls     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "International travel controls (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142670 restrictions_internal_movements     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Restrictions on internal movement (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142668 public_information_campaigns     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Public information campaigns (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142666 close_public_transport     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Close public transport (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142664 cancel_public_events     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Cancel public events (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142662 workplace_closures     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "Workplace Closures (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142660 school_closures     2020-04-02 11:34:30 2023-06-15 05:05:42       COVID Government Response (OxBSG) 5078 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 14 June 2023 17808   
{
    "name": "School closures",
    "zeroDay": "2020-01-01",
    "yearIsDay": true,
    "includeInTable": true
}
 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");