FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Address_1 = "" and Registration_Number = 6549 sorted by Country/Location_Represented
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Foreign_Principal_Termination_Date (date)
Foreign_Principal 15
- Association for the Promotion of the Autonomous Region of Madeira 1
- Business Finland 1
- Destination British Columbia 1
- Embassy of the Republic of Rwanda in Washington, D.C-USA 1
- Italian National Tourist Board 1
- Japan National Tourist Organization 1
- Philippine Department of Tourism 1
- Stark Communications (on behalf of Kerala Tourism) 1
- Stark Communications on behalf of Karnataka Tourism 1
- Tourism and Events Queensland 1
- Turismo de Portugal 1
- Turismo de Tenerife 1
- Visit Buenos Aires 1
- Visit Victoria 1
- Vist Finland 1
Country/Location_Represented 11
State 1
- - 15
Registrant_Name 1
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
750 | 750 | Visit Buenos Aires | 2022-12-13 | ARGENTINA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
716 | 716 | Tourism and Events Queensland | 2022-06-15 | AUSTRALIA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
9926 | 9926 | 2018-07-31 | Visit Victoria | 2018-12-18 | AUSTRALIA | 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 | ||||||
88 | 88 | Business Finland | 2021-11-29 | FINLAND | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
7929 | 7929 | 2020-06-18 | Vist Finland | 2020-06-18 | FINLAND | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | |||||
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 | ||||||
7928 | 7928 | 2020-06-18 | Stark Communications on behalf of Karnataka Tourism | 2020-06-18 | INDIA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | |||||
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 | ||||||
16885 | 16885 | 2020-12-31 | Philippine Department of Tourism | 2018-12-18 | PHILIPPINES | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | |||||
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 | ||||||
6919 | 6919 | 2019-05-29 | Turismo de Portugal | 2019-11-26 | PORTUGAL | 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 | ||||||
16890 | 16890 | 2020-12-31 | Turismo de Tenerife | 2019-11-26 | SPAIN | 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]) );