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

10 rows where sourceId = 18079 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, shortUnit, display, 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
158696 Urban population living in areas where elevation is below 5 meters (% of total population)   Urban population below 5m is the percentage of the total population, living in areas where the elevation is 5 meters or less. Statistical concept and methodology: Population counts in low elevation zones in the year 1990 as described by GRUMPv1 input estimates allocated into 3 arc second grid cells. Population counts in low elevation zones in the year 2000 as described by GRUMPv1 input estimates allocated into 3 arc second grid cells. Population counts in low elevation zones in the year 2010 derived from the application of United Nations 2000-2010 national growth rates to year 2000 population data from GRUMPv1 ( see documentation for full description of methodologies ). 2021-08-10 01:59:15 2023-06-15 05:05:42 EN.POP.EL5M.UR.ZS   1990-2010 World Development Indicators - World Bank (2021.07.30) 5357 Center for International Earth Science Information Network (via World Bank) 18079   
{}
 0 
{}
         1                                  
158692 Urban land area where elevation is below 5 meters (sq. km)   Urban land area below 5m is the total urban land area in square kilometers where the elevation is 5 meters or less. Statistical concept and methodology: Elevation data used to generate the low elevation coastal zones come from the SRTM3 Enhanced Global Map developed by ISCIENCES. The ISCIENCES digital elevation model was created using NASA’s Jet Propulsion Laboratory Shuttle Radar Topography Mission data processed to 3 arc-seconds (SRTM3). 2021-08-10 01:59:15 2023-06-15 05:05:42 AG.LND.EL5M.UR.K2   1990-2010 World Development Indicators - World Bank (2021.07.30) 5357 Center for International Earth Science Information Network (via World Bank) 18079   
{}
 0 
{}
         1                                  
158691 Urban land area where elevation is below 5 meters (% of total land area)   Urban land area below 5m is the percentage of total land where the urban land elevation is 5 meters or less. Statistical concept and methodology: Elevation data used to generate the low elevation coastal zones come from the SRTM3 Enhanced Global Map developed by ISCIENCES. The ISCIENCES digital elevation model was created using NASA’s Jet Propulsion Laboratory Shuttle Radar Topography Mission data processed to 3 arc-seconds (SRTM3). 2021-08-10 01:59:15 2023-06-15 05:05:42 AG.LND.EL5M.UR.ZS   1990-2010 World Development Indicators - World Bank (2021.07.30) 5357 Center for International Earth Science Information Network (via World Bank) 18079   
{}
 0 
{}
         1                                  
158474 Rural population living in areas where elevation is below 5 meters (% of total population)   Rural population below 5m is the percentage of the total population, living in areas where the elevation is 5 meters or less. Statistical concept and methodology: Population counts in low elevation zones in the year 1990 as described by GRUMPv1 input estimates allocated into 3 arc second grid cells. Population counts in low elevation zones in the year 2000 as described by GRUMPv1 input estimates allocated into 3 arc second grid cells. Population counts in low elevation zones in the year 2010 derived from the application of United Nations 2000-2010 national growth rates to year 2000 population data from GRUMPv1 ( see documentation for full description of methodologies ). 2021-08-10 01:59:13 2023-06-15 05:05:42 EN.POP.EL5M.RU.ZS   1990-2010 World Development Indicators - World Bank (2021.07.30) 5357 Center for International Earth Science Information Network (via World Bank) 18079   
{}
 0 
{}
         1                                  
