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

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

State

  • 8

Country/Location_Represented

City

  • 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
1543 2007-01-30 Ministry of Solid Minerals Development 2006-09-29 NIGERIA 5771 5771 2006-09-29 Adams, Gregory Robert Annex 3, 5th Floor, Federal Secretariat Shehu Shagari Way, P.M.B. 107 Abuja    
1946 2008-02-01 Economic & Financial Crimes Commission of Nigeria 2007-11-23 NIGERIA 5788 5788 2007-01-26 KRL International, LLC EFFC Abuja Office 5 Formella Street, Off Adetokunbo Ademola Crescent, Wuse II Abuja    
5747 2006-04-30 Nigerian Investment Promotion Commission 2005-10-19 NIGERIA 5713 5713 2005-10-19 Business Council for International Understanding, Inc. (BCIU) Plot 1181, Aguiyi Ironsi St. Maitama District, P.M.B. 381 Garki Abuja    
6593 2015-05-29 Federal Republic of Nigeria 2015-01-16 NIGERIA 6272 6272 2015-01-16 Cassidy & Associates, Inc. Block B" Federal Secretariat Area 1"   Abuja    
7096 2007-06-01 Abubakar, Atiku 2007-05-10 NIGERIA 4561 4561 1991-09-03 APCO Worldwide, Inc. Democracy House Gimbya Street, Garki, Area 11 Abuja    
12882 2010-10-31 Office of the President of the Federal Republic of Nigeria 2010-10-08 NIGERIA 5801 5801 2007-04-16 Fleishman-Hillard, Inc. State House   Abuja    
14750 2006-12-26 Nigerian Investment Promotion Commission through Business Council for InterNatl Understanding (BCIU) 2006-12-26 NIGERIA 5782 5782 2006-12-26 Coltrin & Associates, Inc. Plot 1181, Aguiyi Ironsi Street Maitama District, P.M.B. 381 Garki Abuja    
15968 2007-12-31 Abubakar, Atibu (through Weidenfeld Law Firm) 2006-05-22 NIGERIA 3301 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 · Query took 164.123ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history