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

49 rows where Registrant_Name = "Mercury Public Affairs, LLC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 7

Registrant_Name 1

  • Mercury Public Affairs, LLC · 49 ✖
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
128 128   Consulate General of Japan 2018-07-11 JAPAN Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 299 Park Avenue, 19th Floor   New York NY 10171
227 227   Embassy of the State of Qatar 2019-12-10 QATAR Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 2555 M Street NW   Washington DC 20037
264 264   GloBee International Agency for Regional Development (GloBee")" 2022-03-16 UKRAINE Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 5 Heroes of Nebesna Sotnya Square, ap 23   Kharkiv    
326 326   Hikvision USA Inc. 2018-08-16 CHINA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 18639 Railroad Street   City of Industry CA 91748
382 382   JinkoSolar (U.S.) Inc. 2020-12-12 CHINA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 595 Market Street Suite 2200 San Francisco CA 94105
516 516   National Gas Corp. Ltd. 2023-06-30 PAPUA NEW GUINEA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Kada Gura Commercial Center   Harbour City Port Moresby    
517 517   National Oil Corporation 2023-02-23 LIBYA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Asseka Road   Tripoli    
543 543   Okinawa Prefecture 2015-06-03 JAPAN Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1101 Connecticut Avenue, NW Suite 450 Washington DC 20036
622 622   Samsung Electronics Co., Ltd. (Samsung")" 2022-11-06 KOREA, SOUTH Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 129 Samsung-ro, Yeongtong-gu   Suwon, Gyeonggi    
1911 1911 2017-01-31 International Agency for Regional Development (Globee) 2016-12-13 UKRAINE Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 5 Geroev Nebesnoy Sontni Square, Suite 23 Kharkov 61001      
2717 2717 2023-02-22 Ministry of Justice, Republic of Kazakhstan through Latham & Watkins LLP 2018-04-02 KAZAKHSTAN Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Left Bank, Mangilik El Street 8 House of Ministries, 13 entrance Astana    
2760 2760 2022-02-24 En+ Group International Public Joint-Stock Company 2019-05-22 RUSSIA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Office 34, Building 8 Oktyabrskaya Street Kaliningrad 236006      
2761 2761 2022-02-24 Sovcombank PJSC (Sovcombank")" 2022-01-27 RUSSIA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 123100, Moscow, Russian Federation Krasnopresnenskaya Nab. 14/1      
3122 3122 2017-02-28 Libertas Foundation, Inc. 2017-02-23 INTERNATIONAL Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1719 East 12th Street   Brooklyn NY 11229
4770 4770 2018-03-31 Consejo de Desarollo Economco de Sinaloa 2017-05-24 MEXICO Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Av. Insurgentes s/n Tercer Piso, Centro Sinaloa, C.P. 80129 Culiacan, Sinaloa      
4771 4771 2018-03-31 Embassy of Japan 2016-07-22 JAPAN Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
4809 4809 2021-03-31 Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB 2019-10-01 BIAFRA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Nnamdi Kanu 7432 East Trimmier Road Killeen TX 76542
5122 5122 2019-04-09 American-Turkish Council (ATC) 2019-04-03 TURKEY Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1101 Wilson Blvd. 6th Floor Arlington VA 22209
5335 5335 2019-04-16 CRRC MA Corporation 2019-02-01 CHINA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 108 Myrtle Street   Quincy MA 02171
5440 5440 2022-04-20 African Development Bank (through Actum International UK Ltd.) (ADB")" 2021-09-28 INTERNATIONAL Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Avenue Joseph Anoma 01 B.P. 1387 Abidjan    
5442 5442 2022-04-20 Government of Ethiopia (through Actum International UK Ltd.) 2021-09-02 ETHIOPIA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 3506 International Drive, NW   Washington DC 20008
5443 5443 2022-04-20 Government of National Unity of Libya (through Actum International UK Ltd.) 2019-04-26 LIBYA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Tariq Al Seka Ben Ashour District Tripoli    
5444 5444 2022-04-20 Turkey-U.S. Business Council (TAIK) 2020-01-10 TURKEY Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC River Plaza Buyukdere Cd. Bahar Sk. No: 13/10 34394 Levent/IST      
6104 6104 2019-04-30 Turkey - U.S. Business Council (TAIK) 2018-02-22 TURKEY Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC River Plaza Buyukdere Cd. Bahar Sk. No:13/10 34394 Levent/IST        
6414 6414 2014-05-08 European Centre For a Modern Ukraine 2017-04-28 UKRAINE Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 14 Rue de la Science, 1040   Brussels    
6725 6725 2019-05-22 Lord Gregory Barker of Battle PC 2018-05-04 RUSSIA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 8 Cleveland Row, London, United Kingdom, SW1A 1DH        
7249 7249 2015-05-31 Adesina, Akinwumi 2015-05-01 NIGERIA Mercury Public Affairs, LLC 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      
7252 7252 2015-05-31 Government of Nigeria, Embassy 2013-08-02 NIGERIA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 3519 International Court, NW   Washington DC 20008
7258 7258 2016-05-31 Embassy of Republic of Turkey through Amsterdam & Partners, LLP 2016-03-16 TURKEY Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
7463 7463 2018-06-01 Rwanda Development Board (through Peter Greenberg Worldwide) 2018-04-11 RWANDA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Rwanda Development Board: KG 220 St., Kigali        
7863 7863 2017-06-15 Commonwealth of Dominica 2017-03-09 DOMINICA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC          
8723 8723 2014-06-30 Ministry of Foreign Affairs of the Government of Somaliland 2013-12-11 SOMALILAND Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC          
9147 9147 2020-07-09 People's Progressive Party (Guyana) 2019-03-07 GUYANA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Freedom House 41 Robb Street Lacytown Georgetown    
10345 10345 2018-08-14 ZTE Corporation (through Hogan Lovells US LLP) 2018-05-24 CHINA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC ZTE: ZTE Plaza, Keji Road South, Hi-Tech Industrial Park Nanshan District, Shenzen, P.R. China      
10667 10667 2018-08-22 Government of the Republic of Cameroon (through TopCom SA) 2018-08-08 CAMEROON Mercury Public Affairs, LLC 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      
11809 11809 2022-09-24 Presidency of the Republic of Senegal (through Kirjas Global Ltd.) (Senegal")" 2022-07-05 SENEGAL Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Avenue Leopold Sedar Senghor   Dakar    
12538 12538 2022-10-07 Ministry of Foreign Affairs and International Trade of Zimbabwe (through Actum International UK Ltd.) (MFA) 2019-09-11 ZIMBABWE Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC P.O. Box 4240, Munhumutapa Building Samora Machel Avenue/Sam Nujoma Street Harare      
12740 12740 2019-10-15 Alliance of Liberals and Democrats of Romania (ALDE) (through Keystone Strategic Advisers, LLC 2019-04-08 ROMANIA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC ALDE: Soseaua Pavel Dimitrievici Kiseleff, Nr. 57, Sector 1, Bucuresti      
12742 12742 2019-10-15 Embassy of the State of Qatar 2015-01-02 QATAR Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 2555 M Street, NW   Washington DC 20037
12965 12965 2020-10-23 Embassy of the Republic of Turkey 2018-05-04 TURKEY Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
13653 13653 2021-11-01 Government of the Republic of Uganda (through Mercury International UK Ltd.) 2021-04-26 UGANDA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 25497 Kampala Road Kampala      
13654 13654 2021-11-01 MTG of DE, LLC (through Mercury International UK Ltd.) 2021-03-24 SAUDI ARABIA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC MTG of DE, LLC PO Box 650461 Sterling VA 21065
13655 13655 2021-11-01 Presidency of the Republic of Haiti (through Mercury International UK Ltd) 2018-02-23 HAITI Mercury Public Affairs, LLC 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    
13656 13656 2021-11-01 Q Cyber Technologies Ltd 2019-12-25 ISRAEL Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC   Galgaley Haplada 22 Herzliya      
14582 14582 2019-11-30 Global Axis Partnership 2019-03-29 INDONESIA Mercury Public Affairs, LLC 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      
14583 14583 2019-11-30 Global IP - Cayman 2019-03-28 CAYMAN ISLANDS Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Willow House, Cricket Square, Floor 4 George Town KY1-9010      
14728 14728 2015-12-01 Government of Uganda 2014-07-30 UGANDA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC P.O. Box 25497 Kamplala      
16748 16748 2014-12-31 Government of Mauritius 2013-05-14 MAURITIUS Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 211 East 43rd Street Suite 1502 New York NY 10017
16926 16926 2022-12-31 Instituto Nacional de Promocion Turistica 2022-09-06 ARGENTINA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1600 New Hampshire Avenue, NW   Washington DC 20009

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