home / lobbying

Lobbying Activity for a Client

Correction under way: a loading error counted some lobbying filings' rows more than once, so totals and row counts here are overstated. LDA.gov's own filing pages show the correct figures. This note comes off when the fix is complete. Detailed lobbying activity for a specific client — every issue area, government entity contacted, and specific issues lobbied on. Income/expense are filing-level, joined from lobbying_filings_raw. As LDA.gov’s terms of use (https://lda.gov/api/tos/) require: “Senate Office of Public Records cannot vouch for the data or analyses derived from these data after the data have been retrieved from LDA.gov.”

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(f.income_amount AS INTEGER) AS income, CAST(f.expense_amount AS INTEGER) AS expenses FROM lobbying_activities la JOIN lobbying_filings_raw f ON f.filing_uuid = la.filing_uuid 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

Powered by Datasette · Queries took 908.97ms · Privacy