Multidimensional Poverty Measures

Harmonized Dataset for Comparisons Over Time

@kaggle.mitchellreynolds_multidimensional_poverty_measures

Table List

1 table(78.69 KB)

Subnational Mpi Across Time

@kaggle.mitchellreynolds_multidimensional_poverty_measures.subnational_mpi_across_time

78.69 KB
515 rows
21 columns

unnamed_0 Unnamed: 0	country Country	region Region	year1 Year1	year2 Year2	mpi_year1 Mpi Year1	mpi_year2 Mpi Year2	mpi_annualized_change Mpi Annualized Change	headcount_ratio_year1 Headcount Ratio Year1	headcount_ratio_year2 Headcount Ratio Year2	headcount_ratio_annualized_change Headcount Ratio Annualized Change	poverty_intensity_year1 Poverty Intensity Year1	poverty_intensity_year2 Poverty Intensity Year2	poverty_intensity_annualized_change Poverty Intensity Annualized Change	mpi_stat_sig Mpi Stat Sig	headcount_ratio_stat_sig Headcount Ratio Stat Sig	poverty_intensity_stat_sig Poverty Intensity Stat Sig	total_population_year1 Total Population Year1	total_population_year2 Total Population Year2	nb_poor_year1 Nb Poor Year1	nb_poor_year2 Nb Poor Year2
	Bangladesh	Barisal	2004	2007	0.394052535295	0.328580826521	-0.0218239035457	70.6922531128	63.4114086628	-2.42694830894	55.7419657707	51.817303896	-1.30822062492	**	*	**	8866114	9225110	6267655	5849772
1	Bangladesh	Chittagong	2004	2007	0.377330154181	0.314115524292	-0.0210715439171	67.5894975662	60.7776641846	-2.27061128616	55.826741457	51.6827225685	-1.38133955002	**	*	***	27390076	29085980	18512814	17677779
2	Bangladesh	Dhaka	2004	2007	0.347243636847	0.301106899977	-0.0153789119795	64.7745192051	56.8391978741	-2.64510726929	53.6080598831	52.9752194881	-0.210946798325	**	**	nan	44005511	44833500	28504359	25483001
3	Bangladesh	Khulna	2004	2007	0.301796168089	0.260602623224	-0.0137311816216	59.5467031002	53.8750112057	-1.89056396484	50.682258606	48.3717113733	-0.77018237114	**	*	**	16668423	17546048	9925497	9452935
4	Bangladesh	Rajshahi	2004	2007	0.373827308416	0.292320132256	-0.0271690580994	70.3195154667	58.3956182003	-3.9746325016	53.1612455845	50.0585794449	-1.03422212601	***	***	***	34059859	34672742	23950728	20247362
5	Bangladesh	Sylhet	2004	2007	0.445901364088	0.396526128054	-0.0164584126323	74.5971977711	70.0264692307	-1.52357625961	59.7745478153	56.6251754761	-1.04979085922	nan	nan	**	10245059	11093686	7642527	7768516
6	Bangladesh	Barisal	2007	2011	0.328580826521	0.272092014551	-0.0141222029924	63.4114086628	55.5073261261	-1.97602057457	51.817303896	49.019113183	-0.69954764843	**	**	**	9225110	8827626	5849772	4899979
7	Bangladesh	Chittagong	2007	2011	0.314115524292	0.252499938011	-0.0154038965702	60.7776641846	50.6713330746	-2.5265827179	51.6827225685	49.8309224844	-0.462950021029	**	***	nan	29085980	29821949	17677779	15111179
8	Bangladesh	Dhaka	2007	2011	0.301106899977	0.234257102013	-0.016712449491	56.8391978741	46.2099015713	-2.6573240757	52.9752194881	50.6941318512	-0.570271909237	***	***	**	44833500	48337472	25483000	22336698
9	Bangladesh	Khulna	2007	2011	0.260602623224	0.188760355115	-0.0179605670273	53.8750112057	42.1150177717	-2.93999838829	48.3717113733	44.8202013969	-0.887877464294	***	***	***	17546048	17148531	9452935	7222106


CREATE TABLE subnational_mpi_across_time (
  "unnamed_0" BIGINT,
  "country" VARCHAR,
  "region" VARCHAR,
  "year1" BIGINT,
  "year2" BIGINT,
  "mpi_year1" DOUBLE,
  "mpi_year2" DOUBLE,
  "mpi_annualized_change" DOUBLE,
  "headcount_ratio_year1" DOUBLE,
  "headcount_ratio_year2" DOUBLE,
  "headcount_ratio_annualized_change" DOUBLE,
  "poverty_intensity_year1" DOUBLE,
  "poverty_intensity_year2" DOUBLE,
  "poverty_intensity_annualized_change" DOUBLE,
  "mpi_stat_sig" VARCHAR,
  "headcount_ratio_stat_sig" VARCHAR,
  "poverty_intensity_stat_sig" VARCHAR,
  "total_population_year1" BIGINT,
  "total_population_year2" BIGINT,
  "nb_poor_year1" BIGINT,
  "nb_poor_year2" BIGINT
);