FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where "Foreign_Principal_Termination_Date" is on date 2016-01-31
This data as json, CSV (advanced)
Suggested facets: Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1904 | 1904 | 2016-01-31 | Federal Republic of Somalia | 2015-09-11 | SOMALI DEMOCRATIC REPUBLIC | Grieboski Global Strategies, LLC 6315 | 2015-09-08 | Grieboski Global Strategies, LLC | Villa Somalia, Dagmada Wardhiigleey | Mogadishu | |||
1905 | 1905 | 2016-01-31 | International Counsel Bureau, Kuwait | 2012-03-27 | KUWAIT | Potomac Square Group 6096 | 2012-03-27 | Potomac Square Group | |||||
1906 | 1906 | 2016-01-31 | Kingdom of Morocco, Ministry of the Handicrafts and Social and Collaborative Economy | 2015-04-24 | MOROCCO | Husch Blackwell, LLP 6273 | 2015-01-19 | Husch Blackwell, LLP | Av. Maa Alainine Haut Agdal, B.P. 6435 Rabat | ||||
1907 | 1907 | 2016-01-31 | Ministry of Finance and Economic Development of Sierra Leone | 2015-04-03 | SIERRA LEONE | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | The Treasury Building | George Street | Freetown | ||
1908 | 1908 | 2016-01-31 | VMRO - Democratic Party for Macedonian National Unity | 2015-12-17 | MACEDONIA | New Partners Consulting, Inc. 6330 | 2015-12-17 | New Partners Consulting, Inc. | ul. Makedonija 17A 1000 Skopje |
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]) );