Explore: Lobbying Client Search

Custom SQL query returning 50 rows (hide)

SELECT f.client_name, CAST(SUM(f.income_amount) AS INTEGER) AS total_income, COUNT(DISTINCT f.registrant_name) AS firm_count, COUNT(*) AS filing_count, MIN(f.filing_year) AS year_from, MAX(f.filing_year) AS year_to FROM lobbying_filings f WHERE f.client_name LIKE '%' || :name || '%' AND f.filing_type GLOB '[1234Q]*' AND f.income_amount > 0 GROUP BY f.client_name ORDER BY total_income DESC LIMIT 50

Query parameters

name

Edit SQL