FARA_All_ForeignPrincipals

Table actions
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: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

Registrant_Name

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