lobbying_activities: 2909891

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts. Sortable columns (indexed): client_name, issue_code, filing_year, filing_uuid. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

This data as json

id	filing_uuid	filing_type	registrant_name	registrant_id	client_name	filing_year	filing_period	issue_code	specific_issues	government_entities	is_no_activity	is_termination	received_date
2909891	cf07a697-11ab-4a72-b4df-5613ee11a758	Q4	BUCHANAN INGERSOLL & ROONEY PC	55291	CITY OF PITTSBURGH	2022	fourth_quarter	CAW	Strategy development and implementation of federal government relations initiatives, including tracking legislation and coordination of legislative and regulatory efforts relating to Water Resources.	HOUSE OF REPRESENTATIVES,SENATE	0	0	2023-01-13T09:00:00-05:00