clear
capture log close
set mem 80m
set more off
#delimit ;

log using Espy_ex_by_region_by_year.log, replace;

****************************************************************************************************************;
*  Created by:      AEB                                                                                         ;
*  Creation Date:   04/27/07                                                                                    ;
*  Directory:       J:\Lobby\Agendas_Project\Death_Penalty\book\website\data_log_and_do_files                   ;
*  Do-file-name:    Espy_ex_by_region_by_year.do                                                                ;
*  Purpose:         calculate regional execution counts by year                                                 ;
*  Data Input:      Espy_executions_data.dta                                                                    ;
*  Log File:        Espy_ex_by_region_by_year.log                                                               ;
*  Data Output:     NONE                                                                                        ;
*  NOTES:                                                                                                       ;
****************************************************************************************************************;

*Start with raw Espy data file, including all executions since 1608;
use Espy_executions_data.dta;

*Calculate regional variable;

gen region = 0;
replace region = 1 if(statecode < 15);
replace region = 2 if(statecode > 20 & statecode < 38);
replace region = 3 if(statecode > 39 & statecode < 57);
replace region = 4 if(statecode > 60 & statecode < 83);

*Make Delaware a southern state to match DPIC categories;
replace region = 3 if statecode == 11;

sum statecode region year jurisdiction;
tab statecode region;

*Look at regional distribution of executions in different time periods for Fig. 2.4;
*Specify jurisdiction = 2 for state executions only;

tab region if(jurisdiction == 2 & year < 1945);
tab region if(jurisdiction == 2 & year > 1945 & year < 1976);
tab region if(jurisdiction == 2 & year > 1976);