FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where "Foreign_Principal_Termination_Date" is on date 2018-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Address_1, Zip, Registrant_Date (date)
Foreign_Principal 21
- Ente Nazionale Italiano per il Turismo (ENIT) 2
- Polish Chamber of Commerce in the United States 2
- Aerovias Nacionales de Colombia, S.A. (AVIANCA) 1
- Circle of Democrats and Republicans of Congo aka Cercle des Democrates et Republicains du Congo 1
- Embassy of the Republic of Kazakhstan in Washington 1
- Embassy of the Republic of Korea 1
- Embassy of the State of Qatar 1
- Government of Argentina 1
- Government of the Democratic Republic of Congo 1
- Korea Ministry of Trade 1
- Mexico City Tourism 1
- Ministry of Culture and Tourism of Turkey 1
- Public Investment Fund 1
- Republic of Turkey through Greenberg Traurig 1
- Saro Spadaro 1
- Social Communication Secretariat of the Office of the President of the Republic of Brazil 1
- Taiwan Tourism Bureau 1
- The Global Covenant of Mayors for Climate & Energy on behalf of the European Climate Foundation 1
- US Office of the National Coalition of Syrian Revolution and Opposition Forces 1
- Venable LLP (on behalf of Slobodan Tesic) 1
- Zurich Tourism 1
Registrant_Name 20
- Daniel J. Edelman, Inc. 2
- MMGY Global, LLC 2
- Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Avenue Strategies, LLC 1
- Bluetext, LLC 1
- CDN International, Inc. 1
- Daschle Group, LLC 1
- Finn Partners, Inc. 1
- Gallagher Group, LLC 1
- Holland & Knight 1
- IPG DXTRA, Inc 1
- Independent Diplomat, Inc. 1
- Italian Government Tourist Board (ENIT), Los Angeles 1
- Italian Government Travel Office, Chicago 1
- Mer Security and Communication Systems Ltd. 1
- Nickles Group, LLC 1
- Portland PR Inc. 1
- Potomac Square Group 1
- Silversmith Law Offices PLLC 1
Country/Location_Represented 18
- ITALY 3
- KOREA, SOUTH 2
- POLAND 2
- TURKEY 2
- ARGENTINA 1
- BRAZIL 1
- COLOMBIA 1
- CONGO, DEMOCRATIC REPUBLIC OF THE 1
- CONGO, REPUBLIC OF THE 1
- KAZAKHSTAN 1
- MEXICO 1
- NETHERLANDS 1
- QATAR 1
- SAUDI ARABIA 1
- SERBIA 1
- SWITZERLAND 1
- SYRIA 1
- TAIWAN 1
City 4
- - 13
- Washington 8
- Brasilia 1
- Taipei City 10694 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16820 | 16820 | 2018-12-31 | Aerovias Nacionales de Colombia, S.A. (AVIANCA) | 1985-12-12 | COLOMBIA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Bogota | CO | |||
16821 | 16821 | 2018-12-31 | Circle of Democrats and Republicans of Congo aka Cercle des Democrates et Republicains du Congo | 2018-03-01 | CONGO, DEMOCRATIC REPUBLIC OF THE | Avenue Strategies, LLC 6446 | 2017-07-24 | Avenue Strategies, LLC | 45 Mabida Street, Makelekele, | ||||
16825 | 16825 | 2018-12-31 | Ente Nazionale Italiano per il Turismo (ENIT) | 1965-04-19 | ITALY | Italian Government Tourist Board (ENIT), Los Angeles 1884 | 1965-04-19 | Italian Government Tourist Board (ENIT), Los Angeles | Rome | ||||
16826 | 16826 | 2018-12-31 | Ente Nazionale Italiano per il Turismo (ENIT) | 1968-06-07 | ITALY | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | Rome | ||||
16827 | 16827 | 2018-12-31 | Government of Argentina | 2018-11-13 | ARGENTINA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Av. Julio A. Roca 782 Piso * | Buenos Aires | |||
16828 | 16828 | 2018-12-31 | Government of the Democratic Republic of Congo | 2017-04-28 | CONGO, REPUBLIC OF THE | Mer Security and Communication Systems Ltd. 6423 | 2017-04-28 | Mer Security and Communication Systems Ltd. | Kinshasa | ||||
16829 | 16829 | 2018-12-31 | Korea Ministry of Trade | 2018-04-25 | KOREA, SOUTH | Bluetext, LLC 6546 | 2018-04-25 | Bluetext, LLC | |||||
16830 | 16830 | 2018-12-31 | Mexico City Tourism | 2015-01-30 | MEXICO | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Havre 67, 6th piso | Col. Juarez, C.P. 06600 Del. Cuauhtemoc, Ciudad de Mexico | |||
16831 | 16831 | 2018-12-31 | Ministry of Culture and Tourism of Turkey | 2018-10-24 | TURKEY | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | Ismet Inonu Bulvari No:32 | Emek Ankara 06100 | |||
16834 | 16834 | 2018-12-31 | Public Investment Fund | 2018-03-08 | SAUDI ARABIA | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | Information Technology and Communications Complex, Building CS01 Al Nakhil District | P.O. Box 6847 Riadh 11452 | |||
16836 | 16836 | 2018-12-31 | Saro Spadaro | 2018-05-24 | ITALY | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 6399 | 2016-12-11 | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy | Rhirie Road | Maho Bay | |||
16839 | 16839 | 2018-12-31 | The Global Covenant of Mayors for Climate & Energy on behalf of the European Climate Foundation | 2018-12-20 | NETHERLANDS | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 2513 AM | Riviervismarkt 5 The Hague | |||
16842 | 16842 | 2018-12-31 | Zurich Tourism | 2017-11-27 | SWITZERLAND | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | Stampfenbachstrasse 52 | CH-8006 Zurich | |||
16837 | 16837 | 2018-12-31 | Social Communication Secretariat of the Office of the President of the Republic of Brazil | 2010-06-28 | BRAZIL | CDN International, Inc. 5992 | 2010-06-28 | CDN International, Inc. | Esokabada Dis Nubusteruis Bloco A 6 Andar - Gabinete | Brasilia | |||
16838 | 16838 | 2018-12-31 | Taiwan Tourism Bureau | 2017-11-27 | TAIWAN | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 9F, No. 290, Sec. 4 | Zhongxiao E. Rd | Taipei City 10694 | ||
16822 | 16822 | 2018-12-31 | Embassy of the Republic of Kazakhstan in Washington | 2018-06-06 | KAZAKHSTAN | Portland PR Inc. 6064 | 2011-09-19 | Portland PR Inc. | 1401 16th Street, NW | Washington | DC | 20036 | |
16823 | 16823 | 2018-12-31 | Embassy of the Republic of Korea | 2012-02-15 | KOREA, SOUTH | Nickles Group, LLC 6089 | 2012-02-15 | Nickles Group, LLC | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16824 | 16824 | 2018-12-31 | Embassy of the State of Qatar | 2018-10-03 | QATAR | Silversmith Law Offices PLLC 6597 | 2018-10-03 | Silversmith Law Offices PLLC | 255 M Street NW | Washington | |||
16832 | 16832 | 2018-12-31 | Polish Chamber of Commerce in the United States | 2018-07-18 | POLAND | Gallagher Group, LLC 6277 | 2015-02-12 | Gallagher Group, LLC | 1200 G Street, NW | Suite 800 | Washington | DC | 20005 |
16833 | 16833 | 2018-12-31 | Polish Chamber of Commerce in the United States | 2018-07-18 | POLAND | Potomac Square Group 6576 | 2018-07-18 | Potomac Square Group | 1200 G Street, NW | Suite 800 | Washington | DC | 20005 |
16835 | 16835 | 2018-12-31 | Republic of Turkey through Greenberg Traurig | 2017-01-18 | TURKEY | Daschle Group, LLC 6280 | 2015-03-16 | Daschle Group, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16840 | 16840 | 2018-12-31 | US Office of the National Coalition of Syrian Revolution and Opposition Forces | 2013-04-08 | SYRIA | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | 1101 Pennsylvania Avenue, NW | Suite 6620 | Washington | DC | 20004 |
16841 | 16841 | 2018-12-31 | Venable LLP (on behalf of Slobodan Tesic) | 2018-02-16 | SERBIA | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 6399 | 2016-12-11 | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy | 600 Massachusetts Avenue, NW | Washington | DC | 20001 |
Advanced export
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]) );