/***************************************************************************

	PROJECT: 			ERC VIET NAM ANALYSIS
						ADDS CLUSTER-LEVEL POVERTY INDICATORS
	AUTHOR:				NICOLA FOSTER
	LAST UPDATED:		31 JANUARY 2022

***************************************************************************/

gen province = provinceA
replace province = provinceB if province==""

* STUDY TIME PERIODS 2007 AND 2017
* WORLD BANK POVERTY HEADCOUNT 2009
gen poverty_2009 = . 
lab var poverty_2009 "Poverty: GSO-WB poverty headcount (%)"

	replace poverty_2009 =	5 if province == "Ha Noi"
	replace poverty_2009 =71 if province ==	"Ha Giang"
	replace poverty_2009 =53 if province ==	"Cao Bang"
	replace poverty_2009 =46 if province ==	"Bac Kan"
	replace poverty_2009 =40 if province ==	"Tuyen Quang"
	replace poverty_2009 =57 if province ==	"Lao Cai"
	replace poverty_2009 =71 if province ==	"Dien Bien"
	replace poverty_2009 =76 if province ==	"Lai Chau"
	replace poverty_2009 =64 if province ==	"Son La"
	replace poverty_2009 =45 if province ==	"Yen Bai"
	replace poverty_2009 =47 if province ==	"Hoa Binh"
	replace poverty_2009 =22 if province ==	"Thai Nguyen"
	replace poverty_2009 =46 if province ==	"Lang Son"
	replace poverty_2009 =12 if province ==	"Quang Ninh"
	replace poverty_2009 =24 if province ==	"Bac Giang"
	replace poverty_2009 =24 if province ==	"Phu Tho"
	replace poverty_2009 =12 if province ==	"Vinh Phuc"
	replace poverty_2009 =10 if province ==	"Bac Ninh"
	replace poverty_2009 =15 if province ==	"Hai Duong"
	replace poverty_2009 =8 if province ==	"Hai Phong city"
	replace poverty_2009 =13 if province ==	"Hung Yen"
	replace poverty_2009 =19 if province ==	"Thai Binh"
	replace poverty_2009 =17 if province ==	"Ha Nam"
	replace poverty_2009 =14 if province ==	"Nam Dinh"
	replace poverty_2009 =. if province ==	"Ninh Binh"
	replace poverty_2009 =26 if province ==	"Thanh Hoa"
	replace poverty_2009 =27 if province ==	"Nghe An"
	replace poverty_2009 =22 if province ==	"Ha Tinh"
	replace poverty_2009 =23 if province ==	"Quang Binh"
	replace poverty_2009 =30 if province ==	"Quang Tri"
	replace poverty_2009 =19 if province ==	"Thua Thien Hue"
	replace poverty_2009 =2	if province == "Da Nang city"
	replace poverty_2009 =23 if province ==	"Quang Nam"
	replace poverty_2009 =24 if province ==	"Quang Ngai"
	replace poverty_2009 =17 if province ==	"Binh Dinh"
	replace poverty_2009 =22 if province ==	"Phu Yen"
	replace poverty_2009 =16 if province ==	"Khanh Hoa"
	replace poverty_2009 =35 if province ==	"Ninh Thuan"
	replace poverty_2009 =21 if province ==	"Binh Thuan"
	replace poverty_2009 =48 if province ==	"Kon Tum"
	replace poverty_2009 =43 if province ==	"Gia Lai"
	replace poverty_2009 =30 if province ==	"Dak Lak"
	replace poverty_2009 =32 if province ==	"Dak Nong"
	replace poverty_2009 =22 if province ==	"Lam Dong"
	replace poverty_2009 =17 if province ==	"Binh Phuoc"
	replace poverty_2009 =12 if province ==	"Tay Ninh"
	replace poverty_2009 =8 if province ==	"Binh Duong"
	replace poverty_2009 =12 if province ==	"Dong Nai"
	replace poverty_2009 =10 if province ==	"Ba Ria - Vung Tau"
	replace poverty_2009 =3	if province == "Ho Chi Minh city"
	replace poverty_2009 =11 if province ==	"Long An"
	replace poverty_2009 =10 if province ==	"Tien Giang"
	replace poverty_2009 =10 if province ==	"Ben Tre"
	replace poverty_2009 =22 if province ==	"Tra Vinh"
	replace poverty_2009 =12 if province ==	"Vinh Long"
	replace poverty_2009 =16 if province ==	"Dong Thap"
	replace poverty_2009 =18 if province ==	"An Giang"
	replace poverty_2009 =24 if province ==	"Kien Giang"
	replace poverty_2009 =12 if province ==	"Can Tho city"
	replace poverty_2009 =20 if province ==	"Hau Giang"
	replace poverty_2009 =27 if province ==	"Soc Trang"
	replace poverty_2009 =23 if province ==	"Bac Lieu"
	replace poverty_2009 =26 if province ==	"Ca Mau"

	
	
