treaty_actions

Action history for treaties.

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

6 rows where treaty_id = "110-8" sorted by action_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: action_date, action_type, action_date (date)

id treaty_id action_date ▲ action_text action_type
2474 Protocols of 2005 to the Convention concerning Safety of Maritime Navigation and to the Protocol concerning Safety of Fixed Platforms on the Continental Shelf 110-8 2008-09-25 Considered by Senate. By Unanimous Consent. Floor
2475 Protocols of 2005 to the Convention concerning Safety of Maritime Navigation and to the Protocol concerning Safety of Fixed Platforms on the Continental Shelf 110-8 2008-09-25 Treaty moved through its parliamentary stages up to and including presentation of the resolution of advice and consent to ratification. Floor
2476 Protocols of 2005 to the Convention concerning Safety of Maritime Navigation and to the Protocol concerning Safety of Fixed Platforms on the Continental Shelf 110-8 2008-09-25 Resolution of advice and consent to ratification agreed to in Senate by Division Vote. Floor
2473 Protocols of 2005 to the Convention concerning Safety of Maritime Navigation and to the Protocol concerning Safety of Fixed Platforms on the Continental Shelf 110-8 2008-09-16 Reported by Senator Biden, Committee on Foreign Relations with printed Ex. Rept.110-25 and a resolution of advice and consent to ratification with reservations, understandings, and declarations. Executive Calendar No. 35. Committee
2472 Protocols of 2005 to the Convention concerning Safety of Maritime Navigation and to the Protocol concerning Safety of Fixed Platforms on the Continental Shelf 110-8 2008-05-07 Committee on Foreign Relations. Hearings held. Committee
2471 Protocols of 2005 to the Convention concerning Safety of Maritime Navigation and to the Protocol concerning Safety of Fixed Platforms on the Continental Shelf 110-8 2007-10-01 Received in the Senate and referred to the Committee on Foreign Relations by unanimous consent to remove the injunction of secrecy. IntroReferral

Advanced export

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

CSV options: 

CREATE TABLE treaty_actions (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    treaty_id TEXT NOT NULL REFERENCES treaties(id),
    action_date TEXT,
    action_text TEXT,
    action_type TEXT
);
CREATE INDEX idx_tact_treaty ON treaty_actions(treaty_id);