Top Lobbying Clients by Spending

Custom SQL query returning 100 rows (hide)

SELECT client_name, COUNT(*) AS activity_count, COUNT(DISTINCT registrant_name) AS firms_hired, COUNT(DISTINCT issue_code) AS issue_areas, CAST(SUM(income_amount) AS INTEGER) AS total_reported, MIN(filing_year) AS first_year, MAX(filing_year) AS last_year FROM lobbying_activities WHERE income_amount > 0 GROUP BY client_name ORDER BY total_reported DESC LIMIT 100

Edit SQL