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

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid id ▲ name unit description createdAt updatedAt code coverage timespan datasetId sourceId shortUnit display columnOrder originalMetadata shortName catalogPath dimensions schemaVersion processingLevel processingLog titlePublic titleVariant attributionShort attribution descriptionShort descriptionFromProducer descriptionKey descriptionProcessing licenses license type sort grapherConfigIdAdmin grapherConfigIdETL dataChecksum metadataChecksum
4594
 4594
 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
 707
 2867
   {"includeInTable": true, "numDecimalPlaces": 1}
 0
         1
                                    
4593
 4593
 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
 707
 2867
   {"includeInTable": true, "numDecimalPlaces": 1}
 0
         1
                                    
4592
 4592
 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
 707
 2867
   {"includeInTable": true, "numDecimalPlaces": 1}
 0
         1
                                    
4591
 4591
 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
 707
 2867
   {"includeInTable": true, "numDecimalPlaces": 1}
 0
         1
                                    
4590
 4590
 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
 707
 2867
   {"includeInTable": true, "numDecimalPlaces": 1}
 0
         1
                                    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE variables(id INTEGER, "name" VARCHAR, unit VARCHAR, description VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, code VARCHAR, coverage VARCHAR, timespan VARCHAR, datasetId INTEGER, sourceId INTEGER, shortUnit VARCHAR, display VARCHAR, columnOrder INTEGER, originalMetadata VARCHAR, shortName VARCHAR, catalogPath VARCHAR, dimensions VARCHAR, schemaVersion INTEGER, processingLevel VARCHAR, processingLog VARCHAR, titlePublic VARCHAR, titleVariant VARCHAR, attributionShort VARCHAR, attribution VARCHAR, descriptionShort VARCHAR, descriptionFromProducer VARCHAR, descriptionKey VARCHAR, descriptionProcessing VARCHAR, licenses VARCHAR, license VARCHAR, "type" VARCHAR, sort VARCHAR, grapherConfigIdAdmin VARCHAR, grapherConfigIdETL VARCHAR, dataChecksum VARCHAR, metadataChecksum VARCHAR);;