lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
11 rows where filing_uuid = "3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2606617 | NATIONAL COUNCIL OF FARMER COOPERATIVES 3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce | Q1 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2021 | first_quarter | TEC | Boradband, issues important to farmer cooperatives and rural America | 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,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 380100 | 0 | 0 | 2021-04-19T18:23:46.870000-04:00 | |
| 2606618 | NATIONAL COUNCIL OF FARMER COOPERATIVES 3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce | Q1 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2021 | first_quarter | RET | Issues relating to pension premiums paid by farmer cooperatives; provisions relating to and impacting 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,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 380100 | 0 | 0 | 2021-04-19T18:23:46.870000-04:00 | |
| 2606619 | NATIONAL COUNCIL OF FARMER COOPERATIVES 3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce | Q1 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2021 | first_quarter | TRD | USDA Market Promotion and Export Programs; provisions and regulations affecting agriculture and farmer cooperatives WTO, provisions and regulations affecting agriculture and farmer cooperatives USDA import/export requirements affecting agriculture and farmer cooperatives U.S. China Negotiations; provisions and regulations affecting agriculture and farmer cooperatives Potential bi-lateral trade negotiations; issues related to agriculture and farmer cooperatives FY 2022 Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations; 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,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 380100 | 0 | 0 | 2021-04-19T18:23:46.870000-04:00 | |
| 2606620 | NATIONAL COUNCIL OF FARMER COOPERATIVES 3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce | Q1 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2021 | first_quarter | AGR | Dodd-Frank Wall Street Reform and Consumer Protections Act; implementation and provisions related to Title 7 Implementation by USDA of the 2018 Farm Bill; provisions impacting agriculture and farmer cooperatives Congressional and Administrative response to COVID-19 pandemic; issues impacting agriculture and farmer cooperatives Implementation of the American Recovery Plan; issues pertaining to agriculture and farmer cooperatives FY 2022 Appropriations; programs pertaining to 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,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 380100 | 0 | 0 | 2021-04-19T18:23:46.870000-04:00 | |
| 2606621 | NATIONAL COUNCIL OF FARMER COOPERATIVES 3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce | Q1 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2021 | first_quarter | TAX | Regulations under Section 199A; provisions and regulations affecting agriculture and farmer cooperatives H.R. 1712 and S. 617, the Death Tax Repeal Act; support for maintaining stepped-up basis; provisions and regulations affecting agriculture and farmer cooperatives Issues surrounding maintaining section 1031 like-kind exchanges for farm property; issues and regulations impacting agriculture and farmer cooperatives Issues surrounding climate change legislation and tax incentives for carbon sequestration/GHG emissions reductions; issues and regulations impacting 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,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 380100 | 0 | 0 | 2021-04-19T18:23:46.870000-04:00 | |
| 2606622 | NATIONAL COUNCIL OF FARMER COOPERATIVES 3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce | Q1 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2021 | first_quarter | TRA | Proposed infrastructure improvement and legislation and regulations; provisions relating to agriculture and farmer cooperatives H.R. 7575, Water Resources Development Act of 2020; provisions relating to agriculture and farmer cooperatives Federal Motor Carrier Safety Administration; Hours of Service rules; issues relating to and impacting agriculture and farmer cooperatives Federal Maritime Commission; issues relating to and impacting agriculture and farmer cooperatives Drive Safe Act (S. 659, H.R. 1745); issues relating to and impacting 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,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 380100 | 0 | 0 | 2021-04-19T18:23:46.870000-04:00 | |
| 2606623 | NATIONAL COUNCIL OF FARMER COOPERATIVES 3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce | Q1 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2021 | first_quarter | CHM | Federal Insecticide, Fungicide, and Rodenticide Act (FIFRA); provisions relating to and impacting 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,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 380100 | 0 | 0 | 2021-04-19T18:23:46.870000-04:00 | |
| 2606624 | NATIONAL COUNCIL OF FARMER COOPERATIVES 3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce | Q1 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2021 | first_quarter | IMM | H-2A Regulations; provisions and regulations affecting agriculture and farmer cooperatives Immigration reform proposals; provisions and regulations affecting agriculture and farmer cooperatives H.R. 1603 The Farm Workforce Modernization Act; provisions and regulations affecting agriculture and farmer cooperatives FY 2022, Department of Labor Appropriations and provisions related to farmer cooperatives Congressional and Administrative response to COVID-19 pandemic; issues impacting 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,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 380100 | 0 | 0 | 2021-04-19T18:23:46.870000-04:00 | |
| 2606625 | NATIONAL COUNCIL OF FARMER COOPERATIVES 3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce | Q1 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2021 | first_quarter | FOO | Buy America provisions of the William F. Goodling Child Nutrition Reauthorization Act of 1998; provisions relating to agriculture and farmer cooperatives Issues relating to the Richard B. Russell Child Nutrition Act; provisions relating to agriculture and farmer cooperatives 2020 Dietary Guidelines for Americans; provisions relating to agriculture and farmer cooperatives FY 2022 Agriculture, Rural Development, Food and Drug Administrations, and Related Agencies Appropriations; provisions relating to agriculture and farmer cooperatives Congressional and Administrative response to COVID-19 pandemic; issues impacting 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,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 380100 | 0 | 0 | 2021-04-19T18:23:46.870000-04:00 | |
| 2606626 | NATIONAL COUNCIL OF FARMER COOPERATIVES 3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce | Q1 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2021 | first_quarter | LBR | Issues relating to personal protective equipment (PPE) shortages for agricultural operations; regulations impacting farmer cooperatives Congressional and Administrative response to COVID-19 pandemic; issues impacting 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,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 380100 | 0 | 0 | 2021-04-19T18:23:46.870000-04:00 | |
| 2606627 | NATIONAL COUNCIL OF FARMER COOPERATIVES 3aa5f8af-2c24-4e4a-8bdf-a40ec64e80ce | Q1 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 27638 | NATIONAL COUNCIL OF FARMER COOPERATIVES | 2021 | first_quarter | CAW | Issues pertaining to climate and its impact in agriculture, food, and farmer co-ops; provisions and regulations affecting agriculture and farmer cooperatives Growing Climate Solutions Act of 2020; provisions and regulations 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,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),U.S. Trade Representative (USTR) | 380100 | 0 | 0 | 2021-04-19T18:23:46.870000-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);