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

5 rows where datasetId = 707 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
8872 Total Services   Total services output, indexed to the year 1700, in log scale. It shows how much services output was produced relative to that in 1700 when measured on a log scale. 2017-08-26 19:45:12 2023-07-07 15:43:25   England 1270-1870 Output of key services sectors in England - using Bank of England (2017) 707 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2867   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
8871 Housing and Domestic Services   Total output of the housing and domestic services sector, indexed to the year 1700, in log scale. It shows how much production took place in housing and domestic services sector relative to that in 1700 when measured on a log scale. 2017-08-26 19:45:12 2023-07-07 15:43:32   England 1270-1870 Output of key services sectors in England - using Bank of England (2017) 707 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2867   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
8870 Financial Services   Total output of the financial services sector, indexed to the year 1700, in log scale. It shows how much production took place in financial services sector relative to that in 1700 when measured on a log scale. 2017-08-26 19:45:12 2023-07-07 15:43:36   England 1270-1870 Output of key services sectors in England - using Bank of England (2017) 707 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2867   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
8869 Trade and Transport   Total output of the trade and transport sector, indexed to the year 1700, in log scale. It shows how much production took place in trade and transport sector relative to that in 1700 when measured on a log scale. 2017-08-26 19:45:12 2023-07-07 15:43:29   England 1270-1870 Output of key services sectors in England - using Bank of England (2017) 707 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2867   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
8868 Government Services   Total output of the government services sector, indexed to the year 1700, in log scale. It shows how much production took place in government services sector relative to that in 1700 when measured on a log scale. 2017-08-26 19:45:12 2023-07-07 15:43:39   England 1270-1870 Output of key services sectors in England - using Bank of England (2017) 707 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2867   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 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");