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

34 rows where Registrant_Name = "Podesta Group, Inc." sorted by Registrant_Name

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal >30

  • Republic of Korea, Embassy 2
  • Republic of South Sudan 2
  • Center for Studies and Media Affairs at Saudi Royal Court 1
  • Democratic Party of Albania 1
  • Democratic Party of Moldova 1
  • Embassy of Japan 1
  • Embassy of the Republic of Azerbaijan 1
  • Embassy of the Socialist Republic of Vietnam 1
  • European Centre for a Modern Ukraine 1
  • Federal Media Partner 1
  • Federal Republlc of Somalia 1
  • Government of Morocco, Embassy (through Private Public Solutions) 1
  • Government of Thailand, Embassy 1
  • Government of the Arab Republic of Egypt, Embassy, through the PLM Group 1
  • Hong Kong Trade Development Council 1
  • Mr. Salman Al-Ansari (through Saudi American Public Relation Affairs Committee, Inc.) 1
  • National Security Council of Georgia 1
  • Ocean Advisory & Consulting W.L.L. through Andreae & Associates 1
  • Republic of Albania 1
  • Republic of Cyprus, Embassy 1
  • Republic of India, Embassy 1
  • Republic of Iraq 1
  • Republic of Kenya 1
  • Republic of Korea Embassy (through Porter Gordon Silver Communications, LLC) 1
  • Republic of Kosova 1
  • Republic of Kosovo, Embassy 1
  • Republic of Maldives 1
  • Republic of the Union of Myanmar 1
  • Saudi Arabian Oil Company through White & Case LLP 1
  • Swiss Confederation, Embassy through Daniel J. Edelman, Inc. 1
  • …

Country/Location_Represented 26

  • KOREA, SOUTH 3
  • SAUDI ARABIA 3
  • AFGHANISTAN 2
  • ALBANIA 2
  • KOSOVA 2
  • REPUBLIC OF SOUTH SUDAN 2
  • AZERBAIJAN 1
  • CYPRUS 1
  • EGYPT 1
  • GEORGIA 1
  • HONG KONG 1
  • INDIA 1
  • IRAQ 1
  • JAPAN 1
  • KENYA 1
  • MALDIVES 1
  • MOLDOVA 1
  • MOROCCO 1
  • MYANMAR (BURMA) 1
  • QATAR 1
  • ROMANIA 1
  • SOMALI DEMOCRATIC REPUBLIC 1
  • SWITZERLAND 1
  • THAILAND 1
  • UKRAINE 1
  • VIETNAM 1

City 9

  • Washington 15
  • - 12
  • Doha 1
  • Mogadishu 1
  • New York 1
  • Prishtina 1
  • Springfield 1
  • Tbilisi 1
  • Tirane 1

State 4

  • - 17
  • DC 15
  • NY 1
  • VA 1

