openregs: treaty_actions: 7 rows where treaty_id = "106-39" sorted by action

Action history for treaties.

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

7 rows where treaty_id = "106-39" sorted by action_date descending

descending

id	treaty_id	action_date ▲	action_text	action_type
1713	Treaty between the Government of the United States of America and the Government of the United Mexican States on the Delimitation of the Continental Shelf in the Western Gulf of Mexico beyond 200 nautical miles, signed at Washington on June 9, 2000. 106-39	2000-10-18	Considered by Senate.	Floor
1714	Treaty between the Government of the United States of America and the Government of the United Mexican States on the Delimitation of the Continental Shelf in the Western Gulf of Mexico beyond 200 nautical miles, signed at Washington on June 9, 2000. 106-39	2000-10-18	Treaty moved through its parliamentary stages up to and including presentation of the resolution of advice and consent to ratification.	Floor
1715	Treaty between the Government of the United States of America and the Government of the United Mexican States on the Delimitation of the Continental Shelf in the Western Gulf of Mexico beyond 200 nautical miles, signed at Washington on June 9, 2000. 106-39	2000-10-18	Resolution of advice and consent to ratification agreed to in Senate by Division Vote.	Floor
1712	Treaty between the Government of the United States of America and the Government of the United Mexican States on the Delimitation of the Continental Shelf in the Western Gulf of Mexico beyond 200 nautical miles, signed at Washington on June 9, 2000. 106-39	2000-09-29	Reported favorably by Senator Helms, Committee on Foreign Relations with printed Ex. Rept. 106-19 and a resolution of advice and consent to ratification with the declaration and provisio indicated in Section VII. Executive Calendar No. 20.	Committee
1711	Treaty between the Government of the United States of America and the Government of the United Mexican States on the Delimitation of the Continental Shelf in the Western Gulf of Mexico beyond 200 nautical miles, signed at Washington on June 9, 2000. 106-39	2000-09-27	Committee on Foreign Relations. Ordered to be reported without amendment favorably. With 1 declaration, 1 proviso.	Committee
1710	Treaty between the Government of the United States of America and the Government of the United Mexican States on the Delimitation of the Continental Shelf in the Western Gulf of Mexico beyond 200 nautical miles, signed at Washington on June 9, 2000. 106-39	2000-09-13	Committee on Foreign Relations. Hearings held. Hearings printed: S.Hrg. 106-660.	Committee
1709	Treaty between the Government of the United States of America and the Government of the United Mexican States on the Delimitation of the Continental Shelf in the Western Gulf of Mexico beyond 200 nautical miles, signed at Washington on June 9, 2000. 106-39	2000-07-27	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

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