treaty_actions

Action history for treaties.

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

6 rows where treaty_id = "105-26" sorted by action_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: action_date, action_type, action_date (date)

id treaty_id action_date ▲ action_text action_type
1162 The Protocol Between the Government of the United States of America and the Government of the United Mexican States Amending the Convention for the Protection of Migratory Birds and Game Mammals, signed at Mexico City on May 5, 1997. 105-26 1997-10-23 Resolution of advice and consent to ratification agreed to in Senate by Division vote. Floor
1163 The Protocol Between the Government of the United States of America and the Government of the United Mexican States Amending the Convention for the Protection of Migratory Birds and Game Mammals, signed at Mexico City on May 5, 1997. 105-26 1997-10-23 Treaty moved through its parliamentary stages up to and including presentation of the resolution of advice and consent to ratification. Floor
1161 The Protocol Between the Government of the United States of America and the Government of the United Mexican States Amending the Convention for the Protection of Migratory Birds and Game Mammals, signed at Mexico City on May 5, 1997. 105-26 1997-10-22 Reported by Mr. Helms, Committee on Foreign Relations, with printed report - Ex.Rept. 105-5. With resolution of advice and consent to ratification with one understanding, one declaration and one proviso. Committee
1160 The Protocol Between the Government of the United States of America and the Government of the United Mexican States Amending the Convention for the Protection of Migratory Birds and Game Mammals, signed at Mexico City on May 5, 1997. 105-26 1997-10-08 Committee on Foreign Relations. Ordered to be reported without amendment favorably. With 1 understanding, 1 declaration, and 1 proviso. Committee
1159 The Protocol Between the Government of the United States of America and the Government of the United Mexican States Amending the Convention for the Protection of Migratory Birds and Game Mammals, signed at Mexico City on May 5, 1997. 105-26 1997-09-25 Committee on Foreign Relations. Hearings held. Hearings printed: S.Hrg. in Ex. Rept. 105-5. Committee
1158 The Protocol Between the Government of the United States of America and the Government of the United Mexican States Amending the Convention for the Protection of Migratory Birds and Game Mammals, signed at Mexico City on May 5, 1997. 105-26 1997-09-15 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);