158470 Rural land area where elevation is below 5 meters (sq. km)   Rural land area below 5m is the total rural land area in square kilometers where the elevation is 5 meters or less. Limitations and exceptions: The 2007 Intergovernmental Panel on Climate Change's (IPCC) assessment report concluded that global warming is “unequivocal” and gave the strongest warning yet about the role of human activities. The report estimated that sea levels would rise approximately 49 centimeters over the next 100 years, with a range of uncertainty of 20–86 centimeters. That will lead to increased coastal flooding through direct inundation and a higher base for storm surges, allowing flooding of larger areas and higher elevations. Climate model simulations predict an increase in average surface air temperature of about 2.5°C by 2100 (Kattenberg and others 1996) and increase of “killer” heat waves during the warm season (Karl and others 1997). Statistical concept and methodology: Elevation data used to generate the low elevation coastal zones come from the SRTM3 Enhanced Global Map developed by ISCIENCES. The ISCIENCES digital elevation model was created using NASA’s Jet Propulsion Laboratory Shuttle Radar Topography Mission data processed to 3 arc-seconds (SRTM3). 2021-08-10 01:59:13 2023-06-15 05:05:42 AG.LND.EL5M.RU.K2   1990-2010 World Development Indicators - World Bank (2021.07.30) 5357 Center for International Earth Science Information Network (via World Bank) 18079   
{}
 0 
{}
         1                                  
158468 Rural land area (sq. km)   Rural land area in square kilometers, derived from urban extent grids which distinguish urban and rural areas based on a combination of population counts (persons), settlement points, and the presence of Nighttime Lights. Areas are defined as urban where contiguous lighted cells from the Nighttime Lights or approximated urban extents based on buffered settlement points for which the total population is greater than 5,000 persons. Limitations and exceptions: The 2007 Intergovernmental Panel on Climate Change's (IPCC) assessment report concluded that global warming is “unequivocal” and gave the strongest warning yet about the role of human activities. The report estimated that sea levels would rise approximately 49 centimeters over the next 100 years, with a range of uncertainty of 20–86 centimeters. That will lead to increased coastal flooding through direct inundation and a higher base for storm surges, allowing flooding of larger areas and higher elevations. Climate model simulations predict an increase in average surface air temperature of about 2.5°C by 2100 (Kattenberg and others 1996) and increase of “killer” heat waves during the warm season (Karl and others 1997). Statistical concept and methodology: The Global Rural-Urban Mapping Project, Version 1 (GRUMPv1) urban extent grid distinguishes urban and rural areas based on a combination of population counts (persons), settlement points, and the presence of Nighttime Lights . Areas are defined as urban where contiguous lighted cells from the Nighttime Lights or approximated urban extents based on buffered settlement points for which the total population is greater than 5,000 persons. This dataset is produced by the Columbia University Center for International Earth Science Information Network (CIESIN) in collaboration with the International Food Policy Research Institute (IFPRI), The World Bank, and Centro Internacional de Agricultura Tropical (CIAT) 2021-08-10 01:59:13 2023-06-15 05:05:42 AG.LND.TOTL.RU.K2   1990-2010 World Development Indicators - World Bank (2021.07.30) 5357 Center for International Earth Science Information Network (via World Bank) 18079   
{}
 0 
{}
         1                                  
158343 Population living in areas where elevation is below 5 meters (% of total population)   Population below 5m is the percentage of the total population living in areas where the elevation is 5 meters or less. Limitations and exceptions: The 2007 Intergovernmental Panel on Climate Change's (IPCC) assessment report concluded that global warming is “unequivocal” and gave the strongest warning yet about the role of human activities. The report estimated that sea levels would rise approximately 49 centimeters over the next 100 years, with a range of uncertainty of 20–86 centimeters. That will lead to increased coastal flooding through direct inundation and a higher base for storm surges, allowing flooding of larger areas and higher elevations. Climate model simulations predict an increase in average surface air temperature of about 2.5°C by 2100 (Kattenberg and others 1996) and increase of “killer” heat waves during the warm season (Karl and others 1997). Statistical concept and methodology: Population counts in low elevation zones in the year 1990 as described by GRUMPv1 input estimates allocated into 3 arc second grid cells. Population counts in low elevation zones in the year 2000 as described by GRUMPv1 input estimates allocated into 3 arc second grid cells. Population counts in low elevation zones in the year 2010 derived from the application of United Nations 2000-2010 national growth rates to year 2000 population data from GRUMPv1 (see documentation for full description of methodologies). 2021-08-10 01:59:12 2023-06-15 05:05:42 EN.POP.EL5M.ZS   1990-2010 World Development Indicators - World Bank (2021.07.30) 5357 Center for International Earth Science Information Network (via World Bank) 18079   
{}
 0 
{}
         1                                  
