Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
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)
Foreign_Principal
Country/Location_Represented
City
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 107 | 107 | 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 | 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 | 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 | 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 | ||||
| 271 | 271 | 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 | |||
| 307 | 307 | Hikvision USA Inc. | 2018-08-16 | CHINA | 6170 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 18639 Railroad Street | City of Industry | CA | 91748 | ||
| 434 | 434 | 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 | ||||
| 446 | 446 | 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 | |||
| 480 | 480 | 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 | |
| 489 | 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 | |
| 510 | 510 | 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 | 526 | Q Cyber Technologies Ltd | 2019-12-25 | ISRAEL | 6170 6170 | 2013-05-14 | Mercury Public Affairs, LLC | Galgaley Haplada 22 Herzliya | |||||
| 665 | 665 | 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 | ||||
| 1796 | 1796 | 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 | |||
| 2960 | 2960 | 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 | |
| 4553 | 4553 | 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 | |||
| 4554 | 4554 | 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 | 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 | 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 | 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 | 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 | |||
| 6407 | 6407 | 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 | ||||
| 6923 | 6923 | 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 | |||
| 6926 | 6926 | 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 | |
| 6932 | 6932 | 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 | |
| 7119 | 7119 | 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 | ||||
| 7502 | 7502 | 2017-06-15 | Commonwealth of Dominica | 2017-03-09 | DOMINICA | 6170 6170 | 2013-05-14 | Mercury Public Affairs, LLC | |||||
| 8352 | 8352 | 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 | |||||
| 8747 | 8747 | 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 | ||
| 9914 | 9914 | 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 | |||
| 10229 | 10229 | 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 | |||
| 12202 | 12202 | 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 | |||
| 12204 | 12204 | 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 | |
| 13997 | 13997 | 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 | |||
| 13998 | 13998 | 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 | |||
| 14128 | 14128 | 2015-12-01 | Government of Uganda | 2014-07-30 | UGANDA | 6170 6170 | 2013-05-14 | Mercury Public Affairs, LLC | P.O. Box 25497 | Kamplala | |||
| 16119 | 16119 | 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 |
JSON shape: default, array, newline-delimited
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) );