treaty_actions

Action history for treaties.

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

4 rows where treaty_id = "101-4" sorted by action_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: action_date (date)

id treaty_id action_date ▲ action_text action_type
259 UNITED NATIONS CONVENTION AGAINST ILLICIT TRAFFIC IN NARCOTIC DRUGS AND PSYCHOTROPIC SUBSTANCES 101-4 1989-11-22 Resolution of advice and consent to ratification agreed to in Senate with understandings by Division Vote. Floor
261 UNITED NATIONS CONVENTION AGAINST ILLICIT TRAFFIC IN NARCOTIC DRUGS AND PSYCHOTROPIC SUBSTANCES 101-4 1989-11-14 Reported by Mr. Pell, Committee on Foreign Relations, with printed report - Ex.Rept. 101-15. Favorably with understandings, with a resolution of advice and consent to ratification. Committee
260 UNITED NATIONS CONVENTION AGAINST ILLICIT TRAFFIC IN NARCOTIC DRUGS AND PSYCHOTROPIC SUBSTANCES 101-4 1989-06-20 Referred to the Committee on Foreign Relations by unanimous consent. IntroReferral
258 UNITED NATIONS CONVENTION AGAINST ILLICIT TRAFFIC IN NARCOTIC DRUGS AND PSYCHOTROPIC SUBSTANCES 101-4 1989-06-19 Transmitted to the Senate by the President. Calendars

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