roll_call_votes
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where congress = 112 and result = "Motion to Recommit Rejected" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112,senate,2,152 | 112 | senate | 2 | 152 | 2012-06-20 | On the Motion to Recommit S. 3240 | Lee Motion to Recommit with Instructions -- An original bill to reauthorize agricultural programs through 2017, and for other purposes. | Motion to Recommit Rejected | 112-s-3240 | S | 3240 | 29 | 70 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1122/vote_112_2_00152.xml | |
| 112,senate,1,193 | 112 | senate | 1 | 193 | 2011-11-01 | On the Motion to Recommit H.R. 2112 | Lee Motion to Recommit H.R. 2112 to the Committee on Appropriations -- An act making consolidated appropriations for the Departments of Agriculture, Commerce, Justice, Transportation, and Housing and Urban Development, and related programs for the fiscal year ending September 30, 2012, and for other purposes. | Motion to Recommit Rejected | 112-hr-2112 | H.R | 2112 | 39 | 60 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1121/vote_112_1_00193.xml |
Advanced export
JSON shape: default, array, newline-delimited, object
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);