openregs: treaty_actions: 5 rows where treaty_id = "99-31" sorted by action

Action history for treaties.

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

5 rows where treaty_id = "99-31" sorted by action_date descending

descending

id	treaty_id	action_date ▲	action_text	action_type
4245	TREATY BETWEEN THE UNITED STATES AND ICELAND TO FACILITATE THEIR DEFENSE RELATIONSHIP 99-31	1986-10-08	Committee on Foreign Relations. Ordered to be reported without amendment favorably.	Committee
4246	TREATY BETWEEN THE UNITED STATES AND ICELAND TO FACILITATE THEIR DEFENSE RELATIONSHIP 99-31	1986-10-08	Reported by Mr. Lugar, Committee on Foreign Relations, with printed report - Ex.Rept. 99-27. Without reservation.	Committee
4247	TREATY BETWEEN THE UNITED STATES AND ICELAND TO FACILITATE THEIR DEFENSE RELATIONSHIP 99-31	1986-10-08	Treaty moved through its parliamentary stages, and the resolution of ratification considered without amendment. Approved by division vote.	Floor
4243	TREATY BETWEEN THE UNITED STATES AND ICELAND TO FACILITATE THEIR DEFENSE RELATIONSHIP 99-31	1986-09-30	Received in the Senate and referred to the Committee on Foreign Relations.	IntroReferral
4244	TREATY BETWEEN THE UNITED STATES AND ICELAND TO FACILITATE THEIR DEFENSE RELATIONSHIP 99-31	1986-09-30	Committee on Foreign Relations. Hearings held.	Committee

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