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

48 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), Registrant_Date (date)

State 7

Registrant_Name 1

  • Mercury Public Affairs, LLC · 48 ✖
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
120 120   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
220 220   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
254 254   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    
320 320   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
371 371   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
498 498   National Oil Corporation 2023-02-23 LIBYA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC Asseka Road   Tripoli    
524 524   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
599 599   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    
1880 1880 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      
2684 2684 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    
2727 2727 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      
2728 2728 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      
3089 3089 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
4724 4724 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      
4725 4725 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
4763 4763 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
5065 5065 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
5278 5278 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
5382 5382 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    
5384 5384 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
5385 5385 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    
5386 5386 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      
6045 6045 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        
6354 6354 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    
6665 6665 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        
7188 7188 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      
7191 7191 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
7197 7197 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
7398 7398 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        
7796 7796 2017-06-15 Commonwealth of Dominica 2017-03-09 DOMINICA Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC          
8654 8654 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          
9074 9074 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    
10270 10270 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      
10592 10592 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      
11732 11732 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    
12457 12457 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      
12657 12657 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      
12659 12659 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
12882 12882 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
13570 13570 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      
13571 13571 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
13572 13572 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    
13573 13573 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      
14498 14498 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      
14499 14499 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      
14642 14642 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      
16660 16660 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
16832 16832 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])
);