help wbopendatadialog:
Indicator List: Indicators List
version 16.3

Title

wbopendata -- World Bank Open Databases.

Syntax

wbopendata, Parameters [Options]

Parameters

country(acronym) list of country code (accepts multiples)

(and)

topics(acronym) topic code (only accepts one)

(or)

indicator(acronym) list of indicator code(accepts multiples)

Options

long imports the data in the long format.

clear replace data in memory.

latest keep only the latest available value of a single indicator.

nometadata omits the display of the metadata.

year(date1:date2) time interval (in yearly, quarterly or monthly depending on the series).

language(language) select the language.

full adds full list of country attributes.

iso adds 2 digits ISO codes to country attributes.

update query query the current vintage of indicators and country metadata available.

update check checks the availability of new indicators and country metadata available for download.

update all refreshes the indicators and country metadata information.

match(varname) mergue country attributes using WDI countrycodes.

projection World Bank population estimates and projections (HPP) .

metadataoffline download all indicator metadata informaiton and generates 71 sthlp files in your local machine.

wbopendata requires a connection to the internet and supports the Stata dialogue function ().

Sections

Sections are presented under the following headings:

Command description
Parameters description
Options description
List of supported country attributes
Country code and names by selected attributes
Indicators by Source
Topic List
Examples
Disclaimer
Terms of use
How to cite
References
Acknowledgements

(Go up to Sections Menu)

Description

wbopendata allows Stata users to download over 17,000 indicators from the World Bank databases, including: Development
Africa Development Indicators; Doing Business; Education Statistics; Enterprise Surveys; Global Development Finance;
Gender Statistics; Health Nutrition and Population Statistics; International Development Association - Results Measurement System;
Millennium Development Goals; World Development Indicators; Worldwide Governance Indicators; and LAC Equity Lab. These indicators include information
from over 256 countries and regions, since 1960.

Users can chose from one of three of the languages supported by the database (and Stata), namely, English, Spanish, or French.

Five possible downloads options are currently supported:

country over 1,000 indicators for all selected years for a single country (WDI Catalogue).

topics WDI indicators within a specific topic, for all selected years and all countries (WDI Catalogue).

indicator all selected years for all countries for a single indicator (from any of the catalogues: 17,000+ series).

indicator and country all selected years for selected countries for a single indicator (from any of the catalogues: 17,000+ series).

multiple indicator all selected years for selected indicators separated by ; (from any of the catalogues: 17,000+ series).

Users can also choose to have the data displayed in either the wide or long format (wide is the default option).
Note that the reshape is the local machine, so it will require the appropriate amount of RAM to work properly.

wbopendata draws from the main World Bank collections of development indicators, compiled from
officially-recognized international sources. It presents the most current and accurate global development
data available, and includes national, regional and global estimates.

The access to this databases is made possible by the World Bank's Open Data Initiative which provide
open full access to World Bank databases.

(Go up to Sections Menu)

Parameters description

Parameters

country(string) Countries and Regions Abbreviations and acronyms. If solely specified, this option
will return all the WDI indicators (1,076 series) for a single country or region (no multiple country selection allowed in
this case). If this option is selected jointly with a specific indicator, the output is a series for a specific
country or region, or multiple countries or region. When selecting multiple countries please use the three letters code, separated by
a semicolon (;), with no spaces.

topics(numlist) Topic List 21 topic lists are curently supported and include Agriculture & Rural Development;
Aid Effectiveness; Economy & Growth; Education; Energy & Mining; Environment; Financial Sector; Health; Infrastructure; Social Protection & Labor;
Poverty; Private Sector; Public Sector; Science & Technology; Social Development; Urban Development; Gender; Millenium development goals; Climate Change;
External Debt; and, Trade (only one topic collection can be requested at the time).

indicator(string) Indicators List list of indicator codes (All series). When selecting multiple
indicators please use semicolon (;), to separate differenet indicatos.

(Go up to Sections Menu)

Options description

Options

long imports the data in the long format. The default option is to import the data in the wide format. It is important
note that wbopendata uses Stata resources to reshape the variables, hence user has to make sure that Stata will have sufficient
RAM to complete this operation.

clear replace data in memory.

latest keep only the latest available value of a single indicator (it only work if the data in the long format).

