home / openregs

Presidential Documents by Year

Count of Executive Orders and Proclamations signed each year.

Custom SQL query returning 34 rows (hide)

SELECT CAST(strftime('%Y', signing_date) AS INTEGER) AS year, SUM(CASE WHEN document_type = 'executive_order' THEN 1 ELSE 0 END) AS executive_orders, SUM(CASE WHEN document_type = 'proclamation' THEN 1 ELSE 0 END) AS proclamations, COUNT(*) AS total FROM presidential_documents WHERE signing_date IS NOT NULL GROUP BY year ORDER BY year DESC

Edit SQL

This data as json, CSV

yearexecutive_ordersproclamationstotal
2026 18 13 31
2025 238 121 359
2024 19 185 204
2023 24 183 207
2022 29 179 208
2021 91 203 294
2020 69 156 225
2019 45 140 185
2018 37 147 184
2017 62 126 188
2016 43 174 217
2015 29 161 190
2014 31 151 182
2013 20 150 170
2012 39 155 194
2011 34 150 184
2010 35 152 187
2009 45 135 180
2008 30 120 150
2007 32 115 147
2006 27 127 154
2005 26 114 140
2004 45 111 156
2003 41 114 155
2002 31 118 149
2001 66 128 194
2000 41 127 168
1999 35 101 136
1998 38 101 139
1997 38 96 134
1996 49 106 155
1995 41 96 137
1994 54 118 172
1993 1 0 1
Powered by Datasette · Queries took 1435.912ms