FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
174 rows where Country/Location_Represented = "SPAIN" sorted by Registrant_Name
This data as json, CSV (advanced)
Foreign_Principal_Registration_Date (date) 17 ✖
- 1982-03-26 2
- 1948-09-14 1
- 1957-01-28 1
- 1965-08-11 1
- 1972-02-29 1
- 1972-06-05 1
- 1973-10-12 1
- 1977-10-27 1
- 1983-08-16 1
- 1984-05-01 1
- 1988-01-19 1
- 1988-03-21 1
- 1988-04-04 1
- 1989-05-08 1
- 1991-10-30 1
- 1995-06-15 1
- 2022-07-16 1
Foreign_Principal 17
- Ministry of Information & Tourism 2
- Amadeus Global Travel Distribution, S.A. 1
- Asociacion de Empresas RENFE/Patentes TALGO, S.A. 1
- Construcciones Aeronauticas, S.A. 1
- Embassy of Spain 1
- Franklin, S.A. 1
- Generalitat of Catalonia 1
- Gobierno Vasco, the Government of the Autonomous Basque Community of Spain 1
- His Excellency Senor D. Jose M. de Areilza, Conde de Motrico, Spanish Ambassador to the U.S. 1
- Melia Hotels International 1
- Menendez, Garcia y Cia., Ltd. 1
- Ministerio de Informacion y Turismo 1
- Ministry of Commerce & Tourism 1
- Ministry of Information & Tourism of Spain 1
- National Tourist Office of Spain 1
- Por Larranaga, Fabrica de Tabacos, S.A. 1
- Spanish State Tourist Department 1
Registrant_Name 14
- Spanish National Tourist Office, San Francisco 3
- Squire Patton Boggs, LLP 3
- Spanish National Tourist Office, New York 1
- Spanish National Tourist Office, Puerto Rico 1
- Spanish National Tourist Office, St. Augustine 1
- Stafford, Burke & Hecker, Inc. 1
- Susan Davis International & Public Affairs 1
- TKC International, Inc. 1
- Taylor & Hammond, Ltd. 1
- Tex McCrary, Inc. 1
- The Raben Group LLC 1
- Washington, Perito & Dubuc 1
- Wexler, Reynolds, Fuller, Harrison & Schule, Inc. 1
- Wilmer, Cutler & Pickering 1
Registrant_Date (date) 14 ✖
- 1965-08-11 3
- 1969-10-09 3
- 1948-09-14 1
- 1957-01-28 1
- 1972-02-29 1
- 1972-06-05 1
- 1978-11-09 1
- 1979-12-13 1
- 1981-11-20 1
- 1982-04-08 1
- 1983-02-16 1
- 1983-08-16 1
- 1988-03-21 1
- 2022-07-16 1
City 2
- - 17
- Palma de Mallorca 1
Country/Location_Represented 1
- SPAIN · 18 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15476 | 15476 | 1980-12-30 | Spanish State Tourist Department | 1948-09-14 | SPAIN | Spanish National Tourist Office, New York 538 | 1948-09-14 | Spanish National Tourist Office, New York | Madrid | ||||
14767 | 14767 | 1981-12-03 | Ministry of Information & Tourism | 1972-06-05 | SPAIN | Spanish National Tourist Office, Puerto Rico 2344 | 1972-06-05 | Spanish National Tourist Office, Puerto Rico | Madrid | ||||
15471 | 15471 | 1980-12-30 | Ministerio de Informacion y Turismo | 1965-08-11 | SPAIN | Spanish National Tourist Office, San Francisco 1914 | 1965-08-11 | Spanish National Tourist Office, San Francisco | Madrid | ||||
15472 | 15472 | 1980-12-30 | Ministry of Commerce & Tourism | 1977-10-27 | SPAIN | Spanish National Tourist Office, San Francisco 1914 | 1965-08-11 | Spanish National Tourist Office, San Francisco | Madrid | ||||
15474 | 15474 | 1980-12-30 | Ministry of Information & Tourism | 1973-10-12 | SPAIN | Spanish National Tourist Office, San Francisco 1914 | 1965-08-11 | Spanish National Tourist Office, San Francisco | Madrid | ||||
10604 | 10604 | 1993-08-18 | Ministry of Information & Tourism of Spain | 1972-02-29 | SPAIN | Spanish National Tourist Office, St. Augustine 2322 | 1972-02-29 | Spanish National Tourist Office, St. Augustine | Madrid | ||||
6825 | 6825 | 1989-05-25 | Menendez, Garcia y Cia., Ltd. | 1982-03-26 | SPAIN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Madrid | ||||
6826 | 6826 | 1989-05-25 | Por Larranaga, Fabrica de Tabacos, S.A. | 1982-03-26 | SPAIN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Madrid | ||||
10983 | 10983 | 1988-08-31 | Embassy of Spain | 1988-01-19 | SPAIN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Washington | DC | |||
3815 | 3815 | 1984-03-16 | Construcciones Aeronauticas, S.A. | 1983-08-16 | SPAIN | Stafford, Burke & Hecker, Inc. 3510 | 1983-08-16 | Stafford, Burke & Hecker, Inc. | Madrid | ||||
5854 | 5854 | 1990-04-30 | Franklin, S.A. | 1991-10-30 | SPAIN | Susan Davis International & Public Affairs 3444 | 1983-02-16 | Susan Davis International & Public Affairs | Madrid | ||||
12063 | 12063 | 1995-09-30 | Generalitat of Catalonia | 1995-06-15 | SPAIN | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | |||||
6261 | 6261 | 1985-05-02 | National Tourist Office of Spain | 1984-05-01 | SPAIN | Taylor & Hammond, Ltd. 2977 | 1978-11-09 | Taylor & Hammond, Ltd. | NY | ||||
15574 | 15574 | 1957-12-31 | His Excellency Senor D. Jose M. de Areilza, Conde de Motrico, Spanish Ambassador to the U.S. | 1957-01-28 | SPAIN | Tex McCrary, Inc. 995 | 1957-01-28 | Tex McCrary, Inc. | Washington | DC | |||
454 | 454 | Melia Hotels International | 2022-07-16 | SPAIN | The Raben Group LLC 7140 | 2022-07-16 | The Raben Group LLC | Calle Gremi de Boters, 2 | Palma de Mallorca | ||||
3931 | 3931 | 1991-03-21 | Asociacion de Empresas RENFE/Patentes TALGO, S.A. | 1988-03-21 | SPAIN | Washington, Perito & Dubuc 4107 | 1988-03-21 | Washington, Perito & Dubuc | Madrid | ||||
10010 | 10010 | 1990-08-01 | Gobierno Vasco, the Government of the Autonomous Basque Community of Spain | 1988-04-04 | SPAIN | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. 3306 | 1981-11-20 | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. | Alava | ||||
13826 | 13826 | 1989-11-08 | Amadeus Global Travel Distribution, S.A. | 1989-05-08 | SPAIN | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Madrid |
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]) );