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

26 rows where "Foreign_Principal_Termination_Date" is on date 2020-12-31

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal 26

  • Ali Arslan, MP 1
  • Alvaro Uribe through 31416 S.A.S. 1
  • Banthoon Lamsam, on behalf of Kasikornbank Public Company Ltd. 1
  • Cayman Islands Ministry of Financial Services, Commerce & Environment 1
  • Center for International Policy (under grant from the Norwegian Agency for Development Cooperation) 1
  • Consulate General of the Dominican Republic 1
  • Embassy of the State of Qatar 1
  • Ennahdha Party 1
  • European Federation for Transport and Environment (under grant from the Norwegian Agency for Development Cooperation) 1
  • Government of the Republic of Cameroon 1
  • Head of Administration of the Government of Georgia 1
  • Korea Foundation 1
  • Macao Government Tourism Office 1
  • National Media Council of the United Arab Emirates 1
  • National Wildlife Federation (under grant from the Norwegian Agency for Development Cooperation) 1
  • Office of the President of the National Assembly 1
  • Papua New Guinea Tourism Promotion Authority 1
  • Petroleos de Venezuela, S.A. (PDVSA) 1
  • Philippine Department of Tourism 1
  • Polska Grupa Zbrojeniowa 1
  • Royal Embassy of Saudi Arabia through Larson Shannahan Slifka Group, LLC 1
  • Taipei Economic & Cultural Representative Office in the U.S. 1
  • Tourism Australia 1
  • Turismo de Tenerife 1
  • Uranium One, Inc. 1
  • VTA Telecom Corporation Viettel Group 1

Country/Location_Represented 24

  • NORWAY 3
  • AUSTRALIA 1
  • CAMEROON 1
  • CAYMAN ISLANDS 1
  • COLOMBIA 1
  • CONGO, DEMOCRATIC REPUBLIC OF THE 1
  • DOMINICAN REPUBLIC 1
  • GEORGIA 1
  • KOREA, SOUTH 1
  • MACAU 1
  • PAPUA NEW GUINEA 1
  • PHILIPPINES 1
  • POLAND 1
  • QATAR 1
  • RUSSIA 1
  • SAUDI ARABIA 1
  • SPAIN 1
  • TAIWAN 1
  • THAILAND 1
  • TUNISIA 1
  • TURKEY 1
  • UNITED ARAB EMIRATES 1
  • VENEZUELA 1
  • VIETNAM 1

Registrant_Name 21

  • Myriad International Marketing, LLC 3
  • Waxman Consulting, Inc. DBA Waxman Strategies 3
  • MMGY Global, LLC 2
  • Avenue Strategies, LLC 1
  • BCW LLC 1
  • BGR Government Affairs, LLC 1
  • Center for International Policy 1
  • DCI Group AZ, LLC 1
  • Greystone Global Strategies 1
  • Hathaway Strategies, LLC 1
  • International Trade & Development Agency, Inc. 1
  • Lexington Avenue Consulting 1
  • Luque PLLC 1
  • McDermott Will & Emery, LLP 1
  • PDV USA, Inc. 1
  • Pillsbury Winthrop Shaw Pittman, LLP 1
  • Project Associates UK Ltd 1
  • Rubenstein Public Relations, Inc. 1
  • Squire Patton Boggs, LLP 1
  • StrateVarious LLC 1
  • Tenam Corporation 1

City 7

  • - 18
  • Washington 3
  • Abu Dhabi 1
  • Los Angeles 1
  • New York 1
  • Reston 1
  • Tbilisi 1

