FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where "Foreign_Principal_Termination_Date" is on date 2009-12-31 sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Registration_Date (date)
Foreign_Principal 21
- National Security Council of Georgia 2
- CNIA - Critical National Infrastructure Authority, Abu Dhabi 1
- Cayman Islands Government, Portfolio of Finance and Economics 1
- Copenhagen Consensus Center 1
- DEWS - Development Economic Western Switzerland 1
- Denis Sassou Nguesso, President of the Republic of Congo, through Trout Cacheris PLLC 1
- Development Economic Western Switzerland 1
- Fundacion para la Inversion y Desarrollo de Exportaciones (FIDE) (Foundation for Investment and Development of Exports) 1
- Government of Aruba 1
- Government of Georgia, National Security Council 1
- Government of Honduras 1
- Government of the Republic of Korea 1
- Government of the Republic of Uganda 1
- Kurdistan Regional Government 1
- Mehmet Ali Talat 1
- Office of Agricultural Affairs of the Royal Thai Embassy 1
- Partidul Social Democrat (PSD")" 1
- Sledgehammer Communications 1
- State of the Netherlands/Royal Netherlands Embassy 1
- Swiss Confederation, Embassy through Daniel J. Edelman, Inc. 1
- twofour54 FZ-LLC (through Gulf Hill & Knowlton) 1
Registrant_Name 18
- Global Communicators, LLC 4
- CLS Strategies 2
- Cassidy & Associates, Inc. 1
- Daniel J. Edelman, Inc. 1
- FGS Global (US) LLC (FKA FGH Holdings LLC) 1
- Fleishman-Hillard, Inc. 1
- Global Policy Initiatives 1
- Hill and Knowlton Strategies, LLC 1
- Jacobs, Barry 1
- Kunin, Daniel Louis 1
- MITA Group, Inc. 1
- Ogilvy Public Relations Worldwide 1
- Podesta Group, Inc. 1
- Public Strategies, Inc. 1
- Squire Patton Boggs, LLP 1
- Tesolin-Hamilton, Elizabeth Leigh 1
- Van Sickle, Valerie L. 1
- Whitaker Group, Inc. 1
Country/Location_Represented 16
- GEORGIA 3
- SWITZERLAND 3
- HONDURAS 2
- UNITED ARAB EMIRATES 2
- ARUBA 1
- CAYMAN ISLANDS 1
- CONGO, DEMOCRATIC REPUBLIC OF THE 1
- CYPRUS 1
- DENMARK 1
- IRAQ 1
- KOREA, SOUTH 1
- MALAYSIA 1
- NETHERLANDS 1
- ROMANIA 1
- THAILAND 1
- UGANDA 1
City 9
- - 9
- Washington 4
- Tbilisi 3
- Abu Dhabi 1
- Bucharest 1
- Frederiksberg 1
- Oranjestad 1
- Seoul 1
- Tegucigalpa 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16654 | 16654 | 2009-12-31 | DEWS - Development Economic Western Switzerland | 2003-12-15 | SWITZERLAND | Van Sickle, Valerie L. 5592 | 2003-12-15 | Van Sickle, Valerie L. | World Trade Center Lausanne 2, Avenue de Gratte - Paille CH - 1000 Lausanne 30 | ||||
16655 | 16655 | 2009-12-31 | Denis Sassou Nguesso, President of the Republic of Congo, through Trout Cacheris PLLC | 2006-10-06 | CONGO, DEMOCRATIC REPUBLIC OF THE | CLS Strategies 5774 | 2006-10-06 | CLS Strategies | |||||
16656 | 16656 | 2009-12-31 | Development Economic Western Switzerland | 2004-06-30 | SWITZERLAND | Tesolin-Hamilton, Elizabeth Leigh 5629 | 2004-06-30 | Tesolin-Hamilton, Elizabeth Leigh | 2 Avenue Gratta Paille World Trade Center Case Postale 452 CH-1000 Lausanne 30 | ||||
16658 | 16658 | 2009-12-31 | Government of Aruba | 2006-03-24 | ARUBA | MITA Group, Inc. 5741 | 2006-03-24 | MITA Group, Inc. | J.E. Irausquin Plaza | Oranjestad | |||
16659 | 16659 | 2009-12-31 | Government of Georgia, National Security Council | 2008-08-22 | GEORGIA | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | Ingorokva St. 7 | Tbilisi | |||
16660 | 16660 | 2009-12-31 | Government of Honduras | 2009-09-18 | HONDURAS | CLS Strategies 5774 | 2006-10-06 | CLS Strategies | Blv Juan Pablo II | Tegucigalpa | |||
16661 | 16661 | 2009-12-31 | Government of the Republic of Korea | 2009-02-23 | KOREA, SOUTH | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Blue House, #1, Cheongwadae-ro, Jongno-gu | Seoul | |||
16662 | 16662 | 2009-12-31 | Government of the Republic of Uganda | 2003-02-13 | UGANDA | Whitaker Group, Inc. 5539 | 2003-02-13 | Whitaker Group, Inc. | Ministry of Finance, Planning and Economic Development P.O. Box 8147 Kampala | ||||
16665 | 16665 | 2009-12-31 | National Security Council of Georgia | 2009-02-23 | GEORGIA | Kunin, Daniel Louis 5911 | 2009-02-23 | Kunin, Daniel Louis | Ingorokva 7 | Tbilisi | |||
16666 | 16666 | 2009-12-31 | National Security Council of Georgia | 2009-03-05 | GEORGIA | Public Strategies, Inc. 5913 | 2009-03-05 | Public Strategies, Inc. | Ingorokva St. 7 | Tbilisi | |||
16670 | 16670 | 2009-12-31 | State of the Netherlands/Royal Netherlands Embassy | 2009-02-10 | NETHERLANDS | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 4200 Linnean Avenue, NW | Washington | DC | 20008 | |
16671 | 16671 | 2009-12-31 | Swiss Confederation, Embassy through Daniel J. Edelman, Inc. | 2009-09-25 | SWITZERLAND | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 2900 Cathedral Avenue, NW | Washington | DC | 20008 | |
16668 | 16668 | 2009-12-31 | Partidul Social Democrat (PSD")" | 2009-09-30 | ROMANIA | Global Policy Initiatives 5954 | 2009-09-30 | Global Policy Initiatives | Palace Parliament | 2 Izor Street | Bucharest | ||
16672 | 16672 | 2009-12-31 | twofour54 FZ-LLC (through Gulf Hill & Knowlton) | 2009-07-31 | UNITED ARAB EMIRATES | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | P.O. Box 2454 | Abu Dhabi | |||
16651 | 16651 | 2009-12-31 | CNIA - Critical National Infrastructure Authority, Abu Dhabi | 2009-10-01 | UNITED ARAB EMIRATES | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Airport Road | Al Bateen Air Base 62220 | Abu Dhabi | ||
16652 | 16652 | 2009-12-31 | Cayman Islands Government, Portfolio of Finance and Economics | 2007-09-07 | CAYMAN ISLANDS | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | Government Administration Building | Grand Cayman | |||
16664 | 16664 | 2009-12-31 | Mehmet Ali Talat | 2008-12-16 | CYPRUS | Jacobs, Barry 5900 | 2008-12-16 | Jacobs, Barry | Office of the President | Lefkosa, Turkish Republic of North Cyprus | |||
16657 | 16657 | 2009-12-31 | Fundacion para la Inversion y Desarrollo de Exportaciones (FIDE) (Foundation for Investment and Development of Exports) | 2007-12-28 | HONDURAS | Global Communicators, LLC 5817 | 2007-06-26 | Global Communicators, LLC | Colonia La Estancia, costado Sur/este; De Plaza Marte, final dek Blvd. | Morazan; Apartado Posta No. 2029 Teguicigalpa, M.D.C. | |||
16653 | 16653 | 2009-12-31 | Copenhagen Consensus Center | 2007-12-28 | DENMARK | Global Communicators, LLC 5817 | 2007-06-26 | Global Communicators, LLC | Copenhagen Business School | Solbjerg Plads 3 DK-2000 | Frederiksberg | ||
16667 | 16667 | 2009-12-31 | Office of Agricultural Affairs of the Royal Thai Embassy | 2009-09-23 | THAILAND | Global Communicators, LLC 5817 | 2007-06-26 | Global Communicators, LLC | 1024 Wisconsin Avenue, NW | Suite 203 | Washington | DC | 10007 |
16663 | 16663 | 2009-12-31 | Kurdistan Regional Government | 2009-05-22 | IRAQ | Cassidy & Associates, Inc. 5643 | 2004-09-10 | Cassidy & Associates, Inc. | 1634 Eye Street, NW | Suite 210 | Washington | DC | 20006 |
16669 | 16669 | 2009-12-31 | Sledgehammer Communications | 2009-09-23 | MALAYSIA | Global Communicators, LLC 5817 | 2007-06-26 | Global Communicators, LLC | 22B, Jalan Tun Mohd Fuad 1 | Taman Tun Dr, Ismail 60000 Kuala Lumpur |
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]) );