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

11 rows where datasetId = 5019 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
135457 Forest Land - Net Forest conversion - 6750 - Net emissions/removals (CO2) (Forest land) - 72332 - gigagrams gigagrams Annual net CO2 emission/removal from Forest Land consist of net carbon stock gain/loss in the living biomass pool (aboveground and belowground biomass) associated with Forest and Net Forest Conversion. 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/index.html) and using area and carbon stocks data compiled by countries in the FAO Global Forest Resource Assessments (http://www.fao.org/forestry/fra/en/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net stock change Gg C, net emissions/removals Gg CO2 and CO2eq, by forest or net forest conversion and by aggregate (forest land). Implied emission factor for CO2 as well as activity data (area, net area difference, total forest area and carbon stock in living biomass) are also given. 2020-02-14 02:24:41 2023-06-15 05:05:42 GF - 6750 - 72332 - gigagrams     Emissions - Land Use: Forest Land 5019 Emissions - Land Use: Forest Land 17750   
{}
 0           1                                  
135456 Forest Land - Net Forest conversion - 6750 - Net emissions/removal (CO2eq) (Forest land) - 72172 - gigagrams gigagrams Annual net CO2 emission/removal from Forest Land consist of net carbon stock gain/loss in the living biomass pool (aboveground and belowground biomass) associated with Forest and Net Forest Conversion. 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/index.html) and using area and carbon stocks data compiled by countries in the FAO Global Forest Resource Assessments (http://www.fao.org/forestry/fra/en/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net stock change Gg C, net emissions/removals Gg CO2 and CO2eq, by forest or net forest conversion and by aggregate (forest land). Implied emission factor for CO2 as well as activity data (area, net area difference, total forest area and carbon stock in living biomass) are also given. 2020-02-14 02:24:40 2023-06-15 05:05:42 GF - 6750 - 72172 - gigagrams     Emissions - Land Use: Forest Land 5019 Emissions - Land Use: Forest Land 17750   
{}
 0           1                                  
135455 Forest Land - Net Forest conversion - 6750 - Implied emission factor for CO2 - 71952 - tonnes CO2/ha tonnes CO2/ha Annual net CO2 emission/removal from Forest Land consist of net carbon stock gain/loss in the living biomass pool (aboveground and belowground biomass) associated with Forest and Net Forest Conversion. 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/index.html) and using area and carbon stocks data compiled by countries in the FAO Global Forest Resource Assessments (http://www.fao.org/forestry/fra/en/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net stock change Gg C, net emissions/removals Gg CO2 and CO2eq, by forest or net forest conversion and by aggregate (forest land). Implied emission factor for CO2 as well as activity data (area, net area difference, total forest area and carbon stock in living biomass) are also given. 2020-02-14 02:24:39 2023-06-15 05:05:42 GF - 6750 - 71952 - tonnes CO2/ha     Emissions - Land Use: Forest Land 5019 Emissions - Land Use: Forest Land 17750   
{}
 0           1                                  
135454 Forest Land - Net Forest conversion - 6750 - Area - 5110 - 1000 ha 1000 ha Annual net CO2 emission/removal from Forest Land consist of net carbon stock gain/loss in the living biomass pool (aboveground and belowground biomass) associated with Forest and Net Forest Conversion. 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/index.html) and using area and carbon stocks data compiled by countries in the FAO Global Forest Resource Assessments (http://www.fao.org/forestry/fra/en/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net stock change Gg C, net emissions/removals Gg CO2 and CO2eq, by forest or net forest conversion and by aggregate (forest land). Implied emission factor for CO2 as well as activity data (area, net area difference, total forest area and carbon stock in living biomass) are also given. 2020-02-14 02:24:38 2023-06-15 05:05:42 GF - 6750 - 5110 - 1000 ha     Emissions - Land Use: Forest Land 5019 Emissions - Land Use: Forest Land 17750   
{}
 0           1                                  
135453 Forest Land - Forest land - 6749 - Net emissions/removals (CO2) (Forest land) - 72332 - gigagrams gigagrams Annual net CO2 emission/removal from Forest Land consist of net carbon stock gain/loss in the living biomass pool (aboveground and belowground biomass) associated with Forest and Net Forest Conversion. 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/index.html) and using area and carbon stocks data compiled by countries in the FAO Global Forest Resource Assessments (http://www.fao.org/forestry/fra/en/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net stock change Gg C, net emissions/removals Gg CO2 and CO2eq, by forest or net forest conversion and by aggregate (forest land). Implied emission factor for CO2 as well as activity data (area, net area difference, total forest area and carbon stock in living biomass) are also given. 2020-02-14 02:24:37 2023-06-15 05:05:42 GF - 6749 - 72332 - gigagrams     Emissions - Land Use: Forest Land 5019 Emissions - Land Use: Forest Land 17750   
{}
 0           1                                  
135452 Forest Land - Forest land - 6749 - Net emissions/removal (CO2eq) (Forest land) - 72172 - gigagrams gigagrams Annual net CO2 emission/removal from Forest Land consist of net carbon stock gain/loss in the living biomass pool (aboveground and belowground biomass) associated with Forest and Net Forest Conversion. 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/index.html) and using area and carbon stocks data compiled by countries in the FAO Global Forest Resource Assessments (http://www.fao.org/forestry/fra/en/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net stock change Gg C, net emissions/removals Gg CO2 and CO2eq, by forest or net forest conversion and by aggregate (forest land). Implied emission factor for CO2 as well as activity data (area, net area difference, total forest area and carbon stock in living biomass) are also given. 2020-02-14 02:24:36 2023-06-15 05:05:42 GF - 6749 - 72172 - gigagrams     Emissions - Land Use: Forest Land 5019 Emissions - Land Use: Forest Land 17750   
{}
 0           1                                  
135451 Forest Land - Forest land - 6749 - Area - 5110 - 1000 ha 1000 ha Annual net CO2 emission/removal from Forest Land consist of net carbon stock gain/loss in the living biomass pool (aboveground and belowground biomass) associated with Forest and Net Forest Conversion. 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/index.html) and using area and carbon stocks data compiled by countries in the FAO Global Forest Resource Assessments (http://www.fao.org/forestry/fra/en/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net stock change Gg C, net emissions/removals Gg CO2 and CO2eq, by forest or net forest conversion and by aggregate (forest land). Implied emission factor for CO2 as well as activity data (area, net area difference, total forest area and carbon stock in living biomass) are also given. 2020-02-14 02:24:35 2023-06-15 05:05:42 GF - 6749 - 5110 - 1000 ha     Emissions - Land Use: Forest Land 5019 Emissions - Land Use: Forest Land 17750   
{}
 0           1                                  
135450 Forest Land - Forest land - 6646 - Net emissions/removals (CO2) (Forest land) - 72332 - gigagrams gigagrams Annual net CO2 emission/removal from Forest Land consist of net carbon stock gain/loss in the living biomass pool (aboveground and belowground biomass) associated with Forest and Net Forest Conversion. 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/index.html) and using area and carbon stocks data compiled by countries in the FAO Global Forest Resource Assessments (http://www.fao.org/forestry/fra/en/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net stock change Gg C, net emissions/removals Gg CO2 and CO2eq, by forest or net forest conversion and by aggregate (forest land). Implied emission factor for CO2 as well as activity data (area, net area difference, total forest area and carbon stock in living biomass) are also given. 2020-02-14 02:24:34 2023-06-15 05:05:42 GF - 6646 - 72332 - gigagrams     Emissions - Land Use: Forest Land 5019 Emissions - Land Use: Forest Land 17750   
{}
 0           1                                  
135449 Forest Land - Forest land - 6646 - Net emissions/removal (CO2eq) (Forest land) - 72172 - gigagrams gigagrams Annual net CO2 emission/removal from Forest Land consist of net carbon stock gain/loss in the living biomass pool (aboveground and belowground biomass) associated with Forest and Net Forest Conversion. 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/index.html) and using area and carbon stocks data compiled by countries in the FAO Global Forest Resource Assessments (http://www.fao.org/forestry/fra/en/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net stock change Gg C, net emissions/removals Gg CO2 and CO2eq, by forest or net forest conversion and by aggregate (forest land). Implied emission factor for CO2 as well as activity data (area, net area difference, total forest area and carbon stock in living biomass) are also given. 2020-02-14 02:24:33 2023-06-15 05:05:42 GF - 6646 - 72172 - gigagrams     Emissions - Land Use: Forest Land 5019 Emissions - Land Use: Forest Land 17750   
{}
 0           1                                  
135448 Forest Land - Forest land - 6646 - Implied emission factor for CO2 - 71952 - tonnes CO2/ha tonnes CO2/ha Annual net CO2 emission/removal from Forest Land consist of net carbon stock gain/loss in the living biomass pool (aboveground and belowground biomass) associated with Forest and Net Forest Conversion. 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/index.html) and using area and carbon stocks data compiled by countries in the FAO Global Forest Resource Assessments (http://www.fao.org/forestry/fra/en/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net stock change Gg C, net emissions/removals Gg CO2 and CO2eq, by forest or net forest conversion and by aggregate (forest land). Implied emission factor for CO2 as well as activity data (area, net area difference, total forest area and carbon stock in living biomass) are also given. 2020-02-14 02:24:32 2023-06-15 05:05:42 GF - 6646 - 71952 - tonnes CO2/ha     Emissions - Land Use: Forest Land 5019 Emissions - Land Use: Forest Land 17750   
{}
 0           1                                  
135447 Forest Land - Forest land - 6646 - Area - 5110 - 1000 ha 1000 ha Annual net CO2 emission/removal from Forest Land consist of net carbon stock gain/loss in the living biomass pool (aboveground and belowground biomass) associated with Forest and Net Forest Conversion. 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/index.html) and using area and carbon stocks data compiled by countries in the FAO Global Forest Resource Assessments (http://www.fao.org/forestry/fra/en/). GHG emissions are provided by country, regions and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net stock change Gg C, net emissions/removals Gg CO2 and CO2eq, by forest or net forest conversion and by aggregate (forest land). Implied emission factor for CO2 as well as activity data (area, net area difference, total forest area and carbon stock in living biomass) are also given. 2020-02-14 02:24:31 2023-06-15 05:05:42 GF - 6646 - 5110 - 1000 ha     Emissions - Land Use: Forest Land 5019 Emissions - Land Use: Forest Land 17750   
{}
 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");