Registrant_Name 1

  • Podesta Group, Inc. · 34 ✖
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
1567 1567 2012-01-27 Government of the Arab Republic of Egypt, Embassy, through the PLM Group 2009-04-01 EGYPT Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 3521 International Court, NW   Washington DC 20008
3109 3109 2014-02-28 Republic of Kosova 2012-03-13 KOSOVA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. Mother Teresa Street, No. 36   Prishtina    
3919 3919 2017-03-20 Ocean Advisory & Consulting W.L.L. through Andreae & Associates 2016-11-08 QATAR Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. Building 75, Zone 39 Al Sadd Street, No. 343 PO 31978 Doha    
4761 4761 2016-03-31 Republic of the Union of Myanmar 2015-04-10 MYANMAR (BURMA) Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 2300 S Street, NW   Washington DC 20008
5085 5085 2016-04-07 Republic of Korea, Embassy 2014-07-10 KOREA, SOUTH Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 2450 Massachusetts Avenue, NW   Washington DC 20008
5315 5315 2016-04-15 Democratic Party of Albania 2016-03-09 ALBANIA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. Rr. Zhan D'Ark, nr. 11 Tirana      
6077 6077 2014-04-30 European Centre for a Modern Ukraine 2017-04-12 UKRAINE Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 14 Rue de la Science 1040 Brussels      
6650 6650 2011-05-18 Government of Thailand, Embassy 2010-06-03 THAILAND Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. Royal Thai Embassy 1024 Wisconsin Avenue, NW Washington DC 20007
7273 7273 2017-05-31 Republic of Iraq 2013-02-13 IRAQ Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 3421 Massachusetts Avenue, NW   Washington DC 20007
8666 8666 2007-06-30 Government of Morocco, Embassy (through Private Public Solutions) 2007-05-18 MOROCCO Podesta Group, Inc. 5813 2007-05-18 Podesta Group, Inc. 1601 21st Street, NW   Washington DC 20009
8742 8742 2017-06-30 Embassy of the Socialist Republic of Vietnam 2013-12-12 VIETNAM Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1233 20th Street, NW Suite 400 Washington DC 20036
8746 8746 2017-06-30 Republic of Kosovo, Embassy 2016-03-11 KOSOVA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 2175 K Street, NW #300 Washington DC 20037
8937 8937 2015-07-01 Transformation and Continuity through Roberti White, LLC 2015-02-27 AFGHANISTAN Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 8105 Ainsworth Avenue   Springfield VA 22152
9226 9226 2014-07-13 Federal Republlc of Somalia 2013-09-16 SOMALI DEMOCRATIC REPUBLIC Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. Corso Somalia 55 P.O. Box 11 Mogadishu    
10049 10049 2015-08-01 Republic of South Sudan 2014-03-11 REPUBLIC OF SOUTH SUDAN Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. Juba        
11726 11726 2017-09-19 Mr. Salman Al-Ansari (through Saudi American Public Relation Affairs Committee, Inc.) 2017-08-15 SAUDI ARABIA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. c/o SAPRAC Inc. 1101 30th Street, NW Suite 315 Washington DC 20006
12218 12218 2013-09-30 Republic of Cyprus, Embassy 2012-11-08 CYPRUS Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc.          
12496 12496 2015-10-05 Republic of Kenya 2015-02-10 KENYA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. Old Treasury Building Harambee Avenue Nairobi      
12781 12781 2017-10-16 Republic of India, Embassy 2010-11-05 INDIA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 2107 Massachusetts Avenue, NW   Washington DC 20008
13463 13463 2013-10-31 Republic of Albania 2011-04-15 ALBANIA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. Blvd. Deshmoret e Kombit, No. 1   Tirane    
13909 13909 2015-11-12 Republic of Maldives 2015-09-17 MALDIVES Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 800 2nd Avenue, #400E   New York NY 10017
14139 14139 2014-11-21 Federal Media Partner 2014-10-10 ROMANIA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. Str. Mihai Bravu no. 85 Pliesti, Prahova, 100550        
14565 14565 2017-11-30 Embassy of Japan 2009-09-16 JAPAN Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 2520 Massachusetts Avenue, NW   Washington DC 20008
14567 14567 2017-11-30 Hong Kong Trade Development Council 2009-04-17 HONG KONG Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 36-9/F, Office Tower, Convention Plaza 1 Harbour Road      
14726 14726 2014-12-01 Transformation and Continuity (through Roberti White, LLC) 2014-10-03 AFGHANISTAN Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc.          
15306 15306 2016-12-21 Saudi Arabian Oil Company through White & Case LLP 2016-09-30 SAUDI ARABIA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. P.O. Box 5000 Dhahran 31311      
15392 15392 2017-12-26 Democratic Party of Moldova 2016-07-01 MOLDOVA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 32 Tighina Street MD-2001 Chisinau        
16671 16671 2009-12-31 Swiss Confederation, Embassy through Daniel J. Edelman, Inc. 2009-09-25 SWITZERLAND Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 2900 Cathedral Avenue, NW   Washington DC 20008
16716 16716 2012-12-31 National Security Council of Georgia 2010-02-03 GEORGIA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. Ingorokv st. 7   Tbilisi    
16720 16720 2012-12-31 Republic of Korea, Embassy 2011-07-29 KOREA, SOUTH Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 2450 Massachussets Avenue, NW   Washington DC 20008
16754 16754 2014-12-31 Republic of Korea Embassy (through Porter Gordon Silver Communications, LLC) 2014-10-06 KOREA, SOUTH Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 2450 Massachusetts Avenue, NW   Washington DC 20008
16772 16772 2015-12-31 Republic of South Sudan 2015-10-23 REPUBLIC OF SOUTH SUDAN Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. Juba        
16797 16797 2017-12-31 Center for Studies and Media Affairs at Saudi Royal Court 2015-09-17 SAUDI ARABIA Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. The Saudi Royal Court Al Riyadh P.O. Box 11111      
16800 16800 2017-12-31 Embassy of the Republic of Azerbaijan 2013-01-31 AZERBAIJAN Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 2741 34th Street, NW   Washington DC 20008

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