*******************************************************************************
gen poverty_2013 = .
lab var poverty_2013 "MOLISA income-based poverty rate"

	replace poverty_2013 = 1.01 if province == "Ha Noi"
	replace poverty_2013 = 26.95	if province =="Ha Giang"
	replace poverty_2013 = 24.2	if province =="Cao Bang"
	replace poverty_2013 = 18.55 if province ==	"Bac Kan"
	replace poverty_2013 = 17.93	if province =="Tuyen Quang"
	replace poverty_2013 =22.21	if province =="Lao Cai"
	replace poverty_2013 =35.22	if province =="Dien Bien"
	replace poverty_2013 =27.22	if province =="Lai Chau"
	replace poverty_2013 =27.01	if province =="Son La"
	replace poverty_2013 =25.38	if province =="Yen Bai"
	replace poverty_2013 =18.7	if province =="Hoa Binh"
	replace poverty_2013 =11.61	if province =="Thai Nguyen"
	replace poverty_2013 =18	if province =="Lang Son"
	replace poverty_2013 =2.42	if province =="Quang Ninh"
	replace poverty_2013 =10.44	if province =="Bac Giang"
	replace poverty_2013 =12.52 if province =="Phu Tho"
	replace poverty_2013 =4.93	if province =="Vinh Phuc"
	replace poverty_2013 =3.42	if province =="Bac Ninh"
	replace poverty_2013 =5.82	if province =="Hai Duong"
	replace poverty_2013 =3.23	if province =="Hai Phong city"
	replace poverty_2013 =5.1	if province =="Hung Yen"
	replace poverty_2013 =4.55	if province =="Thai Binh"
	replace poverty_2013 =6.28	if province == "Ha Nam"
	replace poverty_2013 =5.33	if province == "Nam Dinh"
	replace poverty_2013 =5.44	if province =="Ninh Binh"
	replace poverty_2013 =13.13	if province =="Thanh Hoa"
	replace poverty_2013 =13.42	if province =="Nghe An"
	replace poverty_2013 =10.69	if province =="Ha Tinh"
	replace poverty_2013 =14.18	if province =="Quang Binh"
	replace poverty_2013 =11.77	if province =="Quang Tri"
	replace poverty_2013 =6.42	if province =="Thua Thien Hue"
	replace poverty_2013 =0.77	if province =="Da Nang city"
	replace poverty_2013 =14.91	if province =="Quang Nam"
	replace poverty_2013 =14.93	if province =="Quang Ngai"
	replace poverty_2013 =9.85	if province =="Binh Dinh"
	replace poverty_2013 =13.03 if province =="Phu Yen"
	replace poverty_2013 =4.26	if province =="Khanh Hoa"
	replace poverty_2013 =9.34	if province =="Ninh Thuan"
	replace poverty_2013 =4.88	if province =="Binh Thuan"
	replace poverty_2013 =19.2	if province =="Kon Tum"
	replace poverty_2013 =17.23	if province =="Gia Lai"
	replace poverty_2013 =12.26	if province =="Dak Lak"
	replace poverty_2013 =15.64	if province =="Dak Nong"
	replace poverty_2013 =4.13	if province =="Lam Dong"
	replace poverty_2013 =4.5	if province =="Binh Phuoc"
	replace poverty_2013 =1.67	if province =="Tay Ninh"
	replace poverty_2013 =0	if province =="Binh Duong"
	replace poverty_2013 =0.66	if province =="Dong Nai"
	replace poverty_2013 =0.95	if province =="Ba Ria - Vung Tau"
	replace poverty_2013 =0	if province =="Ho Chi Minh city"
	replace poverty_2013 =3.81 if province ==	"Long An"
	replace poverty_2013 =6.33	if province =="Tien Giang"
	replace poverty_2013 =8.59	if province =="Ben Tre"
	replace poverty_2013 =13.96	if province =="Tra Vinh"
	replace poverty_2013 =4.57	if province =="Vinh Long"
	replace poverty_2013 =7.48	if province =="Dong Thap"
	replace poverty_2013 =4.96	if province =="An Giang"
	replace poverty_2013 =4.73	if province =="Kien Giang"
	replace poverty_2013 =3.95	if province =="Can Tho city"
	replace poverty_2013 =11.58	if province =="Hau Giang"
	replace poverty_2013 =16.99	if province =="Soc Trang"
	replace poverty_2013 =9.39	if province =="Bac Lieu"
	replace poverty_2013 =6.49	if province =="Ca Mau"

	
