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,089 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   China-United States Exchange Foundation 2018-08-31 CHINA 6584 6584 2018-08-31 Wilson Global Communications, LLC 20/F Yardley Commercial Building, No. 3 Connaught Rd West, SHeung Wan, Hong Kong      
102   China-United States Exchange Foundation 2018-11-19 CHINA 6328 6328 2015-11-19 Capitol Counsel, LLC 20/F, Yardley Commercial Building No. 3 Connaught Road West Sheung Wan, Hong Kong      
103   City of Sunderland, England 1998-03-01 GREAT BRITAIN 5246 5246 1998-03-01 Oliver A. Dulle Jr. & Company Colima Avenue, Sunderland Enterprise Park, Sunderland        
104   Common Council of Iraqi and Arabic Tribes 2014-07-18 IRAQ 5974 5974 2010-02-18 Alsalih, Mark K. Hay Babel, Jadriyah #18 Baghdad      
105   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        
106   Concern Belneftekhim 2019-11-01 BELARUS 6706 6706 2019-08-12 Gencarelli, David F. pr. Dzerzhinskogo, 73 220116 Minsk      
107   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
108   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
109   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
110   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
111   Consulate General of Japan in San Francisco 2016-01-20 JAPAN 6337 6337 2016-01-20 California Strategies, LLC Consulate General of Japan in San Francisco 275 Battery Street, #2100 San Francisco CA 94111
112   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
113   Consulate General of Japan 2019-10-25 JAPAN 5712 5712 2005-10-03 Greenberg Traurig, LLP          
114   Consulate General of Mexico 2016-06-22 MEXICO 5932 5932 2009-04-24 Raben Group, LLC 4507 San Jacinto Street   Houston TX 77004
115   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
116   Consulate-General of Japan in Atlanta 2015-09-16 JAPAN 6295 6295 2015-05-19 McGuireWoods Consulting, LLC          
117   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      
118   Coordination of the Movements of the Azawad (CMA) 2017-10-30 MALI 5860 5860 2008-04-03 Independent Diplomat, Inc.          
119   Corporacion Dinant 2015-03-11 HONDURAS 6285 6285 2015-03-11 Tricuro, LLC Barrio Morazan, Frente a Plantas Tropicales Boulevard Suyapa Tegucigalpa      
120   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      
121   Czech Ministry of Foreign Affairs 1996-06-21 CZECHIA 5115 5115 1996-06-21 Czech Center, New York Praha        
122   DPWORLD FZE 2019-12-30 UNITED ARAB EMIRATES 6200 6200 2013-12-11 Dickens & Madson Canada Inc. JAPZA 17 PO BOX 17000 DUBAI    
123   Dalai Lama 1964-03-12 TIBET 1699 1699 1964-03-14 Office of Tibet Dharamsala        
124   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        
125   Democratic Party of Albania 2018-06-12 ALBANIA 6399 6399 2016-12-11 Sonoran Policy Group, LLC Bulevardi Zhan'dark 11 1000 Tirana      
126   Democratic Party of Kosovo 2019-09-30 KOSOVA 6730 6730 2019-09-30 Nunberg, Samuel          
127   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      
128   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      
129   Dentsu Public Relations Inc 2018-10-01 JAPAN 5483 5483 2002-03-06 MSLGROUP Americas, LLC          
130   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    
131   Deutsche Zentrale fuer Tourismus (German National Tourist Board) 1950-02-28 GERMANY 616 616 1950-02-28 German National Tourist Office          
132   Deutsche Zentrale fur Tourismus e.V 2019-01-14 GERMANY 6492 6492 2017-11-27 MMGY Global, LLC          
133   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`      
134   Direction du Tourisme et des Congres 1972-04-25 MONACO 2327 2327 1972-03-21 Monaco Government Tourist Office          
135   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      
136   Dubai Department of Tourism and Commerce Marketing, Government of Dubai 2018-11-14 UNITED ARAB EMIRATES 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 9th Floor Al-Fattan Plaza Building, Airport Road Al Garhoud P.O. Box 594 DUBAI      
137   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        
138   Egyptian Ministry of Investment and International Cooperation 2017-06-27 EGYPT 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC 8 Adley Street   Cairo    
139   Embassy of Afghanistan 2019-03-13 AFGHANISTAN 2244 2244 1971-02-18 Hogan Lovells US LLP 2341 Wyoming Avenue, NW   Washington DC 20008
140   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
141   Embassy of Hungary (through Greenberg Traurig) 2019-05-24 HUNGARY 6684 6684 2019-05-24 Triconsultants, Inc. 3910 Shoemaker Street   Washington DC 20008
142   Embassy of Hungary 2019-05-20 HUNGARY 5712 5712 2005-10-03 Greenberg Traurig, LLP 3910 Shoemaker Street, NW   Washington DC 20008
143   Embassy of Hungary 2019-09-10 HUNGARY 6624 6624 2018-12-31 Capitol Financial Strategies, LLC          
144   Embassy of Hungary 2018-11-20 HUNGARY 6594 6594 2018-09-24 Barnes & Thornburg LLP 30901 Shoemaker Street, NW   Washington DC 20008
145   Embassy of Hungary 2018-11-30 HUNGARY 6544 6544 2018-04-25 Policy Impact Strategic Communications, Inc. 3910 Shoemaker Street, NW   Washington DC 20008
146   Embassy of Iceland in Washington 2019-07-26 ICELAND 6236 6236 2014-07-30 Mayer Brown, LLP Embassy of Iceland House of Sweden 2900 K Street, NW #509 Washington DC 20007
147   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
148   Embassy of Japan 2018-02-10 JAPAN 6522 6522 2018-02-10 Forbes Tate Partners LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
149   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
150   Embassy of Japan 2019-04-09 JAPAN 6658 6658 2019-04-09 Beacon Policy Advisors LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
151   Embassy of Japan 2017-04-12 JAPAN 6396 6396 2016-11-30 CGCN Group 2520 Massachusetts Avenue, NW   Washington DC 20008
152   Embassy of Japan 2015-04-16 JAPAN 6280 6280 2015-03-16 Daschle Group, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
153   Embassy of Japan 2019-04-18 JAPAN 6666 6666 2019-04-18 Comeau & Company LLC          
154   Embassy of Japan 2001-04-19 JAPAN 2244 2244 1971-02-18 Hogan Lovells US LLP 2-2-1 Kasumigaseki Chiyoda-ku, Tokyo 100        
155   Embassy of Japan 2017-04-26 JAPAN 6422 6422 2017-04-26 S-3 Group 2520 Massachusetts Avenue, NW   Washington DC 20008
156   Embassy of Japan 2015-05-08 JAPAN 3718 3718 1985-08-07 Holland & Knight 2520 Massachusetts Avenue, NW   Washington DC 20008
157   Embassy of Japan 2015-05-16 JAPAN 6294 6294 2015-05-16 Greenfield Law, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
158   Embassy of Japan 2018-05-18 JAPAN 6554 6554 2018-05-18 RSC Services International LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
159   Embassy of Japan 2015-05-19 JAPAN 6295 6295 2015-05-19 McGuireWoods Consulting, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
160   Embassy of Japan 2014-05-21 JAPAN 5839 5839 2007-11-12 Sorini, Samet & Associates, LLC 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 Mexico through Kuykendall & Associates 2009-04-24 MEXICO 5932 5932 2009-04-24 Raben Group, LLC          
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 Pakistan 2019-07-26 PAKISTAN 3718 3718 1985-08-07 Holland & Knight 3517 International Court, NW   Washington DC 20008
166   Embassy of Qatar 2018-03-23 QATAR 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 2555 M Street, NW   Washington DC 20037
167   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
168   Embassy of Spain 2019-10-11 SPAIN 5666 5666 2005-01-31 Glover Park Group, LLC 2375 Pennsylvania 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          
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 Hellenic Republic 2018-09-28 GREECE 3712 3712 1985-08-05 DLA Piper US LLP          
173   Embassy of the Islamic Republic of Afghanistan 2018-09-20 AFGHANISTAN 3712 3712 1985-08-05 DLA Piper US LLP          
174   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
175   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
176   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
177   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
178   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
179   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
180   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
181   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
182   Embassy of the Republic of Kazakhstan in Washington 2019-06-03 KAZAKHSTAN 6064 6064 2011-09-19 Portland PR Inc. 1401 16th Street, NW        
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 2016-08-23 KOREA, SOUTH 3718 3718 1985-08-07 Holland & Knight 2450 Massachusetts Avenue, NW   Washington DC 20008
191   Embassy of the Republic of Korea 2019-12-30 KOREA, SOUTH 5044 5044 1995-09-13 Reed, T. Dean          
192   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
193   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
194   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
195   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
196   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
197   Embassy of the State of Qatar 2015-01-02 QATAR 6170 6170 2013-05-14 Mercury Public Affairs, LLC 2555 M Street, NW   Washington DC 20037
198   Embassy of the State of Qatar 2019-01-09 QATAR 6627 6627 2019-01-09 PAVEA, LLC 2555 M Street, NW   Washington DC 20037
199   Embassy of the State of Qatar 2019-01-22 QATAR 6540 6540 2018-04-13 ThirdCircle, Inc. 2555 M Street, NW   Washington DC 20037
200   Embassy of the State of Qatar 2018-02-05 QATAR 5931 5931 2009-04-17 Venable, LLP 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 115.707ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history