State 5

  • - 20
  • DC 3
  • CA 1
  • NY 1
  • VA 1
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
16867 16867 2020-12-31 Ali Arslan, MP 2020-10-07 TURKEY Avenue Strategies, LLC 6446 2017-07-24 Avenue Strategies, LLC Grand National Assembly of Turkey Ankara      
16868 16868 2020-12-31 Alvaro Uribe through 31416 S.A.S. 2020-08-24 COLOMBIA DCI Group AZ, LLC 6278 2015-03-03 DCI Group AZ, LLC Carrera 35 #15 B 143 35 Palms, Floor 4      
16869 16869 2020-12-31 Banthoon Lamsam, on behalf of Kasikornbank Public Company Ltd. 2018-07-05 THAILAND Luque PLLC 6568 2018-07-05 Luque PLLC 1 Soi Rat Burana 27/1 Rat Burana Road Bangkok 10140      
16870 16870 2020-12-31 Cayman Islands Ministry of Financial Services, Commerce & Environment 2016-09-02 CAYMAN ISLANDS Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Government Administration Building, Box 126 133 Elgin Avenue, Grand Cayman KY1-9000      
16871 16871 2020-12-31 Center for International Policy (under grant from the Norwegian Agency for Development Cooperation) 2019-08-23 NORWAY Waxman Consulting, Inc. DBA Waxman Strategies 6710 2019-08-23 Waxman Consulting, Inc. DBA Waxman Strategies 2000 M Street, NW Suite 720 Washington DC 20036
16872 16872 2020-12-31 Consulate General of the Dominican Republic 2019-06-14 DOMINICAN REPUBLIC Rubenstein Public Relations, Inc. 6691 2019-06-14 Rubenstein Public Relations, Inc. 1501 Broadway, 4th Floor   New York NY 10036
16873 16873 2020-12-31 Embassy of the State of Qatar 2019-12-30 QATAR Lexington Avenue Consulting 6777 2019-12-30 Lexington Avenue Consulting 2555 M Street, NW   Washington DC 20037
16874 16874 2020-12-31 Ennahdha Party 2014-09-18 TUNISIA BCW LLC 6227 2014-06-18 BCW LLC          
16875 16875 2020-12-31 European Federation for Transport and Environment (under grant from the Norwegian Agency for Development Cooperation) 2019-08-23 NORWAY Waxman Consulting, Inc. DBA Waxman Strategies 6710 2019-08-23 Waxman Consulting, Inc. DBA Waxman Strategies 18 Square De Meeus, 2nd Floor, Brussels, Belgium 1050        
16876 16876 2020-12-31 Government of the Republic of Cameroon 2004-08-17 CAMEROON Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Prime Minister's Office P.O. Box 13292 Yaounda        
16877 16877 2020-12-31 Head of Administration of the Government of Georgia 2017-07-29 GEORGIA StrateVarious LLC 6449 2017-07-29 StrateVarious LLC The Treasury Ingorokva St. #7 Tbilisi    
16878 16878 2020-12-31 Korea Foundation 2020-11-25 KOREA, SOUTH Center for International Policy 6896 2020-11-25 Center for International Policy 55, Sinjung-ro Seogwip-si, Jeju-do 63565      
16879 16879 2020-12-31 Macao Government Tourism Office 2020-01-06 MACAU MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC Alameda Dr. Carlos d'Assumpcao, n.os 335-341 12 Andar      
16880 16880 2020-12-31 National Media Council of the United Arab Emirates 2017-10-06 UNITED ARAB EMIRATES Project Associates UK Ltd 6472 2017-10-06 Project Associates UK Ltd Al Muroor Street P.O. Box 3790 Abu Dhabi    
16881 16881 2020-12-31 National Wildlife Federation (under grant from the Norwegian Agency for Development Cooperation) 2019-08-23 NORWAY Waxman Consulting, Inc. DBA Waxman Strategies 6710 2019-08-23 Waxman Consulting, Inc. DBA Waxman Strategies 11100 Wildlife Center Drive   Reston VA 20190
16882 16882 2020-12-31 Office of the President of the National Assembly 2020-08-04 CONGO, DEMOCRATIC REPUBLIC OF THE Greystone Global Strategies 6846 2020-08-04 Greystone Global Strategies People's Palace Kinshasa      
16883 16883 2020-12-31 Papua New Guinea Tourism Promotion Authority 2020-01-06 PAPUA NEW GUINEA MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC Pacific MMI Building Level 5 Port Moresby      
16884 16884 2020-12-31 Petroleos de Venezuela, S.A. (PDVSA) 2020-12-31 VENEZUELA PDV USA, Inc. 6903 2020-12-31 PDV USA, Inc. Avenida Libertador, La Campina, Apdo. 169 Caracas 1010-A      
16885 16885 2020-12-31 Philippine Department of Tourism 2018-12-18 PHILIPPINES Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC          
16886 16886 2020-12-31 Polska Grupa Zbrojeniowa 2017-11-20 POLAND BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC ul. Nowy Swiat 4a, 00-497 Warszawa      
16887 16887 2020-12-31 Royal Embassy of Saudi Arabia through Larson Shannahan Slifka Group, LLC 2019-12-03 SAUDI ARABIA Hathaway Strategies, LLC 6761 2019-12-03 Hathaway Strategies, LLC 610 New Hampshire, NW   Washington    
16888 16888 2020-12-31 Taipei Economic & Cultural Representative Office in the U.S. 1995-08-28 TAIWAN International Trade & Development Agency, Inc. 3690 1985-06-13 International Trade & Development Agency, Inc. Washington     DC  
16889 16889 2020-12-31 Tourism Australia 2018-04-30 AUSTRALIA Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC 2029 Century Park E Ste 3150   Los Angeles CA 90067
16890 16890 2020-12-31 Turismo de Tenerife 2019-11-26 SPAIN Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC          
16891 16891 2020-12-31 Uranium One, Inc. 2019-02-18 RUSSIA Tenam Corporation 6638 2019-02-18 Tenam Corporation 333 Bay Street #12-- Toronto, Ontario M5H 2R2      
16892 16892 2020-12-31 VTA Telecom Corporation Viettel Group 2017-09-07 VIETNAM McDermott Will & Emery, LLP 6447 2017-07-27 McDermott Will & Emery, LLP 1551 McCarthy Blvd. STE 210, Milpitas, CA 95935 1 Tran Huu Duc, My Dinh, Tu Liem, Hanoi      

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