openregs: legislation: 7 rows where bill_type = "sjres", congress = 107 and policy_area = "International Affairs" sorted by introduced

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

7 rows where bill_type = "sjres", congress = 107 and policy_area = "International Affairs" sorted by introduced_date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
107-sjres-50	107	sjres	50	A joint resolution expressing the sense of the Senate with respect to human rights in Central Asia.	International Affairs	2002-10-17	2002-10-17	Referred to the Committee on Foreign Relations. (text of measure as introduced: CR S10728-10729)	Senate	Sen. McCain, John [R-AZ]	AZ	R	M000303	1	Calls for the Governments of Kazakhstan, Kyrgyzstan, Tajikistan, Turkmenistan, and Uzbekistan to accelerate democratic reforms and fulfill their human rights obligations. Declares that increased levels of U.S. assistance to the Central Asian governments made possible by their cooperation in the war in Afghanistan can be sustained only if there is substantial and continuing progress towards meeting these goals.Calls for the President of the United States, the Secretary of State, and the Secretary of Defense to: (1) continue to raise specific cases of political and religious persecution with the Central Asian governments and urge greater respect for human rights and democratic freedoms; (2) consider progress in meeting such goals when determining diplomatic engagement and foreign assistance; (3) ensure that provisions of the Foreign Operations Appropriations Act are fully implemented to ensure that no U.S. assistance benefits security forces in Central Asia implicated in human rights violations; (4) follow the recommendations of the United States Commission on International Religious Freedom by designating Turkmenistan a Country of Particular Concern under the International Religious Freedom Act of 1998 and by making clear that Uzbekistan risks designation if conditions there do not improve; (5) work with the Government of Kazakhstan to create a political climate free of intimidation and harassment and to reduce official corruption; and (6) support through U.S. assistance programs those individuals, non-governmental organizations, and media outlets in Central Asia working to build more open societies, support the victims of human rights abuses, and expose official corruption.	2025-01-14T19:00:46Z	https://www.congress.gov/bill/107th-congress/senate-joint-resolution/50
107-sjres-46	107	sjres	46	Authorization for the Use of Military Force Against Iraq	International Affairs	2002-10-02	2002-10-03	Read the second time. Placed on Senate Legislative Calendar under General Orders. Calendar No. 630.	Senate	Sen. Lieberman, Joseph I. [D-CT]	CT	D	L000304	16	Authorization for the Use of Military Force Against Iraq - Expresses support for the President's efforts to: (1) strictly enforce through the United Nations Security Council all relevant Security Council resolutions applicable to Iraq; and (2) obtain prompt and decisive action by the Security Council to ensure that Iraq abandons its strategy of delay, evasion, and noncompliance and promptly and strictly complies with all relevant Security Council resolutions.Authorizes the President to use the U.S. armed forces to: (1) defend U.S. national security against the continuing threat posed by Iraq; and (2) enforce all relevant Security Council resolutions regarding Iraq. Directs the President, prior to or as soon as feasible (but not later than 48 hours) after exercising such authority, to make available to the Speaker of the House of Representatives and the President pro tempore of the Senate his determination that: (1) reliance on further diplomatic or peaceful means alone will not achieve the above purposes; and (2) acting pursuant to this resolution is consistent with the United States and other countries continuing to take necessary actions against international terrorists and terrorist organizations, including those who planned, authorized, committed, or aided the terrorist attacks of September 11, 2001. Declares that this section is intended to constitute specific statutory authorization for use of the armed forces, consistent with requirements of the War Powers Resolution.Requires the President to report to Congress at least every 60 days on matters relevant to this resolution.	2025-08-19T17:29:58Z	https://www.congress.gov/bill/107th-congress/senate-joint-resolution/46
107-sjres-45	107	sjres	45	Further Resolution on Iraq	International Affairs	2002-09-26	2002-10-11	Indefinitely postponed by Senate by Unanimous Consent.	Senate	Sen. Daschle, Thomas A. [D-SD]	SD	D	D000064	1	Further Resolution on Iraq - Authorizes the President to use all appropriate means, including force, to enforce United Nations Security Council Resolutions concerning Iraq, defend U.S. national security interests against the threat posed by Iraq, and restore international peace and security in the region.	2025-08-19T17:32:11Z	https://www.congress.gov/bill/107th-congress/senate-joint-resolution/45
107-sjres-41	107	sjres	41	A joint resolution calling for Congress to consider and vote on a resolution for the use of force by the United States Armed Forces against Iraq before such force is deployed.	International Affairs	2002-07-18	2002-07-18	Read twice and referred to the Committee on Foreign Relations. (consideration: CR 7/22/2002 S7165-7166)	Senate	Sen. Specter, Arlen [R-PA]	PA	R	S000709	3	Calls on Congress to consider and vote on a resolution authorizing the use of force by the U.S. armed forces against Iraq before such force is deployed against Iraq.	2025-04-07T13:37:20Z	https://www.congress.gov/bill/107th-congress/senate-joint-resolution/41
107-sjres-27	107	sjres	27	A joint resolution relating to the political, economic, and military relations of the United States with Nicaragua.	International Affairs	2001-10-31	2001-10-31	Read twice and referred to the Committee on Foreign Relations.	Senate	Sen. Helms, Jesse [R-NC]	NC	R	H000463	2	Directs the President to communicate to the Government of Nicaragua that the U.S. Government will review and modify its political, economic, and military relations with, and its support through multilateral institutions for, Nicaragua if: (1) the November 4, 2001 elections in Nicaragua are not deemed by the international community to be free and fair; or (2) the President determines that U.S. anti-terrorist and anti-narcotics efforts in Nicaragua and the region are in jeopardy.	2025-01-14T19:00:46Z	https://www.congress.gov/bill/107th-congress/senate-joint-resolution/27
107-sjres-17	107	sjres	17	A joint resolution providing for congressional disapproval of the rule submitted by the President relating to the restoration of the Mexico City Policy.	International Affairs	2001-06-22	2001-06-22	Read twice and referred to the Committee on Foreign Relations.	Senate	Sen. Boxer, Barbara [D-CA]	CA	D	B000711	1	Disapproves and nullifies the rule submitted by the President relating to the restoration of the Mexico City Policy (which denies funding to any organization that uses its own funds to provide or promote abortion services overseas).	2025-01-14T19:00:46Z	https://www.congress.gov/bill/107th-congress/senate-joint-resolution/17
107-sjres-9	107	sjres	9	A joint resolution providing for congressional disapproval of the rule submitted by the United States Agency for International Development relating to the restoration of the Mexico City Policy.	International Affairs	2001-03-20	2001-03-20	Read twice and referred to the Committee on Foreign Relations. (text of measure as introduced: CR S2595)	Senate	Sen. Boxer, Barbara [D-CA]	CA	D	B000711	6	Disapproves and nullifies the rule submitted by the United States Agency for International Development relating to the restoration of the Mexico City Policy (which denies funding to any organization that uses its own funds to provide or promote abortion services overseas).	2025-04-07T13:37:20Z	https://www.congress.gov/bill/107th-congress/senate-joint-resolution/9

Advanced export

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

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