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

5 rows where congress = 116 and result = "Resolution of Ratification Agreed to" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, yea_count, nay_count, not_voting_count, date (date)

result 1

  • Resolution of Ratification Agreed to · 5 ✖

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
116,senate,1,327 116 senate 1 327 2019-10-22 On the Resolution of Ratification Treaty Doc. 116-1   Resolution of Ratification for Treaty Doc. 116-1 (North Macedonia) -- Protocol to the North Atlantic Treaty of 1949 on the Accession of the Republic of North Macedonia Resolution of Ratification Agreed to 1-treatydoc-116 Treaty Doc 116-1 91 2 0 7 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1161/vote_116_1_00327.xml
116,senate,1,210 116 senate 1 210 2019-07-17 On the Resolution of Ratification Treaty Doc. 112-1   Resolution of Ratification for Treaty Document No. 112-1 (Switzerland) -- Protocol Amending the Convention between the United States of America and the Swiss Confederation for the Avoidance of Double Taxation with Respect to Taxes on Income, signed at Washington on October 2, 1996, signed on September 23, 2009, at Washington, as corrected by an exchange of notes effected November 16, 2010 and a related agreement effected by an exchange of notes on September 23, 2009 Resolution of Ratification Agreed to 1-treatydoc-112 Treaty Doc 112-1 95 2 0 3 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1161/vote_116_1_00210.xml
116,senate,1,211 116 senate 1 211 2019-07-17 On the Resolution of Ratification Treaty Doc. 114-1   Resolution of Ratification for Treaty Document No. 114-1 (Japan) -- The Protocol Amending the Convention between the Government of the United States of America and the Government of Japan for the Avoidance of Double Taxation and the Prevention of Fiscal Evasion with respect to Taxes on Income and a related agreement entered into by an exchange of notes (together the "proposed Protocol"), both signed on January 24, 2013, at Washington, together with correcting notes exchanged March 9 and March 29, 2013 Resolution of Ratification Agreed to 1-treatydoc-114 Treaty Doc 114-1 95 2 0 3 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1161/vote_116_1_00211.xml
116,senate,1,212 116 senate 1 212 2019-07-17 On the Resolution of Ratification Treaty Doc. 111-8   Resolution of Ratification for Treaty Document No. 111-8 (Luxembourg) -- Protocol Amending the Convention between the Government of the United States of America and the Government of the Grand Duchy of Luxembourg for the Avoidance of Double Taxation and the Prevention of Fiscal Evasion with Respect to Taxes on Income and Capital, signed on May 20, 2009, at Luxembourg (the "proposed Protocol") and a related agreement effected by the exchange of notes also signed on May 20, 2009 Resolution of Ratification Agreed to 8-treatydoc-111 Treaty Doc 111-8 93 3 0 4 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1161/vote_116_1_00212.xml
116,senate,1,209 116 senate 1 209 2019-07-16 On the Resolution of Ratification Treaty Doc. 113-4   Resolution of Ratification for Treaty Document 113-4 (Spain) -- The Protocol Amending the Convention between the United States of America and the Kingdom of Spain for the Avoidance of Double Taxation and the Prevention of Fiscal Evasion with Respect to Taxes on Income and its Protocol, signed at Madrid on February 22, 1990 Resolution of Ratification Agreed to 4-treatydoc-113 Treaty Doc 113-4 94 2 0 4 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1161/vote_116_1_00209.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);