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 = "hjres", congress = 109 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

  • hjres · 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
109-hjres-79 109 hjres 79 Disapproving the results of the review conducted by the Committee on Foreign Investment in the United States (CFIUS) into the purchase of Peninsular and Oriental Steam Navigation (P&O) by Dubai Ports World (DP World). Foreign Trade and International Finance 2006-02-28 2006-03-21 Referred to the Subcommittee on Domestic and International Monetary Policy, Trade, and Technology. House Rep. Harman, Jane [D-CA-36] CA D H000213 1 Disapproves the Committee on Foreign Investment in the United States (CFIUS) review of the purchase by Dubai Ports World (DP World) of Peninsular and Oriental Steam Navigation (P&O) (which conducts operations at 21 U.S. ports, including leasing agreements for terminal operations in New York, Newark, Baltimore, New Orleans, Miami, and Philadelphia). Directs CFIUS to: (1) withdraw its statement of no objection related to the purchase; and (2) conduct a 45-day investigation, pursuant to the Defense Production Act of 1950, in order to ensure that the purchase will not have an adverse effect on U.S. national security. Directs CFIUS to brief Members of Congress on the findings of its investigation before the purchase is allowed to proceed. 2023-01-13T04:49:12Z https://www.congress.gov/bill/109th-congress/house-joint-resolution/79
109-hjres-52 109 hjres 52 Approving the renewal of import restrictions contained in the Burmese Freedom and Democracy Act of 2003. Foreign Trade and International Finance 2005-05-26 2005-07-27 Became Public Law No: 109-39. House Rep. Lantos, Tom [D-CA-12] CA D L000090 46 (This measure has not been amended since it was introduced. The summary of that version is repeated here.) Approves the renewal of certain import restrictions contained in the Burmese Freedom and Democracy Act of 2003. 2023-01-13T04:48:01Z https://www.congress.gov/bill/109th-congress/house-joint-resolution/52
109-hjres-27 109 hjres 27 Withdrawing the approval of the United States from the Agreement establishing the World Trade Organization. Foreign Trade and International Finance 2005-03-02 2005-06-09 Motion to reconsider laid on the table Agreed to without objection. House Rep. Sanders, Bernard [I-VT-At Large] VT I S000033 10 (This measure has not been amended since it was introduced. The summary of that version is repeated here.) Declares that Congress withdraws its approval, provided under the Uruguay Round Agreements Act, establishing the World Trade Organization (WTO). 2022-02-03T05:36:28Z https://www.congress.gov/bill/109th-congress/house-joint-resolution/27

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);