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

10 rows where Registrant_Name = "Ketchum Inc. NY"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Country/Location_Represented 8

State 4

Registrant_Name 1

  • Ketchum Inc. NY · 10 ✖
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
1023 1023 2016-01-01 Extenda 2014-10-06 SPAIN Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 817 Broadway Avenue, 2nd Floor   New York NY 10003
1024 1024 2016-01-01 Gazprom Export 2007-08-07 RUSSIA Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 16 Nametkina Street, V-420, GSP-7   Moscow 117997    
1025 1025 2016-01-01 ICEX Spain Trade and Investment 2014-10-06 SPAIN Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 405 Lexington Avenue 44th Floor New York NY 10174
1027 1027 2016-01-01 Russian Federation 2006-05-09 RUSSIA Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY          
1028 1028 2016-01-01 Tourism Australia 2012-09-05 AUSTRALIA Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 6100 Center Drive, Suite 1150   Los Angeles CA 90045
4750 4750 2015-03-31 Republic of Ecuador, Embassy 2014-04-01 ECUADOR Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 2535 15th Street, NW   Washington DC 20009
6245 6245 2018-05-01 Turkish Exporters' Assembly (TiM) 2018-01-03 TURKEY Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY Dis Ticaret Kompleksi Cobancesme Mevkii Sanayi Cd. B Blok Kat:9 (34196) Yenibosna-Istanbul      
7235 7235 2011-05-31 Kingdom of Saudi Arabia 2011-02-03 SAUDI ARABIA Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY Imam Saud Bin Abdulaziz Road PO Box 5927 Riyadh 11432      
7261 7261 2016-05-31 Republic of Honduras 2015-08-31 HONDURAS Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY Edificio Ejectivo Las Lomas Boulevard Juan Pablo II Tegucigalpa      
13473 13473 2016-10-31 Economic Development Board, Singapore 2016-08-10 SINGAPORE Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 250 North Bridge Road Singapore 179101      

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])
);