All countries (historical)

10 days ago
bookmarkSave

This dataset is about countries yearly. It has 62 columns such as date, country, ISO 3 country code, ISO 2 country code, and country full name. The data is ordered by date.

arrow_down Preview (max 100 rows)
column Columns dropdown

Download

This dataset has 12,416 rows and is 66% filled with values (non-null)

download Download for free
download Free sample

Filters

Use filters to adjust the scope of this dataset
plus Add filter

Stats

Legend

There are 62 fields used in this dataset (including filters):
  • Date: Year period during which the metrics are collected. This field is expressed in year.
  • Country: Name of country.
  • Iso 3 Country Code: Three-letter country codes defined in ISO 3166-1.
  • Iso 2 Country Code: Two-letter country codes defined in ISO 3166-1.
  • Country Full Name: The full name of each country.
  • Currency: Official currency used in the country.
  • Capital City: Capital city of the country.
  • Region: Region the country is situated within.
  • Continent: Continent the country is situated within.
  • Demonym: Term used to describe a country's residents or natives.
  • Latitude: Coordinate that specifies the north–south position. This field is expressed in °.
  • Longitude: Coordinate that specifies the east–west position. This field is expressed in °.
  • Agricultural Land: Agricultural land refers to the share of land area that is arable, under permanent crops, and under permanent pastures. Arable land includes land defined by the FAO as land under temporary crops (double-cropped areas are counted once), temporary meadows for mowing or for pasture, land under market or kitchen gardens, and land temporarily fallow. Land abandoned as a result of shifting cultivation is excluded. Land under permanent crops is land cultivated with crops that occupy the land for long periods and need not be replanted after each harvest, such as cocoa, coffee, and rubber. This category includes land under flowering shrubs, fruit trees, nut trees, and vines, but excludes land under trees grown for wood or timber. Permanent pasture is land used for five or more years for forage, including natural and cultivated crops. This field is expressed in km².
  • Forest Area: Forest area is land under natural or planted stands of trees of at least 5 meters in situ, whether productive or not, and excludes tree stands in agricultural production systems (for example, in fruit plantations and agroforestry systems) and trees in urban parks and gardens. This field is expressed in km².
  • Land Area: Land area is a country's total area, excluding area under inland water bodies, national claims to continental shelf, and exclusive economic zones. In most cases the definition of inland water bodies includes major rivers and lakes. This field is expressed in km².
  • Rural Land Area: 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. This field is expressed in km².
  • Urban Land Area: 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. This field is expressed in km².
  • Central Government Debt: Debt is the entire stock of direct government fixed-term contractual obligations to others outstanding on a particular date. It includes domestic and foreign liabilities such as currency and money deposits, securities other than shares, and loans. It is the gross amount of government liabilities reduced by the amount of equity and financial derivatives held by the government. Because debt is a stock rather than a flow, it is measured as of a given date, usually the last day of the fiscal year. This field is expressed in % of GDP.
  • Expense: Expense is cash payments for operating activities of the government in providing goods and services. It includes compensation of employees (such as wages and salaries), interest and subsidies, grants, social benefits, and other expenses such as rent and dividends. This field is expressed in % of GDP.
  • Gdp: GDP at purchaser's prices is the sum of gross value added by all resident producers in the economy plus any product taxes and minus any subsidies not included in the value of the products. It is calculated without making deductions for depreciation of fabricated assets or for depletion and degradation of natural resources. Data are in current U.S. dollars. Dollar figures for GDP are converted from domestic currencies using single year official exchange rates. For a few countries where the official exchange rate does not reflect the rate effectively applied to actual foreign exchange transactions, an alternative conversion factor is used. This field is expressed in current US$.
  • Inflation: Inflation as measured by the consumer price index reflects the annual percentage change in the cost to the average consumer of acquiring a basket of goods and services that may be fixed or changed at specified intervals, such as yearly. The Laspeyres formula is generally used. This field is expressed in annual %.
  • Self-Employed Workers: Self-employed workers are those workers who, working on their own account or with one or a few partners or in cooperative, hold the type of jobs defined as a "self-employment jobs." i.e. jobs where the remuneration is directly dependent upon the profits derived from the goods and services produced. Self-employed workers include four sub-categories of employers, own-account workers, members of producers' cooperatives, and contributing family workers. This field is expressed in % of total employment.
  • Tax Revenue: Tax revenue refers to compulsory transfers to the central government for public purposes. Certain compulsory transfers such as fines, penalties, and most social security contributions are excluded. Refunds and corrections of erroneously collected tax revenue are treated as negative revenue. This field is expressed in % of GDP.
  • Unemployment: Unemployment refers to the share of the labor force that is without work but available for and seeking employment (ILO estimates). This field is expressed in % of total labor force.
  • Vulnerable Employment: Vulnerable employment is contributing family workers and own-account workers as a percentage of total employment (ILO estimates). This field is expressed in % of total employment.
  • Access To Electricity: Access to electricity is the percentage of population with access to electricity. Electrification data are collected from industry, national surveys and international sources. This field is expressed in % of population.
  • Alternative And Nuclear Energy: Clean energy is noncarbohydrate energy that does not produce carbon dioxide when generated. It includes hydropower and nuclear, geothermal, and solar power, among others. This field is expressed in % of total energy use.
  • Electricity Production From Coal Sources: Sources of electricity refer to the inputs used to generate electricity. Coal refers to all coal and brown coal, both primary (including hard coal and lignite-brown coal) and derived fuels (including patent fuel, coke oven coke, gas coke, coke oven gas, and blast furnace gas). This field is expressed in % of total.
  • Electricity Production From Hydroelectric Sources: Sources of electricity refer to the inputs used to generate electricity. Hydropower refers to electricity produced by hydroelectric power plants. This field is expressed in % of total.
  • Electricity Production From Natural Gas Sources: Sources of electricity refer to the inputs used to generate electricity. Gas refers to natural gas but excludes natural gas liquids. This field is expressed in % of total.
  • Electricity Production From Nuclear Sources: Sources of electricity refer to the inputs used to generate electricity. Nuclear power refers to electricity produced by nuclear power plants. This field is expressed in % of total.
  • Electricity Production From Oil Sources: Sources of electricity refer to the inputs used to generate electricity. Oil refers to crude oil and petroleum products. This field is expressed in % of total.
  • Electricity Production From Renewable Sources, Excluding Hydroelectric: Electricity production from renewable sources, excluding hydroelectric, includes geothermal, solar, tides, wind, biomass, and biofuels. This field is expressed in % of total.
  • Net Energy Imports: Net energy imports are estimated as energy use less production, both measured in oil equivalents. A negative value indicates that the country is a net exporter. Energy use refers to use of primary energy before transformation to other end-use fuels, which is equal to indigenous production plus imports and stock changes, minus exports and fuels supplied to ships and aircraft engaged in international transport. This field is expressed in % of energy use.
  • Fossil Fuel Energy Consumption: Fossil fuel comprises coal, oil, petroleum, and natural gas products. This field is expressed in % of total.
  • Renewable Energy Consumption: Renewable energy consumption is the share of renewables energy in total final energy consumption. This field is expressed in % of total final energy consumption.
  • Carbon Dioxide Emissions (Co2): A measure of annual emissions of carbon dioxide (CO2), one of the six Kyoto greenhouse gases (GHG), from the agriculture, energy, waste, and industrial sectors, excluding LULUCF.. The measure is standardized to carbon dioxide equivalent values using the Global Warming Potential (GWP) factors of IPCC's 5th Assessment Report (AR5). Carbon dioxide emissions are those stemming from the burning of fossil fuels and the manufacture of cement. They include carbon dioxide produced during consumption of solid, liquid, and gas fuels and gas flaring. This field is expressed in Mt of CO2 equivalent.
  • Methane Emissions: A measure of annual emissions of methane (CH4), one of the six Kyoto greenhouse gases (GHG), from the agriculture, energy, waste, and industrial sectors, excluding LULUCF.. The measure is standardized to carbon dioxide equivalent values using the Global Warming Potential (GWP) factors of IPCC's 5th Assessment Report (AR5). Methane emissions are those stemming from human activities such as agriculture and from industrial methane production. This field is expressed in Mt of CO2 equivalent.
  • Nitrous Oxide Emissions: A measure of annual emissions of nitrous oxide (N2O), one of the six Kyoto greenhouse gases (GHG), from the agriculture, energy, waste, and industrial sectors, excluding LULUCF.. The measure is standardized to carbon dioxide equivalent values using the Global Warming Potential (GWP) factors of IPCC's 5th Assessment Report (AR5). Nitrous oxide emissions are emissions from agricultural biomass burning, industrial activities, and livestock management. This field is expressed in Mt of CO2 equivalent.
  • Greenhouse Gas Emissions (Co2, Ch4, N2o, Hfcs, Pfcs, Sf6): A measure of annual emissions of the six greenhouse gases (GHG) covered by the Kyoto Protocol (carbon dioxide (CO2), methane (CH4), nitrous oxide (N2O), hydrofluorocarbons (HFCs), perfluorocarbons (PFCs), and sulphurhexafluoride (SF6)) from the energy, industry, waste, and agriculture sectors, standardized to carbon dioxide equivalent values. This measure excludes GHG fluxes caused by Land Use Change Land Use and Forestry (LULUCF), as these fluxes have larger uncertainties. The measure is standardized to carbon dioxide equivalent values using the Global Warming Potential (GWP) factors of IPCC's 5th Assessment Report (AR5). This field is expressed in Mt of CO2 equivalent.
  • Urban Population Living In Areas Where Elevation Is Below 5 Meters : Urban population below 5m is the percentage of the total population, living in areas where the elevation is 5 meters or less. This field is expressed in % of total population.
  • Health Expenditure: Level of current health expenditure expressed as a percentage of GDP. Estimates of current health expenditures include healthcare goods and services consumed during each year. This indicator does not include capital health expenditures such as buildings, machinery, IT and stocks of vaccines for emergency or outbreaks. This field is expressed in % of GDP.
  • Health Expenditure Per Capita: Current expenditures on health per capita in current US dollars. Estimates of current health expenditures include healthcare goods and services consumed during each year. This field is expressed in current US$.
  • Hospital Beds: Hospital beds include inpatient beds available in public, private, general, and specialized hospitals and rehabilitation centers. In most cases beds for both acute and chronic care are included. This field is expressed in per 1,000 people.
  • Incidence Of Hiv: Number of new HIV infections among uninfected populations expressed per 1,000 uninfected population in the year before the period. This field is expressed in per 1,000 uninfected population.
  • Suicide Mortality Rate: Suicide mortality rate is the number of suicide deaths in a year per 100,000 population. Crude suicide rate (not age-adjusted). This field is expressed in per 100,000 population.
  • Armed Forces Personnel: Armed forces personnel are active duty military personnel, including paramilitary forces if the training, organization, equipment, and control suggest they may be used to support or replace regular military forces. This field is expressed in people.
  • Internally Displaced Persons, By Conflict And Violence: Internally displaced persons are defined according to the 1998 Guiding Principles (http://www.internal-displacement.org/publications/1998/ocha-guiding-principles-on-internal-displacement) as people or groups of people who have been forced or obliged to flee or to leave their homes or places of habitual residence, in particular as a result of armed conflict, or to avoid the effects of armed conflict, situations of generalized violence, violations of human rights, or natural or human-made disasters and who have not crossed an international border. “People displaced” refers to the number of people living in displacement as of the end of each year, and reflects the stock of people displaced at the end of the previous year, plus inflows of new cases arriving over the year as well as births over the year to those displaced, minus outflows which may include returnees, those who settled elsewhere, those who integrated locally, those who travelled over borders, and deaths. This field is expressed in people.
  • Military Expenditure: Military expenditures data from SIPRI are derived from the NATO definition, which includes all current and capital expenditures on the armed forces, including peacekeeping forces; defense ministries and other government agencies engaged in defense projects; paramilitary forces, if these are judged to be trained and equipped for military operations; and military space activities. Such expenditures include military and civil personnel, including retirement pensions of military personnel and social services for personnel; operation and maintenance; procurement; military research and development; and military aid (in the military expenditures of the donor country). Excluded are civil defense and current expenditures for previous military activities, such as for veterans' benefits, demobilization, conversion, and destruction of weapons. This field is expressed in % of GDP.
  • Birth Rate: Crude birth rate indicates the number of live births per 1,000 midyear population. This field is expressed in per 1,000 people.
  • Death Rate: Crude death rate indicates the number of deaths occurring during the year, per 1,000 population estimated at midyear. Subtracting the crude death rate from the crude birth rate provides the rate of natural increase, which is equal to the rate of population change in the absence of migration. This field is expressed in per 1,000 people.
  • Fertility Rate: Total fertility rate represents the number of children that would be born to a woman if she were to live to the end of her childbearing years and bear children in accordance with age-specific fertility rates of the specified year. This field is expressed in births per woman.
  • Individuals Using The Internet: Internet users are individuals who have used the Internet (from any location) in the last 3 months. The Internet can be used via a computer, mobile phone, personal digital assistant, games machine, digital TV etc. This field is expressed in % of population.
  • Life Expectancy At Birth: Life expectancy at birth indicates the number of years a newborn infant would live if prevailing patterns of mortality at the time of its birth were to stay the same throughout its life. This field is expressed in year.
  • Net Migration: Net migration is the number of immigrants minus the number of emigrants, including citizens and noncitizens, for the five-year period. This field is expressed in people.
  • Female Population: Female population is based on the de facto definition of population, which counts all female residents regardless of legal status or citizenship. This field is expressed in people.
  • Male Population: Male population is based on the de facto definition of population, which counts all male residents regardless of legal status or citizenship. This field is expressed in people.
  • Population: Total population is based on the de facto definition of population, which counts all residents regardless of legal status or citizenship. The values shown are midyear estimates. This field is expressed in people.
  • Proportion Of Seats Held By Women In National Parliaments: Women in parliaments are the percentage of parliamentary seats in a single or lower chamber held by women. This field is expressed in %.
  • Rural Population: Rural population refers to people living in rural areas as defined by national statistical offices. It is calculated as the difference between total population and urban population. Aggregation of urban and rural population may not add up to total population because of different country coverages. This field is expressed in people.
  • Urban Population: Urban population refers to people living in urban areas as defined by national statistical offices. It is calculated using World Bank population estimates and urban ratios from the United Nations World Urbanization Prospects. Aggregation of urban and rural population may not add up to total population because of different country coverages. This field is expressed in people.
  • Median Age: Median age of the population, representing the age at which half the population is older and half is younger. This field is expressed in year.

Details

This dataset is based on data from: World Bank

This dataset can be used under the CC BY 4.0 license

Attribution

Please use the following:

close