variables
Data license: CC-BY
12 rows where datasetId = 1026 sorted by id descending
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
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");