lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10 rows where filing_uuid = "02ed408c-e902-4ea0-b2dc-3063b23a8a94" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1152109 | BUNGE NORTH AMERICA, INC 02ed408c-e902-4ea0-b2dc-3063b23a8a94 | Q3 | BUNGE NORTH AMERICA, INC | 83331 | BUNGE NORTH AMERICA, INC | 2011 | third_quarter | FIN | Monitoring Dodd-Frank implementation affecting commodity market speculation, CFTC actions, margin requirements, and financial market regulatory reform. | 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. Agency for International Development (USAID),U.S. Trade Representative (USTR) | 145000 | 0 | 0 | 2011-10-17T17:49:49.230000-04:00 | |
| 1152110 | BUNGE NORTH AMERICA, INC 02ed408c-e902-4ea0-b2dc-3063b23a8a94 | Q3 | BUNGE NORTH AMERICA, INC | 83331 | BUNGE NORTH AMERICA, INC | 2011 | third_quarter | TRA | Waterways and Ports: Infrastructure funding, infrastructure needs. Rail: Monitoring regulatory and legislative activities relating to railroad oversight. | 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. Agency for International Development (USAID),U.S. Trade Representative (USTR) | 145000 | 0 | 0 | 2011-10-17T17:49:49.230000-04:00 | |
| 1152111 | BUNGE NORTH AMERICA, INC 02ed408c-e902-4ea0-b2dc-3063b23a8a94 | Q3 | BUNGE NORTH AMERICA, INC | 83331 | BUNGE NORTH AMERICA, INC | 2011 | third_quarter | TAX | Biofuels: Monitoring activities relating to the tax credit provisions 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. Agency for International Development (USAID),U.S. Trade Representative (USTR) | 145000 | 0 | 0 | 2011-10-17T17:49:49.230000-04:00 | |
| 1152112 | BUNGE NORTH AMERICA, INC 02ed408c-e902-4ea0-b2dc-3063b23a8a94 | Q3 | BUNGE NORTH AMERICA, INC | 83331 | BUNGE NORTH AMERICA, INC | 2011 | third_quarter | ENV | Climate Change: Monitoring legislative and regulatory activities relating to reporting on and regulation of greenhouse gas emissions. National Clean Water Fund: Monitoring Congressional activities relating to recommendations of GAO report. | 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. Agency for International Development (USAID),U.S. Trade Representative (USTR) | 145000 | 0 | 0 | 2011-10-17T17:49:49.230000-04:00 | |
| 1152113 | BUNGE NORTH AMERICA, INC 02ed408c-e902-4ea0-b2dc-3063b23a8a94 | Q3 | BUNGE NORTH AMERICA, INC | 83331 | BUNGE NORTH AMERICA, INC | 2011 | third_quarter | FOR | US-Ukraine Business Relations--grain export quotas; VAT reimbursements; judiciary reforms; visa/passport issues. Global Food Security | 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. Agency for International Development (USAID),U.S. Trade Representative (USTR) | 145000 | 0 | 0 | 2011-10-17T17:49:49.230000-04:00 | |
| 1152114 | BUNGE NORTH AMERICA, INC 02ed408c-e902-4ea0-b2dc-3063b23a8a94 | Q3 | BUNGE NORTH AMERICA, INC | 83331 | BUNGE NORTH AMERICA, INC | 2011 | third_quarter | ENG | RFS 2 Rulemaking at EPA. Ethanol Blend Wall Issue/E-15 waiver request. Expired/Expiring Biofuels Tax Credits Renewable Fuel Standard Flexibility Act (HR3097) | 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. Agency for International Development (USAID),U.S. Trade Representative (USTR) | 145000 | 0 | 0 | 2011-10-17T17:49:49.230000-04:00 | |
| 1152115 | BUNGE NORTH AMERICA, INC 02ed408c-e902-4ea0-b2dc-3063b23a8a94 | Q3 | BUNGE NORTH AMERICA, INC | 83331 | BUNGE NORTH AMERICA, INC | 2011 | third_quarter | LBR | Monitor legislative 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. Agency for International Development (USAID),U.S. Trade Representative (USTR) | 145000 | 0 | 0 | 2011-10-17T17:49:49.230000-04:00 | |
| 1152116 | BUNGE NORTH AMERICA, INC 02ed408c-e902-4ea0-b2dc-3063b23a8a94 | Q3 | BUNGE NORTH AMERICA, INC | 83331 | BUNGE NORTH AMERICA, INC | 2011 | 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; Feed The Future, Global Develop. Biotechnology: Regulatory systems and issues; Biosafety Protocol. FTA Implementation Issues: Mexico (trucking) | 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. Agency for International Development (USAID),U.S. Trade Representative (USTR) | 145000 | 0 | 0 | 2011-10-17T17:49:49.230000-04:00 | |
| 1152117 | BUNGE NORTH AMERICA, INC 02ed408c-e902-4ea0-b2dc-3063b23a8a94 | Q3 | BUNGE NORTH AMERICA, INC | 83331 | BUNGE NORTH AMERICA, INC | 2011 | third_quarter | AGR | Biotechnology: Corn Milling issues relating to new corn varieties, Part 340 regulations. Futures Trading: Issues relating to performance of agricultural and energy futures markets, as well as financial market regulatory reform, Dodd-Frank Implementation. Agricultural and waterways infrastructure. | 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. Agency for International Development (USAID),U.S. Trade Representative (USTR) | 145000 | 0 | 0 | 2011-10-17T17:49:49.230000-04:00 | |
| 1152118 | BUNGE NORTH AMERICA, INC 02ed408c-e902-4ea0-b2dc-3063b23a8a94 | Q3 | BUNGE NORTH AMERICA, INC | 83331 | BUNGE NORTH AMERICA, INC | 2011 | third_quarter | FOO | Food Safety: Monitoring legislative activities and Food Safety Modernization Act Implementation relating to food safety and labeling with emphasis on trade impacts; regulatory actions relating to canola meal imports. Nutrition: Monitoring legislatlive and regulatory activities relating to obesity, nutrition, and healthy living. | 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. Agency for International Development (USAID),U.S. Trade Representative (USTR) | 145000 | 0 | 0 | 2011-10-17T17:49:49.230000-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);