FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Foreign_Principal_Termination_Date" is on date 2013-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Address_1, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 14
- Republic of Panama 2
- Cayman Islands Government 1
- Embassy of Republic of Korea in United States 1
- Embassy of the Republic of Korea 1
- Government of Cote d'Ivoire 1
- Government of the Republic of Singapore 1
- Maldives Marketing & Public Relations Corporation 1
- National Moroccan Tourism Office 1
- Oromo Liberation Front (OLF) 1
- Republic of The Gambia 1
- States of Guernsey 1
- States of Jersey 1
- Tajdeed Party, also known as Tajdeed Slate 1
- Yasuni-ITT Commission (via the UNDP) 1
Registrant_Name 13
- White & Case, LLP 3
- BGR Government Affairs, LLC 1
- BLJ Worldwide LTD 1
- Carmen Group, Inc. 1
- Cassidy & Associates, Inc. 1
- Command Consulting Group, LLC (CCG) 1
- Covington & Burling, LLP 1
- HDMK, LLC 1
- HL Group Partners, LLC 1
- LTL Strategies 1
- Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA) 1
- Ruder Finn, Inc. 1
- West Wing Writers, LLC 1
Country/Location_Represented 12
- CHANNEL ISLANDS 2
- KOREA, SOUTH 2
- PANAMA 2
- CAYMAN ISLANDS 1
- COTE D'IVOIRE (IVORY COAST) 1
- ECUADOR 1
- ETHIOPIA 1
- GAMBIA, THE 1
- IRAQ 1
- MALDIVES 1
- MOROCCO 1
- SINGAPORE 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16728 | 16728 | 2013-12-31 | Cayman Islands Government | 2013-09-16 | CAYMAN ISLANDS | Carmen Group, Inc. 6188 | 2013-09-16 | Carmen Group, Inc. | 133 Elgin Avenue | Grand Cayman KY1-9000 | |||
16729 | 16729 | 2013-12-31 | Embassy of Republic of Korea in United States | 2012-11-15 | KOREA, SOUTH | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | |||||
16731 | 16731 | 2013-12-31 | Government of the Republic of Singapore | 2012-04-30 | SINGAPORE | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Ministry of Finance The Treasury | 100 High Street, #10-01 Singapore 179434 | |||
16732 | 16732 | 2013-12-31 | Maldives Marketing & Public Relations Corporation | 2012-06-27 | MALDIVES | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | H. Velaanaage, 4th Floor, Ameer Ahmed Magu | ||||
16733 | 16733 | 2013-12-31 | National Moroccan Tourism Office | 2013-08-07 | MOROCCO | HL Group Partners, LLC 6178 | 2013-08-07 | HL Group Partners, LLC | Office National Marocain Du Tourisme | Angle Rue Oued Al Makhazine et Rue Zalaqa B.P. 19 Agdal, Rabat, MA | |||
16735 | 16735 | 2013-12-31 | Republic of Panama | 2012-02-17 | PANAMA | Command Consulting Group, LLC (CCG) 6090 | 2012-02-17 | Command Consulting Group, LLC (CCG) | |||||
16736 | 16736 | 2013-12-31 | Republic of Panama | 2009-12-16 | PANAMA | HDMK, LLC 5966 | 2009-12-16 | HDMK, LLC | Palacio de Las Garzas | Corregimiento de San Felipe | |||
16737 | 16737 | 2013-12-31 | Republic of The Gambia | 2013-07-10 | GAMBIA, THE | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | Ministry of Information and Communication Infrastructure | GRTS Building, MDI Road, Kanifing The Gambia, West Africa | |||
16738 | 16738 | 2013-12-31 | States of Guernsey | 2007-05-09 | CHANNEL ISLANDS | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | |||||
16740 | 16740 | 2013-12-31 | Tajdeed Party, also known as Tajdeed Slate | 2013-08-09 | IRAQ | Cassidy & Associates, Inc. 6179 | 2013-08-09 | Cassidy & Associates, Inc. | Aladel Street | Anbar Province Ramadi | |||
16727 | 16727 | 2013-12-31 | Government of Cote d'Ivoire | 2011-12-21 | COTE D'IVOIRE (IVORY COAST) | LTL Strategies 6082 | 2011-12-21 | LTL Strategies | Office of the President, | Republic of Cote d'Ivoire | Abidjan | ||
16739 | 16739 | 2013-12-31 | States of Jersey | 2007-05-09 | CHANNEL ISLANDS | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Cyril Le Marquand House | P.O. Box 140 St. Helier | Jersey | ||
16734 | 16734 | 2013-12-31 | Oromo Liberation Front (OLF) | 2008-12-01 | ETHIOPIA | Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA) 5895 | 2008-12-01 | Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA) | P.O. Box 6185 | City Square | Nairobi | ||
16741 | 16741 | 2013-12-31 | Yasuni-ITT Commission (via the UNDP) | 2011-09-12 | ECUADOR | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | Equipo Negociador de la Iniciativa Yasuni-ITT | Edificio Titanium, 7 mo piso Ave. 6 de Diciembre N33-42 e Ignacio Bossano | Quito | ||
16730 | 16730 | 2013-12-31 | Embassy of the Republic of Korea | 2012-06-06 | KOREA, SOUTH | West Wing Writers, LLC 6107 | 2012-06-06 | West Wing Writers, LLC | 2450 Massachusetts Avenue, NW | Washington | DC | 20008-2850 |
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]) );