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

4 rows where congress = 110 and result = "Resolution Agreed to" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

result 1

  • Resolution Agreed to · 4 ✖

congress 1

  • 110 · 4 ✖

chamber 1

  • senate 4
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
110,senate,2,87 110 senate 2 87 2008-04-03 On the Resolution S.Res. 501   S. Res. 501 -- A resolution honoring the sacrifice of the members of the United States Armed Forces who have been killed in Iraq and Afghanistan. Resolution Agreed to 110-sres-501 S.Res 501 95 0 0 5 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1102/vote_110_2_00087.xml
110,senate,1,114 110 senate 1 114 2007-03-23 On the Resolution S.Con.Res. 21   S. Con. Res. 21 as Amended -- An original concurrent resolution setting forth the congressional budget for the United States Government for fiscal year 2008 and including the appropriate budgetary levels for fiscal years 2007 and 2009 through 2012. Resolution Agreed to 110-sconres-21 S.Con.Res 21 52 47 0 1 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1101/vote_110_1_00114.xml
110,senate,1,76 110 senate 1 76 2007-03-15 On the Resolution S.Res. 107   S. Res. 107 -- A resolution expressing the sense of the Senate that no action should be taken to undermine the safety of the Armed Forces of the United States or impact their ability to complete their assigned or future missions. Resolution Agreed to 110-sres-107 S.Res 107 96 2 0 2 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1101/vote_110_1_00076.xml
110,senate,1,1 110 senate 1 1 2007-01-08 On the Resolution S.Res. 19   S. Res. 19 -- A resolution honoring President Gerald Rudolph Ford. Resolution Agreed to 110-sres-19 S.Res 19 88 0 0 12 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1101/vote_110_1_00001.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 1136.345ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API