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

4 rows where datasetId = 6140 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
738163 willingness_covid_vaccinate_this_week_pct_pop % Monthly share of the population who have not received a COVID-19 vaccine and who agree with the statement: "If a COVID-19 vaccine were made available to me this week, I would definitely get it." Respondents were presented with a 1 to 5 scale, ranging from "Strongly agree" (1) to "Strongly disagree" (5). We consider responses of 1 or 2 to be in agreement with the statement. This statement was only presented to survey respondents who said they have not received a COVID-19 vaccination. To aggregate these responses into a share of a country's population, we multiply the share of respondents who agree with the statement by the share of the country's population that is unvaccinated. Data on the share of a country's population that is unvaccinated comes from public official sources, collated by Our World in Data at https://github.com/owid/covid-19-data/tree/master/public/data/vaccinations. Individuals under 18 years of age were not surveyed. As a result, the share of survey respondents who agree with the statement is a representative estimate of the share of a country's unvaccinated population aged 18 and above that would agree with the statement, but is not necessarily a representative estimate of the share of a country's unvaccinated population of all ages that would agree with the statement. Nevertheless, we expect any differences to be minor. Months containing fewer than 500 survey respondents are excluded. 2023-07-24 09:54:08 2024-07-31 15:41:59       YouGov-Imperial COVID-19 Behavior Tracker, composite variables 6140 Imperial College London YouGov Covid 19 Behaviour Tracker Data Hub – Last updated 30 July 2024 30943 % 
{
    "name": "Share of people who have not received a COVID-19 vaccine and would get a COVID-19 vaccine if it was available to them this week",
    "unit": "%",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 2
}
 0     willingness_covid_vaccinate_this_week_pct_pop grapher/covid/latest/yougov_imperial_behavior_tracker_composite/yougov_imperial_behavior_tracker_composite#willingness_covid_vaccinate_this_week_pct_pop   1                 
[]
         float 
[]
 53c52422c3ee766e43e88d6d64e205cf e3698fbff05a0646ce352dccd4948102
738162 unwillingness_covid_vaccinate_this_week_pct_pop % Monthly share of the population who have not received a COVID-19 vaccine and who do NOT agree with the statement: "If a COVID-19 vaccine were made available to me this week, I would definitely get it." Respondents were presented with a 1 to 5 scale, ranging from "Strongly agree" (1) to "Strongly disagree" (5). We consider responses of 4 or 5 to NOT be in agreement with the statement. This statement was only presented to survey respondents who said they have not received a COVID-19 vaccination. To aggregate these responses into a share of a country's population, we multiply the share of respondents who do not agree with the statement by the share of the country's population that is unvaccinated. Data on the share of a country's population that is unvaccinated comes from public official sources, collated by Our World in Data at https://github.com/owid/covid-19-data/tree/master/public/data/vaccinations. Individuals under 18 years of age were not surveyed. As a result, the share of survey respondents who do not agree with the statement is a representative estimate of the share of a country's unvaccinated population aged 18 and above that would not agree with the statement, but is not necessarily a representative estimate of the share of a country's unvaccinated population of all ages that would not agree with the statement. Nevertheless, we expect any differences to be minor. Months containing fewer than 500 survey respondents are excluded. 2023-07-24 09:54:08 2024-07-31 15:41:59       YouGov-Imperial COVID-19 Behavior Tracker, composite variables 6140 Imperial College London YouGov Covid 19 Behaviour Tracker Data Hub – Last updated 30 July 2024 30943 % 
{
    "name": "Share of people who have not received a COVID-19 vaccine and would not get a COVID-19 vaccine if it was available to them this week",
    "unit": "%",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 2
}
 0     unwillingness_covid_vaccinate_this_week_pct_pop grapher/covid/latest/yougov_imperial_behavior_tracker_composite/yougov_imperial_behavior_tracker_composite#unwillingness_covid_vaccinate_this_week_pct_pop   1                 
[]
         float 
[]
 666a5138eb3909a6f01dd964e541acfa cb5cf9be98263fd8bba3173dd3e64f23
738161 uncertain_covid_vaccinate_this_week_pct_pop % Monthly share of the population who have not received a COVID-19 vaccine and who neither agree or disagree with the statement: "If a COVID-19 vaccine were made available to me this week, I would definitely get it." Respondents were presented with a 1 to 5 scale, ranging from "Strongly agree" (1) to "Strongly disagree" (5). We consider responses of 3 to neither be in agreement or disagreement with the statement. This statement was only presented to survey respondents who said they have not received a COVID-19 vaccination. To aggregate these responses into a share of a country's population, we multiply the share of respondents who neither agree or disagree with the statement by the share of the country's population that is unvaccinated. Data on the share of a country's population that is unvaccinated comes from public official sources, collated by Our World in Data at https://github.com/owid/covid-19-data/tree/master/public/data/vaccinations. Individuals under 18 years of age were not surveyed. As a result, the share of survey respondents who neither agree or disagree with the statement is a representative estimate of the share of a country's unvaccinated population aged 18 and above who would neither agree or disagree with the statement, but is not necessarily a representative estimate of the share of a country's unvaccinated population of all ages who would neither agree or disagree with the statement. Nevertheless, we expect any differences to be minor. Months containing fewer than 500 survey respondents are excluded. 2023-07-24 09:54:08 2024-07-31 15:41:59       YouGov-Imperial COVID-19 Behavior Tracker, composite variables 6140 Imperial College London YouGov Covid 19 Behaviour Tracker Data Hub – Last updated 30 July 2024 30943 % 
{
    "name": "Share of people who have not received a COVID-19 vaccine and are uncertain if they would get a COVID-19 vaccine if it was available to them this week",
    "unit": "%",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 2
}
 0     uncertain_covid_vaccinate_this_week_pct_pop grapher/covid/latest/yougov_imperial_behavior_tracker_composite/yougov_imperial_behavior_tracker_composite#uncertain_covid_vaccinate_this_week_pct_pop   1                 
[]
         float 
[]
 61557f250233615264511ee572ab1af3 bec04f24e632ba7dc91058a1fdaa1133
738160 people_vaccinated_per_hundred % Monthly share of the population who have received at least one dose of a COVID-19 vaccine. 2023-07-24 09:54:08 2024-07-31 15:41:59       YouGov-Imperial COVID-19 Behavior Tracker, composite variables 6140 Imperial College London YouGov Covid 19 Behaviour Tracker Data Hub – Last updated 30 July 2024 30943 % 
{
    "name": "Share of people who have received at least one dose of a COVID-19 vaccine",
    "unit": "%",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true,
    "numDecimalPlaces": 2
}
 0     people_vaccinated_per_hundred grapher/covid/latest/yougov_imperial_behavior_tracker_composite/yougov_imperial_behavior_tracker_composite#people_vaccinated_per_hundred   1                 
[]
         float 
[]
 e630b370aaceb4ce648962a4a39c7010 e52d8abfe722cb6721444f8943fb7baa

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