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 rowid descending
This data as json, CSV (advanced)
Registrant_Name >30
- Koenig, Harry D. 67
- Drucker, David 21
- Amtorg Trading Corporation 5
- Bell, Linda Jane 5
- Recht, Charles 5
- Smith, Edwin S. 5
- Browder, Earl Russell 3
- Kreisinger, Robert 3
- Kurdyumov, Nikolai V. 3
- Lerman, Louis 3
- Beliaev, Anatoli A. 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
- North American Precis Syndicate 2
- Package Express & Travel Agency, Inc. 2
- Alexis, Frank T. 1
- Allegheny Travel Service 1
- Allied Travel, Inc. 1
- American Express Company 1
- American Travel Abroad, Inc. 1
- Arau & Goldberg 1
- Archbishop Uladyslau (Ryzy-Ryski) 1
- Ask Mr. Foster Travel Service, Inc. 1
- Baff, William E. 1
- Barsukov, Jury V. 1
- Beaumet, Charles Theodore 1
- Beck, P.A. 1
- …
Foreign_Principal_Registration_Date (date) >30 ✖
- 1942-10-29 24
- 1942-08-26 21
- 1944-11-03 15
- 1945-05-04 15
- 1944-05-01 7
- 1943-11-04 6
- 1953-06-15 5
- 1946-10-01 3
- 1960-03-30 3
- 1949-11-07 2
- 1958-02-07 2
- 1959-09-25 2
- 1963-03-27 2
- 1968-12-02 2
- 1981-03-27 2
- 1942-07-07 1
- 1942-08-12 1
- 1942-10-01 1
- 1943-05-14 1
- 1948-02-16 1
- 1949-11-10 1
- 1950-01-11 1
- 1950-09-20 1
- 1950-12-06 1
- 1951-01-16 1
- 1952-05-05 1
- 1952-11-06 1
- 1952-11-17 1
- 1953-01-26 1
- 1955-12-27 1
- …
Foreign_Principal >30
- Intourist 13
- Embassy of the U.S.S.R. 4
- Embassy of the Union of Soviet Socialist Republics 3
- Intourist, Ltd. 3
- Izvestia 3
- Mezhdunarodnaya Kniga 3
- Pravda 3
- Vneshposyltorg 3
- Amtorg Trading Corporation 2
- Artkino Pictures, Inc. 2
- Mezhdunarodnaja Kniga 2
- Novosti Press Agency 2
- Soviet Culture"" 2
- Soviet Life Magazine 2
- Trud"" 2
- U.S.S.R. Illustrated Monthly 2
- U.S.S.R. Information Bulletin 2
- A.S. Merilaid & Company 1
- Agricultural Cooperative Society LIETUKIS 1
- Alexandra Ivanovna Poliakoff 1
- All Union Chartering Company (Sovfracht) 1
- Andrew Grycink 1
- Apvienota Kugniecibas A.K.S. Sab. 1
- Baltic State S.S. Company 1
- Basil Katinivic 1
- Benjamin Gashinsky 1
- Berel Jaffe 1
- Black Sea & Baltic General Insurance Company 1
- Black Sea State S.S. Company 1
- Byelorussian Democratic Republic, State Council in Dispersion, Byelorussian Patriarchate or Orth. Cath. Church 1
- …
City 4
- - 197
- New York 3
- Moscow 1
- Washington 1
Country/Location_Represented 1
- USSR · 202 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9391 | 9391 | 1976-07-21 | Soviet Life Publications, Embassy of the U.S.S.R. | 1976-06-18 | USSR | Boland, Kerby Ann 2699 | 1976-06-18 | Boland, Kerby Ann | Washington | DC | |||
9329 | 9329 | 1987-07-17 | General Department of International Air Services (Aeroflot) | 1986-04-23 | USSR | McCamish, Ingram, Martin & Brown, a Professional Corporation 3817 | 1986-04-23 | McCamish, Ingram, Martin & Brown, a Professional Corporation | Moscow | ||||
9324 | 9324 | 1962-07-17 | Trud"" | 1958-02-07 | USSR | Kurdyumov, Nikolai V. 1115 | 1958-02-07 | Kurdyumov, Nikolai V. | Moscow | ||||
9323 | 9323 | 1962-07-17 | Soviet Culture"" | 1958-02-07 | USSR | Kurdyumov, Nikolai V. 1115 | 1958-02-07 | Kurdyumov, Nikolai V. | Moscow | ||||
9299 | 9299 | 1968-07-16 | Moscow News (Newspaper) | 1965-06-26 | USSR | Jiougjda, Robertasse 1905 | 1965-06-29 | Jiougjda, Robertasse | Moscow | ||||
9170 | 9170 | 1951-07-11 | Intourist | 1950-01-11 | USSR | Family Export & Shipping Company, Inc. 605 | 1950-01-11 | Family Export & Shipping Company, Inc. | Moscow | ||||
9132 | 9132 | 1982-07-09 | Intourist Travel Information Office | 1979-06-27 | USSR | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
9034 | 9034 | 1965-07-06 | Izvestia Editorial Office | 1964-11-24 | USSR | Itskov, Andrei Nikolaevich 1820 | 1964-11-24 | Itskov, Andrei Nikolaevich | Moscow | ||||
8999 | 8999 | 1974-07-04 | Soviet Youth Exhibit | 1974-03-22 | USSR | H&H 2506 | 1974-03-22 | H&H | Washington | DC | |||
8833 | 8833 | 1969-07-01 | Economic Gazette, U.S.S.R. | 1969-06-11 | USSR | Beliaev, Anatoli A. 2142 | 1969-06-11 | Beliaev, Anatoli A. | Moscow | ||||
8345 | 8345 | 1982-06-30 | General Department of International Air Services (Aeroflot Soviet Airlines) | 1980-03-10 | USSR | Shaw, Pittman, Potts & Trowbridge 2580 | 1975-02-21 | Shaw, Pittman, Potts & Trowbridge | |||||
8123 | 8123 | 1958-06-27 | Pravda | 1955-12-27 | USSR | Orekhov, Fedor Terentevich 927 | 1955-12-27 | Orekhov, Fedor Terentevich | Moscow | ||||
8106 | 8106 | 1974-06-26 | Intourist | 1974-06-26 | USSR | Davis Public Relations, Inc. 2462 | 1973-10-01 | Davis Public Relations, Inc. | New York | NY | |||
8025 | 8025 | 1970-06-23 | Pravda | 1965-12-23 | USSR | Kurdyumov, Nikolai V. 1948 | 1965-12-23 | Kurdyumov, Nikolai V. | Moscow | ||||
7987 | 7987 | 1988-06-21 | Vneshposyltorg | 1961-09-26 | USSR | Globe Parcel Service, Inc. 1164 | 1958-08-25 | Globe Parcel Service, Inc. | Moscow | ||||
7986 | 7986 | 1988-06-21 | U.S.S.R. Company for Foreign Travel t/a Intourist | 1958-08-25 | USSR | Globe Parcel Service, Inc. 1164 | 1958-08-25 | Globe Parcel Service, Inc. | Moscow | ||||
7985 | 7985 | 1988-06-21 | Soviet Life Magazine | 1981-03-27 | USSR | Bell, Linda Jane 3219 | 1981-03-27 | Bell, Linda Jane | Washington | DC | |||
7981 | 7981 | 1988-06-21 | Embassy of the U.S.S.R. | 1981-03-27 | USSR | Bell, Linda Jane 3219 | 1981-03-27 | Bell, Linda Jane | Washington | DC | |||
7973 | 7973 | 1965-06-21 | Novosti Press Agency | 1963-06-19 | USSR | Crosscurrents Press, Inc. 1308 | 1959-12-09 | Crosscurrents Press, Inc. | Moscow | ||||
7972 | 7972 | 1965-06-21 | Mezhdunarodnaya Kniga | 1959-12-09 | USSR | Crosscurrents Press, Inc. 1308 | 1959-12-09 | Crosscurrents Press, Inc. | Moscow | ||||
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 | ||||
7794 | 7794 | 1976-06-14 | Embassy of Soviet Union Information Department | 1975-06-09 | USSR | Berman, Karen 2588 | 1975-06-09 | Berman, Karen | Washington | DC | |||
7646 | 7646 | 1967-06-07 | Izvestia | 1961-12-07 | USSR | Kondrashov, Stanislav N. 1499 | 1961-12-07 | Kondrashov, Stanislav N. | Moscow | ||||
7633 | 7633 | 1974-06-06 | V/O Sojuznefteexport | 1949-11-07 | USSR | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | Moscow | ||||
7608 | 7608 | 1972-06-05 | Embassy of the U.S.S.R. | 1969-06-16 | USSR | Bell, Linda Jane 2143 | 1969-06-16 | Bell, Linda Jane | Washington | DC | |||
7540 | 7540 | 1987-06-03 | Intourist | 1984-08-16 | USSR | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
7343 | 7343 | 1964-06-01 | U.S.S.R. Illustrated Monthly | 1957-01-29 | USSR | Smith, Edwin S. 723 | 1952-05-05 | Smith, Edwin S. | Washington | DC | |||
7341 | 7341 | 1964-06-01 | Novosti Press Agency | 1962-05-11 | USSR | Smith, Edwin S. 723 | 1952-05-05 | Smith, Edwin S. | Moscow | ||||
7340 | 7340 | 1964-06-01 | Mezhdunarodjna Kniga | 1952-05-05 | USSR | Smith, Edwin S. 723 | 1952-05-05 | Smith, Edwin S. | Moscow | ||||
7335 | 7335 | 1964-06-01 | Fotokhronika Tass | 1958-03-10 | USSR | Smith, Edwin S. 723 | 1952-05-05 | Smith, Edwin S. | Moscow | ||||
7316 | 7316 | 1952-06-01 | U.S.S.R. Information Bulletin | 1952-11-17 | USSR | Smith, Edwin S. 723 | 1952-05-05 | Smith, Edwin S. | Washington | DC | |||
7052 | 7052 | 1981-05-31 | Soviet Life Magazine | 1980-08-04 | USSR | Jack Shelton, Inc. 3129 | 1980-08-04 | Jack Shelton, Inc. | Washington | DC | |||
6932 | 6932 | 1979-05-30 | Soviet Life (Embassy of the U.S.S.R.) | 1979-05-21 | USSR | Bell, Linda Jane 3024 | 1979-05-21 | Bell, Linda Jane | |||||
6898 | 6898 | 1961-05-29 | Izvestia | 1956-11-29 | USSR | Karev, Nikolai N. 986 | 1956-11-29 | Karev, Nikolai N. | Moscow | ||||
6851 | 6851 | 1955-05-26 | Soviet Delegation to the United Nations | 1953-06-15 | USSR | Recht, Charles 101 | 1942-08-20 | Recht, Charles | 680 Park Avenue | New York | NY | 10012 | |
6848 | 6848 | 1955-05-26 | Iniurcollegia | 1953-06-15 | USSR | Recht, Charles 101 | 1942-08-20 | Recht, Charles | |||||
6847 | 6847 | 1955-05-26 | Embassy of the Union of Soviet Socialist Republics | 1953-06-15 | USSR | Recht, Charles 101 | 1942-08-20 | Recht, Charles | 1125 16th Street, NW | Washington | DC | 20005 | |
6843 | 6843 | 1955-05-26 | Artkino Pictures, Inc. | 1953-06-15 | USSR | Recht, Charles 101 | 1942-08-20 | Recht, Charles | 723 Seventh Avenue | New York | NY | 10012 | |
6841 | 6841 | 1955-05-26 | Amtorg Trading Corporation | 1953-06-15 | USSR | Recht, Charles 101 | 1942-08-20 | Recht, Charles | 49 West 37th Street | New York | NY | 10012 | |
6740 | 6740 | 1984-05-23 | Soviet Life | 1981-10-08 | USSR | Arau & Goldberg 3285 | 1981-10-08 | Arau & Goldberg | Washington | DC | |||
6706 | 6706 | 1971-05-22 | Vneshtorgreklama | 1968-12-02 | USSR | Koppe International, Ltd. 2115 | 1968-12-02 | Koppe International, Ltd. | Moscow | ||||
6684 | 6684 | 1963-05-21 | Selskaya Zhizn | 1960-05-04 | USSR | Laourintchioukas, Albertas 1357 | 1960-05-04 | Laourintchioukas, Albertas | Moscow | ||||
6602 | 6602 | 1966-05-16 | Trud"" | 1963-03-27 | USSR | Kuznetsov, Georgi A. 1611 | 1963-03-27 | Kuznetsov, Georgi A. | Moscow | ||||
6601 | 6601 | 1966-05-16 | Soviet Culture"" | 1963-03-27 | USSR | Kuznetsov, Georgi A. 1611 | 1963-03-27 | Kuznetsov, Georgi A. | Moscow | ||||
6567 | 6567 | 1991-05-15 | Embassy of the U.S.S.R. | 1949-11-10 | USSR | Henley, Lillian 597 | 1949-11-10 | Henley, Lillian | Washington | DC | |||
6544 | 6544 | 1965-05-15 | Embassy of the Union of Soviet Socialist Republics in the U.S. | 1957-11-15 | USSR | Select Magazines, Inc. 1083 | 1957-11-15 | Select Magazines, Inc. | Washington | DC | |||
6524 | 6524 | 1959-05-14 | Pravda | 1959-05-14 | USSR | Litoshko, Evgeni Vladimirovich 1227 | 1959-05-14 | Litoshko, Evgeni Vladimirovich | Moscow | ||||
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 | |||
6431 | 6431 | 1974-05-10 | Soviet Embassy, Information Department | 1973-10-27 | USSR | O'Leary, Anne 2475 | 1973-10-27 | O'Leary, Anne | Washington | DC | |||
6376 | 6376 | 1970-05-07 | Government of U.S.S.R. | 1968-11-27 | USSR | Sherwood Ross 2113 | 1968-11-27 | Sherwood Ross | Soviet Embassy 1708 - 18 Street N.W. | DC | |||
6350 | 6350 | 1960-05-06 | Intourist | 1958-04-11 | USSR | American Travel Abroad, Inc. 1130 | 1958-04-11 | American Travel Abroad, Inc. | Moscow | ||||
6271 | 6271 | 1990-05-02 | V/O Sovfracht | 1949-11-07 | USSR | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | Moscow | ||||
6270 | 6270 | 1990-05-02 | V/O Metallurgimport | 1970-10-27 | USSR | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | |||||
6269 | 6269 | 1990-05-02 | V/O Exportles | 1950-12-06 | USSR | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | Moscow | ||||
6268 | 6268 | 1990-05-02 | V/O Avtoexport | 1959-12-21 | USSR | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | Moxcow | ||||
6139 | 6139 | 1968-05-01 | Mezhdunarodnaya Kniga | 1961-06-19 | USSR | Crossworld Books & Periodicals, Inc. 1457 | 1961-06-19 | Crossworld Books & Periodicals, Inc. | Moscow | ||||
6133 | 6133 | 1959-05-01 | Mr. Vasilev | 1959-05-01 | USSR | Baff, William E. 1223 | 1959-05-01 | Baff, William E. | Washington | DC | |||
5788 | 5788 | 1965-04-30 | Vneshposyitorg | 1964-06-25 | USSR | Gramercy Shipping Company Corporation 1765 | 1964-06-25 | Gramercy Shipping Company Corporation | Moscow | ||||
5735 | 5735 | 1945-04-29 | Zinovy Wakulchyk | 1945-05-04 | 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. | |||||
5733 | 5733 | 1945-04-29 | Wladimir Terentiev Maximovich | 1942-10-29 | 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. | |||||
5731 | 5731 | 1945-04-29 | Velvill Seidenknop | 1944-11-03 | 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. | |||||
5729 | 5729 | 1945-04-29 | Unknown Heirs of Fritz Strung | 1945-05-04 | 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. | |||||
5727 | 5727 | 1945-04-29 | Shenka Botwinick | 1944-11-03 | 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. | |||||
5725 | 5725 | 1945-04-29 | Safetka Tseboeva | 1944-05-01 | 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. | |||||
5723 | 5723 | 1945-04-29 | Phyllis Katinivic | 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. | |||||
5721 | 5721 | 1945-04-29 | Pavlina E. Wolochonovich | 1942-10-29 | 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. | |||||
5719 | 5719 | 1945-04-29 | Panteleimon Wakulchyk | 1945-05-04 | 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. | |||||
5717 | 5717 | 1945-04-29 | Nick Katinivic | 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. | |||||
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. | |||||
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. | |||||
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. | |||||
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. | |||||
5711 | 5711 | 1945-04-29 | Nenu Dzanguberkova | 1944-05-01 | 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. | |||||
5709 | 5709 | 1945-04-29 | Mitchell Strung | 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. | |||||
5707 | 5707 | 1945-04-29 | Milia Frankel | 1945-05-04 | 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. | |||||
5705 | 5705 | 1945-04-29 | Mary Loz | 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. | |||||
5703 | 5703 | 1945-04-29 | Maria Wasilievna Poliakoff | 1942-10-29 | 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. | |||||
5701 | 5701 | 1945-04-29 | Madeline Strung | 1945-05-04 | 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. | |||||
5699 | 5699 | 1945-04-29 | Luba Katz | 1942-10-29 | 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. | |||||
5697 | 5697 | 1945-04-29 | Leve Seidenknop | 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. | |||||
5695 | 5695 | 1945-04-29 | Lazar Botwinick | 1944-11-03 | 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. |
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]) );