*******************************************************************************
gen poverty_line = .
lab var poverty_line "percentage of population living under $2 per day"


replace poverty_line=2.93 if province=="Ha Noi"
replace poverty_line=64.76	if province=="Ha Giang"
replace poverty_line=45.38	if province=="Cao Bang"
replace poverty_line=36.92	if province=="Bac Kan"
replace poverty_line=31.44	if province=="Tuyen Quang"
replace poverty_line=50.06	if province=="Lao Cai"
replace poverty_line=65.13	if province=="Dien Bien"
replace poverty_line=70.63	if province=="Lai Chau"
replace poverty_line=55.7	if province=="Son La"
replace poverty_line=37.51	if province=="Yen Bai"
replace poverty_line=38.92	if province=="Hoa Binh"
replace poverty_line=15.39	if province=="Thai Nguyen"
replace poverty_line=36.83	if province=="Lang Son"
replace poverty_line=8.43	if province=="Quang Ninh"
replace poverty_line=16.66	if province=="Bac Giang"
replace poverty_line=16.86	if province=="Phu Tho"
replace poverty_line=7.38	if province=="Vinh Phuc"
replace poverty_line=6.23	if province=="Bac Ninh"
replace poverty_line=9.44	if province=="Hai Duong"
replace poverty_line=4.8	if province=="Hai Phong city"
replace poverty_line=7.97	if province=="Hung Yen"
replace poverty_line=12.31	if province=="Thai Binh"
replace poverty_line=10.52	if province=="Ha Nam"
replace poverty_line=8.65	if province=="Nam Dinh"
replace poverty_line=9.74	if province=="Ninh Binh"
replace poverty_line=18.79	if province=="Thanh Hoa"
replace poverty_line=19.23	if province=="Nghe An"
replace poverty_line=13.84	if province=="Ha Tinh"
replace poverty_line=15.98	if province=="Quang Binh"
replace poverty_line=22.5	if province=="Quang Tri"
replace poverty_line=13.11	if province=="Thua Thien Hue"
replace poverty_line=1.19	if province=="Da Nang city"
replace poverty_line=16.4	if province=="Quang Nam"
replace poverty_line=17.08	if province=="Quang Ngai"
replace poverty_line=10.51	if province=="Binh Dinh"
replace poverty_line=14.93	if province=="Phu Yen"
replace poverty_line=10.88	if province=="Khanh Hoa"
replace poverty_line=26.65	if province=="Ninh Thuan"
replace poverty_line=14.7	if province=="Binh Thuan"
replace poverty_line=42.59	if province=="Kon Tum"
replace poverty_line=37.57	if province=="Gia Lai"
replace poverty_line=24.29	if province=="Dak Lak"
replace poverty_line=25.8	if province=="Dak Nong"
replace poverty_line=16.88	if province=="Lam Dong"
replace poverty_line=11.32	if province=="Binh Phuoc"
replace poverty_line=7.08	if province=="Tay Ninh"
replace poverty_line=4.67	if province=="Binh Duong"
replace poverty_line=7.52	if province=="Dong Nai"
replace poverty_line=6.33	if province=="Ba Ria - Vung Tau"
replace poverty_line=1.82	if province=="Ho Chi Minh city"
replace poverty_line=6.64	if province=="Long An"
replace poverty_line=5.53	if province=="Tien Giang"
replace poverty_line=5.82	if province=="Ben Tre"
replace poverty_line=15.52	if province=="Tra Vinh"
replace poverty_line=7.2	if province=="Vinh Long"
replace poverty_line=9.48	if province=="Dong Thap"
replace poverty_line=11.74	if province=="An Giang"
replace poverty_line=16.77	if province=="Kien Giang"
replace poverty_line=7.24	if province=="Can Tho city"
replace poverty_line=12.94	if province=="Hau Giang"
replace poverty_line=19.6	if province=="Soc Trang"
replace poverty_line=15.59	if province=="Bac Lieu"
replace poverty_line=18.47	if province=="Ca Mau"