About this Dataset

World Development Indicators - World Bank (2022.05.26)

The 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.

Tables

World Development Indicators - World Bank (2022.05.26)

@owid.wdi.owid_wdi_1

35.83 MB
14400 rows
1453 columns


CREATE TABLE owid_wdi_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "ag_agr_trac_no" FLOAT,
  "ag_con_fert_pt_zs" FLOAT,
  "ag_con_fert_zs" FLOAT,
  "ag_lnd_agri_k2" FLOAT,
  "ag_lnd_agri_zs" FLOAT,
  "ag_lnd_arbl_ha" FLOAT,
  "ag_lnd_arbl_ha_pc" FLOAT,
  "ag_lnd_arbl_zs" FLOAT,
  "ag_lnd_crel_ha" UINTEGER,
  "ag_lnd_crop_zs" FLOAT,
  "ag_lnd_el5m_ru_k2" FLOAT,
  "ag_lnd_el5m_ru_zs" FLOAT,
  "ag_lnd_el5m_ur_k2" FLOAT,
  "ag_lnd_el5m_ur_zs" FLOAT,
  "ag_lnd_el5m_zs" FLOAT,
  "ag_lnd_frst_k2" FLOAT,
  "ag_lnd_frst_zs" FLOAT,
  "ag_lnd_irig_ag_zs" FLOAT,
  "ag_lnd_prcp_mm" FLOAT,
  "ag_lnd_totl_k2" FLOAT,
  "ag_lnd_totl_ru_k2" FLOAT,
  "ag_lnd_totl_ur_k2" FLOAT,
  "ag_lnd_trac_zs" FLOAT,
  "ag_prd_crel_mt" UINTEGER,
  "ag_prd_crop_xd" FLOAT,
  "ag_prd_food_xd" FLOAT,
  "ag_prd_lvsk_xd" FLOAT,
  "ag_srf_totl_k2" FLOAT,
  "ag_yld_crel_kg" FLOAT,
  "bg_gsr_nfsv_gd_zs" FLOAT,
  "bm_gsr_cmcp_zs" FLOAT,
  "bm_gsr_fcty_cd" FLOAT,
  "bm_gsr_gnfs_cd" BIGINT,
  "bm_gsr_insf_zs" FLOAT,
  "bm_gsr_mrch_cd" BIGINT,
  "bm_gsr_nfsv_cd" BIGINT,
  "bm_gsr_royl_cd" FLOAT,
  "bm_gsr_totl_cd" BIGINT,
  "bm_gsr_tran_zs" FLOAT,
  "bm_gsr_trvl_zs" FLOAT,
  "bm_klt_dinv_cd_wd" FLOAT,
  "bm_klt_dinv_wd_gd_zs" FLOAT,
  "bm_trf_prvt_cd" FLOAT,
  "bm_trf_pwkr_cd_dt" FLOAT,
  "bn_cab_xoka_cd" BIGINT,
  "bn_cab_xoka_gd_zs" FLOAT,
  "bn_fin_totl_cd" FLOAT,
  "bn_gsr_fcty_cd" FLOAT,
  "bn_gsr_gnfs_cd" FLOAT,
  "bn_gsr_mrch_cd" BIGINT,
  "bn_kac_eoms_cd" FLOAT,
  "bn_klt_dinv_cd" FLOAT,
  "bn_klt_ptxl_cd" FLOAT,
  "bn_res_incl_cd" FLOAT,
  "bn_trf_curr_cd" FLOAT,
  "bn_trf_kogt_cd" FLOAT,
  "bx_grt_exta_cd_wd" FLOAT,
  "bx_grt_tech_cd_wd" BIGINT,
  "bx_gsr_ccis_cd" FLOAT,
  "bx_gsr_ccis_zs" FLOAT,
  "bx_gsr_cmcp_zs" FLOAT,
  "bx_gsr_fcty_cd" FLOAT,
  "bx_gsr_gnfs_cd" BIGINT,
  "bx_gsr_insf_zs" FLOAT,
  "bx_gsr_mrch_cd" BIGINT,
  "bx_gsr_nfsv_cd" BIGINT,
  "bx_gsr_royl_cd" FLOAT,
  "bx_gsr_totl_cd" BIGINT,
  "bx_gsr_tran_zs" FLOAT,
  "bx_gsr_trvl_zs" FLOAT,
  "bx_klt_dinv_cd_wd" FLOAT,
  "bx_klt_dinv_wd_gd_zs" FLOAT,
  "bx_pef_totl_cd_wd" FLOAT,
  "bx_trf_curr_cd" BIGINT,
  "bx_trf_pwkr_cd" FLOAT,
  "bx_trf_pwkr_cd_dt" FLOAT,
  "bx_trf_pwkr_dt_gd_zs" FLOAT,
  "cm_mkt_indx_zg" FLOAT,
  "cm_mkt_lcap_cd" BIGINT,
  "cm_mkt_lcap_gd_zs" FLOAT,
  "cm_mkt_ldom_no" INTEGER,
  "cm_mkt_trad_cd" BIGINT,
  "cm_mkt_trad_gd_zs" FLOAT,
  "cm_mkt_trnr" FLOAT,
  "dc_dac_ausl_cd" FLOAT,
  "dc_dac_autl_cd" FLOAT,
  "dc_dac_bell_cd" FLOAT,
  "dc_dac_canl_cd" FLOAT,
  "dc_dac_cecl_cd" FLOAT,
  "dc_dac_chel_cd" FLOAT,
  "dc_dac_czel_cd" FLOAT,
  "dc_dac_deul_cd" FLOAT,
  "dc_dac_dnkl_cd" FLOAT,
  "dc_dac_espl_cd" FLOAT,
  "dc_dac_finl_cd" FLOAT,
  "dc_dac_fral_cd" FLOAT,
  "dc_dac_gbrl_cd" FLOAT,
  "dc_dac_grcl_cd" FLOAT
);

