List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

40 rows where Registration_Number = 6170 sorted by Registrant_Date

View and edit SQL

Suggested facets: Foreign_Principal_Termination_Date, Address_2, Zip, 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
111   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
213   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
222   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      
277   Government of National Unity of Libya (through Mercury International UK Ltd.) 2019-04-26 LIBYA 6170 6170 2013-05-14 Mercury Public Affairs, LLC Tariq Al Seka Ben Ashour District Tripoli    
299   Government of the Republic of Uganda (through Mercury International UK Ltd.) 2021-04-26 UGANDA 6170 6170 2013-05-14 Mercury Public Affairs, LLC 25497 Kampala Road Kampala      
312   Hikvision USA Inc. 2018-08-16 CHINA 6170 6170 2013-05-14 Mercury Public Affairs, LLC 18639 Railroad Street   City of Industry CA 91748
361   JinkoSolar (U.S.) Inc. 2020-12-12 CHINA 6170 6170 2013-05-14 Mercury Public Affairs, LLC 595 Market Street Suite 2200 San Francisco CA 94105
411   MTG of DE, LLC (through Mercury International UK Ltd.) 2021-03-24 SAUDI ARABIA 6170 6170 2013-05-14 Mercury Public Affairs, LLC MTG of DE, LLC PO Box 650461 Sterling VA 21065
435   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      
447   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    
489   Okinawa Prefecture 2015-06-03 JAPAN 6170 6170 2013-05-14 Mercury Public Affairs, LLC 1101 Connecticut Avenue, NW Suite 450 Washington DC 20036
514   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    
526   Q Cyber Technologies Ltd 2019-12-25 ISRAEL 6170 6170 2013-05-14 Mercury Public Affairs, LLC   Galgaley Haplada 22 Herzliya      
662   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      
1806 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      
2984 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
4587 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      
4588 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
4620 2021-03-31 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
4911 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
5122 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
5879 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        
6170 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    
6472 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        
6989 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      
6992 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
6998 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
7187 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        
7574 2017-06-15 Commonwealth of Dominica 2017-03-09 DOMINICA 6170 6170 2013-05-14 Mercury Public Affairs, LLC          
8426 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          
8826 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    
10001 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      
10317 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      
12313 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      
12315 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
12531 2020-10-23 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
14124 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      
14125 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      
14260 2015-12-01 Government of Uganda 2014-07-30 UGANDA 6170 6170 2013-05-14 Mercury Public Affairs, LLC P.O. Box 25497 Kamplala      
16256 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])
);