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

12 rows where sourceId = 6886 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, coverage, 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
43168 Land (crop, pasture) $ The sum of cropland and pastureland. The value of these two forms of land is calculated as the present value of returns to the land. The World Bank uses sources such as the FAOSTAT database. 2017-11-11 13:06:18 2023-06-15 05:05:42   Global by country 1995-2014 Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 0           1                                  
43080 GDP     2017-11-08 22:44:01 2023-06-15 05:05:42       Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 0           1                                  
43077 Net foreign assets $ Net foreign assets (NFA) are a measure of the cross-border assets and liabilities held by a country’s residents. A country’s external asset position, or net foreign assets (NFA), is calculated as: NFA = FA - FL 2017-11-08 22:44:01 2023-06-15 05:05:42   Global by country 1995-2014 Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 0           1                                  
43074 Human capital $ Total human capital is calculated as the discounted value of lifetime earnings. This method takes into account estimates of years of schooling and experience. 2017-11-08 22:44:01 2023-06-15 05:05:42   Global by country 1995-2014 Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 0           1                                  
43073 Metals and minerals $ Bauxite, copper, gold, iron ore, lead, nickel, phosphate rock, silver, tin, and zinc. The value of these resources is measured as the present value of the stream of expected rents that may be extracted from the resource until it is exhausted. The WB calculates these values using various sources, i.e. US Geological Survey (USGS), Minerals Yearbook, etc. 2017-11-08 22:44:01 2023-06-15 05:05:42   Global by country 1995-2014 Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 0           1                                  
43069 Fossil energy resources (oil, natural gas, coal) $ Petroleum, natural gas, coal (all grades). The value of these resources is measured as the present value of the stream of expected rents that may be extracted from the resource until it is exhausted. The WB calculates these values using various sources, i.e. Rystad Energy, UCUBE (Upstream Database), IEA "World Energy Statistics, etc. 2017-11-08 22:44:01 2023-06-15 05:05:42   Global by country 1995-2014 Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 0           1                                  
43065 Protected areas $ Areas protected for conservation and preservation of ecosystems provide a range of services to the country. For instance, wildlife reserves can generate significant revenues for developing countries in particular from international tourism activities. And about one-third of the world’s big cities get their drinking water from sources in or downstream of protected areas, saving billions of dollars in supply and treatment costs thanks to forests and wetlands that regulate the flow of water and remove contaminants (Dudley et al 2010). Valuing such ecosystem services on a global basis, however, is difficult. For this reason, protected areas are valued in the World Bank wealth accounts using a simplified approach. Under this approach, the quasi-opportunity cost of protection per unit area of land contained in terrestrial protected areas is estimated as the lower of returns to cropland and pastureland. This is likely to be a lower bound on the true value of protected areas. Returns are capitalized over an infinite time horizon. The World Bank bases calculations on a number of its own databases and indicators. 2017-11-08 22:44:01 2023-06-15 05:05:42   Global 1995-2014 Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 0           1                                  
43064 Forest, non-timber $ The annual value of non-timber forest ecosystem services is estimated by multiplying total forest area in a given year by the sum of the per-hectare monetary values for the three benefit categories (non-wood forest products; recreation, hunting, and fishing; and watershed protection). The capitalized value of non-wood services is equal to the present value of annual services, discounted into the future. The World Bank calculates estimates based on sources such as FAO's Global Forest Resources Assessment 2017-11-08 22:44:01 2023-06-15 05:05:42   Global 1995-2014 Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 0           1                                  
43063 Forest, timber $ The predominant economic use of forests has been as a source of timber. Timber resources are valued according to the present discounted value of rents from the production of roundwood over the expected lifetime of standing timber resources. The World Bank calculates this value using various sources, i.e. UN FAOSTAT database 2017-11-08 22:44:01 2023-06-15 05:05:42   Global 1995-2014 Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 0           1                                  
43062 Natural capital, renewable (excluding sub-soil assets) $ Sum of forests - timber, forests - non-timber, protected areas, cropland, pastureland. (See those sources for further detail on each.) 2017-11-08 22:44:01 2023-06-15 05:05:42   Global 1995-2014 Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 0           1                                  
43061 Produced capital $ Physical capital estimates include the value of structures, machinery, and equipment, since the value of the stocks is derived (using the perpetual inventory method) from gross capital formation data that account for these elements. Urban land is also accounted for, however, in the investment figures only land improvements are captured. Thus, the final capital estimates do not entirely reflect the value of urban land. 2017-11-08 22:44:01 2023-06-15 05:05:42   Global by country 1995-2014 Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 0           1                                  
43060 Total wealth per capita $ Total wealth is calculated by summing up each component of wealth (“bottom-up approach”): Natural capital + Produced capital + Human capital + Net foreign assets. (See each of the individual variables for further detail) 2017-11-08 22:44:01 2023-06-15 05:05:42   Global 1995-2014 Wealth per capita by component by country - World Bank (2017) 1026 World Bank (2017) 6886   
{}
 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");