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

37 rows where Registration_Number = 6170 sorted by Registrant_Date

View and edit SQL

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

State

Registrant_Name

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
108   Consulate General of Japan 2018-07-11 JAPAN 6170 6170 2013-05-14 Mercury Public Affairs, LLC 299 Park Avenue, 19th Floor   New York NY 10171
191   Embassy of the Republic of Turkey 2018-05-04 TURKEY 6170 6170 2013-05-14 Mercury Public Affairs, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
204   Embassy of the State of Qatar 2019-12-10 QATAR 6170 6170 2013-05-14 Mercury Public Affairs, LLC 2555 M Street NW   Washington DC 20037
215   En+ Group international Public Joint-Stock Company 2019-05-22 RUSSIA 6170 6170 2013-05-14 Mercury Public Affairs, LLC Office 34, Building 8 Oktyabrskaya Street Kaliningrad 236006      
274   Government of National Accord Libya, Office of the Prime Minister 2019-04-26 LIBYA 6170 6170 2013-05-14 Mercury Public Affairs, LLC Tariq Al Seka Ben Ashour District Tripoli    
310   Hikvision USA Inc. 2018-08-16 CHINA 6170 6170 2013-05-14 Mercury Public Affairs, LLC 18639 Railroad Street   City of Industry CA 91748
440   Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) 2019-09-11 ZIMBABWE 6170 6170 2013-05-14 Mercury Public Affairs, LLC P.O. Box 4240, Munhumutapa Building Samora Machel Avenue/Sam Nujoma Street Harare      
452   Ministry of Justice, Republic of Kazakhstan through Latham & Watkins LLP 2018-04-02 KAZAKHSTAN 6170 6170 2013-05-14 Mercury Public Affairs, LLC Left Bank, Mangilik El Street 8 House of Ministries, 13 entrance Astana    
484   Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB 2019-10-01 BIAFRA 6170 6170 2013-05-14 Mercury Public Affairs, LLC Nnamdi Kanu 7432 East Trimmier Road Killeen TX 76542
488   Okinawa Prefecture 2015-06-03 JAPAN 6170 6170 2013-05-14 Mercury Public Affairs, LLC 1101 Connecticut Avenue, NW Suite 450 Washington DC 20036
509   Presidency of the Republic of Haiti (through Mercury International UK Ltd) 2018-02-23 HAITI 6170 6170 2013-05-14 Mercury Public Affairs, LLC 1 Rue de la Republique Port-au-Prince, Haiti Mercury International UK Ltd: 21-22 Grosvenor Street, London, London W1K 4QJ    
525   Q Cyber Technologies Ltd 2019-12-25 ISRAEL 6170 6170 2013-05-14 Mercury Public Affairs, LLC   Galgaley Haplada 22 Herzliya      
666   Turkey-U.S. Business Council (TAIK) 2020-01-10 TURKEY 6170 6170 2013-05-14 Mercury Public Affairs, LLC River Plaza Buyukdere Cd. Bahar Sk. No: 13/10 34394 Levent/IST      
1800 2017-01-31 International Agency for Regional Development (Globee) 2016-12-13 UKRAINE 6170 6170 2013-05-14 Mercury Public Affairs, LLC 5 Geroev Nebesnoy Sontni Square, Suite 23 Kharkov 61001      
2962 2017-02-28 Libertas Foundation, Inc. 2017-02-23 INTERNATIONAL 6170 6170 2013-05-14 Mercury Public Affairs, LLC 1719 East 12th Street   Brooklyn NY 11229
4554 2018-03-31 Consejo de Desarollo Economco de Sinaloa 2017-05-24 MEXICO 6170 6170 2013-05-14 Mercury Public Affairs, LLC Av. Insurgentes s/n Tercer Piso, Centro Sinaloa, C.P. 80129 Culiacan, Sinaloa      
4555 2018-03-31 Embassy of Japan 2016-07-22 JAPAN 6170 6170 2013-05-14 Mercury Public Affairs, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
4858 2019-04-09 American-Turkish Council (ATC) 2019-04-03 TURKEY 6170 6170 2013-05-14 Mercury Public Affairs, LLC 1101 Wilson Blvd. 6th Floor Arlington VA 22209
5068 2019-04-16 CRRC MA Corporation 2019-02-01 CHINA 6170 6170 2013-05-14 Mercury Public Affairs, LLC 108 Myrtle Street   Quincy MA 02171
5822 2019-04-30 Turkey - U.S. Business Council (TAIK) 2018-02-22 TURKEY 6170 6170 2013-05-14 Mercury Public Affairs, LLC River Plaza Buyukdere Cd. Bahar Sk. No:13/10 34394 Levent/IST        
6105 2014-05-08 European Centre For a Modern Ukraine 2017-04-28 UKRAINE 6170 6170 2013-05-14 Mercury Public Affairs, LLC 14 Rue de la Science, 1040   Brussels    
6405 2019-05-22 Lord Gregory Barker of Battle PC 2018-05-04 RUSSIA 6170 6170 2013-05-14 Mercury Public Affairs, LLC 8 Cleveland Row, London, United Kingdom, SW1A 1DH        
6921 2015-05-31 Adesina, Akinwumi 2015-05-01 NIGERIA 6170 6170 2013-05-14 Mercury Public Affairs, LLC Federal Ministry of Agriculture & Rural Development Federal Republic of Nigeria Complex Republic of Nigeria Complex Block A, Area 11 PMB 135 Garki, Abuja      
6924 2015-05-31 Government of Nigeria, Embassy 2013-08-02 NIGERIA 6170 6170 2013-05-14 Mercury Public Affairs, LLC 3519 International Court, NW   Washington DC 20008
6930 2016-05-31 Embassy of Republic of Turkey through Amsterdam & Partners, LLP 2016-03-16 TURKEY 6170 6170 2013-05-14 Mercury Public Affairs, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
7117 2018-06-01 Rwanda Development Board (through Peter Greenberg Worldwide) 2018-04-11 RWANDA 6170 6170 2013-05-14 Mercury Public Affairs, LLC Rwanda Development Board: KG 220 St., Kigali        
7499 2017-06-15 Commonwealth of Dominica 2017-03-09 DOMINICA 6170 6170 2013-05-14 Mercury Public Affairs, LLC          
8349 2014-06-30 Ministry of Foreign Affairs of the Government of Somaliland 2013-12-11 SOMALILAND 6170 6170 2013-05-14 Mercury Public Affairs, LLC          
8744 2020-07-09 People's Progressive Party (Guyana) 2019-03-07 GUYANA 6170 6170 2013-05-14 Mercury Public Affairs, LLC Freedom House 41 Robb Street Lacytown Georgetown    
9909 2018-08-14 ZTE Corporation (through Hogan Lovells US LLP) 2018-05-24 CHINA 6170 6170 2013-05-14 Mercury Public Affairs, LLC ZTE: ZTE Plaza, Keji Road South, Hi-Tech Industrial Park Nanshan District, Shenzen, P.R. China      
10223 2018-08-22 Government of the Republic of Cameroon (through TopCom SA) 2018-08-08 CAMEROON 6170 6170 2013-05-14 Mercury Public Affairs, LLC TopCom: Bastos BP, Yaounde, PO Box 1987 Republic of Cameroon, Africa Gov't of Cameroon: PO Box 100 Yaounde, Republic of Cameroon, Africa      
12189 2019-10-15 Alliance of Liberals and Democrats of Romania (ALDE) (through Keystone Strategic Advisers, LLC 2019-04-08 ROMANIA 6170 6170 2013-05-14 Mercury Public Affairs, LLC ALDE: Soseaua Pavel Dimitrievici Kiseleff, Nr. 57, Sector 1, Bucuresti      
12191 2019-10-15 Embassy of the State of Qatar 2015-01-02 QATAR 6170 6170 2013-05-14 Mercury Public Affairs, LLC 2555 M Street, NW   Washington DC 20037
13981 2019-11-30 Global Axis Partnership 2019-03-29 INDONESIA 6170 6170 2013-05-14 Mercury Public Affairs, LLC Sudirman Central Business District Lot. 18 Tower A 8th Floor J1. Jenderal Sudirman Kav. 52-53 Jakarta 112190      
13982 2019-11-30 Global IP - Cayman 2019-03-28 CAYMAN ISLANDS 6170 6170 2013-05-14 Mercury Public Affairs, LLC Willow House, Cricket Square, Floor 4 George Town KY1-9010      
14112 2015-12-01 Government of Uganda 2014-07-30 UGANDA 6170 6170 2013-05-14 Mercury Public Affairs, LLC P.O. Box 25497 Kamplala      
16103 2014-12-31 Government of Mauritius 2013-05-14 MAURITIUS 6170 6170 2013-05-14 Mercury Public Affairs, LLC 211 East 43rd Street Suite 1502 New York NY 10017

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