FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where "Foreign_Principal_Termination_Date" is on date 2014-12-31
This data as json, CSV (advanced)
Suggested facets: Registrant_Date, Address_1, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 18
- Embassy of the Republic of Korea 2
- Republic of Korea, Embassy 2
- China National Tourist Office 1
- Embassy of Ecuador in the United States 1
- General Prosecutor Office of the Kyrgyz Republic 1
- Government of Burkina Faso 1
- Government of Mauritius 1
- Ivaniuschenko, Yuriy 1
- Kili/Bikini/Ejit Local Government Council 1
- Ministry of Tourism St. Vincent & The Grenadines 1
- Ministry of Tourism of Ecuador through EKOS Corp. 1
- Oleksandr Tymoshenko 1
- Republic of Korea Embassy (through Porter Gordon Silver Communications, LLC) 1
- SABIC Petrochemicals B.V. 1
- Temasek Holdings 1
- Tourism Toronto 1
- Transformation and Continuity 1
- Trust Company of the Marshall Islands, Inc. (TCMI) 1
Registrant_Name 17
- Akin, Gump, Strauss, Hauer & Feld, LLP 2
- IPG DXTRA, Inc 2
- Spring O'Brien & Company, Inc. 2
- Blank Rome Government Relations, LLC 1
- CD Global Strategies Group, LLC 1
- Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock 1
- Cornerstone Government Affairs, LLC 1
- Delahunt Group, LLC 1
- Development Counsellors International 1
- Finn Partners, Inc. 1
- Kasowitz, Benson, Torres and Friedman, LLP 1
- Mercury Public Affairs, LLC 1
- Podesta Group, Inc. 1
- Porter Gordon Silver Communications, LLC 1
- Roberti + White, LLC 1
- Sidley Austin LLP 1
- Wiley Rein, LLP 1
Country/Location_Represented 13
- KOREA, SOUTH 5
- ECUADOR 2
- MARSHALL ISLANDS 2
- UKRAINE 2
- AFGHANISTAN 1
- BURKINA FASO 1
- CANADA 1
- CHINA 1
- KYRGYZSTAN 1
- MAURITIUS 1
- SAINT VINCENT AND THE GRENADINES 1
- SAUDI ARABIA 1
- SINGAPORE 1
City 6
- - 10
- Washington 5
- New York 2
- Majuro 1
- Majuro 96960 1
- Springfield 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16742 | 16742 | 2014-12-31 | China National Tourist Office | 2014-01-30 | CHINA | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 370 Lexington Avenue | Suite #912 | New York | NY | 10017 |
16743 | 16743 | 2014-12-31 | Embassy of Ecuador in the United States | 2014-07-11 | ECUADOR | Delahunt Group, LLC 6215 | 2014-04-16 | Delahunt Group, LLC | 2535 15th Street, NW | Washington | DC | 20009 | |
16744 | 16744 | 2014-12-31 | Embassy of the Republic of Korea | 2014-03-07 | KOREA, SOUTH | Cornerstone Government Affairs, LLC 6211 | 2014-03-07 | Cornerstone Government Affairs, LLC | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16745 | 16745 | 2014-12-31 | Embassy of the Republic of Korea | 2014-09-09 | KOREA, SOUTH | Kasowitz, Benson, Torres and Friedman, LLP 6197 | 2013-11-19 | Kasowitz, Benson, Torres and Friedman, LLP | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16746 | 16746 | 2014-12-31 | General Prosecutor Office of the Kyrgyz Republic | 2013-07-16 | KYRGYZSTAN | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 139 Toktonalieva Street | Bushkek | |||
16747 | 16747 | 2014-12-31 | Government of Burkina Faso | 2014-11-11 | BURKINA FASO | CD Global Strategies Group, LLC 6262 | 2014-11-11 | CD Global Strategies Group, LLC | 11 BP 852 CMS Ouagadougou 11 | ||||
16748 | 16748 | 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 |
16749 | 16749 | 2014-12-31 | Ivaniuschenko, Yuriy | 2013-01-31 | UKRAINE | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 5 Hrushevskoho str. | Kyiv, 01021 | |||
16750 | 16750 | 2014-12-31 | Kili/Bikini/Ejit Local Government Council | 2008-12-02 | MARSHALL ISLANDS | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | Kili/Bikini/Ejit Local Government Council | P.O. Box 1096 | Majuro 96960 | ||
16751 | 16751 | 2014-12-31 | Ministry of Tourism St. Vincent & The Grenadines | 2008-06-30 | SAINT VINCENT AND THE GRENADINES | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | |||||
16752 | 16752 | 2014-12-31 | Ministry of Tourism of Ecuador through EKOS Corp. | 2014-10-28 | ECUADOR | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | |||||
16753 | 16753 | 2014-12-31 | Oleksandr Tymoshenko | 2012-06-11 | UKRAINE | Wiley Rein, LLP 6108 | 2012-06-11 | Wiley Rein, LLP | 29 Karl Marks Avenue Apt. 39 Dnipropetrovsky, 49600 | ||||
16754 | 16754 | 2014-12-31 | Republic of Korea Embassy (through Porter Gordon Silver Communications, LLC) | 2014-10-06 | KOREA, SOUTH | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16755 | 16755 | 2014-12-31 | Republic of Korea, Embassy | 2014-09-25 | KOREA, SOUTH | Porter Gordon Silver Communications, LLC 6251 | 2014-09-25 | Porter Gordon Silver Communications, LLC | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16756 | 16756 | 2014-12-31 | Republic of Korea, Embassy | 2010-11-01 | KOREA, SOUTH | Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock 5950 | 2009-09-08 | Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock | |||||
16757 | 16757 | 2014-12-31 | SABIC Petrochemicals B.V. | 2013-07-26 | SAUDI ARABIA | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Europaboulevard 1, 6135 LD, Sittard, the Netherlands | ||||
16758 | 16758 | 2014-12-31 | Temasek Holdings | 2008-04-10 | SINGAPORE | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 60 B Orchard Road | #06-18 Singapore | |||
16759 | 16759 | 2014-12-31 | Tourism Toronto | 2010-04-29 | CANADA | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 207 Queens Quay West | Suite 405 Toronto M5J1A7 | |||
16760 | 16760 | 2014-12-31 | Transformation and Continuity | 2014-07-03 | AFGHANISTAN | Roberti + White, LLC 6065 | 2011-09-23 | Roberti + White, LLC | 8105 Ainsworth Avenue | Springfield | VA | 22152 | |
16761 | 16761 | 2014-12-31 | Trust Company of the Marshall Islands, Inc. (TCMI) | 2011-06-08 | MARSHALL ISLANDS | Blank Rome Government Relations, LLC 6025 | 2010-12-03 | Blank Rome Government Relations, LLC | Trust Company Complex Ajeltake Road Ajeltake Island | Majuro |
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]) );