lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12 rows where filing_uuid = "54b70154-3cfa-48df-bd68-cbfd992efe63" sorted by filing_year descending
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2423863 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | CHM | Issues related to the Novel Coronavirus and the disease COVID-19; Issues related to the production of industrial grade alcohol for inclusion in hand sanitizer; Issues related to the transportation and tax treatment for industrial grade alcohol for inclusion in hand sanitizer; H.R. 748, the CARES Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-04:00 |
| 2423864 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | IMM | Issues related to guest visas for agricultural workers; Issues related to workforce and unemployment; Issues related to overtime rules and overtime compensation; | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-04:00 |
| 2423865 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | TRD | Issues related to ethanol exports; Issues related to dried distillers grains (DDGS) exports; Issues related to beef and other protein exports; Issues related to ethanol export tariffs; Issues related to other agricultural commodity exports and tariffs; Issues related to foreign animal diseases prevention and detection; Issues related to ongoing trade negotiations with China, specifically purchase commitments and tariffs on ethanol and DDGS; Issues related to trade with Brazil, specifically tariff rate quotas on ethanol; Issues related to ratification of USMCA; Issues related to trade negotiations with Japan; Issues related to trade with various nations; Issues related to the Novel Coronavirus and the disease COVID-19 including economic impact on ethanol supply and demand; H.R. 748, the CARES Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-04:00 |
| 2423866 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | AGR | Issues related to the RFS; Issues related to ethanol exports; Issues related to distiller grain exports; Issues related to 2017 Renewable Volume Obligation (RVO) under the RFS; issues related to 2018 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2019 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2020 Renewable Volume Obligation (RVO) under the RFS; Issues related to unwarranted small refinery exemptions from RFS compliance; Issues related to proposed Renewable Identification Numbers (RIN) trading changes; Issues related to Reid Vapor Pressure (RVP) waiver extension from E10 to E15 blends; Issues related to livestock transportation; Issues related to detection and prevention of foreign animal diseases; Issues related to livestock indemnity payments; Issues related to flooding and disaster recovery efforts; Issues related to livestock GHG emissions reporting; H.R. 3006; S.1840; Issues related to the Novel Coronavirus and the disease COVID-19 including economic impact on ethanol supply and demand; Issues related to the production of industrial grade alcohol for inclusion in hand sanitizer; Issues related to the transportation and tax treatment for industrial grade alcohol for inclusion in hand sanitizer; H.R. 748, the CARES Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-04:00 |
| 2423867 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | TAX | Issues related to the Novel Coronavirus and the disease COVID-19; Issues related to the production of industrial grade alcohol for inclusion in hand sanitizer; Issues related to the transportation and tax treatment for industrial grade alcohol for inclusion in hand sanitizer; H.R. 748, the CARES Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-04:00 |
| 2423868 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | TRU | Issues related to transportation of ag commodities and livestock; Issues related to hours of service for truck drivers; Issues related to electronic logging devices in trucks; Issues related to the Novel Coronavirus and the disease COVID-19 including economic impact on ethanol supply and demand; Issues related to the production of industrial grade alcohol for inclusion in hand sanitizer; Issues related to the transportation and tax treatment for industrial grade alcohol for inclusion in hand sanitizer; H.R. 748, the CARES Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-04:00 |
| 2423869 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | BUD | Issues related to bills to fund the government, specifically policy items related to tax provisions; Issues related to bills to fund the government, specifically small refinery hardship waivers from the Renewable Fuel Standard (RFS) in report language; Issues related to bills to fund the government, specifically policy items related to livestock GHG emissions reporting; Issues related to the Novel Coronavirus and the disease COVID-19 including appropriations to the USDA for CCC; Issues related to the transportation and tax treatment for industrial grade alcohol for inclusion in hand sanitizer; H.R. 748, the CARES Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-04:00 |
| 2423870 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | ENV | Issues related to the RFS; Issues related to a Reid Vapor Pressure (RVP) fix for mid-level ethanol-blended fuels; Issues related to partial waivers for a 15 percent ethanol fuel (E15); Issues related to E15 fueling infrastructure; Issues related to the 2017 Renewable Volume Obligation (RVO) under the RFS; Issues related to the 2018 Renewable Volume Obligation (RVO) under the RFS; Issues related to the 2019 Renewable Volume Obligation (RVO) under the RFS; Issues related to the 2020 Renewable Volume Obligation (RVO) under the RFS; Issues related to unwarranted small refinery RFS compliance waivers; Issues related to proposed RIN reforms, including transparency, price caps and export credits; Issues related to higher octane fuels; Issues related to ethanol export tariffs; Issues related to Carbon Capture Utilization and Sequestration (CCUS) technology; Issues related to feeding cattle; Issues related to livestock GHG emissions reporting; H.R. 3006; S.1840; Issues related to the Novel Coronavirus and the disease COVID-19 including economic impact on ethanol supply and demand; H.R. 748, the CARES Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-04:00 |
| 2423871 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | ENG | Issues related to the RFS; Issues related to a Reid Vapor Pressure (RVP) fix for mid-level ethanol-blended fuels; Issues related to partial waivers for a 15 percent ethanol fuel (E15); Issues related to the 2017 Renewable Volume Obligation (RVO) under the RFS; Issues related to the 2018 Renewable Volume Obligation (RVO) under the RFS; Issues related to the 2019 Renewable Volume Obligation (RVO) under the RFS; Issues related to the 2020 Renewable Volume Obligation (RVO) under the RFS; Issues related to unwarranted small refinery RFS compliance waivers; Issues related to proposed RIN caps, export credits, transparency, and other measures to influence RIN values; Issues related to higher octane fuels; Issues related to ethanol export tariffs; H.R. 3006; S.1840; Issues related to the Novel Coronavirus and the disease COVID-19 including economic impact on ethanol supply and demand; H.R. 748, the CARES Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-04:00 |
| 2423872 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | FUE | Issues related to the RFS; Issues related to a Reid Vapor Pressure (RVP) waiver for mid-level ethanol-blended fuels; Issues related to partial waivers for a 15 percent ethanol fuel (E15); Issues related to E15 infrastructure and labeling; Issues related to the 2017 Renewable Volume Obligation (RVO) under the RFS; Issues related to the 2018 Renewable Volume Obligation (RVO) under the RFS; Issues related to the 2019 Renewable Volume Obligation (RVO) under the RFS; Issues related to the 2020 Renewable Volume Obligation (RVO) under the RFS; Issues related to unwarranted small refinery RFS compliance waivers; Issues related to proposed RIN reforms; Issues related to higher octane fuels; Issues related to ethanol export tariffs; Issues related to Carbon Capture Utilization and Sequestration (CCUS) technology; H.R. 3006; S.1840; Issues related to the Novel Coronavirus and the disease COVID-19 including economic impact on ethanol supply and demand; Issues related to the production of industrial grade alcohol for inclusion in hand sanitizer; Issues related to the transportation and tax treatment for industrial grade alcohol for inclusion in hand sanitizer; Issues related to the approval of fuel grade ethanol for use in hand sanitizer; H.R. 748, the CARES Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-04:00 |
| 2423873 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | HCR | Issues related to the Novel Coronavirus and the disease COVID-19; Issues related to the production of industrial grade alcohol for inclusion in hand sanitizer; Issues related to the transportation and tax treatment for industrial grade alcohol for inclusion in hand sanitizer; H.R. 748, the CARES Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-04:00 |
| 2423874 | GREEN PLAINS INC. 54b70154-3cfa-48df-bd68-cbfd992efe63 | Q1 | GREEN PLAINS INC. | 401104765 | GREEN PLAINS | 2020 | first_quarter | MED | Issues related to the Novel Coronavirus and the disease COVID-19; Issues related to the production of industrial grade alcohol for inclusion in hand sanitizer; Issues related to the transportation and tax treatment for industrial grade alcohol for inclusion in hand sanitizer; H.R. 748, the CARES Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2020-04-13T12:11:47.367000-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,
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);