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

70 rows where bill_type = "sjres" and congress = 117 sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: latest_action_text, sponsor_party, cosponsor_count, introduced_date (date), latest_action_date (date), update_date (date)

policy_area 18

  • International Affairs 18
  • Government Operations and Politics 6
  • Health 6
  • Civil Rights and Liberties, Minority Issues 5
  • Economics and Public Finance 5
  • Labor and Employment 5
  • Armed Forces and National Security 3
  • Congress 3
  • Crime and Law Enforcement 3
  • Emergency Management 2
  • Environmental Protection 2
  • Finance and Financial Sector 2
  • Housing and Community Development 2
  • Immigration 2
  • Law 2
  • Public Lands and Natural Resources 2
  • Commerce 1
  • Education 1

congress 1

  • 117 · 70 ✖

bill_type 1

  • sjres · 70 ✖
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
117-sjres-70 117 sjres 70 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the United States Fish and Wildlife Service relating to "Endangered and Threatened Wildlife and Plants; Lesser Prairie-Chicken; Threatened Status With Section 4(d) Rule for the Northern Distinct Population Segment and Endangered Status for the Southern Distinct Population Segment". Public Lands and Natural Resources 2022-12-21 2022-12-21 Read twice and referred to the Committee on Environment and Public Works. Senate Sen. Marshall, Roger [R-KS] KS R M001198 3 This joint resolution nullifies the final rule issued by the U.S. Fish and Wildlife Service titled Endangered and Threatened Wildlife and Plants; Lesser Prairie-Chicken; Threatened Status With Section 4(d) Rule for the Northern Distinct Population Segment and Endangered Status for the Southern Distinct Population Segment and published on November 25, 2022. The rule adds the Northern Distinct Population Segment of lesser prairie-chicken to the list of threatened species and the Southern District Population Segment of lesser prairie-chicken to the list of endangered species. 2023-04-24T13:30:20Z  
117-sjres-67 117 sjres 67 A joint resolution proposing an amendment to the Constitution of the United States relative to the fundamental right to vote. Government Operations and Politics 2022-12-15 2022-12-15 Read twice and referred to the Committee on the Judiciary. (text: CR S7259-7260) Senate Sen. Durbin, Richard J. [D-IL] IL D D000563 7 This joint resolution proposes a constitutional amendment related to the fundamental right to vote. Specifically, it grants every U.S. citizen of legal voting age the fundamental right to vote in any public election held in the jurisdiction in which the citizen resides. Next, it specifies that the fundamental right to vote shall not be denied or abridged by the United States, a state, or a political subdivision of a state, unless the denial or abridgment is in furtherance of a compelling governmental interest by the least restrictive means. Finally, it repeals a specific portion of the Fourteenth Amendment to the Constitution, which allows for the denial of the right to vote based on crime. (Currently, some states disallow individuals from voting, either temporarily or indefinitely, after incarceration for a felony.) 2022-12-23T05:23:50Z  
117-sjres-68 117 sjres 68 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Department of Labor relating to "Prudence and Loyalty in Selecting Plan Investments and Exercising Shareholder Rights". Labor and Employment 2022-12-15 2022-12-15 Read twice and referred to the Committee on Health, Education, Labor, and Pensions. Senate Sen. Braun, Mike [R-IN] IN R B001310 4 This joint resolution nullifies a Department of Labor rule concerning the fiduciary duties with respect to employee benefit plans. Under the rule issued on December 1, 2022, plan fiduciaries may consider climate change and other environmental, social, and governance factors when they make investment decisions and when they exercise shareholder rights, including voting on shareholder resolutions and board nominations. 2023-12-15T14:44:32Z  
117-sjres-69 117 sjres 69 A joint resolution proposing an amendment to the Constitution of the United States to abolish the electoral college and to provide for the direct election of the President and Vice President of the United States. Government Operations and Politics 2022-12-15 2022-12-15 Read twice and referred to the Committee on the Judiciary. Senate Sen. Merkley, Jeff [D-OR] OR D M001176 2 This joint resolution proposes a constitutional amendment requiring the President and Vice President to be jointly elected directly by the people of the states and the District of Columbia over the age of 18. 2023-01-05T05:15:34Z  
117-sjres-66 117 sjres 66 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Department of Veterans Affairs relating to "Reproductive Health Services". Armed Forces and National Security 2022-12-13 2022-12-13 Read twice and referred to the Committee on Veterans' Affairs. Senate Sen. Tuberville, Tommy [R-AL] AL R T000278 6 This joint resolution nullifies the interim final rule issued by the Department of Veterans Affairs (VA) titled Reproductive Health Services and published on September 9, 2022. The rule authorizes the VA to provide certain abortion-related care to veterans. The rule also applies to such care provided to beneficiaries covered under the Civilian Health and Medical Program of the Department of Veterans Affairs (CHAMPVA). 2023-06-20T10:45:21Z  
117-sjres-65 117 sjres 65 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Department of Labor relating to "Prudence and Loyalty in Selecting Plan Investments and Exercising Shareholder Rights". Labor and Employment 2022-12-01 2022-12-01 Read twice and referred to the Committee on Health, Education, Labor, and Pensions. Senate Sen. Cotton, Tom [R-AR] AR R C001095 0 This joint resolution nullifies a Department of Labor rule concerning the fiduciary duties with respect to employee benefit plans. Under the rule issued on December 1, 2022, plan fiduciaries may consider climate change and other environmental, social, and governance factors when they make investment decisions and when they exercise shareholder rights, including voting on shareholder resolutions and board nominations. 2023-03-02T08:31:17Z  
117-sjres-64 117 sjres 64 A joint resolution disapproving of the rule submitted by the Department of Homeland Security relating to "Public Charge Ground of Inadmissibility". Immigration 2022-11-14 2022-11-14 Read twice and referred to the Committee on the Judiciary. Senate Sen. Marshall, Roger [R-KS] KS R M001198 2 This joint resolution nullifies the final rule submitted by the Department of Homeland Security titled Public Charge Ground of Inadmissibility and published on September 9, 2022. The 2022 final rule nullified an August 14, 2019, final rule. The 2019 final rule made it more likely that a non-U.S. national (alien under federal law) would be denied admission or lawful permanent resident status because that individual is likely to become a public charge (i.e., receive certain public benefits). This joint resolution restores into effect the nullified 2019 final rule. 2023-08-07T23:45:18Z  
117-sjres-63 117 sjres 63 A joint resolution relating to a national emergency declared by the President on March 13, 2020. Emergency Management 2022-09-22 2022-11-16 Held at the desk. Senate Sen. Marshall, Roger [R-KS] KS R M001198 9 This joint resolution terminates the national emergency concerning COVID-19 declared by the President on March 13, 2020. 2023-11-13T13:43:49Z  
117-sjres-62 117 sjres 62 A joint resolution approving the location of a memorial to commemorate the commitment of the United States to a free press by honoring journalists who sacrificed their lives in service to that cause. Public Lands and Natural Resources 2022-09-14 2022-12-01 Committee on Energy and Natural Resources. Hearings held. Senate Sen. Cardin, Benjamin L. [D-MD] MD D C000141 2 This joint resolution approves of a location of a commemorative work to honor the commitment of the United States to a free press by honoring journalists who sacrificed their lives in service to that cause. Specifically, the approved location is within Area I, as depicted on the map titled Commemorative Areas Washington, DC and Environs, and dated June 24, 2003. 2023-09-01T15:45:20Z  
117-sjres-61 117 sjres 61 A joint resolution to provide for the resolution of issues in a railway labor-management dispute, and for other purposes. Labor and Employment 2022-09-12 2022-09-12 Read twice and referred to the Committee on Health, Education, Labor, and Pensions. Senate Sen. Burr, Richard [R-NC] NC R B001135 8 This joint resolution requires the parties to the disputes between certain railroads and labor organizations to accept the recommendations in the report of the Presidential Emergency Board Numbered 250 that was issued on August 16, 2022, with respect to any such disputes that remain unresolved by 12:01 a.m. eastern daylight time on September 16, 2022. 2022-12-29T13:18:32Z  
117-sjres-60 117 sjres 60 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Department of Education relating to "Final Priorities, Requirements, Definitions, and Selection Criteria-Expanding Opportunity Through Quality Charter Schools Program (CSP)-Grants to State Entities (State Entity Grants); Grants to Charter Management Organizations for the Replication and Expansion of High-Quality Charter Schools (CMO Grants); and Grants to Charter School Developers for the Opening of New Charter Schools and for the Replication and Expansion of High-Quality Charter Schools (Developer Grants)". Education 2022-09-08 2022-12-14 Failed of passage in Senate by Yea-Nay Vote. 49 - 49. Record Vote Number: 390. Senate Sen. Scott, Tim [R-SC] SC R S001184 24 This joint resolution nullifies a Department of Education rule published on July 6, 2022, concerning final priorities, requirements, definitions, and selection criteria for the Charter Schools Program. 2023-01-10T05:25:31Z  
117-sjres-58 117 sjres 58 A joint resolution providing for congressional disapproval of the proposed foreign military sale to the Kingdom of Saudi Arabia of certain defense articles and services. International Affairs 2022-08-04 2022-08-04 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 This joint resolution prohibits the proposed foreign military sale of certain defense articles and services to Saudi Arabia. 2023-01-11T13:50:20Z  
117-sjres-59 117 sjres 59 A joint resolution providing for congressional disapproval of the proposed foreign military sale to the Government of the United Arab Emirates of certain defense articles and services. International Affairs 2022-08-04 2022-08-04 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 This joint resolution prohibits the proposed foreign military sale of certain defense articles and services to the United Arab Emirates. 2023-01-11T13:50:19Z  
117-sjres-57 117 sjres 57 A joint resolution redesignating the Robert E. Lee Memorial in Arlington National Cemetery as the "Arlington House National Historic Site". Armed Forces and National Security 2022-07-18 2022-09-21 Committee on Energy and Natural Resources Subcommittee on National Parks. Hearings held. Senate Sen. Kaine, Tim [D-VA] VA D K000384 0 This joint resolution redesignates the memorial to Robert. E. Lee in Arlington National Cemetery as the Arlington House National Historic Site. 2023-02-08T05:24:32Z  
117-sjres-56 117 sjres 56 A joint resolution directing the removal of United States Armed Forces from hostilities in the Republic of Yemen that have not been authorized by Congress. International Affairs 2022-07-14 2022-07-14 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Sanders, Bernard [I-VT] VT I S000033 13 This joint resolution directs the President to remove U.S. Armed Forces from hostilities against the Houthis in Yemen within 30 days of the enactment of this joint resolution unless Congress authorizes a later withdrawal date, issues a declaration of war, or specifically authorizes the use of the Armed Forces. Prohibited activities include sharing intelligence or providing logistical support to enable offensive strikes by the coalition led by Saudi Arabia. This joint resolution shall not affect any military operations directed at Al Qaeda or forces associated with Al Qaeda. 2022-12-29T18:48:37Z  
117-sjres-55 117 sjres 55 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Council on Environmental Quality relating to "National Environmental Policy Act Implementing Regulations Revisions". Environmental Protection 2022-07-13 2022-09-21 Star Print ordered on the joint resolution. Senate Sen. Sullivan, Dan [R-AK] AK R S001198 49 This joint resolution nullifies the final rule issued by the Council on Environmental Quality titled National Environmental Policy Act Implementing Regulations Revisions and published on April 20, 2022. The rule restores regulatory provisions issued under the National Environmental Policy Act of 1969 (NEPA) that were in effect before being modified in 2020 by the Update to the Regulations Implementing the Procedural Provisions of the National Environmental Policy Act rule. 2022-12-29T19:18:37Z  
117-sjres-53 117 sjres 53 A joint resolution providing for congressional disapproval of the proposed foreign military sale to the Government of Australia of certain defense articles and services. International Affairs 2022-06-23 2022-06-23 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 This joint resolution prohibits the proposed foreign military sale of specified defense articles and services to Australia. 2022-12-29T17:48:32Z  
117-sjres-54 117 sjres 54 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Bureau of Alcohol, Tobacco, Firearms, and Explosives relating to Definition of "Frame or Receiver" and Identification of Firearms. Crime and Law Enforcement 2022-06-23 2022-06-23 Read twice and referred to the Committee on the Judiciary. Senate Sen. Cruz, Ted [R-TX] TX R C001098 19 This joint resolution nullifies a Bureau of Alcohol, Tobacco, Firearms and Explosives rule published on April 26, 2022, concerning regulatory definitions and identification of firearms. 2023-08-09T15:45:21Z  
117-sjres-52 117 sjres 52 A joint resolution providing for congressional disapproval of the proposed foreign military sale to the Government of Egypt of certain defense articles and services. International Affairs 2022-06-07 2022-06-07 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 This joint resolution prohibits the proposed foreign military sale of specified defense articles and services to Egypt. 2022-12-29T17:48:33Z  
117-sjres-49 117 sjres 49 A joint resolution providing for congressional disapproval of the proposed foreign military sale to the Government of Australia of certain defense articles and services. International Affairs 2022-06-06 2022-06-06 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 This joint resolution prohibits the proposed foreign military sale of certain defense articles and services to Australia. 2022-12-29T17:48:33Z  
117-sjres-50 117 sjres 50 A joint resolution providing for congressional disapproval of the proposed foreign military sale to the Government of Egypt of certain defense articles and services. International Affairs 2022-06-06 2022-06-06 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 This joint resolution prohibits the proposed foreign military sale of specified defense articles and services to Egypt. 2022-12-29T17:48:33Z  
117-sjres-51 117 sjres 51 A joint resolution providing for congressional disapproval of the proposed foreign military sale to the Government of Egypt of certain defense articles and services. International Affairs 2022-06-06 2022-06-06 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 This joint resolution prohibits the proposed foreign military sale of specified defense articles and services to Egypt. 2022-12-29T17:48:33Z  
117-sjres-48 117 sjres 48 A joint resolution providing for congressional disapproval of the proposed foreign military sale to the Government of Egypt of certain defense articles and services. International Affairs 2022-05-26 2022-05-26 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 This joint resolution disapproves of the proposed foreign military sale of specified defense articles and services to Egypt. 2022-12-29T16:48:33Z  
117-sjres-47 117 sjres 47 A joint resolution directing the Federal Trade Commission to investigate and report on anticompetitive practices and violations of antitrust law in the beef packing industry. Commerce 2022-05-19 2022-05-19 Read twice and referred to the Committee on the Judiciary. Senate Sen. Warren, Elizabeth [D-MA] MA D W000817 1 This resolution directs the Federal Trade Commission to investigate and report on the extent of anticompetitive practices such as price fixing within the beef packing industry. 2022-12-29T16:48:32Z  
117-sjres-46 117 sjres 46 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Department of Justice and the Department of Homeland Security relating to "Procedures for Credible Fear Screening and Consideration of Asylum, Withholding of Removal, and CAT Protection Claims by Asylum Officers". Immigration 2022-04-28 2022-05-26 Motion by Senator McConnell to reconsider the vote by which S.J. Res. 46 failed of passage (Record Vote No. 211) entered in Senate. Senate Sen. Johnson, Ron [R-WI] WI R J000293 30 This joint resolution nullifies the interim final rule submitted by the Department of Justice and the Department of Homeland Security and published on March 29, 2022, concerning procedures for the consideration of asylum claims and other related issues. (Among other changes, the interim final rule requires an asylum seeker subject to expedited removal to be screened by an asylum officer for a credible fear of persecution or torture, rather than a credible fear of persecution, reasonable possibility of persecution, or reasonable possibility of torture.) 2022-12-29T23:48:35Z  
117-sjres-45 117 sjres 45 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Bureau of Alcohol, Tobacco, Firearms, and Explosives relating to "Definition of 'Frame or Receiver' and Identification of Firearms". Crime and Law Enforcement 2022-04-27 2022-04-27 Read twice and referred to the Committee on the Judiciary. Senate Sen. Cruz, Ted [R-TX] TX R C001098 22 This joint resolution nullifies a Bureau of Alcohol, Tobacco, Firearms and Explosives rule published on April 26, 2022, concerning regulatory definitions and identification of firearms. 2023-08-08T20:00:28Z  
117-sjres-44 117 sjres 44 A joint resolution relating to the disapproval of the proposed sale to the Government of Bahrain of certain defense articles and services. International Affairs 2022-03-30 2022-03-30 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 This joint resolution disapproves of the proposed sale of specified defense articles and services to Bahrain. 2022-12-29T22:48:20Z  
117-sjres-43 117 sjres 43 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Department of the Treasury and the Centers for Medicare & Medicaid Services relating to "Patient Protection and Affordable Care Act; Updating Payment Parameters, Section 1332 Waiver Implementing Regulations, and Improving Health Insurance Markets for 2022 and Beyond". Health 2022-03-23 2022-03-23 Read twice and referred to the Committee on Health, Education, Labor, and Pensions. Senate Sen. Hyde-Smith, Cindy [R-MS] MS R H001079 32 This joint resolution nullifies the rule titled Patient Protection and Affordable Care Act; Updating Payment Parameters, Section 1332 Waiver Implementing Regulations, and Improving Health Insurance Markets for 2022 and Beyond, which was issued by the Centers for Medicare & Medicaid Services and the Department of the Treasury on September 27, 2021. The rule expands the open enrollment period for individual health coverage and rescinds the previous interpretation of certain requirements relating to Section 1332 waivers (also known as State Innovation Waivers or State Relief and Empowerment Waivers). 2022-12-29T22:48:20Z  
117-sjres-42 117 sjres 42 A joint resolution proposing a balanced budget amendment to the Constitution of the United States. Economics and Public Finance 2022-03-17 2022-03-17 Read twice and referred to the Committee on the Judiciary. Senate Sen. Braun, Mike [R-IN] IN R B001310 0 This joint resolution proposes a constitutional amendment prohibiting total federal expenditures for a year from exceeding the average annual federal revenue collected in the three prior years, adjusted for changes in population and inflation. Expenditures for payment of debt and revenues derived from borrowing are excluded. Congress may authorize specific expenditures in excess of the limit for up to one year by declaring an emergency with a roll call vote of two-thirds of each chamber. The requirements take effect in the first year beginning at least 90 days following ratification, except that expenditures are permitted to exceed the limit by specified amounts during each of the first nine years that the requirements are in effect. 2022-12-29T22:48:20Z  
117-sjres-41 117 sjres 41 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Department of Health and Human Services relating to "Ensuring Access to Equitable, Affordable, Client-Centered, Quality Family Planning Services". Health 2022-03-16 2022-04-27 Motion to proceed to consideration of measure rejected in Senate by Yea-Nay Vote. 49 - 49. Record Vote Number: 140. Senate Sen. Rubio, Marco [R-FL] FL R R000595 36 This joint resolution nullifies the rule issued by the Department of Health and Human Services on October 7, 2021, that reverts requirements for federally funded providers of family planning services to those in effect before May 3, 2019, and makes other changes to family planning programs. Specific changes in the rule include (1) removing restrictions on pregnancy options counseling and referrals for abortion services, (2) eliminating requirements for physical and financial separation between abortion-related activities and specified family planning activities, and (3) providing a particular focus on health equity. 2022-12-29T22:48:20Z  
117-sjres-40 117 sjres 40 A joint resolution formally apologizing for the nuclear legacy of the United States in the Republic of the Marshall Islands and affirming the importance of the free association between the Government of the United States and the Government of the Marshall Islands. International Affairs 2022-03-01 2022-03-01 Read twice and referred to the Committee on Energy and Natural Resources. (Sponsor introductory remarks on measure: CR S885-886) Senate Sen. Hirono, Mazie K. [D-HI] HI D H001042 3 This joint resolution expresses that Congress recognizes that the United States' nuclear testing program and radioactive waste disposal in the Marshall Islands caused irreparable material and intangible harm to the people of those islands, apologizes on behalf of the United States to the individuals and families of the Marshall Islands for the hardships they have endured as a result of the U.S. nuclear testing program and radioactive waste disposal, and recognizes that it is incumbent on the United States to open dialogue regarding the nuclear legacy of the United States in Marshall Islands during any negotiation of the Compact of Free Association or its subsidiary agreements. 2022-12-29T22:48:20Z  
117-sjres-38 117 sjres 38 A joint resolution relating to a national emergency declared by the President on March 13, 2020. Emergency Management 2022-02-14 2022-03-03 Passed Senate without amendment by Yea-Nay Vote. 48 - 47. Record Vote Number: 68. (text: CR S982) Senate Sen. Marshall, Roger [R-KS] KS R M001198 9 This joint resolution terminates the national emergency concerning COVID-19 declared by the President on March 13, 2020. 2022-12-29T22:48:20Z  
117-sjres-39 117 sjres 39 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Department of Health and Human Services relating to "Vaccine and Mask Requirements To Mitigate the Spread of COVID-19 in Head Start Programs. Health 2022-02-14 2022-05-06 Held at the desk. Senate Sen. Thune, John [R-SD] SD R T000250 28 This joint resolution nullifies a Department of Health and Human Services rule published on November 30, 2021, concerning vaccine and mask requirements to mitigate the spread of COVID-19 in Head Start programs. These programs provide comprehensive early education and development services to low-income children. 2022-12-29T21:33:28Z  
117-sjres-37 117 sjres 37 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by Centers for Disease Control and Prevention relating to "Requirement for Persons To Wear Masks While on Conveyances and at Transportation Hubs". Health 2022-02-10 2022-03-15 Passed Senate without amendment by Yea-Nay Vote. 57 - 40. Record Vote Number: 81. (text: CR S1171) Senate Sen. Paul, Rand [R-KY] KY R P000603 21 This joint resolution nullifies the rule issued by the Centers for Disease Control and Prevention on February 3, 2021, that requires the use of face masks on planes, trains, buses, and other public conveyances and at transportation hubs to prevent the transmission of COVID-19. 2022-12-29T22:48:20Z  
117-sjres-35 117 sjres 35 A joint resolution providing for congressional disapproval of the proposed foreign military sale to the Government of Egypt of certain defense articles and services. International Affairs 2022-02-07 2022-03-10 Motion to discharge Senate Committee on Foreign Relations rejected by Yea-Nay Vote. 19 - 80. Record Vote Number: 73. (CR S1095) Senate Sen. Paul, Rand [R-KY] KY R P000603 0 This joint resolution prohibits the proposed foreign military sale of specified defense articles and services to Egypt. 2022-12-29T21:33:28Z  
117-sjres-36 117 sjres 36 A joint resolution providing for congressional disapproval of the proposed foreign military sale to the Government of Egypt of certain defense articles and services. International Affairs 2022-02-07 2022-02-07 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Paul, Rand [R-KY] KY R P000603 0 This joint resolution prohibits the proposed foreign military sale of specified defense articles and services to Egypt. 2022-12-29T21:33:28Z  
117-sjres-34 117 sjres 34 A joint resolution disapproving the action of the District of Columbia Council in approving the Coronavirus Immunization of School Students and Early Childhood Workers Amendment Act of 2021. Government Operations and Politics 2022-01-19 2022-01-19 Read twice and referred to the Committee on Homeland Security and Governmental Affairs. Senate Sen. Cruz, Ted [R-TX] TX R C001098 3 This joint resolution disapproves of the action of the District of Columbia Council in approving the Coronavirus Immunization of School Students and Early Childhood Workers Amendment Act of 2021 (D.C. Act 24-285), enacted by the council on January 12, 2022. 2022-12-30T04:04:45Z  
117-sjres-33 117 sjres 33 A joint resolution joint resolution relating to increasing the debt limit. Economics and Public Finance 2021-12-14 2021-12-16 Became Public Law No: 117-73. Senate Sen. Schumer, Charles E. [D-NY] NY D S000148 0 This joint resolution increases the public debt limit by $2.5 trillion. 2023-03-08T20:26:27Z  
117-sjres-32 117 sjres 32 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Centers for Medicare & Medicaid Services relating to "Medicare and Medicaid Programs; Omnibus COVID-19 Health Care Staff Vaccination". Health 2021-12-09 2022-03-02 Passed Senate without amendment by Yea-Nay Vote. 49 - 44. Record Vote Number: 67. (text: CR S936) Senate Sen. Marshall, Roger [R-KS] KS R M001198 36 This joint resolution nullifies the rule titled Medicare and Medicaid Programs; Omnibus COVID-19 Health Care Staff Vaccination, which was issued by the Centers for Medicare & Medicaid Services on November 5, 2021. The rule requires health care providers, as a condition of Medicare and Medicaid participation, to ensure that staff are fully vaccinated against COVID-19. 2022-12-30T03:33:59Z  
117-sjres-31 117 sjres 31 A joint resolution providing for congressional disapproval of the proposed foreign military sale to the Kingdom of Saudi Arabia of certain defense articles. International Affairs 2021-11-18 2021-12-07 Motion to discharge Senate Committee on Foreign Relations rejected by Yea-Nay Vote. 30 - 67. Record Vote Number: 484. (consideration: CR S8955) Senate Sen. Paul, Rand [R-KY] KY R P000603 8 This joint resolution prohibits the proposed foreign military sale of specified defense articles to Saudi Arabia. 2022-12-30T02:48:56Z  
117-sjres-29 117 sjres 29 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Department of Labor relating to "COVID-19 Vaccination and Testing; Emergency Temporary Standard". Labor and Employment 2021-11-17 2021-12-09 Held at the desk. Senate Sen. Braun, Mike [R-IN] IN R B001310 50 This joint resolution nullifies a Department of Labor emergency temporary standard for preventing the transmission of COVID-19 in employment settings. Under the standard issued on November 5, 2021, employers with 100 or more employees must require their onsite employees to either be fully vaccinated against COVID-19 or undergo weekly COVID-19 testing. 2022-12-30T03:33:59Z  
117-sjres-30 117 sjres 30 Original Slavery Remembrance Day Resolution Civil Rights and Liberties, Minority Issues 2021-11-17 2021-11-17 Read twice and referred to the Committee on the Judiciary. Senate Sen. Warren, Elizabeth [D-MA] MA D W000817 11 Original Slavery Remembrance Day Resolution This joint resolution designates a Slavery Remembrance Day annually on August 20 and condemns slavery and its progenies. 2022-12-30T02:48:56Z  
117-sjres-28 117 sjres 28 A joint resolution proposing an amendment to the Constitution of the United States relative to equal rights for men and women. Civil Rights and Liberties, Minority Issues 2021-10-07 2021-10-07 Read twice and referred to the Committee on the Judiciary. (text: CR S2283-2284) Senate Sen. Menendez, Robert [D-NJ] NJ D M000639 16 This joint resolution proposes a constitutional amendment prohibiting the United States or any state from denying or abridging equal rights under the law on account of sex. 2023-01-01T23:48:21Z  
117-sjres-27 117 sjres 27 A joint resolution proposing an amendment to the Constitution of the United States relative to limiting the number of terms that a Member of Congress may serve. Congress 2021-10-06 2021-10-06 Read twice and referred to the Committee on the Judiciary. Senate Sen. Lankford, James [R-OK] OK R L000575 0 This joint resolution proposes a constitutional amendment limiting Representatives to eight terms and Senators to three terms. Terms beginning before the ratification of this amendment do not count towards term limits. 2023-01-01T23:48:22Z  
117-sjres-26 117 sjres 26 Ulysses S. Grant Bicentennial Recognition Act Armed Forces and National Security 2021-09-22 2021-09-22 Read twice and referred to the Committee on the Judiciary. Senate Sen. Blunt, Roy [R-MO] MO R B000575 1 Ulysses S. Grant Bicentennial Recognition Act This joint resolution authorizes the President to posthumously appoint Ulysses S. Grant to the grade of General of the Armies of the United States, effective on April 27, 2022. 2023-01-02T00:29:07Z  
117-sjres-25 117 sjres 25 A joint resolution proposing an amendment to the Constitution of the United States relating to contributions and expenditures intended to affect elections. Government Operations and Politics 2021-09-20 2021-09-20 Read twice and referred to the Committee on the Judiciary. Senate Sen. Shaheen, Jeanne [D-NH] NH D S001181 40 This joint resolution proposes a constitutional amendment authorizing Congress and the states to set reasonable limits on the raising and spending of money by candidates and others to influence elections. The amendment grants Congress and the states the power to implement and enforce this amendment by legislation. They are allowed to distinguish between natural persons and corporations or other artificial entities created by law, including by prohibiting such entities from spending money to influence elections. 2023-01-02T00:29:07Z  
117-sjres-23 117 sjres 23 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by Centers for Disease Control and Prevention relating to "Temporary Halt in Residential Evictions in Communities with Substantial or High Transmission of COVID-19 To Prevent the Further Spread of COVID-19". Housing and Community Development 2021-08-10 2021-08-10 Read twice and referred to the Committee on Health, Education, Labor, and Pensions. Senate Sen. Toomey, Patrick [R-PA] PA R T000461 0 This joint resolution nullifies the order submitted by the Centers for Disease Control and Prevention titled Temporary Halt in Residential Evictions in Communities With Substantial or High Transmission of COVID-19 To Prevent the Further Spread of COVID-19 and published on August 6, 2021. 2023-01-01T20:16:59Z  
117-sjres-24 117 sjres 24 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by Centers for Disease Control and Prevention relating to "Temporary Halt in Residential Evictions in Communities with Substantial or High Transmission of COVID-19 To Prevent the Further Spread of COVID-19". Housing and Community Development 2021-08-10 2021-08-10 Read twice and referred to the Committee on Health, Education, Labor, and Pensions. Senate Sen. Marshall, Roger [R-KS] KS R M001198 2 This joint resolution nullifies the order submitted by the Centers for Disease Control and Prevention titled Temporary Halt in Residential Evictions in Communities With Substantial or High Transmission of COVID-19 To Prevent the Further Spread of COVID-19 and published on August 6, 2021. 2023-01-01T20:16:59Z  
117-sjres-22 117 sjres 22 A joint resolution to prospectively repeal the 2001 Authorization for Use of Military Force. International Affairs 2021-08-09 2021-08-09 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Cardin, Benjamin L. [D-MD] MD D C000141 1 This joint resolution repeals the 2001 Authorization for Use of Military Force, effective one year after the date of enactment of the resolution. The 2001 Authorization for Use of Military Force authorized the President to use all necessary and appropriate force against the nations, organizations, or persons determined to have taken part in carrying out the terrorist attacks of September 11, 2001. 2023-01-01T20:16:59Z  
117-sjres-21 117 sjres 21 A joint resolution proposing an amendment to the Constitution of the United States to prohibit the use of slavery and involuntary servitude as a punishment for a crime. Crime and Law Enforcement 2021-06-17 2021-06-17 Read twice and referred to the Committee on the Judiciary. Senate Sen. Merkley, Jeff [D-OR] OR D M001176 14 This joint resolution proposes an amendment to the U.S. Constitution that prohibits slavery and involuntary servitude as a criminal punishment. 2022-12-31T05:25:41Z  
117-sjres-20 117 sjres 20 A joint resolution proposing an amendment to the Constitution of the United States authorizing the Congress to prohibit the physical desecration of the flag of the United States. Civil Rights and Liberties, Minority Issues 2021-06-14 2021-06-14 Read twice and referred to the Committee on the Judiciary. Senate Sen. Daines, Steve [R-MT] MT R D000618 7 This joint resolution proposes a constitutional amendment to authorize Congress to prohibit the physical desecration of the U.S. flag. 2022-12-31T05:25:42Z  
117-sjres-19 117 sjres 19 A joint resolution providing for congressional disapproval of the proposed transfer to Israel of certain defense articles, including defense services and technical data. International Affairs 2021-05-20 2021-05-20 Read twice and referred to the Committee on Foreign Relations. Senate Sen. Sanders, Bernard [I-VT] VT I S000033 0 This joint resolution prohibits the issuance of an export license for specified defense articles, defense services, and technical data for end use by Israel. 2023-01-11T13:49:57Z  
117-sjres-18 117 sjres 18 A joint resolution proposing an amendment to the Constitution of the United States to repeal the twenty-third article of amendment to the Constitution of the United States. Government Operations and Politics 2021-04-22 2021-04-22 Read twice and referred to the Committee on the Judiciary. Senate Sen. Marshall, Roger [R-KS] KS R M001198 0 This joint resolution proposes a constitutional amendment repealing the Twenty-third Amendment to the Constitution (allowing citizens residing in the District of Columbia to vote for presidential electors, who in turn vote in the electoral college for the President and Vice President). 2023-01-11T13:49:02Z  
117-sjres-17 117 sjres 17 A joint resolution requiring the advice and consent of the Senate or an Act of Congress to suspend, terminate, or withdraw the United States from the North Atlantic Treaty and authorizing related litigation, and for other purposes. International Affairs 2021-04-15 2022-04-06 Placed on Senate Legislative Calendar under General Orders. Calendar No. 337. Senate Sen. Kaine, Tim [D-VA] VA D K000384 17 This joint resolution requires either the advice and consent of the Senate or an act of Congress before the President may suspend, denounce, or withdraw the United States from the North Atlantic Treaty. No funds may be used to support any efforts to suspend, denounce, or withdraw the United States from the treaty unless (1) both the House and the Senate pass a joint resolution approving withdrawal by a two-thirds vote, or (2) the funds are used pursuant to an act of Congress. The President shall notify Congress in writing of any effort to suspend, denounce, or withdraw from the treaty at least 180 days before taking such action. The President must also consult with Congress before providing such written notification. This joint resolution also authorizes the Senate Legal Counsel and the General Counsel of the House of Representatives to represent Congress in judicial proceedings related to actions that are inconsistent with this resolution. 2023-01-11T13:49:02Z  
117-sjres-14 117 sjres 14 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Environmental Protection Agency relating to "Oil and Natural Gas Sector: Emission Standards for New, Reconstructed, and Modified Sources Review". Environmental Protection 2021-03-25 2021-06-30 Became Public Law No: 117-23. Senate Sen. Heinrich, Martin [D-NM] NM D H001046 23 This joint resolution nullifies the Oil and Natural Gas Sector: Emission Standards for New, Reconstructed, and Modified Sources Review rule published by the Environmental Protection Agency on September 14, 2020. The rule finalized amendments to new source performance standards under the Clean Air Act for the oil and natural gas sector, such as an amendment that removed limitations on methane emissions from such sector. 2023-03-08T20:12:01Z  
117-sjres-15 117 sjres 15 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Office of the Comptroller of Currency relating to "National Banks and Federal Savings Associations as Lenders". Finance and Financial Sector 2021-03-25 2021-06-30 Became Public Law No: 117-24. Senate Sen. Van Hollen, Chris [D-MD] MD D V000128 9 This joint resolution nullifies the final rule issued by the Office of the Comptroller of the Currency titled National Banks and Federal Savings Associations as Lenders and published on October 30, 2020. The rule requires that to be considered a lender, a national bank or federal saving association must, as of the date of origination of the loan (1) be named as the lender in the loan agreement, or (2) fund the loan. 2023-03-08T20:12:01Z  
117-sjres-16 117 sjres 16 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Securities and Exchange Commission relating to "Procedural Requirements and Resubmission Thresholds Under Exchange Act Rule 14a-8". Finance and Financial Sector 2021-03-25 2021-03-25 Read twice and referred to the Committee on Banking, Housing, and Urban Affairs. Senate Sen. Brown, Sherrod [D-OH] OH D B000944 0 This joint resolution nullifies the final rule issued by the Securities and Exchange Commission titled Procedural Requirements and Resubmission Thresholds Under Exchange Act Rule 14a-8 and published on November 4, 2020. The rule provides additional requirements for the inclusion of shareholder proposals in proxy statements, such as increasing the securities ownership requirements for submitting a proposal and increasing the level of support a proposal must receive to be eligible for resubmission at a future shareholder meeting. (Proxy statements must be filed by a publicly traded company and provided to shareholders before shareholder meetings. Proxy statements contain information regarding matters such as the election of directors and shareholder proposals.) 2023-01-11T13:47:32Z  
117-sjres-13 117 sjres 13 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Equal Employment Opportunity Commission relating to "Update of Commission's Conciliation Procedures". Labor and Employment 2021-03-23 2021-06-30 Became Public Law No: 117-22. Senate Sen. Murray, Patty [D-WA] WA D M001111 0 This resolution expresses congressional disapproval of the rule submitted by the Equal Employment Opportunity Commission (EEOC) that revises the EEOC settlement process to provide employers with the factual and legal basis that the EEOC relied on to make a reasonable cause finding of a discriminatory practice. 2023-03-08T20:12:01Z  
117-sjres-12 117 sjres 12 A joint resolution proposing an amendment to the Constitution of the United States which requires (except during time of war and subject to suspension by Congress) that the total amount of money expended by the United States during any fiscal year not exceed the amount of certain revenue received by the United States during such fiscal year and not exceed 20 percent of the gross domestic product of the United States during the previous calendar year. Economics and Public Finance 2021-03-18 2021-03-18 Read twice and referred to the Committee on the Judiciary. Senate Sen. Shelby, Richard C. [R-AL] AL R S000320 0 This joint resolution proposes a constitutional amendment prohibiting the total amount of money expended by the United States during a fiscal year from exceeding total revenue received for that fiscal year, excluding revenue from the issuance of bonds, notes, or other obligations of the United States. The amendment also prohibits the total amount of money expended by the United States in any fiscal year from exceeding 20% of the gross domestic product of the United States. The restrictions do not apply during a fiscal year in which a declaration of war is in effect, or if three-fifths of each chamber of Congress votes to suspend the restrictions. 2023-01-11T13:47:33Z  
117-sjres-11 117 sjres 11 A joint resolution proposing an amendment to the Constitution of the United States to clarify the authority of Congress and the States to regulate corporations, limited liability companies, and other corporate entities established by the laws of any State, the United States, or any foreign state. Civil Rights and Liberties, Minority Issues 2021-03-15 2021-03-15 Read twice and referred to the Committee on the Judiciary. Senate Sen. Tester, Jon [D-MT] MT D T000464 0 This joint resolution proposes a constitutional amendment declaring that (1) the rights enumerated in the Constitution and other rights retained by the people are the rights of natural persons; (2) the terms "people," "person," and "citizen" as used in the Constitution do not include corporate entities; and (3) corporate entities are subject to such regulation as the people, through representatives in Congress and state representatives, may determine reasonable, consistent with the powers of Congress and the states. 2023-01-11T13:47:33Z  
117-sjres-10 117 sjres 10 A joint resolution to repeal the authorizations for use of military force against Iraq, and for other purposes. International Affairs 2021-03-03 2021-08-04 Placed on Senate Legislative Calendar under General Orders. Calendar No. 117. Senate Sen. Kaine, Tim [D-VA] VA D K000384 51 This joint resolution repeals specified authorizations for the use of military force against Iraq. 2023-02-28T17:55:06Z  
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-8 117 sjres 8 A joint resolution providing for the appointment of Barbara M. Barrett as a citizen regent of the Board of Regents of the Smithsonian Institution. Government Operations and Politics 2021-02-23 2021-02-23 Read twice and referred to the Committee on Rules and Administration. Senate Sen. Leahy, Patrick J. [D-VT] VT D L000174 1 This joint resolution appoints Barbara M. Barrett as a citizen regent of the Board of Regents of the Smithsonian Institution. 2023-01-11T13:46:29Z  
117-sjres-7 117 sjres 7 A joint resolution disapproving the action of the District of Columbia Council in approving the Minor Consent for Vaccinations Amendment Act of 2020. Health 2021-02-08 2021-02-08 Read twice and referred to the Committee on Homeland Security and Governmental Affairs. Senate Sen. Lee, Mike [R-UT] UT R L000577 7 This joint resolution nullifies the action of the District of Columbia Council in approving the Minor Consent for Vaccinations Amendment Act of 2020, enacted by the council on December 23, 2020, and transmitted on February 4, 2021 [sic], to Congress pursuant to the District of Columbia Home Rule Act. The act authorizes a minor, 11 years of age or older, to consent to receive a vaccine if the minor is capable of meeting the informed consent standard and the vaccine is recommended by the United States Advisory Committee on Immunization Practices and will be provided in accordance with its recommended immunization schedule. 2023-01-11T13:46:29Z  
117-sjres-6 117 sjres 6 A joint resolution proposing an amendment to the Constitution of the United States relative to balancing the budget. Economics and Public Finance 2021-02-03 2021-02-03 Read twice and referred to the Committee on the Judiciary. Senate Sen. Hyde-Smith, Cindy [R-MS] MS R H001079 15 This joint resolution proposes a constitutional amendment prohibiting total outlays for a fiscal year from exceeding total receipts for that fiscal year unless Congress authorizes the excess by a two-thirds vote of each chamber. The prohibition excludes outlays for repayment of debt principal and receipts derived from borrowing. The amendment prohibits total outlays for any fiscal year from exceeding 18% of the gross domestic product of the United States, unless two-thirds of each chamber of Congress provides for a specific increase above this amount. The amendment requires a two-thirds vote of each chamber of Congress to impose a new tax, increase the statutory rate of any tax, or increase the aggregate amount of revenue. It requires a three-fifths vote of each chamber to increase the limit on the debt of the United States. The President must submit an annual budget in which total outlays do not exceed total receipts and 18% of the gross domestic product of the United States. The amendment prohibits a court from ordering a revenue increase to enforce the requirements. Congress may waive specified requirements when a declaration of war is in effect or the United States is engaged in a military conflict that causes an imminent and serious military threat to national security. 2023-01-11T13:46:29Z  
117-sjres-1 117 sjres 1 A joint resolution removing the deadline for the ratification of the equal rights amendment. Civil Rights and Liberties, Minority Issues 2021-01-22 2021-03-03 Star Print ordered on the joint resolution. Senate Sen. Cardin, Benjamin L. [D-MD] MD D C000141 51 This joint resolution eliminates the deadline for the ratification of the Equal Rights Amendment, which prohibits discrimination based on sex. The amendment was proposed to the states in House Joint Resolution 208 of the 92nd Congress, as agreed to in the Senate on March 22, 1972. The amendment shall be part of the Constitution whenever ratified by the legislatures of three-fourths of the states. 2023-05-11T15:46:24Z  
117-sjres-2 117 sjres 2 A joint resolution proposing amendments to the Constitution of the United States relative to the line item veto, a limitation on the number of terms that a Member of Congress may serve, and requiring a vote of two-thirds of the membership of both Houses of Congress on any legislation raising or imposing new taxes or fees. Congress 2021-01-22 2021-01-22 Read twice and referred to the Committee on the Judiciary. Senate Sen. Scott, Rick [R-FL] FL R S001217 0 This joint resolution proposes constitutional amendments that (1) authorize the President to reduce or disapprove any appropriation in a bill or joint resolution using a line-item veto, (2) prohibit Members of Congress from serving more than six terms in the House of Representatives or two terms in the Senate, and (3) require a two-thirds vote of each chamber of Congress for legislation that imposes or raises any tax or fee. 2023-03-08T20:12:14Z  
117-sjres-3 117 sjres 3 A joint resolution proposing an amendment to the Constitution of the United States relative to limiting the number of terms that a Member of Congress may serve. Congress 2021-01-22 2021-01-22 Read twice and referred to the Committee on the Judiciary. Senate Sen. Cruz, Ted [R-TX] TX R C001098 15 This joint resolution proposes a constitutional amendment limiting Representatives to three terms and Senators to two terms. Terms beginning before the ratification of this amendment do not count towards term limits. 2023-01-11T13:47:27Z  
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  
117-sjres-5 117 sjres 5 A joint resolution proposing an amendment to the Constitution of the United States requiring that the Federal budget be balanced. Economics and Public Finance 2021-01-22 2021-01-22 Read twice and referred to the Committee on the Judiciary. Senate Sen. Lee, Mike [R-UT] UT R L000577 1 This joint resolution proposes a constitutional amendment prohibiting total outlays for a fiscal year from exceeding total receipts for that fiscal year or 18% of the U.S. gross domestic product unless Congress authorizes the excess by a two-thirds vote of each chamber. The prohibition excludes outlays for repayment of debt principal and receipts derived from borrowing. The amendment requires a two-thirds vote of each chamber of Congress to levy a new tax, increase the rate of any tax, or increase the debt limit. The amendment provides any Member of Congress with standing and a cause of action to seek judicial enforcement of this amendment if authorized by a petition signed by one-third of the Members of either house of Congress. Courts are prohibited from ordering any increase in revenue to enforce this amendment. 2023-01-11T13:47:27Z  

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 452.13ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API