Selected Indicators From World Bank 2000-2021

34 indicators extracted on 2022-09-16 from World Bank website for a data project

@kaggle.robertolofaro_selected_indicators_from_world_bank_20002019

Table List

3 tables(1011.05 KB)

Dimension Country

Dimension Indicator

Facttable

Facttable

@kaggle.robertolofaro_selected_indicators_from_world_bank_20002019.facttable

1000.15 KB
8778 rows
24 columns

country_code Country Code	indicator_code Indicator Code	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021
AFE	IC.BUS.DISC.XQ						3.73076923076923	3.73076923076923	3.73076923076923	3.69230769230769	3.88461538461538	3.96153846153846	4.11538461538461	4.23076923076923	4.34615384615385	4.42307692307692	4.53846153846154	4.69230769230769	4.73076923076923	4.88461538461539	4.88461538461539
AFE	IC.CRD.INFO.XQ														2.24	2.4	3.26923076923077	3.76923076923077	4.34615384615385	4.42307692307692	4.5
AFE	FS.AST.PRVT.GD.ZS	74.9798926334367	77.003129903379	62.4323760940614	71.3264320378861	80.2680451825998	85.8218538750853	94.9900024483043	94.000221084471	78.933470597269	79.2523391574289	83.9710842872006	74.9991903798794	77.6088952531296	74.1793650265943	72.3963335345263	65.1573833730418	62.9076859094223	64.2460091566748	65.2906392746222	63.5623356317428	59.7442246489629
AFE	EG.USE.ELEC.KH.PC	780.702623963529	743.916043970902	769.080854071567	774.334166181245	777.672090685718	780.851052287502	789.4878404605	796.901935655247	760.576897141733	723.914903111308	740.41765510513	740.741605692739	703.908400908733	698.369914215573	686.728057221492
AFE	EG.IMP.CONS.ZS	-31.3910700728529	-29.1363228434745	-32.9108840507047	-32.4199943225502	-31.1618160686318	-35.9394233025396	-38.8057893242221	-41.694275482213	-40.0256390924859	-38.314270953454	-38.2841587171351	-34.6227253100243	-32.2449915534232	-32.0350067306814	-31.655426118373
AFE	GC.XPN.TOTL.GD.ZS										23.8061028233452	23.7645935793812	25.5168157767111	23.4576651473495	25.1288989538157	25.0669411872412	23.9900899375585	22.9082061458793	25.4221665859869	24.3648782292967	25.8129971718337
AFE	IT.NET.BBND.P2						0.0614095389959254	0.112406495100231	0.13373192572462	0.145390609718297	0.180793682039157	0.197978030949248	0.29452635438881	0.354239756744278	0.457200827987643	0.540377819686139	0.519799225324479	0.513050810283371	0.544641692243999	0.696897405090322	0.624076020364447	0.740055765011962
AFE	IT.MLT.MAIN.P2	1.86083099700546	1.85969653647599	1.90194895663987	1.95503039675373	1.94836803570107	1.84286296867743	1.82409047935348	1.83943093056176	1.83353795293262	1.87254302242918	1.8238498433724	1.72880284917891	1.6338098384664	1.3593769622377	1.31235636413336	1.29483888044159	1.36399966410494	1.34524529936693	1.00473788649705	0.818892491274359	0.803164021137798
AFE	NY.GDP.MKTP.KD.ZG	3.35077349562722	3.6587012149089	3.89337907673297	3.08037602693415	5.50835541325966	6.11680122972891	6.55488087371307	6.60428224821325	4.34345645134013	0.761219025383781	5.15212534897287	3.68087046123608	0.92306718208026	4.20020884185426	3.98438686117323	2.95284538392468	2.21701650452242	2.55713519352429	2.48524422522907	2.0259406786066	-2.88685564830078	4.30366702056686
AFE	SI.POV.GINI


CREATE TABLE facttable (
  "country_code" VARCHAR,
  "indicator_code" VARCHAR,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE
);