*****Baumgartner, Larsen, Leech, and Rutledge (2006) do file *****This do file will recreate all of the tables contained in the paper. clear chdir "N:\Political Research files\PRQ Revisions\PRQ Revisions\Final revisions\Email" set mem 600m set matsize 420 log using "final revisions.log", replace ****************************Note, tables 1-3 in the paper were calculated using excel, so those tables are not included in this do file. *********************************Table 4: The Effect of Congressional Hearings on Lobbying Activity by Organizations ************************Part A: Replicating the original model 1996-2000 use "Leech_et_al_PRQ_2004_dataset.dta", clear iis topic tis period tsset topic period, halfyearly ****Model 1 xtpcse group hearings ****Model 2 xtpcse group hearings budget ****Model 3 xtpcse group hearings budget firms ****Model 4 xtpcse group hearings budget firms l.group ****Model 5 xtpcse group hearings budget l.group ************************Part B: Extending the Original Model, 1996-2004 use "final_revisions(3).dta", clear iis topic tis period tsset topic period, halfyearly *****Model 1 xtpcse group hearings *****Model 2 xtpcse group hearings budget *****Model 3 xtpcse group hearings budget l.group ************************************Table 5: The Effect of Congressional Hearings on Lobbying Activity by Firms *************************Part A: Replicating the Orginal Model, 1996-2000 use "Leech_et_al_PRQ_2004_dataset.dta", clear iis topic tis period tsset topic period, halfyearly ****Model 1 xtpcse lobbyist hearings ****Model 2 xtpcse lobbyist hearings budget ****Model 3 xtpcse lobbyist hearings budget firms ****Model 4 xtpcse lobbyist hearings budget firms l.lobbyist ****Model 5 xtpcse lobbyist hearings budget l.lobbyist **************************Part B: Extending the Original Model, 1996-2004 use "final_revisions(3).dta", clear iis topic tis period tsset topic period, halfyearly ****Model 1 xtpcse lobbyist hearings ****Model 2 xtpcse lobbyist hearings budget ****Model 3 xtpcse lobbyist hearings budget l.lobbyist *************************************Correlations Among Congressional and Presidential Activities: 1953-2004. ****Note, this table did not end up in the final paper. use "correlations.dta" corr hear1 sou1 corr hear2 sou2 corr hear3 sou3 corr hear4 sou4 corr hear5 sou5 corr hear6 sou6 corr hear7 sou7 corr hear8 sou8 corr hear10 sou10 corr hear12 sou12 corr hear13 sou13 corr hear14 sou14 corr hear15 sou15 corr hear16 sou16 corr hear17 sou17 corr hear18 sou18 corr hear20 sou20 corr hear21 sou21 corr hear1 exe1 corr hear2 exe2 corr hear3 exe3 corr hear4 exe4 corr hear5 exe5 corr hear6 exe6 corr hear7 exe7 corr hear8 exe8 corr hear10 exe10 corr hear12 exe12 corr hear13 exe13 corr hear14 exe14 corr hear15 exe15 corr hear16 exe16 corr hear17 exe17 corr hear18 exe18 corr hear20 exe20 corr hear21 exe21 corr stat1 sou1 corr stat2 sou2 corr stat3 sou3 corr stat4 sou4 corr stat5 sou5 corr stat6 sou6 corr stat7 sou7 corr stat8 sou8 corr stat10 sou10 corr stat12 sou12 corr stat13 sou13 corr stat14 sou14 corr stat15 sou15 corr stat16 sou16 corr stat17 sou17 corr stat18 sou18 corr stat20 sou20 corr stat21 sou21 corr stat1 exe1 corr stat2 exe2 corr stat3 exe3 corr stat4 exe4 corr stat5 exe5 corr stat6 exe6 corr stat7 exe7 corr stat8 exe8 corr stat10 exe10 corr stat12 exe12 corr stat13 exe13 corr stat14 exe14 corr stat15 exe15 corr stat16 exe16 corr stat17 exe17 corr stat18 exe18 corr stat20 exe20 corr stat21 exe21 corr hear1 stat1 corr hear2 stat2 corr hear3 stat3 corr hear4 stat4 corr hear5 stat5 corr hear6 stat6 corr hear7 stat7 corr hear8 stat8 corr hear10 stat10 corr hear12 stat12 corr hear13 stat13 corr hear14 stat14 corr hear15 stat15 corr hear16 stat16 corr hear17 stat17 corr hear18 stat18 corr hear20 stat20 corr hear21 stat21 *************************************Table 6: The Effect of Executive Activity on Lobbying by Organizations, 1996-2004 use "final_revisions(3).dta", clear iis topic tis period tsset topic period, halfyearly *****Model 1 xtpcse group hearings budget l.group ****Model 2 xtpcse group presindomains hearings budget l.group ************************************Table 7: The Effect of Executive Activity on Lobbying by Firms, 1996-2004 *****Model 1 xtpcse lobbyist hearings budget l.lobbyist ****Model 2 xtpcse lobbyist presindomains hearings budget l.lobbyist ************************************Appendix table 2 use "final_revisions(3).dta", clear iis topic tis period tsset topic period, halfyearly *****Model 1 xtpcse group pres *****Model 2 xtpcse group presindomains *****Model 2 xtpcse group pres hearings *****Model 4 xtpcse group presindomains hearings *****Model 5 xtpcse group pres hearings budget *****Model 6 xtpcse group presindomains hearings budget *****Model 7 xtpcse group pres hearings budget l.group *****Model 8 xtpcse group presindomains hearings budget l.group ***********************************Appendix Table 2 *****Model 1 xtpcse lobbyist pres *****Model 2 xtpcse lobbyist presindomains *****Model 2 xtpcse lobbyist pres hearings *****Model 4 xtpcse lobbyist presindomains hearings *****Model 5 xtpcse lobbyist pres hearings budget *****Model 6 xtpcse lobbyist presindomains hearings budget *****Model 7 xtpcse lobbyist pres hearings budget l.lobbyist *****Model 8 xtpcse lobbyist presindomains hearings budget l.lobbyist log close