List of all foreign principals (active and terminated)

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

170 rows where Country/Location_Represented = "SPAIN"

View and edit SQL

State

Country/Location_Represented

  • SPAIN · 75
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
9685 1991-08-01 Montecinca, S.A. 1990-12-04 SPAIN 4444 4444 1990-12-05 Friedersdorf, Max L. Barcelona        
9691 1996-08-01 American Basque Foundation 1994-10-05 SPAIN 4947 4947 1994-09-19 McClure, Gerard & Neuenschwander, Inc. Boise     ID  
9692 1996-08-01 Autonomous Community of the Basque Country 1994-09-19 SPAIN 4947 4947 1994-09-19 McClure, Gerard & Neuenschwander, Inc. Victoria-Gasteiz        
9708 2006-08-01 Government of Spain, Embassy 2004-01-28 SPAIN 3712 3712 1985-08-05 DLA Piper US LLP 2375 Pennsylvania Avenue, N.W. 20037     DC  
9746 1942-08-03 Spanish Library of Information 1942-08-03 SPAIN 80 80 1942-08-03 Larcegui, Francisco de S. New York     NY  
9923 1964-08-11 Division of Cultural Affairs of the Spanish Embassy 1949-02-11 SPAIN 562 562 1949-02-11 Clark, Charles Patrick Washington     DC  
9924 1964-08-11 Government of Spain 1955-10-12 SPAIN 562 562 1949-02-11 Clark, Charles Patrick Madrid        
10259 1993-08-18 Ministry of Information & Tourism of Spain 1972-02-29 SPAIN 2322 2322 1972-02-29 Spanish National Tourist Office, St. Augustine Madrid        
10270 1993-08-19 Galicia Province, Spain 1993-02-24 SPAIN 4770 4770 1993-02-24 Brown, Earle Palmer Madrid        
10377 1978-08-25 Ministerio De Commercio Y Turismo 1977-11-17 SPAIN 2321 2321 1972-02-29 Spanish National Tourist Office, Miami Madrid        
10378 1978-08-25 Ministry of Information & Tourism of Spain 1972-02-29 SPAIN 2321 2321 1972-02-29 Spanish National Tourist Office, Miami Madrid        
10574 1981-08-31 Iberia Air Lines of Spain 1970-05-18 SPAIN 1814 1814 1964-11-06 Association Films, Inc. New York     NY  
10602 1981-08-31 Spanish National Tourist Office 1967-10-03 SPAIN 1814 1814 1964-11-06 Association Films, Inc. San Francisco     CA  
10627 1988-08-31 Embassy of Spain 1988-01-19 SPAIN 2165 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
11029 1985-09-06 Spain 1982-08-04 SPAIN 3312 3312 1981-12-01 McGrath, Lee Kimche Madrid        
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  
11210 1984-09-14 Excellency Gabriel Manueco - Embassy of Spain 1983-06-15 SPAIN 3481 3481 1983-06-15 Haley, Kiss & Dowd, Inc. Washington     DC  
11332 1960-09-19 Juan & Pedro Pujol (Newspaper Madrid")" 1948-04-08 SPAIN 425 425 1947-01-10 Casares Sanchez, Manuel Madrid        
11387 1975-09-22 Nicolas Franco 1975-08-07 SPAIN 2600 2600 1975-08-07 Don Braman & Associates, Inc.          
11434 1952-09-25 Spanish State Tourist Office 1951-09-24 SPAIN 684 684 1951-09-24 Calvosa, Ulrich Madrid        
11453 1985-09-26 Government of Spain 1977-05-27 SPAIN 2319 2319 1972-02-18 Doremus & Company Madrid        
11456 1985-09-26 Intemsa 1977-05-13 SPAIN 2319 2319 1972-02-18 Doremus & Company Madrid        
11678 1995-09-30 Generalitat of Catalonia 1995-06-15 SPAIN 3075 3075 1979-12-13 TKC International, Inc.          
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
11882 1950-10-01 Embassy of Spain 1950-06-05 SPAIN 626 626 1950-06-05 Banda, Francisco C. Washington     DC  
11891 1960-10-01 Government of the Republic of Spain (In Exile) 1955-04-01 SPAIN 884 884 1955-04-01 Asensio, General Jose' Paris        
12210 1989-10-12 Banco de Santander, S.A.D.C. 1988-10-12 SPAIN 3794 3794 1986-03-12 Morgan, Lewis & Bockius, L.L.P. Santander        
12222 1989-10-13 CASA Aircraft U.S.A., Inc. 1988-03-17 SPAIN 4106 4106 1988-03-17 Bronheim, David Chantilly     VA  
12252 1993-10-14 CIDEM (Center for Information & Business Development, Autonomous Region of Catalonia, Spain) 1991-07-15 SPAIN 2850 2850 1977-11-29 Hannaford Company, Inc. San Francisco     CA  
12273 1970-10-15 Aceitunas de Mesa, S.A. 1970-06-25 SPAIN 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP Seville        
12560 1945-10-25 Henri Kirschen 1945-02-16 SPAIN 290 290 1945-02-16 Law Office of George E. Tolman Madrid        
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  
13088 1960-11-01 Government of Spain 1949-02-08 SPAIN 420 420 1947-01-09 Cummings, Sellers, Reeves & Conner Washington     DC  
13379 1989-11-08 Amadeus Global Travel Distribution, S.A. 1989-05-08 SPAIN 3355 3355 1982-04-08 Wilmer, Cutler & Pickering Madrid        
13392 1950-11-09 Lucio del Alamo Urrutia (Pyresa)(Prensa y Radio Espanola Sociedad Anonima-Madrid) 1949-05-09 SPAIN 569 569 1949-05-09 Garza, Lorenzo (Melon) Madrid        
13496 1990-11-14 Sociedad Para la Promocion y Reconversion Industrial, S.A. 1990-05-24 SPAIN 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Gran Via        
13500 2019-11-14 Embassy of Spain 2019-10-11 SPAIN 5666 5666 2005-01-31 FGH Holdings 2375 Pennsylvania Avenue, NW   Washington DC 20037
13552 2018-11-15 Government of Catalonia 2017-08-28 SPAIN 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1050 K Street, NW Suite 325 Washington DC 20001
13850 1979-11-29 Aceitunas de Mesa, S.A. (ACEMESA) 1970-12-21 SPAIN 2229 2229 1970-12-21 Egge, George V., Jr. Seville        
13851 1979-11-29 Union de Empresas y Entidades Siderurgicas (UNESID) (Spanish Steel Industries Association) 1978-04-28 SPAIN 2229 2229 1970-12-21 Egge, George V., Jr. Madrid        
13852 1982-11-29 Spanish National Tourist Office 1982-04-07 SPAIN 1803 1803 1964-10-19 Modern Education Services, Inc.          
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  
14145 1955-12-01 Agencia Efe, S.A. 1948-04-08 SPAIN 425 425 1947-01-10 Casares Sanchez, Manuel Madrid        
14146 1955-12-01 Commercial Office of the Embassy of Spain in the U.S. 1955-01-13 SPAIN 866 866 1955-01-13 McDonnell & Slattery Washington     DC  
14297 1981-12-03 Ministry of Information & Tourism 1972-06-05 SPAIN 2344 2344 1972-06-05 Spanish National Tourist Office, Puerto Rico Madrid        
14487 1993-12-10 Department of Environment the Government of Catalonia, Spain 1992-05-07 SPAIN 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Barcelona        
14644 1951-12-15 Government of the Republic of Spain (In Exile) 1949-12-15 SPAIN 602 602 1949-12-15 Asensio, General Jose' Paris        
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  
14694 1985-12-16 Asociacion Nacional de Armadores de Buques Congeladores 1982-07-21 SPAIN 2799 2799 1977-06-29 Finley Kumble Wagner Heine Underberg Manley Myerson & Casey Vigo        
14932 2002-12-27 Spanish Ministry of Commerce 1972-12-27 SPAIN 2400 2400 1972-12-27 Camara Oficial Espanola de Comercio       PR  
14969 1946-12-30 Agencia Efe, S.A. 1943-12-30 SPAIN 166 166 1943-12-30 Lucientes, Francisco J. Madrid        
14982 1980-12-30 Ministerio de Informacion y Turismo 1965-08-11 SPAIN 1914 1914 1965-08-11 Spanish National Tourist Office, San Francisco Madrid        
14983 1980-12-30 Ministry of Commerce & Tourism 1977-10-27 SPAIN 1914 1914 1965-08-11 Spanish National Tourist Office, San Francisco Madrid        
14984 1980-12-30 Ministry of Commerce & Tourism 1977-11-22 SPAIN 1830 1830 1964-12-11 Spanish National Tourist Office, Chicago Madrid        
14985 1980-12-30 Ministry of Information & Tourism 1973-10-12 SPAIN 1914 1914 1965-08-11 Spanish National Tourist Office, San Francisco Madrid        
14986 1980-12-30 Ministry of Information & Tourism 1973-11-26 SPAIN 538 538 1948-09-14 Spanish National Tourist Office, New York Madrid        
14987 1980-12-30 Spanish State Tourist Department 1948-09-14 SPAIN 538 538 1948-09-14 Spanish National Tourist Office, New York Madrid        
15028 1944-12-31 Alfonso El Alcazar, XI 1943-01-01 SPAIN 168 168 1943-01-01 Aladren, Jose M. Madrid        
15029 1945-12-31 Agencia Logos (Logos News Agency) 1945-02-26 SPAIN 293 293 1945-02-26 Aladren del Perojo, Jose Maria Madrid        
15085 1957-12-31 His Excellency Senor D. Jose M. de Areilza, Conde de Motrico, Spanish Ambassador to the U.S. 1957-01-28 SPAIN 995 995 1957-01-28 Tex McCrary, Inc. Washington     DC  
15153 1965-12-31 Ministry of Information & Tourism, Government of Spain 1965-05-27 SPAIN 1896 1896 1965-05-27 Conant & Company Public Relations, Inc. Madrid        
15183 1969-12-31 Spain Government 1964-07-10 SPAIN 1743 1743 1964-05-28 Pendleton & McLaughlin Madrid        
15250 1975-12-31 Ministry of Tourism & Information (General Direction of Tourist Planning) (Spanish National Tourist Office) 1974-10-01 SPAIN 2536 2536 1974-10-01 Robert L. Bliss, Inc. Madrid        
15300 1977-12-31 Government of Spain, Foreign Ministry 1977-02-04 SPAIN 1481 1481 1961-09-27 Ruder Finn, Inc. Madrid        
15315 1978-12-31 Hispanica de Petroleos, S.A. 1971-08-13 SPAIN 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy Madrid        
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  
15505 1987-12-31 Asociacion de Empresas RENFE/Patentes TALGO, S.A. 1987-05-21 SPAIN 2799 2799 1977-06-29 Finley Kumble Wagner Heine Underberg Manley Myerson & Casey Madrid        
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  
16316 2017-12-31 Government of Catalonia 2014-05-07 SPAIN 6220 6220 2014-05-07 Delegation of Catalonia to the United States of America Placa Sant Jaume, 4 08002 Barcelona Catalunya      
16329 2017-12-31 Tourist Office of Spain 2018-06-01 SPAIN 6549 6549 2018-04-30 Myriad International Marketing, LLC 8383 Wilshire Blvd. Suite 960   Beverly Hills CA 90211
16392 2020-12-31 Turismo de Tenerife 2019-11-26 SPAIN 6549 6549 2018-04-30 Myriad International Marketing, LLC          

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