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

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)

State 1

  • - 8

Country/Location_Represented 1

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