FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

29 rows where Foreign_Principal_Termination_Date = "1989-10-25"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 5

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

CSV options: 

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