lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_period = "first_quarter", filing_uuid = "dec8b879-56e5-4e87-b4d3-a451b24133ae" and issue_code = "TRD" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | income_amount | expense_amount | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3811045 | AMERICAN SOYBEAN ASSOCIATION dec8b879-56e5-4e87-b4d3-a451b24133ae | Q1 | AMERICAN SOYBEAN ASSOCIATION | 401105471 | AMERICAN SOYBEAN ASSOCIATION | 2026 | first_quarter | TRD | IEEPA tariffs and Chinese retaliation; Market access issues, including maximum residue levels; Free trade and regional trade agreements, including USMCA; Six year review of the USMCA; Section 301 investigation into China's noncompliance of the U.S. China Phase One Agreement; Section 301 investigations on excess capacity and forced labor; International food assistance, including procurement for Ready to Use Therapeutic Foods; Market Access Program and Foreign Market Development funding; Implementation of executive orders regarding new tariff levels; Efforts to move Food for Peace from USAID to USDA; Continued U.S. membership in WTO; Sec. 122 tariffs; Tariffs on agricultural and farminginputs; Countervailing duties on phosphate fertilizers. | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Intl Trade Administration (ITA),Justice, Dept of (DOJ),Natl Economic Council (NEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Customs & Border Protection,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 218792 | 0 | 0 | 2026-04-15T22:19:27-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE lobbying_activities (
id INTEGER PRIMARY KEY,
filing_uuid TEXT NOT NULL,
filing_type TEXT NOT NULL,
registrant_name TEXT NOT NULL,
registrant_id INTEGER,
client_name TEXT NOT NULL,
filing_year INTEGER NOT NULL,
filing_period TEXT NOT NULL,
issue_code TEXT,
specific_issues TEXT,
government_entities TEXT,
income_amount INTEGER,
expense_amount INTEGER,
is_no_activity INTEGER DEFAULT 0,
is_termination INTEGER DEFAULT 0,
received_date TEXT,
CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
REFERENCES lobbying_filings_raw(filing_uuid)
);
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);