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

15 rows where datasetId = 5006 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
130804 Land use indicators - Primary Forest - 6714 - Share in Forest land - 7210 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:37 2023-06-15 05:05:42 EL - 6714 - 7210 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130803 Land use indicators - Planted Forest - 6716 - Share in Forest land - 7210 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:36 2023-06-15 05:05:42 EL - 6716 - 7210 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130802 Land use indicators - Other naturally regenerated forest - 6717 - Share in Forest land - 7210 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:35 2023-06-15 05:05:42 EL - 6717 - 7210 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130801 Land use indicators - Land under permanent crops - 6650 - Share in Agricultural land - 7208 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:33 2023-06-15 05:05:42 EL - 6650 - 7208 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130800 Land use indicators - Land under perm. meadows and pastures - 6655 - Share in Land area - 7209 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:31 2023-06-15 05:05:42 EL - 6655 - 7209 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130799 Land use indicators - Land under perm. meadows and pastures - 6655 - Share in Agricultural land - 7208 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:29 2023-06-15 05:05:42 EL - 6655 - 7208 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130798 Land use indicators - Land area equipped for irrigation - 6690 - Share in Cropland - 7252 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:28 2023-06-15 05:05:42 EL - 6690 - 7252 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130797 Land use indicators - Land area equipped for irrigation - 6690 - Share in Agricultural land - 7208 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:26 2023-06-15 05:05:42 EL - 6690 - 7208 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130796 Land use indicators - Forest land - 6646 - Share in Land area - 7209 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:25 2023-06-15 05:05:42 EL - 6646 - 7209 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130795 Land use indicators - Cropland - 6620 - Share in Land area - 7209 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:23 2023-06-15 05:05:42 EL - 6620 - 7209 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130794 Land use indicators - Cropland - 6620 - Share in Agricultural land - 7208 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:21 2023-06-15 05:05:42 EL - 6620 - 7208 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130793 Land use indicators - Arable land - 6621 - Share in Agricultural land - 7208 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:19 2023-06-15 05:05:42 EL - 6621 - 7208 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130792 Land use indicators - Agriculture area under organic agric. - 6671 - Share in Agricultural land - 7208 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:19 2023-06-15 05:05:42 EL - 6671 - 7208 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130791 Land use indicators - Agriculture area actually irrigated - 6611 - Share in Agricultural land - 7208 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:19 2023-06-15 05:05:42 EL - 6611 - 7208 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 0           1                                  
130790 Land use indicators - Agricultural land - 6610 - Share in Land area - 7209 - % % The Agri-environmental Indicators—Land Use domain provides information on the distribution of agricultural and forest land, and their sub-components, including irrigated areas and areas under organic agriculture, at national, regional and global levels. 2020-02-14 01:35:17 2023-06-15 05:05:42 EL - 6610 - 7209 - %     Agri-Environmental Indicators: Land use indicators 5006 Agri-Environmental Indicators: Land use indicators 17737   
{}
 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");