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

38 rows where Registrant_Name = "Black, Kelly, Scruggs & Healey"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 4

Registrant_Name 1

  • Black, Kelly, Scruggs & Healey · 38 ✖

City 1

  • - 38
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
1286 1286 1993-01-14 Government of Greece 1992-03-10 GREECE Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Washington     DC  
1287 1287 1993-01-14 Horsham Corporation 1992-05-26 CANADA Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Ontario        
1288 1288 1993-01-14 League of Leaders for Philippine Development 1990-06-13 PHILIPPINES Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Santa Ana     CA  
1289 1289 1993-01-14 Nordion International 1992-05-18 CANADA Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Ontario        
1290 1290 1993-01-14 Usarin Land Development Corporation 1992-07-14 THAILAND Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Bangkok        
1723 1723 1987-01-31 Korea Silo Company, Ltd. 1986-11-19 KOREA, SOUTH Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Inchon        
1814 1814 1998-01-31 Center for Democracy in Angola (CEDA) (formerly: UNITA) 1985-10-16 ANGOLA Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey          
2744 2744 1986-02-24 Chamber of Philippine Manufacturers', Exporters' & Tourism Association 1985-11-23 PHILIPPINES Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Manila        
2946 2946 1988-02-28 ADCOM Group 1987-08-05 LEBANON Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Beirut        
3003 3003 1995-02-28 National Convention for Reconstruction & Development 1994-10-04 GREAT BRITAIN Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey London        
3880 3880 1995-03-18 Fiat Ferroviaria 1994-11-08 ITALY Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Savigliano        
4223 4223 1995-03-30 Embassy of Ecuador 1995-02-16 ECUADOR Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Washington     DC  
4505 4505 1991-03-31 Government of Kenya 1989-05-18 KENYA Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Nairobi        
5948 5948 1995-04-30 Magal Security Systems, Ltd. 1993-05-14 ISRAEL Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey          
6512 6512 1985-05-13 Government of Barbados 1985-05-06 BARBADOS Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Christ Church        
6940 6940 1985-05-30 News Corporation, Ltd. 1984-06-14 AUSTRALIA Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Sidney        
7804 7804 1994-06-14 Vittoria Consultants, Ltd. 1993-10-07 ISLE OF MAN Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Douglas        
8406 8406 1986-06-30 Government of Peru 1985-09-16 PERU Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Lima        
8879 8879 1990-07-01 Government of Somalia 1988-06-14 SOMALI DEMOCRATIC REPUBLIC Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey          
8961 8961 1987-07-02 Intercultural Association of Korea 1987-04-01 KOREA, SOUTH Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Seoul        
8989 8989 1986-07-03 Government of the Dominican Republic 1985-05-06 DOMINICAN REPUBLIC Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Washington     DC  
9244 9244 1994-07-14 Government of Nigeria 1989-12-20 NIGERIA Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Lagos        
9245 9245 1994-07-14 Government of the Republic of Togo 1993-08-02 TOGO Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Lome, Togo        
11252 11252 1986-09-01 Government of the Bahamas 1985-04-09 BAHAMAS Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Nassau        
11274 11274 1989-09-01 Minpeco U.S.A., Inc. 1988-06-14 PERU Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Hartsdale     NY  
12363 12363 1987-10-01 Luso American Foundation for International Relations 1987-04-03 PORTUGAL Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Lisbon        
13247 13247 1988-10-31 Aston Martin Lagonda, Ltd. 1987-07-16 GREAT BRITAIN Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey          
13386 13386 1999-10-31 Government of Equatorial Guinea, Embassy 1995-10-16 EQUATORIAL GUINEA Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Washington     DC  
13706 13706 1986-11-04 Government of Nigeria 1985-10-30 NIGERIA Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey          
13846 13846 1989-11-09 Union for National Action 1989-02-07 PHILIPPINES Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Manila        
14369 14369 1986-11-30 Government of Bermuda 1986-08-20 BERMUDA Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Hamilton        
14714 14714 1999-12-01 Comision Ejecutiva Hidroelectrica del Rio Lempa CEL 1998-03-20 EL SALVADOR Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey          
14845 14845 1999-12-06 Government of El Salvador, Embassy 1998-10-14 EL SALVADOR Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Washington     DC  
15104 15104 1990-12-14 Government of Zaire 1989-07-13 ZAIRE Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Kinshasa        
15107 15107 1993-12-14 Government of the Republic of Kenya 1992-03-10 KENYA Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Washington     DC  
15206 15206 1985-12-18 Government of St. Lucia 1985-05-06 SAINT LUCIA Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Castries        
15964 15964 1986-12-31 Institute for Financial & Fiscal Studies of Curacao 1986-04-19 CURACAO Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Washington     DC  
16107 16107 1989-12-31 Eitaro Itoyama 1989-08-23 JAPAN Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Kawangoe City        

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