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

7 rows where City = "Brussels"

View and edit SQL

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

Country/Location_Represented

State

  • 7

City

  • Brussels · 7
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
237   Flanders Tourism Board 2007-11-15 BELGIUM 5840 5840 2007-11-15 Tourist Office for Flanders, Belgium - New York Office Grasmarkt 61, B-1000   Brussels    
1788 2012-01-31 Friends of Gilgit Baltistan (FOGB) 2011-07-26 PAKISTAN 6051 6051 2011-07-26 Institute for Gilgit Baltistan Studies (IGBS) 60, Rue Wiertz, ASP 10G107   Brussels    
6066 2014-05-08 European Centre For a Modern Ukraine 2017-04-28 UKRAINE 6170 6170 2013-05-14 Mercury Public Affairs, LLC 14 Rue de la Science, 1040   Brussels    
7483 2011-06-17 Albrecht, Jan Phillipp 2010-11-12 BELGIUM 6006 6006 2010-11-12 Ngo, Melissa ASP 08 H 246 Rue Wiertz 60 Brussels    
13836 2010-11-30 Jean-Paul Moka 2010-10-19 CONGO, REPUBLIC OF THE 6004 6004 2010-10-19 Reed International Law & Consulting LLC 92 Avenue de Polo 1150 Woluwe Saint Pierre   Brussels    
13839 2010-11-30 Tango Ekoki International 2010-10-19 CONGO, REPUBLIC OF THE 6004 6004 2010-10-19 Reed International Law & Consulting LLC 5 Place du Champ de Mars 21st Floor, B-1050 Brussels    
16012 2016-12-31 Belgian National Tourist Office 1948-06-17 BELGIUM 529 529 1948-06-17 Belgian National Tourist Office Grasmark 30   Brussels    

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