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

39 rows where Foreign_Principal_Termination_Date = "1993-03-30" and Registration_Number = 596

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • - 39

Registrant_Name 1

Country/Location_Represented 1

City 1

  • - 39
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
4182 4182 1993-03-30 Baltic Sea State Steamship Line 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Leningrad        
4183 4183 1993-03-30 Bank for Foreign Trade of the U.S.S.R. 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4184 4184 1993-03-30 Black Sea State Steamship Line 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Odessa        
4186 4186 1993-03-30 Far Eastern State Steamship Line 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Vladivostok        
4187 4187 1993-03-30 Gorkovskoye Proizvodstvennoye Objedinenie Normal"" 1990-10-11 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Gorki        
4188 4188 1993-03-30 Intourist 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4189 4189 1993-03-30 Inventive Machine Laboratory 1991-11-15 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
4190 4190 1993-03-30 Kwartzsamotsvety"" 1990-03-29 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4191 4191 1993-03-30 Ministry of Foreign Trade of the U.S.S.R. 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4192 4192 1993-03-30 Ministry of Maritime Fleet of the U.S.S.R. 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4193 4193 1993-03-30 Northern State Steamship Line 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Archangel        
4194 4194 1993-03-30 U.S.S.R. Chamber of Commerce 1966-09-02 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4195 4195 1993-03-30 U.S.S.R. Pavilion of Goods 1966-09-02 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4196 4196 1993-03-30 V/O Aviaexport 1967-05-02 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4197 4197 1993-03-30 V/O Centerquartzsamotsvety 1988-05-06 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4198 4198 1993-03-30 V/O Chimmashexport 1988-07-25 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4199 4199 1993-03-30 V/O Im. Yanvarskogo 1988-05-24 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4200 4200 1993-03-30 V/O Machinoimport 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4201 4201 1993-03-30 V/O Mashriiborintorg 1982-12-22 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
4202 4202 1993-03-30 V/O Mezhdunarodnaja Kniga 1966-08-05 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4203 4203 1993-03-30 V/O Mingazprom 1988-08-31 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4204 4204 1993-03-30 V/O Novoexport 1966-08-05 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4205 4205 1993-03-30 V/O Promexport"" 1990-03-21 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4206 4206 1993-03-30 V/O Raznoimport 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4207 4207 1993-03-30 V/O Rosvneshtorg 1988-04-20 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4208 4208 1993-03-30 V/O SKOTOIMPORT"" 1990-10-11 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4209 4209 1993-03-30 V/O STROJDORMASHEXPORT"" 1990-10-11 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4210 4210 1993-03-30 V/O Sojuzkiipvneshtorg 1985-02-11 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
4211 4211 1993-03-30 V/O Sojuzkoopvneshtorg 1985-02-11 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
4212 4212 1993-03-30 V/O Sojuzzagranpribor 1987-11-05 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4213 4213 1993-03-30 V/O Strojdormashexport 1988-08-31 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4214 4214 1993-03-30 V/O Techmashexport 1967-07-11 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4215 4215 1993-03-30 V/O Techmashimport 1974-04-01 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
4216 4216 1993-03-30 V/O Technopromimport 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4217 4217 1993-03-30 V/O Techsnabexport 1988-01-25 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4218 4218 1993-03-30 V/O Tjazhmash 1988-01-20 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4219 4219 1993-03-30 V/O Torgovaja Palata 1988-05-31 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4220 4220 1993-03-30 V/O Traktoroexport 1987-10-29 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
4221 4221 1993-03-30 V/O Vneshekonombank 1988-07-29 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        

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