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

5 rows where datasetId = 5020 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, 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
135462 Grassland - Grassland organic soils - 6728 - Net stock change (C) (Grassland) - 72161 - gigagrams gigagrams Greenhouse gas (GHG) emissions in the domain "Grassland" are currently limited to the CO2 emissions from grassland organic soils. They are those associated with carbon losses from drained histosols under grassland. 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/vol6.html)applied to geospatial data.GHG emissions are provided by country, region and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net emissions/removal Gg CO2 and Gg CO2eq. Implied emission factor for C, net stock change Gg C and activity data (area) are also provided. 2020-02-14 02:24:44 2023-06-15 05:05:42 GG - 6728 - 72161 - gigagrams     Emissions - Land Use: Grassland 5020 Emissions - Land Use: Grassland 17751   
{}
 0           1                                  
135461 Grassland - Grassland organic soils - 6728 - Net emissions/removals (CO2) (Grassland) - 72331 - gigagrams gigagrams Greenhouse gas (GHG) emissions in the domain "Grassland" are currently limited to the CO2 emissions from grassland organic soils. They are those associated with carbon losses from drained histosols under grassland. 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/vol6.html)applied to geospatial data.GHG emissions are provided by country, region and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net emissions/removal Gg CO2 and Gg CO2eq. Implied emission factor for C, net stock change Gg C and activity data (area) are also provided. 2020-02-14 02:24:43 2023-06-15 05:05:42 GG - 6728 - 72331 - gigagrams     Emissions - Land Use: Grassland 5020 Emissions - Land Use: Grassland 17751   
{}
 0           1                                  
135460 Grassland - Grassland organic soils - 6728 - Net emissions/removal (CO2eq) (Grassland) - 72171 - gigagrams gigagrams Greenhouse gas (GHG) emissions in the domain "Grassland" are currently limited to the CO2 emissions from grassland organic soils. They are those associated with carbon losses from drained histosols under grassland. 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/vol6.html)applied to geospatial data.GHG emissions are provided by country, region and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net emissions/removal Gg CO2 and Gg CO2eq. Implied emission factor for C, net stock change Gg C and activity data (area) are also provided. 2020-02-14 02:24:43 2023-06-15 05:05:42 GG - 6728 - 72171 - gigagrams     Emissions - Land Use: Grassland 5020 Emissions - Land Use: Grassland 17751   
{}
 0           1                                  
135459 Grassland - Grassland organic soils - 6728 - Implied emission factor for C (Grassland) - 72411 - tonnes C/ha tonnes C/ha Greenhouse gas (GHG) emissions in the domain "Grassland" are currently limited to the CO2 emissions from grassland organic soils. They are those associated with carbon losses from drained histosols under grassland. 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/vol6.html)applied to geospatial data.GHG emissions are provided by country, region and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net emissions/removal Gg CO2 and Gg CO2eq. Implied emission factor for C, net stock change Gg C and activity data (area) are also provided. 2020-02-14 02:24:42 2023-06-15 05:05:42 GG - 6728 - 72411 - tonnes C/ha     Emissions - Land Use: Grassland 5020 Emissions - Land Use: Grassland 17751   
{}
 0           1                                  
135458 Grassland - Grassland organic soils - 6728 - Area - 5026 - ha ha Greenhouse gas (GHG) emissions in the domain "Grassland" are currently limited to the CO2 emissions from grassland organic soils. They are those associated with carbon losses from drained histosols under grassland. 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/vol6.html)applied to geospatial data.GHG emissions are provided by country, region and special groups, with global coverage, relative to the period 1990-present (with annual updates), expressed as net emissions/removal Gg CO2 and Gg CO2eq. Implied emission factor for C, net stock change Gg C and activity data (area) are also provided. 2020-02-14 02:24:42 2023-06-15 05:05:42 GG - 6728 - 5026 - ha     Emissions - Land Use: Grassland 5020 Emissions - Land Use: Grassland 17751   
{}
 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");