lobbying_activities: 2338313

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
2338313	0f923f44-c332-43b4-9f47-22ca5854eb73	Q3	MERCURY PUBLIC AFFAIRS, LLC	70175	HYUNDAI MOTOR COMPANY	2019	third_quarter	TRD	"Implementation and modification of the United StatesKorea Free Trade Agreement (P.L. No. 11241 United States Korea Free Trade Implementation Act), regarding all provisions, particularly those relating to the automotive sector. U.S.Korea trade, U.S. policy towards Korea, and U.S. trade policy, including the North American Free Trade Agreement." U.S. Department of Commerce Section 232 investigation into auto imports. U.S.- Japan trade agreement discussions.	Commerce, Dept of (DOC),Energy, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT)	0	0	2019-10-03T16:24:57.547000-04:00