home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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

33 rows where Country/Location_Represented = "TUNISIA"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 29

  • Bouhafa, El Abed 3
  • BCW LLC 2
  • Marshall, Leon, Weill & Mahony 2
  • Afridi, Angell & Pelletreau LLP 1
  • America to Africa Consulting, LLC (A2A) 1
  • Amram, Hahn & Sundlun 1
  • Bannerman & Associates, Inc. 1
  • Bourguiba, Habib 1
  • Cohen & Woods International, Inc. 1
  • Dickens & Madson Canada Inc. 1
  • Doremus & Company 1
  • Georgetown Associates, Inc. 1
  • Hoagland, Peter 1
  • Laitman, Leon 1
  • Martin, Ryan, Haley & Associates, Inc. 1
  • Murden & Company, Inc. 1
  • North African Independence Movement 1
  • Pagonis & Donnelly Group, Inc. 1
  • Patrick & Associates 1
  • Powell Tate, Inc. 1
  • Rahman, Hasan Abdel 1
  • Shandwick Public Affairs, Inc. 1
  • Tromson Monroe Advertising, Inc. 1
  • Tunisia Investment Promotion Agency 1
  • Tunisian National Tourist Office 1
  • Tunisian Trade Office 1
  • Washington International Group, Inc. 1
  • Washington Media Group, Inc. 1
  • White & Case, LLP 1

Foreign_Principal 26

  • Embassy of Tunisia 4
  • Republic of Tunisia 3
  • Government of Tunisia 2
  • Tunisian Agency for External Communications 2
  • Agence de Promotion des Investissements 1
  • Agency for Promotion of Investment 1
  • Bank for Economic Development of Tunisia 1
  • Committee for Freedom of North Africa 1
  • Destour Party 1
  • Dr. Mohamed Aboul-Ahrass & Chuk 1
  • Ennahdha Party 1
  • Ennahdha Party Diaspora Group 1
  • Government of Tunisia (Chadli Tnani)(Bahi Ladgham) 1
  • Hasan Abdel Rahman 1
  • League of the Arab States 1
  • Nabil Karoui 1
  • Ofice du Commerce de la Tunisie 1
  • Olfa Terras-Rambourg 1
  • Parti Liberal Constitutional Tunisian (Destour) 1
  • Tunisian Association for Freedom 1
  • Tunisian External Communication Agency (TECA) 1
  • Tunisian Government 1
  • Tunisian Government, National Tourist Office and Investment Promotion Agency 1
  • Tunisian National Tourist Office 1
  • Tunisian-American Friendship Society 1
  • Winnington, Ltd. and (if and when formed) the Ghribi Foundation 1

State 3

  • - 27
  • DC 5
  • NY 1

City 3

  • - 31
  • London 1
  • Tunis 1

