FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where "Foreign_Principal_Termination_Date" is on date 1982-12-31
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_1, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Foreign_Principal 19
- Ajinomoto U.S.A., Inc. 1
- American Chamber of Commerce of the Dominican Republic 1
- Curacao Government Tourist Board 1
- European Travel Commission 1
- Government of Haiti 1
- Israel Aircraft Industries, Ltd. 1
- Messerschmitt-Bolkow-Blohm 1
- Ministry of Tourism, Aviation & Trade, Cayman Islands Government 1
- National Film Board of Canada 1
- Procesadora de Carne, S.A. (PROCASA) 1
- Republic of Cyprus 1
- Republic of Gabon 1
- Republic of Zaire 1
- Scottish Development Agency 1
- Senegal Government Tourist Bureau 1
- Somali Democratic Republic 1
- Thyssen Nordseewerke GmbH 1
- Trinidad & Tobago Tourist Board 1
- Trinidad & Tobago Tourist Office 1
Country/Location_Represented 17
- GERMANY, FEDERAL REPUBLIC OF 2
- TRINIDAD AND TOBAGO 2
- CANADA 1
- CAYMAN ISLANDS 1
- CURACAO 1
- CYPRUS 1
- DOMINICAN REPUBLIC 1
- GABON 1
- GUATEMALA 1
- HAITI 1
- INTERNATIONAL 1
- ISRAEL 1
- JAPAN 1
- SCOTLAND 1
- SENEGAL 1
- SOMALI DEMOCRATIC REPUBLIC 1
- ZAIRE 1
Registrant_Name 16
- Squire Patton Boggs, LLP 3
- Tromson Monroe Advertising, Inc. 2
- Dunlap, Donald F. 1
- Fraser Associates, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Hyman Fine & Associates, Ltd. 1
- International Public Relations Company, Ltd. 1
- Kanner Security Group, Inc. 1
- Law Offices of Cohen & Uretz 1
- Modern Education Services, Inc. 1
- Newsome & Company, Inc. 1
- Ritter, Sheldon 1
- Schoenfeld Film Distribution Corporation 1
- Stinson Associates International 1
- TKC International, Inc. 1
- Wilkinson, Cragun & Barker 1
City 1
- - 19
Link | rowid ▼ | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15873 | 15873 | 1982-12-31 | Ajinomoto U.S.A., Inc. | 1977-11-08 | JAPAN | Fraser Associates, Inc. 2844 | 1977-11-08 | Fraser Associates, Inc. | New York | NY | |||
15874 | 15874 | 1982-12-31 | American Chamber of Commerce of the Dominican Republic | 1982-10-28 | DOMINICAN REPUBLIC | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | |||||
15875 | 15875 | 1982-12-31 | Curacao Government Tourist Board | 1976-04-26 | CURACAO | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | |||||
15876 | 15876 | 1982-12-31 | European Travel Commission | 1979-06-19 | INTERNATIONAL | Wilkinson, Cragun & Barker 3032 | 1979-06-19 | Wilkinson, Cragun & Barker | NY | ||||
15877 | 15877 | 1982-12-31 | Government of Haiti | 1981-11-27 | HAITI | Kanner Security Group, Inc. 3310 | 1981-11-27 | Kanner Security Group, Inc. | |||||
15878 | 15878 | 1982-12-31 | Israel Aircraft Industries, Ltd. | 1971-07-29 | ISRAEL | Law Offices of Cohen & Uretz 2272 | 1971-07-29 | Law Offices of Cohen & Uretz | Tel Aviv | ||||
15879 | 15879 | 1982-12-31 | Messerschmitt-Bolkow-Blohm | 1983-03-24 | GERMANY, FEDERAL REPUBLIC OF | Hyman Fine & Associates, Ltd. 3273 | 1981-09-02 | Hyman Fine & Associates, Ltd. | |||||
15880 | 15880 | 1982-12-31 | Ministry of Tourism, Aviation & Trade, Cayman Islands Government | 1980-06-20 | CAYMAN ISLANDS | Stinson Associates International 2873 | 1978-03-27 | Stinson Associates International | Georgetown | ||||
15881 | 15881 | 1982-12-31 | National Film Board of Canada | 1971-05-07 | CANADA | Schoenfeld Film Distribution Corporation 2056 | 1967-10-16 | Schoenfeld Film Distribution Corporation | |||||
15882 | 15882 | 1982-12-31 | Procesadora de Carne, S.A. (PROCASA) | 1980-08-12 | GUATEMALA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Guatemala City | ||||
15883 | 15883 | 1982-12-31 | Republic of Cyprus | 1978-11-01 | CYPRUS | International Public Relations Company, Ltd. 1967 | 1966-03-14 | International Public Relations Company, Ltd. | |||||
15884 | 15884 | 1982-12-31 | Republic of Gabon | 1982-01-25 | GABON | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Washington | DC | |||
15885 | 15885 | 1982-12-31 | Republic of Zaire | 1981-10-27 | ZAIRE | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Washington | DC | |||
15886 | 15886 | 1982-12-31 | Scottish Development Agency | 1982-09-13 | SCOTLAND | Newsome & Company, Inc. 3189 | 1981-01-09 | Newsome & Company, Inc. | |||||
15887 | 15887 | 1982-12-31 | Senegal Government Tourist Bureau | 1977-06-07 | SENEGAL | Ritter, Sheldon 2666 | 1976-03-10 | Ritter, Sheldon | NY | ||||
15888 | 15888 | 1982-12-31 | Somali Democratic Republic | 1982-04-21 | SOMALI DEMOCRATIC REPUBLIC | Dunlap, Donald F. 3359 | 1982-04-21 | Dunlap, Donald F. | Mogadishu | ||||
15889 | 15889 | 1982-12-31 | Thyssen Nordseewerke GmbH | 1982-02-05 | GERMANY, FEDERAL REPUBLIC OF | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
15890 | 15890 | 1982-12-31 | Trinidad & Tobago Tourist Board | 1979-07-20 | TRINIDAD AND TOBAGO | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
15891 | 15891 | 1982-12-31 | Trinidad & Tobago Tourist Office | 1983-07-08 | TRINIDAD AND TOBAGO | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );