lobbying_by_year

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

28 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unique_registrants

Link rowid ▼ filing_year filing_count unique_clients unique_registrants total_income_reported total_expense_reported
1 1 1999 25197 10966 3780 2405878094 6465186857
2 2 2000 27123 11567 3786 2400618956 8513964699
3 3 2001 29655 12924 3957 2197736948 7393328521
4 4 2002 31849 13963 4041 2673121897 9163155108
5 5 2003 35611 15458 4314 2512958679 9972464070
6 6 2004 37269 16340 4364 2586731117 10402999689
7 7 2005 40851 17740 4540 2955314456 11952800903
8 8 2006 42092 18078 4566 3075675312 16615897595
9 9 2007 45328 18548 4816 3264456395 17747932365
10 10 2008 87224 18651 4997 3167727459 22777133560
11 11 2009 87465 19936 5196 3289607932 32277905665
12 12 2010 85774 19146 5032 3325761520 28792587418
13 13 2011 79944 18041 4965 3085738565 21963240427
14 14 2012 74431 16380 4883 2961567574 23064158091
15 15 2013 72013 15749 4835 3097891275 19722792065
16 16 2014 71012 15361 4760 3152041884 22232466433
17 17 2015 70157 15186 4736 3191906411 20969150051
18 18 2016 69133 14778 4654 3073586450 20489189265
19 19 2017 72502 15649 4750 3365438581 29479248148
20 20 2018 74541 16047 4786 3493275526 21419627646
21 21 2019 75814 16378 4859 3522061394 20849886879
22 22 2020 79178 17373 4816 3835477722 23529716769
23 23 2021 84727 18780 4953 4226508649 21124782303
24 24 2022 88957 19270 5072 4431269950 23462583452
25 25 2023 90397 19649 5154 4464631418 22228596467
26 26 2024 92205 19998 5231 4685971891 21910531082
27 27 2025 100143 22356 5468 8385412064 30998936736
28 28 2026 118 113 64 651750 1770000

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE lobbying_by_year(
  filing_year INT,
  filing_count,
  unique_clients,
  unique_registrants,
  total_income_reported,
  total_expense_reported
);