Wdi 2

@owid.wdi.owid_wdi_2

34.96 MB
14339 rows
1451 columns


CREATE TABLE owid_wdi_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "ag_agr_trac_no" FLOAT,
  "ag_con_fert_pt_zs" FLOAT,
  "ag_con_fert_zs" FLOAT,
  "ag_lnd_agri_k2" FLOAT,
  "ag_lnd_agri_zs" FLOAT,
  "ag_lnd_arbl_ha" FLOAT,
  "ag_lnd_arbl_ha_pc" FLOAT,
  "ag_lnd_arbl_zs" FLOAT,
  "ag_lnd_crel_ha" UINTEGER,
  "ag_lnd_crop_zs" FLOAT,
  "ag_lnd_el5m_ru_k2" FLOAT,
  "ag_lnd_el5m_ru_zs" FLOAT,
  "ag_lnd_el5m_ur_k2" FLOAT,
  "ag_lnd_el5m_ur_zs" FLOAT,
  "ag_lnd_el5m_zs" FLOAT,
  "ag_lnd_frst_k2" FLOAT,
  "ag_lnd_frst_zs" FLOAT,
  "ag_lnd_irig_ag_zs" FLOAT,
  "ag_lnd_prcp_mm" FLOAT,
  "ag_lnd_totl_k2" FLOAT,
  "ag_lnd_totl_ru_k2" FLOAT,
  "ag_lnd_totl_ur_k2" FLOAT,
  "ag_lnd_trac_zs" FLOAT,
  "ag_prd_crel_mt" UINTEGER,
  "ag_prd_crop_xd" FLOAT,
  "ag_prd_food_xd" FLOAT,
  "ag_prd_lvsk_xd" FLOAT,
  "ag_srf_totl_k2" FLOAT,
  "ag_yld_crel_kg" FLOAT,
  "bg_gsr_nfsv_gd_zs" FLOAT,
  "bm_gsr_cmcp_zs" FLOAT,
  "bm_gsr_fcty_cd" FLOAT,
  "bm_gsr_gnfs_cd" FLOAT,
  "bm_gsr_insf_zs" FLOAT,
  "bm_gsr_mrch_cd" FLOAT,
  "bm_gsr_nfsv_cd" FLOAT,
  "bm_gsr_royl_cd" FLOAT,
  "bm_gsr_totl_cd" FLOAT,
  "bm_gsr_tran_zs" FLOAT,
  "bm_gsr_trvl_zs" FLOAT,
  "bm_klt_dinv_cd_wd" FLOAT,
  "bm_klt_dinv_wd_gd_zs" FLOAT,
  "bm_trf_prvt_cd" FLOAT,
  "bm_trf_pwkr_cd_dt" FLOAT,
  "bn_cab_xoka_cd" FLOAT,
  "bn_cab_xoka_gd_zs" FLOAT,
  "bn_fin_totl_cd" FLOAT,
  "bn_gsr_fcty_cd" FLOAT,
  "bn_gsr_gnfs_cd" FLOAT,
  "bn_gsr_mrch_cd" FLOAT,
  "bn_kac_eoms_cd" FLOAT,
  "bn_klt_dinv_cd" FLOAT,
  "bn_klt_ptxl_cd" FLOAT,
  "bn_res_incl_cd" FLOAT,
  "bn_trf_curr_cd" FLOAT,
  "bn_trf_kogt_cd" FLOAT,
  "bx_grt_exta_cd_wd" FLOAT,
  "bx_grt_tech_cd_wd" INTEGER,
  "bx_gsr_ccis_cd" FLOAT,
  "bx_gsr_ccis_zs" FLOAT,
  "bx_gsr_cmcp_zs" FLOAT,
  "bx_gsr_fcty_cd" FLOAT,
  "bx_gsr_gnfs_cd" FLOAT,
  "bx_gsr_insf_zs" FLOAT,
  "bx_gsr_mrch_cd" FLOAT,
  "bx_gsr_nfsv_cd" FLOAT,
  "bx_gsr_royl_cd" FLOAT,
  "bx_gsr_totl_cd" FLOAT,
  "bx_gsr_tran_zs" FLOAT,
  "bx_gsr_trvl_zs" FLOAT,
  "bx_klt_dinv_cd_wd" FLOAT,
  "bx_klt_dinv_wd_gd_zs" FLOAT,
  "bx_pef_totl_cd_wd" FLOAT,
  "bx_trf_curr_cd" FLOAT,
  "bx_trf_pwkr_cd" FLOAT,
  "bx_trf_pwkr_cd_dt" FLOAT,
  "bx_trf_pwkr_dt_gd_zs" FLOAT,
  "cm_mkt_indx_zg" FLOAT,
  "cm_mkt_lcap_cd" FLOAT,
  "cm_mkt_lcap_gd_zs" FLOAT,
  "cm_mkt_ldom_no" INTEGER,
  "cm_mkt_trad_cd" FLOAT,
  "cm_mkt_trad_gd_zs" FLOAT,
  "cm_mkt_trnr" FLOAT,
  "dc_dac_ausl_cd" FLOAT,
  "dc_dac_autl_cd" FLOAT,
  "dc_dac_bell_cd" FLOAT,
  "dc_dac_canl_cd" FLOAT,
  "dc_dac_cecl_cd" FLOAT,
  "dc_dac_chel_cd" FLOAT,
  "dc_dac_czel_cd" FLOAT,
  "dc_dac_deul_cd" FLOAT,
  "dc_dac_dnkl_cd" FLOAT,
  "dc_dac_espl_cd" FLOAT,
  "dc_dac_finl_cd" FLOAT,
  "dc_dac_fral_cd" FLOAT,
  "dc_dac_gbrl_cd" FLOAT,
  "dc_dac_grcl_cd" FLOAT
);

