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

27 rows where "Foreign_Principal_Termination_Date" is on date 1973-12-31

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 4

City 1

  • - 27
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
15693 15693 1973-12-31 Agensia Telegrafika (ATA) 1964-06-26 ALBANIA Solov, Liuba 1766 1964-06-29 Solov, Liuba Tirane        
15694 15694 1973-12-31 Agerpres 1964-06-26 ROMANIA Solov, Liuba 1766 1964-06-29 Solov, Liuba Bucharest        
15695 15695 1973-12-31 Bulgarska Photographia 1964-06-29 BULGARIA Solov, Liuba 1766 1964-06-29 Solov, Liuba Sofia        
15696 15696 1973-12-31 Centralna Agenja Fotograficzna 1964-06-29 POLAND Solov, Liuba 1766 1964-06-29 Solov, Liuba Warsaw        
15697 15697 1973-12-31 China Photo Service 1964-06-29 CHINA Solov, Liuba 1766 1964-06-29 Solov, Liuba Peking        
15698 15698 1973-12-31 Committee of European Shipowners 1963-07-02 GREAT BRITAIN Capone, Ronald A. 1620 1963-04-19 Capone, Ronald A. London        
15699 15699 1973-12-31 Czechopress 1964-06-29 CZECHOSLOVAKIA Solov, Liuba 1766 1964-06-29 Solov, Liuba Prague        
15700 15700 1973-12-31 Fotokhronika Tass 1964-06-29 USSR Solov, Liuba 1766 1964-06-29 Solov, Liuba Moscow        
15701 15701 1973-12-31 German Federal Railroad 1964-01-14 GERMANY, FEDERAL REPUBLIC OF Albert Woodley Company, Inc. 1679 1964-01-14 Albert Woodley Company, Inc. New York     NY  
15702 15702 1973-12-31 Government of Venezuela 1965-08-31 VENEZUELA Lara, Francisco J. 1920 1965-08-31 Lara, Francisco J. Caracas        
15703 15703 1973-12-31 Hashemite Kingdom of the Jordan 1955-03-03 JORDAN Arab Information Center 876 1955-03-03 Arab Information Center Amman        
15704 15704 1973-12-31 Interfoto MTI 1964-06-26 HUNGARY Solov, Liuba 1766 1964-06-29 Solov, Liuba Budapest        
15705 15705 1973-12-31 Kingdom of Iraq 1955-03-03 IRAQ Arab Information Center 876 1955-03-03 Arab Information Center Baghdad        
15706 15706 1973-12-31 Kingdom of Saudi Arabia 1955-03-03 SAUDI ARABIA Arab Information Center 876 1955-03-03 Arab Information Center Riyadh        
15707 15707 1973-12-31 Kuwait Airways Corporation 1973-10-18 KUWAIT Barkett, Mitchell 2436 1973-06-18 Barkett, Mitchell New York     NY  
15708 15708 1973-12-31 Mezhdunarodnaya Kniga 1964-06-29 USSR Solov, Liuba 1766 1964-06-29 Solov, Liuba Moscow        
15709 15709 1973-12-31 Moroccan National Tourist Office 1973-01-09 MOROCCO Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc.          
15710 15710 1973-12-31 Mutawakilite Kingdom of Yemen 1955-03-03 YEMEN Arab Information Center 876 1955-03-03 Arab Information Center San'aa        
15711 15711 1973-12-31 Novosti Press Agency 1964-06-29 USSR Solov, Liuba 1766 1964-06-29 Solov, Liuba Moscow        
15712 15712 1973-12-31 Republic of Egypt 1955-03-03 EGYPT Arab Information Center 876 1955-03-03 Arab Information Center Cairo        
15713 15713 1973-12-31 Republic of Lebanon 1955-03-03 LEBANON Arab Information Center 876 1955-03-03 Arab Information Center Beirut        
15714 15714 1973-12-31 Republic of Syria 1955-03-03 SYRIA Arab Information Center 876 1955-03-03 Arab Information Center Damascus        
15715 15715 1973-12-31 Royal Danish Consulate General 1967-10-03 DENMARK Association Films, Inc. 1814 1964-11-06 Association Films, Inc. San Francisco     CA  
15716 15716 1973-12-31 USSR Illustrated Monthly 1964-06-26 USSR Solov, Liuba 1766 1964-06-29 Solov, Liuba Washington     DC  
15717 15717 1973-12-31 United Kingdom of Libya 1955-03-03 LIBYA Arab Information Center 876 1955-03-03 Arab Information Center Tripoli        
15718 15718 1973-12-31 Yugofoto 1964-06-29 YUGOSLAVIA Solov, Liuba 1766 1964-06-29 Solov, Liuba Belgrage        
15719 15719 1973-12-31 Zentrale Bildstelle 1964-06-26 GERMANY, FEDERAL REPUBLIC OF Solov, Liuba 1766 1964-06-29 Solov, Liuba Berlin        

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