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

3 rows where chamber = "senate", congress = 113 and result = "Decision of Chair Sustained" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session, legislation_type, nay_count, not_voting_count, date (date)

result 1

  • Decision of Chair Sustained · 3 ✖

congress 1

  • 113 · 3 ✖

chamber 1

  • senate · 3 ✖
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
113,senate,2,324 113 senate 2 324 2014-12-12 On the Decision of the Chair H.R. 3979   Shall the Decision of the Chair Stand as the Judgment of the Senate Re: Coburn Appeal -- A bill to amend the Internal Revenue Code of 1986 to ensure that emergency services volunteers are not taken into account as employees under the shared responsibility requirements contained in the Patient Protection and Affordable Care Act. Decision of Chair Sustained 113-hr-3979 H.R 3979 55 45 0 0 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1132/vote_113_2_00324.xml
113,senate,1,250 113 senate 1 250 2013-12-10 On the Decision of the Chair PN408   Shall the Decision of the Chair Stand as the Judgment of the Senate? (McConnell Appeal) -- Melvin L. Watt, of North Carolina, to be Director of the Federal Housing Finance Agency for a term of five years Decision of Chair Sustained 113-pn-408 PN 408 51 45 0 4 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1131/vote_113_1_00250.xml
113,senate,1,243 113 senate 1 243 2013-11-21 On the Decision of the Chair PN527   Shall the Decision of the Chair Stand as the Judgment of the Senate? (McConnell Appeal) -- Patricia Ann Millett, of Virginia, to be United States Circuit Judge for the District of Columbia Circuit Decision of Chair Sustained 113-pn-527 PN 527 52 48 0 0 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1131/vote_113_1_00243.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 49.207ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API