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

16 rows where Foreign_Principal = "Federal Republic of Nigeria"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 2

State 1

  • - 16

Foreign_Principal 1

  • Federal Republic of Nigeria · 16 ✖

Country/Location_Represented 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
1206 1206 1982-01-11 Federal Republic of Nigeria 1980-08-26 NIGERIA B&C International, Inc. 3141 1980-08-26 B&C International, Inc. Lagos        
1207 1207 1982-01-11 Federal Republic of Nigeria 1980-08-26 NIGERIA B&C Associates, Inc. 3142 1980-08-26 B&C Associates, Inc. Lagos        
2651 2651 1992-02-18 Federal Republic of Nigeria 1991-10-21 NIGERIA Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Lagos        
6916 6916 2015-05-29 Federal Republic of Nigeria 2015-01-16 NIGERIA IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc BLock B" Federal Secretariat Area 1 Abuja"      
6917 6917 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    
9001 9001 1996-07-04 Federal Republic of Nigeria 1995-07-17 NIGERIA Barron-Birrell, Inc. 4729 1992-11-02 Barron-Birrell, Inc. Abuja        
10120 10120 1969-08-04 Federal Republic of Nigeria 1968-07-30 NIGERIA Burson-Marsteller Associates 2096 1968-07-30 Burson-Marsteller Associates Lagos        
11128 11128 2009-08-31 Federal Republic of Nigeria 2007-09-21 NIGERIA Watts Partners (J.C. Watts Companies) 5641 2004-08-27 Watts Partners (J.C. Watts Companies) Maputo Street, Wuse Zone 3, P.M.N. 130 Garki, Abuja      
12396 12396 2005-10-01 Federal Republic of Nigeria 1990-04-09 NIGERIA White & Case, LLP 2759 1977-03-09 White & Case, LLP Lagos        
12479 12479 2019-10-04 Federal Republic of Nigeria 2019-05-02 NIGERIA Pagefield Global 6675 2019-05-02 Pagefield Global Plot 71b, Shehu Shagari Way, Maitama Abuja, PMB 192 Garki        
12893 12893 1993-10-21 Federal Republic of Nigeria 1992-11-02 NIGERIA Barron-Birrell, Inc. 4729 1992-11-02 Barron-Birrell, Inc. Abuja        
13378 13378 1998-10-31 Federal Republic of Nigeria 1998-10-15 NIGERIA EAW Group, Inc. 5284 1998-10-15 EAW Group, Inc. Abuja        
15187 15187 1993-12-17 Federal Republic of Nigeria 1982-01-11 NIGERIA Prather, Seeger, Doolittle & Farmer 1815 1964-11-13 Prather, Seeger, Doolittle & Farmer Lagos        
15305 15305 2012-12-21 Federal Republic of Nigeria 2010-01-20 NIGERIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Ministry of Foreign Affairs Maputo Street, Wuse Zone 3, P.M.B. 130 Garki, Abuja      
16198 16198 1991-12-31 Federal Republic of Nigeria 1990-11-14 NIGERIA Edward Aycoth & Company, Inc. 4436 1990-11-14 Edward Aycoth & Company, Inc. Lagos        
16454 16454 1999-12-31 Federal Republic of Nigeria 1998-03-03 NIGERIA Davis Manafort & Freedman, Inc. 5240 1998-03-03 Davis Manafort & Freedman, Inc. 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])
);