lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "47edaaa7-b47e-4c19-bc77-2204d35358e4" and issue_code = "TRD" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 598551 | FARMERS EDUCATIONAL COOPERATIVE UNION OF AMERICA 47edaaa7-b47e-4c19-bc77-2204d35358e4 | Q1 | FARMERS EDUCATIONAL COOPERATIVE UNION OF AMERICA | 14187 | FARMERS EDUCATIONAL COOPERATIVE UNION OF AMERICA | 2008 | first_quarter | TRD | Agriculture/food-related provisions of: H.RES.336, expresses that the U.S. should adhere to moral principles relating to international trade pacts. H.RES.587, expresses that the House should not at this time consider fast-track negotiating authority. H.RES.926, recognizes the importance of food, product safety and U.S. trade policy. H.J.RES.55, to disapprove a final rule on importation of cattle and beef. H.R.137, to amend title 18, U.S. Code, to strengthen prohibitions against animal fighting. H.R.169, to improve trade deficits between U.S. and other countries. H.R.294, to prohibit entry into bilateral or regional trade agreement for 2 years. H.R.321, to require Treasury to report on exchange rate policies of the PRC. H.R.624, to lift the trade embargo on Cuba. H.R.782, to amend title 7 of the 1930 Tariff Act. H.R.1026, to facilitate export of U.S. agricultural products to Cuba. H.R.1042, to extend trade promotion authority. H.R.1706, to assist U.S. exporters of certain fruits and vegetables. H.R.1830, to extend authorities of the Andean Trade Preference Act. H.R.2819, to facilitate export of U.S. agricultural products to Cuba. H.R.2844, to promote U.S. emergency and non-emergency food assistance programs. H.R.3182, to let the U.S. participate in energy development offshore from Cuba and other countries. H.R.3684, to enhance reciprocal market access for U.S. domestic producers in trade agreement negotiations. H.R.3688, to implement the U.S.-Peru Trade Promotion Agreement. H.R.4124, to direct withdrawal from the U.S.-Peru Trade Promotion Agreement. S.J.RES.20, to disapprove a rule relating to importation of cattle and beef. S.1106, to extend the additional duty on ethanol. S.1485, to impose tariff-rate quotas on certain casein and milk protein concentrates. S.1848, to amend the 1974 Trade Act to address the impact of globalization and other purposes. S.2113, to implement the U.S.-Peru Trade Promotion Agreement. Issues other than legislation: Trade (domestic/foreign) Agricultural trade issues for th… | 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) | 210369 | 0 | 0 | 2008-04-18T11:33: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);