nometadata omits the display of the metadata information from the series. Metadata information is only available when downloading specific series (indicator option). The metadata available include information on the name of the series, the source, a detailed description
of the indicator, and the organization responsible for compiling this indicator.

year(date1:date2) allow users to select a specific time interval. Date1=Initial date; Date2=Final date. For most indicators Date should be expressed in yearly format, however for specific series quartely and montly series will be supported. Please check data documentation
at the World Bank Data website to identify which format is supported.

language(option) three languages are supported: The default language is English.

English: en
Spanish: es
French: fr

full adds full list of country attributes.

iso adds only 2 digits ISO codes to country attributes.

update query query the current vintage of indicators available and country metadata.

update check checks the availability of new indicators and country metadata available for download.

update all refreshes the indicators and country metadata information.

match(varname) mergue country attributes using WDI countrycodes.

projection World Bank staff population projection estimates using the World Bank's total population and age/sex distributions of the United Nations Population Division's World Population Prospects: 2019 Revision.

metadataoffline refresh all metadata information, and generate a local copy of all indicators metadata organized by topics and source. This option creates 71 new help files in your local machine with approximately 15mb of documentation.

(Go up to Sections Menu)

List Country attributes currently supported

Country attributes

countrycode Country Code

countryname Country Name

region_iso2 Region Code (ISO 2 digits)

regionname Region Name

adminregion Administrative Region Code

adminregion_iso2 Administrative Region Code (ISO 2 digits)

adminregionname Administrative Region Name

incomelevel Income Level Code

incomelevel_iso2 Income Level Code (ISO 2 digits)

incomelevelname Income Level Name

lendingtype Lending Type Code

region Region Code

lendingtype_iso2 Lending Type Code (ISO 2 digits)

lendingtypename Lending Type Name

capital Capital Name

latitude Capital Latitude

longitude Capital Longitude

(Go up to Sections Menu)

Country Names and Codes by Groups

Regions

NA Aggregates

EAS East Asia and Pacific

ECS Europe and Central Asia

LCN Latin American and the Caribbean

MEA Middle East and North Africa

NAC North America

SAS South Asia

SSF Sub-Saharan Africa

Administrative Regions

EAP East Asia and Pacific

ECA Europe and Central Asia

LAC Latin American and the Caribbean

MNA Middle East and North Africa

SAS South Asia

SSA Sub-Saharan Africa

Income Level Groups

NA Aggregates

HIC High income

UMC Upper middle income

LMC Lower middle income

LIC Low income

Lending Type Group

IBD IBRD

IDX IDA

IDB Blend

LNX Not classified

Source Code (Source TOC)

01 Doing Business

02 World Development Indicators

03 Worldwide Governance Indicators

05 Subnational Malnutrition Database

06 International Debt Statistics

11 Africa Development Indicators

12 Education Statistics

13 Enterprise Surveys

14 Gender Statistics

15 Global Economic Monitor

16 Health Nutrition and Population Statistics

18 IDA Results Measurement System

19 Millennium Development Goals

20 Quarterly Public Sector Debt

22 Quarterly External Debt Statistics SDDS

23 Quarterly External Debt Statistics GDDS

24 Poverty and Equity

25 Jobs

27 Global Economic Prospects

28 Global Financial Inclusion

29 The Atlas of Social Protection: Indicators of Resilience and Equity

30 Exporter Dynamics Database – Indicators at Country-Year Level

32 Global Financial Development

33 G20 Financial Inclusion Indicators

34 Global Partnership for Education

35 Sustainable Energy for All

36 Statistical Capacity Indicators

37 LAC Equity Lab

39 Health Nutrition and Population Statistics by Wealth Quintile

40 Population estimates and projections

41 Country Partnership Strategy for India (FY2013 - 17)

45 Indonesia Database for Policy and Economic Research

46 Sustainable Development Goals

50 Subnational Population

54 Joint External Debt Hub

57 WDI Database Archives

59 Wealth Accounts

60 Economic Fitness

61 PPPs Regulatory Quality

62 International Comparison Program (ICP) 2011

63 Human Capital Index

64 Worldwide Bureaucracy Indicators

65 Health Equity and Financial Protection Indicators

66 Logistics Performance Index

67 PEFA 2011

69 Global Financial Inclusion and Consumer Protection Survey

