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

14 rows where datasetId = 5023 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
135579 Land Use Total - Land Use total - 1707 - Net emissions/removals (CO2eq) - 7217 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:43 2023-06-15 05:05:42 GL - 1707 - 7217 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135578 Land Use Total - Land Use total - 1707 - Net emissions/removals (CO2) - 7233 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:42 2023-06-15 05:05:42 GL - 1707 - 7233 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135577 Land Use Total - Land Use total - 1707 - Emissions (CO2eq) from N2O - 7243 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:40 2023-06-15 05:05:42 GL - 1707 - 7243 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135576 Land Use Total - Land Use total - 1707 - Emissions (CO2eq) from CH4 - 7244 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:40 2023-06-15 05:05:42 GL - 1707 - 7244 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135575 Land Use Total - Grassland - 6794 - Net emissions/removals (CO2eq) - 7217 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:39 2023-06-15 05:05:42 GL - 6794 - 7217 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135574 Land Use Total - Grassland - 6794 - Net emissions/removals (CO2) - 7233 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:38 2023-06-15 05:05:42 GL - 6794 - 7233 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135573 Land Use Total - Forest land - 5065 - Net emissions/removals (CO2eq) - 7217 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:37 2023-06-15 05:05:42 GL - 5065 - 7217 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135572 Land Use Total - Forest land - 5065 - Net emissions/removals (CO2) - 7233 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:35 2023-06-15 05:05:42 GL - 5065 - 7233 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135571 Land Use Total - Cropland - 5070 - Net emissions/removals (CO2eq) - 7217 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:34 2023-06-15 05:05:42 GL - 5070 - 7217 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135570 Land Use Total - Cropland - 5070 - Net emissions/removals (CO2) - 7233 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:34 2023-06-15 05:05:42 GL - 5070 - 7233 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135569 Land Use Total - Burning Biomass - 5069 - Net emissions/removals (CO2eq) - 7217 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:33 2023-06-15 05:05:42 GL - 5069 - 7217 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135568 Land Use Total - Burning Biomass - 5069 - Net emissions/removals (CO2) - 7233 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:32 2023-06-15 05:05:42 GL - 5069 - 7233 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135567 Land Use Total - Burning Biomass - 5069 - Emissions (CO2eq) from N2O - 7243 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:31 2023-06-15 05:05:42 GL - 5069 - 7243 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 0           1                                  
135566 Land Use Total - Burning Biomass - 5069 - Emissions (CO2eq) from CH4 - 7244 - gigagrams gigagrams Land Use Total contains all GHG emissions and removals produced in the different Land Use sub-domains, representing the three IPCC Land Use categories: cropland, forest land, and grassland, collectively called emissions/removals from the Forestry and Other Land Use (FOLU) sector. FOLU emissions consist of CO2 (carbon dioxide), CH4 (methane) and N2O (nitrous oxide) associated with land management activities. CO2 emissions/removals are derived from estimated net carbon stock changes in above and below-ground biomass pools of forest land, including forest land converted to other land uses. CH4 and N2O, and additional CO2 emissions are estimated for fires and drainage of organic soils. 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). GHG emissions are provided as by country, regions and special groups, with global coverage, relative to the period 1990-most recent available year (with annual updates), expressed as Gg CO2eq from CH4 and N2O, net emissions/removals as GG CO2 and Gg CO2eq, by underlying land use emission sub-domain and by aggregate (land use total). 2020-02-14 02:26:30 2023-06-15 05:05:42 GL - 5069 - 7244 - gigagrams     Emissions - Land Use: Land Use Total 5023 Emissions - Land Use: Land Use Total 17754   
{}
 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");