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

12 rows where datasetId = 5050 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
140247 Fertilizers by Nutrient - Nutrient potash K2O (total) - 3104 - Production - 5510 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:45 2023-06-15 05:05:42 RFN - 3104 - 5510 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 0           1                                  
140246 Fertilizers by Nutrient - Nutrient potash K2O (total) - 3104 - Import Quantity - 5610 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:45 2023-06-15 05:05:42 RFN - 3104 - 5610 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 0           1                                  
140245 Fertilizers by Nutrient - Nutrient potash K2O (total) - 3104 - Export Quantity - 5910 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:44 2023-06-15 05:05:42 RFN - 3104 - 5910 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 0           1                                  
140244 Fertilizers by Nutrient - Nutrient potash K2O (total) - 3104 - Agricultural Use - 5157 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:43 2023-06-15 05:05:42 RFN - 3104 - 5157 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 0           1                                  
140243 Fertilizers by Nutrient - Nutrient phosphate P2O5 (total) - 3103 - Production - 5510 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:43 2023-06-15 05:05:42 RFN - 3103 - 5510 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 0           1                                  
140242 Fertilizers by Nutrient - Nutrient phosphate P2O5 (total) - 3103 - Import Quantity - 5610 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:42 2023-06-15 05:05:42 RFN - 3103 - 5610 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 0           1                                  
140241 Fertilizers by Nutrient - Nutrient phosphate P2O5 (total) - 3103 - Export Quantity - 5910 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:42 2023-06-15 05:05:42 RFN - 3103 - 5910 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 0           1                                  
140240 Fertilizers by Nutrient - Nutrient phosphate P2O5 (total) - 3103 - Agricultural Use - 5157 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:42 2023-06-15 05:05:42 RFN - 3103 - 5157 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 0           1                                  
140239 Fertilizers by Nutrient - Nutrient nitrogen N (total) - 3102 - Production - 5510 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:41 2023-06-15 05:05:42 RFN - 3102 - 5510 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 0           1                                  
140238 Fertilizers by Nutrient - Nutrient nitrogen N (total) - 3102 - Import Quantity - 5610 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:41 2023-06-15 05:05:42 RFN - 3102 - 5610 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 0           1                                  
140237 Fertilizers by Nutrient - Nutrient nitrogen N (total) - 3102 - Export Quantity - 5910 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:40 2023-06-15 05:05:42 RFN - 3102 - 5910 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 0           1                                  
140236 Fertilizers by Nutrient - Nutrient nitrogen N (total) - 3102 - Agricultural Use - 5157 - tonnes tonnes The Fertilizers by Nutrient dataset contains information on the totals in nutrients for Production, Trade, Agriculture Use and Other Uses of chemical and mineral fertilizers, over the time series 2002-present. The fertilizer statistics data are validated in terms of summary totals of Production, Import, Export, non-Fertilizer Use and Agricultural Use, separately for the three main plant nutrients: nitrogen (N), phosphate (P2O5), potash (K2O). Both straight and compound fertilizers are included. Detailed information on Fertilizers by Nutrient Methodology at: http://fenixservices.fao.org/faostat/static/documents/RFN/RFN_EN_README.pdf 2020-02-14 03:20:40 2023-06-15 05:05:42 RFN - 3102 - 5157 - tonnes     Inputs: Fertilizers by Nutrient 5050 Inputs: Fertilizers by Nutrient 17781   
{}
 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");