FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40 rows where "Foreign_Principal_Termination_Date" is on date 1993-03-30 sorted by Foreign_Principal
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Address_1, Registrant_Date (date)
Foreign_Principal 40
- Baltic Sea State Steamship Line 1
- Bank for Foreign Trade of the U.S.S.R. 1
- Black Sea State Steamship Line 1
- Commonwealth of the Bahamas Ministry of Tourism 1
- Far Eastern State Steamship Line 1
- Gorkovskoye Proizvodstvennoye Objedinenie Normal"" 1
- Intourist 1
- Inventive Machine Laboratory 1
- Kwartzsamotsvety"" 1
- Ministry of Foreign Trade of the U.S.S.R. 1
- Ministry of Maritime Fleet of the U.S.S.R. 1
- Northern State Steamship Line 1
- U.S.S.R. Chamber of Commerce 1
- U.S.S.R. Pavilion of Goods 1
- V/O Aviaexport 1
- V/O Centerquartzsamotsvety 1
- V/O Chimmashexport 1
- V/O Im. Yanvarskogo 1
- V/O Machinoimport 1
- V/O Mashriiborintorg 1
- V/O Mezhdunarodnaja Kniga 1
- V/O Mingazprom 1
- V/O Novoexport 1
- V/O Promexport"" 1
- V/O Raznoimport 1
- V/O Rosvneshtorg 1
- V/O SKOTOIMPORT"" 1
- V/O STROJDORMASHEXPORT"" 1
- V/O Sojuzkiipvneshtorg 1
- V/O Sojuzkoopvneshtorg 1
- V/O Sojuzzagranpribor 1
- V/O Strojdormashexport 1
- V/O Techmashexport 1
- V/O Techmashimport 1
- V/O Technopromimport 1
- V/O Techsnabexport 1
- V/O Tjazhmash 1
- V/O Torgovaja Palata 1
- V/O Traktoroexport 1
- V/O Vneshekonombank 1
Foreign_Principal_Registration_Date (date) 24 ✖
- 1949-11-07 11
- 1990-10-11 3
- 1966-08-05 2
- 1966-09-02 2
- 1985-02-11 2
- 1988-08-31 2
- 1967-05-02 1
- 1967-07-11 1
- 1974-04-01 1
- 1982-12-22 1
- 1987-10-29 1
- 1987-11-05 1
- 1988-01-20 1
- 1988-01-25 1
- 1988-04-20 1
- 1988-05-06 1
- 1988-05-24 1
- 1988-05-31 1
- 1988-07-25 1
- 1988-07-29 1
- 1988-09-30 1
- 1990-03-21 1
- 1990-03-29 1
- 1991-11-15 1
Registrant_Name 2
State 1
- - 40
City 1
- - 40
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 | ||||
4185 | 4185 | 1993-03-30 | Commonwealth of the Bahamas Ministry of Tourism | 1988-09-30 | BAHAMAS | Caroline Jones Advertising, Inc. 4181 | 1988-09-30 | Caroline Jones Advertising, Inc. | Nassau | ||||
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
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]) );