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

16 rows where datasetId = 5701 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, description, shortUnit, 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
486623 Soil nutrient budget | 00005081 || Cropland nutrient flow | 007275 || tonnes tonnes   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 tonnes 
{
    "name": "Soil nutrient budget - Cropland nutrient flow (tonnes)",
    "unit": "tonnes",
    "shortUnit": "tonnes"
}
 0 
{}
   soil_nutrient_budget_00005081_cropland_nutrient_flow_007275_tonnes     1                                  
486622 Soil nutrient budget | 00005081 || Cropland nutrient flow per unit area | 007276 || kilograms per hectare kilograms per hectare   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 kg/ha 
{
    "name": "Soil nutrient budget - Cropland nutrient flow per unit area (kilograms per hectare)",
    "unit": "kilograms per hectare",
    "shortUnit": "kg/ha"
}
 0 
{}
   soil_nutrient_budget_00005081_cropland_nutrient_flow_per_unit_area_007276_kilograms_per_hectare     1                                  
486621 Input | 00005079 || Cropland nutrient flow | 007275 || tonnes tonnes   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 tonnes 
{
    "name": "Input - Cropland nutrient flow (tonnes)",
    "unit": "tonnes",
    "shortUnit": "tonnes"
}
 0 
{}
   input_00005079_cropland_nutrient_flow_007275_tonnes     1                                  
486620 Synthetic Fertilizers | 00005061 || Cropland nutrient flow per unit area | 007276 || kilograms per hectare kilograms per hectare Inorganic material of synthetic origin added to a soil to supply one or more plant nutrients essential to the growth of plants. Greenhouse gas emissions from synthetic fertilizers consist of the addition of nitrous oxide gas to managed soils. 2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 kg/ha 
{
    "name": "Synthetic Fertilizers - Cropland nutrient flow per unit area (kilograms per hectare)",
    "unit": "kilograms per hectare",
    "shortUnit": "kg/ha"
}
 0 
{}
   synthetic_fertilizers_00005061_cropland_nutrient_flow_per_unit_area_007276_kilograms_per_hectare     1                                  
486619 Outputs | 00005080 || Cropland nutrient flow | 007275 || tonnes tonnes   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 tonnes 
{
    "name": "Outputs - Cropland nutrient flow (tonnes)",
    "unit": "tonnes",
    "shortUnit": "tonnes"
}
 0 
{}
   outputs_00005080_cropland_nutrient_flow_007275_tonnes     1                                  
486618 Synthetic Fertilizers | 00005061 || Cropland nutrient flow | 007275 || tonnes tonnes Inorganic material of synthetic origin added to a soil to supply one or more plant nutrients essential to the growth of plants. Greenhouse gas emissions from synthetic fertilizers consist of the addition of nitrous oxide gas to managed soils. 2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 tonnes 
{
    "name": "Synthetic Fertilizers - Cropland nutrient flow (tonnes)",
    "unit": "tonnes",
    "shortUnit": "tonnes"
}
 0 
{}
   synthetic_fertilizers_00005061_cropland_nutrient_flow_007275_tonnes     1                                  
486617 Outputs | 00005080 || Cropland nutrient flow per unit area | 007276 || kilograms per hectare kilograms per hectare   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 kg/ha 
{
    "name": "Outputs - Cropland nutrient flow per unit area (kilograms per hectare)",
    "unit": "kilograms per hectare",
    "shortUnit": "kg/ha"
}
 0 
{}
   outputs_00005080_cropland_nutrient_flow_per_unit_area_007276_kilograms_per_hectare     1                                  
486616 Input | 00005079 || Cropland nutrient flow per unit area | 007276 || kilograms per hectare kilograms per hectare   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 kg/ha 
{
    "name": "Input - Cropland nutrient flow per unit area (kilograms per hectare)",
    "unit": "kilograms per hectare",
    "shortUnit": "kg/ha"
}
 0 
{}
   input_00005079_cropland_nutrient_flow_per_unit_area_007276_kilograms_per_hectare     1                                  
