legislation
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
35 rows where bill_type = "hconres", congress = 104 and policy_area = "Congress" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104-hconres-229 | 104 | hconres | 229 | Directing the Secretary of the Senate to make corrections in the enrollment of S. 1004. | Congress | 1996-09-28 | 1996-09-30 | Message on Senate action sent to the House. | House | Rep. Shuster, Bud [R-PA-9] | PA | R | S000394 | 0 | Makes technical corrections in the enrollment of S. 1004 (authorizing appropriations for the Coast Guard). | 2025-01-02T17:32:44Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/229 |
| 104-hconres-230 | 104 | hconres | 230 | Providing for the sine die adjournment of the second session of the One Hundred Fourth Congress. | Congress | 1996-09-28 | 1996-10-04 | Message on Senate action sent to the House. | House | Rep. Armey, Richard K. [R-TX-26] | TX | R | A000217 | 0 | Provides for the sine die adjournment of the House of Representatives and of the Senate on October 2, 3, or 4, 1996. | 2025-01-02T17:32:43Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/230 |
| 104-hconres-221 | 104 | hconres | 221 | Directing the Clerk of the House to make corrections in the enrollment of H.R. 3159. | Congress | 1996-09-26 | 1996-09-30 | Message on Senate action sent to the House. | House | Rep. Shuster, Bud [R-PA-9] | PA | R | S000394 | 0 | Makes technical corrections in the enrollment of H.R. 3159 (authorizing appropriations for the National Transportation Safety Board). | 2025-01-02T17:32:44Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/221 |
| 104-hconres-222 | 104 | hconres | 222 | Providing that George Washington's "Farewell Address" shall be read at the beginning of each Congress. | Congress | 1996-09-26 | 1996-09-26 | Referred to the House Committee on Rules. | House | Rep. Dornan, Robert K. [R-CA-46] | CA | R | D000435 | 0 | Requires that George Washington's "Farewell Address" be read aloud on the first day of the first regular session of each Congress in the Senate and in the House of Representatives by a Member designated by the Senate majority leader or the Speaker of the House, respectively. | 2025-01-02T17:32:51Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/222 |
| 104-hconres-216 | 104 | hconres | 216 | Providing for relocation of the Portrait Monument. | Congress | 1996-09-24 | 1996-09-28 | Message on Senate action sent to the House. | House | Rep. Morella, Constance A. [R-MD-8] | MD | R | M000941 | 12 | Directs the Architect of the Capitol to: (1) restore the Portrait Monument (a statue of Lucretia Mott, Elizabeth Cady Stanton, and Susan B. Anthony) and place it in the Rotunda of the Capitol for one year at which time it, along with an appropriate educational display, shall be moved to a permanent site and an alternative statue shall be placed in the Rotunda; and (2) make all necessary arrangements for a rededication ceremony of the Monument in the Rotunda in conjunction with the Woman Suffrage Statue Campaign. Establishes a commission to: (1) select the permanent site; (2) plan and develop the educational display that described some of the most dramatic events of the suffragettes' lives; and (3) select the alternative statue to commemorate the struggle of women in America for equal rights. Prohibits use of Federal funds to pay any expense of the educational display or of restoring, moving, or relocating the Monument. | 2025-04-07T15:23:12Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/216 |
| 104-hconres-211 | 104 | hconres | 211 | Directing the Clerk of the House of Representatives to make a technical correction in the enrollment of H.R. 3060. | Congress | 1996-09-10 | 1996-09-17 | Message on Senate action sent to the House. | House | Rep. Walker, Robert S. [R-PA-16] | PA | R | W000068 | 0 | Makes a technical correction in the enrollment of H.R. 3060 (implementation of the Protocol on Environmental Protection to the Antarctic Treaty). | 2025-01-02T17:32:43Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/211 |
| 104-hconres-208 | 104 | hconres | 208 | Directing the Clerk of the House of Representatives to make a correction in the enrollment of H.R. 3103. | Congress | 1996-08-02 | 1996-08-05 | Message on Senate action sent to the House. | House | Rep. Thomas, William M. [R-CA-21] | CA | R | T000188 | 0 | Makes corrections in the enrollment of H.R. 3103 (health insurance). | 2025-01-02T17:32:43Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/208 |
| 104-hconres-207 | 104 | hconres | 207 | Approving certain regulations to implement provisions of the Congressional Accountability Act of 1995 relating to labor-management relations with respect to covered employees, other than employees of the House of Representatives and employees of the Senate, and for other purposes. | Congress | 1996-08-01 | 1996-09-28 | Message on Senate action sent to the House. | House | Rep. Thomas, William M. [R-CA-21] | CA | R | T000188 | 0 | Approves certain regulations relating to Federal labor-management relations insofar as they apply to covered employees under the Congressional Accountability Act of 1995 (other than employees of the House of Representatives or the Senate). Requires the Board of Directors of the Office of Compliance to adopt regulations to implement the requirement that the Board refer to a hearing officer any matter relating to employee petitions under such provisions. | 2025-07-21T19:44:15Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/207 |
| 104-hconres-203 | 104 | hconres | 203 | Providing for an adjournment of both Houses. | Congress | 1996-07-26 | 1996-07-31 | Message on Senate action sent to the House. | House | Rep. Armey, Richard K. [R-TX-26] | TX | R | A000217 | 0 | Provides for an adjournment of the House of Representatives from August 1, 2, or 3 until September 4, 1996, and a recess or an adjournment of the Senate from August 1, 2, 3, or 4 until September 3, 1996. | 2025-01-02T17:32:43Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/203 |
| 104-hconres-192 | 104 | hconres | 192 | Providing for an adjournment of both Houses. | Congress | 1996-06-27 | 1996-06-28 | Message on Senate action sent to the House. | House | Rep. Diaz-Balart, Lincoln [R-FL-21] | FL | R | D000299 | 0 | Provides for an adjournment of the House of Representatives on June 27 or 28, 1996, until July 8, 1996, and a recess or adjournment of the Senate from June 27, 28, 29, or 30, 1996, until July 8, 1996. | 2025-04-07T15:22:53Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/192 |
| 104-hconres-185 | 104 | hconres | 185 | Expressing the sense of the Congress that Members should understand and use the Internet to improve the democratic process, communicate with the Internet community. | Congress | 1996-06-13 | 1996-06-13 | Referred to the House Committee on House Oversight. | House | Rep. White, Rick [R-WA-1] | WA | R | W000391 | 5 | Declares that the Congress should: (1) educate itself about the Internet and use the technology in personal, committee, and leadership offices; (2) work in a bipartisan and bicameral fashion to facilitate the growth and advancement of the Internet; (3) maximize the openness of and participation in government by the people via the Internet so that constituents can have more information from, and more access to, their elected representatives; (4) promote commerce and free flow of information on the Internet; (5) advance the United States' world leadership in the digital world by avoiding the passage of laws that stifle innovation and increase Internet regulation; and (6) work with the Internet community to receive its input on the issues affecting the Internet that come before the Congress. | 2025-01-02T17:32:51Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/185 |
| 104-hconres-157 | 104 | hconres | 157 | Providing for an adjournment or recess of the two Houses. | Congress | 1996-03-29 | 1996-03-29 | Message on Senate action sent to the House. | House | Rep. Armey, Richard K. [R-TX-26] | TX | R | A000217 | 0 | Provides for an adjournment of the House of Representatives on March 29, 1996, until April 15, 1996, and a recess or adjournment of the Senate from March 29, 30, or 31, 1996, until April 15, 1996. | 2025-01-02T17:32:42Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/157 |
| 104-hconres-141 | 104 | hconres | 141 | Providing for the adjournment of the two Houses. | Congress | 1996-02-01 | 1996-02-27 | Referred to the Committee on Appropriations. | House | Rep. Solomon, Gerald B. H. [R-NY-22] | NY | R | S000675 | 0 | Provides for adjournment of the House of Representatives from Thursday, February 1, 1996, until 1: 0 p.m. on Monday, February 26, 1996, or until noon on the second day after Members are notified to reassemble according to this concurrent resolution, whichever occurs first. Provides for recess or adjournment of the Senate until 3 p.m. on Monday, February 26, 1996, (or until noon on the second day after Members are notified to reassemble according to this concurrent resolution, whichever occurs first) from either Thursday, February 1, Tuesday, February 6, Wednesday, February 7, Thursday, February 8, Tuesday, February 13, Wednesday, February 14, or Thursday, February 15, 1996, pursuant to a motion made by the Majority Leader or his designee. Requires the Speaker of the House and the Majority Leader of the Senate, acting jointly after consultation with the Minority Leaders of the House and Senate, to notify the Members of the House and Senate, respectively, to reassemble whenever, in their opinion, the public interest shall warrant it. | 2025-01-14T18:18:18Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/141 |
| 104-hconres-133 | 104 | hconres | 133 | Providing for an adjournment of the two Houses. | Congress | 1996-01-09 | 1996-01-10 | Message on Senate action sent to the House. | House | Rep. Boehner, John A. [R-OH-8] | OH | R | B000589 | 0 | Provides for an adjournment of the House of Representatives from January 9 until January 22, 1996, and a recess or adjournment of the Senate from January 10 until January 22, 1996. | 2025-01-02T17:32:42Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/133 |
| 104-hconres-131 | 104 | hconres | 131 | Establishing procedures making the transmission of the continuing resolution (H.J. Res. 134) to the President contingent upon the submission by the President of a 7-year balanced budget using updated economic and technical assumptions of the Congressional Budget Office. | Congress | 1996-01-05 | 1996-01-05 | Message on Senate action sent to the House. | House | Rep. Kasich, John R. [R-OH-12] | OH | R | K000016 | 0 | Prohibits the Committee on House Oversight from presenting to the President H.J. Res. 134 (continuing appropriations) until the Speaker of the House notifies such Committee that: (1) the President has submitted to the Congress a plan to achieve a balanced budget by FY 2002; and (2) the Director of the Congressional Budget Office (CBO) has certified that the plan achieves a balanced budget based on CBO economic and technical assumptions. | 2025-04-07T15:28:12Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/131 |
| 104-hconres-126 | 104 | hconres | 126 | To establish a joint committee to oversee the conduct of Operation Joint Endeavor/Task Force Eagle. | Congress | 1995-12-22 | 1995-12-22 | Referred to the House Committee on Rules. | House | Rep. Dornan, Robert K. [R-CA-46] | CA | R | D000435 | 0 | Appoints a joint committee to inquire into the conduct of Operation Joint Endeavor-Task Force Eagle. | 2025-01-02T17:32:51Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/126 |
| 104-hconres-128 | 104 | hconres | 128 | To establish a Commission on Women's Art in the United States Capitol. | Congress | 1995-12-22 | 1995-12-22 | Referred to the House Committee on House Oversight. | House | Rep. Kaptur, Marcy [D-OH-9] | OH | D | K000009 | 39 | Establishes a Commission on Women's Art in the United States Capitol. Directs the Commission to study and report to the Congress on matters relating to the representation of women in history (including the current century) in the United States Capitol. | 2025-01-02T17:32:51Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/128 |
| 104-hconres-123 | 104 | hconres | 123 | To provide for the provisional approval of regulations applicable to certain covered employing offices and covered employees and to be issued by the Office of Compliance before January 23, 1996. | Congress | 1995-12-19 | 1996-01-23 | Message on Senate action sent to the House. | House | Rep. Thomas, William M. [R-CA-21] | CA | R | T000188 | 0 | Approves, on a provisional basis until approved in accordance with the Congressional Accountability Act of 1995, the regulations to be issued by the Office of Compliance before January 23, 1996, applicable to employing offices which are not the House of Representatives or the Senate and their covered employees. | 2025-07-21T19:44:15Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/123 |
| 104-hconres-116 | 104 | hconres | 116 | Directing the Secretary of the Senate to make technical corrections in the enrollment of S. 1060. | Congress | 1995-11-29 | 1995-12-14 | Message on Senate action sent to the House. | House | Rep. Canady, Charles T. [R-FL-12] | FL | R | C000107 | 0 | Makes technical corrections in the enrollment of S. 1060 (lobbying disclosure). | 2025-01-02T17:32:42Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/116 |
| 104-hconres-114 | 104 | hconres | 114 | To authorize the Newington-Cropsey Foundation to erect on the Capitol Grounds and present to Congress a "Bill of Rights Eagle" monument dedicated to the Bill of Rights. | Congress | 1995-11-17 | 1995-11-30 | Referred to the Subcommittee on Public Buildings and Economic Development. | House | Rep. Gilman, Benjamin A. [R-NY-20] | NY | R | G000212 | 0 | Authorizes the Newington-Cropsey Foundation to erect on the Capitol grounds and present to the Congress a "Bill of Rights Eagle" monument dedicated to the Bill of Rights. | 2025-01-02T17:32:52Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/114 |
| 104-hconres-111 | 104 | hconres | 111 | Authorizing the printing of a report to the Speaker of the House of Representatives, prepared by the Congressional Task Force on Immigration Reform. | Congress | 1995-10-26 | 1995-10-26 | Referred to the House Committee on House Oversight. | House | Rep. Gallegly, Elton [R-CA-23] | CA | R | G000021 | 0 | Provides for the printing as a House document of a report to the Speaker of the House of Representatives, prepared by the Congressional Task Force on Immigration Reform, dated June 29, 1995. | 2025-01-02T17:32:50Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/111 |
| 104-hconres-108 | 104 | hconres | 108 | To correct technical errors in the enrollment of the bill H.R. 1594. | Congress | 1995-10-17 | 1995-10-24 | Star Print ordered on the concurrent resolution. | House | Rep. Goodling, William F. [R-PA-19] | PA | R | G000291 | 0 | Makes technical corrections in the enrollment of H.R. 1594 (restrictions on the promotion by Federal agencies of economically targeted investments in connection with employee benefit plans). | 2025-04-21T12:24:17Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/108 |
| 104-hconres-104 | 104 | hconres | 104 | Providing for an adjournment of the two Houses. | Congress | 1995-09-29 | 1995-09-29 | Message on Senate action sent to the House. | House | Rep. Shays, Christopher [R-CT-4] | CT | R | S001144 | 0 | Provides for an adjournment of the House of Representatives from September 29 until October 6, 1995, and a recess or adjournment of the Senate from any day beginning September 29 through October 6, 1995, until October 10, 1995. | 2025-01-02T17:32:42Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/104 |
| 104-hconres-99 | 104 | hconres | 99 | Providing for corrections in the enrollment of the bill (H.R. 1854) making appropriations for the Legislative Branch for the fiscal year ending September 30, 1996, and for other purposes. | Congress | 1995-09-06 | 1995-10-02 | Referred to the Subcommittee on the Constitution. | House | Rep. Bryant, John W. [D-TX-5] | TX | D | B000997 | 1 | Makes corrections in the enrollment of H.R. 1854 (legislative branch appropriations) to add provisions concerning lobbying disclosure and congressional gift rules. | 2025-01-02T17:32:50Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/99 |
| 104-hconres-92 | 104 | hconres | 92 | Providing for an adjournment of the two Houses. | Congress | 1995-08-04 | 1995-08-04 | Message on Senate action sent to the House. | House | Rep. Armey, Richard K. [R-TX-26] | TX | R | A000217 | 0 | Provides for an adjournment of the House of Representatives from August 4 until September 6, 1995, and a recess or adjournment of the Senate from any day between August 5 and August 19 until September 5, 1995. | 2025-01-02T17:32:42Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/92 |
| 104-hconres-89 | 104 | hconres | 89 | Waiving provisions of the Legislative Reorganization Act of 1970 requiring adjournment of Congress by July 31. | Congress | 1995-07-31 | 1995-08-02 | Message on Senate action sent to the House. | House | Rep. Sensenbrenner, F. James, Jr. [R-WI-9] | WI | R | S000244 | 0 | Provides that notwithstanding provisions of the Legislative Reorganization Act of 1946 which require adjournment by July 31 of each year, the House of Representatives and the Senate shall not adjourn for a period in excess of three days, or adjourn sine die, until both Houses of Congress adopt a concurrent resolution providing for either such an adjournment. | 2016-10-26T07:32:47Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/89 |
| 104-hconres-82 | 104 | hconres | 82 | Directing the Secretary of the Senate to make technical corrections in the enrollment of S. 523. | Congress | 1995-07-11 | 1995-07-14 | Message on Senate action sent to the House. | House | Rep. Young, Don [R-AK-At Large] | AK | R | Y000033 | 0 | Requires the Secretary of the Senate to make technical corrections in the enrollment of S. 523 (amending the Colorado River Basin Salinity Control Act to authorize additional measures to carry out the control of salinity upstream of Imperial Dam). | 2016-10-26T07:32:46Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/82 |
| 104-hconres-72 | 104 | hconres | 72 | Providing for the adjournment of the two Houses. | Congress | 1995-05-25 | 1995-05-25 | Message on Senate action sent to the House. | House | Rep. Armey, Richard K. [R-TX-26] | TX | R | A000217 | 0 | Provides for an adjournment of the House of Representatives from May 25 until June 6, 1995, and a recess or adjournment of the Senate from May 25, 26, or 27 until June 5, 1995. | 2016-10-26T07:32:45Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/72 |
| 104-hconres-58 | 104 | hconres | 58 | Providing for the adjournment of the two Houses. | Congress | 1995-04-06 | 1995-04-07 | Message on Senate action sent to the House. | House | Rep. Goss, Porter J. [R-FL-14] | FL | R | G000336 | 0 | Provides for an adjournment of the House of Representatives from April 7 until May 1, 1995, and from May 3 until May 9, 1995, and an adjournment or recess of the Senate from April 6, 7, 8, 9, or 10 until April 24, 1995. | 2016-10-26T07:32:43Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/58 |
| 104-hconres-55 | 104 | hconres | 55 | Requesting the President to return the enrolled bill (H.R. 831), and providing for its reenrollment without the targeted tax benefit contained therein. | Congress | 1995-04-04 | 1995-04-05 | Sponsor introductory remarks on measure. (CR H4186, H4192) | House | Rep. Deutsch, Peter [D-FL-20] | FL | D | D000275 | 0 | Requests the President to return H.R. 831 (amending the Internal Revenue Code to permanently extend the deduction for the health insurance costs of self-employed individuals) to the House of Representatives, to remove certain provisions regarding nonrecognition of gain on sales and exchanges effectuating policies of the Federal Communications Commission. | 2024-02-07T16:32:33Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/55 |
| 104-hconres-41 | 104 | hconres | 41 | Providing for the adjournment of the House on Thursday, March 16, 1995, to stand adjourned until 12:30 p.m. on Tuesday, March 21, 1995. | Congress | 1995-03-16 | 1995-03-16 | Message on Senate action sent to the House. | House | Rep. Livingston, Bob [R-LA-1] | LA | R | L000371 | 0 | Provides for an adjournment of the House of Representatives from March 16 until March 21, 1995. | 2016-10-26T07:32:40Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/41 |
| 104-hconres-30 | 104 | hconres | 30 | Providing for the adjournment of the two Houses. | Congress | 1995-02-16 | 1995-02-16 | Message on Senate action sent to the House. | House | Rep. Scarborough, Joe [R-FL-1] | FL | R | S000106 | 0 | Provides for an adjournment of the House of Representatives from February 16 until February 21, 1995, and a recess or adjournment of the Senate from February 16 until February 22, 1995. | 2016-10-26T07:32:39Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/30 |
| 104-hconres-16 | 104 | hconres | 16 | Providing for a joint session of Congress to receive a message from the President on the State of the Union. | Congress | 1995-01-23 | 1995-01-24 | Message on Senate action sent to the House. | House | Rep. DeLay, Tom [R-TX-22] | TX | R | D000217 | 0 | Provides for a joint session of the Congress on January 24, 1995, for a message from the President on the State of the Union. | 2016-10-26T07:32:37Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/16 |
| 104-hconres-15 | 104 | hconres | 15 | Expressing the sense of Congress that a Member of Congress should be treated to no special retirement benefits than those afforded to any employee of the federal government. | Congress | 1995-01-20 | 1995-02-15 | Referred to the Subcommittee on Civil Service. | House | Rep. Gutierrez, Luis V. [D-IL-4] | IL | D | G000535 | 0 | Expresses the sense of the Congress that: (1) steps should be taken to examine whether a disparity exists between benefits available to Members of Congress and those offered to Federal employees, with the intent of discovering whether retirement benefits available to Members are more generous than those afforded to other employees; (2) hearings should be conducted by the House Committee on Government Reform and Oversight in order to review such findings; (3) legislation should be drafted that resolves such differences by removing any privileges in Federal retirement programs afforded exclusively to Members; and (4) action should be taken on this matter within the first 100 days of the 104th Congress. | 2025-02-04T16:54:13Z | https://www.congress.gov/bill/104th-congress/house-concurrent-resolution/15 |
| 104-hconres-2 | 104 | hconres | 2 | Expressing the sense of the Congress that retirement benefits for Members of Congress should not be subject to cost-of-living adjustments. | Congress | 1995-01-04 | 1995-03-10 | Subcommittee Hearings Held. | House | Rep. Coble, Howard [R-NC-6] | NC | R | C000556 | 0 | Expresses the sense of the Congress that retirement benefits should not, to the extent that they are based on the service of an individual as a Member of Congress, be subject to cost-of-living adjustments. | 2025-02-04T16:54:13Z | https://www.congress.gov/bill/104th-congress/house-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);