openregs: treaty_actions: 7 rows where treaty_id = "108-2" sorted by action

Action history for treaties.

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

7 rows where treaty_id = "108-2" sorted by action_date descending

descending

id	treaty_id	action_date ▲	action_text	action_type
2073	Amendments to the 1987 Treaty on Fisheries with Pacific Island States 108-2	2003-07-31	Resolution of advice and consent to ratification agreed to in Senate by Division Vote.	Floor
2074	Amendments to the 1987 Treaty on Fisheries with Pacific Island States 108-2	2003-07-31	Considered by Senate.	Floor
2075	Amendments to the 1987 Treaty on Fisheries with Pacific Island States 108-2	2003-07-31	Treaty moved through its parliamentary stages up to and including presentation of the resolution of advice and consent to ratification.	Floor
2071	Amendments to the 1987 Treaty on Fisheries with Pacific Island States 108-2	2003-07-29	Reported favorably by Senator Lugar, Committee on Foreign Relations with printed Ex. Rept.108-7 and a resolution of advice and consent to ratification with one declaration. Executive Calendar No. 9.	Committee
2069	Amendments to the 1987 Treaty on Fisheries with Pacific Island States 108-2	2003-06-17	Committee on Foreign Relations. Hearings held.	Committee
2072	Amendments to the 1987 Treaty on Fisheries with Pacific Island States 108-2	2003-06-17	Committee on Foreign Relations. Hearings held. Hearings printed: S.Hrg. in Ex. Rept. 108-8.	Committee
2070	Amendments to the 1987 Treaty on Fisheries with Pacific Island States 108-2	2003-02-11	Received in the Senate and referred to the Committee on Foreign Relations by unanimous consent removing the injunction of secrecy.	IntroReferral

Advanced export

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

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);