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

9 rows where "Foreign_Principal_Termination_Date" is on date 2022-05-31

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal 9

  • African Development Bank 1
  • Bahaa Hariri thru CT Solutions & Private Advisory Ltd. 1
  • Discover Dominica Authority 1
  • Government of Ethiopia 1
  • Government of National Unity of Libya 1
  • Government of the United Kingdom, Embassy 1
  • Ministry of Foreign Affairs and International Trade of Zimbabwe 1
  • N.S.O. Group Technologies Ltd. 1
  • U.S.- China Transpacific Foundation 1

Country/Location_Represented 9

  • CHINA 1
  • COTE D'IVOIRE (IVORY COAST) 1
  • DOMINICAN REPUBLIC 1
  • ETHIOPIA 1
  • GREAT BRITAIN 1
  • ISRAEL 1
  • LEBANON 1
  • LIBYA 1
  • ZIMBABWE 1

City 7

  • - 3
  • Harare 1
  • Herzliya 1
  • Las Vegas 1
  • London 1
  • Tripoli 1
  • Washington 1

Registrant_Name 6

  • Actum International UK Limited 4
  • CTF Global LLC 1
  • Capitol Counsel, LLC 1
  • Holland & Knight 1
  • Myriad International Marketing, LLC 1
  • Rabinowitz, Inc. d/b/a Bluelight Strategies 1

State 3

  • - 6
  • DC 2
  • NV 1
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
7290 7290 2022-05-31 African Development Bank 2021-11-01 COTE D'IVOIRE (IVORY COAST) Actum International UK Limited 7033 2021-11-01 Actum International UK Limited Avenue Joseph Anoma, 01 B.P. 1387 Abidjan, Ivory Coast      
7291 7291 2022-05-31 Bahaa Hariri thru CT Solutions & Private Advisory Ltd. 2021-09-03 LEBANON CTF Global LLC 7008 2021-09-03 CTF Global LLC 20 Grosvenor Square W1K 6LE London    
7292 7292 2022-05-31 Discover Dominica Authority 2018-04-30 DOMINICAN REPUBLIC Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC 1st Floor Financial Centre Roseau, Commonwealth of Dominica      
7293 7293 2022-05-31 Government of Ethiopia 2021-11-01 ETHIOPIA Actum International UK Limited 7033 2021-11-01 Actum International UK Limited United States Embassy of Ethiopia 3506 International Drive, N.W. Washington DC 20008
7294 7294 2022-05-31 Government of National Unity of Libya 2021-11-01 LIBYA Actum International UK Limited 7033 2021-11-01 Actum International UK Limited Tarik al Seka, Ben Ashour District   Tripoli    
7295 7295 2022-05-31 Government of the United Kingdom, Embassy 1999-08-16 GREAT BRITAIN Holland & Knight 3718 1985-08-07 Holland & Knight British Embassy 3100 Massachusetts Ave., NW     DC  
7296 7296 2022-05-31 Ministry of Foreign Affairs and International Trade of Zimbabwe 2021-11-01 ZIMBABWE Actum International UK Limited 7033 2021-11-01 Actum International UK Limited P.O. Box 4240, Munhumutapa Building, Samora Machel Sam Nujoma Street Harare    
7297 7297 2022-05-31 N.S.O. Group Technologies Ltd. 2022-03-10 ISRAEL Rabinowitz, Inc. d/b/a Bluelight Strategies 7094 2022-03-10 Rabinowitz, Inc. d/b/a Bluelight Strategies 9 Hamada St. Gav-Yam, North Building P.O.B. 4166   Herzliya    
7298 7298 2022-05-31 U.S.- China Transpacific Foundation 2017-09-15 CHINA Capitol Counsel, LLC 6328 2015-11-19 Capitol Counsel, LLC 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141

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