legislation
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
32 rows where bill_type = "sconres", congress = 96 and policy_area = "International Affairs" sorted by introduced_date descending
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96-sconres-129 | 96 | sconres | 129 | A concurrent resolution relating to the recent curtailment of Jewish emigration by the Government of the Union of Soviet Socialist Republics. | International Affairs | 1980-09-25 | 1980-09-25 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Church, Frank [D-ID] | ID | D | C000388 | 0 | Deplores the recent curtailment of Jewish emigration from the Soviet Union. Urges executive branch officials to express U.S. opposition to such repression. Urges the President to instruct the U.S. delegation to the Madrid meeting of the Conference on Security and Cooperation in Europe to seek an explanation of Soviet emigration policies and protest violations of the family reunification provisions of the Helsinki Final Act. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/129 |
| 96-sconres-120 | 96 | sconres | 120 | A concurrent resolution congratulating the people of Poland on the successful conclusion of the strike. | International Affairs | 1980-09-03 | 1980-09-03 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Heinz, John [R-PA] | PA | R | H000456 | 33 | Congratulates Polish workers on the successful completion of their strikes. Urges the Polish government to respect the agreement. Calls upon other nations to not interfere in Poland's internal affairs. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/120 |
| 96-sconres-116 | 96 | sconres | 116 | A concurrent resolution expressing the sense of the Congress on the Baltic States question. | International Affairs | 1980-08-26 | 1980-08-26 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Thurmond, Strom [R-SC] | SC | R | T000254 | 2 | Declares the sense of the Congress that the President and the Secretary of State should take all necessary steps to: (1) bring the Baltic States question before the United Nations; and (2) urge the United Nations to request the Soviet Union to withdraw all non-native troops, agents, colonists, and controls from the Republics of Lithuania, Latvia, and Estonia, and to return all Baltic exiles from Siberia and from prisons and labor camps in the Soviet Union. Requires the Secretary of State to do his utmost to bring the matter of the Baltic States to the attention of all nations by means of special radio programs and publications. Declares that the United States should not agree to the recognition of the Soviet Union's annexation of Lithuania, Latvia, and Estonia. Directs the President to take steps to provide that all maps of Europe show the Republics of Lithuania, Latvia, and Estonia as independent states. Calls for a return of self-determination to the peoples of Lithuania, Latvia, and Estonia through free elections conducted under the auspices of the United Nations. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/116 |
| 96-sconres-117 | 96 | sconres | 117 | A concurrent resolution expressing the sense of the Congress that the President should convey to the Soviet Government the deep concern of the Congress and the American people for the fate of Raoul Wallenberg and that the United States delegation to the Madrid Conference on Security and Cooperation in Europe should urge consideration of the case of Raoul Wallenberg at that meeting by the signatories to the Helsinki Final Act. | International Affairs | 1980-08-26 | 1980-11-19 | Measure indefinitely postponed in Senate (See H.Con.Res. 434 for similar provisions). | Senate | Sen. Moynihan, Daniel Patrick [D-NY] | NY | D | M001054 | 9 | Expresses the sense of Congress that: (1) the President should express to the Soviet Government U.S. concern for the fate of Raoul Wallenberg; and (2) the U.S. delegation to the Madrid meeting of the Conference on Security and Cooperation in Europe should urge the consideration of the Wallenberg case. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/117 |
| 96-sconres-114 | 96 | sconres | 114 | A concurrent resolution to express the sense of the Congress with the respect to the independence and integrity of the people and government of Jamaica. | International Affairs | 1980-08-04 | 1980-08-04 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Stone, Richard (Dick) [D-FL] | FL | D | S000962 | 2 | Extends U.S. congratulations to Jamaica on its 18th anniversary of independence. Encourages Jamaica's commitment to peaceful change through elections. Supports Jamaica's efforts to protect its heritage from outside influence. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/114 |
| 96-sconres-110 | 96 | sconres | 110 | A concurrent resolution to honor Raoul Wallenberg and to request that the Department of State take all possible action to obtain information concerning his present status and secure his release. | International Affairs | 1980-07-28 | 1980-07-28 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Boschwitz, Rudy [R-MN] | MN | R | B000647 | 0 | Honors Raoul Wallenberg for his work in Hungary during World War II. Requests the State Department to discover the whereabouts of Raoul Wallenberg from the Soviet Union and secure his return to Sweden. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/110 |
| 96-sconres-97 | 96 | sconres | 97 | A Concurrent Resolution relative to the situation in Kampuchea. | International Affairs | 1980-05-30 | 1980-05-30 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. McGovern, George [D-SD] | SD | D | M000452 | 0 | Expresses the sense of Congress, with regard to Kampuchea (Cambodia), concerning: (1) humanitarian assistance; (2) an international conference to end the fighting; (3) withdrawal of foreign forces; (4) a new government acceptable to the people; and (5) United Nations action to protect human rights. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/97 |
| 96-sconres-96 | 96 | sconres | 96 | A concurrent resolution calling on the President of the United States to proclaim the week of July 21-27, 1980 as "Afghanistan Relief Week", to focus the attention and concern of the American people and the world community on the need to assist the Afghan refugees in their struggle for survival. | International Affairs | 1980-05-22 | 1980-05-22 | Referred to Senate Committee on the Judiciary. | Senate | Sen. Pell, Claiborne [D-RI] | RI | D | P000193 | 3 | Requests the President to designate the week of July 21 through July 27, 1980, as "Afghanistan Relief Week." | 2025-07-21T19:32:26Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/96 |
| 96-sconres-88 | 96 | sconres | 88 | A concurrent resolution stating that the Congress does favor the submission of the President with respect to the Second Amendment for Co-operation Between the International Atomic Energy Agency and the United States of America of May 11, 1959, done at Vienna, Austria, on January 14, 1980. | International Affairs | 1980-04-21 | 1980-04-29 | Referred to House Committee on Foreign Affairs. | Senate | Sen. Church, Frank [D-ID] | ID | D | C000388 | 0 | Declares that Congress favors the President's submission of the text of the Second Amendment to the Agreement for Co-operation Between the International Atomic Energy Agency and the United States. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/88 |
| 96-sconres-85 | 96 | sconres | 85 | A concurrent resolution expressing the sense of the Congress that the United Nations General Assembly should seek advisory opinions of the International Court of Justice on questions of international law arising in national courts and tribunals, and for other purposes. | International Affairs | 1980-04-02 | 1980-04-02 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Cranston, Alan [D-CA] | CA | D | C000877 | 0 | Expresses the sense of Congress that the President should: (1) direct the U.S. representative to the United Nations to propose the establishment of a Special Committee to seek advisory opinions of the International Court of Justice regarding questions of international law, submitted by national courts; and (2) after such Committee is established, propose legislation to the Congress authorizing Federal courts to request such advisory opinions. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/85 |
| 96-sconres-79 | 96 | sconres | 79 | A concurrent resolution expressing the sense of the Congress that the people of the United States should observe February 26, 1980, as a national day of prayer and meditation for the hostages in Iran. | International Affairs | 1980-02-21 | 1980-03-17 | House agreed to Senate amendments. | Senate | Sen. Boschwitz, Rudy [R-MN] | MN | R | B000647 | 12 | (Senate agreed to House amendments with an amendment) Declares March 18, 1980, as a national day of prayer, meditation, and unity for the hostages being held in Iran. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/79 |
| 96-sconres-78 | 96 | sconres | 78 | A concurrent resolution expressing the sense of the Congress that the Government and people of the United States reaffirm support for the well-being and independence of the Republic of Tunisia. | International Affairs | 1980-02-20 | 1980-02-20 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Stone, Richard (Dick) [D-FL] | FL | D | S000962 | 1 | Expresses the sense of the Congress that the Government and people of the United States reaffirm their friendship for and express their support for the continuing independence of Tunisia. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/78 |
| 96-sconres-74 | 96 | sconres | 74 | A concurrent resolution expressing the gratitude of the American people to Canada and her embassy and Ambassador to Iran. | International Affairs | 1980-02-04 | 1980-02-21 | Measure indefinitely postponed in Senate. | Senate | Sen. Heinz, John [R-PA] | PA | R | H000456 | 0 | Expresses the sense of the Congress that the President further express his gratitude to Canada and award the President's Medal of Freedom to Kenneth Taylor, the Canadian Ambassador to Iran. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/74 |
| 96-sconres-72 | 96 | sconres | 72 | A concurrent resolution expressing the sense of the Congress that the President should request the United Nations to establish an international presence in the refugee encampments on the border between Thailand and Kampuchea, and for other purposes. | International Affairs | 1980-01-31 | 1980-02-26 | Measure passed House, roll call #75 (388-1). | Senate | Sen. Levin, Carl [D-MI] | MI | D | L000261 | 9 | Expresses the sense of Congress that the President should request the United Nations to establish an international presence in the Khmer refugee camps on the Thailand - Kampuchea (Cambodia) border to promote security and oversee the distribution of food. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/72 |
| 96-sconres-71 | 96 | sconres | 71 | A concurrent resolution stating the objection of the Congress to certain proposed sales of defense articles to Morocco. | International Affairs | 1980-01-29 | 1980-01-29 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. McGovern, George [D-SD] | SD | D | M000452 | 0 | Objects to the proposed sale of specified aircraft and helicopters to Morocco. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/71 |
| 96-sconres-64 | 96 | sconres | 64 | A concurrent resolution expressing the sense of the Congress with respect to the invasion of Afghanistan by the Soviet Union. | International Affairs | 1980-01-22 | 1980-01-22 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Weicker, Lowell P., Jr. [R-CT] | CT | R | W000253 | 0 | Expresses the sense of Congress that: (1) the United States should not participate in the 1980 summer Olympics, unless Soviet troops are withdrawn from Afghanistan; and (2) further economic restrictions against the Soviet Union should be imposed, including an embargo of exports from the United States. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/64 |
| 96-sconres-60 | 96 | sconres | 60 | A concurrent resolution expressing the sense of the Congress with respect to the treatment of Christians by the Union of Soviet Socialist Republics, and for other purposes. | International Affairs | 1979-12-10 | 1980-12-01 | Referred to House Committee on Foreign Affairs. | Senate | Sen. Jepsen, Roger W. [R-IA] | IA | R | J000101 | 29 | (Measure passed Senate, amended) Expresses the sense of Congress that the President should: (1) continue to affirm U.S. support for full implementation of the Helsinki Accords; (2) communicate to the Soviet Union U.S. disapproval of religious harassment of persons, including Christians, in the Soviet Union and of the restrictions on such persons' freedom to emigrate; and (3) advise the Soviet Union of U.S. expectation that the Soviet Union honor its commitments under the Helsinki Accords and under international law. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/60 |
| 96-sconres-59 | 96 | sconres | 59 | A concurrent resolution calling for an international conference on Cambodia. | International Affairs | 1979-12-05 | 1979-12-19 | Measure indefinitely postponed in Senate (See H. Con. Res. 219. | Senate | Sen. Kennedy, Edward M. [D-MA] | MA | D | K000105 | 4 | Requests the President to work with the Secretary General of the United Nations and other nations to convene an international conference on Cambodia: (1) to bring an end to the conflict in Southeast Asia; and (2) to consider the needs of the Khmer people. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/59 |
| 96-sconres-58 | 96 | sconres | 58 | A concurrent resolution expressing the sense of the Congress with respect to the protection of the premises of diplomatic missions. | International Affairs | 1979-11-30 | 1979-11-30 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Sasser, Jim [D-TN] | TN | D | S000068 | 0 | Expresses the sense of Congress that the President should: (1) negotiate with foreign states for an agreement for mutual and reciprocal diplomatic security arrangements; and (2) obtain multilateral support for the establishment of a permanent diplomatic security corps under the auspices of the United Nations. Sets forth the function of such security corps. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/58 |
| 96-sconres-52 | 96 | sconres | 52 | A concurrent resolution stating the rejection by the Congress of the determination of the President with respect to sanctions against Zimbabwe-Rhodesia. | International Affairs | 1979-11-15 | 1979-11-15 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Hayakawa, Samuel Ichiye [R-CA] | CA | R | H000384 | 0 | Rejects the President's determination that terminating sanctions against Zimbabwe-Rhodesia would not be in the U.S. national interest. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/52 |
| 96-sconres-51 | 96 | sconres | 51 | A concurrent resolution stating the rejection by the Congress of the determination of the President with respect to sanctions against Zimbabwe-Rhodesia. | International Affairs | 1979-11-14 | 1979-12-04 | Reported to Senate from the Committee on Foreign Relations, S. Rept. 96-448. | Senate | Sen. Helms, Jesse [R-NC] | NC | R | H000463 | 0 | Rejects the President's determination that terminating sanctions against Zimbabwe-Rhodesia would not be in the U.S. national interest. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/51 |
| 96-sconres-49 | 96 | sconres | 49 | A concurrent resolution relating to the Iranian crisis and the world response. | International Affairs | 1979-11-13 | 1979-11-13 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Dole, Robert J. [R-KS] | KS | R | D000401 | 0 | Supports the actions taken by the President in attempting to secure the release of U.S. citizens in Iran. Condemns the actions of Iran. Expresses the sense of Congress that the President should enlist international support in securing the release of such hostages by: (1) all nations withdrawing their diplomats from Iran; and (2) a world embargo on Iranian oil until Iran guarantees that all diplomats will be given immunity in accordance with the Vienna Convention on Diplomatic Relations of 1961. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/49 |
| 96-sconres-43 | 96 | sconres | 43 | A concurrent resolution honoring the Fourteenth Centennial of Islam. | International Affairs | 1979-10-04 | 1979-10-16 | Measure passed Senate. | Senate | Sen. Stone, Richard (Dick) [D-FL] | FL | D | S000962 | 0 | (Reported to Senate from the Committee on Foreign Relations (without written report)) Recognizes the contribution of Islam to mankind. Wishes success to the Fourteenth Centennial commemoration of Islam. Pledges congressional efforts to achieve improved relations with all nations of the world. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/43 |
| 96-sconres-42 | 96 | sconres | 42 | A concurrent resolution relating to the presence of Soviet military personnel in Cuba, and for other purposes. | International Affairs | 1979-09-27 | 1979-09-27 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Humphrey, Gordon J. [R-NH] | NH | R | H000951 | 4 | Expresses the sense of Congress that the President should report to Congress: (1) monthly concerning the military capabilities of Soviet troops in Cuba; and (2) annually concerning Soviet military assistance to Cuba and the military capabilities of Cuban troops. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/42 |
| 96-sconres-32 | 96 | sconres | 32 | A concurrent resolution congratulating the European Parliament. | International Affairs | 1979-07-18 | 1979-07-18 | Measure indefinitely postponed in Senate, H.Con.Res. 159 passed in lieu. | Senate | Sen. Biden, Joseph R., Jr. [D-DE] | DE | D | B000444 | 0 | Welcomes and congratulates the first directly elected Parliament of the European Community. Pledges congressional support for continued close relations with such Parliament. | 2021-06-14T19:48:41Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/32 |
| 96-sconres-24 | 96 | sconres | 24 | A concurrent resolution expressing the sense of the Congress on the nonenforcement of sanctions against Zimbabwe Rhodesia. | International Affairs | 1979-04-23 | 1979-04-23 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Schweiker, Richard S. [R-PA] | PA | R | S000159 | 17 | Declares that Zimbabwe Rhodesia has: (1) demonstrated its willingness to negotiate in good faith at an all parties conference; and (2) approved through elections transferring power to a black majority government. Expresses the sense of Congress that the President: (1) should determine that Zimbabwe Rhodesia is in substantial compliance with the International Security Assistance Act of 1978; and (2) should not enforce sanctions against Zimbabwe Rhodesia. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/24 |
| 96-sconres-17 | 96 | sconres | 17 | A concurrent resolution to express the sense of the Congress that a United Nations special investigatory commission should be established to secure a full accounting of Americans listed as missing in Southeast Asia. | International Affairs | 1979-03-29 | 1979-07-18 | Measure indefinitely postponed in Senate, H.Con.Res. 10 passed in lieu. | Senate | Sen. Dole, Robert J. [R-KS] | KS | R | D000401 | 12 | Declares it the sense of the Congress that the Secretary of State should seek the good offices of the Secretary General of the United Nations for the purpose of establishing a special investigatory commission charged with the responsibility of securing a full accounting of Americans listed as missing in Southeast Asia. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/17 |
| 96-sconres-12 | 96 | sconres | 12 | A concurrent resolution regarding the Panama Canal Treaties. | International Affairs | 1979-03-15 | 1979-03-15 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Helms, Jesse [R-NC] | NC | R | H000463 | 0 | Expresses the sense of Congress that the President withdraw the instruments of ratification of the Panama Canal treaties of 1977. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/12 |
| 96-sconres-13 | 96 | sconres | 13 | A concurrent resolution expressing the sense of the Congress with respect to the United Nations report on genocide. | International Affairs | 1979-03-15 | 1979-03-15 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Levin, Carl [D-MI] | MI | D | L000261 | 0 | Expresses the sense of Congress that the United Nations Commission on Human Rights should include a description of the Armenian genocide in their study of the prevention and punishment of genocide. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/13 |
| 96-sconres-9 | 96 | sconres | 9 | A concurrent resolution relating to freedom of religion in the Ukraine. | International Affairs | 1979-03-07 | 1979-03-07 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Goldwater, Barry [R-AZ] | AZ | R | G000267 | 12 | Declares the sense of Congress that the President shall take steps to: (1) call upon the Soviet Union to permit the resurrection of the Ukrainian Orthodox and Catholic Churches; (2) contact the officials of the Soviet Union to secure freedom of worship in the Soviet Union and Eastern Europe; and (3) raise the question of Stalin's liquidation of such churches with national and international religious councils. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/9 |
| 96-sconres-7 | 96 | sconres | 7 | A concurrent resolution expressing the sense of the Congress of the United States on the lifting of sanctions against Zimbabwe-Rhodesia. | International Affairs | 1979-02-09 | 1979-02-09 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Schweiker, Richard S. [R-PA] | PA | R | S000159 | 13 | Expresses the sense of Congress that the President should: (1) find Rhodesia in compliance with the International Security Assistance Act of 1978; (2) find that approval for the Zimbabwe Constitution has been secured; and (3) revoke sanctions against Zimbabwe within ten days of the scheduled free elections. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/7 |
| 96-sconres-2 | 96 | sconres | 2 | A concurrent resolution to uphold the separation of powers between the executive and legislative branches of Government in the termination of treaties. | International Affairs | 1979-01-18 | 1979-01-18 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Goldwater, Barry [R-AZ] | AZ | R | G000267 | 21 | Provides that, in accordance with the separation of powers under the Constitution, the President should not unilaterally take any action abrogating or affecting the validity of any of the security treaties comprising the post-World War II complex of treaties, including mutual defense treaties, without the advice and consent of the Senate or approval of Congress. | 2025-01-14T19:00:46Z | https://www.congress.gov/bill/96th-congress/senate-concurrent-resolution/2 |
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);