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

53 rows where Country/Location_Represented = "CYPRUS"

✎ 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

  • Cameron & Hornbostel, L.L.P. 2
  • International Public Relations Company, Ltd. 2
  • Manatos & Manatos 2
  • Manatt, Phelps & Phillips 2
  • Alcalde & Fay 1
  • Alston & Bird, LLP 1
  • BKSH & Associates 1
  • Berliner Corcoran & Rowe, LLP 1
  • Brown Nelson & Associates, Inc. 1
  • CMS Strategies, LLC 1
  • Covington & Burling, LLP 1
  • DLA Piper US LLP 1
  • Daniel J. Edelman, Inc. 1
  • Delihas, James 1
  • Derwinski, Edward 1
  • Donald N. Martin & Company, Inc. 1
  • Eckert International, Inc. 1
  • European Travel Commission 1
  • Evans Group, Ltd. 1
  • Federalist Group, an Ogilvy PR Worldwide Company 1
  • Harff Butterfield, Inc. 1
  • Hecht, Spencer & Associates, Inc. 1
  • Herrick, Feinstein LLP 1
  • Hogan Lovells US LLP 1
  • Independent Diplomat, Inc. 1
  • Jacobs, Barry 1
  • KARV Communications, Inc. 1
  • LB International Solutions, LLC 1
  • Manatos & Manatos (through the National Coordinated Effort of Hellenes - CEH) 1
  • Mullin Communications, Inc. 1
  • …

