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

39 rows where "Foreign_Principal_Termination_Date" is on date 1987-12-31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registrant_Date, Address_1, Registrant_Date (date)

State 3

City 1

  • - 39
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
15993 15993 1987-12-31 Taiwan Mushroom Packers' United Export Corporation 1972-06-05 TAIWAN Solter, Myron W. 1970 1966-03-22 Solter, Myron W. Taipei        
15994 15994 1987-12-31 Asociacion de Empresas RENFE/Patentes TALGO, S.A. 1987-05-21 SPAIN Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 1977-06-29 Finley Kumble Wagner Heine Underberg Manley Myerson & Casey Madrid        
15995 15995 1987-12-31 Association for the Advancement of Human Rights in Japan 1986-01-27 JAPAN Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell Tokyo        
15996 15996 1987-12-31 Association of British Insurers 1985-10-04 GREAT BRITAIN Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 1977-06-29 Finley Kumble Wagner Heine Underberg Manley Myerson & Casey London        
15997 15997 1987-12-31 Bahamas Ministry of Tourism 1982-09-27 BAHAMAS N.W. Ayer & Son, Inc. 3411 1982-09-27 N.W. Ayer & Son, Inc. Nassau        
15998 15998 1987-12-31 British Airports Authority 1984-08-23 GREAT BRITAIN Kilpatrick & Cody 3610 1984-08-29 Kilpatrick & Cody London        
15999 15999 1987-12-31 Canadian Forest Industries Council 1985-05-21 CANADA APCO Associates 3597 1984-06-20 APCO Associates Ottawa        
16000 16000 1987-12-31 Cayman Airways, Ltd. 1984-07-20 CAYMAN ISLANDS Merren, Orren 3412 1982-09-29 Merren, Orren          
16001 16001 1987-12-31 Cayman Islands Government 1982-09-29 CAYMAN ISLANDS Merren, Orren 3412 1982-09-29 Merren, Orren          
16002 16002 1987-12-31 Cayman Turtle Farm (1983), Ltd. 1984-07-20 CAYMAN ISLANDS Merren, Orren 3412 1982-09-29 Merren, Orren          
16003 16003 1987-12-31 Costa Rica Private Shirt Industry 1987-07-13 COSTA RICA International Development Systems, Inc. 4012 1987-07-13 International Development Systems, Inc. San Jose        
16004 16004 1987-12-31 Embassy of Japan 1977-07-21 JAPAN Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 1977-06-29 Finley Kumble Wagner Heine Underberg Manley Myerson & Casey Washington     DC  
16005 16005 1987-12-31 Fur Institute of Canada 1987-09-01 CANADA Riley, Thomas G. 4034 1987-09-01 Riley, Thomas G. Toronto, Ontario        
16006 16006 1987-12-31 General Administration of Civil Aviation of China (CAAC) 1987-04-03 CHINA Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 1977-06-29 Finley Kumble Wagner Heine Underberg Manley Myerson & Casey Beijing        
16007 16007 1987-12-31 Government of Antigua & Barbuda 1977-06-29 ANTIGUA & BARBUDA Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 1977-06-29 Finley Kumble Wagner Heine Underberg Manley Myerson & Casey St. John's        
16008 16008 1987-12-31 Government of Cape Verde 1986-10-30 CABO VERDE Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 1977-06-29 Finley Kumble Wagner Heine Underberg Manley Myerson & Casey Washington     DC  
16009 16009 1987-12-31 Government of Libya 1977-07-13 LIBYA Aramtek Corporation 2810 1977-07-13 Aramtek Corporation          
16010 16010 1987-12-31 Government of the Republic of Singapore 1985-08-23 SINGAPORE St. Maxens & Company 3726 1985-08-23 St. Maxens & Company          
16011 16011 1987-12-31 Hashemite Kingdom of Jordan 1981-10-06 JORDAN IBTT Consultants, Inc. 3281 1981-10-06 IBTT Consultants, Inc. Amman        
16012 16012 1987-12-31 KLM Royal Dutch Airlines 1964-10-29 NETHERLANDS Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
16013 16013 1987-12-31 King Faisal Foundation 1984-08-28 SAUDI ARABIA Braun & Company 3609 1984-08-28 Braun & Company       DC  
16014 16014 1987-12-31 Major Saad Haddad, Free Lebanon, Merjayoun, Lebanon 1981-12-03 LEBANON Tayoun, Joseph John 3315 1981-12-03 Tayoun, Joseph John Good Fence - Metulla        
16015 16015 1987-12-31 Manitoba Energy Authority 1986-12-24 CANADA Radin & Associates, Inc. 3921 1986-12-24 Radin & Associates, Inc. Manitoba        
16016 16016 1987-12-31 NTS (Narodno-Trudovoy Soyuz) 1973-11-20 USSR NTS-Alliance of Russian Solidarists 565 1949-03-07 NTS-Alliance of Russian Solidarists Frankfurt        
16017 16017 1987-12-31 New Zealand Government Tourist Office 1977-09-16 NEW ZEALAND Peter Rothholz Associates, Inc. 2830 1977-09-16 Peter Rothholz Associates, Inc. Wellington        
16018 16018 1987-12-31 Panama Apparel Association 1987-07-13 PANAMA International Development Systems, Inc. 4012 1987-07-13 International Development Systems, Inc. Panama        
16019 16019 1987-12-31 Republic of Ciskei 1985-02-06 CISKEI Morgan, Gary Russell 3648 1985-02-06 Morgan, Gary Russell Bisho        
16020 16020 1987-12-31 Republic of Korea 1984-01-31 KOREA, SOUTH Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC          
16021 16021 1987-12-31 Sahrawi Arab Democratic Republic (SADR) 1986-11-17 ALGERIA Guerra-Mondragon, Gabriel 3907 1986-11-17 Guerra-Mondragon, Gabriel El Aioun Setlmt West        
16022 16022 1987-12-31 Sir William Lithgow 1986-11-03 GREAT BRITAIN Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 1977-06-29 Finley Kumble Wagner Heine Underberg Manley Myerson & Casey Argyllshire        
16023 16023 1987-12-31 Societe Generale de Surveillance, S.A. 1986-10-21 SWITZERLAND TransSwiss Exports, Ltd. 3899 1986-10-21 TransSwiss Exports, Ltd. Geneva        
16024 16024 1987-12-31 South African Sugar Association (SASA) 1986-09-29 SOUTH AFRICA South African Sugar Association (SASA) 3892 1986-09-29 South African Sugar Association (SASA) Durban        
16025 16025 1987-12-31 St. Lucia Tourist Board 1987-05-08 SAINT LUCIA Warren/Kremer Advertising, Inc. 3977 1987-05-08 Warren/Kremer Advertising, Inc. Castries        
16026 16026 1987-12-31 State of Yucatan, Mexico (Assets & Business of Registrant Acquired by Hill & Knowlton, Inc., Registration No. 3301) 1986-12-15 MEXICO Carl Byoir & Associates, Inc. 3170 1980-11-24 Carl Byoir & Associates, Inc. Merida, Yucatan        
16027 16027 1987-12-31 Swedish Trade Council (Formerly: Sveriges Exportrad) 1982-03-16 SWEDEN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
16028 16028 1987-12-31 Taiwan Regional Association of Rubber Industries 1987-09-29 TAIWAN Solter, Myron W. 1970 1966-03-22 Solter, Myron W. Taipei        
16029 16029 1987-12-31 Turkish Republic of Northern Cyprus 1985-06-04 CYPRUS Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs Washington     DC  
16030 16030 1987-12-31 Verband der Chemischen Industrie, E.V. (VCI) 1987-07-08 GERMANY, FEDERAL REPUBLIC OF O'Melveny & Myers 3346 1982-03-12 O'Melveny & Myers Frankfurt am Main        
16031 16031 1987-12-31 Yan Shan Science & Technology Corporation 1981-04-15 CHINA A.I.T. Corporation 3228 1981-04-15 A.I.T. Corporation Beijing        

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