home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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

44 rows where City = "Washington" and Country/Location_Represented = "TURKEY"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name >30

  • Capitol Counsel, LLC 2
  • Mercury Public Affairs, LLC 2
  • The Van Aucker Group 2
  • 30 Point Strategies, LLC 1
  • 5W Public Relations, LLC 1
  • APCO Worldwide, Inc. 1
  • Advanced Advocacy, LLC 1
  • Alpaytac, Inc. 1
  • Amsterdam & Partners, LLP 1
  • Arnold, Jim 1
  • BCW LLC 1
  • Belvedere Strategies 1
  • Caspian Group, LLC 1
  • DLA Piper US LLP 1
  • Daschle Group, LLC 1
  • DiNovo Strategies, LLC 1
  • Dickstein Shapiro, LLP 1
  • Fleishman-Hillard, Inc. 1
  • Forni, Brian 1
  • Friedlander Consulting Group LLC 1
  • Garvey Strategies 1
  • Gephardt Group Government Affairs, LLC 1
  • Goldin Solutions Inc. 1
  • Gonzalez, Jason Brent 1
  • Greenberg Traurig, LLP 1
  • Israel Consult, Inc. 1
  • Kindel Gagan 1
  • King & Spalding LLP 1
  • LB International Solutions, LLC 1
  • Liss, Norman 1
  • …

Foreign_Principal 29

  • Embassy of Turkey 4
  • Republic of Turkey through Amsterdam & Partners, LLP 4
  • Embassy of the Republic of Turkey 3
  • Government of the Republic of Turkey, Embassy 3
  • Republic of Turkey, Embassy 3
  • Embassy of Republic of Turkey through Amsterdam & Partners, LLP 2
  • Government of Turkey, Embassy 2
  • Republic of Turkey 2
  • Amsterdam & Partners, LLP on behalf of the Embassy of the Republic of Turkey 1
  • Embassy of Republic of Turkey thru Gephardt Group Government Affairs 1
  • Embassy of the Republic of Turkey (through Fleishman-Hillard) 1
  • Embassy of the Republic of Turkey through Amsterdam & Partners, LLP 1
  • Embassy of the Republic of Turkey through DiNovo Strategies and Fleishman-Hillard 1
  • Embassy of the Republic of Turkey through Fleishman-Hillard 1
  • Government of Turkey (through the Gephardt Group) 1
  • Government of Turkey, Embassy through DLA Piper, LLP 1
  • Government of the Republic of Turkey 1
  • Government of the Republic of Turkey, Embassy through Gephardt Group Government Affairs, LLC 1
  • Greenberg Traurig, LLP on behalf of the Republic of Turkey 1
  • IYI Party Representation to the United States LLC 1
  • Ministry of Foreign Affairs, Government of Turkey 1
  • Repubilc of Turkey (through Royal Atlantic LLC) 1
  • Republic of Turkey (through Gephardt Group Government Affairs LLC) 1
  • Republic of Turkey (through the Gephardt Group) 1
  • Republic of Turkey on behalf of Amsterdam & Partners, LLP 1
  • Republic of Turkey through Amsterdam & Partners LLP 1
  • Republic of Turkey through Greenberg Traurig 1
  • Republic of Turkey through Greenberg Traurig LLP 1
  • Republic of Turkiye 1

State 1

  • DC 44

Country/Location_Represented 1

  • TURKEY · 44 ✖

