FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Foreign_Principal_Termination_Date = "2015-06-30"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 10
- Bangladesh Nationalist Party 1
- Dmitry Firtash 1
- Embassy of Libya 1
- Embassy of the Republic of Guatemala 1
- Government of Georgia 1
- Government of Libya 1
- ITC (International Trust Construction) through Levant Suez Consulting Corp. 1
- Kurdistan Regional Government 1
- Republic of Palau 1
- Royal Embassy of Saudi Arabia through Qorvis Communications 1
Country/Location_Represented 8
- LIBYA 2
- SAUDI ARABIA 2
- BANGLADESH 1
- GEORGIA 1
- GUATEMALA 1
- IRAQ 1
- PALAU 1
- UKRAINE 1
Registrant_Name 7
City 3
- - 6
- Washington 3
- Kiev, 01601 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8724 | 8724 | 2015-06-30 | Bangladesh Nationalist Party | 2015-02-20 | BANGLADESH | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 28 VIP Road, Naya Paltan | Dhaka-1000 | |||
8725 | 8725 | 2015-06-30 | Dmitry Firtash | 2014-06-24 | UKRAINE | Lanny J. Davis & Associates, LLC 6230 | 2014-06-24 | Lanny J. Davis & Associates, LLC | c/o Mr. Robert Shelter Jones, Deputy Chairman | Group DF Parus Business Center, 2 Mechnikova Street | Kiev, 01601 | ||
8726 | 8726 | 2015-06-30 | Embassy of Libya | 2015-04-03 | LIBYA | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 2600 Virginia Avenue, NW | Suite 300 | Washington | DC | 20037 |
8727 | 8727 | 2015-06-30 | Embassy of the Republic of Guatemala | 2014-07-24 | GUATEMALA | Peck, Madigan, Jones & Stewart, Inc. 6172 | 2013-06-10 | Peck, Madigan, Jones & Stewart, Inc. | 2220 R Street, NW | Washington | DC | 20008 | |
8728 | 8728 | 2015-06-30 | Government of Georgia | 2013-02-22 | GEORGIA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Tbilisi, Georgia 0175 | P. Ingorokva Str. N7 | |||
8729 | 8729 | 2015-06-30 | Government of Libya | 2011-06-24 | LIBYA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2445 M Street | Washington | DC | 20037 | |
8730 | 8730 | 2015-06-30 | ITC (International Trust Construction) through Levant Suez Consulting Corp. | 2015-06-18 | SAUDI ARABIA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Jeddah - Alharmen Street | ||||
8731 | 8731 | 2015-06-30 | Kurdistan Regional Government | 2014-03-31 | IRAQ | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Erbil, Iraq and | 1532 16th Street, NW Washington, DC 20036 | |||
8732 | 8732 | 2015-06-30 | Republic of Palau | 2013-04-08 | PALAU | Bryan Cave, LLP 6163 | 2013-04-08 | Bryan Cave, LLP | Melekeok | ||||
8733 | 8733 | 2015-06-30 | Royal Embassy of Saudi Arabia through Qorvis Communications | 2002-01-22 | SAUDI ARABIA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 601 New Hampshire Avenue 20037 | DC |
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]) );