70 Economic Fitness 2

71 International Comparison Program (ICP) 2005

73 Global Financial Inclusion and Consumer Protection Survey (Internal)

75 Environment, Social and Governance (ESG) Data

(Go up to Sections Menu)

Topic List

Topic Code

1 - Agriculture & Rural Development For the 70 percent of the world's poor who live in rural areas, agriculture is the main source of income and employment. But depletion and degradation of land and water pose serious challenges to producing enough food and other agricultural products to sustain livelihoods here and meet the needs of urban populations. Data presented here include measures of agricultural inputs, outputs, and productivity compiled by the UN's Food and Agriculture Organization.

2 - Aid Effectiveness Aid effectiveness is the impact that aid has in reducing poverty and inequality, increasing growth, building capacity, and accelerating achievement of the Millennium Development Goals set by the international community. Indicators here cover aid received as well as progress in reducing poverty and improving education, health, and other measures of human welfare.

3 - Economy & Growth Economic growth is central to economic development. When national income grows, real people benefit. While there is no known formula for stimulating economic growth, data can help policy-makers better understand their countries' economic situations and guide any work toward improvement. Data here covers measures of economic growth, such as gross domestic product (GDP) and gross national income (GNI). It also includes indicators representing factors known to be relevant to economic growth, such as capital stock, employment, investment, savings, consumption, government spending, imports, and exports.

4 - Education Education is one of the most powerful instruments for reducing poverty and inequality and lays a foundation for sustained economic growth. The World Bank compiles data on education inputs, participation, efficiency, and outcomes. Data on education are compiled by the United Nations Educational, Scientific, and Cultural Organization (UNESCO) Institute for Statistics from official responses to surveys and from reports provided by education authorities in each country.

5 - Energy & Mining The world economy needs ever-increasing amounts of energy to sustain economic growth, raise living standards, and reduce poverty. But today's trends in energy use are not sustainable. As the world's population grows and economies become more industrialized, nonrenewable energy sources will become scarcer and more costly. Data here on energy production, use, dependency, and efficiency are compiled by the World Bank from the International Energy Agency and the Carbon Dioxide Information Analysis Center.

6 - Environment Natural and man-made environmental resources (fresh water, clean air, forests, grasslands, marine resources, and agro-ecosystems) provide sustenance and a foundation for social and economic development. The need to safeguard these resources crosses all borders. Today, the World Bank is one of the key promoters and financiers of environmental upgrading in the developing world. Data here cover forests, biodiversity, emissions, and pollution. Other indicators relevant to the environment are found under data pages for Agriculture & Rural Development, Energy & Mining, Infrastructure, and Urban Development.

7 - Financial Sector An economy's financial markets are critical to its overall development. Banking systems and stock markets enhance growth, the main factor in poverty reduction. Strong financial systems provide reliable and accessible information that lowers transaction costs, which in turn bolsters resource allocation and economic growth. Indicators here include the size and liquidity of stock markets; the accessibility, stability, and efficiency of financial systems; and international migration and workers\ remittances, which affect growth and social welfare in both sending and receiving countries.

8 - Health Improving health is central to the Millennium Development Goals, and the public sector is the main provider of health care in developing countries. To reduce inequities, many countries have emphasized primary health care, including immunization, sanitation, access to safe drinking water, and safe motherhood initiatives. Data here cover health systems, disease prevention, reproductive health, nutrition, and population dynamics. Data are from the United Nations Population Division, World Health Organization, United Nations Children's Fund, the Joint United Nations Programme on HIV/AIDS, and various other sources.

9 - Infrastructure Infrastructure helps determine the success of manufacturing and agricultural activities. Investments in water, sanitation, energy, housing, and transport also improve lives and help reduce poverty. And new information and communication technologies promote growth, improve delivery of health and other services, expand the reach of education, and support social and cultural advances. Data here are compiled from such sources as the International Road Federation, Containerisation International, the International Civil Aviation Organization, the International Energy Association, and the International Telecommunications Union.

10 - Social Protection & Labor The supply of labor available in an economy includes people who are employed, those who are unemployed but seeking work, and first-time job-seekers. Not everyone who works is included: unpaid workers, family workers, and students are often omitted, while some countries do not count members of the armed forces. Data on labor and employment are compiled by the International Labour Organization (ILO) from labor force surveys, censuses, establishment censuses and surveys, and administrative records such as employment exchange registers and unemployment insurance schemes.

