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 = 110 and result = "Motion to Table Failed" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: nay_count, not_voting_count, date (date)

result 1

  • Motion to Table Failed · 3 ✖

congress 1

  • 110 · 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
110,senate,1,377 110 senate 1 377 2007-10-18 On the Motion to Table S.Amdt. 3321 to S.Amdt. 3325 to H.R. 3043 (Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2008)   Motion to Table Coburn Amdt. No.3321 -- To provide additional care for pregnant women, mothers, and infants by eliminating a $1,000,000 earmark for a museum dedicated to Woodstock. Motion to Table Failed       42 52 0 6 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1101/vote_110_1_00377.xml
110,senate,1,234 110 senate 1 234 2007-06-27 On the Motion to Table S.Amdt. 1934 to S. 1639 (No short title on file)   Motion to Table Div. VII, Amdt. No.1934 as Modified -- Of a perfecting nature. Motion to Table Failed       45 52 0 3 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1101/vote_110_1_00234.xml
110,senate,1,5 110 senate 1 5 2007-01-11 On the Motion to Table S.Amdt. 11 to S.Amdt. 3 to S. 1 (No short title on file)   Motion to Table DeMint Amdt. No. 11 -- To strengthen earmark reform. Motion to Table Failed       46 51 0 3 https://www.senate.gov/legislative/LIS/roll_call_votes/vote1101/vote_110_1_00005.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 152.956ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API