log using "C:\Documents and Settings\Amanda Geller\My Documents\Ohio State Archive - Jeff\stata for archive\Table 1 models.log", replace

/* Table 1, Model 1 */


use "Mocan.dta", clear


tsset fips year, yearly

	

drop if expro~=0 & L6.sentc==0



regress cmurrat exprJLEl  amurtlag sentratl2 cust3lag deathrtl perblk repub unemp realinc mortal urban legal18 /*
*/ legal19 legal20 rat2034 rat3544 rat4554 rat55 state1-state50 time1-time20 trend1-trend51 ok95 [aweight=pop], robust




/* Table 1, Model 2 */


use "altsources.dta", clear

tsset fips year, yearly
drop if dpicexec~=0 & L6.sentences==0 


regress NCHSmurderrate exprJLEl  amurtlag sentratl2 cust3lag deathrtl perblk repub unemp realinc mortal urban legal18 /*
*/ legal19 legal20 rat2034 rat3544 rat4554 rat55 state1-state50 time1-time20 trend1-trend51 ok95 [aweight=total], robust

	


/* Table 1, Model 3 */

use "zero_to_01.dta", clear

drop if execpro_m~=0 & L6.ds_m==0 



regress murderrate_m exprJLEl  amurtlag sentratl2 cust3lag deathrtl perblk repub unemp realinc mortal urban legal18 /*
*/ legal19 legal20 rat2034 rat3544 rat4554 rat55 state1-state50 time1-time20 trend1-trend51 ok95 [aweight=pop], robust




/* Table 1, Model 4 */

use "Mocan.dta", clear
tsset fips year, yearly
drop if expro~=0 & L6.sentc==0 
drop if fips==48



regress cmurrat exprJLEl  amurtlag sentratl2 cust3lag deathrtl perblk repub unemp realinc mortal urban legal18 /*
*/ legal19 legal20 rat2034 rat3544 rat4554 rat55 state1-state50 time1-time20 trend1-trend51 ok95 [aweight=pop], robust



/* Table 1, Model 5 */

use "zero_to_01.dta", clear


drop if execpro_m~=0 & L6.ds_m==0 
drop if fips==48



regress murderrate_m exprJLEl  amurtlag sentratl2 cust3lag deathrtl perblk repub unemp realinc mortal urban legal18 /*
*/ legal19 legal20 rat2034 rat3544 rat4554 rat55 state1-state50 time1-time20 trend1-trend51 ok95 [aweight=pop], robust




/* Table 1, Model 6 */

use  "altsources_zeros_01.dta", clear	



drop if dpicexec~=0 & L6.sentences==0  



regress NCHSmurderrate exprJLEl  amurtlag sentratl2 cust3lag deathrtl perblk repub unemp realinc mortal urban legal18 /*
*/ legal19 legal20 rat2034 rat3544 rat4554 rat55 state1-state50 time1-time20 trend1-trend51 ok95 [aweight=total], robust

	


/* Table 1, Model 7 */
use "zero_to_0.dta", clear

drop if expro~=0 & L6.sentc==0 



regress cmurrat exprJLEl  amurtlag sentratl2 cust3lag deathrtl perblk repub unemp realinc mortal urban legal18 /*
*/ legal19 legal20 rat2034 rat3544 rat4554 rat55 state1-state50 time1-time20 trend1-trend51 ok95 [aweight=pop], robust 

	


/* Table 1, Model 8*/


use "altsources_zeros_0.dta", clear





drop if dpicexec~=0 & L6.sentences==0 



regress NCHSmurderrate exprJLEl  amurtlag sentratl2 cust3lag deathrtl perblk repub unemp realinc mortal urban legal18 /*
*/ legal19 legal20 rat2034 rat3544 rat4554 rat55 state1-state50 time1-time20 trend1-trend51 ok95 [aweight=total], robust 



/* Table 1, Model 9*/

use "altsources.dta", clear

drop if dpicexec~=0 & L6.sentences==0 
drop if fips==48


regress NCHSmurderrate exprJLEl  amurtlag sentratl2 cust3lag deathrtl perblk repub unemp realinc mortal urban legal18 /*
*/ legal19 legal20 rat2034 rat3544 rat4554 rat55 state1-state50 time1-time20 trend1-trend51 ok95 [aweight=total], robust



/* Table 1, Model 10 */


use "Mocan.dta", clear


tsset fips year, yearly

	

drop if expro~=0 & L6.sentc==0 



regress cmurrat exprJLEl  amurtlag sentratl2 cust3lag deathrtl perblk repub unemp realinc mortal urban legal18 /*
*/ legal19 legal20 rat2034 rat3544 rat4554 rat55 state1-state50 time1-time20  ok95 [aweight=pop], robust 


/* Table 1, Model 11 */
use "alternate_deterrence.dta", clear


drop if expro~=0 & L6.sentc==0 



regress cmurrat lagexec amurtlag sentratl2 cust3lag deathrtl perblk repub unemp realinc mortal urban legal18 /*
*/ legal19 legal20 rat2034 rat3544 rat4554 rat55 state1-state50 time1-time20 trend1-trend51 ok95 [aweight=pop], robust 


log close