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

6 rows where datasetId = 5085 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
142791 residential   Changes in the duration of time spent in places of residence relative to a baseline day. A baseline day represents a normal value for that day of the week. The baseline day is the median value from the 5‑week period Jan 3 – Feb 6, 2020. This index is smoothed to the rolling 7-day average. 2020-05-31 14:09:00 2023-06-15 05:05:42       Google Mobility Trends (2020) 5085 Google COVID-19 Community Mobility Trends – Last updated 21 October 2022 17815   
{
    "name": "Residential",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142790 workplaces   Changes in visitors to workplaces relative to a baseline day. A baseline day represents a normal value for that day of the week. The baseline day is the median value from the 5‑week period Jan 3 – Feb 6, 2020. This index is smoothed to the rolling 7-day average. 2020-05-31 14:09:00 2023-06-15 05:05:42       Google Mobility Trends (2020) 5085 Google COVID-19 Community Mobility Trends – Last updated 21 October 2022 17815   
{
    "name": "Workplaces",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142789 transit_stations   Changes in visitors to transit stations relative to a baseline day. A baseline day represents a normal value for that day of the week. The baseline day is the median value from the 5‑week period Jan 3 – Feb 6, 2020. This index is smoothed to the rolling 7-day average. This category includes places like public transport hubs such as subway, bus, and train stations. 2020-05-31 14:09:00 2023-06-15 05:05:42       Google Mobility Trends (2020) 5085 Google COVID-19 Community Mobility Trends – Last updated 21 October 2022 17815   
{
    "name": "Transit Stations",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142788 parks   Changes in visitors to parks relative to a baseline day. A baseline day represents a normal value for that day of the week. The baseline day is the median value from the 5‑week period Jan 3 – Feb 6, 2020. This index is smoothed to the rolling 7-day average. This category includes places like local parks, national parks, public beaches, marinas, dog parks, plazas, and public gardens. 2020-05-31 14:09:00 2023-06-15 05:05:42       Google Mobility Trends (2020) 5085 Google COVID-19 Community Mobility Trends – Last updated 21 October 2022 17815   
{
    "name": "Parks",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142787 grocery_and_pharmacy   Changes in visitors to grocery and pharmacy stores relative to a baseline day. A baseline day represents a normal value for that day of the week. The baseline day is the median value from the 5‑week period Jan 3 – Feb 6, 2020. This index is smoothed to the rolling 7-day average. This category includes places like grocery markets, food warehouses, farmers markets, specialty food shops, drug stores, and pharmacies. 2020-05-31 14:09:00 2023-06-15 05:05:42       Google Mobility Trends (2020) 5085 Google COVID-19 Community Mobility Trends – Last updated 21 October 2022 17815   
{
    "name": "Grocery & Pharmacy Stores",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0           1                                  
142786 retail_and_recreation   Changes in visitors to places of retail and recreation relative to a baseline day. A baseline day represents a normal value for that day of the week. The baseline day is the median value from the 5‑week period Jan 3 – Feb 6, 2020. This index is smoothed to the rolling 7-day average. This category includes places like restaurants, cafes, shopping centers, theme parks, museums, libraries, and movie theaters. 2020-05-31 14:09:00 2023-06-15 05:05:42       Google Mobility Trends (2020) 5085 Google COVID-19 Community Mobility Trends – Last updated 21 October 2022 17815   
{
    "name": "Retail & Recreation",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "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");