treaty_actions

Action history for treaties.

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

3 rows where treaty_id = "92-23" 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
3141 Convention on the Establishment of an International Fund for Compensation for Oil Pollution Damage and Amendments to the 1954 Prevention of Pollution of the Sea by Oil Convention 92-23 2000-10-13 Returned to the President pursuant to S. Res. 267 agreed to in Senate on October 12, 2000. Floor
3142 Convention on the Establishment of an International Fund for Compensation for Oil Pollution Damage and Amendments to the 1954 Prevention of Pollution of the Sea by Oil Convention 92-23 2000-10-12 Returned to the President pursuant to S. Res. 267. Floor
3140 Convention on the Establishment of an International Fund for Compensation for Oil Pollution Damage and Amendments to the 1954 Prevention of Pollution of the Sea by Oil Convention 92-23 1972-05-05 Received in the Senate and referred to the Committee on Foreign Relations by unanimous consent. 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);