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

16,312 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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 101   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
102 102   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
103 103   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
104 104   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
105 105   Consulate-General of Japan in Atlanta 2015-09-16 JAPAN 6295 6295 2015-05-19 McGuireWoods Consulting, LLC          
106 106   Coordination of the Movements of the Azawad (CMA) 2017-10-30 MALI 5860 5860 2008-04-03 Independent Diplomat, Inc.          
107 107   Corporacion Dinant 2015-03-11 HONDURAS 6285 6285 2015-03-11 Tricuro, LLC Barrio Morazan, Frente a Plantas Tropicales Boulevard Suyapa Tegucigalpa      
108 108   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      
109 109   Czech Ministry of Foreign Affairs 1996-06-21 CZECHIA 5115 5115 1996-06-21 Czech Center, New York Praha        
110 110   DPWORLD FZE 2019-12-30 UNITED ARAB EMIRATES 6200 6200 2013-12-11 Dickens & Madson Canada Inc. JAPZA 17 PO BOX 17000 DUBAI    
111 111   Dalai Lama 1964-03-12 TIBET 1699 1699 1964-03-14 Office of Tibet Dharamsala        
112 112   Dave Sheer Guns d/b/a Dave Sheer Gunsmithing & Firearms Exchange 2020-11-20 SOUTH AFRICA 6893 6893 2020-11-20 Farhang & Medcoff, PLLC 95 Forest Rd. Bramely, Johannesburg 2192      
113 113   Delegation of the European Union to the USA 2020-12-09 INTERNATIONAL 6422 6422 2017-04-26 S-3 Group 2175 K STREET, NW   Washington DC 20037
114 114   Democratic Party of Albania 2018-06-12 ALBANIA 6399 6399 2016-12-11 Sonoran Policy Group, LLC Bulevardi Zhan'dark 11 1000 Tirana      
115 115   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      
116 116   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    
117 117   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          
118 118   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    
119 119   Department for International Trade, Government of the United Kingdom 2020-02-24 UNITED KINGDOM 6795 6795 2020-02-24 Linklaters LLP          
120 120   Department for International Trade, Government of the United Kingdom 2020-11-30 UNITED KINGDOM 3731 3731 1985-09-13 Sidley Austin, LLP 3 Whitehall Place SW1A ZAW London    
121 121   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    
122 122   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      
123 123   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    
124 124   Deutsche Zentrale fuer Tourismus (German National Tourist Board) 1950-02-28 GERMANY 616 616 1950-02-28 German National Tourist Office          
125 125   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`      
126 126   Direction du Tourisme et des Congres 1972-04-25 MONACO 2327 2327 1972-03-21 Monaco Government Tourist Office          
127 127   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      
128 128   Dubai Corporation for Tourism and Commerce Marketing 2020-12-01 UNITED ARAB EMIRATES 6212 6212 2014-03-10 Finn Partners, Inc. 4th Floor. One Central, The Offices 2, Dubai World Trade Centre. PO Box 594 Dubai    
129 129   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        
130 130   Education Above All Foundation (through Portland PR Limited (QFC Branch)) 2020-09-03 QATAR 6064 6064 2011-09-19 Portland PR Inc. P.O. Box 34173 Education City Doha      
131 131   Embassy of Armenia to the United States 2020-10-30 ARMENIA 6884 6884 2020-10-30 Copper Strategies LLC 2225 R St NW   Washington DC 20008
132 132   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
133 133   Embassy of Ethiopia 2021-02-04 ETHIOPIA 5931 5931 2009-04-17 Venable, LLP 3506 International Drive   Washington DC 20008
134 134   Embassy of Hungary 2020-10-19 HUNGARY 6880 6880 2020-10-19 Strategic Improvisation Inc. 3910 Shoemaker St NW   Washington DC 20008
135 135   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
136 136   Embassy of Italy 2020-10-14 ITALY 6422 6422 2017-04-26 S-3 Group 300 WHITEHAVEN STREET, NW   Washington DC 20008
137 137   Embassy of Japan in the United States of America 2021-01-30 JAPAN 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 2520 Massachusetts Avenue NW   Washington DC 20008
138 138   Embassy of Japan 2018-02-10 JAPAN 6522 6522 2018-02-10 Forbes Tate Partners LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
139 139   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
140 140   Embassy of Japan 2019-04-09 JAPAN 6658 6658 2019-04-09 Beacon Policy Advisors LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
141 141   Embassy of Japan 2020-04-10 JAPAN 6815 6815 2020-04-10 Griffin, Patrick 2520 Massachusetts Avenue, NW   Washington DC 20008
142 142   Embassy of Japan 2020-04-10 JAPAN 6816 6816 2020-04-10 Peck Madigan Jones, Inc. 2520 Massachusetts Avenue, NW   Washington DC 20008
143 143   Embassy of Japan 2017-04-12 JAPAN 6396 6396 2016-11-30 CGCN Group 2520 Massachusetts Avenue, NW   Washington DC 20008
144 144   Embassy of Japan 2015-04-16 JAPAN 6280 6280 2015-03-16 Daschle Group, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
145 145   Embassy of Japan 2019-04-18 JAPAN 6666 6666 2019-04-18 Comeau & Company LLC          
146 146   Embassy of Japan 2001-04-19 JAPAN 2244 2244 1971-02-18 Hogan Lovells US LLP 2-2-1 Kasumigaseki Chiyoda-ku, Tokyo 100        
147 147   Embassy of Japan 2017-04-26 JAPAN 6422 6422 2017-04-26 S-3 Group 2520 Massachusetts Avenue, NW   Washington DC 20008
148 148   Embassy of Japan 2015-05-08 JAPAN 3718 3718 1985-08-07 Holland & Knight 2520 Massachusetts Avenue, NW   Washington DC 20008
149 149   Embassy of Japan 2015-05-16 JAPAN 6294 6294 2015-05-16 Greenfield Law, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
150 150   Embassy of Japan 2018-05-18 JAPAN 6554 6554 2018-05-18 RSC Services International LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
151 151   Embassy of Japan 2015-05-19 JAPAN 6295 6295 2015-05-19 McGuireWoods Consulting, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
152 152   Embassy of Japan 2020-08-04 JAPAN 6847 6847 2020-08-04 Seven Letter 2520 Massachusetts Avenue, NW   Washington DC 20008
153 153   Embassy of Japan 2015-09-18 JAPAN 6317 6317 2015-09-18 Alignment Government Strategies 2520 Massachusetts Avenue, NW   Washington DC 20008
154 154   Embassy of Japan 2013-11-08 JAPAN 6194 6194 2013-11-08 Parvin, C. Landon 2520 Massachusetts Avenue, NW   Washington DC  
155 155   Embassy of Kazakhstan USA 2020-05-01 KAZAKHSTAN 5430 5430 2001-05-10 BGR Government Affairs, LLC 1401 16th St. NW   Washington DC 20036
156 156   Embassy of Morocco 2018-04-13 MOROCCO 6540 6540 2018-04-13 ThirdCircle, Inc. 1601 21st Street, NW   Washington DC 20009
157 157   Embassy of Qatar (through contract with Nelson, Mullins, Riley & Scarborough LLP 2021-01-13 QATAR 6907 6907 2021-01-13 Nurnberger & Associates, Inc. 2555 M Street, NW   Washigton DC 20037
158 158   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
159 159   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
160 160   Embassy of Qatar 2018-03-23 QATAR 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 2555 M Street, NW   Washington DC 20037
161 161   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
162 162   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
163 163   Embassy of the Bolivarian Republic of Venezuela 2019-04-12 VENEZUELA 5430 5430 2001-05-10 BGR Government Affairs, LLC     Washington DC  
164 164   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
165 165   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
166 166   Embassy of the Kingdom of Saudi Arabia 2020-11-13 SAUDI ARABIA 6889 6889 2020-11-13 Off Hill Strategies LLC 601 New Hampshire Avenue, NW   Washington DC 20037
167 167   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
168 168   Embassy of the Republic of Argentina (on behalf of Arnold & Porter Kaye Scholer LLP) 2021-02-03 ARGENTINA 6922 6922 2021-02-03 Ferox Strategies LLC 1600 New Hampshire Avenue, NW   Washington DC 20009
169 169   Embassy of the Republic of Argentina 2020-05-04 ARGENTINA 5666 5666 2005-01-31 FGH Holdings 1600 New Hampshire Ave.   Washington DC 20009
170 170   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
171 171   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
172 172   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
173 173   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
174 174   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
175 175   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
176 176   Embassy of the Republic of Haiti 2020-12-09 HAITI 6898 6898 2020-12-09 Latin America Advisory Group, LLC 2311 Massachusetts Avenue, NW   Washington DC 20008
177 177   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
178 178   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
179 179   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
180 180   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
181 181   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
182 182   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
183 183   Embassy of the Republic of Korea 2021-01-24 KOREA, SOUTH 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
184 184   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
185 185   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
186 186   Embassy of the Republic of Korea 2019-12-30 KOREA, SOUTH 5044 5044 1995-09-13 Reed, T. Dean          
187 187   Embassy of the Republic of Rwanda in Washington, D.C-USA 2018-12-18 RWANDA 6549 6549 2018-04-30 Myriad International Marketing, LLC          
188 188   Embassy of the Republic of Yemen 2019-02-27 YEMEN 5483 5483 2002-03-06 QORVIS LLC 2319 Wyoming Avenue, NW   Washington DC 20008
189 189   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
190 190   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
191 191   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
192 192   Embassy of the State of Qatar 2019-01-22 QATAR 6540 6540 2018-04-13 ThirdCircle, Inc. 2555 M Street, NW   Washington DC 20037
193 193   Embassy of the State of Qatar 2018-02-05 QATAR 5931 5931 2009-04-17 Venable, LLP 2555 M Street, NW   Washington DC 20037
194 194   Embassy of the State of Qatar 2021-02-09 QATAR 6924 6924 2021-02-09 Ogilvy Government Relations 2555 M Street, NW   Washington DC 20037
195 195   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
196 196   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
197 197   Embassy of the State of Qatar 2018-04-02 QATAR 6415 6415 2017-04-05 Ballard Partners 601 Thirteenth Street NW Suit 450 Washington DC 20005
198 198   Embassy of the State of Qatar 2020-05-08 QATAR 6822 6822 2020-05-08 Proof Strategies Inc. 2555 M Street, NW   Washington DC 20037
199 199   Embassy of the State of Qatar 2019-09-06 QATAR 6723 6723 2019-09-06 Neale Creek, LLC 2555 M Street, NW   Washington DC 20037
200 200   Embassy of the State of Qatar 2019-12-10 QATAR 6170 6170 2013-05-14 Mercury Public Affairs, 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)
);