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

14 rows where Country/Location_Represented = "RWANDA"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 13

  • van Kloberg & Associates, Ltd. 2
  • Fleishman-Hillard, Inc. 1
  • Foley Hoag, LLP 1
  • GoodWorks International, LLC 1
  • Henry J. Kaufman & Associates, Inc. 1
  • Hunt, Darryl L. 1
  • JWI, LLC 1
  • Martin, Michelle E. 1
  • Mercury Public Affairs, LLC 1
  • Myriad International Marketing, LLC 1
  • Rubenstein Public Relations 1
  • W2 Group, Inc. 1
  • Winning Strategies Washington 1

Foreign_Principal 10

  • Government of Rwanda 3
  • Embassy of the Republic of Rwanda 2
  • Republic of Rwanda 2
  • Embassy of Rwanda 1
  • Embassy of the Republic of Rwanda in Washington, D.C-USA 1
  • Government of the Republic of Rwanda 1
  • Republic of Rwanda, Embassy 1
  • Rwanda Development Board 1
  • Rwanda Development Board (through Peter Greenberg Worldwide) 1
  • Rwanda Development Board, Tourism and Conservation 1

State 2

  • - 9
  • DC 5

City 2

  • - 13
  • Kigali 1

Country/Location_Represented 1

  • RWANDA · 14 ✖
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
212 212   Embassy of the Republic of Rwanda in Washington, D.C-USA 2018-12-18 RWANDA Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC          
2659 2659 2004-02-18 Government of the Republic of Rwanda 2003-09-25 RWANDA JWI, LLC 4990 1995-02-06 JWI, LLC Office of the President Government of the Republic of Rwanda Kigali        
4692 4692 2009-03-31 Government of Rwanda 2005-03-04 RWANDA GoodWorks International, LLC 5414 2001-03-02 GoodWorks International, LLC Ministry of Finance & Economic Planning P.O. Box 158, Kigali        
4746 4746 2014-03-31 Republic of Rwanda 2013-06-12 RWANDA Martin, Michelle E. 6175 2013-06-12 Martin, Michelle E. MINAFFET Kimihurura Avenue du lac Muhazi 5th and 6th Floors B.P. 179 Kigali      
7463 7463 2018-06-01 Rwanda Development Board (through Peter Greenberg Worldwide) 2018-04-11 RWANDA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Rwanda Development Board: KG 220 St., Kigali        
8035 8035 1993-06-23 Embassy of the Republic of Rwanda 1993-01-26 RWANDA van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
10152 10152 2004-08-05 Embassy of Rwanda 2003-09-22 RWANDA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 1714 New Hampshire Avenue, N.W. 20009     DC  
10534 10534 1996-08-15 Republic of Rwanda, Embassy 1996-06-17 RWANDA Hunt, Darryl L. 5114 1996-06-17 Hunt, Darryl L. Washington     DC  
10861 10861 2017-08-30 Rwanda Development Board 2014-08-19 RWANDA Winning Strategies Washington 6242 2014-08-19 Winning Strategies Washington KN 5 Rd, KG 9 Ave P.O. Box 6239 Kigali      
12079 12079 1996-09-30 Government of Rwanda 1996-04-26 RWANDA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Kigali        
13847 13847 1990-11-09 Republic of Rwanda 1990-09-28 RWANDA Henry J. Kaufman & Associates, Inc. 4093 1988-02-19 Henry J. Kaufman & Associates, Inc. Washington     DC  
13851 13851 1991-11-09 Embassy of the Republic of Rwanda 1990-09-19 RWANDA van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
15174 15174 2015-12-16 Rwanda Development Board, Tourism and Conservation 2015-08-07 RWANDA Rubenstein Public Relations 6311 2015-08-07 Rubenstein Public Relations KN 5 Rd, KG 9 Ave P.O. Box 6239 Kigali        
16683 16683 2010-12-31 Government of Rwanda 2011-08-12 RWANDA W2 Group, Inc. 6055 2011-08-12 W2 Group, Inc. Ministry of Foreign Affairs and Cooperation Boulevard de la Revolution Place de I'Independence Kigali    

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