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 = "2016-12-31" and State = ""
This data as json, CSV (advanced)
Suggested facets: Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 7
Foreign_Principal 7
Country/Location_Represented 7
- BELGIUM 1
- BERMUDA 1
- GABON 1
- INTERNATIONAL 1
- SAUDI ARABIA 1
- SRI LANKA 1
- UNITED ARAB EMIRATES 1
State 1
- - · 7 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16775 | 16775 | 2016-12-31 | Belgian National Tourist Office | 1948-06-17 | BELGIUM | Belgian National Tourist Office 529 | 1948-06-17 | Belgian National Tourist Office | Grasmark 30 | Brussels | |||
16784 | 16784 | 2016-12-31 | European Travel Commission | 2017-11-27 | INTERNATIONAL | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | Rue de Marche aux Herbes 61 | 1000 Brussels | |||
16785 | 16785 | 2016-12-31 | Gabonese Republic | 2016-09-15 | GABON | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | Office of the President | BP 546 Libreville | |||
16786 | 16786 | 2016-12-31 | Government of Bermuda | 1989-07-25 | BERMUDA | Levine & Company 3971 | 1987-04-29 | Levine & Company | Hamilton | ||||
16787 | 16787 | 2016-12-31 | King Abdullah Foundation | 2018-01-23 | SAUDI ARABIA | Portland PR Inc. 6064 | 2011-09-19 | Portland PR Inc. | Ar Rahmaniyah | Riyadh 12342 | |||
16789 | 16789 | 2016-12-31 | Outlook Energy Investments LLC wholly owned by the Emirate of Abu Dhabi | 2016-05-09 | UNITED ARAB EMIRATES | Investment Diplomacy Group, LLC 6351 | 2016-05-09 | Investment Diplomacy Group, LLC | Al Mamoura Building A, Al Muroor Street P.O. Box 44442 | Abu Dhabi | |||
16794 | 16794 | 2016-12-31 | Sri Lanka Ministry of Development Strategies & International Trade | 2016-08-08 | SRI LANKA | Sandler, Travis & Rosenberg, P.A. 6366 | 2016-08-08 | Sandler, Travis & Rosenberg, P.A. | Level 06 World Trade Center | Colombo, 01 |
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]) );