FARA_All_ForeignPrincipals

Table actions
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

This data as json, CSV (advanced)

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 2

State 1

Country/Location_Represented 1

  • 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
724 724   Turespana Tourist Office of Spain 2020-12-16 SPAIN MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC 60 East 42nd Street, Suite 5300   New York NY 10165
896 896 1987-01-01 Ministry of Transport, Tourism & Communications (Spain) 1985-05-23 SPAIN Lou Hammond & Associates, Inc. 3682 1985-05-23 Lou Hammond & Associates, Inc. New York     NY  
1023 1023 2016-01-01 Extenda 2014-10-06 SPAIN Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 817 Broadway Avenue, 2nd Floor   New York NY 10003
1025 1025 2016-01-01 ICEX Spain Trade and Investment 2014-10-06 SPAIN Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 405 Lexington Avenue 44th Floor New York NY 10174
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  
1679 1679 1963-01-31 Iberia Airlines of Spain 1957-09-09 SPAIN James C. Seix Company, Inc. 1064 1957-09-09 James C. Seix Company, Inc. New York     NY  
1736 1736 1989-01-31 Wines of Spain 1987-06-11 SPAIN Bozell, Jacobs, Kenyon & Eckhardt, Public Relations 3778 1986-02-13 Bozell, Jacobs, Kenyon & Eckhardt, Public Relations New York     NY  
3253 3253 1977-03-01 Movimiento Nacional Progresista (L. Rhadames Trujillo-Martinez) 1977-07-08 SPAIN Martinez, Antonio C. 2804 1977-07-08 Martinez, Antonio C. New York     NY  
3325 3325 2000-03-01 Tourist Office of Spain 1999-09-21 SPAIN Donald N. Martin & Company, Inc. 1381 1960-07-29 Donald N. Martin & Company, Inc. 666 Fifth Avenue New York, NY 10103     NY  
3654 3654 1974-03-12 J.M. Barturen 1964-02-25 SPAIN Brown, Charles H. 1470 1961-08-03 Brown, Charles H. New York     NY  
4547 4547 1996-03-31 Autonomous Government of Catalonia, Department of Industry & Energy (CIDEM), Office of Foreign Investment 1995-02-14 SPAIN Smith McCabe, Ltd. 4687 1992-06-26 Smith McCabe, Ltd. New York     NY  
5269 5269 1950-04-15 Spanish Tourist Office 1950-02-07 SPAIN Kelly-Kramer, Inc. 610 1950-02-07 Kelly-Kramer, Inc. New York     NY  
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  
6885 6885 1981-05-28 Government of Spain 1981-05-28 SPAIN Frankel, Marvin D. 3245 1981-05-28 Frankel, Marvin D. New York     NY  
7823 7823 1982-06-15 Spanish National Tourist Office 1979-05-21 SPAIN Altman, Stoller & Weiss Advertising, Inc. 3025 1979-05-21 Altman, Stoller & Weiss Advertising, Inc. New York     NY  
9166 9166 1947-07-11 Jose Antonio de Aguiree (Only name listed as foreign principal/regarding the Basque Government) 1944-07-11 SPAIN De Aguirre, Jose Antonio 270 1944-07-11 De Aguirre, Jose Antonio New York     NY  
9473 9473 1943-07-26 Spanish Library of Information 1942-07-09 SPAIN Carpenter, Charles M. 29 1942-07-09 Carpenter, Charles M. New York     NY  
9693 9693 1964-07-31 Spanish State Tourist Department 1950-03-24 SPAIN Kelly, Nason, Inc. 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
9749 9749 1988-07-31 National Tourist Office of Spain 1987-06-18 SPAIN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
10084 10084 1942-08-03 Spanish Library of Information 1942-08-03 SPAIN Larcegui, Francisco de S. 80 1942-08-03 Larcegui, Francisco de S. New York     NY  
10930 10930 1981-08-31 Iberia Air Lines of Spain 1970-05-18 SPAIN Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York     NY  
11446 11446 1942-09-09 Spanish Library of Information 1942-09-09 SPAIN Mendez, Cristina 115 1942-09-09 Mendez, Cristina New York     NY  
11447 11447 1942-09-09 Spanish Library of Information 1942-09-09 SPAIN Mezquita, Teresa 116 1942-09-09 Mezquita, Teresa New York     NY  
11448 11448 1942-09-09 Spanish Library of Information 1942-09-09 SPAIN Orta, Pilar 117 1942-09-09 Orta, Pilar New York     NY  
11449 11449 1942-09-09 Spanish Library of Information 1942-09-09 SPAIN Mezquita, Manuel 118 1942-09-09 Mezquita, Manuel New York     NY  
12226 12226 2015-09-30 Delegation of Catalonia to United States of America 2013-09-27 SPAIN Independent Diplomat, Inc. 5860 2008-04-03 Independent Diplomat, Inc. One Rockefeller Plaza, 26th Floor   New York NY 10020
13384 13384 1999-10-31 Center for Information and Business Development (CIDEM) Generalitat of Catalonia 1996-10-24 SPAIN Burson-Marsteller 2469 1973-10-23 Burson-Marsteller New York     NY  
14497 14497 2001-11-30 Spanish Embassy 2001-12-07 SPAIN Development Counsellors International 4777 1993-03-12 Development Counsellors International 405 Lexington Avenue 44th Floor New York 10174     NY  
15121 15121 1966-12-15 Miguel Garcia de Saez, Commissioner General for Spain, New York World's Fair 1964-06-04 SPAIN Camche, Joel T. 1751 1964-06-04 Camche, Joel T. New York     NY  
15810 15810 1978-12-31 Spanish National Tourist Office 1976-08-05 SPAIN Dentsu Corporation of America 2714 1976-08-05 Dentsu Corporation of America New York     NY  
15975 15975 1986-12-31 National Tourist Office of Spain 1984-03-01 SPAIN Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 3043 1979-07-23 Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. New York     NY  
16639 16639 2008-12-31 Instituto Espanol De Comercio Exterior 2005-02-01 SPAIN G2 Worldwide, Inc. 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])
);