486615 Crop Removal | 00005077 || Cropland nutrient flow | 007275 || tonnes tonnes   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 tonnes 
{
    "name": "Crop Removal - Cropland nutrient flow (tonnes)",
    "unit": "tonnes",
    "shortUnit": "tonnes"
}
 0 
{}
   crop_removal_00005077_cropland_nutrient_flow_007275_tonnes     1                                  
486614 Crop Removal | 00005077 || Cropland nutrient flow per unit area | 007276 || kilograms per hectare kilograms per hectare   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 kg/ha 
{
    "name": "Crop Removal - Cropland nutrient flow per unit area (kilograms per hectare)",
    "unit": "kilograms per hectare",
    "shortUnit": "kg/ha"
}
 0 
{}
   crop_removal_00005077_cropland_nutrient_flow_per_unit_area_007276_kilograms_per_hectare     1                                  
486613 Manure applied to Soils | 00005062 || Cropland nutrient flow per unit area | 007276 || kilograms per hectare kilograms per hectare Animal waste distributed on fields in amounts that enrich soils. Greenhouse gas emissions from manure applied to soils consist of nitrous oxide gas from manure added to managed soils. 2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 kg/ha 
{
    "name": "Manure applied to Soils - Cropland nutrient flow per unit area (kilograms per hectare)",
    "unit": "kilograms per hectare",
    "shortUnit": "kg/ha"
}
 0 
{}
   manure_applied_to_soils_00005062_cropland_nutrient_flow_per_unit_area_007276_kilograms_per_hectare     1                                  
486612 Manure applied to Soils | 00005062 || Cropland nutrient flow | 007275 || tonnes tonnes Animal waste distributed on fields in amounts that enrich soils. Greenhouse gas emissions from manure applied to soils consist of nitrous oxide gas from manure added to managed soils. 2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 tonnes 
{
    "name": "Manure applied to Soils - Cropland nutrient flow (tonnes)",
    "unit": "tonnes",
    "shortUnit": "tonnes"
}
 0 
{}
   manure_applied_to_soils_00005062_cropland_nutrient_flow_007275_tonnes     1                                  
486611 Biological Fixation | 00005078 || Cropland nutrient flow | 007275 || tonnes tonnes   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 tonnes 
{
    "name": "Biological Fixation - Cropland nutrient flow (tonnes)",
    "unit": "tonnes",
    "shortUnit": "tonnes"
}
 0 
{}
   biological_fixation_00005078_cropland_nutrient_flow_007275_tonnes     1                                  
486610 Biological Fixation | 00005078 || Cropland nutrient flow per unit area | 007276 || kilograms per hectare kilograms per hectare   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 kg/ha 
{
    "name": "Biological Fixation - Cropland nutrient flow per unit area (kilograms per hectare)",
    "unit": "kilograms per hectare",
    "shortUnit": "kg/ha"
}
 0 
{}
   biological_fixation_00005078_cropland_nutrient_flow_per_unit_area_007276_kilograms_per_hectare     1                                  
486609 Atmospheric Deposition | 00005076 || Cropland nutrient flow | 007275 || tonnes tonnes   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 tonnes 
{
    "name": "Atmospheric Deposition - Cropland nutrient flow (tonnes)",
    "unit": "tonnes",
    "shortUnit": "tonnes"
}
 0 
{}
   atmospheric_deposition_00005076_cropland_nutrient_flow_007275_tonnes     1                                  
486608 Atmospheric Deposition | 00005076 || Cropland nutrient flow per unit area | 007276 || kilograms per hectare kilograms per hectare   2022-08-23 19:31:36 2023-06-15 05:05:42     1961-2018 Land, Inputs and Sustainability: Soil nutrient budget (FAO, 2022-05-17) 5701 Food and Agriculture Organization of the United Nations 26724 kg/ha 
{
    "name": "Atmospheric Deposition - Cropland nutrient flow per unit area (kilograms per hectare)",
    "unit": "kilograms per hectare",
    "shortUnit": "kg/ha"
}
 0 
{}
   atmospheric_deposition_00005076_cropland_nutrient_flow_per_unit_area_007276_kilograms_per_hectare     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");