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 = "95-7" 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
3553 PROTOCOL WITH CANADA TO AMEND THE CONVENTION FOR THE PROTECTION, PRESERVATION, AND EXTENSION OF THE SOCKEYE SALMON FISHERIES IN THE FRASER RIVER SYSTEM, AS AMENDED 95-7 1980-03-20 General debate; approved by 92-0 vote. Record Vote Number 58. Floor
3552 PROTOCOL WITH CANADA TO AMEND THE CONVENTION FOR THE PROTECTION, PRESERVATION, AND EXTENSION OF THE SOCKEYE SALMON FISHERIES IN THE FRASER RIVER SYSTEM, AS AMENDED 95-7 1980-02-20 General debate (also 2/21/80, 2/26/80 and 3/11/80). Floor
3551 PROTOCOL WITH CANADA TO AMEND THE CONVENTION FOR THE PROTECTION, PRESERVATION, AND EXTENSION OF THE SOCKEYE SALMON FISHERIES IN THE FRASER RIVER SYSTEM, AS AMENDED 95-7 1980-02-19 Reported without reservation (Ex. Rept. 96-28). Floor
3550 PROTOCOL WITH CANADA TO AMEND THE CONVENTION FOR THE PROTECTION, PRESERVATION, AND EXTENSION OF THE SOCKEYE SALMON FISHERIES IN THE FRASER RIVER SYSTEM, AS AMENDED 95-7 1977-03-31 Received and referred to the Committee on Foreign Relations. Floor

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