lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "4037e0a9-ffd8-4e97-8066-e2bf5d08726b" and issue_code = "AGR" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 830518 | FARMERS EDUCATIONAL COOPERATIVE UNION OF AMERICA 4037e0a9-ffd8-4e97-8066-e2bf5d08726b | Q3 | FARMERS EDUCATIONAL COOPERATIVE UNION OF AMERICA | 14187 | FARMERS EDUCATIONAL COOPERATIVE UNION OF AMERICA | 2009 | third_quarter | AGR | Agriculture/food-related provisions of: H.R.503, to amend title 18, U.S. Code, to prohibit certain conduct in human consumption of horses. H.R.800, to amend 2008 Food, Conservation and Energy Act regarding vegetable/fruit production, processing. H.R.977, to amend Commodity Exchange Act to bring greater transparency and accountability to markets. H.R.1609, to amend 1985 Food Security Act to require income verification for persons getting USDA benefits. S.221, to amend Commodity Exchange Act to require energy commodities be traded only on regulated markets. S.272, to amend Commodity Exchange Act to ensure commodity transactions be on regulated markets. S.447, to amend Commodity Exchange Act to prevent excessive speculation for farm, energy commodities. S.460, amends 1946 Ag Marketing Act to help packer competition, transparency S.527, amends Clean Air Act to prohibit certain permits for agriculture production emissions. H.RES.317, to recognize Kansas-Missouri region as the Kansas City Animal Health Corridor. H.RES.507, supporting the goals of National Dairy Month. H.R.2448, to regulate energy commodities on futures markets and other purposes. H.R.2869, to prevent manipulation of energy markets. S. RES.174, to recognize Kansas-Missouri region as the Kansas City Animal Health Corridor. S.889, to amend the Agricultural Adjustment Act to determine milk prices. S.931, to amend title 9 of USC regarding arbitration. S.1062, to amend the Beef Research and Information Act to allow U.S. born-and-raised beef promotion. S.1086, to amend 1921 Packers and Stockyards Act, to prohibit use of certain anti-competitive contracts. S.1225, to prevent energy market manipulation. S.1330, to amend the 2008 Food, Conservation and Energy Act to increase certain milk program payments. S.1331, to amend the 2008 Food, Conservation and Energy Act to index for inflation certain milk payments. S.1375, to amend the 1987 Agricultural Credit Act to reauthorize state mediation programs. H.R.3166, to amend 2008 Food, Conservation and energy Act… | Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Bureau of Indian Affairs (BIA),Commodity Futures Trading Commission (CFTC),Council of Economic Advisers (CEA),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Farm Credit Administration,Federal Emergency Management Agency (FEMA),Federal Reserve System,Federal Trade Commission (FTC),Food & Drug Administration (FDA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Maritime Administration (MARAD),Natl Aeronautics & Space Administration (NASA),Occupational Safety & Health Administration (OSHA),Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Surface Transportation Board (STB),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Immigration & Customs Enforcement (ICE),U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 280000 | 0 | 0 | 2009-10-16T09:23:12-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);