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 Address_1
This data as json, CSV (advanced)
Suggested facets: Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_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 (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3214 | 3214 | 1960-03-01 | International Book | 1959-08-11 | USSR | Rosell, Charles William 1138 | 1958-04-28 | Rosell, Charles William | |||||
3392 | 3392 | 1980-03-03 | Soviet Exhibition of Science, Technology & Culture (Alexander Shelnov, Deputy Director) | 1959-10-20 | USSR | Lerman, Louis 973 | 1956-08-28 | Lerman, Louis | NY | ||||
3494 | 3494 | 1960-03-07 | Intourist | 1959-11-16 | USSR | Poly Travel, Inc. 1297 | 1959-11-16 | Poly Travel, Inc. | |||||
4289 | 4289 | 1952-03-31 | USSR Information Bulletin of the Embassy of the Union of Soviet Socialist Republics | 1951-01-16 | USSR | Resnikoff, Reuben 656 | 1951-01-16 | Resnikoff, Reuben | |||||
5117 | 5117 | 1985-04-09 | Vneshposyltorg | 1963-05-13 | USSR | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | |||||
5208 | 5208 | 1986-04-12 | Embassy of the Union of Soviet Socialist Republics | 1985-04-25 | USSR | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | DC | ||||
5474 | 5474 | 1965-04-22 | Honorable Jonas Budrys - Consul General of Lithuania at New York | 1964-08-24 | USSR | Alexis, Frank T. 1781 | 1964-08-24 | Alexis, Frank T. | |||||
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. | |||||
6270 | 6270 | 1990-05-02 | V/O Metallurgimport | 1970-10-27 | USSR | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | |||||
6848 | 6848 | 1955-05-26 | Iniurcollegia | 1953-06-15 | USSR | Recht, Charles 101 | 1942-08-20 | Recht, Charles | |||||
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 | |||||
7540 | 7540 | 1987-06-03 | Intourist | 1984-08-16 | USSR | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
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 | |||||
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 | ||||
11324 | 11324 | 1983-09-02 | Intourist | 1980-01-29 | USSR | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
11347 | 11347 | 1965-09-03 | Pravda | 1965-05-10 | USSR | Strelnikov, Boris G. 1890 | 1965-05-10 | Strelnikov, Boris G. | |||||
11348 | 11348 | 1965-09-03 | Pravda | 1959-12-09 | USSR | Strelnikov, Boris G. 1299 | 1959-11-19 | Strelnikov, Boris G. | |||||
11500 | 11500 | 1951-09-11 | Mezhdunarodnaya Kniga | 1942-07-06 | USSR | Black, Helen 6 | 1942-07-06 | Black, Helen | |||||
11505 | 11505 | 1951-09-11 | TASS (Telegraph Agency of the U.S.S.R.) | 1942-07-06 | USSR | Black, Helen 6 | 1942-07-06 | Black, Helen | |||||
11949 | 11949 | 1979-09-30 | V/O Sovinflot | 1971-11-23 | USSR | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | |||||
13266 | 13266 | 1989-10-31 | V/O Sojuzgazexport | 1983-04-27 | USSR | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | |||||
13704 | 13704 | 1980-11-04 | Soviet Life | 1980-03-31 | USSR | Bell, Linda Jane 3096 | 1980-03-31 | Bell, Linda Jane | |||||
13890 | 13890 | 1948-11-12 | Russian Anti-Communist Nacionalno-Trudovoy Soyuz" (NTS)" | 1948-03-24 | USSR | Baydalakoff, Victor 499 | 1947-11-12 | Baydalakoff, Victor | |||||
14023 | 14023 | 1966-11-17 | V/O Prodintorg | 1964-05-13 | USSR | Nachman & Feldstein 1730 | 1964-05-13 | Nachman & Feldstein | |||||
14861 | 14861 | 1959-12-07 | Intourist | 1959-12-07 | USSR | Simmons Gateway Tours 1305 | 1959-12-07 | Simmons Gateway Tours | |||||
16083 | 16083 | 1988-12-31 | U.S.S.R. Chamber of Commerce & Industry | 1989-01-03 | USSR | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | |||||
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 | |
11760 | 11760 | 1960-09-22 | Intourist | 1958-04-17 | USSR | Whitbey-Rehbock Advertising, Inc. 1133 | 1958-04-21 | Whitbey-Rehbock Advertising, Inc. | 49 West 37 Street | New York | NY | ||
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 | |
12003 | 12003 | 1989-09-30 | Aeroflot | 1978-10-22 | USSR | Wolf Shevack, Inc. 1436 | 1961-03-28 | Wolf Shevack, Inc. | 545 Fifth Avenue | NY | |||
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 | |
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 | |
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 | ||||
14090 | 14090 | 1973-11-20 | Nacionalno Trudovoy Soyuz (NTS) | 1949-03-07 | USSR | NTS-Alliance of Russian Solidarists 565 | 1949-03-07 | NTS-Alliance of Russian Solidarists | Brooklyn | NY |
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]) );