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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: action_type, action_date (date)

id treaty_id action_date ▲ action_text action_type
4286 VIENNA CONVENTION FOR THE PROTECTION OF THE OZONE LAYER 99-9 1986-07-24 Treaty moved through its various parliamentary stages, and resolution of ratification considered without amendment. Approved by division vote. Floor
4284 VIENNA CONVENTION FOR THE PROTECTION OF THE OZONE LAYER 99-9 1986-04-23 Reported favorably, by Mr. Lugar, Committee on Foreign Relations, with a proposed resolution of advice and consent to ratification without reservation (Printed report together with additional views--Ex. Rept. 99-13). Calendars
4283 VIENNA CONVENTION FOR THE PROTECTION OF THE OZONE LAYER 99-9 1985-09-09 Read the first time, referred to the Committee on Foreign Relations, and ordered to be printed for the use of the Senate. Calendars
4285 VIENNA CONVENTION FOR THE PROTECTION OF THE OZONE LAYER 99-9 1985-09-04 Transmitted by the President of the United States and received by the Secretary of the Senate. 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);