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 = 5017 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
135381 Cropland - Cropland organic soils - 6727 - Net stock change (C) (Cropland) - 72160 - gigagrams gigagrams Greenhouse gas (GHG) emissions in the domain "Cropland" are currently limited to CO2 emissions from cropland organic soils. They are those associated with carbon losses from drained histosols under cropland. 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/vol5.html) applied to geospatial data. GHG emissions are provided by country, region and special groups, with global coverage, relative to the period 1990-2016 (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:22:52 2023-06-15 05:05:42 GC - 6727 - 72160 - gigagrams     Emissions - Land Use: Cropland 5017 Emissions - Land Use: Cropland 17748   
{}
 0           1                                  
135380 Cropland - Cropland organic soils - 6727 - Net emissions/removals (CO2) (Cropland) - 72330 - gigagrams gigagrams Greenhouse gas (GHG) emissions in the domain "Cropland" are currently limited to CO2 emissions from cropland organic soils. They are those associated with carbon losses from drained histosols under cropland. 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/vol5.html) applied to geospatial data. GHG emissions are provided by country, region and special groups, with global coverage, relative to the period 1990-2016 (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:22:52 2023-06-15 05:05:42 GC - 6727 - 72330 - gigagrams     Emissions - Land Use: Cropland 5017 Emissions - Land Use: Cropland 17748   
{}
 0           1                                  
135379 Cropland - Cropland organic soils - 6727 - Net emissions/removal (CO2eq) (Cropland) - 72170 - gigagrams gigagrams Greenhouse gas (GHG) emissions in the domain "Cropland" are currently limited to CO2 emissions from cropland organic soils. They are those associated with carbon losses from drained histosols under cropland. 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/vol5.html) applied to geospatial data. GHG emissions are provided by country, region and special groups, with global coverage, relative to the period 1990-2016 (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:22:51 2023-06-15 05:05:42 GC - 6727 - 72170 - gigagrams     Emissions - Land Use: Cropland 5017 Emissions - Land Use: Cropland 17748   
{}
 0           1                                  
135378 Cropland - Cropland organic soils - 6727 - Implied emission factor for C (Cropland) - 72410 - tonnes C/ha tonnes C/ha Greenhouse gas (GHG) emissions in the domain "Cropland" are currently limited to CO2 emissions from cropland organic soils. They are those associated with carbon losses from drained histosols under cropland. 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/vol5.html) applied to geospatial data. GHG emissions are provided by country, region and special groups, with global coverage, relative to the period 1990-2016 (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:22:51 2023-06-15 05:05:42 GC - 6727 - 72410 - tonnes C/ha     Emissions - Land Use: Cropland 5017 Emissions - Land Use: Cropland 17748   
{}
 0           1                                  
135377 Cropland - Cropland organic soils - 6727 - Area - 5026 - ha ha Greenhouse gas (GHG) emissions in the domain "Cropland" are currently limited to CO2 emissions from cropland organic soils. They are those associated with carbon losses from drained histosols under cropland. 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/vol5.html) applied to geospatial data. GHG emissions are provided by country, region and special groups, with global coverage, relative to the period 1990-2016 (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:22:50 2023-06-15 05:05:42 GC - 6727 - 5026 - ha     Emissions - Land Use: Cropland 5017 Emissions - Land Use: Cropland 17748   
{}
 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");