clear capture log close set mem 80m set more off #delimit ; log using Espy_ex_by_state.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_state.do ; * Purpose: make summary variables of numbers of those executed in each state over time ; * Data Input: Espy_executions_data.dta ; * Log File: Espy_ex_by_state.log ; * Data Output: NONE ; * NOTES: This do file generates values for the left-hand column (1945-1975) in Table 2.3. ; * Values for the right-hand column (1976-2006) are taken from the Death Penalty Information ; * Center's Searchable Database of Executions: http://www.deathpenaltyinfo.org/executions.php ; ****************************************************************************************************************; *Start with raw Espy data file, including all executions since 1608; use Espy_executions_data.dta; *Generate 1945-1975 time period; gen period_1945_1975=0; replace period_1945_1975=1 if (year>1944 & year<1976); tab statecode period_1945_1975;