Wdi 3

@owid.wdi.owid_wdi_3

38.72 MB
14948 rows
1496 columns


CREATE TABLE owid_wdi_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "ag_agr_trac_no" FLOAT,
  "ag_con_fert_pt_zs" FLOAT,
  "ag_con_fert_zs" FLOAT,
  "ag_lnd_agri_k2" FLOAT,
  "ag_lnd_agri_zs" FLOAT,
  "ag_lnd_arbl_ha" FLOAT,
  "ag_lnd_arbl_ha_pc" FLOAT,
  "ag_lnd_arbl_zs" FLOAT,
  "ag_lnd_crel_ha" UINTEGER,
  "ag_lnd_crop_zs" FLOAT,
  "ag_lnd_el5m_ru_k2" FLOAT,
  "ag_lnd_el5m_ru_zs" FLOAT,
  "ag_lnd_el5m_ur_k2" FLOAT,
  "ag_lnd_el5m_ur_zs" FLOAT,
  "ag_lnd_el5m_zs" FLOAT,
  "ag_lnd_frst_k2" FLOAT,
  "ag_lnd_frst_zs" FLOAT,
  "ag_lnd_irig_ag_zs" FLOAT,
  "ag_lnd_prcp_mm" FLOAT,
  "ag_lnd_totl_k2" FLOAT,
  "ag_lnd_totl_ru_k2" FLOAT,
  "ag_lnd_totl_ur_k2" FLOAT,
  "ag_lnd_trac_zs" FLOAT,
  "ag_prd_crel_mt" FLOAT,
  "ag_prd_crop_xd" FLOAT,
  "ag_prd_food_xd" FLOAT,
  "ag_prd_lvsk_xd" FLOAT,
  "ag_srf_totl_k2" FLOAT,
  "ag_yld_crel_kg" FLOAT,
  "bg_gsr_nfsv_gd_zs" FLOAT,
  "bm_gsr_cmcp_zs" FLOAT,
  "bm_gsr_fcty_cd" FLOAT,
  "bm_gsr_gnfs_cd" BIGINT,
  "bm_gsr_insf_zs" FLOAT,
  "bm_gsr_mrch_cd" BIGINT,
  "bm_gsr_nfsv_cd" BIGINT,
  "bm_gsr_royl_cd" FLOAT,
  "bm_gsr_totl_cd" BIGINT,
  "bm_gsr_tran_zs" FLOAT,
  "bm_gsr_trvl_zs" FLOAT,
  "bm_klt_dinv_cd_wd" FLOAT,
  "bm_klt_dinv_wd_gd_zs" FLOAT,
  "bm_trf_prvt_cd" FLOAT,
  "bn_cab_xoka_cd" BIGINT,
  "bn_cab_xoka_gd_zs" FLOAT,
  "bn_fin_totl_cd" FLOAT,
  "bn_gsr_fcty_cd" FLOAT,
  "bn_gsr_gnfs_cd" FLOAT,
  "bn_gsr_mrch_cd" BIGINT,
  "bn_kac_eoms_cd" FLOAT,
  "bn_klt_dinv_cd" FLOAT,
  "bn_klt_ptxl_cd" FLOAT,
  "bn_res_incl_cd" FLOAT,
  "bn_trf_curr_cd" FLOAT,
  "bn_trf_kogt_cd" FLOAT,
  "bx_grt_exta_cd_wd" FLOAT,
  "bx_grt_tech_cd_wd" INTEGER,
  "bx_gsr_ccis_cd" FLOAT,
  "bx_gsr_ccis_zs" FLOAT,
  "bx_gsr_cmcp_zs" FLOAT,
  "bx_gsr_fcty_cd" FLOAT,
  "bx_gsr_gnfs_cd" BIGINT,
  "bx_gsr_insf_zs" FLOAT,
  "bx_gsr_mrch_cd" BIGINT,
  "bx_gsr_nfsv_cd" BIGINT,
  "bx_gsr_royl_cd" FLOAT,
  "bx_gsr_totl_cd" BIGINT,
  "bx_gsr_tran_zs" FLOAT,
  "bx_gsr_trvl_zs" FLOAT,
  "bx_klt_dinv_cd_wd" FLOAT,
  "bx_klt_dinv_wd_gd_zs" FLOAT,
  "bx_pef_totl_cd_wd" FLOAT,
  "bx_trf_curr_cd" BIGINT,
  "bx_trf_pwkr_cd" FLOAT,
  "bx_trf_pwkr_dt_gd_zs" FLOAT,
  "cc_est" FLOAT,
  "cc_no_src" INTEGER,
  "cc_per_rnk" FLOAT,
  "cc_per_rnk_lower" FLOAT,
  "cc_per_rnk_upper" FLOAT,
  "cc_std_err" FLOAT,
  "cm_mkt_indx_zg" FLOAT,
  "cm_mkt_lcap_cd" BIGINT,
  "cm_mkt_lcap_gd_zs" FLOAT,
  "cm_mkt_ldom_no" INTEGER,
  "cm_mkt_trad_cd" BIGINT,
  "cm_mkt_trad_gd_zs" FLOAT,
  "cm_mkt_trnr" FLOAT,
  "dc_dac_ausl_cd" FLOAT,
  "dc_dac_autl_cd" FLOAT,
  "dc_dac_bell_cd" FLOAT,
  "dc_dac_canl_cd" FLOAT,
  "dc_dac_cecl_cd" FLOAT,
  "dc_dac_chel_cd" FLOAT,
  "dc_dac_czel_cd" FLOAT,
  "dc_dac_deul_cd" FLOAT,
  "dc_dac_dnkl_cd" FLOAT,
  "dc_dac_espl_cd" FLOAT
);

