Explore: Client Lobbying Activity

Lobbying activity records for a specific client. Filing-level income/expense are joined from lobbying_filings.

Custom SQL query (hide) 

SELECT la.registrant_name, la.filing_year, la.filing_period, la.issue_code, CAST(f.income_amount AS INTEGER) AS income, CAST(f.expense_amount AS INTEGER) AS expense, la.specific_issues, la.government_entities FROM lobbying_activities la JOIN lobbying_filings f ON f.filing_uuid = la.filing_uuid WHERE la.client_name = :client_name ORDER BY la.filing_year DESC, la.filing_period DESC LIMIT 100

Query parameters

Edit SQL

0 results