World Development Indicators, World Bank: Difference between revisions
Jump to navigation
Jump to search
Yutang.Xiong (talk | contribs) m (Yutang.Xiong moved page World Bank to World Development Indicators, World Bank without leaving a redirect: new name) |
Norah.Shamin (talk | contribs) No edit summary |
||
| Line 6: | Line 6: | ||
The data team uses World Bank Open Data and WDI for a number of series about education, agriculture, aid, gender issues, environment, finances, economics, and development. Most importantly, WB databases are used for GDP and GDPPC. Example series from the World Bank include but are not limited to, SeriesAgFoodProductIndex, SeriesAidRec%GNI, SeriesCompanyValue%GDP, SeriesExportImport%GDP. | The data team uses World Bank Open Data and WDI for a number of series about education, agriculture, aid, gender issues, environment, finances, economics, and development. Most importantly, WB databases are used for GDP and GDPPC. Example series from the World Bank include but are not limited to, SeriesAgFoodProductIndex, SeriesAidRec%GNI, SeriesCompanyValue%GDP, SeriesExportImport%GDP. | ||
= | = Tables in IFs = | ||
{| class="wikitable" | {| class="wikitable" | ||
|Variable | |Variable | ||
|Definition | |Definition | ||
|Units | |Units | ||
|UsedInPreprocessor | |UsedInPreprocessor | ||
|UsedInPreprocessorFileName | |UsedInPreprocessorFileName | ||
| Line 81: | Line 20: | ||
|Arms imports (SIPRI trend indicator values) | |Arms imports (SIPRI trend indicator values) | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 91: | Line 29: | ||
|External debt, private non-guaranteed, as percentage of gross domestic product | |External debt, private non-guaranteed, as percentage of gross domestic product | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 101: | Line 38: | ||
|External debt, public and publicly guaranteed, as percentage of gross domestic product | |External debt, public and publicly guaranteed, as percentage of gross domestic product | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 111: | Line 47: | ||
|Net flows from IDA as % of GDP | |Net flows from IDA as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 121: | Line 56: | ||
|Net nonconcessional flows from IMF as % of GDP | |Net nonconcessional flows from IMF as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 131: | Line 65: | ||
|IMF credits as % of GDP | |IMF credits as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 141: | Line 74: | ||
|Income payments as % of GDP | |Income payments as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 151: | Line 83: | ||
|Portfolio investment in bonds (PPG and PNG) as % of GDP | |Portfolio investment in bonds (PPG and PNG) as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 161: | Line 92: | ||
|Portfolio investment in equity as % of GDP | |Portfolio investment in equity as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 171: | Line 101: | ||
|Gross international reserves as % of GDP | |Gross international reserves as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 181: | Line 110: | ||
|Net concessional flows from IMF as % of GDP | |Net concessional flows from IMF as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 191: | Line 119: | ||
|Income receipts as % of GDP | |Income receipts as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 201: | Line 128: | ||
|Net flows from IBRD as % of GDP | |Net flows from IBRD as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 211: | Line 137: | ||
|IBRD loans and IDA credits as % of GDP | |IBRD loans and IDA credits as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 221: | Line 146: | ||
|Current government revenue as % of GDP | |Current government revenue as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 231: | Line 155: | ||
|Exports of services as % of GDP | |Exports of services as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 241: | Line 164: | ||
|Exports of merchandise as % of GDP | |Exports of merchandise as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 251: | Line 173: | ||
|Imports of Services as % of GDP | |Imports of Services as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 261: | Line 182: | ||
|Imports of merchandiseas % of GDP | |Imports of merchandiseas % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 271: | Line 191: | ||
|Worker remittances by country where paid as % of GDP | |Worker remittances by country where paid as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 281: | Line 200: | ||
|Worker remittances received by country as % of GDP | |Worker remittances received by country as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 291: | Line 209: | ||
|External debt as percentage of gross domestic product | |External debt as percentage of gross domestic product | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 301: | Line 218: | ||
|Net Foreign Assets (current LCU) as a percent of GDP. | |Net Foreign Assets (current LCU) as a percent of GDP. | ||
|Percent | |Percent | ||
|0 | |0 | ||
| | | | ||
| Line 311: | Line 227: | ||
|Labor force size | |Labor force size | ||
|Millions | |Millions | ||
|1 | |1 | ||
|POPULATION | |POPULATION | ||
| Line 321: | Line 236: | ||
|Urban population | |Urban population | ||
|Millions | |Millions | ||
|1 | |1 | ||
|POPULATION | |POPULATION | ||
| Line 331: | Line 245: | ||
|Gross Domestic Product in Current US$ | |Gross Domestic Product in Current US$ | ||
|Billion $ | |Billion $ | ||
|1 | |1 | ||
|ENERGY | |ENERGY | ||
| Line 341: | Line 254: | ||
|External long-term (more than 1 year) debt: public, publically guaranteed and priv nonguaranteed | |External long-term (more than 1 year) debt: public, publically guaranteed and priv nonguaranteed | ||
|Billion $ | |Billion $ | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 351: | Line 263: | ||
|Portion of labor force made up by women | |Portion of labor force made up by women | ||
|Percent | |Percent | ||
|1 | |1 | ||
|POPULATION | |POPULATION | ||
| Line 361: | Line 272: | ||
|Labor in industry as % of total | |Labor in industry as % of total | ||
|Percent | |Percent | ||
|0 | |0 | ||
| | | | ||
| Line 371: | Line 281: | ||
|Labor in services as % of total | |Labor in services as % of total | ||
|Percent | |Percent | ||
|0 | |0 | ||
| | | | ||
| Line 381: | Line 290: | ||
|Value added in industry as percent of GDP | |Value added in industry as percent of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 391: | Line 299: | ||
|Ores and Metals imports as % of merchandise imports | |Ores and Metals imports as % of merchandise imports | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 401: | Line 308: | ||
|Central government debt as % of GDP | |Central government debt as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 411: | Line 317: | ||
|Value added in manufacturing as percent of GDP | |Value added in manufacturing as percent of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 421: | Line 326: | ||
|Foreign population as % of total population | |Foreign population as % of total population | ||
|Percent | |Percent | ||
|0 | |0 | ||
| | | | ||
| Line 431: | Line 335: | ||
|Agricultural labor force as % of total employment, ISIC multiple revisions | |Agricultural labor force as % of total employment, ISIC multiple revisions | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 441: | Line 344: | ||
|Proportion of time spent on unpaid domestic and care work, female (% of 24 hour day). | |Proportion of time spent on unpaid domestic and care work, female (% of 24 hour day). | ||
|Percent | |Percent | ||
|0 | |0 | ||
| | | | ||
| Line 451: | Line 353: | ||
|Proportion of time spent on unpaid domestic and care work, male (% of 24 hour day). | |Proportion of time spent on unpaid domestic and care work, male (% of 24 hour day). | ||
|Percent | |Percent | ||
|1 | |1 | ||
|POPULATION | |POPULATION | ||
| Line 461: | Line 362: | ||
|Percentage of the population living on less than $2.15 a day at 2017 international prices, estimation by World Bank, Poverty and Inequality Platform. | |Percentage of the population living on less than $2.15 a day at 2017 international prices, estimation by World Bank, Poverty and Inequality Platform. | ||
|Percent | |Percent | ||
|0 | |0 | ||
| | | | ||
| Line 471: | Line 371: | ||
|Percentage of the population living on less than $3.65 a day at 2017 international prices, estimation by World Bank, Poverty and Inequality Platform. | |Percentage of the population living on less than $3.65 a day at 2017 international prices, estimation by World Bank, Poverty and Inequality Platform. | ||
|Percent | |Percent | ||
|0 | |0 | ||
| | | | ||
| Line 481: | Line 380: | ||
|Percentage of the population living on less than $6.85 a day at 2017 international prices, estimation by World Bank, Poverty and Inequality Platform. | |Percentage of the population living on less than $6.85 a day at 2017 international prices, estimation by World Bank, Poverty and Inequality Platform. | ||
|Percent | |Percent | ||
|0 | |0 | ||
| | | | ||
| Line 491: | Line 389: | ||
|Poverty gap at $2.15 per day (2017PPP), percent, estimation by World Bank, Poverty and Inequality Platform | |Poverty gap at $2.15 per day (2017PPP), percent, estimation by World Bank, Poverty and Inequality Platform | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 501: | Line 398: | ||
|Poverty gap at $3.65 per day (2017PPP), percent, estimation by World Bank, Poverty and Inequality Platform | |Poverty gap at $3.65 per day (2017PPP), percent, estimation by World Bank, Poverty and Inequality Platform | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 511: | Line 407: | ||
|Poverty gap at $6.85 per day (2017PPP), percent, estimation by World Bank, Poverty and Inequality Platform | |Poverty gap at $6.85 per day (2017PPP), percent, estimation by World Bank, Poverty and Inequality Platform | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 521: | Line 416: | ||
|Exports of goods and services as % of GDP | |Exports of goods and services as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 531: | Line 425: | ||
|Electric power transmission and distribution losses (% of output) | |Electric power transmission and distribution losses (% of output) | ||
|Percent | |Percent | ||
|1 | |1 | ||
|INFRASTRUCTURE | |INFRASTRUCTURE | ||
| Line 541: | Line 434: | ||
|Educational expenditures (public) as percent of GDP | |Educational expenditures (public) as percent of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 551: | Line 443: | ||
|Cost of registring a business as a percent of per capita income | |Cost of registring a business as a percent of per capita income | ||
|Percent | |Percent | ||
|1 | |1 | ||
|SOCIOPOL | |SOCIOPOL | ||
| Line 561: | Line 452: | ||
|Military expenditures (as percent of GDP). Taiwan, China values filled by SIPRI. | |Military expenditures (as percent of GDP). Taiwan, China values filled by SIPRI. | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 571: | Line 461: | ||
|Government (general) final consumption as % of GDP | |Government (general) final consumption as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 581: | Line 470: | ||
|Government expense as % of GDP (compare with govt expenditures) | |Government expense as % of GDP (compare with govt expenditures) | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 591: | Line 479: | ||
|Imports of goods and services as % of GDP | |Imports of goods and services as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 601: | Line 488: | ||
|Electricity consumption per capita | |Electricity consumption per capita | ||
|KWH/Cap | |KWH/Cap | ||
|1 | |1 | ||
|INFRASTRUCTURE | |INFRASTRUCTURE | ||
| Line 611: | Line 497: | ||
|Gross capital formation (Investment), percent of GDP | |Gross capital formation (Investment), percent of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 621: | Line 506: | ||
|Foreign direct investment net inflow as % of GDP | |Foreign direct investment net inflow as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 631: | Line 515: | ||
|Foreign direct investment net outflow as % of GDP | |Foreign direct investment net outflow as % of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 641: | Line 524: | ||
|Income share of poorest 20% of population | |Income share of poorest 20% of population | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 651: | Line 533: | ||
|Labor unemployment, % of labor force | |Labor unemployment, % of labor force | ||
|Percent | |Percent | ||
|1 | |1 | ||
|POPULATION | |POPULATION | ||
| Line 661: | Line 542: | ||
|Customs and other import duties (% of tax revenue) | |Customs and other import duties (% of tax revenue) | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 671: | Line 551: | ||
|Ores and Metals exports as % of merchandise exports | |Ores and Metals exports as % of merchandise exports | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 681: | Line 560: | ||
|Prevalence of contraceptive use | |Prevalence of contraceptive use | ||
|Percent | |Percent | ||
|0 | |0 | ||
| | | | ||
| Line 691: | Line 569: | ||
|Access to electric energy National (% of population) | |Access to electric energy National (% of population) | ||
|percentage | |percentage | ||
|1 | |1 | ||
|INFRASTRUCTURE | |INFRASTRUCTURE | ||
| Line 701: | Line 578: | ||
|Access to electricity in Rural areas (% of population) | |Access to electricity in Rural areas (% of population) | ||
|percentage | |percentage | ||
|1 | |1 | ||
|INFRASTRUCTURE | |INFRASTRUCTURE | ||
| Line 711: | Line 587: | ||
|Access to electricity in Urban areas (% of population) | |Access to electricity in Urban areas (% of population) | ||
|percentage | |percentage | ||
|1 | |1 | ||
|INFRASTRUCTURE | |INFRASTRUCTURE | ||
| Line 721: | Line 596: | ||
|Percentage of children under 5 malnourished based on weight; US benchmark | |Percentage of children under 5 malnourished based on weight; US benchmark | ||
|Percent | |Percent | ||
|1 | |1 | ||
|AGRICULTURE | |AGRICULTURE | ||
| Line 731: | Line 605: | ||
|Taxes on goods and services as % of total govt revenue | |Taxes on goods and services as % of total govt revenue | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 741: | Line 614: | ||
|Social security taxes as % of total govt revenue | |Social security taxes as % of total govt revenue | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 751: | Line 623: | ||
|Gini index of income inequality (lower = more equal) | |Gini index of income inequality (lower = more equal) | ||
|Index | |Index | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 761: | Line 632: | ||
|Percent of population on-line | |Percent of population on-line | ||
|Percent | |Percent | ||
|1 | |1 | ||
|SOCIOPOL | |SOCIOPOL | ||
| Line 771: | Line 641: | ||
|Employees, agriculture, female as % of female employment | |Employees, agriculture, female as % of female employment | ||
|Percent | |Percent | ||
|1 | |1 | ||
|POPULATION | |POPULATION | ||
| Line 781: | Line 650: | ||
|Value added in agriculture as percent of GDP | |Value added in agriculture as percent of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 791: | Line 659: | ||
|Value added in services as percent of GDP | |Value added in services as percent of GDP | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 801: | Line 668: | ||
|Employees, agriculture, males as % of male employment | |Employees, agriculture, males as % of male employment | ||
|Percent | |Percent | ||
|1 | |1 | ||
|POPULATION | |POPULATION | ||
| Line 811: | Line 677: | ||
|Current account balance (% of GDP) | |Current account balance (% of GDP) | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 821: | Line 686: | ||
|Maternal deaths per 100,000 live births | |Maternal deaths per 100,000 live births | ||
|Ratio | |Ratio | ||
|1 | |1 | ||
|POPULATION | |POPULATION | ||
| Line 831: | Line 695: | ||
|PM2.5 air pollution, mean annual exposure (micrograms per cubic meter) | |PM2.5 air pollution, mean annual exposure (micrograms per cubic meter) | ||
|micrograms per cubic meter | |micrograms per cubic meter | ||
|1 | |1 | ||
|ENVIRONMENT | |ENVIRONMENT | ||
| Line 841: | Line 704: | ||
|Stunting (Height for age) amongst children aged under the age of 5 | |Stunting (Height for age) amongst children aged under the age of 5 | ||
|Percent | |Percent | ||
|1 | |1 | ||
|HEALTH | |HEALTH | ||
| Line 851: | Line 713: | ||
|Use of insecticide-treated bed nets (% of under-5 population) | |Use of insecticide-treated bed nets (% of under-5 population) | ||
|Percent | |Percent | ||
|1 | |1 | ||
|HEALTH | |HEALTH | ||
| Line 861: | Line 722: | ||
|Grants and other revenue include grants from other foreign governments, international organizations, and other government units; | |Grants and other revenue include grants from other foreign governments, international organizations, and other government units; | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 871: | Line 731: | ||
|Population below national poverty line | |Population below national poverty line | ||
|Percent | |Percent | ||
|1 | |1 | ||
|ECONOMY | |ECONOMY | ||
| Line 881: | Line 740: | ||
|Imports of ICT goods as % of total goods imports | |Imports of ICT goods as % of total goods imports | ||
|Percent | |Percent | ||
|0 | |0 | ||
| | | | ||
| Line 891: | Line 749: | ||
|Exports of ICT goods as % of total goods exports | |Exports of ICT goods as % of total goods exports | ||
|Percent | |Percent | ||
|0 | |0 | ||
| | | | ||
| Line 899: | Line 756: | ||
|} | |} | ||
= STEPS TO PULL DATA FROM WORLD BANK = | |||
Step 1. To pull data from the world bank, navigate to [https://data.worldbank.org/ data.worldbank.org] | |||
Step 2. To find the series, you can type in the search bar, click <Country> or click <nowiki><Indicator>.</nowiki> | |||
Step 3. Go to step 4 if clicked on <Country> or to step 7 if clicked on <nowiki><Indicator>.</nowiki> | |||
[[File:WBscreenshot10.jpg|center|World Bank Data homepage|thumb|499x499px]] | |||
Step 4. If clicked on <Country>, you can select an individual country or options under various categories, such as <Region> and <Income levels>. This example will use the <High Income> category. | |||
[[File:WB IMG STEP 04.jpg|center|thumb|544x544px|Countries and Economies main page]] | |||
Step 5. If a category is selected, the following example screen of <High Income> will formulate. From here, select the relevant topic/theme/SDG Goal, then click on the desired indicator. Then skip to steps 10-12, which show how to download an indicator. | |||
[[File:WB IMG STEP 05.jpg|center|thumb|504x504px|High Income example page]] | |||
Step 6. If an individual country is selected, the following example screen will formulate. From here, select the relevant topic/theme/SDG Goal, then click on the desired indicator. Then skip to steps 10-12, which show how to download an indicator. | |||
[[File:WBscreenshot15.jpg|center|Afghanistan example page|thumb|507x507px]] | |||
Step 7. If clicked on <nowiki><Indicator>, navigate to the relevant category of the desired indicator or type in the search bar. For this example, click on the <Climate Change> category.</nowiki> | |||
[[File:WB IMG STEP 07.jpg|center|Indicators main page|thumb|499x499px]] | |||
Step 8. The following page will populate. Click on <Access to electricity (% of population)> as an indicator example. | |||
[[File:WB IMG STEP 08.jpg|center|Example category from indicators page|thumb|508x508px]] | |||
Step 9. Clicking on <Access to electricity (% of population)> will lead to this page. | |||
[[File:WBscreenshot5.jpg|center|Access to electricity indicator|thumb|502x502px]] | |||
Step 10. If a more specific variable is desired, select one of the options of the right side. As an example, <Access to electricity, urban (% of urban population)> is showed here. | |||
[[File:WBscreenshot12.jpg|center|Access to electricity indicator|thumb|504x504px]] | |||
Step 11. Before downloading, select desired time range on the sliding scale beneath the graph. | |||
Step 12. On the right side of the graph, under <Download>, click <EXCEL>. An excel data set will immediately download. You may also click <WDI Tables> to see the data in a slightly different format. | |||
[[File:WB IMG STEP 12.jpg|center|Download Indicator|thumb|493x493px]] | |||
== STEPS TO PULL DATA FROM WORLD BANK WDI (WORLD DEVELOPMENT INDICATORS)== | |||
Step 1. To pull data from the World Bank's World Development Indicators database, navigate to https://databank.worldbank.org/source/world-development-indicators | |||
Step 2. In order to pull data, you'll need to first make selections regarding the database to pull from, countries, series, and time. These variables are on the left hand side. | |||
[[File:WBwdiScreenshot9.jpg|center|World Bank WDI main page|thumb|505x505px]] | |||
Step 3. First, select a database. This example will stay with WDI. [[File:WBwdiScreenshot.jpg|center|WDI page with database options|thumb|502x502px]] | |||
Step 4. Second, select the countries to include in the data. To choose all countries, click the checkbox above the list of country names. [[File:WBwdiScreenshot10.jpg|center|WDI page with country options|thumb|509x509px]] | |||
Step 5. Third, select series from keywords or alphabetical list. This example will choose <Access to electricity, (% of population)>. | |||
[[File:WB WDI IMG STEP 05.jpg|center|thumb|508x508px|WDI page with series options]] | |||
Step 6. Finally, select time as range of years. To choose all years, click the checkbox above the list of years. | |||
. [[File:WBwdiScreenshot11.jpg|center|WDI page with year options|thumb|501x501px]] | |||
Step 7. When all variables have been selected, click <Apply Changes>. [[File:WBwdiScreenshot12.jpg|center|WDI page with "Apply Changes"|thumb|499x499px]] | |||
Step 8. The following preview page will formulate. You can also adjust the layout on the left side under the <Layout> tab, and you can preview data in different formats by clicking on <nowiki><Table>, <Chart>, and <Map>. </nowiki> | |||
To download, click <Download Options> in right hand corner. Then click <Excel> and an Excel dataset will immediately download. | |||
[[File:WB WDI IMG STEP 08(2).jpg|center|thumb|501x501px|WDI page with download options]] | |||
= Notes for Data Importing = | |||
We updated 82 series from WDI, 71 of them are preprocessors and 11 non preprocessors. | |||
# Download CSV file from https://datacatalog.worldbank.org/search/dataset/0037712/World-Development-Indicators | # Download CSV file from https://datacatalog.worldbank.org/search/dataset/0037712/World-Development-Indicators | ||
# Open the WDICSV.csv file. | # Open the WDICSV.csv file. | ||
| Line 906: | Line 824: | ||
## Always applying "'''round'''" function after you applied multiplying 100. | ## Always applying "'''round'''" function after you applied multiplying 100. | ||
# The "'''Years'''" for some series are discountinued, please remove the years with all "Nulls" before importing. | # The "'''Years'''" for some series are discountinued, please remove the years with all "Nulls" before importing. | ||
# Blending with | # Blending with old data in IFsHistSeries: | ||
## A country that has data in the previous release but not anymore. For this case, we need to bring the data in unless we have a solid proof to say they delete a country's data on purpose. For example, in the table GovCon%GDP, Nigeria used to have values, but the new table has all nulls for it because WDI somehow removes values for Nigeria. | ## A country that has data in the previous release but not anymore. For this case, we need to bring the data in unless we have a solid proof to say they delete a country's data on purpose. For example, in the table GovCon%GDP, Nigeria used to have values, but the new table has all nulls for it because WDI somehow removes values for Nigeria. | ||
## Some historical years of data are missing completely for all countries. WDI does this every now and then. For example, for certain tables, it used to have coverage back to 1960, then along the updates WDI only offers data back to 1980 or even 2000. | ## Some historical years of data are missing completely for all countries. WDI does this every now and then. For example, for certain tables, it used to have coverage back to 1960, then along the updates WDI only offers data back to 1980 or even 2000. | ||
# If you want to try to use python scripts to pull the data, you may access the scripts from [https://github.com/ | # If you want to try to use python scripts to pull the data, you may access the scripts from [https://github.com/n1shamin/World-Development-Indicators-Update-2025 here]. | ||
Revision as of 18:30, 1 July 2025
SUMMARY
The World Bank's Open Data is an initiative from the the World Bank Group to produce reliable data about its member countries, including a number of macro, financial, and sector databases. Their datasets include ones focused on development, aid effectiveness, climate change, economy, education, debt, infrastructure, etc. The World Bank also has a World Development Indicators (WDI) database, which is the premier compilation of cross country comparable data on development and is the primary collection of development indicators. WDI specifically contains 1,400 time series indicators from 217 economies, with much of that data going back more than 50 years. Data for Open Data and WDI is compiled from statistical systems of member countries and officially recognized international sources. Most social and economic data are updated annually or less often and some economic and financial data are updated quarterly. The WDI database is updated quarterly, sometimes more often.
The data team uses World Bank Open Data and WDI for a number of series about education, agriculture, aid, gender issues, environment, finances, economics, and development. Most importantly, WB databases are used for GDP and GDPPC. Example series from the World Bank include but are not limited to, SeriesAgFoodProductIndex, SeriesAidRec%GNI, SeriesCompanyValue%GDP, SeriesExportImport%GDP.
Tables in IFs
| Variable | Definition | Units | UsedInPreprocessor | UsedInPreprocessorFileName | Code in Source | Decimal Places | Formula |
| ArmsImp%TotImp | Arms imports (SIPRI trend indicator values) | Percent | 1 | ECONOMY | MS.MIL.MPRT.KD | 3 | %'NE.IMP.GNFS.CD' |
| XDebtPNG%GDP | External debt, private non-guaranteed, as percentage of gross domestic product | Percent | 1 | ECONOMY | DT.DOD.DPNG.CD | 4 | %'NY.GDP.MKTP.CD' |
| XDebtPPG%GDP | External debt, public and publicly guaranteed, as percentage of gross domestic product | Percent | 1 | ECONOMY | DT.DOD.DPPG.CD | 4 | %'NY.GDP.MKTP.CD' |
| XFlowsIDA%GDP | Net flows from IDA as % of GDP | Percent | 1 | ECONOMY | DT.NFL.MIDA.CD | 4 | %'NY.GDP.MKTP.CD' |
| XFlowsIMFNonCon%GDP | Net nonconcessional flows from IMF as % of GDP | Percent | 1 | ECONOMY | DT.NFL.IMFN.CD | 4 | %'NY.GDP.MKTP.CD' |
| XIMFCredit%GDP | IMF credits as % of GDP | Percent | 1 | ECONOMY | DT.DOD.DIMF.CD | 4 | %'NY.GDP.MKTP.CD' |
| XIncPayments%GDP | Income payments as % of GDP | Percent | 1 | ECONOMY | BM.GSR.FCTY.CD | 4 | %'NY.GDP.MKTP.CD' |
| XPortBonds%GDP | Portfolio investment in bonds (PPG and PNG) as % of GDP | Percent | 1 | ECONOMY | DT.NFL.BOND.CD | 4 | %'NY.GDP.MKTP.CD' |
| XPortEquity%GDP | Portfolio investment in equity as % of GDP | Percent | 1 | ECONOMY | BX.PEF.TOTL.CD.WD | 4 | %'NY.GDP.MKTP.CD' |
| XReserves%GDP | Gross international reserves as % of GDP | Percent | 1 | ECONOMY | FI.RES.TOTL.CD | 4 | %'NY.GDP.MKTP.CD' |
| XFlowsIMFCon%GDP | Net concessional flows from IMF as % of GDP | Percent | 1 | ECONOMY | DT.NFL.IMFC.CD | 4 | %'NY.GDP.MKTP.CD' |
| XIncReceipts%GDP | Income receipts as % of GDP | Percent | 1 | ECONOMY | BX.GSR.FCTY.CD | 3 | %'NY.GDP.MKTP.CD' |
| XFlowsIBRD%GDP | Net flows from IBRD as % of GDP | Percent | 1 | ECONOMY | DT.NFL.MIBR.CD | 4 | %'NY.GDP.MKTP.CD' |
| XWBLoans%GDP | IBRD loans and IDA credits as % of GDP | Percent | 1 | ECONOMY | DT.DOD.MWBG.CD | 4 | %'NY.GDP.MKTP.CD' |
| GovtCurRev%GDP | Current government revenue as % of GDP | Percent | 1 | ECONOMY | GC.REV.XGRT.GD.ZS | 3 | %'NY.GDP.MKTP.CD' |
| ExportServices%GDP | Exports of services as % of GDP | Percent | 1 | ECONOMY | BX.GSR.NFSV.CD | 4 | %'NY.GDP.MKTP.CD' |
| ExportsMerchandise%GDP | Exports of merchandise as % of GDP | Percent | 1 | ECONOMY | TX.VAL.MRCH.CD.WT | 4 | %'NY.GDP.MKTP.CD' |
| ImportServices%GDP | Imports of Services as % of GDP | Percent | 1 | ECONOMY | BM.GSR.NFSV.CD | 4 | %'NY.GDP.MKTP.CD' |
| ImportsMerchandise%GDP | Imports of merchandiseas % of GDP | Percent | 1 | ECONOMY | TM.VAL.MRCH.CD.WT | 4 | %'NY.GDP.MKTP.CD' |
| XWorkerRemitPaid%GDP | Worker remittances by country where paid as % of GDP | Percent | 1 | ECONOMY | BM.TRF.PWKR.CD.DT | 4 | %'NY.GDP.MKTP.CD' |
| XWorkerRemitReceived%GDP | Worker remittances received by country as % of GDP | Percent | 1 | ECONOMY | BX.TRF.PWKR.CD.DT | 4 | %'NY.GDP.MKTP.CD' |
| XDebt%GDP | External debt as percentage of gross domestic product | Percent | 1 | ECONOMY | DT.DOD.DECT.CD | 4 | %'NY.GDP.MKTP.CD' |
| NetForeignAssets%GDP | Net Foreign Assets (current LCU) as a percent of GDP. | Percent | 0 | FM.AST.NFRG.CN | 4 | %'NY.GDP.MKTP.CN' | |
| Labor | Labor force size | Millions | 1 | POPULATION | SL.TLF.TOTL.IN | 4 | /1000000 |
| PopulationUrban | Urban population | Millions | 1 | POPULATION | SP.URB.TOTL | 4 | /1000000 |
| GDPCurDol | Gross Domestic Product in Current US$ | Billion $ | 1 | ENERGY | NY.GDP.MKTP.CD | 4 | /1000000000 |
| Xdebt | External long-term (more than 1 year) debt: public, publically guaranteed and priv nonguaranteed | Billion $ | 1 | ECONOMY | DT.DOD.DLXF.CD | 4 | /1000000000 |
| LaborFemale% | Portion of labor force made up by women | Percent | 1 | POPULATION | SL.TLF.TOTL.FE.ZS | 4 | |
| LaborSecInd%Tot | Labor in industry as % of total | Percent | 0 | SL.IND.EMPL.ZS | 4 | ||
| LaborSecSer%Tot | Labor in services as % of total | Percent | 0 | SL.SRV.EMPL.ZS | 4 | ||
| VaddInd% | Value added in industry as percent of GDP | Percent | 1 | ECONOMY | NV.IND.TOTL.ZS | 3 | |
| OresMetsIm%MerchIm | Ores and Metals imports as % of merchandise imports | Percent | 1 | ECONOMY | TM.VAL.MMTL.ZS.UN | 4 | |
| GovtDebt%GDP | Central government debt as % of GDP | Percent | 1 | ECONOMY | GC.DOD.TOTL.GD.ZS | 4 | |
| VaddMan% | Value added in manufacturing as percent of GDP | Percent | 1 | ECONOMY | NV.IND.MANF.ZS | 3 | |
| PopForeign% | Foreign population as % of total population | Percent | 0 | SM.POP.TOTL.ZS | 4 | ||
| LaborAgriSector | Agricultural labor force as % of total employment, ISIC multiple revisions | Percent | 1 | ECONOMY | SL.AGR.EMPL.ZS | 3 | |
| GenderUnpaidDomesticWorkTimeFemale | Proportion of time spent on unpaid domestic and care work, female (% of 24 hour day). | Percent | 0 | SG.TIM.UWRK.FE | 2 | ||
| GenderUnpaidDomesticWorkTimeMale | Proportion of time spent on unpaid domestic and care work, male (% of 24 hour day). | Percent | 1 | POPULATION | SG.TIM.UWRK.MA | 2 | |
| IncBelow2D15c% | Percentage of the population living on less than $2.15 a day at 2017 international prices, estimation by World Bank, Poverty and Inequality Platform. | Percent | 0 | SI.POV.DDAY | 4 | ||
| IncBelow3D65c% | Percentage of the population living on less than $3.65 a day at 2017 international prices, estimation by World Bank, Poverty and Inequality Platform. | Percent | 0 | SI.POV.LMIC | 4 | ||
| IncBelow6D85c% | Percentage of the population living on less than $6.85 a day at 2017 international prices, estimation by World Bank, Poverty and Inequality Platform. | Percent | 0 | SI.POV.UMIC | 4 | ||
| PovGap2D15cperDay | Poverty gap at $2.15 per day (2017PPP), percent, estimation by World Bank, Poverty and Inequality Platform | Percent | 1 | ECONOMY | SI.POV.GAPS | 4 | |
| PovGap3D65perDay | Poverty gap at $3.65 per day (2017PPP), percent, estimation by World Bank, Poverty and Inequality Platform | Percent | 1 | ECONOMY | SI.POV.LMIC.GP | 4 | |
| PovGap6D85cperDay | Poverty gap at $6.85 per day (2017PPP), percent, estimation by World Bank, Poverty and Inequality Platform | Percent | 1 | ECONOMY | SI.POV.UMIC.GP | 4 | |
| ExportGoodSer% | Exports of goods and services as % of GDP | Percent | 1 | ECONOMY | NE.EXP.GNFS.ZS | 4 | |
| EnElecTransLoss% | Electric power transmission and distribution losses (% of output) | Percent | 1 | INFRASTRUCTURE | EG.ELC.LOSS.ZS | 4 | |
| GovtEdPub%GDP | Educational expenditures (public) as percent of GDP | Percent | 1 | ECONOMY | SE.XPD.TOTL.GD.ZS | 4 | |
| GovWBDoingBusinessCostofStarting | Cost of registring a business as a percent of per capita income | Percent | 1 | SOCIOPOL | IC.REG.COST.PC.ZS | 4 | |
| GovtMil%GDPWDI | Military expenditures (as percent of GDP). Taiwan, China values filled by SIPRI. | Percent | 1 | ECONOMY | MS.MIL.XPND.GD.ZS | 4 | |
| GovCon%GDP | Government (general) final consumption as % of GDP | Percent | 1 | ECONOMY | NE.CON.GOVT.ZS | 3 | |
| GovExpense%GDP | Government expense as % of GDP (compare with govt expenditures) | Percent | 1 | ECONOMY | GC.XPN.TOTL.GD.ZS | 3 | |
| ImportGoodSer% | Imports of goods and services as % of GDP | Percent | 1 | ECONOMY | NE.IMP.GNFS.ZS | 4 | |
| EnElecConsPerCap | Electricity consumption per capita | KWH/Cap | 1 | INFRASTRUCTURE | EG.USE.ELEC.KH.PC | 4 | |
| InvestGrCapForm%GDP | Gross capital formation (Investment), percent of GDP | Percent | 1 | ECONOMY | NE.GDI.TOTL.ZS | 3 | |
| XFDIInflows%GDP | Foreign direct investment net inflow as % of GDP | Percent | 1 | ECONOMY | BX.KLT.DINV.WD.GD.ZS | 4 | |
| XFDIOutflows%GDP | Foreign direct investment net outflow as % of GDP | Percent | 1 | ECONOMY | BM.KLT.DINV.WD.GD.ZS | 3 | |
| IncShareL20% | Income share of poorest 20% of population | Percent | 1 | ECONOMY | SI.DST.FRST.20 | 3 | |
| LaborUnemploy% | Labor unemployment, % of labor force | Percent | 1 | POPULATION | SL.UEM.TOTL.ZS | 3 | |
| TaxImportDuties%Rev | Customs and other import duties (% of tax revenue) | Percent | 1 | ECONOMY | GC.TAX.IMPT.ZS | 4 | |
| OresMetsEx%MerchEx | Ores and Metals exports as % of merchandise exports | Percent | 1 | ECONOMY | TX.VAL.MMTL.ZS.UN | 4 | |
| PopContrUse%WDI | Prevalence of contraceptive use | Percent | 0 | SP.DYN.CONU.ZS | 4 | ||
| EnElecAccess%National | Access to electric energy National (% of population) | percentage | 1 | INFRASTRUCTURE | EG.ELC.ACCS.ZS | 4 | |
| EnElecAccess%Rural | Access to electricity in Rural areas (% of population) | percentage | 1 | INFRASTRUCTURE | EG.ELC.ACCS.RU.ZS | 4 | |
| EnElecAccess%Urban | Access to electricity in Urban areas (% of population) | percentage | 1 | INFRASTRUCTURE | EG.ELC.ACCS.UR.ZS | 4 | |
| MalnChil%WeightWB | Percentage of children under 5 malnourished based on weight; US benchmark | Percent | 1 | AGRICULTURE | SH.STA.MALN.ZS | 4 | |
| TaxGoodSer%CurRev | Taxes on goods and services as % of total govt revenue | Percent | 1 | ECONOMY | GC.TAX.GSRV.RV.ZS | 3 | |
| TaxSocSec%CurRev | Social security taxes as % of total govt revenue | Percent | 1 | ECONOMY | GC.REV.SOCL.ZS | 3 | |
| GiniExtended | Gini index of income inequality (lower = more equal) | Index | 1 | ECONOMY | SI.POV.GINI | 3 | |
| ICTInternet%Pop | Percent of population on-line | Percent | 1 | SOCIOPOL | IT.NET.USER.ZS | 4 | |
| LaborAgr%TotFemale | Employees, agriculture, female as % of female employment | Percent | 1 | POPULATION | SL.AGR.EMPL.FE.ZS | 4 | |
| VaddAg% | Value added in agriculture as percent of GDP | Percent | 1 | ECONOMY | NV.AGR.TOTL.ZS | 3 | |
| VaddSer% | Value added in services as percent of GDP | Percent | 1 | ECONOMY | NV.SRV.TOTL.ZS | 3 | |
| LaborAgr%TotMale | Employees, agriculture, males as % of male employment | Percent | 1 | POPULATION | SL.AGR.EMPL.MA.ZS | 4 | |
| XCurActBal%GDP | Current account balance (% of GDP) | Percent | 1 | ECONOMY | BN.CAB.XOKA.GD.ZS | 3 | |
| MaternalMortalityRatio | Maternal deaths per 100,000 live births | Ratio | 1 | POPULATION | SH.STA.MMRT | 2 | |
| EnvPMWDI | PM2.5 air pollution, mean annual exposure (micrograms per cubic meter) | micrograms per cubic meter | 1 | ENVIRONMENT | EN.ATM.PM25.MC.M3 | 5 | |
| ChildStuntingPercentWDI | Stunting (Height for age) amongst children aged under the age of 5 | Percent | 1 | HEALTH | SH.STA.STNT.ZS | 5 | |
| HealthMalarBedNetsWDI | Use of insecticide-treated bed nets (% of under-5 population) | Percent | 1 | HEALTH | SH.MLR.NETS.ZS | 3 | |
| AidRecGrant%TotRev | Grants and other revenue include grants from other foreign governments, international organizations, and other government units; | Percent | 1 | ECONOMY | GC.REV.GOTR.ZS | 3 | |
| IncBelowNPL%WDI | Population below national poverty line | Percent | 1 | ECONOMY | SI.POV.NAHC | 1 | |
| ICTImport%Imp | Imports of ICT goods as % of total goods imports | Percent | 0 | TM.VAL.ICTG.ZS.UN | 2 | ||
| ICTExport%Exp | Exports of ICT goods as % of total goods exports | Percent | 0 | TX.VAL.ICTG.ZS.UN | 2 |
STEPS TO PULL DATA FROM WORLD BANK
Step 1. To pull data from the world bank, navigate to data.worldbank.org
Step 2. To find the series, you can type in the search bar, click <Country> or click <Indicator>.
Step 3. Go to step 4 if clicked on <Country> or to step 7 if clicked on <Indicator>.
Step 4. If clicked on <Country>, you can select an individual country or options under various categories, such as <Region> and <Income levels>. This example will use the <High Income> category.
Step 5. If a category is selected, the following example screen of <High Income> will formulate. From here, select the relevant topic/theme/SDG Goal, then click on the desired indicator. Then skip to steps 10-12, which show how to download an indicator.
Step 6. If an individual country is selected, the following example screen will formulate. From here, select the relevant topic/theme/SDG Goal, then click on the desired indicator. Then skip to steps 10-12, which show how to download an indicator.
Step 7. If clicked on <Indicator>, navigate to the relevant category of the desired indicator or type in the search bar. For this example, click on the <Climate Change> category.
Step 8. The following page will populate. Click on <Access to electricity (% of population)> as an indicator example.
Step 9. Clicking on <Access to electricity (% of population)> will lead to this page.
Step 10. If a more specific variable is desired, select one of the options of the right side. As an example, <Access to electricity, urban (% of urban population)> is showed here.
Step 11. Before downloading, select desired time range on the sliding scale beneath the graph.
Step 12. On the right side of the graph, under <Download>, click <EXCEL>. An excel data set will immediately download. You may also click <WDI Tables> to see the data in a slightly different format.
STEPS TO PULL DATA FROM WORLD BANK WDI (WORLD DEVELOPMENT INDICATORS)
Step 1. To pull data from the World Bank's World Development Indicators database, navigate to https://databank.worldbank.org/source/world-development-indicators
Step 2. In order to pull data, you'll need to first make selections regarding the database to pull from, countries, series, and time. These variables are on the left hand side.
Step 3. First, select a database. This example will stay with WDI.
Step 4. Second, select the countries to include in the data. To choose all countries, click the checkbox above the list of country names.
Step 5. Third, select series from keywords or alphabetical list. This example will choose <Access to electricity, (% of population)>.
Step 6. Finally, select time as range of years. To choose all years, click the checkbox above the list of years.
.
Step 7. When all variables have been selected, click <Apply Changes>.
Step 8. The following preview page will formulate. You can also adjust the layout on the left side under the <Layout> tab, and you can preview data in different formats by clicking on <Table>, <Chart>, and <Map>.
To download, click <Download Options> in right hand corner. Then click <Excel> and an Excel dataset will immediately download.
.jpg)
Notes for Data Importing
We updated 82 series from WDI, 71 of them are preprocessors and 11 non preprocessors.
- Download CSV file from https://datacatalog.worldbank.org/search/dataset/0037712/World-Development-Indicators
- Open the WDICSV.csv file.
- Use the "Code in Source" from the DataDict and "Indicator Code" from WDICSV file to preprare the series.
- Be care of the "Formula", if there is a "%XXXX"(the XXXX is the "Indicator Code"), then you need to use the series divide the series after "%". The series after "%" also in the WDICSV.
- Please keep in mind *100 after you finish the division to make it in "Percent" instead of decimal.
- Always applying "round" function after you applied multiplying 100.
- The "Years" for some series are discountinued, please remove the years with all "Nulls" before importing.
- Blending with old data in IFsHistSeries:
- A country that has data in the previous release but not anymore. For this case, we need to bring the data in unless we have a solid proof to say they delete a country's data on purpose. For example, in the table GovCon%GDP, Nigeria used to have values, but the new table has all nulls for it because WDI somehow removes values for Nigeria.
- Some historical years of data are missing completely for all countries. WDI does this every now and then. For example, for certain tables, it used to have coverage back to 1960, then along the updates WDI only offers data back to 1980 or even 2000.
- If you want to try to use python scripts to pull the data, you may access the scripts from here.