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

32 rows where datasetId = 5693 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, timespan, 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
474345 Tree-covered areas | 00006974 || Area from MODIS | 005007 || thousand hectares thousand hectares   2022-08-23 17:41:44 2023-06-15 05:05:42     2001-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Tree-covered areas - Area from MODIS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   tree_covered_areas_00006974_area_from_modis_005007_thousand_hectares     1                                  
474344 Woody crops | 00006972 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:44 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Woody crops - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   woody_crops_00006972_area_from_cci_lc_005008_thousand_hectares     1                                  
474343 Tree-covered areas | 00006974 || Area from CGLS | 005006 || thousand hectares thousand hectares   2022-08-23 17:41:44 2023-06-15 05:05:42     2015-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Tree-covered areas - Area from CGLS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   tree_covered_areas_00006974_area_from_cgls_005006_thousand_hectares     1                                  
474342 Tree-covered areas | 00006974 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:44 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Tree-covered areas - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   tree_covered_areas_00006974_area_from_cci_lc_005008_thousand_hectares     1                                  
474341 Terrestrial barren land | 00006979 || Area from MODIS | 005007 || thousand hectares thousand hectares   2022-08-23 17:41:43 2023-06-15 05:05:42     2001-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Terrestrial barren land - Area from MODIS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   terrestrial_barren_land_00006979_area_from_modis_005007_thousand_hectares     1                                  
474340 Terrestrial barren land | 00006979 || Area from CGLS | 005006 || thousand hectares thousand hectares   2022-08-23 17:41:43 2023-06-15 05:05:42     2015-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Terrestrial barren land - Area from CGLS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   terrestrial_barren_land_00006979_area_from_cgls_005006_thousand_hectares     1                                  
474339 Terrestrial barren land | 00006979 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:43 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Terrestrial barren land - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   terrestrial_barren_land_00006979_area_from_cci_lc_005008_thousand_hectares     1                                  
474338 Sparsely natural vegetated areas | 00006978 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:43 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Sparsely natural vegetated areas - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   sparsely_natural_vegetated_areas_00006978_area_from_cci_lc_005008_thousand_hectares     1                                  
474337 Shrubs and/or herbaceous vegetation, aquatic or regularly flooded | 00006977 || Area from CGLS | 005006 || thousand hectares thousand hectares   2022-08-23 17:41:43 2023-06-15 05:05:42     2015-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Shrubs and/or herbaceous vegetation, aquatic or regularly flooded - Area from CGLS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   shrubs_and_or_herbaceous_vegetation_aquatic_or_regularly_flooded_00006977_area_from_cgls_005006_thousand_hectares     1                                  
474336 Shrubs and/or herbaceous vegetation, aquatic or regularly flooded | 00006977 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:43 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Shrubs and/or herbaceous vegetation, aquatic or regularly flooded - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   shrubs_and_or_herbaceous_vegetation_aquatic_or_regularly_flooded_00006977_area_from_cci_lc_005008_thousand_hectares     1                                  
474335 Shrubs and/or herbaceous vegetation, aquatic or regularly flooded | 00006977 || Area from MODIS | 005007 || thousand hectares thousand hectares   2022-08-23 17:41:43 2023-06-15 05:05:42     2001-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Shrubs and/or herbaceous vegetation, aquatic or regularly flooded - Area from MODIS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   shrubs_and_or_herbaceous_vegetation_aquatic_or_regularly_flooded_00006977_area_from_modis_005007_thousand_hectares     1                                  
474334 Shrub-covered areas | 00006976 || Area from MODIS | 005007 || thousand hectares thousand hectares   2022-08-23 17:41:43 2023-06-15 05:05:42     2001-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Shrub-covered areas - Area from MODIS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   shrub_covered_areas_00006976_area_from_modis_005007_thousand_hectares     1                                  
474333 Shrub-covered areas | 00006976 || Area from CGLS | 005006 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2015-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Shrub-covered areas - Area from CGLS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   shrub_covered_areas_00006976_area_from_cgls_005006_thousand_hectares     1                                  
474332 Mangroves | 00006975 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Mangroves - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   mangroves_00006975_area_from_cci_lc_005008_thousand_hectares     1                                  
474331 Permanent snow and glaciers | 00006980 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Permanent snow and glaciers - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   permanent_snow_and_glaciers_00006980_area_from_cci_lc_005008_thousand_hectares     1                                  
474330 Inland water bodies | 00006981 || Area from MODIS | 005007 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2001-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Inland water bodies - Area from MODIS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   inland_water_bodies_00006981_area_from_modis_005007_thousand_hectares     1                                  
474329 Grassland | 00006983 || Area from MODIS | 005007 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2001-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Grassland - Area from MODIS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   grassland_00006983_area_from_modis_005007_thousand_hectares     1                                  
474328 Permanent snow and glaciers | 00006980 || Area from MODIS | 005007 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2001-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Permanent snow and glaciers - Area from MODIS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   permanent_snow_and_glaciers_00006980_area_from_modis_005007_thousand_hectares     1                                  
474327 Inland water bodies | 00006981 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Inland water bodies - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   inland_water_bodies_00006981_area_from_cci_lc_005008_thousand_hectares     1                                  
474326 Mangroves | 00006975 || Area from MODIS | 005007 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2001-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Mangroves - Area from MODIS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   mangroves_00006975_area_from_modis_005007_thousand_hectares     1                                  
474325 Shrub-covered areas | 00006976 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Shrub-covered areas - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   shrub_covered_areas_00006976_area_from_cci_lc_005008_thousand_hectares     1                                  
474324 Inland water bodies | 00006981 || Area from CGLS | 005006 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2015-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Inland water bodies - Area from CGLS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   inland_water_bodies_00006981_area_from_cgls_005006_thousand_hectares     1                                  
474323 Permanent snow and glaciers | 00006980 || Area from CGLS | 005006 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2015-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Permanent snow and glaciers - Area from CGLS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   permanent_snow_and_glaciers_00006980_area_from_cgls_005006_thousand_hectares     1                                  
474322 Herbaceous crops | 00006971 || Area from CGLS | 005006 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2015-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Herbaceous crops - Area from CGLS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   herbaceous_crops_00006971_area_from_cgls_005006_thousand_hectares     1                                  
474321 Herbaceous crops | 00006971 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Herbaceous crops - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   herbaceous_crops_00006971_area_from_cci_lc_005008_thousand_hectares     1                                  
474320 Grassland | 00006983 || Area from CGLS | 005006 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2015-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Grassland - Area from CGLS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   grassland_00006983_area_from_cgls_005006_thousand_hectares     1                                  
474319 Herbaceous crops | 00006971 || Area from MODIS | 005007 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2001-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Herbaceous crops - Area from MODIS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   herbaceous_crops_00006971_area_from_modis_005007_thousand_hectares     1                                  
474318 Grassland | 00006983 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Grassland - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   grassland_00006983_area_from_cci_lc_005008_thousand_hectares     1                                  
474317 Artificial surfaces (including urban and associated areas) | 00006970 || Area from CCI_LC | 005008 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     1992-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Artificial surfaces (including urban and associated areas) - Area from CCI_LC (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   artificial_surfaces_including_urban_and_associated_areas_00006970_area_from_cci_lc_005008_thousand_hectares     1                                  
474316 Coastal water bodies and intertidal areas | 00006982 || Area from CGLS | 005006 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2015-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Coastal water bodies and intertidal areas - Area from CGLS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   coastal_water_bodies_and_intertidal_areas_00006982_area_from_cgls_005006_thousand_hectares     1                                  
474315 Artificial surfaces (including urban and associated areas) | 00006970 || Area from MODIS | 005007 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2001-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Artificial surfaces (including urban and associated areas) - Area from MODIS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   artificial_surfaces_including_urban_and_associated_areas_00006970_area_from_modis_005007_thousand_hectares     1                                  
474314 Artificial surfaces (including urban and associated areas) | 00006970 || Area from CGLS | 005006 || thousand hectares thousand hectares   2022-08-23 17:41:41 2023-06-15 05:05:42     2015-2019 Agri-Environmental Indicators: Land Cover (FAO, 2022-05-17) 5693 Food and Agriculture Organization of the United Nations 26716 1000 ha 
{
    "name": "Artificial surfaces (including urban and associated areas) - Area from CGLS (thousand hectares)",
    "unit": "thousand hectares",
    "shortUnit": "1000 ha"
}
 0 
{}
   artificial_surfaces_including_urban_and_associated_areas_00006970_area_from_cgls_005006_thousand_hectares     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");