Country/Location_Represented 1

  • TUNISIA · 33 ✖
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
947 947 1992-01-01 Government of Tunisia 1988-05-10 TUNISIA Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Washington     DC  
1043 1043 2022-01-01 Ennahdha Party Diaspora Group 2021-08-03 TUNISIA BCW LLC 6227 2014-06-18 BCW LLC 55 Bryanston Street Marble Arch Tower W1H London    
1115 1115 2011-01-06 Republic of Tunisia 2010-05-13 TUNISIA Washington Media Group, Inc. 5988 2010-05-13 Washington Media Group, Inc. Ministry of Communication   Tunis    
2924 2924 1978-02-28 Republic of Tunisia 1978-02-23 TUNISIA Doremus & Company 2319 1972-02-18 Doremus & Company Tunis        
3555 3555 1991-03-09 Republic of Tunisia 1988-06-20 TUNISIA White & Case, LLP 2759 1977-03-09 White & Case, LLP Tunis        
5775 5775 1960-04-30 Government of Tunisia (Chadli Tnani)(Bahi Ladgham) 1958-10-02 TUNISIA Laitman, Leon 1176 1958-10-02 Laitman, Leon Tunis        
7319 7319 1957-06-01 League of the Arab States 1954-07-27 TUNISIA Bouhafa, El Abed 466 1947-06-04 Bouhafa, El Abed Cairo        
7607 7607 1966-06-05 Embassy of Tunisia 1961-12-05 TUNISIA Amram, Hahn & Sundlun 1496 1961-12-05 Amram, Hahn & Sundlun Washington     DC  
7873 7873 1981-06-16 Ofice du Commerce de la Tunisie 1978-12-05 TUNISIA Tunisian Trade Office 2982 1978-12-05 Tunisian Trade Office          
8146 8146 2002-06-28 Tunisian External Communication Agency (TECA) 1998-11-23 TUNISIA Afridi, Angell & Pelletreau LLP 5231 1998-02-04 Afridi, Angell & Pelletreau LLP Tunis        
8913 8913 1999-07-01 Winnington, Ltd. and (if and when formed) the Ghribi Foundation 1997-12-31 TUNISIA Cohen & Woods International, Inc. 5003 1995-03-10 Cohen & Woods International, Inc. Lugano        
9019 9019 1993-07-05 Government of Tunisia 1992-04-10 TUNISIA Washington International Group, Inc. 3320 1982-01-05 Washington International Group, Inc. Tunis        
9312 9312 1947-07-17 Destour Party 1947-01-17 TUNISIA North African Independence Movement 427 1947-01-17 North African Independence Movement Tunis        
9972 9972 1979-08-01 Embassy of Tunisia 1978-12-06 TUNISIA Patrick & Associates 2984 1978-12-06 Patrick & Associates Washington     DC  
9978 9978 1979-08-01 Tunisian National Tourist Office 1979-10-10 TUNISIA Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc.          
9982 9982 1981-08-01 Agence de Promotion des Investissements 1979-04-02 TUNISIA Tunisia Investment Promotion Agency 3011 1979-04-02 Tunisia Investment Promotion Agency Tunis        
9986 9986 1981-08-01 Tunisian Government, National Tourist Office and Investment Promotion Agency 1975-09-25 TUNISIA Tunisian National Tourist Office 2610 1975-09-25 Tunisian National Tourist Office          
10332 10332 1986-08-14 Embassy of Tunisia 1982-11-19 TUNISIA Murden & Company, Inc. 2703 1976-06-26 Murden & Company, Inc. Washington     DC  
12724 12724 1999-10-15 Tunisian Agency for External Communications 1998-01-12 TUNISIA Powell Tate, Inc. 5148 1996-12-30 Powell Tate, Inc. Tunis        
12725 12725 1999-10-15 Tunisian Agency for External Communications 1999-12-10 TUNISIA Shandwick Public Affairs, Inc. 5220 1997-12-17 Shandwick Public Affairs, Inc. Tunis        
13500 13500 2019-10-31 Nabil Karoui 2019-09-26 TUNISIA Dickens & Madson Canada Inc. 6200 2013-12-11 Dickens & Madson Canada Inc.          
13502 13502 2019-10-31 Olfa Terras-Rambourg 2019-09-03 TUNISIA America to Africa Consulting, LLC (A2A) 6715 2019-09-03 America to Africa Consulting, LLC (A2A) 74 rue d'Assas 75006 Paris FRANCE      
14047 14047 1993-11-17 Tunisian Association for Freedom 1992-08-11 TUNISIA Pagonis & Donnelly Group, Inc. 3692 1985-06-20 Pagonis & Donnelly Group, Inc. London, England        
14529 14529 2007-11-30 Embassy of Tunisia 2002-05-14 TUNISIA Hoagland, Peter 5496 2002-05-14 Hoagland, Peter 1515 Massachusetts Avenue, N.W. 20005     DC  
15202 15202 1973-12-18 Tunisian Government 1973-12-05 TUNISIA Georgetown Associates, Inc. 2482 1973-12-05 Georgetown Associates, Inc. Tunis        
15217 15217 1946-12-19 Parti Liberal Constitutional Tunisian (Destour) 1946-12-19 TUNISIA Bourguiba, Habib 415 1946-12-19 Bourguiba, Habib          
15219 15219 1974-12-19 Tunisian-American Friendship Society 1974-06-06 TUNISIA Martin, Ryan, Haley & Associates, Inc. 2517 1974-06-06 Martin, Ryan, Haley & Associates, Inc. Tunis        
15565 15565 1957-12-31 Committee for Freedom of North Africa 1947-07-15 TUNISIA Bouhafa, El Abed 466 1947-06-04 Bouhafa, El Abed Paris        
15569 15569 1957-12-31 Dr. Mohamed Aboul-Ahrass & Chuk 1947-06-04 TUNISIA Bouhafa, El Abed 466 1947-06-04 Bouhafa, El Abed New York     NY  
15735 15735 1975-12-31 Agency for Promotion of Investment 1975-05-16 TUNISIA Marshall, Leon, Weill & Mahony 2584 1975-05-16 Marshall, Leon, Weill & Mahony Tunis        
15736 15736 1975-12-31 Bank for Economic Development of Tunisia 1975-05-16 TUNISIA Marshall, Leon, Weill & Mahony 2584 1975-05-16 Marshall, Leon, Weill & Mahony Tunis        
16060 16060 1988-12-31 Hasan Abdel Rahman 1988-04-28 TUNISIA Rahman, Hasan Abdel 4132 1988-04-28 Rahman, Hasan Abdel Tunis        
16874 16874 2020-12-31 Ennahdha Party 2014-09-18 TUNISIA BCW LLC 6227 2014-06-18 BCW LLC          

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])
);
Powered by Datasette · Queries took 341.083ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows