FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
29 rows where "Foreign_Principal_Termination_Date" is on date 1989-10-25 sorted by Registrant_Date descending
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Registrant_Date (date)
Foreign_Principal 29
- Austrian Press & Information Service 1
- Autonomous University of Guadalajara 1
- Bahamas Tourist Office 1
- Burson-Marsteller for the Industrial Development Board of Northern Ireland 1
- Ceylon Tea Bureau 1
- Chinese Cultural Center 1
- City of West Berlin 1
- City of West Berlin, New York 1
- Consulate General of Israel 1
- D.J. Edelman for Tourism Canada 1
- Electronic Industries Association of Japan (Hill & Knowlton) 1
- Embassy of Japan 1
- Eurailpass 1
- European Travel Commission, New York 1
- French Government Tourist Office 1
- Government of the Kingdom of Morocco 1
- Hong Kong Tourist Organization 1
- Industrial Development Board of Northern Ireland 1
- Israel Government Tourist Office 1
- Israel Ministry of Tourism 1
- Italian Trade Commission 1
- Jamaica Tourist Board Office 1
- Japan National Tourist Organization 1
- Malaysian Airline System 1
- Revenue Canada - Customs & Excise 1
- Romanian National Tourist Office 1
- Swedish Tourist Board 1
- Swiss National Tourist Office 1
- Tea Board of India 1
Country/Location_Represented 21
Foreign_Principal_Registration_Date (date) 19 ✖
- 1989-09-20 4
- 1988-07-25 3
- 1988-10-12 3
- 1989-04-13 3
- 1989-08-08 2
- 1983-05-04 1
- 1985-04-18 1
- 1986-05-21 1
- 1986-12-12 1
- 1987-02-28 1
- 1987-08-17 1
- 1987-10-22 1
- 1987-12-28 1
- 1988-02-09 1
- 1988-03-18 1
- 1988-04-12 1
- 1988-09-13 1
- 1988-10-03 1
- 1988-12-08 1
Registrant_Name 2
City 1
- - 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13015 | 13015 | 1989-10-25 | Government of the Kingdom of Morocco | 1988-03-18 | MOROCCO | Shearson Lehman Brothers, Inc. 4097 | 1988-03-02 | Shearson Lehman Brothers, Inc. | Rabat | ||||
13000 | 13000 | 1989-10-25 | Austrian Press & Information Service | 1986-12-12 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | |||||
13001 | 13001 | 1989-10-25 | Autonomous University of Guadalajara | 1989-09-20 | MEXICO | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | San Antonio | TX | |||
13002 | 13002 | 1989-10-25 | Bahamas Tourist Office | 1988-10-12 | BAHAMAS | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13003 | 13003 | 1989-10-25 | Burson-Marsteller for the Industrial Development Board of Northern Ireland | 1988-10-03 | NORTHERN IRELAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13004 | 13004 | 1989-10-25 | Ceylon Tea Bureau | 1988-09-13 | SRI LANKA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13005 | 13005 | 1989-10-25 | Chinese Cultural Center | 1988-10-12 | CHINA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13006 | 13006 | 1989-10-25 | City of West Berlin | 1989-09-20 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13007 | 13007 | 1989-10-25 | City of West Berlin, New York | 1988-07-25 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13008 | 13008 | 1989-10-25 | Consulate General of Israel | 1988-07-25 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13009 | 13009 | 1989-10-25 | D.J. Edelman for Tourism Canada | 1988-10-12 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13010 | 13010 | 1989-10-25 | Electronic Industries Association of Japan (Hill & Knowlton) | 1989-09-20 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
13011 | 13011 | 1989-10-25 | Embassy of Japan | 1987-08-17 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | DC | ||||
13012 | 13012 | 1989-10-25 | Eurailpass | 1987-02-28 | FRANCE | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13013 | 13013 | 1989-10-25 | European Travel Commission, New York | 1988-07-25 | INTERNATIONAL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13014 | 13014 | 1989-10-25 | French Government Tourist Office | 1985-04-18 | FRANCE | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13016 | 13016 | 1989-10-25 | Hong Kong Tourist Organization | 1988-12-08 | HONG KONG | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13017 | 13017 | 1989-10-25 | Industrial Development Board of Northern Ireland | 1988-02-09 | NORTHERN IRELAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13018 | 13018 | 1989-10-25 | Israel Government Tourist Office | 1989-08-08 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13019 | 13019 | 1989-10-25 | Israel Ministry of Tourism | 1989-04-13 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13020 | 13020 | 1989-10-25 | Italian Trade Commission | 1987-10-22 | ITALY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13021 | 13021 | 1989-10-25 | Jamaica Tourist Board Office | 1989-04-13 | JAMAICA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13022 | 13022 | 1989-10-25 | Japan National Tourist Organization | 1989-09-20 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13023 | 13023 | 1989-10-25 | Malaysian Airline System | 1988-04-12 | MALAYSIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Los Angeles | CA | |||
13024 | 13024 | 1989-10-25 | Revenue Canada - Customs & Excise | 1989-08-08 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Ottawa | ||||
13025 | 13025 | 1989-10-25 | Romanian National Tourist Office | 1987-12-28 | ROMANIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13026 | 13026 | 1989-10-25 | Swedish Tourist Board | 1983-05-04 | SWEDEN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13027 | 13027 | 1989-10-25 | Swiss National Tourist Office | 1986-05-21 | SWITZERLAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13028 | 13028 | 1989-10-25 | Tea Board of India | 1989-04-13 | INDIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY |
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]) );