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 congress = 111 and result = "Motion to Proceed Rejected" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: not_voting_count, date (date)

result 1

  • Motion to Proceed Rejected · 3 ✖

congress 1

  • 111 · 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
111,senate,2,244 111 senate 2 244 2010-09-29 On the Motion to Proceed S.J.Res. 39   Motion to Proceed to Consider S.J.Res. 39 -- A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule relating to status as a grandfathered health plan under the Patient Protection and Affordable Care Act. Motion to Proceed Rejected 111-sjres-39 S.J.Res 39 40 59 0 1 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1112/vote_111_2_00244.xml
111,senate,2,239 111 senate 2 239 2010-09-23 On the Motion to Proceed S.J.Res. 30   Motion to Proceed to the Consideration of S. J. Res. 30 -- A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the National Mediation Board relating to representation election procedures. Motion to Proceed Rejected 111-sjres-30 S.J.Res 30 43 56 0 1 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1112/vote_111_2_00239.xml
111,senate,2,184 111 senate 2 184 2010-06-10 On the Motion to Proceed S.J.Res. 26   Motion to Proceed to S.J. Res. 26 -- A joint resolution disapproving a rule submitted by the Environmental Protection Agency relating to the endangerment finding and the cause or contribute findings for greenhouse gases under section 202(a) of the Clean Air Act. Motion to Proceed Rejected 111-sjres-26 S.J.Res 26 47 53 0 0 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1112/vote_111_2_00184.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 947.183ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API