City 1

  • Washington · 44 ✖
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
190 190   Embassy of Turkey 2023-04-18 TURKEY The Van Aucker Group 7260 2023-04-18 The Van Aucker Group 2525 Mass. Avenue   Washington DC 20008
191 191   Embassy of Turkey 2021-06-11 TURKEY Garvey Strategies 6974 2021-06-11 Garvey Strategies 2525 Massachusetts Avenue   Washington DC 20007
311 311   Government of the Republic of Turkey 2022-01-12 TURKEY Friedlander Consulting Group LLC 7009 2021-09-03 Friedlander Consulting Group LLC 2525 Massachusettes Ave NW   Washington DC 20008
312 312   Government of the Republic of Turkey, Embassy 2014-03-03 TURKEY LB International Solutions, LLC 6210 2014-03-03 LB International Solutions, LLC 2525 Massachusetts Avenue, NW   Washington DC 29998
341 341   IYI Party Representation to the United States LLC 2023-01-30 TURKEY Media Theory LLC 7223 2023-01-30 Media Theory LLC 2200 Pennsylvania Ave. NW, STE 500   Washington DC 20037
597 597   Republic of Turkey, Embassy 2015-10-26 TURKEY Amsterdam & Partners, LLP 6325 2015-10-26 Amsterdam & Partners, LLP 2525 Massachusetts Avenue, NW   Washington DC 20008
598 598   Republic of Turkiye 2022-12-22 TURKEY Sporn, Kalman Chaim 7208 2022-12-22 Sporn, Kalman Chaim 2525 Massachusetts Avenue, NW   Washington DC 20008
1469 1469 2009-01-22 Government of Turkey, Embassy 2007-05-10 TURKEY DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2525 Massachusetts Avenue, NW   Washington DC 20008
1914 1914 2018-01-31 Republic of Turkey through Amsterdam & Partners, LLP 2016-06-06 TURKEY Madison Group, LLC 6355 2016-06-06 Madison Group, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
3353 3353 2017-03-01 Amsterdam & Partners, LLP on behalf of the Embassy of the Republic of Turkey 2016-03-29 TURKEY Kindel Gagan 6346 2016-03-29 Kindel Gagan 2525 Massachusetts Avenue, NW   Washington DC 20008
4757 4757 2016-03-31 Embassy of the Republic of Turkey through Amsterdam & Partners, LLP 2016-03-28 TURKEY MediaFix Associates 6345 2016-03-28 MediaFix Associates 2525 Massachusetts Avenue, NW   Washington DC 20008
4979 4979 2021-04-01 Republic of Turkey through Greenberg Traurig LLP 2017-01-01 TURKEY Capitol Counsel, LLC 6328 2015-11-19 Capitol Counsel, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
6040 6040 2008-04-30 Government of Turkey, Embassy 2007-10-17 TURKEY Liss, Norman 5832 2007-10-17 Liss, Norman Turkish Embassy 2525 Massachusetts Avenue, NW Washington DC 20008
6080 6080 2014-04-30 Government of the Republic of Turkey, Embassy 2007-09-24 TURKEY Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 2525 Massachusetts Avenue, NW   Washington DC 20008
6093 6093 2018-04-30 Embassy of Republic of Turkey through Amsterdam & Partners, LLP 2016-04-21 TURKEY Arnold, Jim 6349 2016-04-21 Arnold, Jim 2525 Massachusetts Avenue, NW   Washington DC 20008
7220 7220 2009-05-31 Embassy of the Republic of Turkey through DiNovo Strategies and Fleishman-Hillard 2008-09-30 TURKEY Neusner Communications, LLC 5883 2008-09-30 Neusner Communications, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
7250 7250 2015-05-31 Embassy of the Republic of Turkey 2014-05-23 TURKEY Alpaytac, Inc. 6224 2014-05-23 Alpaytac, Inc. 2525 Massachusetts Avenue, NW   Washington DC 20006
7258 7258 2016-05-31 Embassy of Republic of Turkey through Amsterdam & Partners, LLP 2016-03-16 TURKEY Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
7446 7446 2009-06-01 Embassy of the Republic of Turkey through Fleishman-Hillard 2008-10-09 TURKEY DiNovo Strategies, LLC 5887 2008-10-09 DiNovo Strategies, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
7709 7709 2015-06-09 Repubilc of Turkey (through Royal Atlantic LLC) 2015-06-05 TURKEY Goldin Solutions Inc. 6298 2015-06-05 Goldin Solutions Inc. 2525 Massachusetts Avenue, NW   Washington DC 20008
9636 9636 2013-07-30 Government of the Republic of Turkey, Embassy 2009-03-09 TURKEY Caspian Group, LLC 5915 2009-03-09 Caspian Group, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
9871 9871 2007-07-31 Embassy of Turkey 2005-01-19 TURKEY Israel Consult, Inc. 5580 2003-10-06 Israel Consult, Inc. 2525 Massachusetts Avenue, N.W.   Washington DC 20008
9906 9906 2015-07-31 Republic of Turkey (through the Gephardt Group) 2009-04-01 TURKEY Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 2525 Massachusetts Avenue, NW   Washington DC 20008
10138 10138 2016-08-04 Government of the Republic of Turkey, Embassy through Gephardt Group Government Affairs, LLC 2012-01-09 TURKEY Forni, Brian 6085 2012-01-09 Forni, Brian 2525 Massachusetts Avenue, NW   Washington DC 20008
10816 10816 2015-08-28 Government of Turkey (through the Gephardt Group) 2015-08-10 TURKEY Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2525 Massachusetts Avenue, NW   Washington DC 20008
12249 12249 2018-09-30 Republic of Turkey through Amsterdam & Partners LLP 2017-03-10 TURKEY Advanced Advocacy, LLC 6407 2017-03-10 Advanced Advocacy, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
12419 12419 2013-10-01 Embassy of the Republic of Turkey (through Fleishman-Hillard) 2009-10-30 TURKEY 30 Point Strategies, LLC 5884 2008-10-06 30 Point Strategies, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
12650 12650 2016-10-13 Republic of Turkey through Amsterdam & Partners, LLP 2016-06-03 TURKEY Signal Group Consulting, LLC 6297 2015-06-02 Signal Group Consulting, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
12965 12965 2020-10-23 Embassy of the Republic of Turkey 2018-05-04 TURKEY Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
13086 13086 2020-10-27 Republic of Turkey 2014-08-12 TURKEY Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2525 Massachusetts Avenue, NW   Washington DC 20008
13142 13142 2017-10-29 Republic of Turkey through Amsterdam & Partners, LLP 2017-05-25 TURKEY 5W Public Relations, LLC 6434 2017-05-25 5W Public Relations, LLC 601 13th Street, NW 11th Floor South Washington DC 20005
13485 13485 2017-10-31 Republic of Turkey through Amsterdam & Partners, LLP 2017-04-28 TURKEY Gonzalez, Jason Brent 6424 2017-04-28 Gonzalez, Jason Brent The Homer Building 601 13th Street, NW 11th Floor South Washington DC 20005
13749 13749 2020-11-05 Greenberg Traurig, LLP on behalf of the Republic of Turkey 2019-01-19 TURKEY Venable, LLP 5931 2009-04-17 Venable, LLP 2525 Massachusetts Avenue, NW   Washington DC 20008
14002 14002 2017-11-15 Republic of Turkey on behalf of Amsterdam & Partners, LLP 2017-09-29 TURKEY Stroud Communications 6471 2017-09-29 Stroud Communications 2525 Massachusetts Avenue, NW   Washington DC 20008
14064 14064 2010-11-18 Government of Turkey, Embassy through DLA Piper, LLP 2009-03-27 TURKEY Mercer & Associates, Inc. 5923 2009-03-27 Mercer & Associates, Inc. 2525 Massachusetts Avenue, NW   Washington DC 20008
16779 16779 2016-12-31 Embassy of Republic of Turkey thru Gephardt Group Government Affairs 2016-06-14 TURKEY Belvedere Strategies 6360 2016-06-14 Belvedere Strategies 2525 Massachusetts Avenue, NW   Washington DC 20008
16791 16791 2016-12-31 Republic of Turkey (through Gephardt Group Government Affairs LLC) 2015-11-19 TURKEY Capitol Counsel, LLC 6328 2015-11-19 Capitol Counsel, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
16792 16792 2016-12-31 Republic of Turkey, Embassy 2008-07-21 TURKEY Gephardt Group Government Affairs, LLC 5874 2008-07-21 Gephardt Group Government Affairs, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
16793 16793 2016-12-31 Republic of Turkey, Embassy 2016-07-29 TURKEY APCO Worldwide, Inc. 6291 2015-04-28 APCO Worldwide, Inc. 2525 Massachusetts Avenue, NW   Washington DC 20008
16802 16802 2017-12-31 Embassy of the Republic of Turkey 2017-05-09 TURKEY BCW LLC 6227 2014-06-18 BCW LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
16814 16814 2017-12-31 Ministry of Foreign Affairs, Government of Turkey 2017-12-21 TURKEY King & Spalding LLP 6501 2017-12-21 King & Spalding LLP 2525 Massachusetts Avenue, NW   Washington DC 20008
16835 16835 2018-12-31 Republic of Turkey through Greenberg Traurig 2017-01-18 TURKEY Daschle Group, LLC 6280 2015-03-16 Daschle Group, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
16897 16897 2021-12-31 Embassy of Turkey 2021-09-19 TURKEY MWM Murray Consulting, LLC 7016 2021-09-19 MWM Murray Consulting, LLC 2525 Massachusetts Ave NW   Washington DC 20008
16931 16931 2022-12-31 Republic of Turkey 2022-01-04 TURKEY The Van Aucker Group 7066 2022-01-04 The Van Aucker Group 2525 Massachusetts Ave 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])
);
Powered by Datasette · Queries took 161.657ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history