treaties

Treaties submitted to the Senate (Congresses 89–119), with countries, index terms, and resolution text.

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

2 rows where congress = 118 sorted by transmitted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: transmitted_date (date)

congress 1

id congress number title topic transmitted_date ▲ in_force_date countries index_terms resolution_text
118-2 118 2 Agreement Under the United Nations Convention on the Law of the Sea on the Conservation and Sustainable Use of Marine Biological Diversity of Areas Beyond National Jurisdiction International Law and Organization 2024-12-18T00:00:00Z     Conservation, Law of the Sea, TD 118-2, Treaty Doc. 118-2, United Nations Convention  
118-1 118 1 The Treaty between the United States of America and the Republic of Cuba on the Delimitation of the Continental Shelf in the Eastern Gulf of Mexico beyond 200 Nautical Miles, and the Treaty between the Government of the United States of America and the Government of the United Mexican States on the Delimitation of the Maritime Boundary in the Eastern Gulf of Mexico, both of which were signed at Washington on January 18, 2017 Maritime Boundaries and Claims 2023-12-18T00:00:00Z   Mexico Cuba, Maritime Boundaries, Mexico, TD 118-1, Treaty Doc. 118-1  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE treaties (
    id TEXT PRIMARY KEY,
    congress INTEGER,
    number INTEGER,
    title TEXT,
    topic TEXT,
    transmitted_date TEXT,
    in_force_date TEXT,
    countries TEXT,
    index_terms TEXT,
    resolution_text TEXT
);
CREATE INDEX idx_treaty_congress ON treaties(congress);
CREATE INDEX idx_treaty_date ON treaties(transmitted_date);