List of all foreign principals (active and terminated)

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

41 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)

State

Registrant_Name

Registrant_Date (date)

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
117   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
226   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
236   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      
276   Government of Ethiopia (through Mercury International UK Ltd.) 2021-09-02 ETHIOPIA 6170 6170 2013-05-14 Mercury Public Affairs, LLC 3506 International Drive, NW   Washington DC 20008
288   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    
314   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      
329   Hikvision USA Inc. 2018-08-16 CHINA 6170 6170 2013-05-14 Mercury Public Affairs, LLC 18639 Railroad Street   City of Industry CA 91748
381   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
435   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
460   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      
470   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    
516   Okinawa Prefecture 2015-06-03 JAPAN 6170 6170 2013-05-14 Mercury Public Affairs, LLC 1101 Connecticut Avenue, NW Suite 450 Washington DC 20036
540   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    
554   Q Cyber Technologies Ltd 2019-12-25 ISRAEL 6170 6170 2013-05-14 Mercury Public Affairs, LLC   Galgaley Haplada 22 Herzliya      
694   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      
1842 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      
3022 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
4628 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      
4629 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
4666 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
4957 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
5168 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
5924 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        
6221 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    
6526 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        
7043 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      
7046 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
7052 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
7243 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        
7631 2017-06-15 Commonwealth of Dominica 2017-03-09 DOMINICA 6170 6170 2013-05-14 Mercury Public Affairs, LLC          
8486 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          
8889 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    
10067 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      
10383 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      
12382 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      
12384 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
12602 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
14197 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      
14198 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      
14333 2015-12-01 Government of Uganda 2014-07-30 UGANDA 6170 6170 2013-05-14 Mercury Public Affairs, LLC P.O. Box 25497 Kamplala      
16331 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])
);