legislation

Congressional bills and resolutions from Congress.gov, filtered to policy areas relevant to environmental, health, agriculture, and wildlife regulation.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

3 rows where bill_type = "sjres", congress = 94 and policy_area = "Foreign Trade and International Finance" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Foreign Trade and International Finance · 3 ✖

congress 1

bill_type 1

  • sjres · 3 ✖
bill_id congress bill_type bill_number title policy_area introduced_date ▲ latest_action_date latest_action_text origin_chamber sponsor_name sponsor_state sponsor_party sponsor_bioguide_id cosponsor_count summary_text update_date url
94-sjres-136 94 sjres 136 A joint resolution to repeal the China Trade Act, 1922. Foreign Trade and International Finance 1975-10-01 1975-10-01 Referred to Senate Committee on Commerce. Senate Sen. Moss, Frank E. [D-UT] UT D M001033 1 Repeals the China Trade Act of 1922 which provides incentives to promote trade with China. 2025-01-14T18:51:33Z https://www.congress.gov/bill/94th-congress/senate-joint-resolution/136
94-sjres-81 94 sjres 81 A joint resolution to regulate commerce by prohibiting the importation into the United States of any fish or fish products by any foreign enterprise which engages in commercial whaling activities, and for other purposes. Foreign Trade and International Finance 1975-05-12 1975-05-12 Referred to Senate Committee on Finance. Senate Sen. Magnuson, Warren G. [D-WA] WA D M000053 5 Directs the Secretary of Commerce to carry out an investigation to identify foreign enterprises engaged in commercial whaling. Provides that it shall be unlawful for any fish or fish products produced, owned or distributed by such enterprise to be imported into the United States. Authorizes the Secretary to issue and amend regulations to carry out the purposes of this resolution. 2025-01-14T18:51:33Z https://www.congress.gov/bill/94th-congress/senate-joint-resolution/81
94-sjres-12 94 sjres 12 A joint resolution to prohibit for a period of 60 days the imposition of tariffs, fees, and quotas on oil imports and the lifting of all price controls on domestic oil, and to thereafter require the submission to, and the right of approval of the Congress of any such action within 30 days. Foreign Trade and International Finance 1975-01-23 1975-02-20 Measure placed on calender in Senate under "Subjects on the Table". Senate Sen. Kennedy, Edward M. [D-MA] MA D K000105 54 Provides that no new tariff, fee or other charge, no increase in existing tariffs, fees or other charges, and no new quota or other limitation on imports of crude oil or petroleum products other than those in effect on January 1, 1975, may be imposed unless: (1) such action is specifically authorized by law enacted after the date of enactment of this joint resolution; or (2) the specific action proposed to be taken is submitted to both Houses of the Congress. States that if such action is disapproved by either House within the thirty-day review period, no officer or agency shall have authority to take any action inconsistent with the provisions of this joint resolution. 2024-08-01T19:34:16Z https://www.congress.gov/bill/94th-congress/senate-joint-resolution/12

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE legislation (
    bill_id TEXT PRIMARY KEY,
    congress INTEGER,
    bill_type TEXT,
    bill_number INTEGER,
    title TEXT,
    policy_area TEXT,
    introduced_date TEXT,
    latest_action_date TEXT,
    latest_action_text TEXT,
    origin_chamber TEXT,
    sponsor_name TEXT,
    sponsor_state TEXT,
    sponsor_party TEXT,
    sponsor_bioguide_id TEXT,
    cosponsor_count INTEGER DEFAULT 0,
    summary_text TEXT,
    update_date TEXT,
    url TEXT
);
CREATE INDEX idx_leg_congress ON legislation(congress);
CREATE INDEX idx_leg_type ON legislation(bill_type);
CREATE INDEX idx_leg_policy ON legislation(policy_area);
CREATE INDEX idx_leg_date ON legislation(introduced_date);
CREATE INDEX idx_leg_sponsor ON legislation(sponsor_name);
CREATE INDEX idx_leg_sponsor_bioguide ON legislation(sponsor_bioguide_id);