Explore: Lobbying Client Search

Custom SQL query returning 50 rows (hide)

SELECT client_name, SUM(income_amount) AS total_income, COUNT(DISTINCT registrant_name) AS firm_count, COUNT(*) AS filing_count, COUNT(DISTINCT issue_code) AS issue_count, MIN(filing_year) AS year_from, MAX(filing_year) AS year_to FROM lobbying_activities WHERE client_name LIKE '%' || :name || '%' GROUP BY client_name ORDER BY total_income DESC LIMIT 50

Query parameters

name

Edit SQL