You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
. which wbopendata
.\w\wbopendata.ado
*! v 16.0.1 31Oct2019 by Joao Pedro Azevedo
. which _query
.\_\_query.ado
*! v 16.0 29Oct2019 by Joao Pedro Azevedo
. which wbopendata.sthlp
.\w\wbopendata.sthlp
. wbopendata, language(en - English) indicator(ag.agr.trac.no - Agricultural machinery,
> tractors) clear
Metadata: ag.agr.trac.no
---------------------------------------------------------------------------------------
Name: Agricultural machinery, tractors
-------------------------------------------------------------------------------------
Source: World Development Indicators
--------------------------------------------------------------------------------------
Source Note: Agricultural machinery refers to the number of wheel and crawler
tractors (excluding garden tractors) in use in agriculture at the end of the
calendar year specified or during the first quarter of the following year.
--------------------------------------------------------------------------------------
Source Organization: Food and Agriculture Organization, electronic files and web
site.
--------------------------------------------------------------------------------------
Topics: Agriculture & Rural Development
--------------------------------------------------------------------------------------
. tab countryname in 1/10
Country Name | Freq. Percent Cum.
----------------------------------------+-----------------------------------
Afghanistan | 1 10.00 10.00
Albania | 1 10.00 20.00
American Samoa | 1 10.00 30.00
Andorra | 1 10.00 40.00
Angola | 1 10.00 50.00
Arab World | 1 10.00 60.00
Argentina | 1 10.00 70.00
Armenia | 1 10.00 80.00
Aruba | 1 10.00 90.00
United Arab Emirates | 1 10.00 100.00
----------------------------------------+-----------------------------------
Total | 10 100.00
Download specific indicator and report in long format [ag.agr.trac.no]
. wbopendata, language(en - English) indicator(ag.agr.trac.no - Agricultural machinery,
> tractors) long clear
Metadata: ag.agr.trac.no
---------------------------------------------------------------------------------------
Name: Agricultural machinery, tractors
-------------------------------------------------------------------------------------
Source: World Development Indicators
--------------------------------------------------------------------------------------
Source Note: Agricultural machinery refers to the number of wheel and crawler
tractors (excluding garden tractors) in use in agriculture at the end of the
calendar year specified or during the first quarter of the following year.
--------------------------------------------------------------------------------------
Source Organization: Food and Agriculture Organization, electronic files and web
site.
--------------------------------------------------------------------------------------
Topics: Agriculture & Rural Development
--------------------------------------------------------------------------------------
. tab year in 1/10
Year | Freq. Percent Cum.
------------+-----------------------------------
1960 | 1 10.00 10.00
1961 | 1 10.00 20.00
1962 | 1 10.00 30.00
1963 | 1 10.00 40.00
1964 | 1 10.00 50.00
1965 | 1 10.00 60.00
1966 | 1 10.00 70.00
1967 | 1 10.00 80.00
1968 | 1 10.00 90.00
1969 | 1 10.00 100.00
------------+-----------------------------------
Total | 10 100.00
. qui tempfile tmp
. wbopendata, language(en - English) indicator(it.cel.sets.p2) long clear latest
Metadata: it.cel.sets.p2
---------------------------------------------------------------------------------------
Name: Mobile cellular subscriptions (per 100 people)
-------------------------------------------------------------------------------------
Source: World Development Indicators
--------------------------------------------------------------------------------------
Source Note: Mobile cellular telephone subscriptions are subscriptions to a
public mobile telephone service that provide access to the PSTN using cellular
technology. The indicator includes (and is split into) the number of postpaid
subscriptions, and the number of active prepaid accounts (i.e. that have been
used during the last three months"}). The indicator applies to all mobile
cellular subscriptions that offer voice communications. It excludes subscriptions
via data cards or USB modems, subscriptions to public mobile data services,
private trunked mobile radio, telepoint, radio paging and telemetry services.
--------------------------------------------------------------------------------------
Source Organization: International Telecommunication Union, World
Telecommunication/ICT Development Report and database.
--------------------------------------------------------------------------------------
Topics: Infrastructure
--------------------------------------------------------------------------------------
. local labelvar "`r(varlabel1)'"
. sort countrycode
. save `tmp', replace
(note: file C:\Users\wb255520\AppData\Local\Temp\ST_9474_000003.tmp not found)
file C:\Users\wb255520\AppData\Local\Temp\ST_9474_000003.tmp saved
. qui sysuse world-d, clear
. qui merge countrycode using `tmp'
. qui 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("`labelvar'", size(*1.2)) ///
> legstyle(3) legend(ring(1) position(3))
> ///
> note("Source: World Development Indicators (latest available year: `a
> vg') using Azevedo, J.P. (2011) wbopendata: Stata module to " "access World Bank dat
> abases, Statistical Software Components S457234 Boston College Department of Economic
> s.")
Bencharmk latest poverty levels by percapital income, highlighting single
country
. wbopendata, indicator(si.pov.dday; ny.gdp.pcap.pp.kd) clear long latest
Metadata: si.pov.dday
---------------------------------------------------------------------------------------
Name: Poverty headcount ratio at $1.90 a day (2011 PPP) (% of population)
-------------------------------------------------------------------------------------
Source: World Development Indicators
--------------------------------------------------------------------------------------
Source Note: Poverty headcount ratio at $1.90 a day is the percentage of the
population living on less than $1.90 a day at 2011 international prices. As a
result of revisions in PPP exchange rates, poverty rates for individual countries
cannot be compared with poverty rates reported in earlier editions.
--------------------------------------------------------------------------------------
Source Organization: World Bank, Development Research Group. Data are based on
primary household survey data obtained from government statistical agencies and
World Bank country departments. Data for high-income economies are from the
Luxembourg Income Study database. For more information and methodology, please
see PovcalNet (http://iresearch.worldbank.org/PovcalNet/index.htm"}"}).
--------------------------------------------------------------------------------------
Topics: Poverty
--------------------------------------------------------------------------------------
Topics: Aid Effectiveness
--------------------------------------------------------------------------------------
Topics: Climate Change
--------------------------------------------------------------------------------------
Metadata: ny.gdp.pcap.pp.kd
---------------------------------------------------------------------------------------
Name: GDP per capita, PPP (constant 2011 international $)
-------------------------------------------------------------------------------------
Source: World Development Indicators
--------------------------------------------------------------------------------------
Source Note: GDP per capita based on purchasing power parity (PPP"}). PPP GDP is
gross domestic product converted to international dollars using purchasing power
parity rates. An international dollar has the same purchasing power over GDP as
the U.S. dollar has in the United States. 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 constant 2011
international dollars.
--------------------------------------------------------------------------------------
Source Organization: World Bank, International Comparison Program database.
--------------------------------------------------------------------------------------
Topics: Economy & Growth
--------------------------------------------------------------------------------------
. linewrap , longstring("`r(varlabel1)'") maxlength(52) name(ylabel)
. linewrap , longstring("`r(varlabel2)'") maxlength(52) name(xlabel)
. twoway ///
> (scatter si_pov_dday ny_gdp_pcap_pp_kd, msize(*.2)) ///
> (scatter si_pov_dday ny_gdp_pcap_pp_kd if string(si_pov_dday) == "35.8", ///
> msize(*.8) mlabel(countryname)) ///
> (lowess si_pov_dday ny_gdp_pcap_pp_kd) ///
> if region != "NA" ///
> , legend(off) ///
> xtitle("`r(xlabel1)'" "`r(xlabel2)'" "`r(xlabel3)'") ///
> ytitle("`r(ylabel1)'" "`r(ylabel2)'" "`r(ylabel3)'") ///
> note("Source: `r(source1)' using WBOPENDATA")
. wbopendata, indicator(si.pov.dday ) clear long
Metadata: si.pov.dday
---------------------------------------------------------------------------------------
Name: Poverty headcount ratio at $1.90 a day (2011 PPP) (% of population)
-------------------------------------------------------------------------------------
Source: World Development Indicators
--------------------------------------------------------------------------------------
Source Note: Poverty headcount ratio at $1.90 a day is the percentage of the
population living on less than $1.90 a day at 2011 international prices. As a
result of revisions in PPP exchange rates, poverty rates for individual countries
cannot be compared with poverty rates reported in earlier editions.
--------------------------------------------------------------------------------------
Source Organization: World Bank, Development Research Group. Data are based on
primary household survey data obtained from government statistical agencies and
World Bank country departments. Data for high-income economies are from the
Luxembourg Income Study database. For more information and methodology, please
see PovcalNet (http://iresearch.worldbank.org/PovcalNet/index.htm"}"}).
--------------------------------------------------------------------------------------
Topics: Poverty
--------------------------------------------------------------------------------------
Topics: Aid Effectiveness
--------------------------------------------------------------------------------------
Topics: Climate Change
--------------------------------------------------------------------------------------
. drop if si_pov_dday == .
(14,165 observations deleted)
. sort countryname year
. bysort countryname : gen diff_pov = (si_pov_dday-si_pov_dday[_n-1])/(year-year[_n
> -1])
(178 missing values generated)
. encode region, gen(reg)
. encode countryname, gen(reg2)
. keep if regionname == "Aggregates"
(1,475 observations deleted)
. alorenz diff_pov, gp points(20) xdecrease markvar(reg2) ///
> ytitle("Change in Poverty (p.p.)") xtitle("Proportion of regional episodes of
> poverty reduction (%)") ///
> legend(off) title("Poverty Reduction")
> ///
> legend(off) note("Source: World Development Indicators using Azevedo, J.P. (20
> 11) wbopendata: Stata module to " "access World Bank databases, Statistical Software
> Components S457234 Boston College Department of Economics.", size(*.7))
. wbopendata, indicator(si.pov.dday ) clear long
Metadata: si.pov.dday
---------------------------------------------------------------------------------------
Name: Poverty headcount ratio at $1.90 a day (2011 PPP) (% of population)
-------------------------------------------------------------------------------------
Source: World Development Indicators
--------------------------------------------------------------------------------------
Source Note: Poverty headcount ratio at $1.90 a day is the percentage of the
population living on less than $1.90 a day at 2011 international prices. As a
result of revisions in PPP exchange rates, poverty rates for individual countries
cannot be compared with poverty rates reported in earlier editions.
--------------------------------------------------------------------------------------
Source Organization: World Bank, Development Research Group. Data are based on
primary household survey data obtained from government statistical agencies and
World Bank country departments. Data for high-income economies are from the
Luxembourg Income Study database. For more information and methodology, please
see PovcalNet (http://iresearch.worldbank.org/PovcalNet/index.htm"}"}).
--------------------------------------------------------------------------------------
Topics: Poverty
--------------------------------------------------------------------------------------
Topics: Aid Effectiveness
--------------------------------------------------------------------------------------
Topics: Climate Change
--------------------------------------------------------------------------------------
. drop if si_pov_dday == .
(14,165 observations deleted)
. sort countryname year
. keep if regionname == "Aggregates"
(1,475 observations deleted)
. bysort countryname : gen diff_pov = (si_pov_dday-si_pov_dday[_n-1])/(year-year[_n
> -1])
(14 missing values generated)
. gen baseline = si_pov_dday if year == 1990
(187 missing values generated)
. sort countryname baseline
. bysort countryname : replace baseline = baseline[1] if baseline == .
(176 real changes made)
. gen mdg1 = baseline/2
(11 missing values generated)
. gen present = si_pov_dday if year == 2008
(186 missing values generated)
. sort countryname present
. bysort countryname : replace present = present[1] if present == .
(186 real changes made)
. gen target = ((baseline-mdg1)/(2008-1990))*(2015-1990)
(11 missing values generated)
. sort countryname year
. gen angel45x = .
(200 missing values generated)
. gen angle45y = .
(200 missing values generated)
. replace angel45x = 0 in 1
(1 real change made)
. replace angle45y = 0 in 1
(1 real change made)
. replace angel45x = 80 in 2
(1 real change made)
. replace angle45y = 80 in 2
(1 real change made)
. 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) u
> sing Azevedo, J.P. (2011) wbopendata: Stata module to " "access World Bank databases,
> Statistical Software Components S457234 Boston College Department of Economics.", si
> ze(*.7))
Bencharmk latest poverty levels by percapital income, highlighting regional
averages
. wbopendata, indicator(si.pov.dday; ny.gdp.pcap.pp.kd) clear long latest
Metadata: si.pov.dday
---------------------------------------------------------------------------------------
Name: Poverty headcount ratio at $1.90 a day (2011 PPP) (% of population)
-------------------------------------------------------------------------------------
Source: World Development Indicators
--------------------------------------------------------------------------------------
Source Note: Poverty headcount ratio at $1.90 a day is the percentage of the
population living on less than $1.90 a day at 2011 international prices. As a
result of revisions in PPP exchange rates, poverty rates for individual countries
cannot be compared with poverty rates reported in earlier editions.
--------------------------------------------------------------------------------------
Source Organization: World Bank, Development Research Group. Data are based on
primary household survey data obtained from government statistical agencies and
World Bank country departments. Data for high-income economies are from the
Luxembourg Income Study database. For more information and methodology, please
see PovcalNet (http://iresearch.worldbank.org/PovcalNet/index.htm"}"}).
--------------------------------------------------------------------------------------
Topics: Poverty
--------------------------------------------------------------------------------------
Topics: Aid Effectiveness
--------------------------------------------------------------------------------------
Topics: Climate Change
--------------------------------------------------------------------------------------
Metadata: ny.gdp.pcap.pp.kd
---------------------------------------------------------------------------------------
Name: GDP per capita, PPP (constant 2011 international $)
-------------------------------------------------------------------------------------
Source: World Development Indicators
--------------------------------------------------------------------------------------
Source Note: GDP per capita based on purchasing power parity (PPP"}). PPP GDP is
gross domestic product converted to international dollars using purchasing power
parity rates. An international dollar has the same purchasing power over GDP as
the U.S. dollar has in the United States. 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 constant 2011
international dollars.
--------------------------------------------------------------------------------------
Source Organization: World Bank, International Comparison Program database.
--------------------------------------------------------------------------------------
Topics: Economy & Growth
--------------------------------------------------------------------------------------
.
. local time "$S_FNDATE"
.
. linewrap , longstring("`r(varlabel1)'") maxlength(52) name(ylabel)
. linewrap , longstring("`r(varlabel2)'") maxlength(52) name(xlabel)
.
. graph twoway ///
> (scatter si_pov_dday ny_gdp_pcap_pp_kd, msize(*.3)) ///
> (scatter si_pov_dday ny_gdp_pcap_pp_kd if regionname == "Aggregates", msize(*
> .8) mlabel(countryname) mlabsize(*.8) mlabangle(25)) ///
> (lowess si_pov_dday ny_gdp_pcap_pp_kd) , ///
> legend(off) ///
> xtitle("`r(xlabel1)'" "`r(xlabel2)'" "`r(xlabel3)'") ///
> ytitle("`r(ylabel1)'" "`r(ylabel2)'" "`r(ylabel3)'") ///
>
> note("Source: World Development Indicators (latest available year as
> off `time') using Azevedo, J.P. (2011) wbopendata: Stata" "module to access World Ban
> k databases, Statistical Software Components S457234 Boston College Department of Eco
> nomics.", size(*.7))
. wbopendata, update query
---------------------------------------------------------------------------------------
Indicators update status
Existing Number of Indicators: 17299
Last check for updates: 3 Nov 2019 17:11:02
New update available: none (as of 3 Nov 2019 17:11:02)
Current update level: 29 Oct 2019 09:52:40
Country metadata: 304
Last country check: 3 Nov 2019 17:11:02
Current country update level: 29 Oct 2019 09:54:45
Possible actions
Check for available updates (or type -wbopendata, update check detail -)
See current documentation on indicators list, Regions,
Administrative Regions, Income Levels, and Lending Types
---------------------------------------------------------------------------------------
. wbopendata, update check
---------------------------------------------------------------------------------------
Indicators update status
Existing Number of Indicators: 17299
Last check for updates: 3 Nov 2019 17:11:02
New update available: none (as of 3 Nov 2019 17:33:25}
Current update level: 29 Oct 2019 09:52:40
Country metadata: 304
New update available: none (as of 3 Nov 2019 17:33:25}
Last country check: 3 Nov 2019 17:11:02
Current country update level: 29 Oct 2019 09:54:45
Possible actions
Do nothing; all files are up to date.
See current documentation on indicators list, Regions,
Administrative Regions, Income Levels, and Lending Types
---------------------------------------------------------------------------------------
. wbopendata, update all
---------------------------------------------------------------------------------------
Indicators update status
Existing Number of Indicators: 17299
Last check for updates: 3 Nov 2019 17:33:25
New update available: none (as of 3 Nov 2019 17:33:26}
Current update level: 29 Oct 2019 09:52:40
Country metadata: 304
New update available: none (as of 3 Nov 2019 17:33:26}
Last country check: 3 Nov 2019 17:33:25
Current country update level: 29 Oct 2019 09:54:45
Possible actions
Do nothing; all files are up to date.
See current documentation on indicators list, Regions,
Administrative Regions, Income Levels, and Lending Types
---------------------------------------------------------------------------------------
. qui tempfile tmp
.
. wbopendata, language(en - English) indicator(SE.LPV.PRIM) long clear latest
Metadata: SE.LPV.PRIM
---------------------------------------------------------------------------------------
Name: Learning poverty: Share of Children at the End-of-Primary age below minimum
reading proficiency adjusted by Out-of-School Children (%)
-------------------------------------------------------------------------------------
Source: Education Statistics
--------------------------------------------------------------------------------------
Source Note: This indicator brings together schooling and learning. It starts
with the share of children who haven't achieved minimum reading proficiency and
adjusts it by the proportion of children who are out of school. The data used to
calculate Learning Poverty has been made possible thanks to the work of the
Global Alliance to Monitor Learning led by the UNESCO Institute for Statistics
(UIS), which established Minimum Proficiency Levels (MPLs) that enable countries
to benchmark learning across different cross-national and national assessments.
For more information please see [CITE WORKING PAPER].
--------------------------------------------------------------------------------------
Source Organization: Word Bank and UIS
--------------------------------------------------------------------------------------
.
. sort countrycode
. save `tmp', replace
(note: file C:\Users\wb255520\AppData\Local\Temp\ST_9474_000004.tmp not found)
file C:\Users\wb255520\AppData\Local\Temp\ST_9474_000004.tmp saved
.
. local labelvar "`r(varlabel1)'"
. linewrap , longstring("`labelvar'") maxlength(72) name(xlabel)
. local xlabel1 "`r(xlabel1)'"
. local xlabel2 "`r(xlabel2)'"
. local xlabel3 "`r(xlabel3)'"
.
. local sourcek "Source: World Development Indicators using Azevedo, J.P. (2011) wb
> opendata: Stata module to access World Bank databases, Statistical Software Component
> s S457234 Boston College Department of Economics."
. linewrap , longstring("`sourcek'") maxlength(180) name(sourcek)
. local source1 "`r(sourcek1)'"
. local source2 "`r(sourcek2)'"
. local source3 "`r(sourcek3)'"
.
.
. qui sysuse world-d, clear
. qui merge countrycode using `tmp'
. spmap se_lpv_prim using "world-c.dta", id(_ID) ///
> clnumber(9) fcolor(Reds2) ocolor(none ..)
> ///
> title("`xlabel1'" "`xlabel2'" "`xlabel3'", size(*1)) ///
> legstyle(3) legend(ring(1) position(3))
> ///
> note("`source1'" "`source2'" "`source3'", size(*.9))
. wbopendata, indicator(SP.POP.TOTL) long clear projection
Metadata: SP.POP.TOTL
---------------------------------------------------------------------------------------
Name: Population, total
-------------------------------------------------------------------------------------
Source: World Development Indicators
--------------------------------------------------------------------------------------
Source Note: 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.
--------------------------------------------------------------------------------------
Source Organization: (1) United Nations Population Division. World Population
Prospects: 2019 Revision. (2) Census reports and other statistical publications
from national statistical offices, (3) Eurostat: Demographic Statistics, (4)
United Nations Statistical Division. Population and Vital Statistics Reprot
(various years), (5) U.S. Census Bureau: International Database, and (6)
Secretariat of the Pacific Community: Statistics and Demography Programme.
--------------------------------------------------------------------------------------
Topics: Climate Change
--------------------------------------------------------------------------------------
Topics: Health
--------------------------------------------------------------------------------------
.
. local ylabel = "`r(varlabel1)'"
. local yvar "`r(indicator)'"
.
. replace sp_pop_totl = sp_pop_totl/1000000000
(23,210 real changes made)
.
. format %16.2gc sp_pop_totl
.
. graph twoway (line sp_pop_totl year if countryname == "World" & year <= 2019, xline(2
> 019, lpattern(dot))) ///
> (line sp_pop_totl year if countryname == "World" & year > 20
> 19, lpattern(dash)) ///
> , legend(off) ytitle("`ylabel' [`yvar']" "(Es
> timates and Projections in Billions)") ///
> note("Source: World Development Indicators, W
> orld Bank")
