FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Foreign_Principal_Termination_Date" is on date 2016-05-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7260 | 7260 | 2016-05-31 | Minou Tavarez Mirabal | 2016-02-26 | DOMINICAN REPUBLIC | Sanitas International, LLC 5963 | 2009-11-18 | Sanitas International, LLC | Calle Fernando Valerio, #5 esq. Dr. Nunez y Dominguez | Ensanche La Julia Santo Domingo, D.N. | |||
7261 | 7261 | 2016-05-31 | Republic of Honduras | 2015-08-31 | HONDURAS | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | Edificio Ejectivo Las Lomas | Boulevard Juan Pablo II Tegucigalpa | |||
7262 | 7262 | 2016-05-31 | Tourism Fiji | 2012-12-21 | FIJI | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 5777 West Century Boulevard | Suite 220 | New York | NY | 90045 |
7259 | 7259 | 2016-05-31 | Government of Ontario, Ministry of Natural Resources and Forestry, and Ministry of Citizenship, Immigration and International Trade | 1987-05-29 | CANADA | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | Suite 400 | 70 Foster Drive Sault Ste Marie | Ontario | ||
7257 | 7257 | 2016-05-31 | Embassy of Grenada | 2016-06-01 | GRENADA | SS KS, LLC dba Sunshine Sachs 6354 | 2016-06-01 | SS KS, LLC dba Sunshine Sachs | 1701 New Hampshire Avenue, NW | Washington | DC | 20009 | |
7258 | 7258 | 2016-05-31 | Embassy of Republic of Turkey through Amsterdam & Partners, LLP | 2016-03-16 | TURKEY | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 |
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]) );