lobbying_activities

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.

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

10 rows where filing_uuid = "c2fb6998-e032-4e86-9eda-7074a0d2c10d" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 10

filing_year 1

filing_period 1

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
833423 BUNGE NORTH AMERICA, INC c2fb6998-e032-4e86-9eda-7074a0d2c10d Q3 BUNGE NORTH AMERICA, INC 83331 BUNGE NORTH AMERICA, INC 2009 third_quarter FIN Monitoring bills affecting commodity market speculation, CFTC actions, margin requirements, and financial market regulatory reform (HR 977, S 272, S 447). Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Surface Transportation Board (STB),U.S. Trade Representative (USTR)   230000 0 0 2009-10-16T16:55:44-04:00
833424 BUNGE NORTH AMERICA, INC c2fb6998-e032-4e86-9eda-7074a0d2c10d Q3 BUNGE NORTH AMERICA, INC 83331 BUNGE NORTH AMERICA, INC 2009 third_quarter TRD Trade Negotiations: Support for liberalized agricultural trade in WTO and bilateral trade agreements (Korea, Colombia, Panama) Food Aid: Support for US in-kind food aid programs; Global Food Security Act of 2009 (S 384). Biotechnology: regulatory systems and issues FTA Implementation Issues: Peru (tariff rate quotas); Mexico (trucking) Export credit programs: implementation and rules Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Surface Transportation Board (STB),U.S. Trade Representative (USTR)   230000 0 0 2009-10-16T16:55:44-04:00
833425 BUNGE NORTH AMERICA, INC c2fb6998-e032-4e86-9eda-7074a0d2c10d Q3 BUNGE NORTH AMERICA, INC 83331 BUNGE NORTH AMERICA, INC 2009 third_quarter AGR Biotechnology: corn milling issues relating to new corn varieties, Part 340 regulations, GAO Report on biotechnology, USDA OIG. Futures Trading: issues relating to performance of agricultural and energy futures markets, as well as financial market regulatory reform. (HR 977, S. 272, S. 447) Economic Stimulus: agricultural and waterways infrastructure (HR 1, S. 1) Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Surface Transportation Board (STB),U.S. Trade Representative (USTR)   230000 0 0 2009-10-16T16:55:44-04:00
833426 BUNGE NORTH AMERICA, INC c2fb6998-e032-4e86-9eda-7074a0d2c10d Q3 BUNGE NORTH AMERICA, INC 83331 BUNGE NORTH AMERICA, INC 2009 third_quarter TAX Biofuels: Monitoring regulatory activities relating to the tax credit provision for biodiesel and ethanol. Corporate Tax Reform: Monitoring legislative activities relating to corporate tax policy. Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Surface Transportation Board (STB),U.S. Trade Representative (USTR)   230000 0 0 2009-10-16T16:55:44-04:00
833427 BUNGE NORTH AMERICA, INC c2fb6998-e032-4e86-9eda-7074a0d2c10d Q3 BUNGE NORTH AMERICA, INC 83331 BUNGE NORTH AMERICA, INC 2009 third_quarter FOR US-Ukraine Business Relations -- grain export quotas; VAT reimbursements; judiciary reforms. Global Food Security Act of 2009 (S 384) Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Surface Transportation Board (STB),U.S. Trade Representative (USTR)   230000 0 0 2009-10-16T16:55:44-04:00
833428 BUNGE NORTH AMERICA, INC c2fb6998-e032-4e86-9eda-7074a0d2c10d Q3 BUNGE NORTH AMERICA, INC 83331 BUNGE NORTH AMERICA, INC 2009 third_quarter ENV Climate Change: monitoring legislative and regulatory activities relating to reporting on and regulation of greenhouse gas emissions and the structure of a cap and trade system (HR 2454). National Clean Water Fund: monitoring congressional activities relating to recommendations of GAO report (HR 3202). Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Surface Transportation Board (STB),U.S. Trade Representative (USTR)   230000 0 0 2009-10-16T16:55:44-04:00
833429 BUNGE NORTH AMERICA, INC c2fb6998-e032-4e86-9eda-7074a0d2c10d Q3 BUNGE NORTH AMERICA, INC 83331 BUNGE NORTH AMERICA, INC 2009 third_quarter ENG RFS 2 Rulemaking at EPA Ethanol Blend Wall Issue/E-15 waiver request Indirect Land Use Issue (HR 2454; HR 2409; S 943) Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Surface Transportation Board (STB),U.S. Trade Representative (USTR)   230000 0 0 2009-10-16T16:55:44-04:00
833430 BUNGE NORTH AMERICA, INC c2fb6998-e032-4e86-9eda-7074a0d2c10d Q3 BUNGE NORTH AMERICA, INC 83331 BUNGE NORTH AMERICA, INC 2009 third_quarter TRA Waterways and Ports: Infrastructure funding (HR 1, S 1), infrastructure needs Rail: monitoring regulatory and legislative activities relating to railroad oversight (S 1036; S 146). Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Surface Transportation Board (STB),U.S. Trade Representative (USTR)   230000 0 0 2009-10-16T16:55:44-04:00
833431 BUNGE NORTH AMERICA, INC c2fb6998-e032-4e86-9eda-7074a0d2c10d Q3 BUNGE NORTH AMERICA, INC 83331 BUNGE NORTH AMERICA, INC 2009 third_quarter FOO Food Safety: monitoring legislative activities relating to food safety and labeling with emphasis on trade impacts (HR 875, HR 759, HR 1332, S 510, HR 2749); regulatory actions relating to canola meal imports. Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Surface Transportation Board (STB),U.S. Trade Representative (USTR)   230000 0 0 2009-10-16T16:55:44-04:00
833432 BUNGE NORTH AMERICA, INC c2fb6998-e032-4e86-9eda-7074a0d2c10d Q3 BUNGE NORTH AMERICA, INC 83331 BUNGE NORTH AMERICA, INC 2009 third_quarter LBR Employee Free Choice Act of 2009 (HR 1409, S 560): monitor legislation and assess impact to corporate operations. Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Surface Transportation Board (STB),U.S. Trade Representative (USTR)   230000 0 0 2009-10-16T16:55:44-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);