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

10 rows where Country/Location_Represented = "BENIN"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 8

  • Squire Patton Boggs, LLP 2
  • van Kloberg & Associates, Ltd. 2
  • Future Pact LLC 1
  • GoodWorks International, LLC 1
  • Portland PR Inc. 1
  • Sanitas International 1
  • Sanitas International, Inc. 1
  • Washington World Group, Ltd. 1

Foreign_Principal 8

  • Alliance PNE 2
  • Republic of Benin 2
  • Embassy of Benin 1
  • Embassy of the Republic of Benin 1
  • Government of Benin 1
  • Office of the Presidency of the Republic of Benin 1
  • Presidency of the Republic of Benin (through Portland PR Limited) 1
  • Rogatien Biaou 1

City 3

  • - 6
  • Cotonou 2
  • Washington 2

State 2

  • - 6
  • DC 4

Country/Location_Represented 1

  • BENIN · 10 ✖
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
538 538   Office of the Presidency of the Republic of Benin 2022-02-14 BENIN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Route de l'Aeroport 01 BP 301   Cotonou    
932 932 1991-01-01 Embassy of Benin 1991-01-25 BENIN van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
7287 7287 2021-05-31 Alliance PNE 2021-03-15 BENIN Sanitas International, Inc. 6530 2018-03-07 Sanitas International, Inc. 2134 Kalorama Road, NW   Washington DC 20008
9773 9773 1990-07-31 Embassy of the Republic of Benin 1990-06-22 BENIN van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
9914 9914 2017-07-31 Presidency of the Republic of Benin (through Portland PR Limited) 2017-09-29 BENIN Portland PR Inc. 6064 2011-09-19 Portland PR Inc. Palais de la Marina Littoral, Cotonou 01BP 2028        
11903 11903 2021-09-29 Alliance PNE 2021-07-22 BENIN Sanitas International 6980 2021-07-22 Sanitas International 2134 Kalorama Road NW   Washington DC 20008
12069 12069 1995-09-30 Republic of Benin 1995-07-10 BENIN Washington World Group, Ltd. 5016 1995-04-20 Washington World Group, Ltd. Cotonou        
12285 12285 2022-09-30 Rogatien Biaou 2022-06-09 BENIN Future Pact LLC 7074 2022-01-27 Future Pact LLC          
14177 14177 2007-11-22 Government of Benin 2007-05-02 BENIN GoodWorks International, LLC 5414 2001-03-02 GoodWorks International, LLC Ministry of Development/Finance   Cotonou    
16506 16506 2001-12-31 Republic of Benin 1999-07-08 BENIN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Minister of Finance B.P. 301 Benin, West Africa        

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