FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

19 rows where City = "Moscow"

Search:

descending

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
20	20		ANO TV-Novosti	2017-11-10	RUSSIA	6485 6485	2017-11-10	T&R Productions LLC	111020 Borovaya St. 3		Moscow
329	329		International Centre for Legal Protection	2019-10-09	RUSSIA	6739 6739	2019-10-09	Lauer, Matthew Jay	Krasnopresenskaya Nab.		Moscow
615	615		TENEX, Joint Stock Company	2020-07-20	RUSSIA	3731 3731	1985-09-13	Sidley Austin, LLP	2813 Ozerkovsksya-nab-11584		Moscow
684	684		Vnesheconombank, State Development Corporation, (VEB.RF)	2019-10-09	RUSSIA	6740 6740	2019-10-09	Geopolitical Solutions LLC d/b/a/ Geopols	Akademika Sakharova Prospekt, 9		Moscow
921	921	2007-01-01	Mediaservices, LLC	2006-09-19	RUSSIA	5483 5483	2002-03-06	MSLGROUP Americas, LLC	29 Planetnaya str.	Building 1	Moscow
3263	3263	1973-03-05	Izvestia	1969-04-17	USSR	2130 2130	1969-04-17	Sturua, Melor G.	Pushkin Place 5		Moscow
4464	4464	2007-03-31	Terralife Strategic Advertising Agency LLC (on behalf of the Department of External Activity of the Krasnodar Region, Russia)	2007-11-30	RUSSIA	4561 4561	1991-09-03	APCO Worldwide, Inc.	7 Ostozhenka Street	Bld. 1, Level 1, Office 33, Room 12	Moscow
4526	4526	2014-03-31	Gazprom Export through Ketchum, Inc.	2010-06-21	RUSSIA	5931 5931	2009-04-17	Venable, LLP	Nametkina Street, V-420, GSP-7		Moscow
4786	4786	2018-04-05	Deripaska, Oleg	2009-05-08	RUSSIA	5934 5934	2009-05-08	Endeavor Law Firm, PC	c/o Basic Element	30 Rochdelskaya Street	Moscow
5353	5353	2020-04-27	PJSC United Aircraft Corporation	2020-04-08	RUSSIA	6813 6813	2020-04-08	Stopa, Mark Thomas	Bolshaya Pionerskaya str., 1		Moscow
5935	5935	2009-05-01	NCB Finetechproject	2009-03-27	RUSSIA	5924 5924	2009-03-27	Spencer, Thomas R.	42 Mosfilmovskaya Street		Moscow
6380	6380	2009-05-21	OAO Gazprom	2007-08-09	RUSSIA	5824 5824	2007-08-09	Kreab Gavin Anderson (USA), Inc.	16 Nametkina Street V-420	GSP-7	Moscow
8705	8705	2011-07-08	Joint Stock Company Techsnabexport""	2010-04-13	RUSSIA	4561 4561	1991-09-03	APCO Worldwide, Inc.	Ozerkovskaya nab., 28 bld. 3		Moscow
9744	9744	2007-08-06	Maia Topuria, Justice Party, Republic of Georgia	2007-03-02	GEORGIA	5791 5791	2007-02-05	Squire Sanders Public Advocacy, LLC	c/o James S. Friedlander, Gen. Director/Friedlander Associates	ul. Bolshaya Sadovaya 10, Rm 9	Moscow
12869	12869	2006-10-31	Rosneft OJSC	2006-06-01	RUSSIA	5700 5700	2005-07-26	Brunswick Group, LLC	Kadashevskaya Naberezhnaya	115035	Moscow
12883	12883	2010-10-31	Russian Venture Company	2010-11-23	RUSSIA	3634 3634	1984-11-15	Daniel J. Edelman, Inc.	3-1 Kapranova Lane		Moscow
13086	13086	2005-11-02	Leadership of the Rodina Political Party	2005-11-02	RUSSIA	5720 5720	2005-11-02	Global Strategic Communications Group, LLC			Moscow
14810	14810	2014-12-29	Russian Federation (through Ketchum, Inc.)	2009-01-29	RUSSIA	5549 5549	2003-04-01	Alston & Bird, LLP	4 Staraya Square		Moscow
16002	16002	2008-12-31	Russian Federation through the Washington Group	2008-02-27	RUSSIA	5855 5855	2008-02-27	Integrated Solutions Group, LLC	4 Staraya Square		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)
);