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

15 rows where datasetId = 5234 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
240953 people_unvaccinated     2022-01-11 11:55:12 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
180063 new_people_vaccinated_smoothed_per_hundred     2021-11-15 12:56:13 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{}
 0           1                                  
180061 new_people_vaccinated_smoothed     2021-11-15 12:40:14 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true
}
 0           1                                  
176434 share_of_boosters     2021-09-29 16:19:04 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
165484 total_boosters_per_hundred     2021-08-13 08:30:05 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true
}
 0           1                                  
165483 total_boosters     2021-08-13 08:30:05 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true
}
 0           1                                  
145612 new_vaccinations     2021-01-13 10:10:11 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true
}
 0           1                                  
145611 people_fully_vaccinated     2021-01-12 17:40:11 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "World: Data for China reported at irregular intervals\nUpper middle income: Data for China reported at irregular intervals\nAsia: Data for China reported at irregular intervals"
}
 0           1                                  
145610 people_vaccinated_per_hundred     2021-01-12 17:40:11 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "Gibraltar: Exceeds 100% due to non-resident vaccinations\nWorld: Data for China reported at irregular intervals\nUpper middle income: Data for China reported at irregular intervals\nAsia: Data for China reported at irregular intervals"
}
 0           1                                  
145609 people_fully_vaccinated_per_hundred     2021-01-12 17:40:11 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "World: Data for China reported at irregular intervals\nUpper middle income: Data for China reported at irregular intervals\nAsia: Data for China reported at irregular intervals"
}
 0           1                                  
145608 people_vaccinated     2021-01-12 17:40:11 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "includeInTable": true,
    "entityAnnotationsMap": "World: Data for China reported at irregular intervals\nUpper middle income: Data for China reported at irregular intervals\nAsia: Data for China reported at irregular intervals"
}
 0           1                                  
145605 new_vaccinations_smoothed_per_million   Not all countries report vaccination data on a daily basis. To generate this series we assume that vaccination changed equally on a daily basis over any periods in which no data was reported. This produces a complete series of daily figures, which is then averaged over a rolling 7-day window. 2020-12-31 14:37:34 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
145604 new_vaccinations_smoothed   Not all countries report vaccination data on a daily basis. To generate this series we assume that vaccination changed equally on a daily basis over any periods in which no data was reported. This produces a complete series of daily figures, which is then averaged over a rolling 7-day window. 2020-12-31 14:37:34 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
145572 total_vaccinations_per_hundred     2020-12-16 10:44:13 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "name": "Cumulative COVID-19 vaccinations per 100 people",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
145569 total_vaccinations     2020-12-16 10:44:13 2023-06-15 05:05:42       COVID-19 - Vaccinations 5234 Official data collated by Our World in Data – Last updated 10 August 2023 17963   
{
    "name": "Cumulative COVID-19 vaccinations",
    "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");