Baselight
Sign In

WBSTATS From World Bank API

Access to Data and Statistics from the World Bank API (from R)

@kaggle.darylb_wbstats

Loading...
Loading...

About this Dataset

WBSTATS From World Bank API

This Dataset comes from the R Package wbstats. The World Bank[https://www.worldbank.org/] is a tremendous source of global socio-economic data; spanning several decades and dozens of topics, it has the potential to shed light on numerous global issues. To help provide access to this rich source of information, The World Bank themselves, provide a well structured RESTful API. While this API is very useful for integration into web services and other high-level applications, it becomes quickly overwhelming for researchers who have neither the time nor the expertise to develop software to interface with the API. This leaves the researcher to rely on manual bulk downloads of spreadsheets of the data they are interested in. This too is can quickly become overwhelming, as the work is manual, time consuming, and not easily reproducible. The goal of the wbstats R-package is to provide a bridge between these alternatives and allow researchers to focus on their research questions and not the question of accessing the data. The wbstats R-package allows researchers to quickly search and download the data of their particular interest in a programmatic and reproducible fashion; this facilitates a seamless integration into their workflow and allows analysis to be quickly rerun on different areas of interest and with realtime access to the latest available data.

World Development Indicators (WDI) is the primary World Bank collection 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. Copied from https://databank.worldbank.org/source/world-development-indicators.

Highlighted features of the wbstats R-package:

  • Uses version 2 of the World Bank API that provides access to more indicators and metadata than the previous API version
  • Access to all annual, quarterly, and monthly data available in the API
  • Support for searching and downloading data in multiple languages
  • Returns data in either wide (default) or long format
  • Support for Most Recent Value queries
  • Support for grep style searching for data descriptions and names
  • Ability to download data not only by country, but by aggregates as well, such as High Income or South Asia

More information can be found at https://www.rdocumentation.org/packages/wbstats/versions/1.0.4

Note for Version 1.
Version 1 published January 2023. Its primary focus is on the featured indicator of climate change. Other versions planned will cover other featured indicators such as economy, education, energy, environment, debt, gender, health, infrastructure, poverty, science and technology.

Tables

Wb Climatechange Data

@kaggle.darylb_wbstats.wb_climatechange_data
  • 1.32 MB
  • 4,364 rows
  • 81 columns
Loading... 
CREATE TABLE wb_climatechange_data (
  "iso2c" VARCHAR,
  "iso3c" VARCHAR,
  "country" VARCHAR,
  "date" BIGINT,
  "ag_lnd_agri_k2" DOUBLE,
  "ag_lnd_agri_zs" DOUBLE,
  "ag_lnd_arbl_zs" DOUBLE,
  "ag_lnd_el5m_ru_k2" DOUBLE,
  "ag_lnd_el5m_ru_zs" DOUBLE,
  "ag_lnd_el5m_ur_k2" DOUBLE,
  "ag_lnd_el5m_ur_zs" DOUBLE,
  "ag_lnd_el5m_zs" DOUBLE,
  "ag_lnd_frst_k2" DOUBLE,
  "ag_lnd_frst_zs" DOUBLE,
  "ag_lnd_irig_ag_zs" DOUBLE,
  "ag_lnd_prcp_mm" DOUBLE,
  "ag_yld_crel_kg" DOUBLE,
  "bx_klt_dinv_wd_gd_zs" DOUBLE,
  "eg_elc_accs_zs" DOUBLE,
  "eg_elc_coal_zs" DOUBLE,
  "eg_elc_hyro_zs" DOUBLE,
  "eg_elc_ngas_zs" DOUBLE,
  "eg_elc_nucl_zs" DOUBLE,
  "eg_elc_petr_zs" DOUBLE,
  "eg_elc_rnew_zs" DOUBLE,
  "eg_elc_rnwx_kh" DOUBLE,
  "eg_elc_rnwx_zs" DOUBLE,
  "eg_fec_rnew_zs" DOUBLE,
  "eg_use_comm_gd_pp_kd" DOUBLE,
  "eg_use_elec_kh_pc" DOUBLE,
  "eg_use_pcap_kg_oe" DOUBLE,
  "en_atm_co2e_eg_zs" DOUBLE,
  "en_atm_co2e_gf_kt" DOUBLE,
  "en_atm_co2e_gf_zs" DOUBLE,
  "en_atm_co2e_kd_gd" DOUBLE,
  "en_atm_co2e_kt" DOUBLE,
  "en_atm_co2e_lf_kt" DOUBLE,
  "en_atm_co2e_lf_zs" DOUBLE,
  "en_atm_co2e_pc" DOUBLE,
  "en_atm_co2e_pp_gd" DOUBLE,
  "en_atm_co2e_pp_gd_kd" DOUBLE,
  "en_atm_co2e_sf_kt" DOUBLE,
  "en_atm_co2e_sf_zs" DOUBLE,
  "en_atm_ghgo_kt_ce" DOUBLE,
  "en_atm_ghgo_zg" DOUBLE,
  "en_atm_ghgt_kt_ce" DOUBLE,
  "en_atm_ghgt_zg" DOUBLE,
  "en_atm_hfcg_kt_ce" DOUBLE,
  "en_atm_meth_kt_ce" DOUBLE,
  "en_atm_meth_zg" DOUBLE,
  "en_atm_noxe_kt_ce" DOUBLE,
  "en_atm_noxe_zg" DOUBLE,
  "en_atm_pfcg_kt_ce" DOUBLE,
  "en_atm_sf6g_kt_ce" DOUBLE,
  "en_clc_drsk_xq" DOUBLE,
  "en_clc_ghgr_mt_ce" DOUBLE,
  "en_clc_mdat_zs" DOUBLE,
  "en_pop_el5m_ru_zs" DOUBLE,
  "en_pop_el5m_ur_zs" DOUBLE,
  "en_pop_el5m_zs" DOUBLE,
  "en_urb_mcty_tl_zs" DOUBLE,
  "er_h2o_fwtl_k3" DOUBLE,
  "er_h2o_fwtl_zs" DOUBLE,
  "er_lnd_ptld_zs" DOUBLE,
  "er_mrn_ptmr_zs" DOUBLE,
  "er_ptd_totl_zs" DOUBLE,
  "ic_bus_ease_xq" DOUBLE,
  "iq_cpa_pubs_xq" DOUBLE,
  "is_rod_pave_zs" DOUBLE,
  "nv_agr_totl_zs" DOUBLE,
  "se_enr_prsc_fm_zs" DOUBLE,
  "se_prm_cmpt_zs" DOUBLE,
  "sh_dyn_mort" DOUBLE,
  "sh_med_cmhw_p3" DOUBLE,
  "sh_sta_maln_zs" DOUBLE,
  "si_pov_dday" DOUBLE,
  "sp_pop_grow" DOUBLE,
  "sp_pop_totl" DOUBLE,
  "sp_urb_grow" DOUBLE,
  "sp_urb_totl" DOUBLE,
  "sp_urb_totl_in_zs" DOUBLE
);

Wb Countries

@kaggle.darylb_wbstats.wb_countries
  • 27.82 kB
  • 299 rows
  • 18 columns
Loading... 
CREATE TABLE wb_countries (
  "iso3c" VARCHAR,
  "iso2c" VARCHAR,
  "country" VARCHAR,
  "capital_city" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "region_iso3c" VARCHAR,
  "region_iso2c" VARCHAR,
  "region" VARCHAR,
  "admin_region_iso3c" VARCHAR,
  "admin_region_iso2c" VARCHAR,
  "admin_region" VARCHAR,
  "income_level_iso3c" VARCHAR,
  "income_level_iso2c" VARCHAR,
  "income_level" VARCHAR,
  "lending_type_iso3c" VARCHAR,
  "lending_type_iso2c" VARCHAR,
  "lending_type" VARCHAR
);

Wb Income Levels

@kaggle.darylb_wbstats.wb_income_levels
  • 2.78 kB
  • 7 rows
  • 3 columns
Loading... 
CREATE TABLE wb_income_levels (
  "iso3c" VARCHAR,
  "iso2c" VARCHAR,
  "income_level" VARCHAR
);

Wb Indicators

@kaggle.darylb_wbstats.wb_indicators
  • 1.12 MB
  • 20,153 rows
  • 8 columns
Loading... 
CREATE TABLE wb_indicators (
  "indicator_id" VARCHAR,
  "indicator" VARCHAR,
  "unit" VARCHAR,
  "indicator_desc" VARCHAR,
  "source_org" VARCHAR,
  "topics" VARCHAR,
  "source_id" BIGINT,
  "source" VARCHAR
);

Wb Indicators Topics

@kaggle.darylb_wbstats.wb_indicators_topics
  • 49.6 kB
  • 6,240 rows
  • 3 columns
Loading... 
CREATE TABLE wb_indicators_topics (
  "indicator_id" VARCHAR,
  "id" BIGINT,
  "value" VARCHAR
);

Wb Languages

@kaggle.darylb_wbstats.wb_languages
  • 3.35 kB
  • 23 rows
  • 3 columns
Loading... 
CREATE TABLE wb_languages (
  "iso2" VARCHAR,
  "lang" VARCHAR,
  "lang_native" VARCHAR
);

Wb Lending Types

@kaggle.darylb_wbstats.wb_lending_types
  • 2.67 kB
  • 4 rows
  • 3 columns
Loading... 
CREATE TABLE wb_lending_types (
  "iso3c" VARCHAR,
  "iso2c" VARCHAR,
  "lending_type" VARCHAR
);

Wb Regions

@kaggle.darylb_wbstats.wb_regions
  • 4.44 kB
  • 44 rows
  • 4 columns
Loading... 
CREATE TABLE wb_regions (
  "region_id" DOUBLE,
  "iso3c" VARCHAR,
  "iso2c" VARCHAR,
  "region" VARCHAR
);

Wb Sources

@kaggle.darylb_wbstats.wb_sources
  • 9.36 kB
  • 68 rows
  • 9 columns
Loading... 
CREATE TABLE wb_sources (
  "source_id" BIGINT,
  "last_updated" TIMESTAMP,
  "source" VARCHAR,
  "source_code" VARCHAR,
  "source_desc" VARCHAR,
  "source_url" VARCHAR,
  "data_available" BOOLEAN,
  "metadata_available" VARCHAR,
  "concepts" BIGINT
);

Wb Topics

@kaggle.darylb_wbstats.wb_topics
  • 11.49 kB
  • 21 rows
  • 3 columns
Loading... 
CREATE TABLE wb_topics (
  "topic_id" BIGINT,
  "topic" VARCHAR,
  "topic_desc" VARCHAR
);

Share link

Anyone who has the link will be able to view this.