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

8 rows where City = "Abuja"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 8

  • APCO Worldwide, Inc. 1
  • Adams, Gregory Robert 1
  • Business Council for International Understanding, Inc. (BCIU) 1
  • Cassidy & Associates, Inc. 1
  • Coltrin & Associates, Inc. 1
  • Fleishman-Hillard, Inc. 1
  • Hill and Knowlton Strategies, LLC 1
  • KRL International, LLC 1

Foreign_Principal 8

  • Abubakar, Atibu (through Weidenfeld Law Firm) 1
  • Abubakar, Atiku 1
  • Economic & Financial Crimes Commission of Nigeria 1
  • Federal Republic of Nigeria 1
  • Ministry of Solid Minerals Development 1
  • Nigerian Investment Promotion Commission 1
  • Nigerian Investment Promotion Commission through Business Council for InterNatl Understanding (BCIU) 1
  • Office of the President of the Federal Republic of Nigeria 1

State 1

  • - 8

Country/Location_Represented 1

  • NIGERIA 8

City 1

  • Abuja · 8 ✖
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
1623 1623 2007-01-30 Ministry of Solid Minerals Development 2006-09-29 NIGERIA Adams, Gregory Robert 5771 2006-09-29 Adams, Gregory Robert Annex 3, 5th Floor, Federal Secretariat Shehu Shagari Way, P.M.B. 107 Abuja    
2039 2039 2008-02-01 Economic & Financial Crimes Commission of Nigeria 2007-11-23 NIGERIA KRL International, LLC 5788 2007-01-26 KRL International, LLC EFFC Abuja Office 5 Formella Street, Off Adetokunbo Ademola Crescent, Wuse II Abuja    
5970 5970 2006-04-30 Nigerian Investment Promotion Commission 2005-10-19 NIGERIA Business Council for International Understanding, Inc. (BCIU) 5713 2005-10-19 Business Council for International Understanding, Inc. (BCIU) Plot 1181, Aguiyi Ironsi St. Maitama District, P.M.B. 381 Garki Abuja    
6857 6857 2015-05-29 Federal Republic of Nigeria 2015-01-16 NIGERIA Cassidy & Associates, Inc. 6272 2015-01-16 Cassidy & Associates, Inc. Block B" Federal Secretariat Area 1"   Abuja    
7377 7377 2007-06-01 Abubakar, Atiku 2007-05-10 NIGERIA APCO Worldwide, Inc. 4561 1991-09-03 APCO Worldwide, Inc. Democracy House Gimbya Street, Garki, Area 11 Abuja    
13365 13365 2010-10-31 Office of the President of the Federal Republic of Nigeria 2010-10-08 NIGERIA Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. State House   Abuja    
15301 15301 2006-12-26 Nigerian Investment Promotion Commission through Business Council for InterNatl Understanding (BCIU) 2006-12-26 NIGERIA Coltrin & Associates, Inc. 5782 2006-12-26 Coltrin & Associates, Inc. Plot 1181, Aguiyi Ironsi Street Maitama District, P.M.B. 381 Garki Abuja    
16525 16525 2007-12-31 Abubakar, Atibu (through Weidenfeld Law Firm) 2006-05-22 NIGERIA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Office of the Vice President Presidential Villa Asorock Abuja    

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