List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

32 rows where Country/Location_Represented = "SPAIN" and State = "NY"

View and edit SQL

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

City

State

Country/Location_Represented

  • SPAIN · 32
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
661   Turespana Tourist Office of Spain 2020-12-16 SPAIN 6492 6492 2017-11-27 MMGY Global, LLC 60 East 42nd Street, Suite 5300   New York NY 10165
813 1987-01-01 Ministry of Transport, Tourism & Communications (Spain) 1985-05-23 SPAIN 3682 3682 1985-05-23 Lou Hammond & Associates, Inc. New York     NY  
940 2016-01-01 Extenda 2014-10-06 SPAIN 5758 5758 2006-05-09 Ketchum Inc. NY 817 Broadway Avenue, 2nd Floor   New York NY 10003
942 2016-01-01 ICEX Spain Trade and Investment 2014-10-06 SPAIN 5758 5758 2006-05-09 Ketchum Inc. NY 405 Lexington Avenue 44th Floor New York NY 10174
1520 1952-01-30 Spanish Confederated Societies of New York 1947-01-31 SPAIN 273 273 1944-07-31 Junta de Cultura Espanola       NY  
1575 1963-01-31 Iberia Airlines of Spain 1957-09-09 SPAIN 1064 1064 1957-09-09 James C. Seix Company, Inc. New York     NY  
1632 1989-01-31 Wines of Spain 1987-06-11 SPAIN 3778 3778 1986-02-13 Bozell, Jacobs, Kenyon & Eckhardt, Public Relations New York     NY  
3103 1977-03-01 Movimiento Nacional Progresista (L. Rhadames Trujillo-Martinez) 1977-07-08 SPAIN 2804 2804 1977-07-08 Martinez, Antonio C. New York     NY  
3175 2000-03-01 Tourist Office of Spain 1999-09-21 SPAIN 1381 1381 1960-07-29 Donald N. Martin & Company, Inc. 666 Fifth Avenue New York, NY 10103     NY  
3486 1974-03-12 J.M. Barturen 1964-02-25 SPAIN 1470 1470 1961-08-03 Brown, Charles H. New York     NY  
4365 1996-03-31 Autonomous Government of Catalonia, Department of Industry & Energy (CIDEM), Office of Foreign Investment 1995-02-14 SPAIN 4687 4687 1992-06-26 Smith McCabe, Ltd. New York     NY  
5057 1950-04-15 Spanish Tourist Office 1950-02-07 SPAIN 610 610 1950-02-07 Kelly-Kramer, Inc. New York     NY  
6023 1985-05-02 National Tourist Office of Spain 1984-05-01 SPAIN 2977 2977 1978-11-09 Taylor & Hammond, Ltd.       NY  
6630 1981-05-28 Government of Spain 1981-05-28 SPAIN 3245 3245 1981-05-28 Frankel, Marvin D. New York     NY  
7537 1982-06-15 Spanish National Tourist Office 1979-05-21 SPAIN 3025 3025 1979-05-21 Altman, Stoller & Weiss Advertising, Inc. New York     NY  
8846 1947-07-11 Jose Antonio de Aguiree (Only name listed as foreign principal/regarding the Basque Government) 1944-07-11 SPAIN 270 270 1944-07-11 De Aguirre, Jose Antonio New York     NY  
9148 1943-07-26 Spanish Library of Information 1942-07-09 SPAIN 29 29 1942-07-09 Carpenter, Charles M. New York     NY  
9364 1964-07-31 Spanish State Tourist Department 1950-03-24 SPAIN 71 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
9420 1988-07-31 National Tourist Office of Spain 1987-06-18 SPAIN 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
9746 1942-08-03 Spanish Library of Information 1942-08-03 SPAIN 80 80 1942-08-03 Larcegui, Francisco de S. New York     NY  
10574 1981-08-31 Iberia Air Lines of Spain 1970-05-18 SPAIN 1814 1814 1964-11-06 Association Films, Inc. New York     NY  
11078 1942-09-09 Spanish Library of Information 1942-09-09 SPAIN 115 115 1942-09-09 Mendez, Cristina New York     NY  
11079 1942-09-09 Spanish Library of Information 1942-09-09 SPAIN 116 116 1942-09-09 Mezquita, Teresa New York     NY  
11080 1942-09-09 Spanish Library of Information 1942-09-09 SPAIN 117 117 1942-09-09 Orta, Pilar New York     NY  
11081 1942-09-09 Spanish Library of Information 1942-09-09 SPAIN 118 118 1942-09-09 Mezquita, Manuel New York     NY  
11840 2015-09-30 Delegation of Catalonia to United States of America 2013-09-27 SPAIN 5860 5860 2008-04-03 Independent Diplomat, Inc. One Rockefeller Plaza, 26th Floor   New York NY 10020
12950 1999-10-31 Center for Information and Business Development (CIDEM) Generalitat of Catalonia 1996-10-24 SPAIN 2469 2469 1973-10-23 Burson-Marsteller New York     NY  
14043 2001-11-30 Spanish Embassy 2001-12-07 SPAIN 4777 4777 1993-03-12 Development Counsellors International 405 Lexington Avenue 44th Floor New York 10174     NY  
14646 1966-12-15 Miguel Garcia de Saez, Commissioner General for Spain, New York World's Fair 1964-06-04 SPAIN 1751 1751 1964-06-04 Camche, Joel T. New York     NY  
15321 1978-12-31 Spanish National Tourist Office 1976-08-05 SPAIN 2714 2714 1976-08-05 Dentsu Corporation of America New York     NY  
15486 1986-12-31 National Tourist Office of Spain 1984-03-01 SPAIN 3043 3043 1979-07-23 Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. New York     NY  
16150 2008-12-31 Instituto Espanol De Comercio Exterior 2005-02-01 SPAIN 5667 5667 2005-02-01 G2 Worldwide, Inc. 405 Lexington Avenue 44th Floor New York     NY  

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])
);