treaty_actions

Action history for treaties.

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

1 row where treaty_id = "118-1" 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
2892 The Treaty between the United States of America and the Republic of Cuba on the Delimitation of the Continental Shelf in the Eastern Gulf of Mexico beyond 200 Nautical Miles, and the Treaty between the Government of the United States of America and the Government of the United Mexican States on the Delimitation of the Maritime Boundary in the Eastern Gulf of Mexico, both of which were signed at Washington on January 18, 2017 118-1 2023-12-18 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

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