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

16 rows where Registrant_Name = "Bannerman & Associates, Inc."

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal 15

  • Government of the Philippines 2
  • Arab Republic of Egypt 1
  • Embassy of El Salvador 1
  • Embassy of Lebanon 1
  • Embassy of the Republic of Djibouti 1
  • Government of Bangladesh 1
  • Government of Kazakhstan 1
  • Government of Tunisia 1
  • Government of the Philippines, Embassy 1
  • Government of the Republic of the Philippines 1
  • Government of the United Arab Emirates 1
  • Kestral Trading Company 1
  • Office of the President, Palestinian Authority 1
  • Palestinian Authority 1
  • Philippine Coconut Authority 1

Country/Location_Represented 10

  • PHILIPPINES 5
  • PALESTINE 2
  • UNITED ARAB EMIRATES 2
  • BANGLADESH 1
  • EGYPT 1
  • EL SALVADOR 1
  • KAZAKHSTAN 1
  • LEBANON 1
  • PAKISTAN 1
  • TUNISIA 1

State 2

  • - 9
  • DC 7

City 2

  • - 15
  • Ramallah 1

Registrant_Name 1

  • Bannerman & Associates, Inc. · 16 ✖
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
947 947 1992-01-01 Government of Tunisia 1988-05-10 TUNISIA Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Washington     DC  
948 948 1992-01-01 Government of the Republic of the Philippines 1988-08-04 PHILIPPINES Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Manila        
1001 1001 2007-01-01 Office of the President, Palestinian Authority 2006-03-14 PALESTINE Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc.     Ramallah    
2264 2264 1991-02-07 Government of Bangladesh 1988-04-07 BANGLADESH Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Dhaka        
2565 2565 2006-02-15 Palestinian Authority 1999-12-06 PALESTINE Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Ramallah, West Bank        
3080 3080 2007-02-28 Arab Republic of Egypt 1990-03-22 EGYPT Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Cairo        
4648 4648 2006-03-31 Embassy of El Salvador 1993-07-29 EL SALVADOR Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Washington     DC  
5625 5625 1998-04-27 Government of the Philippines 1994-06-01 PHILIPPINES Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Washington     DC  
5626 5626 1998-04-27 Government of the Philippines, Embassy 1994-06-01 PHILIPPINES Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Washington     DC  
9751 9751 1988-07-31 Philippine Coconut Authority 1988-05-10 PHILIPPINES Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Quezon City        
11676 11676 2004-09-16 Kestral Trading Company 2004-05-27 PAKISTAN Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Suite #8 Ground Floor Evacuee Trust Complex Sir Agha Khan Road F-5/1, Islamabad        
11992 11992 1988-09-30 Embassy of Lebanon 1987-04-28 LEBANON Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Washington     DC  
13107 13107 1999-10-28 Government of the United Arab Emirates 1991-08-09 UNITED ARAB EMIRATES Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Abu Dhabi        
13422 13422 2005-10-31 Government of the Philippines 2001-07-19 PHILIPPINES Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 1600 Massachusetts Avenue, N.W. 20036     DC  
14279 14279 1992-11-27 Embassy of the Republic of Djibouti 1991-04-18 UNITED ARAB EMIRATES Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Washington     DC  
16499 16499 2001-12-31 Government of Kazakhstan 2001-10-23 KAZAKHSTAN Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. Almaty        

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