FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

18 rows where Registration_Number = 6492

View and edit SQL

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

City

Registrant_Name

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
71   British Virgin Islands Tourist Board & Film Commission 2019-01-14 BRITISH VIRGIN ISLANDS 6492 6492 2017-11-27 MMGY Global, LLC          
113   Costa Rica Tourism Board 2018-06-29 COSTA RICA 6492 6492 2017-11-27 MMGY Global, LLC Costado Este del Puente Juan Pablo II Sobre la Autopista General Canas San Jose, 777-1000      
404   Macao Government Tourism Office 2020-01-06 MACAU 6492 6492 2017-11-27 MMGY Global, LLC Alameda Dr. Carlos d'Assumpcao, n.os 335-341 12 Andar      
464   Nassau Paradise Island Promotion Board 2017-11-27 BAHAMAS 6492 6492 2017-11-27 MMGY Global, LLC          
500   Papua New Guinea Tourism Promotion Authority 2020-01-06 PAPUA NEW GUINEA 6492 6492 2017-11-27 MMGY Global, LLC Pacific MMI Building Level 5 Port Moresby      
618   Tahiti Tourisme 2019-06-26 TAHITI 6492 6492 2017-11-27 MMGY Global, LLC 5901 W. Century Blvd. Suite 1120   Los Angeles CA 90045
653   Tourism Ireland 2017-11-27 IRELAND 6492 6492 2017-11-27 MMGY Global, LLC          
663   Turismo de Los Cabos 2017-11-27 MEXICO 6492 6492 2017-11-27 MMGY Global, LLC          
4536 2016-03-31 Barbados Tourism Authority 2017-11-27 BARBADOS 6492 6492 2017-11-27 MMGY Global, LLC          
4550 2017-03-31 Jordan Tourism Board 2017-11-27 JORDAN 6492 6492 2017-11-27 MMGY Global, LLC          
4575 2020-03-31 Government of St. Maarten 2017-11-27 ST. MARTIN 6492 6492 2017-11-27 MMGY Global, LLC          
6942 2017-05-31 Gobierno de la Ciudad de Buenos Aires 2017-11-27 ARGENTINA 6492 6492 2017-11-27 MMGY Global, LLC          
10714 2017-08-31 Metro Vancouver Convention and Visitors Bureau, dba Tourism Vancouver 2017-11-27 CANADA 6492 6492 2017-11-27 MMGY Global, LLC          
16157 2016-12-31 European Travel Commission 2017-11-27 INTERNATIONAL 6492 6492 2017-11-27 MMGY Global, LLC          
16210 2018-12-31 Taiwan Tourism Bureau 2017-11-27 TAIWAN 6492 6492 2017-11-27 MMGY Global, LLC          
16214 2018-12-31 Zurich Tourism 2017-11-27 SWITZERLAND 6492 6492 2017-11-27 MMGY Global, LLC          
16217 2019-12-31 Bermuda Tourism Authority 2017-11-27 BERMUDA 6492 6492 2017-11-27 MMGY Global, LLC          
16220 2019-12-31 Deutsche Zentrale fur Tourismus e.V 2019-01-14 GERMANY 6492 6492 2017-11-27 MMGY Global, LLC          

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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)
);
Powered by Datasette · Query took 245.651ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history