FARA_All_ForeignPrincipals
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_Termination_Date
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name >30
- Koenig, Harry D. 67
- Drucker, David 21
- Amtorg Trading Corporation 12
- Bell, Linda Jane 7
- Recht, Charles 5
- Siegel, Leah 5
- Smith, Edwin S. 5
- Black, Helen 4
- Lamken, Natalie 4
- Litoshko, Evgeni Vladimirovich 4
- Solov, Liuba 4
- Browder, Earl Russell 3
- Burson-Marsteller 3
- Kreisinger, Robert 3
- Kurdyumov, Nikolai V. 3
- Lerman, Louis 3
- Beliaev, Anatoli A. 2
- Bienstock, Natalie Anna 2
- Brockman Jr., Earle Wingo 2
- Compass Publications, Inc. 2
- Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 2
- Crosscurrents Press, Inc. 2
- Gleason, Stephen Bernard 2
- Globe Parcel Service, Inc. 2
- Kuznetsov, Georgi A. 2
- Laourintchioukas, Albertas 2
- Modern Education Services, Inc. 2
- NTS-Alliance of Russian Solidarists 2
- North American Precis Syndicate 2
- Package Express & Travel Agency, Inc. 2
- …
Registrant_Date >30 ✖
- 1942-10-29 67
- 1942-08-26 21
- 1949-11-07 12
- 1942-08-20 5
- 1952-05-05 5
- 1974-01-21 5
- 1942-07-06 4
- 1964-06-29 4
- 1964-10-19 4
- 1946-10-01 3
- 1950-09-20 3
- 1952-02-20 3
- 1956-08-28 3
- 1960-03-30 3
- 1973-10-23 3
- 1949-03-07 2
- 1950-01-26 2
- 1950-05-01 2
- 1958-02-07 2
- 1958-02-24 2
- 1958-04-21 2
- 1958-08-25 2
- 1959-05-14 2
- 1959-07-10 2
- 1959-09-25 2
- 1959-12-09 2
- 1963-03-27 2
- 1966-06-08 2
- 1968-12-02 2
- 1969-06-11 2
- …
Foreign_Principal >30
- Intourist 21
- Embassy of the U.S.S.R. 10
- Pravda 10
- Novosti Press Agency 6
- Intourist, Ltd. 5
- Mezhdunarodnaya Kniga 5
- Soviet Embassy 5
- U.S.S.R. Information Bulletin 5
- Embassy of the Union of Soviet Socialist Republics 4
- Soviet Life 4
- Soviet Life Magazine 4
- Fotokhronika Tass 3
- Izvestia 3
- Radio Moscow 3
- Vneshposyltorg 3
- Amtorg Trading Corporation 2
- Artkino Pictures, Inc. 2
- Mezhdunarodnaja Kniga 2
- Newspaper Izvestia"" 2
- Soviet Culture"" 2
- Soviet Embassy, Information Department 2
- Trud"" 2
- U.S.S.R. Chamber of Commerce & Industry 2
- U.S.S.R. Illustrated Monthly 2
- Vneshtorgreklama 2
- A.S. Merilaid & Company 1
- Aeroflot 1
- Agricultural Cooperative Society LIETUKIS 1
- Alexandra Ivanovna Poliakoff 1
- All Union Chartering Company (Sovfracht) 1
- …
City 4
- - 296
- New York 4
- Moscow 1
- Washington 1
Country/Location_Represented 1
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6518 | 6518 | 1943-05-14 | Johannes Kaiv, Consul General of Estonia | 1943-05-14 | USSR | Beck, P.A. 191 | 1943-05-14 | Beck, P.A. | New York | NY | |||
12290 | 12290 | 1943-10-01 | Archbishop Gevorg Cheorekjian, Vicar Catholicos of the American Church | 1943-04-08 | USSR | Prelacy of the Armenian Apostolic Church in America, Inc. 188 | 1943-04-08 | Prelacy of the Armenian Apostolic Church in America, Inc. | Armenia | ||||
7885 | 7885 | 1944-06-17 | Universal Press Service (Service Universal de Presse) | 1942-10-01 | USSR | Granich, Grace 133 | 1942-10-01 | Granich, Grace | Moscow | ||||
5669 | 5669 | 1945-04-29 | Alexandra Ivanovna Poliakoff | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5670 | 5670 | 1945-04-29 | Andrew Grycink | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5671 | 5671 | 1945-04-29 | Basil Katinivic | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5672 | 5672 | 1945-04-29 | Benjamin Gashinsky | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5673 | 5673 | 1945-04-29 | Berel Jaffe | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5674 | 5674 | 1945-04-29 | Chae Hene Goldenberg | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5675 | 5675 | 1945-04-29 | Chai Drezar Karvorsky | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5676 | 5676 | 1945-04-29 | Chaika Botwinick | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5677 | 5677 | 1945-04-29 | Children of Schmeul Seidenknop | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5678 | 5678 | 1945-04-29 | David Greenberg | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5679 | 5679 | 1945-04-29 | Deborah Katz | 1943-11-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5680 | 5680 | 1945-04-29 | Dmitri Wakulchyk | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5681 | 5681 | 1945-04-29 | Dmitry Wasilievich Poliakoff | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5682 | 5682 | 1945-04-29 | Dorothy Herzog | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5683 | 5683 | 1945-04-29 | Emily Borgardt | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5684 | 5684 | 1945-04-29 | Esta Risha Seidenknop | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5685 | 5685 | 1945-04-29 | Etta (Yanta) Milner | 1943-11-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5686 | 5686 | 1945-04-29 | Fage Kaplan | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5687 | 5687 | 1945-04-29 | Gittel Ubogy | 1943-11-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5688 | 5688 | 1945-04-29 | Gregor Kashisky | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5689 | 5689 | 1945-04-29 | Haretina Wakulchyk | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5690 | 5690 | 1945-04-29 | Herschel Botwinick | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5691 | 5691 | 1945-04-29 | Itzick Seidenknop | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5692 | 5692 | 1945-04-29 | Ivan Wasilievich Poliakoff | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5693 | 5693 | 1945-04-29 | Jacob Greenberg | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5694 | 5694 | 1945-04-29 | Laber Botwinick | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5695 | 5695 | 1945-04-29 | Lazar Botwinick | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5696 | 5696 | 1945-04-29 | Leib Einbender | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5697 | 5697 | 1945-04-29 | Leve Seidenknop | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5698 | 5698 | 1945-04-29 | Lily Schwarzwald | 1944-05-01 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5699 | 5699 | 1945-04-29 | Luba Katz | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5700 | 5700 | 1945-04-29 | Machlea Kesselman | 1943-11-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5701 | 5701 | 1945-04-29 | Madeline Strung | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5702 | 5702 | 1945-04-29 | Malasha Rewchuk | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5703 | 5703 | 1945-04-29 | Maria Wasilievna Poliakoff | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5704 | 5704 | 1945-04-29 | Marianna Meskauskis | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5705 | 5705 | 1945-04-29 | Mary Loz | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5706 | 5706 | 1945-04-29 | Mary Strung | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5707 | 5707 | 1945-04-29 | Milia Frankel | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5708 | 5708 | 1945-04-29 | Minna Gruenfeld | 1943-11-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5709 | 5709 | 1945-04-29 | Mitchell Strung | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5710 | 5710 | 1945-04-29 | Moisha Seidenknop | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5711 | 5711 | 1945-04-29 | Nenu Dzanguberkova | 1944-05-01 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5712 | 5712 | 1945-04-29 | Next of Kin of Constantine Tarbeyff | 1943-11-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5713 | 5713 | 1945-04-29 | Next of Kin of Harry Pavloos (Harry Thomas Pavlof) | 1944-05-01 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5714 | 5714 | 1945-04-29 | Next of Kin of Solomon Wapner (Wapno) | 1944-05-01 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5715 | 5715 | 1945-04-29 | Next of Kin of the Estate of Demetri Teplikow (a/k/a Jim Circulowski) | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5716 | 5716 | 1945-04-29 | Next of Kin of the Estate of Frank Norwillas (Norwellas) | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5717 | 5717 | 1945-04-29 | Nick Katinivic | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5718 | 5718 | 1945-04-29 | Olga Kubalova | 1944-05-01 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5719 | 5719 | 1945-04-29 | Panteleimon Wakulchyk | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5720 | 5720 | 1945-04-29 | Pavel Wasilievich Poliakoff | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5721 | 5721 | 1945-04-29 | Pavlina E. Wolochonovich | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5722 | 5722 | 1945-04-29 | Peter Wasilievich Poliakoff | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5723 | 5723 | 1945-04-29 | Phyllis Katinivic | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5724 | 5724 | 1945-04-29 | Rifke Maler | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5725 | 5725 | 1945-04-29 | Safetka Tseboeva | 1944-05-01 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5726 | 5726 | 1945-04-29 | Shayer Seidenknop | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5727 | 5727 | 1945-04-29 | Shenka Botwinick | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5728 | 5728 | 1945-04-29 | Sonya Gloeva | 1944-05-01 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5729 | 5729 | 1945-04-29 | Unknown Heirs of Fritz Strung | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5730 | 5730 | 1945-04-29 | Vasili Krotoff | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5731 | 5731 | 1945-04-29 | Velvill Seidenknop | 1944-11-03 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5732 | 5732 | 1945-04-29 | Walter Katinivic | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5733 | 5733 | 1945-04-29 | Wladimir Terentiev Maximovich | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5734 | 5734 | 1945-04-29 | Yehuda Greenberg | 1942-10-29 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
5735 | 5735 | 1945-04-29 | Zinovy Wakulchyk | 1945-05-04 | USSR | Koenig, Harry D. 151 | 1942-10-29 | Koenig, Harry D. | |||||
2391 | 2391 | 1947-02-12 | Republic of Estonia | 1942-08-12 | USSR | Jaakson, Ernst Rudolf 91 | 1942-08-12 | Jaakson, Ernst Rudolf | New York | NY | |||
2793 | 2793 | 1947-02-26 | Kasmu Laeva Omanikud (Kasmu Shipowners' Association) | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Tallnin, Estonia | ||||
2794 | 2794 | 1947-02-26 | A.S. Merilaid & Company | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Tallnin, Estonia | ||||
2795 | 2795 | 1947-02-26 | Agricultural Cooperative Society LIETUKIS | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Kaunas, Lithuania | ||||
2796 | 2796 | 1947-02-26 | All Union Chartering Company (Sovfracht) | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Moscow | ||||
2797 | 2797 | 1947-02-26 | Amtorg Trading Corporation | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | New York | NY | |||
2798 | 2798 | 1947-02-26 | Apvienota Kugniecibas A.K.S. Sab. | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Riga, Latvia | ||||
2799 | 2799 | 1947-02-26 | Artkino Pictures, Inc. | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | New York | NY | |||
2800 | 2800 | 1947-02-26 | Baltic State S.S. Company | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Leningrad | ||||
2801 | 2801 | 1947-02-26 | Black Sea & Baltic General Insurance Company | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | London, England | ||||
2802 | 2802 | 1947-02-26 | Black Sea State S.S. Company | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Odessa | ||||
2803 | 2803 | 1947-02-26 | Estonia State Steamship Line | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Tallnin, Estonia | ||||
2804 | 2804 | 1947-02-26 | F. Grauds | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Riga, Latvia | ||||
2805 | 2805 | 1947-02-26 | Flor N. Koritz | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Washington | DC | |||
2806 | 2806 | 1947-02-26 | Juri Silberberg | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Tallnin, Estonia | ||||
2807 | 2807 | 1947-02-26 | Karl Mitt & Company | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Tallnin, Estonia | ||||
2808 | 2808 | 1947-02-26 | Latvia State Steamship Line | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Riga, Latvia/Moscow | ||||
2809 | 2809 | 1947-02-26 | Latvyas Kugniecibas Sabiedriba (Latvian Shipping Company) | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Riga, Latvia | ||||
2810 | 2810 | 1947-02-26 | Lietuvas Baltyos Lloydos, Lithuanian Baltic Lloyd | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Kaunas, Lithuania | ||||
2811 | 2811 | 1947-02-26 | Oskar Tiedemann | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Tallnin, Estonia | ||||
2812 | 2812 | 1947-02-26 | Tallinna Laevahisis, A.S. (Tallnin Shipping Company, Ltd.) | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Tallnin, Estonia | ||||
2813 | 2813 | 1947-02-26 | Vassily Ratoushny | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | Vladivostok | ||||
15522 | 15522 | 1947-12-31 | Intourist, Ltd. | 1947-01-10 | USSR | Pennsylvania Company for Banking & Trusts 423 | 1947-01-10 | Pennsylvania Company for Banking & Trusts | Moscow | ||||
13890 | 13890 | 1948-11-12 | Russian Anti-Communist Nacionalno-Trudovoy Soyuz" (NTS)" | 1948-03-24 | USSR | Baydalakoff, Victor 499 | 1947-11-12 | Baydalakoff, Victor | |||||
1057 | 1057 | 1949-01-03 | His Imperial Highness The Grand Duke Wladimir of Russia | 1942-07-07 | USSR | Pouschine, Ivan 11 | 1942-07-07 | Pouschine, Ivan | Madrid | ||||
4284 | 4284 | 1949-03-31 | Publishing House of the Central Council of Trade Unions (PROFIZDAT) | 1946-10-01 | USSR | Browder, Earl Russell 374 | 1946-10-01 | Browder, Earl Russell | Moscow | ||||
4285 | 4285 | 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 | Browder, Earl Russell 374 | 1946-10-01 | Browder, Earl Russell | Moscow | ||||
4286 | 4286 | 1949-03-31 | U.S. Publishing House of the Council of Ministers of the U.S.S.R. (OGIZ) | 1946-10-01 | USSR | Browder, Earl Russell 374 | 1946-10-01 | Browder, Earl Russell | Moscow | ||||
13516 | 13516 | 1950-11-01 | Pravda | 1950-05-01 | USSR | Rassadin, Grigorii 623 | 1950-05-01 | Rassadin, Grigorii | Moscow | ||||
14086 | 14086 | 1950-11-20 | Embassy of the U.S.S.R. | 1946-05-07 | USSR | Lynch, Mary Katherine 356 | 1946-05-07 | Lynch, Mary Katherine | Washington | DC |
Advanced export
JSON shape: default, array, newline-delimited
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]) );