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

9 rows where Registration_Number = 6162

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal 9

  • Association of Cyprus Banks (ACB) (via Pillsbury Winthrop Shaw Pittman LLP) 1
  • COSCO Shipping Holdings Co., Ltd. (through The Harbour Group) 1
  • Emirate of Ras Al Khaimah 1
  • Government of the Republic of Serbia 1
  • NEOM (through Richard Attias and Associates Saudi for Organization of Exhibitions Co.) 1
  • Public Investment Fund 1
  • Stiftung Pressischer Kulturbesitz (SPK) (through Wiggin and Dana LLP) 1
  • Ukranian Federation of Employers of the Oil and Gas Industry (UFEOGI) 1
  • YB DATO' SERI HJ. NAJIB BIN TUN HJ. ABDUL RAZAK (Najib Razak) (through Scivetti & Associates) 1

Country/Location_Represented 8

  • SAUDI ARABIA 2
  • CHINA 1
  • CYPRUS 1
  • GERMANY 1
  • MALAYSIA 1
  • SERBIA 1
  • UKRAINE 1
  • UNITED ARAB EMIRATES 1

City 4

  • - 6
  • Washington 1
  • Kuala Lumpur 1
  • Kyiv 1

State 2

  • - 8
  • DC 1

Registrant_Name 1

  • KARV Communications, Inc. 9
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
235 235   Emirate of Ras Al Khaimah 2013-04-08 UNITED ARAB EMIRATES KARV Communications, Inc. 6162 2013-04-08 KARV Communications, Inc. P.O. Box 5130 Ras Al Khaimah      
308 308   Government of the Republic of Serbia 2023-07-21 SERBIA KARV Communications, Inc. 6162 2013-04-08 KARV Communications, Inc. 1333 16th Street, NW   Washington DC 20036
504 504   NEOM (through Richard Attias and Associates Saudi for Organization of Exhibitions Co.) 2023-04-11 SAUDI ARABIA KARV Communications, Inc. 6162 2013-04-08 KARV Communications, Inc. RDC Complex, Building CS01, 4th Floor, Unit 9, 3884 Al Imam Saud Ibn Abdul Aziz Branch Road Al Nakhi      
658 658   Stiftung Pressischer Kulturbesitz (SPK) (through Wiggin and Dana LLP) 2020-12-06 GERMANY KARV Communications, Inc. 6162 2013-04-08 KARV Communications, Inc. Von-der-Heydt-StraSe 16-18 10785 Berlin      
6123 6123 2023-04-30 Ukranian Federation of Employers of the Oil and Gas Industry (UFEOGI) 2021-07-09 UKRAINE KARV Communications, Inc. 6162 2013-04-08 KARV Communications, Inc. 97/37 Volodymyrska str, 01033 Kyiv    
7807 7807 2022-06-14 YB DATO' SERI HJ. NAJIB BIN TUN HJ. ABDUL RAZAK (Najib Razak) (through Scivetti & Associates) 2022-03-07 MALAYSIA KARV Communications, Inc. 6162 2013-04-08 KARV Communications, Inc. No. 11, Jalan Langgak Duta Taman Duta 50480 Kuala Lumpur    
8778 8778 2021-06-30 Public Investment Fund 2019-02-25 SAUDI ARABIA KARV Communications, Inc. 6162 2013-04-08 KARV Communications, Inc. Alraidah Digital City, Building CS01, Al Nakhil District P.O. Box 6847 Riyadh 11452      
9918 9918 2018-07-31 COSCO Shipping Holdings Co., Ltd. (through The Harbour Group) 2017-08-28 CHINA KARV Communications, Inc. 6162 2013-04-08 KARV Communications, Inc. 8/F No. 658 Dong Da Ming Road Shanghai China 200080      
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 179.364ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history