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

28 rows where Registration_Number = 6549

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

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
73   British Virgin Islands Tourist Board 2018-04-30 BRITISH VIRGIN ISLANDS 6549 6549 2018-04-30 Myriad International Marketing, LLC Decastro Street 2nd Floor, Akara Building Road Town, Tortola, BVI      
138   Discover Dominica Authority 2018-04-30 DOMINICAN REPUBLIC 6549 6549 2018-04-30 Myriad International Marketing, LLC 1st Floor Financial Centre Roseau, Commonwealth of Dominica      
247   German National Tourist Office 2018-04-30 GERMANY 6549 6549 2018-04-30 Myriad International Marketing, LLC 122 East 42nd Street, Suite 2000   New York NY 10168
342   Italian National Tourist Board 2019-11-26 ITALY 6549 6549 2018-04-30 Myriad International Marketing, LLC          
363   Kenya Tourism Board 2018-04-30 KENYA 6549 6549 2018-04-30 Myriad International Marketing, LLC Kenya Re Towers, Ragari Road Nairobi      
397   Kyoto Convention & Visitors Bureau 2018-04-30 JAPAN 6549 6549 2018-04-30 Myriad International Marketing, LLC Karasuma Ebisugawa Nakagyo-ku Kyoto 604-0862      
411   Macao Government Tourism Office 2018-04-30 MACAU 6549 6549 2018-04-30 Myriad International Marketing, LLC Alameda Dr. Carlos d'Assumpcao, no 335-341, 13/F, Room 1312        
502   Papua New Guinea Tourism Promotion Authority 2018-04-30 PAPUA NEW GUINEA 6549 6549 2018-04-30 Myriad International Marketing, LLC Pacific MMI Building Level 5 Port Moresby      
529   Qatar Tourism Authority 2018-04-30 QATAR 6549 6549 2018-04-30 Myriad International Marketing, LLC 24624 Lusail Expy, Doha        
580   Samoa Tourism Authority 2018-04-30 SAMOA 6549 6549 2018-04-30 Myriad International Marketing, LLC Main Beach Road Apia      
593   Shizuoka Prefectural Tourism Association 2019-05-22 JAPAN 6549 6549 2018-04-30 Myriad International Marketing, LLC 2F Mizunomori Bldg., 14-1 Minami-cho, Suraga-ku, Shizuoka 422-8067        
601   South Tyrol 2018-06-01 ITALY 6549 6549 2018-04-30 Myriad International Marketing, LLC Pfarrplatz 11 - Piazza della, Parrocchia, 11 39100 Bozen-Bolzano      
605   Stark Communications on behalf of Karnataka Tourism 2020-06-18 INDIA 6549 6549 2018-04-30 Myriad International Marketing, LLC          
628   Taiwan Tourism Bureau 2018-04-30 TAIWAN 6549 6549 2018-04-30 Myriad International Marketing, LLC 39F, No. 290, Sec. 4 Zhongxiao E. Rd Taipei City 10694      
629   Taiwan Visitors Association 2018-06-01 TAIWAN 6549 6549 2018-04-30 Myriad International Marketing, LLC Zhongshan District Section 2 Minquan E Rd. No. 9 Taipei City 104      
650   Tourism Australia 2018-04-30 AUSTRALIA 6549 6549 2018-04-30 Myriad International Marketing, LLC 2029 Century Park E Ste 3150   Los Angeles CA 90067
656   Tourism Northern Territory 2018-04-30 AUSTRALIA 6549 6549 2018-04-30 Myriad International Marketing, LLC Level 1, Alice Plaza Alice Springs, Northern Territory, 0870      
660   Toyooka City Hall Tourism Division 2018-06-01 JAPAN 6549 6549 2018-04-30 Myriad International Marketing, LLC 2-4 Chuo-machi Toyooka City, Hyogo 668-8666      
666   Turismo de Tenerife 2019-11-26 SPAIN 6549 6549 2018-04-30 Myriad International Marketing, LLC          
683   Vist Finland 2020-06-18 FINLAND 6549 6549 2018-04-30 Myriad International Marketing, LLC          
2976 2019-02-28 China National Tourist Office 2018-04-30 CHINA 6549 6549 2018-04-30 Myriad International Marketing, LLC 370 Lexington Avenue #912   New York NY 10017
5819 2019-04-30 Kerala Tourism Board, represented by Start Communications 2019-05-22 INDIA 6549 6549 2018-04-30 Myriad International Marketing, LLC 9/566, E-2 jAWAHAR NAGAR KOWDIAR, TRIVANDRUM INDIA 695003      
6596 2020-05-29 Turismo de Portugal 2019-11-26 PORTUGAL 6549 6549 2018-04-30 Myriad International Marketing, LLC          
8388 2019-06-30 Melbourne Convention & Visitors Bureau 2018-04-30 AUSTRALIA 6549 6549 2018-04-30 Myriad International Marketing, LLC Collins Square Tower Two, Level 28, 727 Collins St Melbourne, Victoria 3008      
10713 2018-08-31 INTUR (Instituto Nicaraguense de Turismo) 2018-04-30 NICARAGUA 6549 6549 2018-04-30 Myriad International Marketing, LLC Crowne Plaza 1 c. al Sur 1 c. al Oeste, 9 Calle Suroeste Managua 5088      
12918 2017-10-31 Portuguese National Tourist Office 2018-06-01 PORTUGAL 6549 6549 2018-04-30 Myriad International Marketing, LLC 866 Second Avenue, 8th Floor   New York NY 10017
12921 2017-10-31 Tourism Fiji 2018-04-30 FIJI 6549 6549 2018-04-30 Myriad International Marketing, LLC 5777 Century Blvd, #220   Los Angeles CA 90045
16172 2017-12-31 Tourist Office of Spain 2018-06-01 SPAIN 6549 6549 2018-04-30 Myriad International Marketing, LLC 8383 Wilshire Blvd. Suite 960   Beverly Hills CA 90211

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 144.208ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history