157969 Land area where elevation is below 5 meters (% of total land area)   Land area below 5m is the percentage of total land where the elevation is 5 meters or less. Limitations and exceptions: The 2007 Intergovernmental Panel on Climate Change's (IPCC) assessment report concluded that global warming is “unequivocal” and gave the strongest warning yet about the role of human activities. The report estimated that sea levels would rise approximately 49 centimeters over the next 100 years, with a range of uncertainty of 20–86 centimeters. That will lead to increased coastal flooding through direct inundation and a higher base for storm surges, allowing flooding of larger areas and higher elevations. Climate model simulations predict an increase in average surface air temperature of about 2.5°C by 2100 (Kattenberg and others 1996) and increase of “killer” heat waves during the warm season (Karl and others 1997). Statistical concept and methodology: Elevation data used to generate the low elevation coastal zones come from the SRTM3 Enhanced Global Map developed by ISCIENCES. The ISCIENCES digital elevation model was created using NASA’s Jet Propulsion Laboratory Shuttle Radar Topography Mission data processed to 3 arc-seconds (SRTM3). 2021-08-10 01:59:08 2023-06-15 05:05:42 AG.LND.EL5M.ZS   1990-2010 World Development Indicators - World Bank (2021.07.30) 5357 Center for International Earth Science Information Network (via World Bank) 18079   
{}
 0 
{}
         1                                  
147879 Urban land area (sq. km) sq. km Urban land area in square kilometers, based on a combination of population counts (persons), settlement points, and the presence of Nighttime Lights. Areas are defined as urban where contiguous lighted cells from the Nighttime Lights or approximated urban extents based on buffered settlement points for which the total population is greater than 5,000 persons. Statistical concept and methodology: The Global Rural-Urban Mapping Project, Version 1 (GRUMPv1) urban extent grid distinguishes urban and rural areas based on a combination of population counts (persons), settlement points, and the presence of Nighttime Lights . Areas are defined as urban where contiguous lighted cells from the Nighttime Lights or approximated urban extents based on buffered settlement points for which the total population is greater than 5,000 persons. This dataset is produced by the Columbia University Center for International Earth Science Information Network (CIESIN) in collaboration with the International Food Policy Research Institute (IFPRI), The World Bank, and Centro Internacional de Agricultura Tropical (CIAT) 2021-08-09 06:23:33 2023-06-15 05:05:42 AG.LND.TOTL.UR.K2   1990-2010 World Development Indicators - World Bank (2021.07.30) 5357 Center for International Earth Science Information Network (via World Bank) 18079 sq. km 
{
    "unit": "Rate"
}
 0 
{}
         1                                  
147872 Rural land area where elevation is below 5 meters (% of total land area) % of total land area Rural land area below 5m is the percentage of total land where the rural land elevation is 5 meters or less. Limitations and exceptions: The 2007 Intergovernmental Panel on Climate Change's (IPCC) assessment report concluded that global warming is “unequivocal” and gave the strongest warning yet about the role of human activities. The report estimated that sea levels would rise approximately 49 centimeters over the next 100 years, with a range of uncertainty of 20–86 centimeters. That will lead to increased coastal flooding through direct inundation and a higher base for storm surges, allowing flooding of larger areas and higher elevations. Climate model simulations predict an increase in average surface air temperature of about 2.5°C by 2100 (Kattenberg and others 1996) and increase of “killer” heat waves during the warm season (Karl and others 1997). Statistical concept and methodology: Elevation data used to generate the low elevation coastal zones come from the SRTM3 Enhanced Global Map developed by ISCIENCES. The ISCIENCES digital elevation model was created using NASA’s Jet Propulsion Laboratory Shuttle Radar Topography Mission data processed to 3 arc-seconds (SRTM3). 2021-08-09 06:23:33 2023-06-15 05:05:42 AG.LND.EL5M.RU.ZS   1990-2010 World Development Indicators - World Bank (2021.07.30) 5357 Center for International Earth Science Information Network (via World Bank) 18079 % 
{
    "unit": "Rate"
}
 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");