home / lobbying

Lobbying Spending Over Time

Total reported lobbying income by year, showing spending trends across the lobbying industry.

Custom SQL query returning 28 rows (hide)

SELECT filing_year, COUNT(*) AS activity_count, COUNT(DISTINCT client_name) AS unique_clients, COUNT(DISTINCT registrant_name) AS unique_registrants, CAST(SUM(income_amount) AS INTEGER) AS total_income, CAST(SUM(expense_amount) AS INTEGER) AS total_expenses FROM lobbying_activities WHERE filing_year IS NOT NULL GROUP BY filing_year ORDER BY filing_year DESC

Edit SQL

This data as json, CSV

filing_yearactivity_countunique_clientsunique_registrantstotal_incometotal_expenses
2026 148 113 64 651750 1770000
2025 271919 22356 5468 8385412064 30998936736
2024 189326 19998 5231 4685971891 21910531082
2023 184045 19649 5154 4464631418 22228596467
2022 184984 19270 5072 4431269950 23462583452
2021 178046 18780 4953 4226508649 21124782303
2020 170857 17373 4816 3835477722 23529716769
2019 159677 16378 4859 3522061394 20849886879
2018 159313 16047 4786 3493275526 21419627646
2017 153405 15649 4750 3365438581 29479248148
2016 145477 14778 4654 3073586450 20489189265
2015 146876 15186 4736 3191906411 20969150051
2014 144485 15361 4760 3152041884 22232466433
2013 142736 15749 4835 3097891275 19722792065
2012 145722 16380 4883 2961567574 23064158091
2011 151946 18041 4965 3085738565 21963240427
2010 163466 19146 5032 3325761520 28792587418
2009 163567 19936 5196 3289607932 32277905665
2008 159582 18651 4997 3167727459 22777133560
2007 81241 18548 4816 3264456395 17747932365
2006 74904 18078 4566 3075675312 16615897595
2005 73149 17740 4540 2955314456 11952800903
2004 66787 16340 4364 2586731117 10402999689
2003 63619 15458 4314 2512958679 9972464070
2002 68727 13963 4041 2673121897 9163155108
2001 52734 12924 3957 2197736948 7393328521
2000 54915 11567 3786 2400618956 8513964699
1999 47816 10966 3780 2405878094 6465186857
Powered by Datasette · Queries took 4699.546ms