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

9 rows where Registration_Number = 6379

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal 9

  • Agility Public Warehousing Company K.S.C.P. through Quinn Emanuel Urquhart & Sullivan, LLP 1
  • Bader El-Jeaan through Quinn Emanuel Urquhart & Sullivan, LLP 1
  • Center for Studies and Media Affairs at the Saudi Royal Court 1
  • Embassy of the State of Qatar through Venable LLP 1
  • Federal Democratic Republic of Ethiopia 1
  • Government of Catalonia 1
  • Inovo BV through Flynn Intel Group, Inc. 1
  • Ministry of Foreign Affairs and International Cooperation of the Kingdom of Morocco (through JPC Strategies LLC) 1
  • Partido Alianza Republicana Nacionalista (ARENA) And El Salvador Presidental candidate, Carlos Calleja 1

Country/Location_Represented 8

  • KUWAIT 2
  • EL SALVADOR 1
  • ETHIOPIA 1
  • MOROCCO 1
  • QATAR 1
  • SAUDI ARABIA 1
  • SPAIN 1
  • TURKEY 1

City 3

  • - 5
  • Washington 3
  • San Salvador 1

State 2

  • - 6
  • DC 3

Registrant_Name 1

  • S.G.R. LLC Government Relations and Lobbying 9
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
216 216   Embassy of the State of Qatar through Venable LLP 2018-02-05 QATAR S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 2555 M Street, NW   Washington DC 20037
1572 1572 2021-01-27 Ministry of Foreign Affairs and International Cooperation of the Kingdom of Morocco (through JPC Strategies LLC) 2018-01-12 MOROCCO S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 7 rue F. Roosevelt Rabat      
5439 5439 2018-04-20 Federal Democratic Republic of Ethiopia 2017-01-27 ETHIOPIA S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 3506 International Drive, NW   Washington DC 20008
12429 12429 2020-10-01 Agility Public Warehousing Company K.S.C.P. through Quinn Emanuel Urquhart & Sullivan, LLP 2019-08-06 KUWAIT S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying P.O. Box 25418 Safet 13115      
13145 13145 2019-10-29 Bader El-Jeaan through Quinn Emanuel Urquhart & Sullivan, LLP 2019-08-06 KUWAIT S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying Jaber Al-Mubarak Street Al Kuwayt      
13493 13493 2018-10-31 Partido Alianza Republicana Nacionalista (ARENA) And El Salvador Presidental candidate, Carlos Calleja 2018-09-13 EL SALVADOR S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying Prolognacion Calle Arce, entre 45 y 46 avenida norte No. 2429   San Salvador    
14000 14000 2016-11-15 Inovo BV through Flynn Intel Group, Inc. 2017-03-07 TURKEY S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying INOVO BV - 27 Adireaanstraat, 3581 SC Utrecht        
14003 14003 2018-11-15 Government of Catalonia 2017-08-28 SPAIN S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1050 K Street, NW Suite 325 Washington DC 20001
15214 15214 2016-12-18 Center for Studies and Media Affairs at the Saudi Royal Court 2016-09-20 SAUDI ARABIA S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying Al Riyadh PO Box 11111        

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 625.22ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows