lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12 rows where filing_uuid = "8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1453033 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | IMM | H-2A Regulations; provisions relating to farmer cooperatives. E-Verify and other legislative reform relating to farmer cooperatives. Immigration reform proposals; provisions and regulations affecting agriculture and farmer cooperatives.S. 744, Border Security, Economic Opportunity, and Immigration Modernization Act of 2013; provisions relating to farmer cooperatives. H.R. 1773, Agricultural Guestworker Act; provisions relating to agriculture and farmer cooperatives. H.R. 1772, Legal Workforce Act; provisions relating to agriculture and farmer cooperatives. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-04:00 | |
| 1453034 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | TAX | Issues relating to federal tax reform; regulations related to agriculture and farmer cooperatives. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-04:00 | |
| 1453035 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | TRD | Food, Conservation and Energy Act of 2008; regulations related to agriculture and farmer cooperatives. USDA GSM Export Credit Program; provisions related to agriculture and farmer cooperatives. USDA Export Programs; provisions related to agriculture and farmer cooperatives.WTO, issues related to agriculture and farmer cooperatives. USDA import/export requirements affecting agriculture and farmer cooperatives. Trans-Pacific Partnership Agreement; issues related to agriculture and farmer cooperatives. Trans-Atlantic Trade and Investment Partnership; issues related to agriculture and farmer cooperatives. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-04:00 | |
| 1453036 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | AGR | Food, Conservation and Energy Act of 2008; regulatory provisions related to agriculture and farmer cooperatives. ADUFA III; implementation and provisions related to agriculture and farmer cooperatives. Farm Bill Reauthorization; provisions affecting agriculture and farmer cooperatives.Biotechnology Deregulation Process, including the deregulation of crops derived through biotechnology; provisions affecting agriculture and farmer cooperatives. Dodd-Frank Wall Street Reform and Consumer Protections Act, implementation and provisions related to Title 7. H.R. 1947, H.R. 2642, Federal Agriculture Reform and Risk Management Act of 2013; provisions affecting agriculture and farmer cooperatives. S. 954, Agriculture Reform, Food and Jobs Act of 2013; provisions affecting agriculture and farmer cooperatives. Crop insurance, legislative and regulatory issues impacting co-ops and their farmer-owners. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-04:00 | |
| 1453037 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | TRA | Surface Transportation Board, provisions relating to agriculture and farmer cooperatives. Highway transportation regulations related to agriculture and farmer cooperatives. H.R. 3080, Water Resources Development Act of 2013; provisions affecting agriculture and farmer cooperatives.S. 407, River Act of 2013; provisions affecting agriculture and farmer cooperatives. Inland waterways transportation issues; provisions affecting agriculture and farmer cooperatives. S. 601, Water Resources Development Act of 2013; provisions affecting agriculture and farmer cooperatives. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-04:00 | |
| 1453038 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | RET | S. 1302, The Cooperative and Small Employer Charity Pension Flexibility Act of 2013; provisions affecting agriculture and farmer cooperatives. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-04:00 | |
| 1453039 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | TRU | Agriculture Hours of Service Exemption; provisions relative to agriculture and farmer cooperatives. MAP-21 (Highway Bill); provisions relative to agriculture and farmer cooperatives. H.R. 612, The Safe and Efficient Transportation Act; provisions relative to agriculture and farmer cooperatives. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-04:00 | |
| 1453040 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | BUD | FY 2014 Budget Resolution- House; provisions relating to agricuture and farmer cooperatives. FY 2014 Ag Appropriations; provisions relating to agriculture and farmer cooperatives. Budget Control Act of 2011; provisions affecting agricuture and farmer cooperatives. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-04:00 | |
| 1453041 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | CHM | FIFRA/FQPA registration and re-registration of crop protection products; provisions affecting agriculture and farmer cooperatives Crop protections permit requirements; provisions affecting agriculture and farmer cooperatives. FIFRA/ESA Section 7 Consultation Process; provisions affecting agriculture and farmer cooperatives.H.R. 935 Reducing Regulatory Burdens Act of 2011; provisions affecting agriculture and farmer cooperatives. S. 802, Sensible Environmental Protection Act of 2013; provisions affecting agriculture and farmer cooperatives. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-04:00 | |
| 1453042 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | FOO | Implementation of the FDA Food Safety Modernization Act; provisions relating to agriculture and farmer cooperatives. Healthy, Hunger-Free Kids Act of 2010; provisions and regulatory implementation relating to agriculture and farmer cooperatives. USDA Dietary Guidelines; provisions relating to agriculture and farmer cooperatives. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-04:00 | |
| 1453043 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | LBR | NLRB decsions and issues affecting agriculture and farmer cooperatives. OSHA, regulations affecting labor; provisions relating to agriuculture and farmer cooperatives. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-04:00 | |
| 1453044 | NATIONAL COUNCIL OF FARMER COOPERATIVES 8c8cb256-7d2c-4e13-a8a1-ee3a4a41dcec | Q3 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2013 | third_quarter | CAW | Spill Prevention, Control and Countermeasures (SPCC); provisions and regulations affecting agriculture and farmer cooperatives. Clean Air Act, provisions and regulations affecting agricuture and farmer cooperatives. H.R. 311 and S. 496, Farmers Undertake Environmental Land Stewardship (FUELS) Act; provisions affecting agriculture and farmer cooperatives.Concentrated Animal Feeding Operations (CAFO) rule; provisions and regulations affecting agriculture and farmer cooperatives. Clean Water Act; application and regulations pertaining to agriculture. Chesapeake Bay Initiative, Executive Order 13508; all provisions pertaining to agriculture and farmer cooperatives. H.R. 935, Reducing Regulatory Burdens Act of 2011; provisions relating to agriculture and farmer cooperatives. Mississippi River Basin Initiative; provisions related to agriculture and farmer cooperatives. S. 802, Sensible Environmental Protection Act of 2013; provisions relating to agriculture and farmer cooperatives. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commodity Futures Trading Commission (CFTC),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR) | 319508 | 0 | 0 | 2013-10-18T15:04:40.907000-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);