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

302 rows where Country/Location_Represented = "USSR" sorted by Foreign_Principal_Registration_Date

✎ View and edit SQL

This data as json, CSV (advanced)

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

City

State

Country/Location_Represented

  • USSR · 302 ✖
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
11130 11130 1951-09-11 Mezhdunarodnaya Kniga 1942-07-06 USSR 6 6 1942-07-06 Black, Helen          
11135 11135 1951-09-11 TASS (Telegraph Agency of the U.S.S.R.) 1942-07-06 USSR 6 6 1942-07-06 Black, Helen          
970 970 1949-01-03 His Imperial Highness The Grand Duke Wladimir of Russia 1942-07-07 USSR 11 11 1942-07-07 Pouschine, Ivan Madrid        
2270 2270 1947-02-12 Republic of Estonia 1942-08-12 USSR 91 91 1942-08-12 Jaakson, Ernst Rudolf New York     NY  
2656 2656 1947-02-26 Kasmu Laeva Omanikud (Kasmu Shipowners' Association) 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Tallnin, Estonia        
2657 2657 1947-02-26 A.S. Merilaid & Company 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Tallnin, Estonia        
2658 2658 1947-02-26 Agricultural Cooperative Society LIETUKIS 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Kaunas, Lithuania        
2659 2659 1947-02-26 All Union Chartering Company (Sovfracht) 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Moscow        
2660 2660 1947-02-26 Amtorg Trading Corporation 1942-08-26 USSR 108 108 1942-08-26 Drucker, David New York     NY  
2661 2661 1947-02-26 Apvienota Kugniecibas A.K.S. Sab. 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Riga, Latvia        
2662 2662 1947-02-26 Artkino Pictures, Inc. 1942-08-26 USSR 108 108 1942-08-26 Drucker, David New York     NY  
2663 2663 1947-02-26 Baltic State S.S. Company 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Leningrad        
2664 2664 1947-02-26 Black Sea & Baltic General Insurance Company 1942-08-26 USSR 108 108 1942-08-26 Drucker, David London, England        
2665 2665 1947-02-26 Black Sea State S.S. Company 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Odessa        
2666 2666 1947-02-26 Estonia State Steamship Line 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Tallnin, Estonia        
2667 2667 1947-02-26 F. Grauds 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Riga, Latvia        
2668 2668 1947-02-26 Flor N. Koritz 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Washington     DC  
2669 2669 1947-02-26 Juri Silberberg 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Tallnin, Estonia        
2670 2670 1947-02-26 Karl Mitt & Company 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Tallnin, Estonia        
2671 2671 1947-02-26 Latvia State Steamship Line 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Riga, Latvia/Moscow        
2672 2672 1947-02-26 Latvyas Kugniecibas Sabiedriba (Latvian Shipping Company) 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Riga, Latvia        
2673 2673 1947-02-26 Lietuvas Baltyos Lloydos, Lithuanian Baltic Lloyd 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Kaunas, Lithuania        
2674 2674 1947-02-26 Oskar Tiedemann 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Tallnin, Estonia        
2675 2675 1947-02-26 Tallinna Laevahisis, A.S. (Tallnin Shipping Company, Ltd.) 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Tallnin, Estonia        
2676 2676 1947-02-26 Vassily Ratoushny 1942-08-26 USSR 108 108 1942-08-26 Drucker, David Vladivostok        
7597 7597 1944-06-17 Universal Press Service (Service Universal de Presse) 1942-10-01 USSR 133 133 1942-10-01 Granich, Grace Moscow        
5446 5446 1945-04-29 Alexandra Ivanovna Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5448 5448 1945-04-29 Basil Katinivic 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5451 5451 1945-04-29 Chae Hene Goldenberg 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5455 5455 1945-04-29 David Greenberg 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5458 5458 1945-04-29 Dmitry Wasilievich Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5459 5459 1945-04-29 Dorothy Herzog 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5460 5460 1945-04-29 Emily Borgardt 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5465 5465 1945-04-29 Gregor Kashisky 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5469 5469 1945-04-29 Ivan Wasilievich Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5470 5470 1945-04-29 Jacob Greenberg 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5476 5476 1945-04-29 Luba Katz 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5479 5479 1945-04-29 Malasha Rewchuk 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5480 5480 1945-04-29 Maria Wasilievna Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5482 5482 1945-04-29 Mary Loz 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5492 5492 1945-04-29 Next of Kin of the Estate of Demetri Teplikow (a/k/a Jim Circulowski) 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5493 5493 1945-04-29 Next of Kin of the Estate of Frank Norwillas (Norwellas) 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5494 5494 1945-04-29 Nick Katinivic 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5497 5497 1945-04-29 Pavel Wasilievich Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5498 5498 1945-04-29 Pavlina E. Wolochonovich 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5499 5499 1945-04-29 Peter Wasilievich Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5500 5500 1945-04-29 Phyllis Katinivic 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5509 5509 1945-04-29 Walter Katinivic 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5510 5510 1945-04-29 Wladimir Terentiev Maximovich 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5511 5511 1945-04-29 Yehuda Greenberg 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
11877 11877 1943-10-01 Archbishop Gevorg Cheorekjian, Vicar Catholicos of the American Church 1943-04-08 USSR 188 188 1943-04-08 Prelacy of the Armenian Apostolic Church in America, Inc. Armenia        
6271 6271 1943-05-14 Johannes Kaiv, Consul General of Estonia 1943-05-14 USSR 191 191 1943-05-14 Beck, P.A. New York     NY  
5456 5456 1945-04-29 Deborah Katz 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5462 5462 1945-04-29 Etta (Yanta) Milner 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5464 5464 1945-04-29 Gittel Ubogy 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5477 5477 1945-04-29 Machlea Kesselman 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5485 5485 1945-04-29 Minna Gruenfeld 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5489 5489 1945-04-29 Next of Kin of Constantine Tarbeyff 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
11132 11132 1951-09-11 Photoagency 1944-03-13 USSR 6 6 1942-07-06 Black, Helen Moscow        
11134 11134 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        
5475 5475 1945-04-29 Lily Schwarzwald 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5488 5488 1945-04-29 Nenu Dzanguberkova 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5490 5490 1945-04-29 Next of Kin of Harry Pavloos (Harry Thomas Pavlof) 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5491 5491 1945-04-29 Next of Kin of Solomon Wapner (Wapno) 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5495 5495 1945-04-29 Olga Kubalova 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5502 5502 1945-04-29 Safetka Tseboeva 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5505 5505 1945-04-29 Sonya Gloeva 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5452 5452 1945-04-29 Chai Drezar Karvorsky 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5453 5453 1945-04-29 Chaika Botwinick 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5454 5454 1945-04-29 Children of Schmeul Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5461 5461 1945-04-29 Esta Risha Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5467 5467 1945-04-29 Herschel Botwinick 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5468 5468 1945-04-29 Itzick Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5471 5471 1945-04-29 Laber Botwinick 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5472 5472 1945-04-29 Lazar Botwinick 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5473 5473 1945-04-29 Leib Einbender 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5474 5474 1945-04-29 Leve Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5487 5487 1945-04-29 Moisha Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5503 5503 1945-04-29 Shayer Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5504 5504 1945-04-29 Shenka Botwinick 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5507 5507 1945-04-29 Vasili Krotoff 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5508 5508 1945-04-29 Velvill Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5447 5447 1945-04-29 Andrew Grycink 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5449 5449 1945-04-29 Benjamin Gashinsky 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5450 5450 1945-04-29 Berel Jaffe 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5457 5457 1945-04-29 Dmitri Wakulchyk 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5463 5463 1945-04-29 Fage Kaplan 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5466 5466 1945-04-29 Haretina Wakulchyk 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5478 5478 1945-04-29 Madeline Strung 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5481 5481 1945-04-29 Marianna Meskauskis 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5483 5483 1945-04-29 Mary Strung 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5484 5484 1945-04-29 Milia Frankel 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5486 5486 1945-04-29 Mitchell Strung 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5496 5496 1945-04-29 Panteleimon Wakulchyk 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5501 5501 1945-04-29 Rifke Maler 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5506 5506 1945-04-29 Unknown Heirs of Fritz Strung 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5512 5512 1945-04-29 Zinovy Wakulchyk 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
13633 13633 1950-11-20 Embassy of the U.S.S.R. 1946-05-07 USSR 356 356 1946-05-07 Lynch, Mary Katherine Washington     DC  
4102 4102 1949-03-31 Publishing House of the Central Council of Trade Unions (PROFIZDAT) 1946-10-01 USSR 374 374 1946-10-01 Browder, Earl Russell Moscow        
4103 4103 1949-03-31 State Art Publishing House of the Committee on Art Affairs of the Council of Ministers of U.S.S.R. (ISKUSSTVO) 1946-10-01 USSR 374 374 1946-10-01 Browder, Earl Russell Moscow        

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