FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
336 rows where Document_Type = "Exhibit AB" and Foreign_Principal_Country = "RUSSIA" sorted by Registration_Number
This data as json, CSV (advanced)
Registrant_Name >30
- Amtorg Trading Corporation 127
- T&R Productions LLC 13
- AMTORG TRADING CORPORATION 8
- HOGAN & HARTSON, L.L.P. 8
- NUTTER & HARRIS, INC. 7
- RM Broadcasting, LLC 6
- Mercury Public Affairs, LLC 5
- Reston Translator, LLC 5
- Daniel J. Edelman, Inc. 4
- Gallagher, John J. 4
- INTOURIST, RUSSIAN JOINT STOCK COMPANY FOR FOREIGN TRAVEL, 4
- SCHNADER, HARRISON, SEGAL & LEWIS 4
- APCO Worldwide, Inc. 3
- Alston & Bird, LLP 3
- Ghebi LLC 3
- Ketchum Inc. NY 3
- PARTNERS & SHEVACK, INC. 3
- SHAW, PITTMAN, POTTS & TROWBRIDGE 3
- STROOCK & STROOCK & LAVAN 3
- Solutions North America Incorporated 3
- Venable, LLP 3
- ADVANTAGE ASSOCIATES, INC. 2
- CHALK, O. ROY 2
- Capitol Counsel, LLC 2
- Clark & Weinstock 2
- DANIEL J. EDELMAN, INC. 2
- Denton, James Steele 2
- ENERGIA U.S.A., INC. 2
- Endeavor Law Firm, PC 2
- Fleishman-Hillard, Inc. 2
- …
Foreign_Principal_Name >30
- ANO TV-Novosti 17
- Federal State Unitary Enterprise Rossiya Segodnya International Information Agency 14
- V/O Techsnabexport 6
- V/O Novoexport 5
- V/O Medexport 4
- V/O Sudoimport 4
- VSESOJUZNOE AKTZIONERNOE OBSHCHESTVO "INTOURIST" 4
- CHECHEN REPUBLIC 3
- City Government of St. Petersburg, Russia 3
- En+Group plc 3
- INTOURIST 3
- Kurchatov Institute 3
- MATEK 3
- Russian Federation (through Ketchum, Inc.) 3
- 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
- …
Foreign_Principal_Country 1
- RUSSIA · 336 ✖
Document_Type 1
- Exhibit AB · 336 ✖
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]) );