FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where "Foreign_Principal_Termination_Date" is on date 2018-06-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Address_2, Foreign_Principal_Registration_Date (date)
Registrant_Name 7
Foreign_Principal 7
- Channel Koos for Ministry of Justice, Nigeria 1
- Comision para la Promocion de la Alianza 1
- Korea Ministry for Trade, Industry, and Energy (MOTIE") (through K&L Gates)" 1
- Mount Olives, LLC (on behalf of the Nigerian Attorney General) 1
- Office of Commercial Affairs, Royal Thai Embassy 1
- Peter Maddox, Direct Sellers Association of Canada 1
- VTB Group 1
City 4
- - 4
- Laurel 1
- Toronto 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8747 | 8747 | 2018-06-30 | Channel Koos for Ministry of Justice, Nigeria | 2018-05-31 | NIGERIA | Mount Olive LLC 6562 | 2018-05-31 | Mount Olive LLC | 21 Road 2nd Avenue, Gwarimpa, Abuja fci | ||||
8748 | 8748 | 2018-06-30 | Comision para la Promocion de la Alianza | 2014-09-29 | HONDURAS | Burson-Marsteller, LLC (Miami Office) 6223 | 2014-05-20 | Burson-Marsteller, LLC (Miami Office) | Colonia Altos de Miramontes, Diagonal Barro y Poseidon, | casa 2801 Tegucigalpa | |||
8749 | 8749 | 2018-06-30 | Korea Ministry for Trade, Industry, and Energy (MOTIE") (through K&L Gates)" | 2018-02-12 | KOREA, SOUTH | Levick Strategic Communications, LP 6228 | 2014-06-25 | Levick Strategic Communications, LP | MOTIE: 402 Hannuri-daero, Sejong-si, 30118, Republic of Korea | K&L Gates: 1601 K Street NW, Washington, DC 20006 | |||
8753 | 8753 | 2018-06-30 | VTB Group | 2016-05-11 | RUSSIA | Manatos & Manatos 6353 | 2016-05-11 | Manatos & Manatos | 12 Presnenskaya Embankment | 123100 Moscow | |||
8750 | 8750 | 2018-06-30 | Mount Olives, LLC (on behalf of the Nigerian Attorney General) | 2018-05-30 | NIGERIA | Prime Policy Group 6377 | 2016-09-19 | Prime Policy Group | 8470 Winding Trail | Laurel | MD | 20724 | |
8752 | 8752 | 2018-06-30 | Peter Maddox, Direct Sellers Association of Canada | 2018-03-27 | CANADA | Larkin, Kyle 6539 | 2018-03-27 | Larkin, Kyle | 180 Attwell Drive, Suite 250 | Toronto | |||
8751 | 8751 | 2018-06-30 | Office of Commercial Affairs, Royal Thai Embassy | 2018-07-18 | THAILAND | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 1024 Wisconsin Avenue, NW | Washington | DC | 20007 |
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]) );