11 - Poverty For countries with an active poverty monitoring program, the World Bank in collaboration with national institutions, other development agencies, and civil society regularly conducts analytical work to assess the extent and causes of poverty and inequality, examine the impact of growth and public policy, and review household survey data and measurement methods. Data here includes poverty and inequality measures generated from analytical reports, from national poverty monitoring programs, and from the World Bank's Development Research Group which has been producing internationally comparable and global poverty estimates and lines since 1990.

12 - Private Sector Private markets drive economic growth, tapping initiative and investment to create productive jobs and raise incomes. Trade is also a driver of economic growth as it integrates developing countries into the world economy and generates benefits for their people. Data on the private sector and trade are from the World Bank Group's Private Participation in Infrastructure Project Database, Enterprise Surveys, and Doing Business Indicators, as well as from the International Monetary Fund's Balance of Payments database and International Financial Statistics, the UN Commission on Trade and Development, the World Trade Organization, and various other sources.

13 - Public Sector Effective governments improve people's standard of living by ensuring access to essential services (health, education, water and sanitation, electricity, transport and the opportunity to live and work in peace and security). Data here includes World Bank staff assessments of country performance in economic management, structural policies, policies for social inclusion and equity, and public sector management and institutions for the poorest countries. Also included are indicators on revenues and expenses from the International Monetary Fund's Government Finance Statistics, and on tax policies from various sources.

14 - Science & Technology Technological innovation, often fueled by governments, drives industrial growth and helps raise living standards. Data here aims to shed light on countries technology base: research and development, scientific and technical journal articles, high-technology exports, royalty and license fees, and patents and trademarks. Sources include the UNESCO Institute for Statistics, the U.S. National Science Board, the UN Statistics Division, the International Monetary Fund, and the World Intellectual Property Organization.

15 - Social Development Data here cover child labor, gender issues, refugees, and asylum seekers. Children in many countries work long hours, often combining studying with work for pay. The data on their paid work are from household surveys conducted by the International Labour Organization (ILO), the United Nations Children's Fund (UNICEF), the World Bank, and national statistical offices. Gender disparities are measured using a compilation of data on key topics such as education, health, labor force participation, and political participation. Data on refugees are from the United Nations High Commissioner for Refugees complemented by statistics on Palestinian refugees under the mandate of the United Nations Relief and Works Agency.

16 - Urban Development Cities can be tremendously efficient. It is easier to provide water and sanitation to people living closer together, while access to health, education, and other social and cultural services is also much more readily available. However, as cities grow, the cost of meeting basic needs increases, as does the strain on the environment and natural resources. Data on urbanization, traffic and congestion, and air pollution are from the United Nations Population Division, World Health Organization, International Road Federation, World Resources Institute, and other sources.

17 - Gender Women's empowerment and the promotion of gender equality are key to achieving sustainable development. Greater gender equality can enhance economic efficiency and improve other development outcomes by removing barriers that prevent women from having the same access as men to human resource endowments, rights, and economic opportunities. Giving women access to equal opportunities allows them to emerge as social and economic actors, influencing and shaping more inclusive policies. Improving women's status also leads to more investment in their children's education, health, and overall wellbeing. Data here covers demography, education, health, labor force and employment, and political participation.

18 - Millenium development goals

19 - Climate Change Climate change is expected to hit developing countries the hardest. Its effects higher temperatures, changes in precipitation patterns, rising sea levels, and more frequent weather-related disasters pose risks for agriculture, food, and water supplies. At stake are recent gains in the fight against poverty, hunger and disease, and the lives and livelihoods of billions of people in developing countries. Addressing climate change requires unprecedented global cooperation across borders. The World Bank Group is helping support developing countries and contributing to a global solution, while tailoring our approach to the differing needs of developing country partners. Data here cover climate systems, exposure to climate impacts, resilience, greenhouse gas emissions, and energy use. Other indicators relevant to climate change are found under other data pages, particularly Environment, Agriculture & Rural Development, Energy & Mining, Health, Infrastructure, Poverty, and Urban Development.

