FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Address_1 = "" and Country/Location_Represented = "SPAIN"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 20
- Asociacion Monarquica Espanola 1
- Catalan National Assembly in the United States of America Association 1
- Centro de Cultura por Correspondencia (CCC) 1
- Compania Naviera Vascongada 1
- Generalitat of Catalonia 1
- Government of Catalonia 1
- Hotel Los Monteros 1
- Iberia Airlines 1
- Investment Promotion Agency of Spain - INTERES 1
- Ministerio de Informacion y Turismo (Spanish Government) 1
- Muebles Darro (Furniture Company) 1
- National Tourist Office of Spain 1
- Nicolas Franco 1
- Oversea Solution, Ltd. on behalf of the Embassy of Spain 1
- Spanish Confederated Societies of New York 1
- Spanish Ministry of Commerce 1
- Spanish National Tourist Office 1
- Spanish Republican Government 1
- Spanish Trade Commission 1
- Turismo de Tenerife 1
Registrant_Name 16
- Leiser, Henri 5
- Abernathy MacGregor Group, Inc. 1
- Burson-Marsteller 1
- Camara Oficial Espanola de Comercio 1
- De Agustin, Don Manuel 1
- Development Counsellors International 1
- Don Braman & Associates, Inc. 1
- Garcia & Diaz 1
- Junta de Cultura Espanola 1
- Meana, Juan A. 1
- Miquel Fernandez Barros 1
- Modern Education Services, Inc. 1
- Myriad International Marketing, LLC 1
- Ruder Finn, Inc. 1
- TKC International, Inc. 1
- Taylor & Hammond, Ltd. 1
Registrant_Date (date) 16 ✖
- 1964-09-01 5
- 1942-07-08 1
- 1942-07-15 1
- 1944-07-31 1
- 1945-12-27 1
- 1961-09-27 1
- 1964-10-19 1
- 1972-12-27 1
- 1973-10-23 1
- 1975-08-07 1
- 1978-11-09 1
- 1979-12-13 1
- 1993-03-12 1
- 2018-04-30 1
- 2019-03-13 1
- 2022-11-29 1
Country/Location_Represented 1
- SPAIN · 20 ✖
City 1
- - 20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102 | 102 | Catalan National Assembly in the United States of America Association | 2022-11-29 | SPAIN | Miquel Fernandez Barros 7197 | 2022-11-29 | Miquel Fernandez Barros | ||||||
792 | 792 | 1964-01-01 | Centro de Cultura por Correspondencia (CCC) | 1964-09-01 | SPAIN | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | |||||
794 | 794 | 1964-01-01 | Hotel Los Monteros | 1964-09-01 | SPAIN | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | |||||
795 | 795 | 1964-01-01 | Iberia Airlines | 1964-09-01 | SPAIN | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | |||||
796 | 796 | 1964-01-01 | Ministerio de Informacion y Turismo (Spanish Government) | 1964-09-01 | SPAIN | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | |||||
797 | 797 | 1964-01-01 | Muebles Darro (Furniture Company) | 1964-09-01 | SPAIN | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | |||||
1141 | 1141 | 1946-01-08 | Compania Naviera Vascongada | 1944-08-04 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | |||||
1624 | 1624 | 1952-01-30 | Spanish Confederated Societies of New York | 1947-01-31 | SPAIN | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | NY | ||||
2368 | 2368 | 1946-02-11 | Asociacion Monarquica Espanola | 1942-07-15 | SPAIN | De Agustin, Don Manuel 47 | 1942-07-15 | De Agustin, Don Manuel | |||||
3954 | 3954 | 2019-03-21 | Oversea Solution, Ltd. on behalf of the Embassy of Spain | 2019-03-13 | SPAIN | Abernathy MacGregor Group, Inc. 6647 | 2019-03-13 | Abernathy MacGregor Group, Inc. | |||||
4174 | 4174 | 1989-03-30 | Spanish Trade Commission | 1987-03-27 | SPAIN | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
4955 | 4955 | 2010-04-01 | Investment Promotion Agency of Spain - INTERES | 2006-11-02 | SPAIN | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | |||||
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 | ||||
6558 | 6558 | 1986-05-15 | Government of Catalonia | 1986-04-25 | SPAIN | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | |||||
8118 | 8118 | 1949-06-27 | Spanish Republican Government | 1945-12-27 | SPAIN | Meana, Juan A. 334 | 1945-12-27 | Meana, Juan A. | |||||
11762 | 11762 | 1975-09-22 | Nicolas Franco | 1975-08-07 | SPAIN | Don Braman & Associates, Inc. 2600 | 1975-08-07 | Don Braman & Associates, Inc. | |||||
12063 | 12063 | 1995-09-30 | Generalitat of Catalonia | 1995-06-15 | SPAIN | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | |||||
14306 | 14306 | 1982-11-29 | Spanish National Tourist Office | 1982-04-07 | SPAIN | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
15415 | 15415 | 2002-12-27 | Spanish Ministry of Commerce | 1972-12-27 | SPAIN | Camara Oficial Espanola de Comercio 2400 | 1972-12-27 | Camara Oficial Espanola de Comercio | PR | ||||
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]) );