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

3 rows where congress = 112 and result = "Bill Defeated" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session, legislation_type, present_count, date (date)

result 1

  • Bill Defeated · 3 ✖

congress 1

chamber 1

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
112,senate,2,196 112 senate 2 196 2012-09-22 On Passage of the Bill S. 3576   S. 3576 -- A bill to provide limitations on United States assistance, and for other purposes. Bill Defeated 112-s-3576 S 3576 10 81 0 9 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1122/vote_112_2_00196.xml
112,senate,2,113 112 senate 2 113 2012-05-24 On Passage of the Bill S. 2343   S. 2343 -- A bill to amend the Higher Education Act of 1965 to extend the reduced interest rate for Federal Direct Stafford Loans, and for other purposes. Bill Defeated 112-s-2343 S 2343 51 43 1 5 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1122/vote_112_2_00113.xml
112,senate,1,36 112 senate 1 36 2011-03-09 On Passage of the Bill H.R. 1   H.R. 1 -- A bill making appropriations for the Department of Defense and the other departments and agencies of the Government for the fiscal year ending September 30, 2011, and for other purposes. Bill Defeated 112-hr-1 H.R 1 44 56 0 0 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1121/vote_112_1_00036.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);