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

17 rows where Country/Location_Represented = "SIERRA LEONE"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 4

City 3

Country/Location_Represented 1

  • SIERRA LEONE · 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
1273 1273 1998-01-13 AFRC Government of Sierra Leone 1998-01-13 SIERRA LEONE Fry, Morton H. 5226 1998-01-13 Fry, Morton H. Freetown        
1861 1861 2006-01-31 Republic of Sierra Leone, Embassy 2005-07-08 SIERRA LEONE Brian L. Morris 5696 2005-07-08 Brian L. Morris 1701 19th Street, NW   Washington DC 20009
1907 1907 2016-01-31 Ministry of Finance and Economic Development of Sierra Leone 2015-04-03 SIERRA LEONE FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 2005-01-31 FGS Global (US) LLC (FKA FGH Holdings LLC) The Treasury Building George Street Freetown    
2144 2144 1966-02-03 Government of Sierra Leone 1964-06-16 SIERRA LEONE Bradley, Rosen & Kaus Advertising, Inc. 1761 1964-06-16 Bradley, Rosen & Kaus Advertising, Inc. New York     NY  
3017 3017 1996-02-28 Republic of Sierra Leone 1994-12-27 SIERRA LEONE PSC International, Ltd. 4559 1991-08-28 PSC International, Ltd. Freetown        
4427 4427 1986-03-31 Government of Sierra Leone 1985-12-11 SIERRA LEONE Darius International, Inc. 3713 1985-08-06 Darius International, Inc. Freetown        
5502 5502 2004-04-23 Sierra Rutile America, Inc. 1996-06-10 SIERRA LEONE Sierra Rutile America, Inc. 5128 1996-06-10 Sierra Rutile America, Inc. Freetown        
5801 5801 1973-04-30 Sierra Leone 1972-04-17 SIERRA LEONE Gurtman & Murtha Associates, Inc. 2332 1972-04-17 Gurtman & Murtha Associates, Inc. New York     NY  
6771 6771 1993-05-24 Government of Sierra Leone 1991-04-22 SIERRA LEONE Denison, George H. 4502 1991-04-22 Denison, George H. Freetown        
9256 9256 1965-07-15 Government of Sierra Leone 1964-06-24 SIERRA LEONE Barnet & Reef Associates, Inc. 1378 1960-07-15 Barnet & Reef Associates, Inc. Freetown        
9586 9586 1987-07-29 Government of Sierra Leone 1986-07-18 SIERRA LEONE Alvin Rosenbaum Projects, Inc. 3858 1986-07-18 Alvin Rosenbaum Projects, Inc. Freetown        
10771 10771 2013-08-26 Government of Sierra Leone 2011-10-07 SIERRA LEONE GoodWorks International, LLC 5414 2001-03-02 GoodWorks International, LLC c/o Attorney General Franklyn Bai Kargro Freetown, Sierra Leone      
11024 11024 1993-08-31 Mano River Union 1993-08-02 SIERRA LEONE James, John D. 4836 1993-08-02 James, John D. Freetown        
11788 11788 1997-09-23 Republic of Sierra Leone 1997-09-23 SIERRA LEONE Nabo Traders, Inc. 5212 1997-09-23 Nabo Traders, Inc. Conakry        
12086 12086 1997-09-30 NABO Traders 1997-08-01 SIERRA LEONE Powell Tate, Inc. 5148 1996-12-30 Powell Tate, Inc. Arlington     VA  
12905 12905 1965-10-22 Government of Sierra Leone and Embassy of Sierra Leone 1964-05-20 SIERRA LEONE Robert R. Nathan Associates, Inc. 352 1946-04-22 Robert R. Nathan Associates, Inc.          
15269 15269 1995-12-20 Jeredine Williams Sarho 1995-12-20 SIERRA LEONE Shoenberg, Susan S. 5090 1995-12-20 Shoenberg, Susan S. Freetown        

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