20 - External Debt Debt statistics provide a detailed picture of debt stocks and flows of developing countries. Data presented as part of the Quarterly External Debt Statistics takes a closer look at the external debt of high-income countries and emerging markets to enable a more complete understanding of global financial flows. The Quarterly Public Sector Debt database provides further data on public sector valuation methods, debt instruments, and clearly defined tiers of debt for central, state and local government, as well as extra-budgetary agencies and funds. Data are gathered from national statistical organizations and central banks as well as by various major multilateral institutions and World Bank staff.

21 - Trade Trade is a key means to fight poverty and achieve the Millennium Development Goals, specifically by improving developing country access to markets, and supporting a rules based, predictable trading system. In cooperation with other international development partners, the World Bank launched the Transparency in Trade Initiative to provide free and easy access to data on country-specific trade policies.

Examples

(Go up to Sections Menu)

. wbopendata, update query

. wbopendata, update check

. wbopendata, update all

. wbopendata, metadataoffline

. wbopendata, country(chn - China) clear

. wbopendata, language(en - English) topics(2 - Aid Effectiveness) clear

. wbopendata, language(en - English) indicator(ag.agr.trac.no - Agricultural machinery, tractors) clear

. wbopendata, language(en - English) indicator(ag.agr.trac.no - Agricultural machinery, tractors) long clear

. wbopendata, country(ago;bdi;chi;dnk;esp) indicator(sp.pop.0610.fe.un) clear

. wbopendata, indicator(SP.POP.1014.FE; SP.POP.1014.MA) year(1990:2050) projection clear

. wbopendata, indicator(si.pov.dday; ny.gdp.pcap.pp.kd) clear long

. tempfile tmp
. wbopendata, language(en - English) indicator(it.cel.sets.p2) long clear latest
. sort countrycode
. save `tmp', replace
. sysuse world-d, clear
. merge countrycode using `tmp'
. sum year
. local avg = string(`r(mean)',"%16.1f")
. spmap it_cel_sets_p2 using "world-c.dta", id(_ID) ///
clnumber(20) fcolor(Reds2) ocolor(none ..) ///
title("Mobile cellular subscriptions (per 100 people)", size(*1.2)) ///
legstyle(3) legend(ring(1) position(3)) ///
note("Source: World Development Indicators (latest available year: `avg') using ///
Azevedo, J.P. (2011) wbopendata: Stata module to " "access World Bank databases, ///
Statistical Software Components S457234 Boston College Department of Economics.", ///
size(*.7))
(click to run)

