FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

13 rows where Registrant_Name = "Fenton Communications"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Country/Location_Represented 7

City 7

State 2

Registrant_Name 1

  • Fenton Communications · 13 ✖
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 State Zip
1356 1356 2009-01-15 Embassy of Ecuador 2008-08-25 ECUADOR Fenton Communications 5803 2007-04-30 Fenton Communications 2535 15th Street, NW   Washington DC 20009
3085 3085 2008-02-28 Corporacion de Promocion de Exportacion e Inverciones (CORPEI) through Foley Hoag, LLP 2007-04-30 ECUADOR Fenton Communications 5803 2007-04-30 Fenton Communications Cdla. Kennedy Norte, Avda. Francisco de Orellana y Miguel H. Alcivar, Edificio Centro Empresarial Las Camaras, Torre de Oficinas, 2do piso. Telefono (593-4) 2681550 Guayaquil    
3089 3089 2010-02-28 Embassy of the Republic of Ecuador 2009-06-26 ECUADOR Fenton Communications 5945 2009-06-26 Fenton Communications 2535 15th Street, NW   Washington DC 20009
6067 6067 2012-04-30 Embassy of Argentina 2012-04-30 ARGENTINA Fenton Communications 5945 2009-06-26 Fenton Communications          
6068 6068 2012-04-30 Embassy of the Republic of Ecuador 2011-01-31 ECUADOR Fenton Communications 5945 2009-06-26 Fenton Communications          
7659 7659 2007-06-07 Royal Norwegian Embassy 2007-06-07 NORWAY Fenton Communications 5803 2007-04-30 Fenton Communications 2720 34th Street, NW   Washington DC 20008
10194 10194 2009-08-07 Qatar Foundation for Education, Science and Community Development 2009-09-28 QATAR Fenton Communications 5945 2009-06-26 Fenton Communications P.O. Box 5825   Doha    
11139 11139 2010-08-31 Office of Her Highness Sheikha Mozah Bint Nasser Al-Missned 2009-09-28 QATAR Fenton Communications 5945 2009-06-26 Fenton Communications P.O. Box 34000   Doha    
12225 12225 2014-09-30 Transformation and Continuity, Ajmal Ghani 2014-05-05 AFGHANISTAN Fenton Communications 6245 2014-05-05 Fenton Communications House #3 MRRD Road Darul Aman Kabul      
14233 14233 2008-11-24 Maretz, Israeli Political Party 2009-01-26 ISRAEL Fenton Communications 5803 2007-04-30 Fenton Communications Kirayat Ben Gurion 91950   Jerusalem    
14554 14554 2014-11-30 Transformation and Continuity, Ajmal Ghani 2014-05-05 AFGHANISTAN Fenton Communications 5945 2009-06-26 Fenton Communications House #3 MRRD Road Darul Aman Kabul    
14881 14881 2007-12-07 Embassy of the Republic of Bolivia 2009-03-30 BOLIVIA Fenton Communications 5803 2007-04-30 Fenton Communications 3014 Massachusetts Avenue, NW   Washington DC 20008
16694 16694 2011-12-31 Government of Ecuador, Ministry for the Coordination of Production, Employment and Competitiveness 2010-06-10 ECUADOR Fenton Communications 5945 2009-06-26 Fenton Communications Av. Coruna y 12 de Octubre, Edificio altana Paza 4to piso.   Quito    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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