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 Registrant_Name
This data as json, CSV (advanced)
Registrant_Name >30
- Koenig, Harry D. 67
- Recht, Charles 5
- Siegel, Leah 5
- Smith, Edwin S. 5
- Lamken, Natalie 4
- Litoshko, Evgeni Vladimirovich 4
- Solov, Liuba 4
- Kreisinger, Robert 3
- Kurdyumov, Nikolai V. 3
- Lerman, Louis 3
- 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
- Silvin, Mary Jane 2
- Strelnikov, Boris G. 2
- Gallagher, Dennis F. 1
- Garber's Travel Service, Inc. 1
- Globe Travel Service 1
- Gramercy Shipping Company Corporation 1
- Granich, Grace 1
- Gromeka, Vasily Ivanovich 1
- Guevorguian, Goratsi 1
- H&H 1
- Henley, Lillian 1
- Holladay-Tyler Printing Corporation 1
- …
Foreign_Principal_Termination_Date (date) >30 ✖
- 1945-04-29 67
- 1955-05-26 5
- 1964-06-01 4
- 1973-12-31 4
- 1990-11-30 4
- 1960-03-30 3
- 1966-02-18 3
- 1953-07-26 2
- 1960-03-01 2
- 1962-07-17 2
- 1965-09-03 2
- 1966-05-16 2
- 1980-03-03 2
- 1985-04-09 2
- 1988-06-21 2
- 1991-12-31 2
- 1943-10-01 1
- 1944-06-17 1
- 1947-02-12 1
- 1947-12-31 1
- 1949-01-03 1
- 1950-11-01 1
- 1950-11-20 1
- 1951-10-01 1
- 1952-03-31 1
- 1952-06-01 1
- 1952-09-01 1
- 1952-09-30 1
- 1953-01-26 1
- 1955-09-02 1
- …
Foreign_Principal >30
- Intourist 12
- Pravda 9
- Embassy of the U.S.S.R. 7
- Soviet Embassy 5
- Intourist, Ltd. 4
- Fotokhronika Tass 3
- Izvestia 3
- Novosti Press Agency 3
- Soviet Life Magazine 3
- U.S.S.R. Information Bulletin 3
- Embassy of the Union of Soviet Socialist Republics 2
- Mezhdunarodnaya Kniga 2
- Radio Moscow 2
- Soviet Culture"" 2
- Soviet Embassy, Information Department 2
- Trud"" 2
- U.S.S.R. Illustrated Monthly 2
- Vneshposyltorg 2
- Aeroflot 1
- Alexandra Ivanovna Poliakoff 1
- All-Union Company (Vneshposyltorg) 1
- All-Union Radio Committee 1
- Amtorg Trading Corporation 1
- Andrew Grycink 1
- Archbishop Gevorg Cheorekjian, Vicar Catholicos of the American Church 1
- Artkino Pictures, Inc. 1
- Basil Katinivic 1
- Benjamin Gashinsky 1
- Berel Jaffe 1
- Chae Hene Goldenberg 1
- …
City 4
- - 196
- New York 4
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10986 | 10986 | 1988-08-31 | U.S.S.R. Trade Mission | 1988-06-17 | USSR | Gallagher, Dennis F. 4152 | 1988-06-17 | Gallagher, Dennis F. | Washington | DC | |||
14618 | 14618 | 1959-12-01 | Intourist Travel Agency | 1959-06-01 | USSR | Garber's Travel Service, Inc. 1232 | 1959-06-01 | Garber's Travel Service, Inc. | Moscow | ||||
4151 | 4151 | 1960-03-30 | Giorghi (Employee for Soviet Embassy Superior of Third Secretary Gaorikov) | 1960-03-30 | USSR | Gleason, Stephen Bernard 1345 | 1960-03-30 | Gleason, Stephen Bernard | Washington | DC | |||
4152 | 4152 | 1960-03-30 | Third Secretary Gennody B. Gaorikov | 1960-03-30 | USSR | Gleason, Stephen Bernard 1345 | 1960-03-30 | Gleason, Stephen Bernard | Washington | DC | |||
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 | ||||
7987 | 7987 | 1988-06-21 | Vneshposyltorg | 1961-09-26 | USSR | Globe Parcel Service, Inc. 1164 | 1958-08-25 | Globe Parcel Service, Inc. | Moscow | ||||
3987 | 3987 | 1960-03-23 | Intourist, Ltd. | 1948-02-16 | USSR | Globe Travel Service 512 | 1948-02-16 | Globe Travel Service | Moscow | ||||
5788 | 5788 | 1965-04-30 | Vneshposyitorg | 1964-06-25 | USSR | Gramercy Shipping Company Corporation 1765 | 1964-06-25 | Gramercy Shipping Company Corporation | 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 | ||||
3907 | 3907 | 1969-03-20 | Ekonomicheskaya Gazeta (Economic Gazette) | 1966-06-06 | USSR | Gromeka, Vasily Ivanovich 1980 | 1966-06-06 | Gromeka, Vasily Ivanovich | Moscow | ||||
14891 | 14891 | 1971-12-08 | Trud" (Newspaper)" | 1967-04-17 | USSR | Guevorguian, Goratsi 2022 | 1967-04-17 | Guevorguian, Goratsi | Moscow | ||||
8999 | 8999 | 1974-07-04 | Soviet Youth Exhibit | 1974-03-22 | USSR | H&H 2506 | 1974-03-22 | H&H | Washington | DC | |||
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 | |||
14839 | 14839 | 1985-12-06 | Soviet Embassy | 1964-12-16 | USSR | Holladay-Tyler Printing Corporation 1835 | 1964-12-16 | Holladay-Tyler Printing Corporation | Washington | DC | |||
9034 | 9034 | 1965-07-06 | Izvestia Editorial Office | 1964-11-24 | USSR | Itskov, Andrei Nikolaevich 1820 | 1964-11-24 | Itskov, Andrei Nikolaevich | Moscow | ||||
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 | |||
12315 | 12315 | 1972-10-01 | Soviet Life Magazine | 1971-09-29 | USSR | Jack J. Morris Associates, Inc. 2281 | 1971-09-29 | Jack J. Morris Associates, Inc. | 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 | |||
9299 | 9299 | 1968-07-16 | Moscow News (Newspaper) | 1965-06-26 | USSR | Jiougjda, Robertasse 1905 | 1965-06-29 | Jiougjda, Robertasse | Moscow | ||||
1124 | 1124 | 1964-01-07 | Radio Moscow | 1960-07-07 | USSR | Kalugin, Oleg Danilovich 1375 | 1960-07-07 | Kalugin, Oleg Danilovich | Moscow | ||||
6898 | 6898 | 1961-05-29 | Izvestia | 1956-11-29 | USSR | Karev, Nikolai N. 986 | 1956-11-29 | Karev, Nikolai N. | Moscow | ||||
15036 | 15036 | 1974-12-12 | U.S.S.R. | 1973-05-31 | USSR | Kassatly, Richard 2430 | 1973-05-31 | Kassatly, Richard | Washington | DC | |||
9977 | 9977 | 1979-08-01 | Soviet Life Magazine | 1979-02-28 | USSR | Ketchum Communications Holdings, Inc. 2386 | 1972-10-17 | Ketchum Communications Holdings, Inc. | DC | ||||
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. | |||||
7646 | 7646 | 1967-06-07 | Izvestia | 1961-12-07 | USSR | Kondrashov, Stanislav N. 1499 | 1961-12-07 | Kondrashov, Stanislav N. | Moscow | ||||
6706 | 6706 | 1971-05-22 | Vneshtorgreklama | 1968-12-02 | USSR | Koppe International, Ltd. 2115 | 1968-12-02 | Koppe International, Ltd. | Moscow | ||||
2636 | 2636 | 1966-02-18 | Press Department, Embassy of the U.S.S.R. | 1952-11-06 | USSR | Kreisinger, Robert 641 | 1950-09-20 | Kreisinger, Robert | Washington | DC | |||
2637 | 2637 | 1966-02-18 | U.S.S.R. Information Bulletin | 1950-09-20 | USSR | Kreisinger, Robert 641 | 1950-09-20 | Kreisinger, Robert | Washington | DC | |||
2638 | 2638 | 1966-02-18 | U.S.S.R. Magazine (Published by the Embassy of the U.S.S.R.) | 1956-12-10 | USSR | Kreisinger, Robert 641 | 1950-09-20 | Kreisinger, Robert | Washington | DC | |||
12996 | 12996 | 1966-10-25 | Selskaya Zhizn"" | 1965-02-12 | USSR | Krylov, Mikhail Victorovich 1854 | 1965-02-12 | Krylov, Mikhail Victorovich | Moscow | ||||
4150 | 4150 | 1960-03-30 | Evgeni A. Zaostrovtsev | 1960-03-30 | USSR | Kulberg, Raoul F. 1346 | 1960-03-30 | Kulberg, Raoul F. | Washington | DC | |||
8025 | 8025 | 1970-06-23 | Pravda | 1965-12-23 | USSR | Kurdyumov, Nikolai V. 1948 | 1965-12-23 | 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 | ||||
9324 | 9324 | 1962-07-17 | Trud"" | 1958-02-07 | USSR | Kurdyumov, Nikolai V. 1115 | 1958-02-07 | Kurdyumov, Nikolai V. | Moscow |
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]) );