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

28 rows where congress = 97 sorted by transmitted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: topic, transmitted_date, in_force_date, countries, resolution_text, transmitted_date (date), in_force_date (date)

congress 1

id congress number title topic transmitted_date ▲ in_force_date countries index_terms resolution_text
97-28 97 28 TAX CONVENTIION WITH AUSTRALIA Taxation 1982-09-14T00:00:00Z 1983-10-31T00:00:00Z Australia 97-28, AUSTRALIA, INCOME TAX, TAX, TAX CONVENTION, TAXATION  
97-27 97 27 TAX CONVENTION WITH NEW ZEALAND Taxation 1982-08-13T00:00:00Z 1983-11-02T00:00:00Z New Zealand 97-27, INCOME TAX, NEW ZEALAND, TAX, TAX CONVENTION, TAXATION  
97-26 97 26 TAX CONVENTION WITH AUSTRIA Taxation 1982-08-10T00:00:00Z 1983-07-01T00:00:00Z Austria 97-26, AUSTRIA, ESTATE TAX, GENERATION-SKIPPING TRANSFERS, GIFT TAX, INHERITANCE TAX, TAX, TAX CONVENTION, TAXATION  
97-25 97 25 CONVENTION FOR THE CONSERVATION OF SALMON IN THE NORTH ATLANTIC OCEAN Fisheries and Wildlife 1982-06-22T00:00:00Z 1983-10-01T00:00:00Z   97-25, ATLANTIC OCEAN, ATLANTIC SALMON, CONSERVATION OF SALMON, NORTH ATLANTIC OCEAN, SALMON, SALMON CONSERVATION  
97-24 97 24 AGREEMENT WITH THE PEOPLE'S REPUBLIC OF CHINA WITH RESPECT TO MUTUAL EXEMPTION FROM TAXATION OF TRANSPORTATION INCOME OF SHIPPING AND AIR TRANSPORT ENTERPRISES Taxation 1982-06-16T00:00:00Z 1983-09-23T00:00:00Z China 97-24, AIR TRANSPORT ENTERPRISES, CHINA, PEOPLE'S REPUBLIC OF CHINA, SHIPPING, TAX, TAXATION, TRANSPORTATION, TRANSPORTATION INCOME  
97-23 97 23 INTERNATIONAL CONVENTION ON THE SIMPLIFICATION AND HARMONIZATION OF CUSTOMS PROCEDURES Commercial 1982-02-22T00:00:00Z 1984-01-28T00:00:00Z   97-23, CUSTOMS, CUSTOMS PRODECURES, HARMONIZATION OF CUSTOMS PROCEDURES, SIMPLIFICATION OF CUSTOMS PROCEDURES  
97-22 97 22 PROTOCOL TO THE NORTH ATLANTIC TREATY ON THE ACCESSION OF SPAIN International Law and Organization 1982-01-26T00:00:00Z 1982-05-29T00:00:00Z   97-22, ACCESSION OF SPAIN, NATO, NORTH ATLANTIC TREATY, NORTH ATLANTIC TREATY ORGANIZATION, SPAIN  
97-21 97 21 RADIO REGULATIONS (GENEVA, 1979) Commercial 1981-11-24T00:00:00Z 1983-10-27T00:00:00Z   97-21, RADIO, RADIO REGULATIONS  
97-20 97 20 AGREEMENT EXTENDING FOR EIGHT MONTHS PROVISIONS OF THE TREATY OF FRIENDSHIP AND COOPERATION WITH SPAIN Commercial 1981-10-09T00:00:00Z 1982-05-10T00:00:00Z Spain 97-20, COOPERATION, SPAIN, TREATY OF FRIENDSHIP  
97-19 97 19 CONSTITUTION OF THE UNITED NATIONS INDUSTRIAL DEVELOPMENT ORGANIZATION (UNIDO) ADOPTED BY THE UNITED NATIONS CONFERENCE ON THE ESTABLISHMENT OF THE UNITED NATIONS INDUSTRIAL DEVELOPMENT ORGANIZATION AS A SPECIALIZED AGENCY ON APRIL 8, 1979, AND SIGNED ON BEHALF OF THE UNITED STATES ON JANUARY 17, 1980. International Law and Organization 1981-10-05T00:00:00Z     97-19, CONSTITUTION, INDUSTRIAL DEVELOPMENT, INDUSTRIAL DEVELOPMENT ORGANIZATION, UNITED NATIONS  
97-18 97 18 CONVENTION WITH MEXICO FOR THE RECOVERY AND RETURN OF STOLEN OR EMBEZZLED VEHICLES AND AIRCRAFT Extradition and Criminal Assistance 1981-09-29T00:00:00Z 1983-06-28T00:00:00Z Mexico 97-18, AIRCRAFT, EMBEZZLED AIRCRAFT, EMBEZZLED VEHICLES, MEXICO, RECOVERY AND RETURN, STOLEN AIRCRAFT, STOLEN VEHICLES, VEHICLES  
97-17 97 17 PROTOCOL AMENDING THE 1980 TAX CONVENTION WITH JAMAICA Taxation 1981-09-09T00:00:00Z 1981-12-29T00:00:00Z Jamaica 97-17, INCOME TAX, JAMAICA, TAX, TAX CONVENTION, TAXATION  
97-16 97 16 TREATY OF MUTUAL LEGAL ASSISTANCE WITH THE NETHERLANDS Extradition and Criminal Assistance 1981-08-06T00:00:00Z 1983-09-15T00:00:00Z Netherlands 97-16, LEGAL, LEGAL ASSISTANCE, MUTUAL LEGAL ASSISTANCE, NETHERLANDS  
97-15 97 15 SUPPLEMENTARY EXTRADITION CONVENTION WITH SWEDEN Extradition and Criminal Assistance 1981-07-28T00:00:00Z   Sweden 97-15, EXTRADITION, S. Res 267 (106th), SWEDEN  
97-14 97 14 1979 AMENDMENT TO A REGULATION OF ANNEX II OF THE INTERNATIONAL CONVENTION ON LOAD LINES, 1966 Shipping and Marine Pollution 1981-07-27T00:00:00Z     1979 AMENDMENT, 97-14, AMENDMENT TO REGULATION, ANNEX II, Ex. Rept. 102-3, INTERNATIONAL CONVENTION ON LOAD LINES, LOAD LINES, LOAD LINES CONVENTION, S. Res. 104 (102nd)  
97-13 97 13 TREATY WITH CANADA ON PACIFIC COAST ALBACORE TUNA VESSELS AND PORT PRIVILEGES Fisheries and Wildlife 1981-07-01T00:00:00Z 1981-07-29T00:00:00Z Canada 97-13, ALBACORETUNA, CANADA, PACIFIC COAST, PACIFIC COAST ALBACORE TUNA VESSELS, PORT PRIVILEGES, TUNA, TUNA VESSELS  
97-12 97 12 INTER-AMERICAN CONVENTION ON INTERNATIONAL COMMERCIAL ARBITRATION Commercial 1981-06-15T00:00:00Z   inter-american 97-12, ARBITRATION, COMMERCIAL ARBITRATION, INTER-AMERICAN, INTERNATIONAL COMMERCIAL ARBITRATION <!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml" lang="en"><head><meta name="dc:title" content="[ 99] TreatyRes. 19 for Treaty Doc. 97 - 12" /><meta name="Content-Type" content="application/rtf" /><title>[ 99] TreatyRes. 19 for Treaty Doc. 97 - 12</title></head><body><p>TEXT OF RESOLUTION OF ADVICE AND CONSENT TO RATIFICATION REPORTED BY THE COMMITTEE ON FOREIGN RELATIONS AND AS ADOPTED BY THE SENATE:</p><p>Resolved, (two-thirds of the Senators present concurring therein), That the Senate advise and consent to the ratification of the Inter-American Convention on Commercial Arbitration adopted by the First Inter-American Specialized Conference on Private International Law, at Panama City, Panama, on January 30, 1975, and signed by the United States on June 9, 1978, subject to the following reservations:</p><p>1. Unless there is an express agreement among the parties to an arbitration agreement to the contrary, where the requirements for application of both the Inter-American Convention on International Commercial Arbitration and the Convention on the Recognition and Enforcement of Foreign Arbitral Awards are met, if a majority of such parties are citizens of a state or states that have ratified or acceded to the Inter-American Convention and are member states of the Organization of American States, the Inter-American Convention shall apply. In all other cases, the Convention on the Recognition and Enforcement of Foreign Arbitral Awards shall apply.</p><p>2. The United States of America will apply the rules of procedure of the Inter-American Commercial Arbitration Commission which are in effect on the date that the United States of America deposits its instrument of ratification, unless the United States of America makes a later official determination to adopt and apply subsequent amendments to such rules.</p><p>3. The United States of America will apply the Convention, on the basis of reciprocity, to the recognition and enforcement of only those awards made in the territory of another Contracting State. (…
97-10 97 10 TAX CONVENTION WITH ARGENTINA Taxation 1981-06-11T00:00:00Z   Argentina 97-10, ARGENTINA, CAPITAL TAX, INCOME TAX, TAX, TAX CONVENTION, TAXATION  
97-11 97 11 MUTUAL LEGAL ASSISTANCE TREATY WITH COLOMBIA Extradition and Criminal Assistance 1981-06-11T00:00:00Z   Colombia 97-11, COLOMBIA, LEGAL ASSISTANCE, MUTUAL LEGAL ASSISTANCE  
97-9 97 9 1981 PROTOCOLS FOR THE EXTENSION OF THE INTERNATIONAL WHEAT AGREEMENT, 1971 Commercial 1981-06-11T00:00:00Z 1982-01-12T00:00:00Z   97-9, EXTENSION OF WHEAT AGREEMENT, FOOD AID CONVENTION, INTERNATIONAL WHEAT AGREEMENT, WHEAT, WHEAT AGREEMENT, WHEAT TRADE CONVENTION  
97-7 97 7 EXTRADITION TREATY WITH THE NETHERLANDS Extradition and Criminal Assistance 1981-06-01T00:00:00Z 1983-09-15T00:00:00Z Netherlands 97-7, EXTRADITION, NETHERLANDS  
97-8 97 8 EXTRADITION TREATY WITH COLOMBIA Extradition and Criminal Assistance 1981-06-01T00:00:00Z 1982-03-04T00:00:00Z Colombia 97-8, COLOMBIA, EXTRADITION  
97-6 97 6 TAX CONVENTION WITH THE BRITISH VIRGIN ISLANDS Taxation 1981-04-21T00:00:00Z   Virgin Islands (British Overseas Territory) 97-6, BRITISH VIRGIN ISLANDS, INCOME TAX, TAX, TAX CONVENTION, TAXATION, VIRGIN ISLANDS  
97-5 97 5 TREATY WITH NEW ZEALAND ON DELIMITATION OF U.S.-TOKELAU MARITIME BOUNDARY Maritime Boundaries and Claims 1981-03-25T00:00:00Z 1983-09-03T00:00:00Z New Zealand 97-5, DELIMITATION OF MARITIME BOUNDARY, MARITIME, MARITIME BOUNDARY, NEW ZEALAND, TOKELAU  
97-2 97 2 PROTOCOL TO THE AGREEMENT ON THE IMPORTATION OF EDUCATIONAL, SCIENTIFIC, AND CULTURAL MATERIALS International Law 1981-01-19T00:00:00Z 1982-10-25T00:00:00Z   97-2, CULTURAL MATERIALS, EDUCATIONAL MATERIALS, IMPORTATION, IMPORTATION AGREEMENT, SCIENTIFIC MATERIALS, UNITED NATIONS  
97-3 97 3 CONSULAR CONVENTION WITH THE PEOPLE'S REPUBLIC OF CHINA Consular 1981-01-19T00:00:00Z 1982-02-19T00:00:00Z China 97-3, CHINA, CONSULAR, PEOPLE'S REPUBLIC OF CHINA  
97-4 97 4 PROTOCOL RELATING TO AN AMENDMENT TO THE INTERNATIONAL CIVIL AVIATION CONVENTION Aviation 1981-01-19T00:00:00Z     97-4, AVIATION, CIVIL AVIATION, CIVIL AVIATION CONVENTION, INTERNATIONAL CIVIL AVIATION  
97-1 97 1 TAX CONVENTION WITH THE FEDERAL REPUBLIC OF GERMANY Taxation 1981-01-15T00:00:00Z 1986-06-27T00:00:00Z Germany 97-1, ESTATE TAX, FEDERAL REPUBLIC OF GERMANY, GERMANY, GIFT TAX, INHERITANCE TAX, TAX, TAX CONVENTION, TAXATION, TIAS 11082  

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