FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Foreign_Principal_Termination_Date = "" and Registration_Number = 6549 sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Address_1, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 20
- Association for the Promotion of the Autonomous Region of Madeira 1
- British Virgin Islands Tourist Board 1
- Business Finland 1
- Destination British Columbia 1
- Embassy of the Republic of Rwanda in Washington, D.C-USA 1
- German National Tourist Office 1
- INPROTUR, Instituto Nacional de Promocion Turistica of Argentina- via Interamerican Network 1
- Italian National Tourist Board 1
- Japan National Tourist Organization 1
- Kyoto Convention & Visitors Bureau 1
- Papua New Guinea Tourism Promotion Authority 1
- Samoa Tourism Authority 1
- Shizuoka Prefectural Tourism Association 1
- South Tyrol 1
- Stark Communications (on behalf of Kerala Tourism) 1
- Taiwan Tourism Bureau 1
- Tourism Northern Territory 1
- Tourism and Events Queensland 1
- Toyooka City Hall Tourism Division 1
- Visit Buenos Aires 1
Country/Location_Represented 14
City 3
- - 18
- Monterideo Urugual 1
- New York 1
Registrant_Name 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
52 | 52 | Association for the Promotion of the Autonomous Region of Madeira | 2021-11-29 | PORTUGAL | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
85 | 85 | British Virgin Islands Tourist Board | 2018-04-30 | BRITISH VIRGIN ISLANDS | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | Decastro Street 2nd Floor, Akara Building | Road Town, Tortola, BVI | ||||
88 | 88 | Business Finland | 2021-11-29 | FINLAND | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
144 | 144 | Destination British Columbia | 2023-05-30 | CANADA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
212 | 212 | Embassy of the Republic of Rwanda in Washington, D.C-USA | 2018-12-18 | RWANDA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
262 | 262 | German National Tourist Office | 2018-04-30 | GERMANY | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 122 East 42nd Street, Suite 2000 | New York | NY | 10168 | ||
340 | 340 | INPROTUR, Instituto Nacional de Promocion Turistica of Argentina- via Interamerican Network | 2021-05-28 | ARGENTINA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | Calle Cerrito 415 Piso 02 Plaza | Independencia Suite 506 | Monterideo Urugual | |||
363 | 363 | Italian National Tourist Board | 2022-12-13 | ITALY | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
376 | 376 | Japan National Tourist Organization | 2021-11-29 | JAPAN | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
420 | 420 | Kyoto Convention & Visitors Bureau | 2018-04-30 | JAPAN | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | Karasuma Ebisugawa Nakagyo-ku | Kyoto 604-0862 | ||||
553 | 553 | Papua New Guinea Tourism Promotion Authority | 2018-04-30 | PAPUA NEW GUINEA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | Pacific MMI Building Level 5 | Port Moresby | ||||
621 | 621 | Samoa Tourism Authority | 2018-04-30 | SAMOA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | Main Beach Road | Apia | ||||
632 | 632 | Shizuoka Prefectural Tourism Association | 2019-05-22 | JAPAN | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 2F Mizunomori Bldg., 14-1 Minami-cho, Suraga-ku, Shizuoka 422-8067 | |||||
643 | 643 | South Tyrol | 2018-06-01 | ITALY | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | Pfarrplatz 11 - Piazza della, Parrocchia, 11 | 39100 Bozen-Bolzano | ||||
651 | 651 | Stark Communications (on behalf of Kerala Tourism) | 2023-05-30 | INDIA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
674 | 674 | Taiwan Tourism Bureau | 2018-04-30 | TAIWAN | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 39F, No. 290, Sec. 4 | Zhongxiao E. Rd Taipei City 10694 | ||||
715 | 715 | Tourism Northern Territory | 2018-04-30 | AUSTRALIA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | Level 1, Alice Plaza | Alice Springs, Northern Territory, 0870 | ||||
716 | 716 | Tourism and Events Queensland | 2022-06-15 | AUSTRALIA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
718 | 718 | Toyooka City Hall Tourism Division | 2018-06-01 | JAPAN | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 2-4 Chuo-machi | Toyooka City, Hyogo 668-8666 | ||||
750 | 750 | Visit Buenos Aires | 2022-12-13 | ARGENTINA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC |
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]) );