home / openregs

legislation_actions

Legislative action history for tracked bills — committee referrals, floor votes, amendments, and presidential signatures.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

16 rows where bill_id = "110-sjres-9" sorted by action_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: action_date, action_type, action_code, action_date (date)

id bill_id action_date ▲ action_text action_type chamber action_code
916756 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-15 Returned to the Calendar., pursuant to the order of March 15, 2007, having failed to achieve the required 60 votes in the affirmative. Calendar No. 72. (consideration: CR S3287) Floor   Senate
916757 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-15 Pursuant to the order of March 15, 2007, having failed to achieve the required 60 votes in the affirmative, the vote was vitiated by Unanimous Consent. (consideration: CR S3287) Floor   Senate
916758 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-15 Failed of passage in Senate by Yea-Nay Vote. 48 - 50. Record Vote Number: 75. Floor   Senate
916759 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-15 Failed of passage/not agreed to in Senate: Failed of passage in Senate by Yea-Nay Vote. 48 - 50. Record Vote Number: 75. Floor   Library of Congress
916760 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-15 Measure laid before Senate by motion. (consideration: CR S3162-3287) Floor   Senate
916761 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-15 Motion to proceed to consideration of measure agreed to in Senate by Unanimous Consent. Floor   Senate
916762 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-15 Motion to proceed to measure considered in Senate. (consideration: CR S3162-3287) Floor   Senate
916771 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-15 Senate amendment submitted Floor   Library of Congress
916763 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-14 Motion to proceed to measure considered in Senate. (consideration: CR S3085-3087, S3088-3112, S3113-3114, S3115-3117) Floor   Senate
916764 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-14 Cloture on the motion to proceed to the measure invoked in Senate by Yea-Nay Vote. 89 - 9. Record Vote Number: 74. (consideration: CR S3077-3085; text: CR S3085) Floor   Senate
916765 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-12 Motion to proceed to consideration of measure withdrawn in Senate. Floor   Senate
916766 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-12 Cloture motion on the motion to proceed to the measure presented in Senate. (consideration: CR S3011; text: CR S3011) Floor   Senate
916767 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-12 Motion to proceed to consideration of measure made in Senate. (consideration: CR S3011) Floor   Senate
916768 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-09 Read the second time. Placed on Senate Legislative Calendar under General Orders. Calendar No. 72. Calendars   Senate
916769 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-08 Introduced in the Senate. Read the first time. Placed on Senate Legislative Calendar under Read the First Time. (text of measure as introduced: CR S2927) Calendars   Senate
916770 United States Policy in Iraq Resolution of 2007 110-sjres-9 2007-03-08 Introduced in Senate IntroReferral   Library of Congress

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE legislation_actions (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    bill_id TEXT REFERENCES legislation(bill_id),
    action_date TEXT,
    action_text TEXT,
    action_type TEXT,
    chamber TEXT,
    action_code TEXT
);
CREATE INDEX idx_legact_bill ON legislation_actions(bill_id);
CREATE INDEX idx_legact_date ON legislation_actions(action_date);
Powered by Datasette · Queries took 307.773ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API