home / openregs

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

5 rows where bill_id = "104-hconres-214" sorted by action_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

id bill_id action_date ▲ action_text action_type chamber action_code
336411 Expressing the sense of the Congress that a patient has certain rights regarding medical care that should be protected by law. 104-hconres-214 1996-09-20 Referred to the Subcommittee on Health and Environment. Committee house House committee actions
336412 Expressing the sense of the Congress that a patient has certain rights regarding medical care that should be protected by law. 104-hconres-214 1996-09-12 Referred to the House Committee on Commerce. IntroReferral house House floor actions
336413 Expressing the sense of the Congress that a patient has certain rights regarding medical care that should be protected by law. 104-hconres-214 1996-09-12 Sponsor introductory remarks on measure. (CR E1592-1593) IntroReferral   Library of Congress
336414 Expressing the sense of the Congress that a patient has certain rights regarding medical care that should be protected by law. 104-hconres-214 1996-09-12 Introduced in House IntroReferral   Library of Congress
336415 Expressing the sense of the Congress that a patient has certain rights regarding medical care that should be protected by law. 104-hconres-214 1996-09-12 Introduced in House 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);
Powered by Datasette · Queries took 1.56ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy