Lobbying Activity for a Client

Detailed lobbying activity for a specific client — every issue area, government entity contacted, and specific issues lobbied on.

Custom SQL query (hide) 

SELECT la.filing_year, la.filing_period, la.registrant_name, la.issue_code, COALESCE(lic.description, la.issue_code) AS issue_description, la.government_entities, la.specific_issues, CAST(la.income_amount AS INTEGER) AS income, CAST(la.expense_amount AS INTEGER) AS expenses FROM lobbying_activities la LEFT JOIN lobbying_issue_codes lic ON la.issue_code = lic.code WHERE la.client_name = :client_name ORDER BY la.filing_year DESC, la.filing_period DESC LIMIT 500

Query parameters

Edit SQL

0 results