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

26 rows where Registration_Number = 4776

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal 24

  • Republic of Guyana 2
  • Republic of Uganda, Embassy 2
  • Agexpront 1
  • Corporation for the Promotion of Exports and Investments of Ecuador 1
  • Democracy & Dignity Foundation 1
  • Embassy of El Salvador 1
  • Government of Bangladesh 1
  • Government of Honduras 1
  • Government of Honduras, Embassy 1
  • Government of Rwanda 1
  • Government of the People's Democratic Republic of Algeria, Embassy 1
  • Herty Alianza 2006 1
  • Interim Government of National Unity of the Republic of Liberia 1
  • Republic of Djibouti 1
  • Republic of Guatemala 1
  • Republic of Haiti 1
  • Republic of Kenya 1
  • Republic of Mauritius 1
  • Republic of Nicaragua 1
  • Saharawi Arab Democratic Republic 1
  • Supreme Court of Justice of the Republic of Guatemala 1
  • United Coconut Association of the Philippines 1
  • United Front for Multiparty Democracy in Malawi 1
  • United Republic of Tanzania 1

Country/Location_Represented 19

  • GUATEMALA 3
  • ALGERIA 2
  • GUYANA 2
  • HONDURAS 2
  • NICARAGUA 2
  • UGANDA 2
  • BANGLADESH 1
  • DJIBOUTI 1
  • ECUADOR 1
  • EL SALVADOR 1
  • FRANCE 1
  • HAITI 1
  • KENYA 1
  • LIBERIA 1
  • MALAWI 1
  • MAURITIUS 1
  • PHILIPPINES 1
  • RWANDA 1
  • TANZANIA 1

City 5

  • - 19
  • Washington 4
  • Guayaquil 1
  • Managua 1
  • New York 1

State 3

  • - 20
  • DC 5
  • NY 1

Registrant_Name 1

  • Foley Hoag, LLP 26
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
1222 1222 1994-01-11 Interim Government of National Unity of the Republic of Liberia 1993-03-03 LIBERIA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Monrovia        
1224 1224 1994-01-11 United Coconut Association of the Philippines 1993-03-03 PHILIPPINES Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Manila        
1841 1841 2002-01-31 Republic of Uganda, Embassy 2001-02-13 UGANDA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP 5911 16th Street, N.W.     DC  
3064 3064 2004-02-28 Republic of Haiti 2003-04-24 HAITI Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Palais National Port-au-Prince        
4561 4561 1998-03-31 Government of Honduras 1996-04-26 HONDURAS Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Tegucigalpa        
4676 4676 2007-03-31 Government of Honduras, Embassy 2006-05-24 HONDURAS Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP 3007 Tilden Street, N.W., POD 4M   Washington DC 20008
4729 4729 2013-03-31 Corporation for the Promotion of Exports and Investments of Ecuador 2007-04-02 ECUADOR Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Cdla. Kennedy Norte, Avda. Francisco de Orellana y Miguel H. Alcivar Edificio Centro Empresarial Las Camaras, Torre de Oficinas, 2 do piso Guayaquil    
4737 4737 2013-03-31 Republic of Djibouti 2004-08-10 DJIBOUTI Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Ministry of Foreign Relations        
4738 4738 2013-03-31 Republic of Guyana 2004-04-09 GUYANA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Ministry of Foreign Relations Georgetown        
4798 4798 2021-03-31 Government of the People's Democratic Republic of Algeria, Embassy 2007-05-25 ALGERIA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP 2118 Kalorama Road, NW   Washington DC 20008
4816 4816 2022-03-31 Republic of Mauritius 2019-09-06 MAURITIUS Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP 211 East 43rd Street 22nd Floor New York NY 10017
5298 5298 1995-04-15 United Republic of Tanzania 1994-01-11 TANZANIA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Dar Es Salaam        
5304 5304 1999-04-15 Republic of Uganda, Embassy 1994-01-11 UGANDA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Entebbe        
6026 6026 2006-04-30 Embassy of El Salvador 2006-04-06 EL SALVADOR Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP 2308 California Street, NW   Washington DC 20008
6027 6027 2006-04-30 Herty Alianza 2006 2006-04-06 NICARAGUA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Primavera entrada Las Colinas Pollos Tip Top 80 Varas Abajo, Casa #6 Managua    
7197 7197 2003-05-31 Republic of Kenya 2003-01-06 KENYA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Nairobi        
12079 12079 1996-09-30 Government of Rwanda 1996-04-26 RWANDA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Kigali        
12149 12149 2003-09-30 Republic of Guatemala 2000-02-09 GUATEMALA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Guatemala City        
12585 12585 2001-10-10 Agexpront 2001-04-30 GUATEMALA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP 15 Avenida 14-72 Zona 13 Guatemala, CA 01013        
15321 15321 1994-12-22 Democracy & Dignity Foundation 1993-05-20 FRANCE Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Neuilly/Seine        
15324 15324 1994-12-22 Saharawi Arab Democratic Republic 1993-03-03 ALGERIA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Tindouf        
15325 15325 1994-12-22 Supreme Court of Justice of the Republic of Guatemala 1993-03-03 GUATEMALA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Guatemala City        
15326 15326 1994-12-22 United Front for Multiparty Democracy in Malawi 1993-03-03 MALAWI Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Lusaka        
15391 15391 2013-12-26 Government of Bangladesh 2013-06-12 BANGLADESH Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP 3510 International Drive, NW   Washington DC 20008
16403 16403 1996-12-31 Republic of Nicaragua 1993-03-02 NICARAGUA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Managua        
16507 16507 2001-12-31 Republic of Guyana 1993-03-03 GUYANA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Georgetown        

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 292.603ms · 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