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

5 rows where bill_type = "sjres", congress = 118 and policy_area = "Congress" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Congress · 5 ✖

congress 1

bill_type 1

  • sjres · 5 ✖
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
118-sjres-73 118 sjres 73 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the multiple agencies relating to "Partnerships With Faith-Based and Neighborhood Organizations". Congress 2024-04-18 2024-04-18 Read twice and referred to the Committee on Homeland Security and Governmental Affairs. Senate Sen. Rubio, Marco [R-FL] FL R R000595 10   2025-01-14T19:03:55Z https://www.congress.gov/bill/118th-congress/senate-joint-resolution/73
118-sjres-67 118 sjres 67 A joint resolution to provide for related procedures concerning the articles of impeachment against Alejandro Nicholas Mayorkas, Secretary of Homeland Security. Congress 2024-03-23 2024-04-08 Read the second time. Placed on Senate Legislative Calendar under General Orders. Calendar No. 351. Senate Sen. Lee, Mike [R-UT] UT R L000577 0   2025-12-05T08:54:46Z https://www.congress.gov/bill/118th-congress/senate-joint-resolution/67
118-sjres-68 118 sjres 68 A joint resolution providing for the issuance of a summons, providing for the appointment of a committee to receive and to report evidence, and establishing related procedures concerning the articles of impeachment against Alejandro Nicholas Mayorkas. Congress 2024-03-23 2024-04-08 Read the second time. Placed on Senate Legislative Calendar under General Orders. Calendar No. 352. Senate Sen. Lee, Mike [R-UT] UT R L000577 0   2025-12-05T08:55:16Z https://www.congress.gov/bill/118th-congress/senate-joint-resolution/68
118-sjres-69 118 sjres 69 A joint resolution to provide for related procedures concerning the articles of impeachment against Alejandro Nicholas Mayorkas, Secretary of Homeland Security. Congress 2024-03-23 2024-04-08 Read the second time. Placed on Senate Legislative Calendar under General Orders. Calendar No. 353. Senate Sen. Lee, Mike [R-UT] UT R L000577 0   2025-12-05T09:02:47Z https://www.congress.gov/bill/118th-congress/senate-joint-resolution/69
118-sjres-2 118 sjres 2 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 2023-01-23 2023-01-23 Read twice and referred to the Committee on the Judiciary. Senate Sen. Cruz, Ted [R-TX] TX R C001098 20   2025-12-05T23:35:56Z https://www.congress.gov/bill/118th-congress/senate-joint-resolution/2

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);