openregs: roll_call_votes: 1 row where congress = 109 and result = "Cloture on the Motion to Proceed Agreed to" sorted by date descending

Roll call votes in the House and Senate, Congresses 106–119. Includes vote question, result, and linked bill.

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

1 row where congress = 109 and result = "Cloture on the Motion to Proceed Agreed to" sorted by date descending

descending

Link	congress	chamber	session	roll_call_number	date ▲	question	vote_type	description	result	bill_id	legislation_type	legislation_number	yea_count	nay_count	present_count	not_voting_count	source_url
109,senate,2,12	109	senate	2	12	2006-02-07	On Cloture on the Motion to Proceed S. 852		Motion to Invoke Cloture on the Motion to Proceed to Consider S. 852 -- A bill to create a fair and efficient system to resolve claims of victims for bodily injury caused by asbestos exposure, and for other purposes.	Cloture on the Motion to Proceed Agreed to	109-s-852	S	852	98	1	0	1	https://www.senate.gov/legislative/LIS/roll_call_votes/vote1092/vote_109_2_00012.xml

Advanced export

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

CREATE TABLE roll_call_votes (
    congress INTEGER NOT NULL,
    chamber TEXT NOT NULL,
    session INTEGER,
    roll_call_number INTEGER NOT NULL,
    date TEXT,
    question TEXT,
    vote_type TEXT,
    description TEXT,
    result TEXT,
    bill_id TEXT,
    legislation_type TEXT,
    legislation_number TEXT,
    yea_count INTEGER,
    nay_count INTEGER,
    present_count INTEGER,
    not_voting_count INTEGER,
    source_url TEXT,
    PRIMARY KEY (congress, chamber, session, roll_call_number)
);
CREATE INDEX idx_rcv_date ON roll_call_votes(date);
CREATE INDEX idx_rcv_bill ON roll_call_votes(bill_id);
CREATE INDEX idx_rcv_congress ON roll_call_votes(congress);
CREATE INDEX idx_rcv_result ON roll_call_votes(result);
CREATE INDEX idx_rcv_compound ON roll_call_votes(congress, chamber, session, roll_call_number);