home / openregs

treaty_actions

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 = "117-3" 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
2888 Protocols to the North Atlantic Treaty of 1949 on the Accession of the Republic of Finland and the Kingdom of Sweden 117-3 2022-08-03 Considered by Senate. Floor
2889 Protocols to the North Atlantic Treaty of 1949 on the Accession of the Republic of Finland and the Kingdom of Sweden 117-3 2022-08-03 Resolution of advice and consent to ratification agreed to as amended in Senate by Yea-Nay Vote. 95 - 1. Record Vote Number: 282. Floor
2890 Protocols to the North Atlantic Treaty of 1949 on the Accession of the Republic of Finland and the Kingdom of Sweden 117-3 2022-08-03 Treaty moved through its parliamentary stages up to and including presentation of the resolution of advice and consent to ratification. Floor
2891 Protocols to the North Atlantic Treaty of 1949 on the Accession of the Republic of Finland and the Kingdom of Sweden 117-3 2022-08-02 By unanimous consent agreement, debate and vote 8/3/2022. Floor
2887 Protocols to the North Atlantic Treaty of 1949 on the Accession of the Republic of Finland and the Kingdom of Sweden 117-3 2022-07-20 Reported by Senator Menendez, Committee on Foreign Relations with printed Ex. Rept. 117-5 and a resolution of advice and consent to ratification with six declarations and one condition. Executive Calendar No. 5. Committee
2886 Protocols to the North Atlantic Treaty of 1949 on the Accession of the Republic of Finland and the Kingdom of Sweden 117-3 2022-07-19 Committee on Foreign Relations. Ordered to be reported without amendment favorably. Committee
2885 Protocols to the North Atlantic Treaty of 1949 on the Accession of the Republic of Finland and the Kingdom of Sweden 117-3 2022-07-11 Received in the Senate and referred to the Committee on Foreign Relations by unanimous consent removing the injunction of secrecy. 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);
Powered by Datasette · Queries took 306.732ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API