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

8 rows where datasetId = 705 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, 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
8863 Printed books   Total output of printed books, indexed to the year 1700 in log scale. It shows how many books were printed relative to that in 1700 when measured on a log scale. 2017-08-26 19:25:46 2023-07-07 15:21:18   England 1270-1870 Output of key industries in England - using Bank of England (2017) 705 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2865   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
8862 Construction   Total construction output, indexed to the year 1700 in log scale. It shows how much construction was done relative to that in 1700 when measured on a log scale. 2017-08-26 19:25:46 2023-07-07 15:20:54   England 1270-1870 Output of key industries in England - using Bank of England (2017) 705 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2865   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
8861 Foodstuffs   Total output of foodstuffs, indexed to the year 1700 in log scale. It shows how much foodstuffs was produced relative to that in 1700 when measured on a log scale. 2017-08-26 19:25:46 2023-07-07 15:20:59   England 1270-1870 Output of key industries in England - using Bank of England (2017) 705 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2865   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
8860 Leather   Total output of leather, indexed to the year 1700 in log scale. It shows how much leather was produced relative to that in 1700 when measured on a log scale. 2017-08-26 19:25:46 2023-07-07 15:21:02   England 1270-1870 Output of key industries in England - using Bank of England (2017) 705 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2865   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
8859 Wool/Textiles   Total output of wool/textiles, indexed to the year 1700 in log scale. It shows how much wool/textiles was produced relative to that in 1700 when measured on a log scale. 2017-08-26 19:25:46 2023-07-07 15:21:05   England 1270-1870 Output of key industries in England - using Bank of England (2017) 705 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2865   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
8858 Coal   Total output of coal, indexed to the year 1700 in log scale. It shows how much coal was produced relative to that in 1700 when measured on a log scale. 2017-08-26 19:25:45 2023-07-07 15:21:09   England 1270-1870 Output of key industries in England - using Bank of England (2017) 705 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2865   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
8857 Iron   Total output of iron, indexed to the year 1700 in log scale. It shows how much iron was produced relative to that in 1700 when measured on a log scale. 2017-08-26 19:25:45 2023-07-07 15:21:12   England 1270-1870 Output of key industries in England - using Bank of England (2017) 705 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2865   
{
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
8856 Tin   Total output of tin, indexed to the year 1700 in log scale. It shows how much tin was produced relative to that in 1700 when measured on a log scale. 2017-08-26 19:25:45 2023-07-07 15:21:15   England 1270-1870 Output of key industries in England - using Bank of England (2017) 705 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 2865   
{
    "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");