openregs: treaty_actions: 6 rows where treaty_id = "98-29" sorted by action

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 = "98-29" sorted by action_date descending

descending

id	treaty_id	action_date ▲	action_text	action_type
4049	Request for Advice and Consent to Withdraw a Reservation Made to the 1975 Patent Cooperation Treaty. 98-29	1986-10-09	Request for withdrawal considered.	Calendars
4050	Request for Advice and Consent to Withdraw a Reservation Made to the 1975 Patent Cooperation Treaty. 98-29	1986-10-09	Yeas and nays ordered on the resolution of advice and consent to withdrawal of reservation.	Calendars
4051	Request for Advice and Consent to Withdraw a Reservation Made to the 1975 Patent Cooperation Treaty. 98-29	1986-10-09	Approved 98-0 by roll call vote (Record Vote No. 342). Calendar No. 17.	Floor
4047	Request for Advice and Consent to Withdraw a Reservation Made to the 1975 Patent Cooperation Treaty. 98-29	1986-09-18	Reported by Mr. Lugar, Committee on Foreign Relations, with printed report - Ex.Rept. 99-23. With a resolution of advice and consent to withdrawal of a Senate-passed reservation to the 1975 Patent Cooperation Treaty.	Committee
4046	Request for Advice and Consent to Withdraw a Reservation Made to the 1975 Patent Cooperation Treaty. 98-29	1984-07-31	Referred to the Committee on Foreign Relations.	IntroReferral
4048	Request for Advice and Consent to Withdraw a Reservation Made to the 1975 Patent Cooperation Treaty. 98-29	1984-07-27	Transmitted by the President to the Secretary of the Senate.	Calendars

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