lobbying_year_summary

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

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ filing_year filing_count unique_clients unique_registrants total_income total_expenses
1 1 2007 7 6 6 3806667  
2 2 2008 87180 18638 4994 1715590299 3136629035
3 3 2009 87464 19936 5196 1746884281 4117373261
4 4 2010 85762 19146 5032 1715128666 3186978442
5 5 2011 79938 18041 4965 1589438944 3140896795
6 6 2012 74427 16380 4883 1489186278 2795034091
7 7 2013 72013 15749 4835 1603020120 2712534636
8 8 2014 71012 15361 4760 1470384176 2737929825
9 9 2015 70157 15186 4736 1482809401 2714294047
10 10 2016 69133 14778 4654 1460603525 2644940400
11 11 2017 72502 15649 4750 1607022462 3761642627
12 12 2018 74541 16047 4786 1647215535 2797648001
13 13 2019 75814 16378 4859 1696855113 2845163007
14 14 2020 79178 17373 4816 1808424249 2759890654
15 15 2021 84727 18780 4953 2012597116 2837789501
16 16 2022 88957 19270 5072 2174974942 3234081707
17 17 2023 90397 19649 5154 2239669088 3197522312
18 18 2024 92205 19998 5231 2338469043 3265805370
19 19 2025 100583 22371 5465 3058840506 3652386795
20 20 2026 25899 20411 5098 773336580 980587218

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE lobbying_year_summary(
  filing_year INT,
  filing_count,
  unique_clients,
  unique_registrants,
  total_income INT,
  total_expenses INT
);