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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, display, type, dataChecksum, 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
738507 vaccine_eligibility     2023-07-24 09:56:23 2024-07-31 15:42:13       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     vaccine_eligibility grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#vaccine_eligibility   1                 
[]
         int 
[]
 c09ff5b2b54a9ed4df6ce8ac4e464a85 b0c66c781fd8f1f16cb81beb80f8db7f
738506 pregnant_vaccine_eligibility     2023-07-24 09:56:23 2024-07-31 15:42:13       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     pregnant_vaccine_eligibility grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#pregnant_vaccine_eligibility   1                 
[]
         int 
[]
 ffa4ded09ebb0e68dce1d03712ebaf31 c3566689ce9aa093d820a130cf414236
738505 containment_index (0 to 100, 100 = strictest)   2023-07-24 09:56:22 2024-07-31 15:42:12       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "COVID-19 Containment and Health Index",
    "unit": "(0 to 100, 100 = strictest)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     containment_index grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#containment_index   1                 
[]
         float 
[]
 8a3da6afe16d9cbfc7065e531b9e83fe 309f61d3dbc5b04e35256e56f25a48b7
738504 stringency_index (0 to 100, 100 = strictest)   2023-07-24 09:56:21 2024-07-31 15:42:12       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Government Response Stringency Index",
    "unit": "(0 to 100, 100 = strictest)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     stringency_index grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#stringency_index   1                 
[]
         float 
[]
 7e28a096f41e3d994285e200a59dfb58 e9c8c9caa6233a9a6fe27eb4a1c9bf8c
738503 vaccine_eligibility_age_at_risk     2023-07-24 09:56:19 2024-07-31 15:42:12       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     vaccine_eligibility_age_at_risk grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#vaccine_eligibility_age_at_risk   1                 
[]
         string 
[]
 d1c26aeabe45afff263d3e86eb3e9b5d c769395119b270da2b2adac47b7101f4
738502 vaccine_eligibility_age     2023-07-24 09:56:18 2024-07-31 15:42:11       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     vaccine_eligibility_age grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#vaccine_eligibility_age   1                 
[]
         string 
[]
 7c2acd6fd5b6372b831848e86d5a137d 309e2678ea522bacf84b1115b8c9947c
738501 vaccine_availability     2023-07-24 09:56:18 2024-07-31 15:42:10       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     vaccine_availability grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#vaccine_availability   1                 
[]
         int 
[]
 c09ff5b2b54a9ed4df6ce8ac4e464a85 b0753a7b3d968147762bd0b54cac674b
738500 vaccination_policy     2023-07-24 09:56:16 2024-07-31 15:42:10       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     vaccination_policy grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#vaccination_policy   1                 
[]
         int 
[]
 4235d41ec238f8221b0503dc2c388ed5 0b1e564251ec0979850793653e61d9bf
