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)
These facets timed out: Document_Type, Registrant_Name
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
- …
Foreign_Principal_Country 1
- RUSSIA · 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]) );