legislation
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
33 rows where bill_type = "sconres" and policy_area = "Energy" sorted by introduced_date descending
This data as json, CSV (advanced)
Suggested facets: title, latest_action_text, sponsor_name, sponsor_state, sponsor_party, sponsor_bioguide_id, cosponsor_count, update_date, introduced_date (date), latest_action_date (date), update_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 113-sconres-21 | 113 | sconres | 21 | A concurrent resolution expressing the sense of Congress that construction of the Keystone XL pipeline and the Federal approvals required for the construction of the Keystone XL pipeline are in the national interest of the United States. | Energy | 2013-07-31 | 2013-07-31 | Referred to the Committee on Energy and Natural Resources. (text of measure as introduced: CR S6133-6134) | Senate | Sen. Landrieu, Mary L. [D-LA] | LA | D | L000550 | 12 | Expresses the sense of Congress that completion of the Keystone XL pipeline is in the national interest of the United States and its construction will promote: (1) sound investment in the infrastructure of the United States, and (2) energy security in North America and generate an increase in private sector jobs that will benefit both the region surrounding the Keystone XL pipeline and the United States as a whole. | 2023-01-11T13:24:21Z | |
| 110-sconres-3 | 110 | sconres | 3 | A concurrent resolution expressing the sense of Congress that it is the goal of the United States that, not later than January 1, 2025, the agricultural, forestry, and working land of the United States should provide from renewable resources not less than 25 percent of the total energy consumed in the United States and continue to produce safe, abundant, and affordable food, feed, and fiber. | Energy | 2007-01-17 | 2007-01-17 | Referred to the Committee on Agriculture, Nutrition, and Forestry. (text of measure as introduced: CR S705) | Senate | Sen. Salazar, Ken [D-CO] | CO | D | S001163 | 33 | Expresses the sense of Congress that it is the goal of the United States that not later than January 1, 2025, U.S. agricultural, forestry, and working land should provide from renewable resources not less than 25% of total U.S. energy consumption and continue to produce safe, abundant, and affordable food, feed, and fiber. | 2023-01-11T20:04:01Z | |
| 109-sconres-97 | 109 | sconres | 97 | A concurrent resolution expressing the sense of Congress that it is the goal of the United States that, not later than January 1, 2025, the agricultural, forestry, and working land of the United States should provide from renewable resources not less than 25 percent of the total energy consumed in the United States and continue to produce safe, abundant, and affordable food, feed, and fiber. | Energy | 2006-06-07 | 2006-06-07 | Read twice and referred to the Committee on Agriculture, Nutrition, and Forestry. (text of measure as introduced: CR S5605-5606) | Senate | Sen. Grassley, Chuck [R-IA] | IA | R | G000386 | 29 | Expresses the sense of Congress that it is the goal of the United States that by January 1, 2025, U.S. agricultural, forestry, and working land should provide from renewable resources not less than 25% of the total U.S. energy consumption and continue to produce safe, abundant, and affordable food, feed, and fiber. | 2023-01-13T04:50:35Z | |
| 108-sconres-141 | 108 | sconres | 141 | A concurrent resolution recognizing the essential role of nuclear power in the national energy policy of the United States and supporting the increased use of nuclear power and the construction and development of new and improved nuclear power generating plants. | Energy | 2004-10-06 | 2004-10-06 | Referred to the Committee on Energy and Natural Resources. | Senate | Sen. Domenici, Pete V. [R-NM] | NM | R | D000407 | 12 | Declares that Congress: (1) recognizes the essential role of nuclear power in the national energy policy of the United States; and (2) supports the increased use of nuclear power and the construction and development of new and improved nuclear power generating plants as a means of contributing to national energy independence and maintaining a clean environment. | 2023-01-14T22:48:34Z | |
| 106-sconres-88 | 106 | sconres | 88 | A concurrent resolution expressing the sense of Congress concerning drawdowns of the Strategic Petroleum Reserve. | Energy | 2000-03-02 | 2000-03-02 | Referred to the Committee on Energy and Natural Resources. (text of measure as introduced: CR S1128-1129) | Senate | Sen. Collins, Susan M. [R-ME] | ME | R | C001035 | 14 | Expresses the sense of Congress that the President and the Secretary of Energy should: (1) draw down the Strategic Petroleum Reserve (SPR) directly through time exchanges (swaps) or other means to combat unfair foreign trade practices of the Organization of Petroleum Exporting Countries (OPEC) and alleviate their severely deleterious consequences to people and businesses in the United States; and (2) prepare for future threats to the domestic economy and energy supply by developing methods to draw down the SPR when needed, and increase SPR crude oil quantity over time in an economically reasonable manner. | 2026-03-24T12:48:03Z | |
| 102-sconres-137 | 102 | sconres | 137 | A concurrent resolution to express the sense of Congress that the Comptroller General of the United States should conduct a study of the economic impacts of Order No. 636 of the Federal Energy Regulatory Commission on residential, commercial, and other end-users of natural gas, and that the Federal Energy Regulatory Commission should refrain from processing restructuring proceedings pursuant to the order during the 60-day period after the submittal to Congress of the results of the study. | Energy | 1992-09-22 | 1992-09-22 | Read twice and referred to the Committee on Energy and Natural Resources. | Senate | Sen. Wellstone, Paul D. [D-MN] | MN | D | W000288 | 2 | Expresses the sense of the Congress that: (1) the Comptroller General of the United States should study and report to the Congress on the economic impacts of a specified Federal Energy Regulatory Commission Order (FERC) upon natural gas end-users and the geographic regions of the United States; and (2) FERC should refrain from processing restructuring proceedings pursuant to such order during the 60-day period after the report is submitted to the Congress. | 2026-03-24T12:48:03Z | |
| 101-sconres-151 | 101 | sconres | 151 | A concurrent resolution expressing the sense of the Congress of the desirability of promoting energy efficiency and conservation, setting energy efficiency and conservation goals for the United States, and calling an energy summit. | Energy | 1990-10-03 | 1990-10-04 | Referred to Subcommittee on Energy Regulation. | Senate | Sen. Akaka, Daniel K. [D-HI] | HI | D | A000069 | 1 | Expresses the sense of the Congress that, in furtherance of the shared responsibility of the executive and legislative branches to oversee and develop energy efficiency and conservation policies, the Congress: (1) urges the President to convene a national energy summit including experts on the environment and energy from both governmental and private sectors; and (2) believes the National Energy Strategy being developed by the Department of Energy should be an important part of the discussion at the energy summit. | 2026-03-24T12:48:03Z | |
| 100-sconres-96 | 100 | sconres | 96 | An original concurrent resolution to express the sense of the Congress on the proposed revision of the United States agreement for nuclear cooperation with Japan. | Energy | 1988-01-20 | 1988-03-25 | Indefinitely postponed by Senate by Voice Vote. | Senate | Sen. Pell, Claiborne [D-RI] | RI | D | P000193 | 0 | Expresses the sense of the Congress that: (1) the United States' consent to Japanese use and transport of United States controlled plutonium under the proposed nuclear cooperation agreement is inconsistent with the Atomic Energy Act of 1954; and (2) the President must renegotiate the draft agreement or resubmit it to the Congress with an exemption of statutory requirements before it goes into effect. | 2025-01-14T19:00:46Z | |
| 100-sconres-36 | 100 | sconres | 36 | A concurrent resolution expressing the sense of Congress with respect to the use of ethanol and methanol in reducing air pollution, and for other purposes. | Energy | 1987-03-19 | 1987-03-19 | Referred to the Committee on Governmental Affairs. | Senate | Sen. Pressler, Larry [R-SD] | SD | R | P000513 | 6 | Expresses the sense of the Congress that the use of ethanol blended and methanol fuels should be established to reduce air pollution and surplus grain stocks and that such use should be encouraged through information and technical assistance. | 2025-01-14T19:03:55Z | |
| 99-sconres-75 | 99 | sconres | 75 | A concurrent resolution to request the President to provide economic assistance to Mexico while enhancing the national security and energy preparedness of the United States by further filling the Strategic Petroleum Reserve with petroleum obtained from Mexico. | Energy | 1985-10-03 | 1985-10-03 | Read twice and referred to the Committee on Foreign Relations. | Senate | Sen. Cranston, Alan [D-CA] | CA | D | C000877 | 0 | Expresses the sense of the Congress that the President should: (1) purchase petroleum from Mexico for the strategic petroleum reserve by using the total amount in such reserve that is available for acquisition of petroleum products; and (2) submit to the Congress a plan to make available to Mexico an additional $1,500,000,000 in a loan to be repaid, with interest, with petroleum for the strategic petroleum reserve. Urges such plan to offset the Federal budget by the amount of the outlay of such loan by reducing expenditures. | 2025-01-14T19:00:46Z | |
| 97-sconres-124 | 97 | sconres | 124 | A concurrent resolution concerning the Administration's study of hydroelectric power. | Energy | 1982-09-21 | 1982-09-21 | Referred to the Committee on Environment and Public Works. | Senate | Sen. Sasser, Jim [D-TN] | TN | D | S000068 | 4 | Expresses the sense of the Congress that: (1) changes in the public power pricing practices should be the subject of extensive congressional deliberation; and (2) the current administration study of hydroelectric power policies of the Tennessee Valley Authority, other public power authorities, and Federal agencies shall be stopped until Congress has considered the subject. | 2025-01-14T17:12:38Z | |
| 97-sconres-116 | 97 | sconres | 116 | A concurrent resolution expressing the sense of Congress that a national coal export policy is necessary to coordinate federal activities with respect to increasing coal exports, to provide for a statement of intent regarding coal port improvements, and for other purposes. | Energy | 1982-08-17 | 1982-08-17 | Referred to the Committee on Banking. | Senate | Sen. Randolph, Jennings [D-WV] | WV | D | R000046 | 0 | Expresses the sense of Congress that increased coal exports are important and that Congress should consider legislation to enhance the coal capability of U.S. ports. Declares that such legislation should: (1) not provide for the imposition of user charges to recover Federal expenditures at such ports; (2) seek to expedite authorizations for port improvements; and (3) request the President to further define a national coal export policy and initiate bilateral conferences with coal trading parties. | 2025-01-14T18:20:21Z | |
| 97-sconres-25 | 97 | sconres | 25 | A concurrent resolution to disapprove a proposed rule relative to Incremental Pricing under the Natural Gas Policy Act of 1978. | Energy | 1981-07-30 | 1981-07-30 | Referred to Senate Committee on Energy and Natural Resources. | Senate | Sen. McClure, James A. [R-ID] | ID | R | M000346 | 0 | Expresses the Senate's disapproval of a proposed rule relating to incremental pricing under the Natural Gas Policy Act of 1978. | 2025-04-23T11:41:33Z | |
| 96-sconres-104 | 96 | sconres | 104 | A concurrent resolution expressing the sense of the Congress regarding the importance of the Alaska Natural Gas Transportation System. | Energy | 1980-06-27 | 1980-07-01 | Measure passed House. | Senate | Sen. Jackson, Henry M. [D-WA] | WA | D | J000013 | 2 | Expresses the sense of Congress that the Alaska Natural Gas Transportation System remains an essential part of securing this Nation's energy future. Supports its expeditious construction and completion. | 2021-06-14T19:49:08Z | |
| 96-sconres-103 | 96 | sconres | 103 | A concurrent resolution disapproving the sale of nuclear fuel to India. | Energy | 1980-06-20 | 1980-06-20 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Byrd, Harry F., Jr. [I-VA] | VA | I | B001209 | 1 | Disapproves the President's decision to export nuclear fuel and related materials to India contrary to the decision of the Nuclear Regulatory Commission. | 2025-01-14T19:00:46Z | |
| 96-sconres-77 | 96 | sconres | 77 | A concurrent resolution stating that the Congress does favor the submission of the President with respect to the Amendment to the Agreement between the Government of the United States of America and the Government of the United Kingdom of Great Britain and Northern Ireland for Cooperation on the Uses of Atomic Energy for Mutual Defense Purposes of July 3, 1958, signed on December 5, 1979. | Energy | 1980-02-19 | 1980-02-28 | Referred to House Committee on Foreign Affairs. | Senate | Sen. Church, Frank [D-ID] | ID | D | C000388 | 0 | Favors the President's submission of the Amendment to the Agreement Between the Government of the United States of America and the Government of the United Kingdom of Great Britain and Northern Ireland for Cooperation on the Uses of Atomic Energy for Mutual Defense Purposes. | 2025-01-14T19:00:46Z | |
| 96-sconres-28 | 96 | sconres | 28 | A concurrent resolution to express the sense of the Congress that the President should immediately establish and appoint a National Energy Council. | Energy | 1979-05-24 | 1979-05-24 | Referred to Senate Committee on Energy and Natural Resources. | Senate | Sen. Dole, Robert J. [R-KS] | KS | R | D000401 | 0 | Expresses the sense of the Congress that the President immediately establish and appoint a National Energy Council to: (1) study the energy shortage, its impact, and the credibility of energy data; (2) present a written report to the President and the Congress concerning energy data credibility enhancement; and (3) compile and publish a national energy audit. | 2025-04-23T11:41:33Z | |
| 96-sconres-27 | 96 | sconres | 27 | A concurrent resolution expressing the sense of the Congress that the United States, Mexico, and Canada should establish a common economic bond of energy cooperation. | Energy | 1979-05-21 | 1979-05-21 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Dole, Robert J. [R-KS] | KS | R | D000401 | 7 | Expresses the sense of Congress that the leaders of the United States, Mexico, and Canada should meet to discuss energy issues and establish a common economic bond of energy cooperation. | 2025-01-14T19:00:46Z | |
| 96-sconres-21 | 96 | sconres | 21 | A concurrent resolution expressing the sense of the Congress that the United States should cooperate effectively with the United Nations on the United Nations Conference on New and Renewable Energy Sources to be held in 1981. | Energy | 1979-04-10 | 1979-04-10 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Percy, Charles H. [R-IL] | IL | R | P000222 | 2 | Expresses the sense of Congress that the United States should cooperate with the United Nations Conference on New and Renewable Energy Sources. | 2025-01-14T19:00:46Z | |
| 96-sconres-19 | 96 | sconres | 19 | A concurrent resolution to express the sense of the Congress that the President should immediately create and appoint a Presidential Commission to investigate present and future implications of the nuclear power plant accident at Three Mile Island, Pennsylvania, on March 28, 1979. | Energy | 1979-04-05 | 1979-04-05 | Referred to Senate Committee on Energy and Natural Resources. | Senate | Sen. Schweiker, Richard S. [R-PA] | PA | R | S000159 | 0 | Expresses the sense of Congress that the President should create and appoint a Presidential Commission to investigate present and future implications of the nuclear power plant accident at Three Mile Island, Pennsylvania, on March 28, 1979. | 2025-04-23T11:41:33Z | |
| 95-sconres-73 | 95 | sconres | 73 | A concurrent resolution to express the sense of the United States Congress regarding the imposition of import fees on crude oil by the President of the United States. | Energy | 1978-04-03 | 1978-05-09 | Reported to Senate from the Committee on Finance with amendment, S. Rept. 95-787. | Senate | Sen. Dole, Robert J. [R-KS] | KS | R | D000401 | 29 | (Reported to Senate from the Committee on Finance with amendment, S. Rept. 95-787) Declares it the sense of Congress that: (1) the President should not impose additional import fees on oil as a means of reducing crude oil imports; (2) the President should not impose additional import fees on imports of refined petroleum products if additional import fees are not imposed on imported crude oil and if a crude oil equalization tax is not imposed on domestically produced crude oil; and (3) the President should hold open public hearings to assess and mitigate the effects on the economic well-being of affected regions and industries of additional import fees on refined petroleum products before imposing such fees. | 2024-08-01T20:07:13Z | |
| 95-sconres-59 | 95 | sconres | 59 | A concurrent resolution relating to Petroleos Mexicanos. | Energy | 1977-10-19 | 1977-10-19 | Referred to Senate Committee on Banking, Housing and Urban Affairs. | Senate | Sen. Stevenson, Adlai E., III [D-IL] | IL | D | S000890 | 0 | Declares it the sense of Congress that the Export-Import Bank should not furnish financing to Petroleos Mexicanos (PEMEX) to assist in construction of a natural gas pipeline until it is established that such pipeline will make available substantial gas supplies to United States consumers and that certain pricing conditions are met. | 2025-01-14T18:20:21Z | |
| 95-sconres-58 | 95 | sconres | 58 | A concurrent resolution authorizing the correction in engrossment of Senate amendments to H.R. 4018. | Energy | 1977-10-17 | 1977-10-18 | Measure passed House. | Senate | Sen. Griffin, Robert P. [R-MI] | MI | R | G000465 | 0 | Revises the engrossment of the Senate amendments to H.R. 4018 to stipulate that no action by the Federal Power Commission pursuant to any Act shall take from a natural gas distribution company any volumes of gas which such company demonstrates resulted from energy conservation measures. | 2024-08-01T20:07:13Z | |
| 95-sconres-35 | 95 | sconres | 35 | A concurrent resolution relating to the power failure in New York City. | Energy | 1977-07-14 | 1977-07-14 | Referred to Senate Committee on Energy and Natural Resources. | Senate | Sen. Moynihan, Daniel Patrick [D-NY] | NY | D | M001054 | 0 | Calls for an immediate investigation of the New York power outage of July 13, 1977, by the Federal Power Commission. | 2025-04-23T11:41:33Z | |
| 95-sconres-23 | 95 | sconres | 23 | A concurrent resolution proposing a world conference on energy and critical material resources. | Energy | 1977-05-11 | 1977-05-11 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Williams, Harrison A., Jr. [D-NJ] | NJ | D | W000502 | 2 | Requests the President to propose a World Conference on Energy and Critical Material Resources to develop a program of international cooperation in the area of energy and critical resource research and development, including the recommendation of methods to safeguard against the proliferation of nuclear weapons capabilities. | 2025-01-14T19:00:46Z | |
| 95-sconres-17 | 95 | sconres | 17 | A concurrent resolution relating to the establishment of an international nuclear fuel authority. | Energy | 1977-04-01 | 1977-04-01 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Glenn, John H., Jr. [D-OH] | OH | D | G000236 | 0 | Requests the President to negotiate a multilateral treaty establishing an International Nuclear Fuel Authority to allocate, distribute, and regulate nuclear fuel and nuclear fuel processing. | 2025-01-14T19:00:46Z | |
| 94-sconres-69 | 94 | sconres | 69 | Concurrent resolution relating to nuclear reduction, testing and nonproliferation. | Energy | 1975-10-09 | 1975-10-09 | Referred to Senate Committee on Foreign Relations. | Senate | Sen. Cranston, Alan [D-CA] | CA | D | C000877 | 3 | Requests the President to inform the appropriate foreign countries of a declaration by the Congress calling for reduction and control of nuclear testing and non-proliferation of nuclear materials, including the embodiment of the Vladivostok Accord of 1974 in a treaty. | 2025-01-14T19:00:46Z | |
| 94-sconres-25 | 94 | sconres | 25 | A concurrent resolution regarding delivery of oil and natural gas from Alaska. | Energy | 1975-03-13 | 1975-03-13 | Referred to Senate Committee on Interior and Insular Affairs. | Senate | Sen. Bayh, Birch [D-IN] | IN | D | B000254 | 1 | Requests the President to supply the Congress with a comprehensive report of the status of negotiations with the Government of Canada as relates to the transportation of Alaskan oil, alternatives under consideration for transport of oil from naval petroleum reserves numbered four to the contiguous forty-eight States, estimates of when a decision must be reached on the system for delivery of natural gas from Alaska, the nature of agreements which must be reached with the Government of Canada to guarantee the unimpeded shipment of oil and natural gas through our respective countries, and recommendations for legislation to permit the earliest, responsible use of all the Nation's energy reserves in Alaska and in naval petroleum reserves numbered four. | 2025-04-23T11:41:33Z | |
| 94-sconres-13 | 94 | sconres | 13 | Concurrent resolutions expressing the approval of Congress on distribution and uses of atomic material. | Energy | 1975-02-11 | 1975-03-17 | Measure laid on table in House. | Senate | Sen. Pastore, John O. [D-RI] | RI | D | P000100 | 0 | Expresses congressional approval of the proposed additional amounts of special nuclear material which may be distributed to the International Atomic Energy Agency pursuant to the Atomic Energy Act. | 2024-08-01T19:33:36Z | |
| 94-sconres-14 | 94 | sconres | 14 | Concurrent resolutions expressing the approval of Congress on distribution and uses of atomic material. | Energy | 1975-02-11 | 1975-03-17 | Measure laid on table in House. | Senate | Sen. Pastore, John O. [D-RI] | RI | D | P000100 | 0 | Expresses congressional approval of the proposed additional amounts of special nuclear material which may be distributed to the European Atomic Energy Community pursuant to the Atomic Energy Act. | 2024-08-01T19:33:36Z | |
| 94-sconres-15 | 94 | sconres | 15 | Concurrent resolutions expressing the approval of Congress on distribution and uses of atomic material. | Energy | 1975-02-11 | 1975-03-11 | Measure passed House in lieu of H.Con.Res. 114. | Senate | Sen. Pastore, John O. [D-RI] | RI | D | P000100 | 0 | Expresses approval of the Congresss to the proposed amendment to the 1955 Agreement for Cooperation Between the Government of the United States of America and the Government of Israel Concerning Civil Uses of Atomic Energy. | 2024-08-01T19:33:37Z | |
| 93-sconres-60 | 93 | sconres | 60 | A concurrent resolution declaring the existence of a shortage of crude oil, residual fuel oil, and refined petroleum products. | Energy | 1973-12-10 | 1973-12-10 | Referred to Senate Committee on Government Operations. | Senate | Sen. Roth Jr., William V. [R-DE] | DE | R | R000460 | 49 | Expresses the sense of the Congress that: (1) the President should determine and take immediate steps to reduce Federal Government consumption of fuels by a third; (2) the President should initiate a program within the Federal Government to immediately reduce nonessential uses of all Government vehicles and equipment, and commercial and mass transportation should be utilized whenever practical in the conduct of government business; (3) the President should allot Federal Government departments and agencies a fixed quantity of fuel for a fixed period for essential purposes only, and critical national security activities and other vital services may be exempted on a case-by-case basis; (4) the Secretary of Defense should immediately initiate innovative measures to reduce the amount of fuels used for defense activities; and (5) the President should immediately urge State, local, and other public authorities to adopt similar measures. | 2025-01-14T19:03:55Z | |
| 93-sconres-31 | 93 | sconres | 31 | A concurrent resolution expressing the sense of Congress against increases in the price of natural gas. | Energy | 1973-06-14 | 1973-06-14 | Referred to Senate Committee on Commerce. | Senate | Sen. Moss, Frank E. [D-UT] | UT | D | M001033 | 0 | Makes it the sense of the Congress that, inasmuch as there is at present inadequate information as to the available supply of natural gas, and since such needed information will become available by January 1, 1974, that, prior to January 1, 1974, it will be contrary to the public interest for the Federal Power Commission to permit increases in the price of natural gas above the administratively determined area rate ceilings in effect on June 1, 1973. Provides that the Commission may prior to January 1, 1974, consider and approve petitions for special relief from such rates pursuant to the Commissioner's regulations in instances where, based on evidentiary record the Commission finds such relief to be cost justified. | 2025-01-14T18:51:33Z |
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);