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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, description, updatedAt, timespan, display, 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
1818 Number of people employed in services (Herrendorf et al. data) People Historical estimates of employment (number of people) by economic sector. 2017-05-10 00:39:15 2023-06-15 05:05:42   Selected countries Latest observation: 2016 Historical employment and output by sector – OWID (2017) 464 Our World In Data based on Herrendorf et al. (2014) 586   
{
    "unit": "Rate"
}
 0           1                                  
1817 Number of people employed in industry (Herrendorf et al. data) People Historical estimates of employment (number of people) by economic sector. 2017-05-10 00:39:15 2023-06-15 05:05:42   Selected countries Latest observation: 2016 Historical employment and output by sector – OWID (2017) 464 Our World In Data based on Herrendorf et al. (2014) 586   
{
    "unit": "Rate"
}
 0           1                                  
1816 Number of people employed in agriculture (Herrendorf et al. data) People Historical estimates of employment (number of people) by economic sector. 2017-05-10 00:39:15 2023-06-15 05:05:42   Selected countries Latest observation: 2016 Historical employment and output by sector – OWID (2017) 464 Our World In Data based on Herrendorf et al. (2014) 586   
{
    "unit": "Rate"
}
 0           1                                  
1815 Share of services in GDP at current prices (Herrendorf et al. data) % GDP Historical estimates of value added by economic sector, at current prices (expressed as share of total value added at current prices) 2017-05-10 00:39:15 2023-07-07 16:06:01   Selected countries Latest observation: 2016 Historical employment and output by sector – OWID (2017) 464 Our World In Data based on Herrendorf et al. (2014) 586 % 
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
1814 Share of industry in GDP at current prices (Herrendorf et al. data) % GDP Historical estimates of value added by economic sector, at current prices (expressed as share of total value added at current prices) 2017-05-10 00:39:15 2023-07-07 16:06:04   Selected countries Latest observation: 2016 Historical employment and output by sector – OWID (2017) 464 Our World In Data based on Herrendorf et al. (2014) 586 % 
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
1813 Share of agriculture in GDP at current prices (Herrendorf et al. data) % GDP Historical estimates of value added by economic sector, at current prices (expressed as share of total value added at current prices) 2017-05-10 00:39:15 2023-07-07 16:06:07   Selected countries Earliest observation: 1800. Latest observation: 2016 Historical employment and output by sector – OWID (2017) 464 Our World In Data based on Herrendorf et al. (2014) 586 % 
{
    "unit": "%",
    "shortUnit": "%",
    "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");