home / openregs

roll_call_votes

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

2 rows where congress = 111 and result = "Motion to Recommit Rejected" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

result 1

  • Motion to Recommit Rejected · 2 ✖

congress 1

  • 111 · 2 ✖

chamber 1

  • senate 2
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
111,senate,1,319 111 senate 1 319 2009-10-08 On the Motion to Recommit H.R. 2847   Ensign Motion to Recommit to H.R. 2847 to the Committee of Appropriations -- A bill making appropriations for the Departments of Commerce and Justice, and Science, and Related Agencies for the fiscal year ending September 30, 2010, and for other purposes. Motion to Recommit Rejected 111-hr-2847 H.R 2847 33 65 0 2 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1111/vote_111_1_00319.xml
111,senate,1,132 111 senate 1 132 2009-04-02 On the Motion to Recommit S.Con.Res. 13   Johanns Motion to Recommit to the Committee on the Budget -- An original concurrent resolution setting forth the congressional budget for the United States Government for fiscal year 2010, revising the appropriate budgetary levels for fiscal year 2009, and setting forth the appropriate budgetary levels for fiscal years 2011 through 2014. Motion to Recommit Rejected 111-sconres-13 S.Con.Res 13 43 55 0 1 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1111/vote_111_1_00132.xml

Advanced export

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

CSV options:

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