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

16,469 rows sorted by Registrant_Date

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Country/Location_Represented

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
8543 8543 1945-07-01 Direccion General del Turismo (Direction General of Tourism) 1942-07-03 SPAIN 2 2 1942-07-03 Garcia-Rubiera, Marcelino Madrid        
8710 8710 1942-07-03 China Defense Supplies, Inc. 1942-07-03 CHINA 3 3 1942-07-03 Lawrence, William S. Washington     DC  
8711 8711 1943-07-03 Associated Distributors Party, Ltd. 1942-07-03 AUSTRALIA 4 4 1942-07-03 Auten, Harold Sydney        
8712 8712 1943-07-03 British Empire Films (N.Z.), Ltd. 1942-07-03 NEW ZEALAND 4 4 1942-07-03 Auten, Harold Wellington        
8713 8713 1943-07-03 British Empire Films Party, Ltd., Australia 1942-07-03 AUSTRALIA 4 4 1942-07-03 Auten, Harold Sydney        
8714 8714 1943-07-03 British Empire Films Party, Ltd., England 1942-07-03 GREAT BRITAIN 4 4 1942-07-03 Auten, Harold London, England        
8715 8715 1943-07-03 Cinesound Productions Party, Ltd. 1942-07-03 AUSTRALIA 4 4 1942-07-03 Auten, Harold          
8716 8716 1943-07-03 Greater Union Theatres Party, Ltd. 1942-07-03 AUSTRALIA 4 4 1942-07-03 Auten, Harold          
8717 8717 1943-07-03 Theatre Management, Ltd. 1942-07-03 NEW ZEALAND 4 4 1942-07-03 Auten, Harold Wellington        
8583 8583 1971-07-01 Swedish Government 1942-07-06 SWEDEN 13 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. Stockholm        
8770 8770 1942-07-06 Danish Travel Information Bureau 1942-07-06 DENMARK 7 7 1942-07-06 Christensen, Valdemar Emil New York     NY  
8771 8771 1946-07-06 Exiled Autonomous Basque Government/Jose' A. de Aguirre 1942-07-06 GREAT BRITAIN 5 5 1942-07-06 De La Sota y Aburto, Manuel Londong, England        
8772 8772 1946-07-06 Basque Delegation in the U.S.A. 1943-03-10 GREAT BRITAIN 5 5 1942-07-06 De La Sota y Aburto, Manuel London, England        
10529 10529 1972-08-29 ABL&P Widengren 1969-08-05 SWEDEN 13 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. Vingaker        
10530 10530 1972-08-29 Port of Gothenburg 1969-08-05 SWEDEN 13 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. Gothenburg        
11189 11189 1951-09-11 Agerpress 1951-04-20 ROMANIA 6 6 1942-07-06 Black, Helen Bucharest        
11190 11190 1951-09-11 China Photo Service 1950-11-16 CHINA 6 6 1942-07-06 Black, Helen Peking        
11191 11191 1951-09-11 Czechopress, Feature-Photo Service 1950-11-16 CZECHOSLOVAKIA 6 6 1942-07-06 Black, Helen Prague        
11192 11192 1951-09-11 Hungarian Bulletin 1950-11-16 HUNGARY 6 6 1942-07-06 Black, Helen Budapest        
11193 11193 1951-09-11 Mezhdunarodnaya Kniga 1942-07-06 USSR 6 6 1942-07-06 Black, Helen          
11194 11194 1951-09-11 Olga de Wolkonsky 1949-08-05 ARGENTINA 6 6 1942-07-06 Black, Helen Buenos Aires        
11195 11195 1951-09-11 Photoagency 1944-03-13 USSR 6 6 1942-07-06 Black, Helen Moscow        
11196 11196 1951-09-11 Polish Research & Information Service 1950-11-16 POLAND 6 6 1942-07-06 Black, Helen New York     NY  
11197 11197 1951-09-11 Presslit (Press & Publisher Literary Agency of the U.S.S.R.) 1944-03-13 USSR 6 6 1942-07-06 Black, Helen Moscow        
11198 11198 1951-09-11 TASS (Telegraph Agency of the U.S.S.R.) 1942-07-06 USSR 6 6 1942-07-06 Black, Helen          
1001 1001 1949-01-03 His Imperial Highness The Grand Duke Wladimir of Russia 1942-07-07 USSR 11 11 1942-07-07 Pouschine, Ivan Madrid        
1231 1231 1943-01-15 Ministry for Foreign Affairs 1943-03-17 FINLAND 10 10 1942-07-07 Ramo, Herman Rudolf Kristian Helsinki        
1232 1232 1943-01-15 Suomen-Matkat (Association Finland Travel) 1942-07-07 FINLAND 10 10 1942-07-07 Ramo, Herman Rudolf Kristian Helsinki        
1254 1254 1973-01-15 Suomen-Matkat (Association Finland-Travel) 1942-07-07 FINLAND 9 9 1942-07-07 Finnish Information Center Helsinki        
3691 3691 1943-03-17 Ministry of Foreign Affairs 1943-03-17 FINLAND 9 9 1942-07-07 Finnish Information Center Helsinki        
8793 8793 1942-07-07 Exiled Autonomous Basque Government 1942-07-07 GREAT BRITAIN 12 12 1942-07-07 De La Sota y Macmahon, Ramon London, England        
8794 8794 1942-07-07 Societe Nationale des Chemins de Fer Francais 1942-07-07 FRANCE 8 8 1942-07-07 French National Railroads, New York          
1073 1073 1943-01-08 Canadian Advertising Agency, Ltd. 1942-07-08 CANADA 19 19 1942-07-08 H.A. Bruno & Associates Montreal        
1074 1074 1946-01-08 Agencia Maritima 1944-08-04 ARGENTINA 16 16 1942-07-08 Garcia & Diaz Buenos Aires        
1075 1075 1946-01-08 Antonio Menchaca y Compania 1944-08-04 SPAIN 16 16 1942-07-08 Garcia & Diaz Bilbao        
1076 1076 1946-01-08 Auxiliar Maritima 1944-08-04 SPAIN 16 16 1942-07-08 Garcia & Diaz Bilbao        
1077 1077 1946-01-08 Compania Espanola de Navegacion Maritima, S.A. 1942-07-08 SPAIN 16 16 1942-07-08 Garcia & Diaz Barcelona        
1078 1078 1946-01-08 Compania Naviera Espanola 1944-08-04 SPAIN 16 16 1942-07-08 Garcia & Diaz Madrid        
1079 1079 1946-01-08 Compania Naviera Vascongada 1944-08-04 SPAIN 16 16 1942-07-08 Garcia & Diaz          
1080 1080 1946-01-08 Compania Trasatlantica, Administrada por el Estado-Apartado 1942-07-08 SPAIN 16 16 1942-07-08 Garcia & Diaz Madrid        
1081 1081 1946-01-08 Compania Trasmediterranea 1942-07-08 SPAIN 16 16 1942-07-08 Garcia & Diaz Madrid        
1082 1082 1946-01-08 Guayaquil & Quito Railway Company 1944-08-04 ECUADOR 16 16 1942-07-08 Garcia & Diaz Quito        
1083 1083 1946-01-08 Hellenic Lines, Ltd. 1942-07-08 GREECE 16 16 1942-07-08 Garcia & Diaz Pireaus        
1084 1084 1946-01-08 Hijo de Ramon Ramos 1944-08-04 SPAIN 16 16 1942-07-08 Garcia & Diaz Barcelona        
1085 1085 1946-01-08 Islena Maritima, S.A. 1943-03-09 SPAIN 16 16 1942-07-08 Garcia & Diaz Madrid        
1086 1086 1946-01-08 Jose Navas Escuder 1944-08-04 SPAIN 16 16 1942-07-08 Garcia & Diaz Barcelona        
1087 1087 1946-01-08 Orion Compania Naviera 1944-08-04 SPAIN 16 16 1942-07-08 Garcia & Diaz Madrid        
1088 1088 1946-01-08 Sud Americana de Exportacion e Importacion S.R., Ltda. 1943-03-09 ARGENTINA 16 16 1942-07-08 Garcia & Diaz Buenos Aires        
1089 1089 1946-01-08 West Hartlepool Steam Navigation Company 1942-07-08 GREAT BRITAIN 16 16 1942-07-08 Garcia & Diaz London, England        
2791 2791 1946-02-28 Confederacion Regional Obrera Mexicana 1942-07-08 MEXICO 20 20 1942-07-08 Haberman, Roberto Mexico City        
8828 8828 1942-07-08 Consulate General of Switzerland 1942-07-08 SWITZERLAND 18 18 1942-07-08 Marx, Karl T. New York     NY  
8829 8829 1943-07-08 Internatioal Transport Workers' Federation 1942-07-08 INTERNATIONAL 14 14 1942-07-08 Lipsett, Alexander S. Bedford, England        
14601 14601 1950-12-11 Belgian Information Center 1942-07-08 BELGIUM 17 17 1942-07-08 Gotham Advertising Company          
14602 14602 1950-12-11 Fred L. Myers & Son 1942-07-08 JAMAICA 17 17 1942-07-08 Gotham Advertising Company Kingston        
14603 14603 1950-12-11 Gotham (Australasia) Party, Ltd. 1942-07-08 AUSTRALIA 17 17 1942-07-08 Gotham Advertising Company Sydney        
14604 14604 1950-12-11 Hiram Walker & Sons, Ltd. 1944-08-09 CANADA 17 17 1942-07-08 Gotham Advertising Company Walkerville        
14605 14605 1950-12-11 Publicity & Travel Department 1942-07-08 SOUTH AFRICA 17 17 1942-07-08 Gotham Advertising Company Johannesburg        
14606 14606 1950-12-11 South African Government 1942-07-08 SOUTH AFRICA 17 17 1942-07-08 Gotham Advertising Company          
14607 14607 1950-12-11 South African Railways & Harbours 1944-02-10 SOUTH AFRICA 17 17 1942-07-08 Gotham Advertising Company Washington     DC  
14608 14608 1950-12-11 William P. Harley, Ltd. 1942-07-08 GREAT BRITAIN 17 17 1942-07-08 Gotham Advertising Company Liverpool        
718 718 1944-01-01 Jewish Agency for Palestine 1942-07-09 PALESTINE 31 31 1942-07-09 Rosenbluth, Martin (Michael) 77 Great Russell, London        
1102 1102 1945-01-09 Erez Israel (Palestine) Foundation Fund Keren Hayesod, Ltd. 1942-07-09 ISRAEL 30 30 1942-07-09 Blumenfeld, Kurt Behavia, Jerusalem        
2152 2152 1948-02-06 Spanish Embassy 1942-07-09 SPAIN 27 27 1942-07-09 LeRoy & Denslow Washington     DC  
3090 3090 1950-03-01 French Consulate 1950-06-05 FRANCE 27 27 1942-07-09 LeRoy & Denslow Washington     DC  
4004 4004 1943-03-30 Department of Fomento, Republic of the U.S. of Venezuela 1942-07-09 VENEZUELA 25 25 1942-07-09 Arroyo, Julian Avelino Caracas        
8853 8853 1942-07-09 Dr. Syngman Rhee 1942-07-09 KOREA, SOUTH 26 26 1942-07-09 Chang, Kee Young Washington     DC  
8854 8854 1942-07-09 Vicesecretaria de Educacion Popular 1942-07-09 SPAIN 28 28 1942-07-09 Spanish Library of Information Madrid        
8855 8855 1943-07-09 Finnish-American Trading Corporation 1942-07-09 FINLAND 24 24 1942-07-09 Jarvinen, Vilho Olavi New York     NY  
8857 8857 1946-07-09 Sino-Korean People's League 1942-07-09 KOREA, SOUTH 23 23 1942-07-09 Haan, Kilsoo Kenneth Honolulu     HI  
8858 8858 1946-07-09 Korean National Front Federation 1942-07-09 KOREA, SOUTH 23 23 1942-07-09 Haan, Kilsoo Kenneth Chungking        
8859 8859 1950-07-09 Argentine Embassy 1943-07-30 ARGENTINA 27 27 1942-07-09 LeRoy & Denslow Washington     DC  
8860 8860 1950-07-09 Legation of Finland 1944-02-02 FINLAND 27 27 1942-07-09 LeRoy & Denslow Washington     DC  
9209 9209 1943-07-26 Spanish Library of Information 1942-07-09 SPAIN 29 29 1942-07-09 Carpenter, Charles M. New York     NY  
13399 13399 1947-11-07 Legation of Hungary 1946-07-11 HUNGARY 27 27 1942-07-09 LeRoy & Denslow Washington     DC  
13719 13719 1945-11-21 Legation of Sweden, Department of Finnish Interests 1944-07-28 SWEDEN 27 27 1942-07-09 LeRoy & Denslow Washington     DC  
1114 1114 1945-01-10 Johann Luehne, Sr. 1942-07-10 GERMANY, FEDERAL REPUBLIC OF 33 33 1942-07-10 Luehne Jr., John H. Chicago     IL  
1115 1115 1945-01-10 Modene Louis Rachin 1942-07-10 GERMANY, FEDERAL REPUBLIC OF 33 33 1942-07-10 Luehne Jr., John H. Chicago     IL  
8890 8890 1943-07-10 Department of Fomento, Venezuelan Government 1942-07-10 VENEZUELA 35 35 1942-07-10 Franklin, Emilio          
6526 6526 1945-05-23 Comision Nacional de Propaganda y Defensa del Tabaco Habano, Ministerio de Agricultura, Republica de Cuba 1942-07-11 CUBA 38 38 1942-07-11 Arnaz y Alberni, Desiderio Habana        
8905 8905 1942-07-11 Cuban Tourist Commission (Corporacion Nacional del Turismo) 1942-07-11 CUBA 40 40 1942-07-11 Ardois, Luis Fernandez Havana        
14206 14206 1946-12-01 Commission of Government of Newfoundland 1942-07-11 NETHERLANDS 37 37 1942-07-11 Newfoundland Government Information Bureau St. John's        
3662 3662 1943-03-16 Dr. Willibald N. Ploechl, Chairman of Free Austrian National Council 1942-07-13 AUSTRIA 43 43 1942-07-13 Gassner, Josef Hieronymus          
4669 4669 1943-04-01 Austrian Nation, Austrian Federal Government, Federation of Austrians (Underground Movement) 1942-07-13 AUSTRIA 44 44 1942-07-13 Ploechl, Willibald Maria          
8945 8945 1945-07-13 Royal Danish Legation (Consulate General of Denmark) 1942-07-13 DENMARK 42 42 1942-07-13 Larsen-Heltborg, Arthur E. Washington     DC  
8987 8987 1946-07-15 Accion Republicana Espanola 1942-07-13 MEXICO 41 41 1942-07-13 Asensio, Jose'          
1878 1878 1952-02-01 Hamburg-American Line 1942-07-14 GERMANY, FEDERAL REPUBLIC OF 45 45 1942-07-14 Knauth, Arnold Whitman Hamburg        
1233 1233 1946-01-15 Dutch Central Transport Workers' Union 1942-07-15 NETHERLANDS 49 49 1942-07-15 Dutch Central Transport Workers' Union New York     NY  
1234 1234 1946-01-15 Netherlands Information Bureau 1942-07-15 NETHERLANDS 49 49 1942-07-15 Dutch Central Transport Workers' Union New York     NY  
2283 2283 1946-02-11 Asociacion Monarquica Espanola 1942-07-15 SPAIN 47 47 1942-07-15 De Agustin, Don Manuel          
11384 11384 1963-09-18 Dr. Arnolds Spekke, Charge d'Affaires of Lativa to the U.S. 1942-07-15 LATVIA 46 46 1942-07-15 Law Jr., Robert H. Washington     DC  
11385 11385 1963-09-18 Dr. Alfred Bilmanis, Latvian Minister & Consul General of Latvia in the U.S. & the Latvian Legation 1942-07-15 LATVIA 46 46 1942-07-15 Law Jr., Robert H. Washington     DC  
11386 11386 1963-09-18 Dr. Anatol Dinbergs, Counselor, Latvian Legation 1942-07-15 LATVIA 46 46 1942-07-15 Law Jr., Robert H. Washington     DC  
15096 15096 1942-12-31 Dutch Central Transport Workers' Union 1943-03-13 NETHERLANDS 48 48 1942-07-15 Van Den Berge, Petrus Jacobus London, Englad        
15098 15098 1942-12-31 Netherlands Information Bureau 1942-07-15 NETHERLANDS 48 48 1942-07-15 Van Den Berge, Petrus Jacobus New York     NY  
3600 3600 1943-03-15 French Ambassador Gaston Henry-Haye 1943-03-15 FRANCE 51 51 1942-07-16 Jules-Bois, Henri Antoine          
3601 3601 1943-03-15 French Embassy 1942-07-16 FRANCE 51 51 1942-07-16 Jules-Bois, Henri Antoine          
7576 7576 1946-06-15 Comite' International du Bois 1942-07-16 INTERNATIONAL 52 52 1942-07-16 Glesinger, Egon Brussels        
9028 9028 1942-07-16 G. Henry-Haye (French Embassy) 1942-07-16 FRANCE 50 50 1942-07-16 Musa, John L. Washington     DC  
3931 3931 1944-03-27 Latvian Legation 1942-07-17 LATVIA 53 53 1942-07-17 Lielnors, Harry W. Washington     DC  
1355 1355 1945-01-20 Dr. Slawoj-Skladkowski 1942-07-20 POLAND 57 57 1942-07-20 Banach, Francis-Louis Edward          

Next page

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