Name: WBSTATS From World Bank API
Creator: Kaggle
License: https://datacatalog.worldbank.org/public-licenses

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

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

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

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

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

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

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

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

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

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

CREATE TABLE wb_topics (
  "topic_id" BIGINT,
  "topic" VARCHAR,
  "topic_desc" VARCHAR
);