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

5 rows where City = "Kyiv"

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
691	691		Victor Pinchuk	2011-10-19	UKRAINE	6071 6071	2011-10-19	Schoen, Doug	Parus Business Center	2, Mechnikova Street	Kyiv
2948	2948	2014-02-28	Ukrainian Party of Regions	2017-06-27	UKRAINE	6440 6440	2017-06-27	DMP International, LLC	3/5 Kudriavskaya Street		Kyiv
11807	11807	2011-10-01	Ivaniuschenko, Yuriy	2011-03-08	UKRAINE	3731 3731	1985-09-13	Sidley Austin, LLP	5 Hrushevskoho Street		Kyiv
16041	16041	2017-12-31	Agrarian Party of Ukraine	2017-10-07	UKRAINE	6474 6474	2017-10-07	Medowood Management, LLC	2 Solomyanska Sq.		Kyiv
16061	16061	2017-12-31	Rybalka, Serhey	2017-10-07	UKRAINE	6474 6474	2017-10-07	Medowood Management, LLC	3 Lypska Street	01021	Kyiv

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)
);