Wdi 4

@owid.wdi.owid_wdi_4

40.3 MB
15187 rows
1514 columns


CREATE TABLE owid_wdi_4 (
  "country" VARCHAR,
  "year" INTEGER,
  "ag_con_fert_pt_zs" FLOAT,
  "ag_con_fert_zs" FLOAT,
  "ag_lnd_agri_k2" FLOAT,
  "ag_lnd_agri_zs" FLOAT,
  "ag_lnd_arbl_ha" FLOAT,
  "ag_lnd_arbl_ha_pc" FLOAT,
  "ag_lnd_arbl_zs" FLOAT,
  "ag_lnd_crel_ha" UINTEGER,
  "ag_lnd_crop_zs" FLOAT,
  "ag_lnd_el5m_ru_k2" FLOAT,
  "ag_lnd_el5m_ru_zs" FLOAT,
  "ag_lnd_el5m_ur_k2" FLOAT,
  "ag_lnd_el5m_ur_zs" FLOAT,
  "ag_lnd_el5m_zs" FLOAT,
  "ag_lnd_frst_k2" FLOAT,
  "ag_lnd_frst_zs" FLOAT,
  "ag_lnd_irig_ag_zs" FLOAT,
  "ag_lnd_prcp_mm" FLOAT,
  "ag_lnd_totl_k2" FLOAT,
  "ag_lnd_totl_ru_k2" FLOAT,
  "ag_lnd_totl_ur_k2" FLOAT,
  "ag_prd_crel_mt" FLOAT,
  "ag_prd_crop_xd" FLOAT,
  "ag_prd_food_xd" FLOAT,
  "ag_prd_lvsk_xd" FLOAT,
  "ag_srf_totl_k2" FLOAT,
  "ag_yld_crel_kg" FLOAT,
  "bg_gsr_nfsv_gd_zs" FLOAT,
  "bm_gsr_cmcp_zs" FLOAT,
  "bm_gsr_fcty_cd" FLOAT,
  "bm_gsr_gnfs_cd" BIGINT,
  "bm_gsr_insf_zs" FLOAT,
  "bm_gsr_mrch_cd" BIGINT,
  "bm_gsr_nfsv_cd" BIGINT,
  "bm_gsr_royl_cd" FLOAT,
  "bm_gsr_totl_cd" BIGINT,
  "bm_gsr_tran_zs" FLOAT,
  "bm_gsr_trvl_zs" FLOAT,
  "bm_klt_dinv_cd_wd" FLOAT,
  "bm_klt_dinv_wd_gd_zs" FLOAT,
  "bm_trf_prvt_cd" FLOAT,
  "bn_cab_xoka_cd" BIGINT,
  "bn_cab_xoka_gd_zs" FLOAT,
  "bn_fin_totl_cd" FLOAT,
  "bn_gsr_fcty_cd" FLOAT,
  "bn_gsr_gnfs_cd" FLOAT,
  "bn_gsr_mrch_cd" BIGINT,
  "bn_kac_eoms_cd" FLOAT,
  "bn_klt_dinv_cd" FLOAT,
  "bn_klt_ptxl_cd" FLOAT,
  "bn_res_incl_cd" FLOAT,
  "bn_trf_curr_cd" FLOAT,
  "bn_trf_kogt_cd" FLOAT,
  "bx_grt_exta_cd_wd" FLOAT,
  "bx_grt_tech_cd_wd" INTEGER,
  "bx_gsr_ccis_cd" FLOAT,
  "bx_gsr_ccis_zs" FLOAT,
  "bx_gsr_cmcp_zs" FLOAT,
  "bx_gsr_fcty_cd" FLOAT,
  "bx_gsr_gnfs_cd" BIGINT,
  "bx_gsr_insf_zs" FLOAT,
  "bx_gsr_mrch_cd" BIGINT,
  "bx_gsr_nfsv_cd" BIGINT,
  "bx_gsr_royl_cd" FLOAT,
  "bx_gsr_totl_cd" BIGINT,
  "bx_gsr_tran_zs" FLOAT,
  "bx_gsr_trvl_zs" FLOAT,
  "bx_klt_dinv_cd_wd" FLOAT,
  "bx_klt_dinv_wd_gd_zs" FLOAT,
  "bx_pef_totl_cd_wd" FLOAT,
  "bx_trf_curr_cd" BIGINT,
  "bx_trf_pwkr_cd" FLOAT,
  "bx_trf_pwkr_dt_gd_zs" FLOAT,
  "cc_est" FLOAT,
  "cc_no_src" INTEGER,
  "cc_per_rnk" FLOAT,
  "cc_per_rnk_lower" FLOAT,
  "cc_per_rnk_upper" FLOAT,
  "cc_std_err" FLOAT,
  "cm_mkt_indx_zg" FLOAT,
  "cm_mkt_lcap_cd" BIGINT,
  "cm_mkt_lcap_gd_zs" FLOAT,
  "cm_mkt_ldom_no" INTEGER,
  "cm_mkt_trad_cd" BIGINT,
  "cm_mkt_trad_gd_zs" FLOAT,
  "cm_mkt_trnr" FLOAT,
  "dc_dac_ausl_cd" FLOAT,
  "dc_dac_autl_cd" FLOAT,
  "dc_dac_bell_cd" FLOAT,
  "dc_dac_canl_cd" FLOAT,
  "dc_dac_cecl_cd" FLOAT,
  "dc_dac_chel_cd" FLOAT,
  "dc_dac_czel_cd" FLOAT,
  "dc_dac_deul_cd" FLOAT,
  "dc_dac_dnkl_cd" FLOAT,
  "dc_dac_espl_cd" FLOAT,
  "dc_dac_estl_cd" FLOAT,
  "dc_dac_finl_cd" FLOAT
);