FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
127 rows where Foreign_Principal_Country = "RUSSIA" and Registrant_Name = "Amtorg Trading Corporation"
This data as json, CSV (advanced)
Foreign_Principal_Name >30
- V/O Techsnabexport 6
- V/O Novoexport 5
- V/O Medexport 4
- V/O Sudoimport 4
- V/O Almazjuvelirexport 3
- V/O Electronorgtechnica 3
- V/O Energomashexport 3
- V/O Exportkhleb 3
- V/O Licensintorg 3
- V/O Machinoexport 3
- V/O Machinoimport 3
- V/O Prodintorg 3
- V/O Promsyrioimport 3
- V/O Raznoimport 3
- V/O Sojuzpromexport 3
- V/O Stankoimport 3
- V/O Techmashexport 3
- V/O Techmashimport 3
- V/O Technoexport 3
- V/O Technopromimport 3
- V/O Vneshtorgreklama 3
- "Kwartzsamotsvety" 2
- U.S.S.R. Chamber of Commerce 2
- U.S.S.R. Pavilion of Goods 2
- V/O Avtopromimport 2
- V/O Mashpriborintorg 2
- V/O Raznoexport 2
- V/O Sojuzplodoimport 2
- V/O Strojmaterialintorg 2
- V/O Vneshposyltorg 2
- …
Date_Stamped (date) >30 ✖
- 1950-06-07 10
- 1974-04-01 8
- 1974-04-10 8
- 1990-10-11 7
- 1966-09-02 6
- 1967-09-01 5
- 1966-08-05 4
- 1991-02-25 4
- 1967-05-02 3
- 1967-07-11 3
- 1982-11-03 3
- 1960-04-29 2
- 1968-05-01 2
- 1968-10-31 2
- 1979-06-11 2
- 1980-02-08 2
- 1982-12-22 2
- 1990-02-27 2
- 1990-03-14 2
- 1990-03-21 2
- 1990-03-29 2
- 1990-03-30 2
- 1990-04-18 2
- 1990-05-02 2
- 1990-05-17 2
- 1990-10-01 2
- 1990-12-27 2
- 1952-04-28 1
- 1954-04-28 1
- 1961-10-30 1
- …
Registrant_Name 1
- Amtorg Trading Corporation · 127 ✖
Foreign_Principal_Country 1
- RUSSIA · 127 ✖
Document_Type 1
- Exhibit AB 127
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );