comments_by_year

Pre-computed view: annual comment volume per agency with submitter type breakdown.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

1,290 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ agency_id posted_year comment_count docket_count org_comments individual_comments anonymous_comments
1 1 AMS 2004 1 1 0 0 0
2 2 AMS 2007 6422 48 0 3 2
3 3 AMS 2008 3911 37 62 1194 3
4 4 AMS 2009 3965 31 201 3131 0
5 5 AMS 2010 1459 27 187 623 0
6 6 AMS 2011 7507 35 409 2388 3
7 7 AMS 2012 5101 24 136 196 2
8 8 AMS 2013 8967 34 5 3 43
9 9 AMS 2014 4466 26 0 0 133
10 10 AMS 2015 5716 24 4 4 70
11 11 AMS 2016 12912 38 0 2 183
12 12 AMS 2019 16685 26 1 1769 344
13 13 AMS 2020 10362 49 42 6182 1142
14 14 AMS 2021 3454 33 280 1158 152
15 15 AMS 2023 4737 33 113 639 83
16 16 AMS 2024 29561 37 267 18775 208
17 17 AMS 2026 32 9 4 14 11
18 18 APHIS 2004 326 18 0 0 31
19 19 APHIS 2005 2416 64 485 1301 520
20 20 APHIS 2006 5328 69 473 4762 1
21 21 APHIS 2007 3161 93 538 2574 5
22 22 APHIS 2008 3521 86 496 2966 11
23 23 APHIS 2009 17580 60 425 17115 0
24 24 APHIS 2010 15965 61 106 15782 3
25 25 APHIS 2011 12631 90 113 12495 7
26 26 APHIS 2012 26643 69 84 26548 7
27 27 APHIS 2013 23301 89 64 17147 6078
28 28 APHIS 2014 35275 84 96 31989 2839
29 29 APHIS 2015 13886 71 49 13399 346
30 30 APHIS 2016 26186 76 27 25103 809
31 31 APHIS 2017 38684 61 53 37937 650
32 32 APHIS 2018 31073 60 31 30574 425
33 33 APHIS 2019 46927 74 54 45301 1459
34 34 APHIS 2020 19246 56 107 18440 677
35 35 APHIS 2021 26732 56 197 25676 854
36 36 APHIS 2022 33467 38 232 31793 1188
37 37 APHIS 2023 67391 58 431 65147 1798
38 38 APHIS 2024 44897 37 119 44685 87
39 39 APHIS 2025 11830 27 152 11329 346
40 40 APHIS 2026 404 21 21 275 106
41 41 ATF 2009 3 1 0 0 0
42 42 ATF 2010 20 3 0 0 0
43 43 ATF 2012 19 3 0 0 0
44 44 ATF 2013 7035 1 0 0 0
45 45 ATF 2014 1605 4 0 1 0
46 46 ATF 2015 3 2 0 0 0
47 47 ATF 2016 51 2 0 0 0
48 48 ATF 2018 122631 2 0 0 0
49 49 ATF 2020 7050 1 0 0 0
50 50 ATF 2021 419679 3 0 0 3
51 51 ATF 2023 296355 2 0 0 0
52 52 ATF 2024 74 2 0 0 0
53 53 ATF 2026 50 1 0 0 0
54 54 BIA 2008 27 2 0 0 0
55 55 BIA 2011 2 2 0 0 0
56 56 BIA 2012 86 2 0 0 0
57 57 BIA 2013 116 4 0 0 0
58 58 BIA 2014 656 4 0 0 12
59 59 BIA 2015 1924 6 0 0 18
60 60 BIA 2016 20 5 0 0 0
61 61 BIA 2017 106 4 0 0 0
62 62 BIA 2018 127 4 0 0 0
63 63 BIA 2019 113 7 0 0 0
64 64 BIA 2020 10 7 0 0 0
65 65 BIA 2021 42 5 0 0 0
66 66 BIA 2022 196 3 0 0 2
67 67 BIA 2023 297 5 0 0 7
68 68 BIA 2024 198 3 0 0 2
69 69 BIA 2025 7 2 0 0 2
70 70 BIS 2007 6 1 1 0 0
71 71 BIS 2008 17 3 5 0 0
72 72 BIS 2009 6 2 2 1 0
73 73 BIS 2010 2 2 0 0 0
74 74 BIS 2011 113 5 18 11 0
75 75 BIS 2012 75 15 0 1 0
76 76 BIS 2013 97 6 1 1 2
77 77 BIS 2014 26 3 0 0 0
78 78 BIS 2015 441 9 0 0 3
79 79 BIS 2016 22 3 0 0 0
80 80 BIS 2017 16 1 0 0 0
81 81 BIS 2018 52027 7 0 0 234
82 82 BOEM 2009 8 1 2 2 0
83 83 BOEM 2010 522 9 78 438 0
84 84 BOEM 2011 1037 43 216 782 0
85 85 BOEM 2012 391 19 186 172 0
86 86 BOEM 2013 476 22 105 321 1
87 87 BOEM 2014 2430 19 307 2032 30
88 88 BOEM 2015 19242 25 358 18673 78
89 89 BOEM 2016 4946 25 311 4099 27
90 90 BOEM 2017 28820 7 235 28377 88
91 91 BOEM 2018 55115 11 755 53631 462
92 92 BOEM 2019 585 6 80 471 6
93 93 BOEM 2020 5216 1 7 5188 17
94 94 BOEM 2021 2072 21 377 1292 69
95 95 BOEM 2024 3583 22 340 2668 435
96 96 BOR 2007 883 1 1 0 4
97 97 BOR 2008 654 7 0 1 0
98 98 BOR 2009 6 1 1 1 0
99 99 BOR 2020 700 1 0 0 0
100 100 BOR 2023 12 1 1 4 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE comments_by_year(
  agency_id TEXT,
  posted_year INT,
  comment_count,
  docket_count,
  org_comments,
  individual_comments,
  anonymous_comments
);
CREATE INDEX idx_cby_agency ON comments_by_year(agency_id);