------------------------------------------------------------------------------- log: J:\Lobby\Agendas_Project\Death_Penalty\book\website\ch2_The_Death_ > Penalty_in_America\Espy_ex_by_region_by_year.log log type: text opened on: 27 Apr 2007, 16:39:16 . ***************************************************************************** > ***********************************; . * Created by: AEB > ; . * Creation Date: 04/27/07 > ; . * Directory: J:\Lobby\Agendas_Project\Death_Penalty\book\website\ch2_T > he_Death_Penalty_in_America ; . * Do-file-name: Espy_ex_by_region_by_year.do > ; . * Purpose: calculate region execution counts by year > ; . * Data Input: Espy_executions_data.dta > ; . * Log File: Espy_ex_by_region_by_year.log > ; . * NOTES: > ; . ***************************************************************************** > ***********************************; . *Start with raw Espy file; . use espy_executions_data.dta; . *Calculate regional variable; . gen region = 0; . replace region = 1 if(statecode < 15); (3203 real changes made) . replace region = 2 if(statecode > 20 & statecode < 38); (1522 real changes made) . replace region = 3 if(statecode > 39 & statecode < 57); (8984 real changes made) . replace region = 4 if(statecode > 60 & statecode < 83); (1560 real changes made) . *Make Delaware a southern state to match DPIC categories; . replace region = 3 if statecode == 11; (75 real changes made) . sum statecode region year jurisdiction; Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- statecode | 15269 39.0355 17.7782 1 82 region | 15269 2.59277 .9249348 1 4 year | 15269 1891.927 62.83177 1608 2002 jurisdiction | 15264 2.380372 1.112418 1 6 . tab statecode region; | region ICPSR STATE CODE | 1 2 3 4 | Total -----------------+--------------------------------------------+---------- CT (1788) | 126 0 0 0 | 126 Maine (1820) | 21 0 0 0 | 21 MA (1788) | 345 0 0 0 | 345 NH (1788) | 24 0 0 0 | 24 RI (1790) | 52 0 0 0 | 52 Vermont (1791) | 26 0 0 0 | 26 Delaware (1787) | 0 0 75 0 | 75 NJ (1787) | 361 0 0 0 | 361 New York (1788) | 1,130 0 0 0 | 1,130 PA (1787) | 1,043 0 0 0 | 1,043 Illinois (1818) | 0 360 0 0 | 360 Indiana (1816) | 0 140 0 0 | 140 Michigan (1837) | 0 13 0 0 | 13 Ohio (1803) | 0 443 0 0 | 443 Wisconsin (1848) | 0 1 0 0 | 1 Iowa (1846) | 0 45 0 0 | 45 Kansas (1861) | 0 57 0 0 | 57 Minnesota (1858) | 0 66 0 0 | 66 Missouri (1821) | 0 340 0 0 | 340 Nebraska (1867) | 0 34 0 0 | 34 ND (1889) | 0 8 0 0 | 8 SD (1889) | 0 15 0 0 | 15 Virginia (1788) | 0 0 1,361 0 | 1,361 Alabama (1819) | 0 0 733 0 | 733 Arkansas (1836) | 0 0 501 0 | 501 Florida (1845) | 0 0 369 0 | 369 Georgia (1788) | 0 0 976 0 | 976 Louisiana (1812) | 0 0 658 0 | 658 MS (1817) | 0 0 357 0 | 357 NC (1789) | 0 0 803 0 | 803 SC (1788) | 0 0 668 0 | 668 Texas (1845) | 0 0 1,031 0 | 1,031 Kentucky (1792) | 0 0 426 0 | 426 Maryland (1788) | 0 0 312 0 | 312 Oklahoma (1907) | 0 0 181 0 | 181 Tennessee (1796) | 0 0 335 0 | 335 Washington, D.C | 0 0 118 0 | 118 WV (1863) | 0 0 155 0 | 155 Arizona (1912) | 0 0 0 127 | 127 Colorado (1876) | 0 0 0 102 | 102 Idaho (1890) | 0 0 0 27 | 27 Montana (1889) | 0 0 0 73 | 73 Nevada (1864) | 0 0 0 73 | 73 NM (1912) | 0 0 0 73 | 73 Utah (1896) | 0 0 0 49 | 49 Wyoming (1890) | 0 0 0 23 | 23 CA (1850) | 0 0 0 719 | 719 Oregon (1859) | 0 0 0 124 | 124 WA (1889) | 0 0 0 109 | 109 Alaska (1959) | 0 0 0 12 | 12 Hawaii (1959) | 0 0 0 49 | 49 -----------------+--------------------------------------------+---------- Total | 3,128 1,522 9,059 1,560 | 15,269 . *Look at regional distribution of executions in different time periods for Fi > g. 2.4; . *Specify jurisdiction = 2 for state executions only; . tab region if(jurisdiction == 2 & year < 1945); region | Freq. Percent Cum. ------------+----------------------------------- 1 | 2,392 21.55 21.55 2 | 1,172 10.56 32.10 3 | 6,564 59.12 91.23 4 | 974 8.77 100.00 ------------+----------------------------------- Total | 11,102 100.00 . tab region if(jurisdiction == 2 & year > 1945 & year < 1976); region | Freq. Percent Cum. ------------+----------------------------------- 1 | 194 13.91 13.91 2 | 130 9.32 23.23 3 | 856 61.36 84.59 4 | 215 15.41 100.00 ------------+----------------------------------- Total | 1,395 100.00 . tab region if(jurisdiction == 2 & year > 1976); region | Freq. Percent Cum. ------------+----------------------------------- 1 | 3 0.39 0.39 2 | 81 10.41 10.80 3 | 632 81.23 92.03 4 | 62 7.97 100.00 ------------+----------------------------------- Total | 778 100.00 . end of do-file . clear . do Espy_collapse_year.do . clear . capture log close