home / openregs

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

44 rows where bill_type = "sjres" and policy_area = "Law" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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)

congress 19

  • 101 5
  • 97 4
  • 98 4
  • 102 4
  • 93 3
  • 95 3
  • 99 3
  • 118 3
  • 94 2
  • 100 2
  • 116 2
  • 117 2
  • 103 1
  • 104 1
  • 105 1
  • 106 1
  • 113 1
  • 114 1
  • 119 1

policy_area 1

  • Law · 44 ✖

bill_type 1

  • sjres · 44 ✖
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
119-sjres-16 119 sjres 16 A joint resolution proposing an amendment to the Constitution of the United States to require that the Supreme Court of the United States be composed of nine justices. Law 2025-02-06 2025-02-06 Read twice and referred to the Committee on the Judiciary. Senate Sen. Cruz, Ted [R-TX] TX R C001098 21   2025-12-05T21:20:18Z  
118-sjres-120 118 sjres 120 A joint resolution proposing an amendment to the Constitution of the United States to normalize vacancies and appointments for justices of the Supreme Court of the United States and for other purposes. Law 2024-12-05 2024-12-05 Read twice and referred to the Committee on the Judiciary. Senate Sen. Welch, Peter [D-VT] VT D W000800 1   2025-07-21T19:32:26Z  
118-sjres-21 118 sjres 21 A joint resolution proposing an amendment to the Constitution of the United States to require that the Supreme Court of the United States be composed of nine justices. Law 2023-03-22 2023-03-22 Read twice and referred to the Committee on the Judiciary. Senate Sen. Cruz, Ted [R-TX] TX R C001098 20   2025-12-05T22:37:23Z  
118-sjres-16 118 sjres 16 A joint resolution proposing an amendment to the Constitution of the United States to require that the Supreme Court of the United States be composed of not more than 9 justices. Law 2023-02-16 2023-02-16 Read twice and referred to the Committee on the Judiciary. Senate Sen. Rubio, Marco [R-FL] FL R R000595 12   2025-07-21T19:32:26Z  
117-sjres-9 117 sjres 9 A joint resolution proposing an amendment to the Constitution of the United States to require that the Supreme Court of the United States be composed of nine justices. Law 2021-02-25 2021-03-01 Read the second time. Placed on Senate Legislative Calendar under General Orders. Calendar No. 8. Senate Sen. Cruz, Ted [R-TX] TX R C001098 20 This joint resolution proposes an amendment to the Constitution to require that the Supreme Court consist of nine Justices. 2021-12-16T19:22:35Z  
117-sjres-4 117 sjres 4 A joint resolution proposing an amendment to the Constitution of the United States to require that the Supreme Court of the United States be composed of not more than 9 justices. Law 2021-01-22 2021-01-22 Read twice and referred to the Committee on the Judiciary. Senate Sen. Rubio, Marco [R-FL] FL R R000595 17 This joint resolution proposes an amendment to the Constitution requiring the Supreme Court to be composed of not more than nine Justices. 2023-01-11T13:47:27Z  
116-sjres-76 116 sjres 76 A joint resolution proposing an amendment to the Constitution of the United States to require that the Supreme Court of the United States be composed of nine justices. Law 2020-10-19 2020-11-09 Read the second time. Placed on Senate Legislative Calendar under General Orders. Calendar No. 583. Senate Sen. Cruz, Ted [R-TX] TX R C001098 15 This joint resolution proposes an amendment to the Constitution to require that the Supreme Court consist of nine justices. 2021-12-29T21:58:57Z  
116-sjres-14 116 sjres 14 A joint resolution proposing an amendment to the Constitution of the United States to require that the Supreme Court of the United States be composed of not more than 9 justices. Law 2019-03-25 2019-03-25 Read twice and referred to the Committee on the Judiciary. Senate Sen. Rubio, Marco [R-FL] FL R R000595 22 Constitutional Amendment This joint resolution proposes a constitutional amendment requiring the U.S. Supreme Court to be composed of not more than nine Justices. 2022-11-01T18:17:21Z  
114-sjres-13 114 sjres 13 A joint resolution proposing an amendment to the Constitution of the United States relative to applying laws equally to the citizens of the United States and the Federal Government. Law 2015-04-23 2015-04-23 Read twice and referred to the Committee on the Judiciary. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 Constitutional Amendment Prohibits Congress from making any law that is applicable to a U.S. citizen but not equally applicable to: (1) Congress; (2) the executive branch, including the President, Vice President, ambassadors, other public ministers and consuls, and all other officers of the United States, including those provided for under the Constitution and by law; and (3) Justices of the Supreme Court and judges of inferior courts. 2023-01-11T13:27:22Z  
113-sjres-25 113 sjres 25 A joint resolution proposing an amendment to the Constitution of the United States relative to applying laws equally to the citizens of the United States and the Federal Government. Law 2013-10-11 2013-10-11 Read twice and referred to the Committee on the Judiciary. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 Constitutional Amendment - Prohibits Congress from making any law that is applicable to a U.S. citizen but not equally applicable to: (1) Congress; (2) the executive branch, including the President, Vice President, ambassadors, other public ministers and consuls, and all other officers of the United States, including those provided for under the Constitution and by law; and (3) Justices of the Supreme Court and judges of inferior courts. 2023-01-11T13:23:51Z  
106-sjres-16 106 sjres 16 A joint resolution proposing a constitutional amendment to establish limited judicial terms of office. Law 1999-03-25 1999-03-25 Read twice and referred to the Committee on Judiciary. Senate Sen. Smith, Bob [R-NH] NH R S000606 2 Constitutional Amendment - Limits to ten years the term of office of the Chief Justice and judges of the Supreme Court and inferior courts. Makes such justice and judges eligible for nomination and appointment by the President to additional terms. 2025-07-21T19:32:26Z  
105-sjres-26 105 sjres 26 A joint resolution proposing a constitutional amendment to establish limited judicial terms of office. Law 1997-04-23 1998-05-15 Referred to Subcommittee on Constitution, Federalism, Property. Senate Sen. Smith, Bob [R-NH] NH R S000606 2 Constitutional Amendment - Limits to ten years the term of office of the Chief Justice and judges of the Supreme Court and inferior courts. Makes such justice and judges eligible for nomination and appointment by the President to additional terms. 2025-07-21T19:32:26Z  
104-sjres-58 104 sjres 58 A joint resolution proposing an amendment to the Constitution of the United States relative to granting power to the States to propose constitutional amendments. Law 1996-07-31 1996-07-31 Read twice and referred to the Committee on Judiciary. Senate Sen. Ashcroft, John [R-MO] MO R A000356 0 Constitutional Amendment - Provides that: (1) whenever two-thirds of the States propose an amendment, in identical terms, to the Constitution, such proposal shall be submitted to the Congress for consideration; (2) if two-thirds of the Members of each House of Congress do not disapprove the proposal during the session in which the proposal is submitted, the proposal shall be submitted to all of the States for consideration; and (3) such amendment shall be valid as part of the Constitution when ratified by the legislatures of three-fourths of the States. 2025-07-21T19:32:26Z  
103-sjres-206 103 sjres 206 A joint resolution designating September 17, 1994, as "Constitution Day". Law 1994-06-29 1994-06-29 Read twice and referred to the Committee on Judiciary. Senate Sen. Wofford, Harris [D-PA] PA D W000665 20 Designates September 17, 1994, as Constitution Day. 2025-07-21T19:32:26Z  
102-sjres-345 102 sjres 345 A joint resolution proposing an amendment to the Constitution of the United States to prohibit the Supreme Court or any inferior court of the United States from ordering the laying or increasing of taxes. Law 1992-10-02 1992-10-02 Read twice and referred to the Committee on Judiciary. Senate Sen. Danforth, John C. [R-MO] MO R D000030 13 Constitutional Amendment - Declares that neither the Supreme Court nor any inferior court of the United States shall have the power to instruct or order a State or political subdivision thereof, or an official of such State or political subdivision, to lay or increase taxes. 2025-07-21T19:32:26Z  
102-sjres-299 102 sjres 299 A joint resolution to state the finding of Congress that the Amendment to the Constitution of the United States relating to compensation for Members of Congress has been duly ratified, and for other purposes. Law 1992-05-12 1992-05-12 Read twice and referred to the Committee on Judiciary. Senate Sen. Kasten, Robert W., Jr. [R-WI] WI R K000019 0 States the finding to the Congress that the proposed amendment to the Constitution (relating to the prohibition to vary the compensation of Members of Congress until an intervening election of Representatives) has been duly ratified. 2025-07-21T19:32:26Z  
102-sjres-244 102 sjres 244 A joint resolution to recognize and honor the National Conference of Commissioners on Uniform State Laws on its Centennial for its contribution to a strong federal system of government. Law 1992-01-30 1992-03-03 Referred to the House Committee on Post Office and Civil Service. Senate Sen. Simpson, Alan K. [R-WY] WY R S000429 54 Recognizes and commemorates the centennial of the National Conference of Commissioners on Uniform State Laws. Requests the President to issue a proclamation observing the centennial from January 1 through December 31, 1992. 2025-07-21T19:32:26Z  
102-sjres-150 102 sjres 150 A joint resolution to designate June 15, 1991, as "Magna Carta Day". Law 1991-05-23 1991-05-31 Referred to the Subcommittee on Census and Population. Senate Sen. Fowler, Wyche, Jr. [D-GA] GA D F000329 94 Designates June 15, 1991, as Magna Carta Day. 2025-07-21T19:32:26Z  
101-sjres-372 101 sjres 372 A joint resolution to recognize and commend the "Bill of Responsibilities" of the Freedoms Foundation at Valley Forge. Law 1990-09-28 1990-09-28 Read twice and referred to the Committee on Judiciary. Senate Sen. Thurmond, Strom [R-SC] SC R T000254 1 Declares that the Congress: (1) recognizes and commends the "Bill of Responsibilities" of the Freedoms Foundation at Valley Forge; and (2) urges citizens to embrace such principles as a model of responsible American citizenship. 2025-07-21T19:32:26Z  
101-sjres-295 101 sjres 295 A joint resolution proposing an amendment to the Constitution of the United States to prohibit the Supreme Court or any inferior court of the United States from ordering the laying or increasing of taxes. Law 1990-04-20 1990-06-19 Subcommittee on Constitution. Hearings held. Senate Sen. Danforth, John C. [R-MO] MO R D000030 29 Constitutional Amendment - Prohibits the Supreme Court or any inferior court of the United States from ordering a State or political subdivision, or an official of such State or subdivision, from laying or increasing taxes. 2025-07-21T19:32:26Z  
101-sjres-232 101 sjres 232 A joint resolution proposing an amendment to the Constitution of the United States with respect to the impeachment of judges. Law 1989-11-21 1990-03-21 Subcommittee on Constitution. Hearings held. Senate Sen. Heflin, Howell [D-AL] AL D H000445 0 Constitutional Amendment - Establishes the Judicial Inquiry Commission to conduct investigations and receive or initiate complaints concerning any judge of the judicial system. Directs the Commission to file a complaint with the Court of the Judiciary if five of the seven Commission members decide that a reasonable basis exists to charge: (1) a judge with violation of any canon of judicial ethics, misconduct in office, or failure to perform duties; or (2) that a judge is physically or mentally unable to perform duties. Requires: (1) all proceedings of the Commission to be confidential (except the filing of a complaint); and (2) the Commission to prosecute the complaints. Requires the Supreme Court to adopt canons of ethics binding on all justices, judges, bankruptcy judges, and magistrates. Creates a Court of the Judiciary with the authority to adjudicate cases brought before it to remove from office and: (1) suspend for up to two years, with or without pay, or censure any judge for misconduct in office or failure to perform the duties of office; or (2) suspend with pay, or place on senior status, any judge who is physically or mentally unable to perform the duties of office. Sets forth provisions with respect to Supreme Court review of appeals of Court of the Judiciary decisions, disqualification from service pending an indictment or information charging a judge with a felony, and termination of salary if a judge is convicted or suspended. 2025-07-21T19:32:26Z  
101-sjres-233 101 sjres 233 A joint resolution proposing an amendment to the Constitution of the United States with respect to the impeachment of Article III judges. Law 1989-11-21 1990-03-21 Subcommittee on Constitution. Hearings held. Senate Sen. Heflin, Howell [D-AL] AL D H000445 0 Constitutional Amendment - Grants the Congress the power to provide for: (1) the removal from office and lesser sanctions for justices, judges, and other Federal judicial officers found guilty of misconduct, failure or inability to perform the duties of office, or violating judicial ethics canons; and (2) the suspension of such officers, with or without pay, when convicted of a felony or under indictment or information charging such officer with a felony. 2025-07-21T19:32:26Z  
101-sjres-69 101 sjres 69 A joint resolution designating April 8, 1989 as "Chief Justice Earl Warren Day". Law 1989-03-01 1989-03-01 Read twice and referred to the Committee on Judiciary. Senate Sen. Cranston, Alan [D-CA] CA D C000877 8 Designates April 8, 1989, as Chief Justice Earl Warren Day. 2025-07-21T19:32:26Z  
100-sjres-173 100 sjres 173 A joint resolution to commemorate the 200th anniversary of the signing of the United States Constitution. Law 1987-07-08 1987-09-28 Referred to Subcommittee on Census and Population. Senate Sen. Reid, Harry [D-NV] NV D R000146 53 Declares that the Congress encourages all Americans to read the Constitution within one year of its 200th anniversary and strongly encourages Members of Congress, Federal judges, and officials of the executive branch to set the example in studying this cornerstone of democratic government. 2025-07-21T19:32:26Z  
100-sjres-113 100 sjres 113 A joint resolution proposing an amendment to the Constitution of the United States with respect to the impeachment of Article III judges. Law 1987-04-09 1987-04-28 Referred to Subcommittee on Constitution. Senate Sen. Heflin, Howell [D-AL] AL D H000445 5 Constitutional Amendment - Grants the Congress power to provide procedures for the impeachment of Article III judges. 2025-07-21T19:32:26Z  
99-sjres-370 99 sjres 370 A joint resolution proposing an amendment to the Constitution of the United States regarding judges appointed pursuant to Article III. Law 1986-06-26 1986-08-12 Subcommittee on Constitution. Hearings held. Senate Sen. DeConcini, Dennis [D-AZ] AZ D D000185 0 Constitutional Amendment - States that, upon conviction of a felony and exhaustion of all appeals, a Federal judge shall forfeit office and benefits thereof. Empowers the Congress to set legislative standards by which the Supreme Court may discipline Federal judges who bring disrepute on Federal courts. 2025-07-21T19:32:26Z  
99-sjres-30 99 sjres 30 A joint resolution proposing an amendment to the Constitution of the United States to establish a ten-year term of office for Federal judges. Law 1985-01-24 1985-05-15 Committee on Judiciary requested executive comment from Justice Department. Senate Sen. Boren, David L. [D-OK] OK D B000639 2 Constitutional Amendment - Limits the tenure of Federal judges (including Supreme Court justices) to a ten-year term during good behavior. Authorizes an additional term upon the advice and consent of the Senate. 2025-07-21T19:32:26Z  
99-sjres-5 99 sjres 5 A joint resolution to amend the Constitution to establish legislative authority in Congress and the States with respect to abortion. Law 1985-01-03 1985-05-15 Committee on Judiciary requested executive comment from Justice Department. Senate Sen. Hatch, Orrin G. [R-UT] UT R H000338 12 Constitutional Amendment - Declares that the Constitution does not secure a right to abortion. 2025-07-21T19:32:26Z  
98-sjres-165 98 sjres 165 A joint resolution to commemorate the bicentennial anniversary of the constitutional foundation for patent and copyright laws. Law 1983-09-19 1984-05-17 Referred to House Committee on Post Office and Civil Service. Senate Sen. Mathias, Charles McC., Jr. [R-MD] MD R M000241 28 Calls for special recognition during 1987, the bicentennial year of the United States Constitution, of the constitutional foundation for patent and copyright laws. 2025-07-21T19:32:26Z  
98-sjres-100 98 sjres 100 A joint resolution proposing an amendment to the Constitution of the United States with respect to the appellate jurisdiction of the Supreme Court of the United States. Law 1983-05-16 1983-05-20 Referred to Subcommittee on Constitution. Senate Sen. Moynihan, Daniel Patrick [D-NY] NY D M001054 0 Constitutional Amendment - Confers upon the Supreme Court appellate jurisdiction over all cases arising under the Constitution. Authorizes the Court to prescribe exceptions and regulations for all such cases. 2025-07-21T19:32:26Z  
98-sjres-39 98 sjres 39 A joint resolution proposing an amendment to the Constitution of the United States to establish a ten year term of office for Federal judges. Law 1983-02-22 1984-01-23 Committee on Judiciary received executive comment from Office of U.S. Attorney General. Senate Sen. Boren, David L. [D-OK] OK D B000639 1 Constitutional Amendment - Limits the tenure of Federal judges (including Supreme Court justices) to a ten-year term during good behavior. Authorizes an additional term upon the advice and consent of the Senate. 2025-07-21T19:32:26Z  
98-sjres-3 98 sjres 3 A joint resolution to amend the Constitution to establish legislative authority in Congress and the States with respect to abortion. Law 1983-01-26 1983-06-28 Failed of passage in Senate by Yea-Nay Vote. 49-50. Record Vote No: 173. Senate Sen. Hatch, Orrin G. [R-UT] UT R H000338 12 (Reported to Senate from the Committee on the Judiciary with amendment, S. rept. 98-149) Constitutional Amendment - Declares that a right to abortion is not secured by the Constitution. 2025-07-21T19:32:26Z  
97-sjres-97 97 sjres 97 A joint resolution to designate the second full week in October as "National Legal Secretaries' Court Observance Week". Law 1981-07-13 1982-09-21 Referred to House Committee on Post Office and Civil Service. Senate Sen. Mitchell, George J. [D-ME] ME D M000811 26 (Measure passed Senate, amended) Requests the President to designate the second full week in October 1982 as Legal Secretaries' Court Observance Week. 2025-07-21T19:32:26Z  
97-sjres-33 97 sjres 33 Constitution Bicentennial Observance Act Law 1981-02-24 1981-09-17 Subcommittee on Constitution. Hearings held. Senate Sen. Helms, Jesse [R-NC] NC R H000463 5 Constitution Bicentennial Observance Act - Establishes the United States Constitution Bicentennial Commission, with representatives from the three branches of Government and the public sector, to plan and develop a three-year program for commemorating the bicentennial of the United States Constitution. Authorizes appropriations for such purpose. Directs the Commission to submit specified reports to the President and the Congress. Requires certain Federal officials to assist the Commission in planning the commemoration. Terminates the Commission on April 31, 1988. Authorizes the Commission to extend matching grants to nonprofit entities, States, and local governments for commemorative programs. 2025-08-29T19:50:32Z  
97-sjres-24 97 sjres 24 A joint resolution proposing an amendment to the Constitution of the United States with respect to reconfirmation of Federal judges after a term of ten years. Law 1981-01-29 1981-02-06 Referred to Subcommittee on Constitution. Senate Sen. Durenberger, Dave [R-MN] MN R D000566 2 Constitutional Amendment - Limits the tenure of Federal judges (including Supreme Court justices) to a ten-year term during good behavior. 2025-07-21T19:32:26Z  
97-sjres-21 97 sjres 21 A joint resolution proposing an amendment to the Constitution of the United States to establish a ten year term of office for federal judges. Law 1981-01-27 1982-06-23 Committee on Judiciary received executive comment from Office of the Attorney General. Senate Sen. Boren, David L. [D-OK] OK D B000639 0 Constitutional Amendment - Limits the tenure of Federal judges (including Supreme Court justices) to a ten-year term during good behavior. Authorizes an additional term upon the advice and consent of the Senate. 2025-07-21T19:32:26Z  
95-sjres-73 95 sjres 73 A joint resolution proposing an amendment to the Constitution of the United States to establish maximum age limits for certain officers of the Government. Law 1977-07-19 1977-07-19 Referred to Senate Committee on the Judiciary. Senate Sen. Bartlett, Dewey F. [R-OK] OK R B000200 0 Constitutional Amendment - Requires Federal judges to retire from regular active service within 30 days of attaining age 70. 2025-07-21T19:32:26Z  
95-sjres-74 95 sjres 74 A joint resolution proposing an amendment to the Constitution of the United States providing for the reconfirmation by popular vote of certain Federal judges. Law 1977-07-19 1977-07-19 Referred to Senate Committee on the Judiciary. Senate Sen. Bartlett, Dewey F. [R-OK] OK R B000200 0 Constitutional Amendment - Provides for periodic reconfirmation of United States district court judges by popular vote of the inhabitants of their respective judicial districts. 2025-07-21T19:32:26Z  
95-sjres-19 95 sjres 19 A joint resolution proposing an amendment to the Constitution of the United States with respect to the reconfirmation of judges after a term of eight years. Law 1977-02-01 1977-02-01 Referred to Senate Committee on the Judiciary. Senate Sen. Byrd, Harry F., Jr. [I-VA] VA I B001209 9 Constitutional Amendment - Requires that justices of the Supreme Court and judges of inferior Federal courts be reconfirmed by the Senate every eight years. 2025-07-21T19:32:26Z  
94-sjres-200 94 sjres 200 Public Law Revision Resolution Law 1976-06-14 1976-06-14 Referred to Senate Committee on Government Operations. Senate Sen. Stone, Richard (Dick) [D-FL] FL D S000962 0 Public Law Revision Resolution - Directs each standing committee of the House of Representatives and of the Senate to submit, by the last day of the first session of the Ninety- fifth Congress, to the Speaker of the House and the President pro tempore of the Senate, a plan for a comprehensive review of all existing Federal statutes with respect to which any such committee has legislative jurisdiction with a view toward revising and repealing such statutes as may be appropriate. 2025-09-02T18:50:28Z  
94-sjres-96 94 sjres 96 A joint resolution proposing an amendment to the Constitution of the United States providing for the reconfirmation by popular vote of certain Federal judges. Law 1975-06-11 1975-06-11 Referred to Senate Committee on the Judiciary. Senate Sen. Bartlett, Dewey F. [R-OK] OK R B000200 0 Constitutional Amendment - Provides for the reconfirmation by popular vote of Federal district court judges at the time of every fourth Congressional election after such judge's appointment. 2025-07-21T19:32:26Z  
93-sjres-123 93 sjres 123 Joint resolution authorizing the procurement of an oil portrait and marble bust of former Chief Justice Earl Warren. Law 1973-06-18 1974-10-17 Public law 93-446. Senate Sen. Cranston, Alan [D-CA] CA D C000877 3 Authorizes the procurement of an oil portrait and marble bust of former Chief Justice Earl Warren to be placed in the United State Supreme Court Building. 2025-01-14T17:21:40Z  
93-sjres-16 93 sjres 16 A joint resolution proposing an amendment to the Constitution relating to the continuance in office of judges of the Supreme Court and of inferior courts. Law 1973-01-11 1973-01-11 Referred to Senate Committee on Judiciary. Senate Sen. Scott, William Lloyd [R-VA] VA R S000189 0 Constitutional Amendment - States that unless the president nominates and the Senate consents to the continuance in office of a judge of the Supreme Court or of an inferior court ordained and established by Congress, that judge may not hold office for more than ten years after: (1) he took office; (2) the Senate last consented to his continuance in office, or (3) the ratification of this article; whichever last occurs. 2025-07-21T19:32:26Z  
93-sjres-13 93 sjres 13 A joint resolution proposing an amendment to the Constitution of the United States with respect to the reconfirmation of judges after a term of eight years. Law 1973-01-09 1973-01-09 Referred to Senate Committee on Judiciary. Senate Sen. Byrd, Harry F., Jr. [I-VA] VA I B001209 3 Constitutional Amendment - Provides that each judge of the Supreme Court and each judge of an inferior court established by Congress under section 1 of article III of the Constitution shall hold his office during good behavior for terms of eight years. States that during the eighth year of each term of office of any such judge, his nomination for an additional term of office for the judgeship which he holds shall be placed before the Senate in the manner provided by the law, for the advice and consent of the Senate to such additional term, unless that judge requests that his nomination not be so placed. 2025-07-21T19:32:26Z  

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);
Powered by Datasette · Queries took 1466.534ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API