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

4 rows where datasetId = 5027 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, 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
136298 Rice Cultivation - Rice, paddy - 27 - Implied emission factor for CH4 (Rice cultivation) - 72245 - g CH4/m2 g CH4/m2 Greenhouse gas (GHG) emissions from rice cultivation consist of methane gas from the anaerobic decomposition of organic matter in paddy fields. The FAOSTAT emissions database is computed following Tier 1 IPCC 2006 Guidelines for National GHG Inventories (http://www.ipcc-nggip.iges.or.jp/public/2006gl/vol4.html) and the IPCC 2000 Good Practice Guidance and Uncertainty Management in National GHG Inventories (http://www.ipcc-nggip.iges.or.jp/public/gp/english/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1961-present (with annual updates) and with projections for 2030 and 2050, expressed both as Gg CH4 and Gg CO2eq. Implied emission factor for CH4 and activity data are also provided. 2020-02-14 02:43:06 2023-06-15 05:05:42 GR - 27 - 72245 - g CH4/m2     Emissions - Agriculture: Rice Cultivation 5027 Emissions - Agriculture: Rice Cultivation 17758   
{}
 0           1                                  
136297 Rice Cultivation - Rice, paddy - 27 - Emissions (CO2eq) (Rice cultivation) - 72315 - gigagrams gigagrams Greenhouse gas (GHG) emissions from rice cultivation consist of methane gas from the anaerobic decomposition of organic matter in paddy fields. The FAOSTAT emissions database is computed following Tier 1 IPCC 2006 Guidelines for National GHG Inventories (http://www.ipcc-nggip.iges.or.jp/public/2006gl/vol4.html) and the IPCC 2000 Good Practice Guidance and Uncertainty Management in National GHG Inventories (http://www.ipcc-nggip.iges.or.jp/public/gp/english/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1961-present (with annual updates) and with projections for 2030 and 2050, expressed both as Gg CH4 and Gg CO2eq. Implied emission factor for CH4 and activity data are also provided. 2020-02-14 02:43:04 2023-06-15 05:05:42 GR - 27 - 72315 - gigagrams     Emissions - Agriculture: Rice Cultivation 5027 Emissions - Agriculture: Rice Cultivation 17758   
{}
 0           1                                  
136296 Rice Cultivation - Rice, paddy - 27 - Emissions (CH4) (Rice cultivation) - 72255 - gigagrams gigagrams Greenhouse gas (GHG) emissions from rice cultivation consist of methane gas from the anaerobic decomposition of organic matter in paddy fields. The FAOSTAT emissions database is computed following Tier 1 IPCC 2006 Guidelines for National GHG Inventories (http://www.ipcc-nggip.iges.or.jp/public/2006gl/vol4.html) and the IPCC 2000 Good Practice Guidance and Uncertainty Management in National GHG Inventories (http://www.ipcc-nggip.iges.or.jp/public/gp/english/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1961-present (with annual updates) and with projections for 2030 and 2050, expressed both as Gg CH4 and Gg CO2eq. Implied emission factor for CH4 and activity data are also provided. 2020-02-14 02:43:03 2023-06-15 05:05:42 GR - 27 - 72255 - gigagrams     Emissions - Agriculture: Rice Cultivation 5027 Emissions - Agriculture: Rice Cultivation 17758   
{}
 0           1                                  
136295 Rice Cultivation - Rice, paddy - 27 - Area harvested - 5312 - ha ha Greenhouse gas (GHG) emissions from rice cultivation consist of methane gas from the anaerobic decomposition of organic matter in paddy fields. The FAOSTAT emissions database is computed following Tier 1 IPCC 2006 Guidelines for National GHG Inventories (http://www.ipcc-nggip.iges.or.jp/public/2006gl/vol4.html) and the IPCC 2000 Good Practice Guidance and Uncertainty Management in National GHG Inventories (http://www.ipcc-nggip.iges.or.jp/public/gp/english/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1961-present (with annual updates) and with projections for 2030 and 2050, expressed both as Gg CH4 and Gg CO2eq. Implied emission factor for CH4 and activity data are also provided. 2020-02-14 02:43:01 2023-06-15 05:05:42 GR - 27 - 5312 - ha     Emissions - Agriculture: Rice Cultivation 5027 Emissions - Agriculture: Rice Cultivation 17758   
{}
 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");