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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, updatedAt, 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
737239 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 5week period Jan 3 - Feb 6, 2020. This index is smoothed to the rolling 7-day average. 2023-07-14 13:18:30 2024-07-31 15:42:00       Google Mobility Trends (2020) 6124 Google COVID-19 Community Mobility Trends - Last updated 30 July 2024 30939 % 
{
    "name": "Residential",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0     residential grapher/covid/latest/google_mobility_trends/google_mobility_trends#residential   1                 
[]
         float 
[]
 8e2ed6765c618ac70ea8b90c5c4506fc edf25b2ea699b77feafb15eb1e89bcab
737238 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 5week period Jan 3 - Feb 6, 2020. This index is smoothed to the rolling 7-day average. 2023-07-14 13:18:30 2024-07-31 15:41:59       Google Mobility Trends (2020) 6124 Google COVID-19 Community Mobility Trends - Last updated 30 July 2024 30939 % 
{
    "name": "Workplaces",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0     workplaces grapher/covid/latest/google_mobility_trends/google_mobility_trends#workplaces   1                 
[]
         float 
[]
 4dac9c9d466fa09fa6e65743f9c56397 2d7fdc624db8078d18e014dfa27874cc
737237 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 5week 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. 2023-07-14 13:18:30 2024-07-31 15:41:59       Google Mobility Trends (2020) 6124 Google COVID-19 Community Mobility Trends - Last updated 30 July 2024 30939 % 
{
    "name": "Transit Stations",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0     transit_stations grapher/covid/latest/google_mobility_trends/google_mobility_trends#transit_stations   1                 
[]
         float 
[]
 137e5c1ef7380f17219872e8f24f0316 737e697b3af9a4a9e57a1c984022c085
737236 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 5week 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. 2023-07-14 13:18:30 2024-07-31 15:41:59       Google Mobility Trends (2020) 6124 Google COVID-19 Community Mobility Trends - Last updated 30 July 2024 30939 % 
{
    "name": "Parks",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0     parks grapher/covid/latest/google_mobility_trends/google_mobility_trends#parks   1                 
[]
         float 
[]
 03346df869195b1a8f9da2bf369d52ec 6cb6200335b223945dd65c7f6a0dc037
737235 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 5week 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. 2023-07-14 13:18:29 2024-07-31 15:41:58       Google Mobility Trends (2020) 6124 Google COVID-19 Community Mobility Trends - Last updated 30 July 2024 30939 % 
{
    "name": "Grocery & Pharmacy Stores",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0     grocery_and_pharmacy grapher/covid/latest/google_mobility_trends/google_mobility_trends#grocery_and_pharmacy   1                 
[]
         float 
[]
 e495eccf2fe181082666339772cfdb15 316453cb9ad408e6671ff1633ad8c4a7
737234 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 5week 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. 2023-07-14 13:18:29 2024-07-31 15:41:59       Google Mobility Trends (2020) 6124 Google COVID-19 Community Mobility Trends - Last updated 30 July 2024 30939 % 
{
    "name": "Retail & Recreation",
    "unit": "%",
    "zeroDay": "2020-01-01",
    "shortUnit": "%",
    "yearIsDay": true,
    "includeInTable": true
}
 0     retail_and_recreation grapher/covid/latest/google_mobility_trends/google_mobility_trends#retail_and_recreation   1                 
[]
         float 
[]
 7b74b34f9b421e923ad6f5a72105851b cc094c5b7fd06c97425cccec8dd67e2d

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