-------------------------------------------------------------------------------
       log:  J:\Lobby\Agendas_Project\Death_Penalty\book\website\data_log_and_d
> o_files\Espy_ex_by_state.log
  log type:  text
 opened on:  27 Apr 2007, 16:58:43

. *****************************************************************************
> ***********************************;
. *  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 ea
> ch state over time                 ;
. *  Data Input:      Espy_executions_data.dta                                 
>                                    ;
. *  Log File:        Espy_ex_by_state.log                                     
>                                    ;
. *  NOTES:           This do file generates values for the left-hand column (1
> 945-1975) in Table 2.3.            ;
. *                   Values for the right-hand column (1976-2006) are taken fr
> om the Death Penalty Information   ;
. *                   Center's Searchable Database of Executions: http://www.de
> athpenaltyinfo.org/executions.php  ;
. *****************************************************************************
> ***********************************;
. *Import 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);
(1566 real changes made)

. tab statecode period_1945_1975;

                 |   period_1945_1975
ICPSR STATE CODE |         0          1 |     Total
-----------------+----------------------+----------
       CT (1788) |       115         11 |       126 
    Maine (1820) |        21          0 |        21 
       MA (1788) |       342          3 |       345 
       NH (1788) |        24          0 |        24 
       RI (1790) |        52          0 |        52 
  Vermont (1791) |        23          3 |        26 
 Delaware (1787) |        73          2 |        75 
       NJ (1787) |       333         28 |       361 
 New York (1788) |     1,029        101 |     1,130 
       PA (1787) |       988         55 |     1,043 
 Illinois (1818) |       344         16 |       360 
  Indiana (1816) |       132          8 |       140 
 Michigan (1837) |        13          0 |        13 
     Ohio (1803) |       368         75 |       443 
Wisconsin (1848) |         1          0 |         1 
     Iowa (1846) |        37          8 |        45 
   Kansas (1861) |        23         34 |        57 
Minnesota (1858) |        66          0 |        66 
 Missouri (1821) |       317         23 |       340 
 Nebraska (1867) |        30          4 |        34 
       ND (1889) |         8          0 |         8 
       SD (1889) |        14          1 |        15 
 Virginia (1788) |     1,310         51 |     1,361 
  Alabama (1819) |       686         47 |       733 
 Arkansas (1836) |       456         45 |       501 
  Florida (1845) |       280         89 |       369 
  Georgia (1788) |       803        173 |       976 
Louisiana (1812) |       608         50 |       658 
       MS (1817) |       289         68 |       357 
       NC (1789) |       721         82 |       803 
       SC (1788) |       608         60 |       668 
    Texas (1845) |       887        144 |     1,031 
 Kentucky (1792) |       394         32 |       426 
 Maryland (1788) |       286         26 |       312 
 Oklahoma (1907) |       161         20 |       181 
Tennessee (1796) |       308         27 |       335 
 Washington, D.C |       101         17 |       118 
       WV (1863) |       137         18 |       155 
  Arizona (1912) |       112         15 |       127 
 Colorado (1876) |        86         16 |       102 
    Idaho (1890) |        24          3 |        27 
  Montana (1889) |        73          0 |        73 
   Nevada (1864) |        58         15 |        73 
       NM (1912) |        67          6 |        73 
     Utah (1896) |        41          8 |        49 
  Wyoming (1890) |        21          2 |        23 
       CA (1850) |       567        152 |       719 
   Oregon (1859) |       113         11 |       124 
       WA (1889) |        94         15 |       109 
   Alaska (1959) |        10          2 |        12 
   Hawaii (1959) |        49          0 |        49 
-----------------+----------------------+----------
           Total |    13,703      1,566 |    15,269 


. exit;

end of do-file

. do Espy_contract_ex_by_race_by_year.do

. clear

. capture log close