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

16,216 rows

View and edit SQL

State

Country/Location_Represented

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
101   Common Council of Iraqi and Arabic Tribes 2014-07-18 IRAQ 5974 5974 2010-02-18 Alsalih, Mark K. Hay Babel, Jadriyah #18 Baghdad      
102   Commonwealth of Dominica, Office of Ministry of Finance, Industry and Trade 1999-10-12 DOMINICA 5334 5334 1999-10-12 Commonwealth of Dominica Maritime Registry, Inc. Rosseau        
103   Concern Belneftekhim 2019-11-01 BELARUS 6706 6706 2019-08-12 Gencarelli, David F. pr. Dzerzhinskogo, 73 220116 Minsk      
104   Consulate General for Japan in Los Angeles 2019-04-09 JAPAN 6659 6659 2019-04-09 Community Partners 350 S. Grand Avenue   Los Angeles CA 90071
105   Consulate General of Japan in Atlanta 2018-10-15 JAPAN 6600 6600 2018-10-15 Taylor English Decisions, LLC 3438 Peachtree Road Phipps Tower, Suite 850 Atlanta GA 30326
106   Consulate General of Japan in Boston 2014-04-09 JAPAN 6213 6213 2014-04-09 Policy Agency, LLC Federal Reserve Plaza, 22nd Floor 600 Atlantic Avenue   Boston MA 02210
107   Consulate General of Japan in New York 2015-04-16 JAPAN 6289 6289 2015-04-16 Marathon Strategies, LLC 299 Park Avenue   New York NY 10171
108   Consulate General of Japan 2018-07-11 JAPAN 6170 6170 2013-05-14 Mercury Public Affairs, LLC 299 Park Avenue, 19th Floor   New York NY 10171
109   Consulate General of the Dominican Republic 2019-06-14 DOMINICAN REPUBLIC 6691 6691 2019-06-14 Rubenstein Public Relations, Inc. 1501 Broadway, 4th Floor   New York NY 10036
110   Consulate-General of Japan in Atlanta 2015-09-16 JAPAN 6295 6295 2015-05-19 McGuireWoods Consulting, LLC          
111   Contrasta Global SL 2020-01-24 SPAIN 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. Calle Progreso, 2 Pl Los Olivos 289906-Getafe, Espana      
112   Coordination of the Movements of the Azawad (CMA) 2017-10-30 MALI 5860 5860 2008-04-03 Independent Diplomat, Inc.          
113   Corporacion Dinant 2015-03-11 HONDURAS 6285 6285 2015-03-11 Tricuro, LLC Barrio Morazan, Frente a Plantas Tropicales Boulevard Suyapa Tegucigalpa      
114   Costa Rica Tourism Board 2018-06-29 COSTA RICA 6492 6492 2017-11-27 MMGY Global, LLC Costado Este del Puente Juan Pablo II Sobre la Autopista General Canas San Jose, 777-1000      
115   Czech Ministry of Foreign Affairs 1996-06-21 CZECHIA 5115 5115 1996-06-21 Czech Center, New York Praha        
116   DPWORLD FZE 2019-12-30 UNITED ARAB EMIRATES 6200 6200 2013-12-11 Dickens & Madson Canada Inc. JAPZA 17 PO BOX 17000 DUBAI    
117   Dalai Lama 1964-03-12 TIBET 1699 1699 1964-03-14 Office of Tibet Dharamsala        
118   Decision Support Center of Libya (on behalf of the Libyan National Army) 2019-05-19 LIBYA 6682 6682 2019-05-19 Linden Government Solutions, LLC Libyan National Army Headquarters        
119   Delegation of Ukrainian Officials via contract with Ukrainian Guild of Activities via contract with Tricuro, LLC 2020-09-03 UKRAINE 6865 6865 2020-09-03 DC International Advisory, LLC          
120   Delegation of Ukrainian officials via a contract with the Ukrainian Guild of Activists 2020-09-03 UKRAINE 6285 6285 2015-03-11 Tricuro, LLC 220, 35th Floor Klousky Descent 7a (Carnegie Towers) Kiev    
121   Delegation of Ukrainian officials via contract with Ukrainian Guild of Activists via Tricuro LLC 2020-09-04 UKRAINE 6737 6737 2019-10-07 Southfive Strategies, LLC 200, 35th Floor Klousky Descent 7a Carnegie Towers Kiev    
122   Democracy News Live 2020-08-27 INDIA 6860 6860 2020-08-27 Babones, Salvatore Jason H-91, Sector 63 Noida, Uttar Pradesh 201309      
123   Democratic Party of Albania 2018-06-12 ALBANIA 6399 6399 2016-12-11 Sonoran Policy Group, LLC Bulevardi Zhan'dark 11 1000 Tirana      
124   Democratic Party of Kosovo 2019-09-30 KOSOVA 6730 6730 2019-09-30 Nunberg, Samuel          
125   Democratic Progressive Party 2013-09-06 TAIWAN 6187 6187 2013-09-06 Taiwan Democratic Progressive Party Mission in the U.S. 30 Peiping E. Road 10th Floor Taipei      
126   Democratic Republic of Congo through Mer Security and Communications, Ltd. 2018-02-14 CONGO, REPUBLIC OF THE 6399 6399 2016-12-11 Sonoran Policy Group, LLC 5 Hatzoref Street Holon, Israel      
127   Dentsu Public Relations Inc 2018-10-01 JAPAN 5483 5483 2002-03-06 MSLGROUP Americas, LLC          
128   Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2020-05-19 UNITED KINGDOM 6827 6827 2020-05-19 Fragomen, Del Rey, Bernsen & Loewy, LLP 3 Whitehall Place SW1A 2AW London    
129   Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2020-05-27 UNITED KINGDOM 6653 6653 2019-03-22 Steptoe & Johnson, LLP          
130   Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2020-05-28 UNITED KINGDOM 6831 6831 2020-05-28 Harris, Wiltshire & Grannis LLP 3 Whitehall Place   London    
131   Department for International Trade, Government of the United Kingdom 2020-02-24 UNITED KINGDOM 6795 6795 2020-02-24 Linklaters LLP          
132   Department for International Trade, Government of the United Kingdom, through Linklaters LLP 2020-05-28 UNITED KINGDOM 6830 6830 2020-05-28 Fish & Richardson P.C. Three Whitehall Place   London    
133   Department of Culture and Tourism - Abu Dhabi 2020-05-20 UNITED ARAB EMIRATES 6826 6826 2020-05-20 Brunswick Group LLC PO Box 94000 Abu Dhabi      
134   Deutsche Telekom, A.G. (formerly: Deutsche Bundespost Telekom) 1990-10-09 GERMANY 4419 4419 1990-10-09 Deutsche Telekom, Inc. Friedrich-Ebert-Allee 140 53113 Bonn    
135   Deutsche Zentrale fuer Tourismus (German National Tourist Board) 1950-02-28 GERMANY 616 616 1950-02-28 German National Tourist Office          
136   Direct Media Sarl 2019-05-07 TOGO 6671 6671 2019-05-07 Global Specialty LLC Rue Satelite, 2eme Maison avant Group CAP Fer, Cacaveli BP 30117 Lome`      
137   Direction du Tourisme et des Congres 1972-04-25 MONACO 2327 2327 1972-03-21 Monaco Government Tourist Office          
138   Discover Dominica Authority 2018-04-30 DOMINICAN REPUBLIC 6549 6549 2018-04-30 Myriad International Marketing, LLC 1st Floor Financial Centre Roseau, Commonwealth of Dominica      
139   Economic Development Board of the Kingdom of Bahrain 2018-10-26 BAHRAIN 6582 6582 2018-08-22 APCO Worldwide LLC P.O. Box 11299 Manama        
140   Education Above All Foundation (through Portland PR Limited (QFC Branch)) 2020-09-03 QATAR 6064 6064 2011-09-19 Portland PR Inc.          
141   Embassy of Democratic Republic of Congo 2019-03-15 CONGO, REPUBLIC OF THE 6649 6649 2019-03-15 LFA Holdings INC. 1100 Connecticut Avenue, NW #725 Washington DC 20036
142   Embassy of Ethiopia 2020-07-14 ETHIOPIA 6594 6594 2018-09-24 Barnes & Thornburg LLP 3506 International Drive, NW   Washington DC 20008
143   Embassy of Hungary 2018-11-20 HUNGARY 6594 6594 2018-09-24 Barnes & Thornburg LLP 30901 Shoemaker Street, NW   Washington DC 20008
144   Embassy of Iraq 2019-05-13 IRAQ 6678 6678 2019-05-13 Gibson, Thomas F. / G.83 LLC 3421 Massachusetts Avenue, NW   Washington DC 20007
145   Embassy of Japan 2018-02-10 JAPAN 6522 6522 2018-02-10 Forbes Tate Partners LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
146   Embassy of Japan 2011-03-02 JAPAN 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
147   Embassy of Japan 2019-04-09 JAPAN 6658 6658 2019-04-09 Beacon Policy Advisors LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
148   Embassy of Japan 2020-04-10 JAPAN 6815 6815 2020-04-10 Griffin, Patrick 2520 Massachusetts Avenue, NW   Washington DC 20008
149   Embassy of Japan 2020-04-10 JAPAN 6816 6816 2020-04-10 Peck Madigan Jones, Inc. 2520 Massachusetts Avenue, NW   Washington DC 20008
150   Embassy of Japan 2017-04-12 JAPAN 6396 6396 2016-11-30 CGCN Group 2520 Massachusetts Avenue, NW   Washington DC 20008
151   Embassy of Japan 2015-04-16 JAPAN 6280 6280 2015-03-16 Daschle Group, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
152   Embassy of Japan 2019-04-18 JAPAN 6666 6666 2019-04-18 Comeau & Company LLC          
153   Embassy of Japan 2001-04-19 JAPAN 2244 2244 1971-02-18 Hogan Lovells US LLP 2-2-1 Kasumigaseki Chiyoda-ku, Tokyo 100        
154   Embassy of Japan 2017-04-26 JAPAN 6422 6422 2017-04-26 S-3 Group 2520 Massachusetts Avenue, NW   Washington DC 20008
155   Embassy of Japan 2015-05-08 JAPAN 3718 3718 1985-08-07 Holland & Knight 2520 Massachusetts Avenue, NW   Washington DC 20008
156   Embassy of Japan 2015-05-16 JAPAN 6294 6294 2015-05-16 Greenfield Law, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
157   Embassy of Japan 2018-05-18 JAPAN 6554 6554 2018-05-18 RSC Services International LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
158   Embassy of Japan 2015-05-19 JAPAN 6295 6295 2015-05-19 McGuireWoods Consulting, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
159   Embassy of Japan 2014-05-21 JAPAN 5839 5839 2007-11-12 Sorini, Samet & Associates, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
160   Embassy of Japan 2020-08-04 JAPAN 6847 6847 2020-08-04 Seven Letter 2520 Massachusetts Avenue, NW   Washington DC 20008
161   Embassy of Japan 2015-09-18 JAPAN 6317 6317 2015-09-18 Alignment Government Strategies 2520 Massachusetts Avenue, NW   Washington DC 20008
162   Embassy of Japan 2013-11-08 JAPAN 6194 6194 2013-11-08 Parvin, C. Landon 2520 Massachusetts Avenue, NW   Washington DC  
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
164   Embassy of Morocco 2018-04-13 MOROCCO 6540 6540 2018-04-13 ThirdCircle, Inc. 1601 21st Street, NW   Washington DC 20009
165   Embassy of Qatar in the United States (though Pillsbury WInthrop Shaw Pittman LLP) 2020-08-18 QATAR 6857 6857 2020-08-18 Praia Consultants LLC 2555 M St. NW   Washington DC 20037
166   Embassy of Qatar through Nelson Mullins Riley & Scarborough, LLP 2020-02-20 QATAR 3718 3718 1985-08-07 Holland & Knight 2555 M Street, NW   Washington DC 20037
167   Embassy of Qatar 2018-03-23 QATAR 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 2555 M Street, NW   Washington DC 20037
168   Embassy of Saudi Arabia 2018-06-29 SAUDI ARABIA 6391 6391 2016-11-16 McKeon Group, Inc. 601 New Hamphsire Avenue, NW   Washington DC 20037
169   Embassy of Thailand, Office of Commercial Affairs 2019-07-09 THAILAND 6699 6699 2019-07-09 Pilot Rock Global Strategies LLC Office of Commercial Affairs Royal Thai Embassy 1024 Wisconsin Aveune, NW Washington DC 20007
170   Embassy of the Bolivarian Republic of Venezuela 2019-04-12 VENEZUELA 5430 5430 2001-05-10 BGR Government Affairs, LLC     Washington DC  
171   Embassy of the Bolivarian Republic of Venezuela 2018-12-15 VENEZUELA 6613 6613 2018-12-15 Flores, Leonardo 1099 30th Street, NW   Washington DC 20007
172   Embassy of the Islamic Republic of Afghanistan 2018-09-20 AFGHANISTAN 3712 3712 1985-08-05 DLA Piper US LLP          
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
174   Embassy of the Principality of Monaco 2015-10-14 MONACO 5299 5299 1999-02-02 Berliner Corcoran & Rowe, LLP 3400 International Drive, NW   Washington DC 20008
175   Embassy of the Republic of Argentina 2020-05-04 ARGENTINA 5666 5666 2005-01-31 Glover Park Group, LLC 1600 New Hampshire Ave.   Washington DC 20009
176   Embassy of the Republic of Argentina 2020-05-07 ARGENTINA 1750 1750 1964-06-04 Arnold & Porter Kaye Scholer, LLP 1600 New Hampshire Avenue, NW   Washington DC 20009
177   Embassy of the Republic of Azerbaijan (through BGR Government Affairs, LLC) 2018-03-05 AZERBAIJAN 6535 6535 2018-03-05 Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. 2741 34th Street, NW   Washington DC 20008
178   Embassy of the Republic of Azerbaijan to the United States of America 2020-01-31 AZERBAIJAN 6789 6789 2020-01-31 Stellar Jay Communications 2741 34th Street, 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
180   Embassy of the Republic of Guinea 2019-08-14 GUINEA 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 2112 Leroy Place, NW   Washington DC 20008
181   Embassy of the Republic of Haiti Government of the Republic of Haiti 2019-03-11 HAITI 6644 6644 2019-03-11 LeBlanc, Johanna 2311 Massachusetts Avenue, NW   Washington DC 20008
182   Embassy of the Republic of Iraq 2018-10-31 IRAQ 6605 6605 2018-10-31 Holly Strategies Incorporated 3421 Massachusetts Avenue, NW   Washington DC 20007
183   Embassy of the Republic of Kenya 2017-06-06 KENYA 6399 6399 2016-12-11 Sonoran Policy Group, LLC 2249 R Street, NW   Washington DC 20008
184   Embassy of the Republic of Korea through Cornerstone Government Affairs 2017-03-14 KOREA, SOUTH 6408 6408 2017-03-14 DiNino Associates, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
185   Embassy of the Republic of Korea 2018-01-10 KOREA, SOUTH 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
186   Embassy of the Republic of Korea 2019-01-10 KOREA, SOUTH 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
187   Embassy of the Republic of Korea 2017-01-20 KOREA, SOUTH 6401 6401 2017-01-20 Cornerstone Government Affairs 2450 Massachusetts Avenue, NW   Washington DC 20008
188   Embassy of the Republic of Korea 2010-03-22 KOREA, SOUTH 5982 5982 2010-03-22 Thomas Capitol Partners, Inc. 2450 Massachusetts Avenue, 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
190   Embassy of the Republic of Korea 2019-12-30 KOREA, SOUTH 5044 5044 1995-09-13 Reed, T. Dean          
191   Embassy of the Republic of Turkey 2018-05-04 TURKEY 6170 6170 2013-05-14 Mercury Public Affairs, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
192   Embassy of the Republic of Yemen 2019-02-27 YEMEN 5483 5483 2002-03-06 MSLGROUP Americas, LLC 2319 Wyoming Avenue, NW   Washington DC 20008
193   Embassy of the State of Qatar through Venable LLP 2018-02-02 QATAR 6517 6517 2018-02-02 Husch Blackwell Strategies, LLC 2555 M Street, NW   Washington DC 20037
194   Embassy of the State of Qatar through Venable LLP 2018-02-05 QATAR 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 2555 M Street, NW   Washington DC 20037
195   Embassy of the State of Qatar through Venable LLP 2017-12-08 QATAR 6497 6497 2017-12-08 Iron Bridge Strategies LLC 2555 M Street, NW   Washington DC 20037
196   Embassy of the State of Qatar 2019-01-22 QATAR 6540 6540 2018-04-13 ThirdCircle, Inc. 2555 M Street, NW   Washington DC 20037
197   Embassy of the State of Qatar 2018-02-05 QATAR 5931 5931 2009-04-17 Venable, LLP 2555 M Street, NW   Washington DC 20037
198   Embassy of the State of Qatar 2020-03-20 QATAR 6804 6804 2020-03-20 Bridge Builder Communications 2555 M St NW   Washington DC 20037
199   Embassy of the State of Qatar 2020-03-26 QATAR 6415 6415 2017-04-05 Ballard Partners 601 Thirteenth Street NW Suit 450 Washington DC 20005
200   Embassy of the State of Qatar 2018-03-29 QATAR 6537 6537 2018-03-29 Lumen8 Advisors, LLC 2555 M Street, NW   Washington DC 20037

Next page

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