openregs: treaties: 10 rows where congress = 89 sorted by transmitted

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

10 rows where congress = 89 sorted by transmitted_date descending

descending

id	congress	number	title	topic	transmitted_date ▲	countries	index_terms
89-16	89	16	Convention (No. 122) Concerning Employment Policy	Labor	1966-06-02T00:00:00Z	Multilateral	89-16, CONVENTION NO. 122, EMPLOYMENT, EMPLOYMENT POLICY, T.DOC. 89-16
89-9	89	9	TAX PROTOCOL WITH THE FEDERAL REPUBLIC OF GERMANY	Taxation	1965-09-29T00:00:00Z	Germany	DOUBLE TAXATION, FEDERAL REPUBLID OF GERMANY, GERMANY, INCOME TAX, PROTOCOL, TAX, TAX PROTOCOL, TAXATION
89-8	89	8	AMENDMENTS OF CONVENTION ON INTERGOVERNMENTAL MARITIME CONSULTATIVE ORGANIZATION	Shipping and Marine Pollution	1965-09-13T00:00:00Z		IMCO, IMCO AMENDMENTS, MARITIME, SHIPPING
89-7	89	7	PROTOCOL MODIFYING CONVENTION WITH BELGIUM FOR THE AVOIDANCE OF DOUBLE TAXATION	Taxation	1965-08-05T00:00:00Z	Belgium	BELGIUM, DOUBLE TAXATION, INCOME TAX, PROTOCOL, TAX, TAX PROTOCOL, TAXATION
89-4	89	4	INCOME TAX CONVENTION WITH THE PHILIPPINES	Taxation	1965-07-29T00:00:00Z	Philippines	INCOME TAXES, PHILIPPINES, TAX, TAXATION
89-5	89	5	INCOME TAX CONVENTION WITH THAILAND	Taxation	1965-07-29T00:00:00Z	Thailand	INCOME TAX, TAX, THAILAND
89-6	89	6	TAX CONVENTION WITH ISRAEL	Taxation	1965-07-29T00:00:00Z	Israel	INCOME TAX, INVESTMENT, ISRAEL, TAX TAXATION, TRADE
89-3	89	3	AGREEMENT WITH CANADA ON ESTABLISHMENT OF AN INTERNATIONAL ARBITRAL TRIBUNAL TO DISPOSE OF U. S. CLAIMS RELATING TO GUT DAM	Dispute Settlement and Arbitration	1965-05-17T00:00:00Z	Canada	ARBITRAL TRIBUNAL, ARBITRATION, CANADA, CLAIMS, GUT DAM, ST. LAWRENCE RIVER, U. S. CLAIMS
89-2	89	2	(open for signature in Washington from March 22 to April 23, 1965)	Commercial	1965-04-23T00:00:00Z	multilateral	1962 WHEAT AGREEMENT, 1965 WHEAT AGREEMENT EXTENSION, INTERNATIONAL WHEAT AGREEMENT, WHEAT, WHEAT AGREEMENT, WHEAT AGREEMENT EXTENSION
89-1	89	1	TWO AMENDMENTS TO THE CHARTER OF THE UNITED NATIONS	International Law and Organization	1965-04-06T00:00:00Z	multilateral	ECONOMIC AND SOCIAL COUNCIL, SECURITY COUNCIL, UN CHARTER, UN CHARTER AMENDMENTS, UNITED NATIONS

Advanced export

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

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