Foreign_Principal >30

  • Republic of Cyprus 7
  • Republic of Cyprus, Embassy 4
  • Turkish Republic of Northern Cyprus 4
  • Freedom & Justice for Cyprus Trust 3
  • Cyprus Tourism Organization 2
  • Government of Cyprus 2
  • Government of the Republic of Cyprus 2
  • Government of the Republic of Cyprus, Embassy 2
  • Polygon Company, Ltd. 2
  • Association of Cyprus Banks 1
  • Association of Cyprus Banks (ACB) (via Pillsbury Winthrop Shaw Pittman LLP) 1
  • Consulate General of Cyprus in New York 1
  • Embassy of Cyprus 1
  • Embassy of the Republic of Cyprus 1
  • Embassy of the Republic of Cyprus, through Covington & Burling LLP 1
  • Festival Shipping & Tourist Enterprises, Ltd. 1
  • Foreign Ministry of the Turkish Republic of Northern Cyprus 1
  • Government of Cyprus, Embassy 1
  • Government of the Republic of Cyprus, Embassy, through Patton Boggs LLP 1
  • Mehmet Ali Talat 1
  • Ministry of Commerce & Industry (Tourist Section) of Cyprus 1
  • Office of the Turkish State of North Cyprus 1
  • PSEKA, International Co-Ordinating Committee -- Justice for Cyprus 1
  • PSEKA, International Coordinating Committee--Justice for Cyprus 1
  • Polygon Co., Ltd. 1
  • Republic of Cyprus Government, Embassy 1
  • Republic of Cyprus through Podesta Group 1
  • Republic of Cyprus, Embassy through Covington & Burling 1
  • Republic of Cyprus, Embassy, through Patton Boggs LLP 1
  • Turkish Republic of Northern Cyprus (T.R.N.C.")" 1
  • …

State 4

  • - 27
  • DC 21
  • NY 4
  • VA 1

City 2

  • - 44
  • Washington 9

Country/Location_Represented 1

  • CYPRUS · 53 ✖
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
306 306   Government of the Republic of Cyprus 2019-05-21 CYPRUS Manatos & Manatos (through the National Coordinated Effort of Hellenes - CEH) 6683 2019-05-21 Manatos & Manatos (through the National Coordinated Effort of Hellenes - CEH) Commissioner's Office for issues relating to Overseas Affairs 56 Kyriakou Matsi Avenue 1082 Nicosia      
727 727   Turkish Republic of Northern Cyprus (TRNC) Washington DC Office 2023-01-03 CYPRUS LB International Solutions, LLC 6210 2014-03-03 LB International Solutions, LLC 1667 K Street NW, Suite 690   Washington DC 20006
729 729   Turkish Republic of Northern Cyprus, H.E. Mr. Ersin Tatar 1975-10-16 CYPRUS Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus          
908 908 1988-01-01 Freedom & Justice for Cyprus Trust 1986-10-21 CYPRUS Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Nicosia        
1349 1349 2001-01-15 Republic of Cyprus 1989-03-02 CYPRUS Evans Group, Ltd. 4222 1989-03-02 Evans Group, Ltd. Nicosia        
2266 2266 1995-02-07 Festival Shipping & Tourist Enterprises, Ltd. 1991-12-13 CYPRUS Eckert International, Inc. 4198 1988-12-16 Eckert International, Inc. Oakton     VA  
3021 3021 1997-02-28 Polygon Company, Ltd. 1993-11-01 CYPRUS Cameron & Hornbostel, L.L.P. 4705 1992-08-19 Cameron & Hornbostel, L.L.P. Nicosia        
3062 3062 2003-02-28 Polygon Company, Ltd. 1999-02-02 CYPRUS Berliner Corcoran & Rowe, LLP 5299 1999-02-02 Berliner Corcoran & Rowe, LLP Nicosia        
3161 3161 2000-02-29 Government of the Republic of Cyprus, Embassy 1997-10-03 CYPRUS Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
3281 3281 1987-03-01 Freedom & Justice for Cyprus Trust 1986-10-31 CYPRUS Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Nicosia        
3577 3577 1995-03-10 Cyprus Tourism Organization 1993-06-29 CYPRUS Peter Martin Associates, Inc. 4236 1989-04-05 Peter Martin Associates, Inc.          
3911 3911 1982-03-20 Republic of Cyprus 1982-12-01 CYPRUS International Public Relations Company, Ltd. 1967 1966-03-14 International Public Relations Company, Ltd.          
3913 3913 1989-03-20 Republic of Cyprus 1985-09-20 CYPRUS Manatt, Phelps & Phillips 3736 1985-09-20 Manatt, Phelps & Phillips Nicosia        
4035 4035 1966-03-25 Government of Cyprus 1966-03-25 CYPRUS Patsalos, Nicholas A. 1971 1966-03-25 Patsalos, Nicholas A. New York     NY  
4126 4126 1999-03-28 Government of the Republic of Cyprus 1995-04-11 CYPRUS Derwinski, Edward 5011 1995-04-11 Derwinski, Edward Washington     DC  
4166 4166 1987-03-30 Republic of Cyprus 1983-07-13 CYPRUS Delihas, James 3497 1983-07-13 Delihas, James          
4228 4228 1998-03-30 Unicom Management Services, Ltd. 1998-03-30 CYPRUS Brown Nelson & Associates, Inc. 4615 1992-02-12 Brown Nelson & Associates, Inc. Oasis Centre, Corner Gladstone/Karaiskakis St., P.O. Box 6674, 3032 Limassol        
4495 4495 1990-03-31 Turkish Republic of Northern Cyprus 1988-05-17 CYPRUS Harff Butterfield, Inc. 4140 1988-05-17 Harff Butterfield, Inc. Washington     DC  
4951 4951 2004-04-01 Republic of Cyprus Government, Embassy 2001-02-22 CYPRUS DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2211 R Street, N.W. 20008     DC  
5465 5465 1993-04-21 PSEKA, International Coordinating Committee--Justice for Cyprus 1991-07-12 CYPRUS Manatos & Manatos 3522 1983-09-28 Manatos & Manatos Nicosia        
6012 6012 2003-04-30 Government of Cyprus, Embassy 1998-04-17 CYPRUS Mullin Communications, Inc. 5253 1998-04-17 Mullin Communications, Inc. 2211 R Street, N.W.     DC  
6064 6064 2010-04-30 Turkish Republic of Northern Cyprus 2008-12-15 CYPRUS Independent Diplomat, Inc. 5860 2008-04-03 Independent Diplomat, Inc. Mehmet Ali Talat, President TRNC Nicosia      
7546 7546 1993-06-03 Cyprus Tourism Organization 1984-12-06 CYPRUS Donald N. Martin & Company, Inc. 1381 1960-07-29 Donald N. Martin & Company, Inc. New York     NY  
7598 7598 2019-06-04 Turkish Republic of Northern Cyprus (TRNC) 2016-09-19 CYPRUS Prime Policy Group 6377 2016-09-19 Prime Policy Group 1667 K Street, NW   Washington DC 20006
7642 7642 1994-06-06 Turkish Republic of Northern Cyprus 1990-08-03 CYPRUS Steptoe & Johnson, L.L.P. 3975 1987-05-08 Steptoe & Johnson, L.L.P. Mersin        
7893 7893 1991-06-17 Republic of Cyprus 1991-05-17 CYPRUS Alcalde & Fay 3571 1984-03-14 Alcalde & Fay Nicosia        
8881 8881 1990-07-01 PSEKA, International Co-Ordinating Committee -- Justice for Cyprus 1990-09-10 CYPRUS Manatos & Manatos 3522 1983-09-28 Manatos & Manatos Nicosia        
8996 8996 2014-07-03 Republic of Cyprus through Podesta Group 2012-12-12 CYPRUS Roberti + White, LLC 6065 2011-09-23 Roberti + White, LLC 2211 R Street, NW   Washington DC 20008
9838 9838 2002-07-31 Embassy of Cyprus 2002-01-30 CYPRUS Video Placement Worldwide - A Division of JD Communikaters 5468 2002-01-30 Video Placement Worldwide - A Division of JD Communikaters 2211 R Street, N.W. 20008     DC  
9936 9936 2020-07-31 Association of Cyprus Banks 2019-08-28 CYPRUS Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 15, Demetriou Karatasou Str., 4th Floor, Flat 401 Nicosia 2024      
10520 10520 1985-08-15 Government of Cyprus 1984-01-27 CYPRUS O'Connor & Hannan, L.L.P. 2972 1978-10-25 O'Connor & Hannan, L.L.P. Washington     DC  
11105 11105 2006-08-31 Republic of Cyprus, Embassy through Covington & Burling 2004-06-17 CYPRUS Federalist Group, an Ogilvy PR Worldwide Company 5628 2004-06-17 Federalist Group, an Ogilvy PR Worldwide Company 2211 R Street, N.W. 20008     DC  
11106 11106 2006-08-31 Republic of Cyprus, Embassy 2004-05-07 CYPRUS Prism Public Affairs 5620 2004-05-07 Prism Public Affairs 2211 R Street, N.W. 20008     DC  
11111 11111 2007-08-31 Embassy of the Republic of Cyprus 2006-09-21 CYPRUS Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 2211 R Street, NW   Washington DC 20008
11112 11112 2007-08-31 Embassy of the Republic of Cyprus, through Covington & Burling LLP 2006-11-29 CYPRUS BKSH & Associates 5402 2000-12-14 BKSH & Associates 1201 Pennsylvania Avenue, NW   Washington DC 20004
11120 11120 2007-08-31 Republic of Cyprus, Embassy 2004-05-07 CYPRUS Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 2211 R Street, N.W. 20008     DC  
11153 11153 2015-08-31 Foreign Ministry of the Turkish Republic of Northern Cyprus 2013-09-09 CYPRUS Southfive Strategies, LLC 6186 2013-09-09 Southfive Strategies, LLC Lefkosa        
12218 12218 2013-09-30 Republic of Cyprus, Embassy 2012-11-08 CYPRUS Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc.          
12961 12961 1992-10-23 Republic of Cyprus 1989-10-31 CYPRUS Manatt, Phelps & Phillips 3736 1985-09-20 Manatt, Phelps & Phillips Nicosia        
13092 13092 1978-10-28 Consulate General of Cyprus in New York 1978-05-22 CYPRUS Perry, Marilyn Edith 2731 1976-10-27 Perry, Marilyn Edith New York     NY  
13455 13455 2011-10-31 Government of the Republic of Cyprus, Embassy 2007-09-25 CYPRUS Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2211 R Street, NW   Washington DC 20008
13456 13456 2011-10-31 Government of the Republic of Cyprus, Embassy, through Patton Boggs LLP 2007-10-03 CYPRUS QORVIS LLC 5483 2002-03-06 QORVIS LLC 2211 R Street, NW   Washington DC 20008
13459 13459 2011-10-31 Republic of Cyprus, Embassy, through Patton Boggs LLP 2006-09-12 CYPRUS CMS Strategies, LLC 5766 2006-09-12 CMS Strategies, LLC 2211 R Street, NW   Washington DC 20008
14374 14374 1987-11-30 Freedom & Justice for Cyprus Trust 1986-10-03 CYPRUS Hecht, Spencer & Associates, Inc. 3740 1985-09-26 Hecht, Spencer & Associates, Inc. Nicosia        
14509 14509 2003-11-30 Republic of Cyprus, Embassy 2003-05-16 CYPRUS Alston & Bird, LLP 5549 2003-04-01 Alston & Bird, LLP 224 R Street 20008     DC  
14558 14558 2015-11-30 Turkish Republic of Northern Cyprus (T.R.N.C.")" 2013-09-09 CYPRUS Herrick, Feinstein LLP 6185 2013-09-09 Herrick, Feinstein LLP Office of the Representative T.R.N.C. 1667 K Street, NW., Suite 690 Washington DC 20006
15502 15502 1998-12-30 Polygon Co., Ltd. 1998-10-19 CYPRUS Cameron & Hornbostel, L.L.P. 4705 1992-08-19 Cameron & Hornbostel, L.L.P. Nicosia        
15732 15732 1974-12-31 Ministry of Commerce & Industry (Tourist Section) of Cyprus 1973-11-26 CYPRUS European Travel Commission 574 1949-06-30 European Travel Commission Nicosia        
15883 15883 1982-12-31 Republic of Cyprus 1978-11-01 CYPRUS International Public Relations Company, Ltd. 1967 1966-03-14 International Public Relations Company, Ltd.          
15920 15920 1984-12-31 Office of the Turkish State of North Cyprus 1984-01-27 CYPRUS Szaz, Zoltan Michael 3187 1981-01-07 Szaz, Zoltan Michael New York     NY  
16029 16029 1987-12-31 Turkish Republic of Northern Cyprus 1985-06-04 CYPRUS Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs Washington     DC  
16664 16664 2009-12-31 Mehmet Ali Talat 2008-12-16 CYPRUS Jacobs, Barry 5900 2008-12-16 Jacobs, Barry Office of the President Lefkosa, Turkish Republic of North Cyprus      
16844 16844 2019-12-31 Association of Cyprus Banks (ACB) (via Pillsbury Winthrop Shaw Pittman LLP) 2019-08-28 CYPRUS KARV Communications, Inc. 6162 2013-04-08 KARV Communications, Inc. 15 Demetriou Karatasou Str., 4th Floor, Flat 401 Nicosia 2024      

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