legislation_actions

Legislative action history for tracked bills — committee referrals, floor votes, amendments, and presidential signatures.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

19 rows where bill_id = "111-s-3987" sorted by action_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: action_date, action_text, action_type, action_code, action_date (date)

id bill_id action_date ▲ action_text action_type chamber action_code
1008998 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-18 Became Public Law No: 111-319. President   House floor actions
1008999 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-18 Became Public Law No: 111-319. BecameLaw   Library of Congress
1009000 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-18 Signed by President. President   House floor actions
1009001 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-18 Signed by President. BecameLaw   Library of Congress
1009002 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-09 Presented to President. Floor   House floor actions
1009003 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-09 Presented to President. President   Library of Congress
1009004 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-07 Cleared for White House.      
1009005 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-07 Motion to reconsider laid on the table Agreed to without objection. Floor   House floor actions
1009006 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-07 On motion to suspend the rules and pass the bill Agreed to by voice vote. (text: CR H8059) Floor   House floor actions
1009007 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-07 Passed/agreed to in House: On motion to suspend the rules and pass the bill Agreed to by voice vote.(text: CR H8059) Floor   Library of Congress
1009008 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-07 DEBATE - The House proceeded with forty minutes of debate on S. 3987. Floor   House floor actions
1009009 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-07 Considered under suspension of the rules. (consideration: CR H8059-8060) Floor   House floor actions
1009010 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-07 Mr. Adler (NJ) moved to suspend the rules and pass the bill. Floor   House floor actions
1009011 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-01 Referred to the House Committee on Financial Services. IntroReferral   House floor actions
1009012 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-01 Message on Senate action sent to the House. Floor   Senate
1009013 Red Flag Program Clarification Act of 2010 111-s-3987 2010-12-01 Received in the House. Floor   House floor actions
1009014 Red Flag Program Clarification Act of 2010 111-s-3987 2010-11-30 Introduced in the Senate, read twice, considered, read the third time, and passed without amendment by Unanimous Consent. (consideration: CR S8288-8289; text as passed Senate: CR S8289) Floor   Senate
1009015 Red Flag Program Clarification Act of 2010 111-s-3987 2010-11-30 Passed/agreed to in Senate: Introduced in the Senate, read twice, considered, read the third time, and passed without amendment by Unanimous Consent.(consideration: CR S8288-8289; text as passed Senate: CR S8289) Floor   Library of Congress
1009016 Red Flag Program Clarification Act of 2010 111-s-3987 2010-11-30 Introduced in Senate IntroReferral   Library of Congress

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE legislation_actions (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    bill_id TEXT REFERENCES legislation(bill_id),
    action_date TEXT,
    action_text TEXT,
    action_type TEXT,
    chamber TEXT,
    action_code TEXT
);
CREATE INDEX idx_legact_bill ON legislation_actions(bill_id);
CREATE INDEX idx_legact_date ON legislation_actions(action_date);