. wbopendata, indicator(si.pov.dday ) clear long
. drop if si_pov_dday == .
. sort countryname year
. bysort countryname : gen diff_pov = (si_pov_dday-si_pov_dday[_n-1])/(year-year[_n-1])
. encode region, gen(reg)
. encode countryname, gen(reg2)
. alorenz diff_pov, gp points(100) fullview xdecrease markvar(reg2) ///
ytitle("Change in Poverty (p.p.)") xtitle("Proportion of regional ///
episodes of poverty reduction (%)") legend(off) title("Poverty Reduction") ///
mlabelangle(45)	legend(off)	///
note("Source: World Development Indicators using Azevedo, J.P. (2011) ///
wbopendata: Stata module to " "access World Bank databases, Statistical ///
Software Components S457234 Boston College Department of Economics.", ///
size(*.7))
(click to run)

. wbopendata, indicator(si.pov.dday ) clear long
. drop if si_pov_dday == .
. sort countryname year
. keep if regionname == "Aggregates"
. bysort countryname : gen diff_pov = (si_pov_dday-si_pov_dday[_n-1])/(year-year[_n-1])
. gen baseline = si_pov_dday if year == 1990
. sort countryname baseline
. bysort countryname : replace baseline = baseline[1] if baseline == .
. gen mdg1 = baseline/2
. gen present = si_pov_dday if year == 2008
. sort countryname present
. bysort countryname : replace present = present[1] if present == .
. gen target = ((baseline-mdg1)/(2008-1990))*(2015-1990)
. sort countryname year
. gen angel45x = .
. gen angle45y = .
. replace angel45x = 0 in 1
. replace angle45y = 0 in 1
. replace angel45x = 80 in 2
. replace angle45y = 80 in 2
. graph twoway ///
(scatter present target if year == 2008, mlabel( countrycode)) ///
(line angle45y angel45x ), ///
legend(off) xtitle("Target for 2008") ytitle(Present) ///
title("MDG 1 - 1.9 USD") ///
note("Source: World Development Indicators (latest available year: 2008) ///
using Azevedo, J.P. (2011) wbopendata: Stata module to " "access ///
World Bank databases, Statistical Software Components S457234 Boston ///
College Department of Economics.", size(*.7))
(click to run)

. wbopendata, indicator(si.pov.dday; ny.gdp.pcap.pp.kd) clear long latest

. graph twoway ///
(scatter si_pov_dday ny_gdp_pcap_pp_kd, msize(*.6)) ///
(scatter si_pov_dday ny_gdp_pcap_pp_kd if region == "Aggregates", msize(*.8) ///
mlabel(countryname) mlabsize(*.8) mlabangle(25)) ///
(lowess si_pov_dday ny_gdp_pcap_pp_kd) , ///
xtitle("GDP per capita, PPP (constant 2011 international $)") ///
ytitle("Poverty headcount ratio at the International Poverty Line") ///
mlabelangle(45)	legend(off) ///
note("Source: World Development Indicators (latest available year as off 2012-08-08) ///
using Azevedo, J.P. (2011) wbopendata: Stata module to " "access World Bank databases, ///
Statistical Software Components S457234 Boston College Department of Economics.", ///
size(*.7))

(click to run)

Disclaimer

(Go up to Sections Menu)

Users should not use wbopendata without checking first for more detailed information on the
definitions of each indicator
and data-catalogues . The indicators names and codes used
by wbopendata are precisely the same used in the World Bank data catalogue in order to facilitate such
cross reference.

When downloading specific series, through the indicator options, wbopendata will by default display in the Stata results window the metadata available for this
particular series, including information on the name of the series, the source, a detailed description of the indicator, and the organization
responsible for compiling this indicator.

Terms of use World Bank Data

(Go up to Sections Menu)

The use of World Bank datasets listed in the Data Catalog is governed by a specific
Terms of Use for World Bank Data.
The terms of use of the APIs is governed by the World Bank Terms and Conditions.

Thanks for citing wbopendata as follows

(Go up to Sections Menu)

Azevedo, J.P. (2011) "wbopendata: Stata module to access World Bank databases," Statistical Software Components S457234, Boston College Department of
Economics.http://ideas.repec.org/c/boc/bocode/s457234.html

Please make reference to the date when the database was downloaded, as indicator values and availabiltiy may change.

References

(Go up to Sections Menu)

David C. Elliott, 2002. "TKNZ: Stata module to tokenize string into named macros," Statistical Software Components
S426302, Boston College Department of Economics, revised 17 Oct 2006.

Acknowledgements

(Go up to Sections Menu)

This program was developed by Joao Pedro Azevedo.

A special thanks to the World Bank API team, in particular, Malarvizhi Veerappan, Lakshmikanthan Subramanian, Shanmugam Natarajan, Ugendran Machakkalai, Rochelle Glenene O'Hagan, Timothy Grant Herzog,
and Ana Florina Pirlea.

The author would like to thanks comments received from Minh Cong Nguyen, John Luke Gallup, Aart C. Kraay, Amer Hasan, Johan Mistiaen, Roy Shuji Katayama, Dean Mitchell Jolliffe, Nobuo Yoshida,
Manohar Sharma, Gabriel Demombynes, Paolo Verme, Elizaveta Perova, Kit Baum, Kerry Kammire, Derek Wagner, Neil Fantom and Loiuse J. Cord. The usual disclaimer applies.

I would like to dedicate this ado file to Dr Richard Sperling, who asked us to support intelligent and well
thought out public policies that help those in society who are less fortunate than we are. www.stata.com/statalist/archive/2011-02/msg00062.html

wbopendata uses the Stata user written command _pecats produced by J. Scott Long and Jeremy Freese, and tknz written by David C. Elliott and
Nick Cox.

Author

Joao Pedro Azevedo (jazevedo@worldbank.org)

GitHub Respository

For previous releases and additional examples please visit wbopendata GitHub Repo

Please make any enhancement suggestions and/or report any problems with wbopendata at Issues and Suggestions page

Also see

Online: linewrap alorenz spmap tknz (if installed)