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 = 107 and result = "Motion for Attendance Agreed to" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session, legislation_type, date (date)

result 1

  • Motion for Attendance Agreed to · 3 ✖

congress 1

  • 107 · 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
107,senate,2,1 107 senate 2 1 2002-01-23 On the Motion for Attendance S. 1731   Motion to Instruct Sergeant at Arms -- An original bill to strengthen the safety net for agricultural producers, to enhance resource conservation and rural development, to provide for farm credit, agricultural research, nutrition, and related programs, to ensure consumers abundant food and fiber, and for other purposes. Motion for Attendance Agreed to 107-s-1731 S 1731 88 6 0 6 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00001.xml
107,senate,1,255 107 senate 1 255 2001-07-27 On the Motion for Attendance H.R. 2299   Motion to Instruct Sgt. at Arms -- A bill making appropriations for the Department of Transportation and related agencies for the fiscal year ending September 30, 2002, and for other purposes. Motion for Attendance Agreed to 107-hr-2299 H.R 2299 60 28 0 12 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00255.xml
107,senate,1,239 107 senate 1 239 2001-07-19 On the Motion for Attendance H.R. 2311   Motion to Instruct Sgt. At Arms -- A bill making appropriations for energy and water development for the fiscal year ending September 30, 2002, and for other purposes. Motion for Attendance Agreed to 107-hr-2311 H.R 2311 76 23 0 1 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00239.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 181.569ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API