home / openregs

treaty_actions

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 = "99-14" sorted by action_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: action_text, action_type, action_date (date)

id treaty_id action_date ▲ action_text action_type
4150 The Treaty between the United States of America and the Republic of Panama concerning the Treatment and Protection of Investments, with Agreed Minutes, signed at Washington, October 27, 1982. 99-14 1990-10-28 Resolution of advice and consent to ratification agreed to in Senate by Division Vote. Floor
4147 The Treaty between the United States of America and the Republic of Panama concerning the Treatment and Protection of Investments, with Agreed Minutes, signed at Washington, October 27, 1982. 99-14 1990-10-09 Reported by Mr. Pell, Committee on Foreign Relations, with printed report - Ex.Rept. 101-34. With a resolution of advice and consent to ratification without amendment. Committee
4146 The Treaty between the United States of America and the Republic of Panama concerning the Treatment and Protection of Investments, with Agreed Minutes, signed at Washington, October 27, 1982. 99-14 1990-09-18 Committee on Foreign Relations. Hearings held. Hearings printed: S.Hrg. 101-1063. Committee
4148 The Treaty between the United States of America and the Republic of Panama concerning the Treatment and Protection of Investments, with Agreed Minutes, signed at Washington, October 27, 1982. 99-14 1990-09-14 Committee on Foreign Relations. Ordered to be reported without amendment favorably. Committee
4149 The Treaty between the United States of America and the Republic of Panama concerning the Treatment and Protection of Investments, with Agreed Minutes, signed at Washington, October 27, 1982. 99-14 1988-08-09 Committee on Foreign Relations. Hearings held. Committee
4145 The Treaty between the United States of America and the Republic of Panama concerning the Treatment and Protection of Investments, with Agreed Minutes, signed at Washington, October 27, 1982. 99-14 1986-08-11 Committee on Foreign Relations. Hearings held. Committee
4144 The Treaty between the United States of America and the Republic of Panama concerning the Treatment and Protection of Investments, with Agreed Minutes, signed at Washington, October 27, 1982. 99-14 1986-03-25 Received in the Senate and referred to the Committee on Foreign Relations. 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);
Powered by Datasette · Queries took 48.318ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API