738499 facial_coverings     2023-07-24 09:56:15 2024-07-31 15:42:09       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Facial coverings (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     facial_coverings grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#facial_coverings   1                 
[]
         int 
[]
 60deed96adac3623e150453511227196 17e4f5c055e90e2cba324bd096a7273b
738498 investment_vaccines $   2023-07-24 09:56:14 2024-07-31 15:42:09       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949 $ 
{
    "name": "Investment in COVID-19 vaccines",
    "unit": "$",
    "zeroDay": "2020-01-01",
    "shortUnit": "$",
    "yearIsDay": true
}
 0     investment_vaccines grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#investment_vaccines   1                 
[]
         float 
[]
 d383f54e0d0663b3ab318c531db044d9 96e894dbb6c1d3c9201ff7de72c409ee
738497 emergency_investment_healthcare     2023-07-24 09:56:13 2024-07-31 15:42:08       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Emergency investment in health care (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     emergency_investment_healthcare grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#emergency_investment_healthcare   1                 
[]
         float 
[]
 5f13be6a79d4903d3ad6fd0e715a1169 0ffe376aafcaeaaebb614170a61ff2b0
738496 contact_tracing     2023-07-24 09:56:12 2024-07-31 15:42:08       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Contact tracing (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     contact_tracing grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#contact_tracing   1                 
[]
         int 
[]
 c8af9b984866ece31f3eae84a0861b7f 2d4017e1a21d2bc423bbc32a92ef6904
738495 testing_policy     2023-07-24 09:56:11 2024-07-31 15:42:07       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Testing policy (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     testing_policy grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#testing_policy   1                 
[]
         int 
[]
 0f3c81e62b3364ec5563816fb706abf7 abbe24bd0661aace09c882b7ab258648
738494 public_information_campaigns     2023-07-24 09:56:10 2024-07-31 15:42:07       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Public information campaigns (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     public_information_campaigns grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#public_information_campaigns   1                 
[]
         int 
[]
 489141de0b1795492efda77006bbbe2a be5058b71eb0a497cad1975c8b000189
738493 international_support     2023-07-24 09:56:08 2024-07-31 15:42:06       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "International support (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     international_support grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#international_support   1                 
[]
         float 
[]
 36c6d2c26320658e048312ce1c093ee2 e94fb4e29e14d7e47c437cb0d0b86909
738492 fiscal_measures     2023-07-24 09:56:06 2024-07-31 15:42:06       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Fiscal measures (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     fiscal_measures grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#fiscal_measures   1                 
[]
         float 
[]
 6e532aeb4b36001b22b1e45e454aa640 a810961ba6c82586c7249d89147008a0
738491 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 2023-07-24 09:56:05 2024-07-31 15:42:05       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Debt or contract relief",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     debt_relief grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#debt_relief   1                 
[]
         int 
[]
 99ab6860e896f729fd042633c6e13185 231c5a1cd79d22705875d9680a2ed5ea
738490 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) 2023-07-24 09:56:03 2024-07-31 15:42:05       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Income support",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     income_support grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#income_support   1                 
[]
         int 
[]
 41319dd5279d25a4110ddc9d7075019b 0fd6e116efcc28a6b1d6254023006c58
738489 international_travel_controls     2023-07-24 09:56:03 2024-07-31 15:42:04       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "International travel controls (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     international_travel_controls grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#international_travel_controls   1                 
[]
         int 
[]
 13def42c3a1e2cda33e7667abc07cedb 5003f1e3505d569ef24c381f512515da
738488 stay_home_requirements     2023-07-24 09:56:00 2024-07-31 15:42:03       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Stay at home requirements (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     stay_home_requirements grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#stay_home_requirements   1                 
[]
         int 
[]
 91b30f6d07b817ae2dde0c040a6ab59a 4fb9df361e63de8e55a91a9d4dcbe136
738487 restrictions_internal_movements     2023-07-24 09:56:01 2024-07-31 15:42:04       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Restrictions on internal movement (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     restrictions_internal_movements grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#restrictions_internal_movements   1                 
[]
         int 
[]
 36f1954d4ff8e03c8e6b20ff5e85b689 c886e29563b354de8c6ed94811018dda
738486 close_public_transport     2023-07-24 09:56:00 2024-07-31 15:42:02       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Close public transport (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     close_public_transport grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#close_public_transport   1                 
[]
         int 
[]
 92297447273a86a1438e307d032f86f4 0c0d3a9d6b7b6284301b703226b03f01
738485 restriction_gatherings     2023-07-24 09:56:00 2024-07-31 15:42:01       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Restrictions on gatherings (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     restriction_gatherings grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#restriction_gatherings   1                 
[]
         int 
[]
 481420ac2f1cbc8393530b85ab8d1a4d 4007a875afc6a9e10e1424c53e8e5aac
738484 cancel_public_events     2023-07-24 09:55:59 2024-07-31 15:42:02       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Cancel public events (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     cancel_public_events grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#cancel_public_events   1                 
[]
         int 
[]
 c539efb0634ab45228912bfb17d06b37 3216e46224633fe6b5aa55921c19fd58
738483 workplace_closures     2023-07-24 09:55:58 2024-07-31 15:42:01       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "Workplace Closures (OxBSG)",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     workplace_closures grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#workplace_closures   1                 
[]
         int 
[]
 8f9a56bd38a77fa876778386136565b0 97e6303a0320a23a812b9cc49e4693a8
738482 school_closures     2023-07-24 09:55:58 2024-07-31 15:42:01       COVID Government Response (OxBSG) 6149 Oxford COVID-19 Government Response Tracker, Blavatnik School of Government, University of Oxford – Last updated 30 July 2024 30949   
{
    "name": "School closures",
    "zeroDay": "2020-01-01",
    "yearIsDay": true
}
 0     school_closures grapher/covid/latest/government_response_oxbsg/government_response_oxbsg#school_closures   1                 
[]
         int 
[]
 e1074a92462f51277c919103f7002365 571dfe3a97fcdd2651842810824cca1b

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