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

17 rows where Country/Location_Represented = "SENEGAL"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 16

  • Ritter, Sheldon 2
  • Carter Ledyard & Milburn, LLP 1
  • Dickens & Madson Canada, Inc. 1
  • Envision Strategy, LLC 1
  • Holland & Knight 1
  • JWI, LLC 1
  • James M. Johnson 1
  • Johnson, James M. 1
  • Keating Group, Inc. 1
  • LTL Strategies 1
  • McKenna Long & Aldridge, LLP 1
  • Mercury Public Affairs, LLC 1
  • Vanguard Africa 1
  • Washington International Group, Inc. 1
  • Watts Partners (J.C. Watts Companies) 1
  • van Kloberg & Associates, Ltd. 1

Foreign_Principal 13

  • Government of Senegal 3
  • Embassy of the Republic of Senegal 2
  • Government of the Republic of Senegal 2
  • Air Afrique 1
  • Dakar Industrial Free Zone 1
  • Idrissa Seck 1
  • Idrissa Seck, founder and present leader of the Rewmi Party, a Senegalese political party, and President of the Economic, Social and Environmental Council, an advisory council Government of Senegal 1
  • Mr. Idrissa Seck 1
  • Office of the President of the Republic of Senegal 1
  • Presidency of the Republic of Senegal (through Kirjas Global Ltd.) (Senegal")" 1
  • Republic of Senegal 1
  • Senegal Government Tourist Bureau 1
  • Yoro K. Fall 1

City 5

  • - 11
  • Dakar 2
  • Washington 2
  • Thies 1
  • Dakar-Fann 1

State 3

  • - 12
  • DC 3
  • NY 2

Country/Location_Represented 1

  • SENEGAL · 17 ✖
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
342 342   Idrissa Seck, founder and present leader of the Rewmi Party, a Senegalese political party, and President of the Economic, Social and Environmental Council, an advisory council Government of Senegal 2023-04-10 SENEGAL James M. Johnson 7256 2023-04-10 James M. Johnson Rue Van Vollenoven   Thies    
497 497   Mr. Idrissa Seck 2023-05-22 SENEGAL Vanguard Africa 6411 2017-03-26 Vanguard Africa Rue Van Vollenoven Thies Senegal        
1003 1003 2008-01-01 Government of Senegal 2004-08-27 SENEGAL Watts Partners (J.C. Watts Companies) 5641 2004-08-27 Watts Partners (J.C. Watts Companies) His Excellency Abdoulaye Wade President of the Republic of Senegal P.O. Box 4044 Dakar        
2609 2609 2007-02-16 Government of Senegal 2007-02-15 SENEGAL Carter Ledyard & Milburn, LLP 5793 2007-02-15 Carter Ledyard & Milburn, LLP c/o Aziz Diey 2, Place de I'Independance BP 188 Dakar    
3107 3107 2014-02-28 Government of the Republic of Senegal 2014-01-31 SENEGAL JWI, LLC 4990 1995-02-06 JWI, LLC 2031 Florida Avenue, NW   Washington DC 20009
3606 3606 1993-03-11 Air Afrique 1987-05-26 SENEGAL Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
4678 4678 2007-03-31 Idrissa Seck 2005-09-09 SENEGAL Johnson, James M. 5710 2005-09-09 Johnson, James M. Point E Rue 3 XC Dakar BP 5861        
4726 4726 2012-03-31 Republic of Senegal 2011-11-22 SENEGAL McKenna Long & Aldridge, LLP 5772 2006-10-03 McKenna Long & Aldridge, LLP Office of the President Republic of Senegal Dakar      
6003 6003 2002-04-30 Government of Senegal 2002-03-04 SENEGAL LTL Strategies 5482 2002-03-04 LTL Strategies Palais de la Republique Dakar        
7266 7266 2017-05-31 Embassy of the Republic of Senegal 2016-11-17 SENEGAL Envision Strategy, LLC 6392 2016-11-17 Envision Strategy, LLC 2215 M Street, NW   Washington DC 20037
8455 8455 1990-06-30 Embassy of the Republic of Senegal 1990-05-18 SENEGAL van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
9021 9021 1993-07-05 Office of the President of the Republic of Senegal 1993-05-06 SENEGAL Washington International Group, Inc. 3320 1982-01-05 Washington International Group, Inc. Dakar        
10218 10218 1998-08-08 Government of the Republic of Senegal 1994-10-07 SENEGAL Holland & Knight 3718 1985-08-07 Holland & Knight Dakar        
11809 11809 2022-09-24 Presidency of the Republic of Senegal (through Kirjas Global Ltd.) (Senegal")" 2022-07-05 SENEGAL Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Avenue Leopold Sedar Senghor   Dakar    
15818 15818 1979-12-31 Dakar Industrial Free Zone 1980-03-30 SENEGAL Ritter, Sheldon 2666 1976-03-10 Ritter, Sheldon          
15887 15887 1982-12-31 Senegal Government Tourist Bureau 1977-06-07 SENEGAL Ritter, Sheldon 2666 1976-03-10 Ritter, Sheldon       NY  
16650 16650 2008-12-31 Yoro K. Fall 2007-01-10 SENEGAL Dickens & Madson Canada, Inc. 5784 2007-01-10 Dickens & Madson Canada, Inc. Villa 35, Mamelles Universite Quakam/Dakar, Senegal Dakar-Fann    

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 140.255ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history