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

41 rows where Registration_Number = 5430

View and edit SQL

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

State

Registrant_Name

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
8   Government of the People's Republic of Bangladesh, Embassy 2013-09-23 BANGLADESH 5430 5430 2001-05-10 BGR Government Affairs, LLC 3510 International Drive, NW   Washington DC 20008
95   China-United States Exchange Foundation 2019-03-01 CHINA 5430 5430 2001-05-10 BGR Government Affairs, LLC 20/F, Yardley Commercial Building No. 3 Connaught Road West Sheung Wan, Hong Kong      
163   Embassy of Kazakhstan USA 2020-05-01 KAZAKHSTAN 5430 5430 2001-05-10 BGR Government Affairs, LLC 1401 16th St. NW   Washington DC 20036
170   Embassy of the Bolivarian Republic of Venezuela 2019-04-12 VENEZUELA 5430 5430 2001-05-10 BGR Government Affairs, LLC     Washington DC  
173   Embassy of the Kingdom of Bahrain to the United States of America 2018-06-12 BAHRAIN 5430 5430 2001-05-10 BGR Government Affairs, LLC 3502 International Drive, NW   Washington DC 20008
179   Embassy of the Republic of Azerbaijan 2017-03-20 AZERBAIJAN 5430 5430 2001-05-10 BGR Government Affairs, LLC 2741 34th Street, NW   Washington DC 20008
189   Embassy of the Republic of Korea 2018-06-26 KOREA, SOUTH 5430 5430 2001-05-10 BGR Government Affairs, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
263   Government of Honduras 2020-01-16 HONDURAS 5430 5430 2001-05-10 BGR Government Affairs, LLC          
315   Hong Kong Trade Development Council 2019-04-05 HONG KONG 5430 5430 2001-05-10 BGR Government Affairs, LLC 219 East 46th Street   New York NY 10017
389   Kurdish Regional Government (formerly known as Kurdish Democratic Party) 2004-06-25 IRAQ 5430 5430 2001-05-10 BGR Government Affairs, LLC 1015 18th Street, N.W. Suite 704   Washington DC 20036
428   Minister of National Defense for Republic of Poland 2019-02-09 POLAND 5430 5430 2001-05-10 BGR Government Affairs, LLC Al. Niepodleglosci 218, 00-909   Warszawa    
507   Polska Grupa Zbrojeniowa 2017-11-20 POLAND 5430 5430 2001-05-10 BGR Government Affairs, LLC ul. Nowy Swiat 4a, 00-497 Warszawa      
547   Republic of India, Embassy 2005-09-12 INDIA 5430 5430 2001-05-10 BGR Government Affairs, LLC 2107 Massachusetts Avenue, NW   Washington DC 20008
1738 2004-01-31 Antonov Aircraft Corporation 2003-11-24 UKRAINE 5430 5430 2001-05-10 BGR Government Affairs, LLC 1100 Lee Wagener Boulevard #208 FLL International Airport Ft. Lauderdale 33315     FL  
1763 2008-01-31 Iraqi National Accord 2007-08-20 IRAQ 5430 5430 2001-05-10 BGR Government Affairs, LLC al-Zaytoun Street al-Harthia District Baghdad    
1785 2014-01-31 BGR Gabara, Ltd. (for the Embassy of Kazakhstan, London UK) 2011-04-11 KAZAKHSTAN 5430 5430 2001-05-10 BGR Government Affairs, LLC 1 Duchess Street, London WIW 6AN        
1799 2017-01-31 Democratic Republic of the Congo 2016-09-06 CONGO, REPUBLIC OF THE 5430 5430 2001-05-10 BGR Government Affairs, LLC          
4502 2012-03-31 BGR Gabara, Ltd. (for Bidzina Ivanishvili) 2011-11-28 GEORGIA 5430 5430 2001-05-10 BGR Government Affairs, LLC 1 Duchess Street London, WIW 6AN      
4504 2012-03-31 BGR Gabara, Ltd. (for Free Democrats) 2011-07-22 GEORGIA 5430 5430 2001-05-10 BGR Government Affairs, LLC 1 Duchess Street London, WIW 6AN      
4518 2013-03-31 Government of Mauritius 2012-04-20 MAURITIUS 5430 5430 2001-05-10 BGR Government Affairs, LLC 211 East 43rd Street, Suite 1502   New York NY 10017
4982 2005-04-13 Republic of Equatorial Guinea (through Farragut Advisors (E.G.), LLC) 2004-12-14 EQUATORIAL GUINEA 5430 5430 2001-05-10 BGR Government Affairs, LLC 375 Park Avenue 10152     NY  
5098 2019-04-17 Ambassador Carlos Vecchio Embassy of the Bolivarian Republic of Venezuela 2019-04-17 VENEZUELA 5430 5430 2001-05-10 BGR Government Affairs, LLC     Washington DC  
5950 2019-05-01 National Reforms Council of Ukraine 2017-01-01 UKRAINE 5430 5430 2001-05-10 BGR Government Affairs, LLC 11 Bankova Str. 01220, Kyiv        
6890 2008-05-31 Serbia (through Serbian-American Center) 2006-07-21 SERBIA 5430 5430 2001-05-10 BGR Government Affairs, LLC Serbian- American Center Pariska 13 11000 Belgrade, Republic of Serbia      
6902 2010-05-31 Embassy of Poland 2008-05-28 POLAND 5430 5430 2001-05-10 BGR Government Affairs, LLC 2640 16th Street, NW   Washington DC 20009
6920 2014-05-31 Royal Thai Embassy, Washington, DC 2012-10-01 THAILAND 5430 5430 2001-05-10 BGR Government Affairs, LLC          
6927 2015-05-31 State of Qatar, Embassy 2004-12-14 QATAR 5430 5430 2001-05-10 BGR Government Affairs, LLC Embassy of the State of Qatar 4200 Wisconsin Avenue, NW 20016     DC  
8262 2004-06-30 Embassy of Honduras 2002-11-27 HONDURAS 5430 5430 2001-05-10 BGR Government Affairs, LLC 3007 Tilden Street, N.W. Suite 4M 20008     DC  
8282 2006-06-30 Embassy of the State of Eritrea 2006-02-03 ERITREA 5430 5430 2001-05-10 BGR Government Affairs, LLC 1708 New Hampshire Avenue, NW   Washington DC 20009
9424 2002-07-31 Government of Macedonia Ministry of Finance 2001-05-10 MACEDONIA 5430 5430 2001-05-10 BGR Government Affairs, LLC Dame gruev, 14 1000 Skopje        
9681 2018-08-03 Center for Studies and Media Affairs at the Saudi Royal Court 2016-03-15 SAUDI ARABIA 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 New Hampshire Avenue, NW   Washington DC 20037
10109 2019-08-15 Ministry of Finance, Federal Republic of Somailia 2018-05-01 SOMALI DEMOCRATIC REPUBLIC 5430 5430 2001-05-10 BGR Government Affairs, LLC Villa Somalia, Ministry of Finance Mogadishu Banadir Region      
10624 2002-08-31 Embassy of the Republic of Bolivia 2002-05-02 BOLIVIA 5430 5430 2001-05-10 BGR Government Affairs, LLC 3014 Massachusetts Avenue, N.W.     DC  
10666 2007-08-31 Republic of China (Taiwan) 2005-03-15 TAIWAN 5430 5430 2001-05-10 BGR Government Affairs, LLC National Security Council No. 122, Sec. 1, Chungching S. Road   Taipai    
11676 2006-09-30 National Dialogue Party of Lebanon 2006-06-05 LEBANON 5430 5430 2001-05-10 BGR Government Affairs, LLC Dona Maria Str. Marj el Zouhour Bldg. Rass El Nabeh Beirut    
12254 2018-10-17 The Embassy of The Kingdom of Saudi Arabia 2018-08-14 SAUDI ARABIA 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 New Hampshire Ave NW   Washington    
15871 2002-12-31 Embassy of the Republic of Mexico 2001-10-02 MEXICO 5430 5430 2001-05-10 BGR Government Affairs, LLC 1911 Pennsylvania Avenue, N.W. 20006     DC  
16092 2013-12-31 Republic of The Gambia 2013-07-10 GAMBIA, THE 5430 5430 2001-05-10 BGR Government Affairs, LLC Ministry of Information and Communication Infrastructure GRTS Building, MDI Road, Kanifing The Gambia, West Africa      
16137 2016-12-31 Embassy of the Republic of Korea 2015-04-17 KOREA, SOUTH 5430 5430 2001-05-10 BGR Government Affairs, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
16197 2019-12-31 Aviora Consult EAD (on behalf of Delyan Peevski 2017-09-07 BULGARIA 5430 5430 2001-05-10 BGR Government Affairs, LLC Sofia 1000 29 Hristo Belchev Street, entr. A, 4th fl      
16213 2019-12-31 Thaksin Shinawatra 2011-06-30 THAILAND 5430 5430 2001-05-10 BGR Government Affairs, LLC          

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