********************************************************************* ****************Paul Collier and Anke Hoeffler*********************** ***Testing the Neocon Agenda: Democracy in Resource-Rich Societies*** ****************European Economic Review, 2009*********************** ********************************************************************* *Table 1, summary statistics sum democ if natressample==1 sum democ if natressample==1 & natresshy>10 sum democ if natressample==1 & year==1970 sum democ if natressample==1 & natresshy>10 &year==1970 sum democ if natressample==1 & year==1974 sum democ if natressample==1 & natresshy>10 &year==1974 sum democ if natressample==1 & year==1978 sum democ if natressample==1 & natresshy>10 &year==1978 sum democ if natressample==1 & year==1982 sum democ if natressample==1 & natresshy>10 &year==1982 sum democ if natressample==1 & year==1986 sum democ if natressample==1 & natresshy>10 &year==1986 sum democ if natressample==1 & year==1990 sum democ if natressample==1 & natresshy>10 &year==1990 sum democ if natressample==1 & year==1994 sum democ if natressample==1 & natresshy>10 &year==1994 sum democ if natressample==1 & year==1998 sum democ if natressample==1 & natresshy>10 &year==1998 *Table 2, Growth, Democracy and Natural Resource Rents gen natresshydem=democ*natresshy gen checksnatres=checks*natresshy gen natresshy2=natresshy^2 gen demdum=. replace demdum=0 if democ<=5 replace demdum=1 if democ>5 gen natresshydemd=demdum*natresshy gen sample= growth+ lngdppc+ natresshy_1+ democ +natresshydem+ checksnatres+ easia_ +eca_+ mena_ +sa_ +ssa_+ td7+ td8+ td9+ td10+ td11+ td12 if natressample==1 tab obs, gen(c) reg growth lngdppc natresshy democ easia_ eca_ mena_ sa_ ssa_ td6 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg growth lngdppc natresshy democ natresshydem easia_ eca_ mena_ sa_ ssa_ td6 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg growth lngdppc natresshy natresshy2 democ natresshydem easia_ eca_ mena_ sa_ ssa_ td6 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg growth lngdppc natresshy natresshy_1 democ natresshydem easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if natressample==1, robust reg growth lngdppc natresshy_1 democ natresshydem easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if natressample==1, robust reg growth lngdppc natresshy_1 democ natresshydem checks checksnatres easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if natressample==1, robust reg growth lngdppc natresshy_1 democ natresshydem checksnatres easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if natressample==1, robust reg growth lngdppc natresshy_1 demdum natresshydemd checksnatres easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if sample~=., robust reg growth lngdppc natresshy_1 democ natresshydem checksnatres easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 c9 c11 c13 c30 c31 c34 c35 c52 c55 c58 c66 c68 c78 c82 c88 c90 c106 c107 c109 c113 c117 c124 c128 c130 c132 c135 c138 c139 c143 c154 c172 c179 c183 c190 c191 if natressample==1, robust reg growth lngdppc natresshy democ natresshydem checksnatres easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if natressample==1, robust *Table 3: Growth, Democracy and Natural Resource Rents - 2SLSQ reg democ lngdppc natresshy lnsmortality easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if natressample==1, robust predict residual, resid reg growth lngdppc natresshy democ natresshydem residual easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if natressample==1, robust drop residual * Table 4: Growth, Democracy and Scrutiny gen ethdem=ethnic*democ gen dem2natresshy=(democ^2)*natresshy reg growth lngdppc natresshy_1 democ natresshydem checksnatres easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if sample~=. & natressample==1, robust reg growth lngdppc natresshy_1 democ natresshydem checksnatres lninv easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if sample~=. & natressample==1, robust reg growth lngdppc natresshy_1 democ natresshydem checksnatres govcons easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if sample~=. & natressample==1, robust reg growth lngdppc natresshy_1 democ natresshydem checksnatres ethnic ethdem easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if sample~=. & natressample==1, robust reg growth lngdppc natresshy_1 democ natresshydem dem2natresshy checksnatres easia_ eca_ mena_ sa_ ssa_ td7 td8 td9 td10 td11 td12 if natressample==1, robust *Table 5: Checks, Democracy and Natural Resource Rents sort obs year by obs: gen lngdppc_1=lngdppc[_n-1] by obs: gen lngdppc_2=lngdppc[_n-2] by obs: gen lngdppc_3=lngdppc[_n-3] by obs: gen lngdppc_4=lngdppc[_n-4] by obs: gen lngdppc_5=lngdppc[_n-5] by obs: gen lngdppc_6=lngdppc[_n-6] by obs: gen lngdppc_7=lngdppc[_n-7] by obs: gen natresshy_2=natresshy[_n-2] by obs: gen natresshy_3=natresshy[_n-3] by obs: gen natresshy_4=natresshy[_n-4] by obs: gen natresshy_5=natresshy[_n-5] by obs: gen natresshy_6=natresshy[_n-6] by obs: gen natresshy_7=natresshy[_n-7] by obs: gen democ_1=democ[_n-1] by obs: gen democ_2=democ[_n-2] by obs: gen democ_3=democ[_n-3] by obs: gen democ_4=democ[_n-4] by obs: gen democ_5=democ[_n-5] by obs: gen democ_6=democ[_n-6] by obs: gen democ_7=democ[_n-7] gen deltademoc_1=democ-democ_1 gen deltademoc_2=democ-democ_2 gen deltademoc_3=democ-democ_3 gen deltademoc_4=democ-democ_4 gen deltademoc_5=democ-democ_5 gen deltademoc_6=democ-democ_6 gen deltademoc_7=democ-democ_7 by obs: gen checks_1=checks[_n-1] by obs: gen checks_2=checks[_n-2] by obs: gen checks_3=checks[_n-3] by obs: gen checks_4=checks[_n-4] by obs: gen checks_5=checks[_n-5] by obs: gen checks_6=checks[_n-6] gen deltachecks_1=checks-checks_1 gen deltachecks_2=checks-checks_2 gen deltachecks_3=checks-checks_3 gen deltachecks_4=checks-checks_4 gen deltachecks_5=checks-checks_5 gen deltachecks_6=checks-checks_6 *Block (A) reg checks lngdppc natresshy_1 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg checks lngdppc_1 natresshy_2 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg checks lngdppc_2 natresshy_3 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg checks lngdppc_3 natresshy_4 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg checks lngdppc_4 natresshy_5 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg checks lngdppc_5 natresshy_6 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg checks lngdppc_6 natresshy_7 td7 td8 td9 td10 td11 td12 if natressample==1, robust *Block (B) reg democ lngdppc natresshy_1 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg democ lngdppc_1 natresshy_2 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg democ lngdppc_2 natresshy_3 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg democ lngdppc_3 natresshy_4 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg democ lngdppc_4 natresshy_5 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg democ lngdppc_5 natresshy_6 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg democ lngdppc_6 natresshy_7 td7 td8 td9 td10 td11 td12 if natressample==1, robust *Block (C) reg deltachecks_1 lngdppc_1 checks_1 natresshy_1 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg deltachecks_2 lngdppc_2 checks_2 natresshy_2 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg deltachecks_3 lngdppc_3 checks_3 natresshy_3 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg deltachecks_4 lngdppc_4 checks_4 natresshy_4 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg deltachecks_5 lngdppc_5 checks_5 checks_5 natresshy_5 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg deltachecks_6 lngdppc_6 checks_6 natresshy_6 td7 td8 td9 td10 td11 td12 if natressample==1, robust *Block (D) reg deltademoc_1 lngdppc_1 democ_1 natresshy_1 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg deltademoc_2 lngdppc_2 democ_2 natresshy_2 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg deltademoc_3 lngdppc_3 democ_3 natresshy_3 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg deltademoc_4 lngdppc_4 democ_4 natresshy_4 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg deltademoc_5 lngdppc_5 democ_5 natresshy_5 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg deltademoc_6 lngdppc_6 democ_6 natresshy_6 td7 td8 td9 td10 td11 td12 if natressample==1, robust reg deltademoc_7 lngdppc_7 democ_7 natresshy_7 td7 td8 td9 td10 td11 td12 if natressample==1, robust *Appendix Tables sum growth lngdppc natresshy natresshy_1 democ checks ethnic lninv govcons if sample~=. cor growth lngdppc natresshy natresshy_1 democ checks ethnic lninv govcons if sample~=. sum checks if natressample==1, detail sum checks if natressample==1 & natresshy>10 sum checks if natressample==1 & year==1970 sum checks if natressample==1 & natresshy>10 &year==1970 sum checks if natressample==1 & year==1974 sum checks if natressample==1 & natresshy>10 &year==1974 sum checks if natressample==1 & year==1978 sum checks if natressample==1 & natresshy>10 &year==1978 sum checks if natressample==1 & year==1982 sum checks if natressample==1 & natresshy>10 &year==1982 sum checks if natressample==1 & year==1986 sum checks if natressample==1 & natresshy>10 &year==1986 sum checks if natressample==1 & year==1990 sum checks if natressample==1 & natresshy>10 &year==1990 sum checks if natressample==1 & year==1994 sum checks if natressample==1 & natresshy>10 &year==1994 sum checks if natressample==1 & year==1998 sum checks if natressample==1 & natresshy>10 &year==1998