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 = 108 and result = "Resolution of Ratification Agreed to" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

result 1

  • Resolution of Ratification Agreed to · 2 ✖

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
108,senate,1,142 108 senate 1 142 2003-05-08 On the Resolution of Ratification Treaty Doc. 108-4   Resolution Of Ratification To Accompany Treaty Doc. 108-4 -- Protocols to the North Atlantic Treaty of 1949 on the Accession of Bulgaria, Estonia, Latvia, Lithuania, Romania, Slovakia, and Slovenia. These protocols were opened for signature at Brussels on March 26, 2003, and signed that day on behalf of the United States and the other parties to the North Atlantic Treaty Resolution of Ratification Agreed to 4-treatydoc-108 Treaty Doc 108-4 96 0 0 4 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1081/vote_108_1_00142.xml
108,senate,1,43 108 senate 1 43 2003-03-06 On the Resolution of Ratification Treaty Doc. 107-8   Treaty Document 107-8 Resolution Of Ratification -- The Treaty Between the United States of America and the Russian Federation on Strategic Offensive Reductions, Signed at Moscow on May 24, 2002 Resolution of Ratification Agreed to 8-treatydoc-107 Treaty Doc 107-8 95 0 0 5 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1081/vote_108_1_00043.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);