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

7 rows where City = "Quito"

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
1763	1763	2007-01-31	Corporacion de Promocion de Exportacion e Inversiones (CORPEI)	2006-10-25	ECUADOR	5562 5562	2003-06-10	Tew Cardenas, LLP	Direccion: Av. Amazonas 4430 y Villalengua, Edificio Amazonas 100, Piso 8		Quito
1785	1785	2011-01-31	Ministry of Coordination of Production, Employment and Competitiveness; Republic of Ecuador	2010-06-10	ECUADOR	5980 5980	2010-03-16	Blue Star Strategies, LLC	Av. Coruna y 12 de Octubre,	Edificio Altana Plaza 4o piso.	Quito
9390	9390	2006-07-31	Republic of Ecuador	2006-01-20	ECUADOR	5562 5562	2003-06-10	Tew Cardenas, LLP	Ministry of Foreign Trade, Industry , Fishing and Competitiveness	Ave. Eloy Alfaro y Amazonas, Edif, MAG-MICIP, 1er Piso,	Quito
10641	10641	2018-08-31	Unidad de Analisis Financiero y Economico	2017-06-19	ECUADOR	2244 2244	1971-02-18	Hogan Lovells US LLP	Avenida Republica de Salvador N36-161 y	Avenida Naciones Unidades	Quito
15848	15848	2006-12-31	Republic of Ecuador through Tew Cardenas LLP	2006-10-25	ECUADOR	5774 5774	2006-10-06	CLS Strategies			Quito
15936	15936	2011-12-31	Government of Ecuador, Ministry for the Coordination of Production, Employment and Competitiveness	2010-06-10	ECUADOR	5945 5945	2009-06-26	Fenton Communications	Av. Coruna y 12 de Octubre, Edificio altana Paza 4to piso.		Quito
15982	15982	2013-12-31	Yasuni-ITT Commission (via the UNDP)	2011-09-12	ECUADOR	5875 5875	2008-06-17	BLJ Worldwide LTD	Equipo Negociador de la Iniciativa Yasuni-ITT	Edificio Titanium, 7 mo piso Ave. 6 de Diciembre N33-42 e Ignacio Bossano	Quito

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